SQL

create table Brand
(Name VarChar(20)
, AutoID
)

create table GoodsColor(
Name VarChar(20) ,AutoID
)

create table GoodsInfo(
Id,  --info.Id
Price
Name VarChar(20),
Barcode VarChar(50),
SortId Integer,
SizeId Integer,
ColorId Integer,
UnitId Integer,
BrandId Integer,
Remark VarChar(255)
)

create table  GoodsSize
(
Id,AutoID,
Name VarChar(20)
)

create table  GoodsSort(
id
Name VarChar(20),
,ParentId Integer, 4
)

create table Unit(
AutoID,
Id
Name VarChar(20),
)

create table InDepotBill(
AutoID,Name,
[Number] VarChar, 20)
,[Date] OleDbType.DBDate
,Operator OleDbType.VarChar, 100
,Remark OleDbType.VarChar, 255
)

create table InDepotRecord(
Id,AutoID,Name,
   new OleDbParameter("@BillId", OleDbType.Integer),
new OleDbParameter("@GoodsInfoId", OleDbType.Integer),
 new OleDbParameter("@Price", OleDbType.Numeric),
 new OleDbParameter("@Count", OleDbType.Integer)
)

create table SellBill(
id,name,
 new OleDbParameter("@Number", OleDbType.VarChar, 20),
new OleDbParameter("@Date", OleDbType.DBDate),
  new OleDbParameter("@Cashier", OleDbType.VarChar, 20),
new OleDbParameter("@Sales", OleDbType.VarChar, 100)
)

create table SellRecord(
id,name
--BillId,GoodsInfoId,Price,[Count],DiscountKind,DiscountDecimal,DiscountValue
new OleDbParameter("@BillId", OleDbType.Integer),----==SellBill.id
new OleDbParameter("@GoodsInfoId", OleDbType.Integer),
 new OleDbParameter("@Price", OleDbType.Numeric),
 new OleDbParameter("@Count", OleDbType.Integer),
 new OleDbParameter("@DiscountKind", OleDbType.TinyInt),
 new OleDbParameter("@DiscountDecimal", OleDbType.TinyInt),
 new OleDbParameter("@DiscountValue", OleDbType.Numeric)

create table Cashier
id
--([Name],JobNumber,[Password],State)
new OleDbParameter("@Name", OleDbType.VarChar, 20),
new OleDbParameter("@JobNumber", OleDbType.VarChar, 20),
new OleDbParameter("@Password", OleDbType.VarChar, 32),
new OleDbParameter("@State", OleDbType.TinyInt)

create table  [Group]
id
[Name] VarChar, 20
,Remark VarChar, 100

create table Sales
id
[Name] VarChar 20
,Sex OleDbType.TinyInt

create table [User]
id
[Name] VarChar 20,
[Password] VarChar 32
,State OleDbType.TinyInt, 1
,GroupID OleDbType.Integer, 32
,Remark VarChar 100

 

create table SellBillNumber --SellBill.execute.cs
 [Number],[DateTime]

)