Modified commercial management

Submitted by: 
Visitors have accessed this post 8485 times.

added some detail in this code, you can generate report and print invoice printer atm generate bar code. You can also use bar code reader is ready to be used and improved.
User data are encoded
user can select different themes user Jornesio password 12345

this is an amended version posted here by jaysfall

Portuguese language spoken

acrescentou alguns detalhes neste código, você pode gerar o relatório e impressão da fatura de impressora de código de barras atm generate. Também é possível usar o leitor de código de barras está pronto para ser utilizado e melhorado.
Os dados do usuário são codificados
usuário pode selecionar diferentes temas senha Jornesio 12345

esta é uma versão alterada postado aqui por jaysfall


Tags: 

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Thank you so much!
I love the resource you sharing here.
But I have a question.
Is any barcode scanner OK? How about this .NET bar code scanner?

meu querido poderia colocar um banco access neste sistema

please re-upload the database backup. Pos.ldf file missing leaves no database created by high in that file

Create starting the above code because it depends on the version of sql server is right the version to use this?

i use sql server 2012 no compatible version
no is compatible to version previous
contact me any question

This sent the email as requested, the version of sql used by me is Sql server 2012. most also includes the query checks to your email

do you have a pos.ldf file for this system? because i cannot attach your database to sql server because he will be looking for pos.ldf file. can you send it to me? heres my e-add [email protected].

  1. USE [master]
  2. GO
  3.  
  4. /****** Object: Database [Pos] Script Date: 16-04-2013 14:51:20 ******/
  5. CREATE DATABASE [Pos]
  6. CONTAINMENT = NONE
  7. ON PRIMARY
  8. ( NAME = N'Pos', FILENAME = N'd:\Pos.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  9. LOG ON
  10. ( NAME = N'Pos_log', FILENAME = N'd:\Pos_log.ldf' , SIZE = 504KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
  11. GO
  12.  
  13. ALTER DATABASE [Pos] SET COMPATIBILITY_LEVEL = 110
  14. GO
  15.  
  16. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  17. BEGIN
  18. EXEC [Pos].[dbo].[sp_fulltext_database] @action = 'enable'
  19. END
  20. GO
  21.  
  22. ALTER DATABASE [Pos] SET ANSI_NULL_DEFAULT OFF
  23. GO
  24.  
  25. ALTER DATABASE [Pos] SET ANSI_NULLS OFF
  26. GO
  27.  
  28. ALTER DATABASE [Pos] SET ANSI_PADDING OFF
  29. GO
  30.  
  31. ALTER DATABASE [Pos] SET ANSI_WARNINGS OFF
  32. GO
  33.  
  34. ALTER DATABASE [Pos] SET ARITHABORT OFF
  35. GO
  36.  
  37. ALTER DATABASE [Pos] SET AUTO_CLOSE OFF
  38. GO
  39.  
  40. ALTER DATABASE [Pos] SET AUTO_CREATE_STATISTICS ON
  41. GO
  42.  
  43. ALTER DATABASE [Pos] SET AUTO_SHRINK OFF
  44. GO
  45.  
  46. ALTER DATABASE [Pos] SET AUTO_UPDATE_STATISTICS ON
  47. GO
  48.  
  49. ALTER DATABASE [Pos] SET CURSOR_CLOSE_ON_COMMIT OFF
  50. GO
  51.  
  52. ALTER DATABASE [Pos] SET CURSOR_DEFAULT GLOBAL
  53. GO
  54.  
  55. ALTER DATABASE [Pos] SET CONCAT_NULL_YIELDS_NULL OFF
  56. GO
  57.  
  58. ALTER DATABASE [Pos] SET NUMERIC_ROUNDABORT OFF
  59. GO
  60.  
  61. ALTER DATABASE [Pos] SET QUOTED_IDENTIFIER OFF
  62. GO
  63.  
  64. ALTER DATABASE [Pos] SET RECURSIVE_TRIGGERS OFF
  65. GO
  66.  
  67. ALTER DATABASE [Pos] SET DISABLE_BROKER
  68. GO
  69.  
  70. ALTER DATABASE [Pos] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  71. GO
  72.  
  73. ALTER DATABASE [Pos] SET DATE_CORRELATION_OPTIMIZATION OFF
  74. GO
  75.  
  76. ALTER DATABASE [Pos] SET TRUSTWORTHY OFF
  77. GO
  78.  
  79. ALTER DATABASE [Pos] SET ALLOW_SNAPSHOT_ISOLATION OFF
  80. GO
  81.  
  82. ALTER DATABASE [Pos] SET PARAMETERIZATION SIMPLE
  83. GO
  84.  
  85. ALTER DATABASE [Pos] SET READ_COMMITTED_SNAPSHOT OFF
  86. GO
  87.  
  88. ALTER DATABASE [Pos] SET HONOR_BROKER_PRIORITY OFF
  89. GO
  90.  
  91. ALTER DATABASE [Pos] SET RECOVERY SIMPLE
  92. GO
  93.  
  94. ALTER DATABASE [Pos] SET MULTI_USER
  95. GO
  96.  
  97. ALTER DATABASE [Pos] SET PAGE_VERIFY CHECKSUM
  98. GO
  99.  
  100. ALTER DATABASE [Pos] SET DB_CHAINING OFF
  101. GO
  102.  
  103. ALTER DATABASE [Pos] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
  104. GO
  105.  
  106. ALTER DATABASE [Pos] SET TARGET_RECOVERY_TIME = 0 SECONDS
  107. GO
  108.  
  109. ALTER DATABASE [Pos] SET READ_WRITE
  110. GO
  111.  
  112.  
  113. USE [Pos]
  114. GO
  115.  
  116. /****** Object: Table [dbo].[usuario] Script Date: 16-04-2013 14:51:13 ******/
  117. SET ANSI_NULLS ON
  118. GO
  119.  
  120. SET QUOTED_IDENTIFIER ON
  121. GO
  122.  
  123. CREATE TABLE [dbo].[usuario](
  124. [DATA] [nvarchar](50) NULL,
  125. [Nome] [nvarchar](50) NULL,
  126. [Datanasc] [nvarchar](50) NULL,
  127. [Passaport] [nvarchar](50) NULL,
  128. [filiacao] [nvarchar](50) NULL,
  129. [reparticao] [nvarchar](50) NULL,
  130. [nivel] [nvarchar](50) NULL,
  131. [DTB] [nvarchar](50) NULL,
  132. [Estado] [nvarchar](50) NULL,
  133. [Acesso] [nvarchar](50) NULL
  134. ) ON [PRIMARY]
  135.  
  136. GO
  137.  
  138.  
  139. USE [Pos]
  140. GO
  141.  
  142. /****** Object: Table [dbo].[Table_1] Script Date: 16-04-2013 14:51:09 ******/
  143. SET ANSI_NULLS ON
  144. GO
  145.  
  146. SET QUOTED_IDENTIFIER ON
  147. GO
  148.  
  149. CREATE TABLE [dbo].[Table_1](
  150. [hh] [DECIMAL](18, 0) NULL
  151. ) ON [PRIMARY]
  152.  
  153. GO
  154.  
  155.  
  156. USE [Pos]
  157. GO
  158.  
  159. /****** Object: Table [dbo].[Product_x] Script Date: 16-04-2013 14:51:05 ******/
  160. SET ANSI_NULLS ON
  161. GO
  162.  
  163. SET QUOTED_IDENTIFIER ON
  164. GO
  165.  
  166. CREATE TABLE [dbo].[Product_x](
  167. [Product_No] [nvarchar](50) NULL,
  168. [Product_Shortcode] [nvarchar](50) NULL,
  169. [Product_name] [nvarchar](50) NULL,
  170. [Unit] [nvarchar](MAX) NULL,
  171. [Barcode] [nvarchar](MAX) NULL,
  172. [Categoryname] [nvarchar](50) NULL,
  173. [Unit_Price] [money] NULL,
  174. [Price] [money] NULL,
  175. [Mincriticalstocklevel] [INT] NULL,
  176. [Createdby] [nvarchar](MAX) NULL,
  177. [Datecreated] [nvarchar](50) NULL,
  178. [Brand_name] [nvarchar](50) NULL,
  179. [Stock] [INT] NULL,
  180. [Impost] [NCHAR](10) NULL,
  181. [Stockcritico] [INT] NULL,
  182. [custo] [money] NULL,
  183. [USUARIO] [nvarchar](MAX) NULL,
  184. [data2] [INT] NULL,
  185. [data3] [INT] NULL,
  186. [temp] [nvarchar](50) NULL,
  187. [doc] [INT] NULL
  188. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  189.  
  190. GO
  191.  
  192.  
  193. USE [Pos]
  194. GO
  195.  
  196. /****** Object: Table [dbo].[Product] Script Date: 16-04-2013 14:51:00 ******/
  197. SET ANSI_NULLS ON
  198. GO
  199.  
  200. SET QUOTED_IDENTIFIER ON
  201. GO
  202.  
  203. CREATE TABLE [dbo].[Product](
  204. [Product_No] [nvarchar](50) NULL,
  205. [Product_Shortcode] [nvarchar](50) NULL,
  206. [Product_name] [nvarchar](50) NULL,
  207. [Unit] [nvarchar](MAX) NULL,
  208. [Barcode] [nvarchar](MAX) NULL,
  209. [Categoryname] [nvarchar](50) NULL,
  210. [Unit_Price] [money] NULL,
  211. [Price] [money] NULL,
  212. [Mincriticalstocklevel] [INT] NULL,
  213. [Createdby] [nvarchar](MAX) NULL,
  214. [Datecreated] [nvarchar](50) NULL,
  215. [Brand_name] [nvarchar](50) NULL,
  216. [Stock] [INT] NULL,
  217. [Impost] [NCHAR](10) NULL,
  218. [Stockcritico] [INT] NULL,
  219. [custo] [money] NULL,
  220. [Data2] [INT] NULL,
  221. [Data3] [INT] NULL,
  222. [usuario] [nvarchar](50) NULL
  223. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  224.  
  225. GO
  226.  
  227.  
  228. USE [Pos]
  229. GO
  230.  
  231. /****** Object: Table [dbo].[Numerario2] Script Date: 16-04-2013 14:50:55 ******/
  232. SET ANSI_NULLS ON
  233. GO
  234.  
  235. SET QUOTED_IDENTIFIER ON
  236. GO
  237.  
  238. CREATE TABLE [dbo].[Numerario2](
  239. [Ordem] [INT] IDENTITY(1000,1) NOT NULL,
  240. [Estado] [nvarchar](50) NULL,
  241. [DATA] [nvarchar](50) NULL
  242. ) ON [PRIMARY]
  243.  
  244. GO
  245.  
  246.  
  247. USE [Pos]
  248. GO
  249.  
  250. /****** Object: Table [dbo].[Numera_s] Script Date: 16-04-2013 14:50:45 ******/
  251. SET ANSI_NULLS ON
  252. GO
  253.  
  254. SET QUOTED_IDENTIFIER ON
  255. GO
  256.  
  257. CREATE TABLE [dbo].[Numera_s](
  258. [Ordem] [INT] IDENTITY(1000,1) NOT NULL,
  259. [Estado] [nvarchar](50) NULL,
  260. [DATA] [nvarchar](50) NULL
  261. ) ON [PRIMARY]
  262.  
  263. GO

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.