Modified commercial management

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

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.

Tags

Comments

Submitted byAnonymous (not verified)on Tue, 04/16/2013 - 16:20

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
Submitted byAnonymous (not verified)on Wed, 04/17/2013 - 06:04

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
Submitted byAnonymous (not verified)on Sun, 04/21/2013 - 01:34

please re-upload the database backup. Pos.ldf file missing leaves no database created by high in that file
Submitted byAnonymous (not verified)on Mon, 04/22/2013 - 05:17

In reply to by Anonymous (not verified)

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
Submitted byClaudisnei (not verified)on Tue, 09/10/2013 - 09:42

meu querido poderia colocar um banco access neste sistema

Add new comment