手机管理系统 CS架构 C# 源码

create database Handset go use Handset go create table HandsetInfo ( HId int primary key NOT NULL, Hcards varchar(10) not NULL, Htype varchar(10) not NULL, Hunit varchar(10) not null, Hplace varchar(4) not null, Hcolor varchar(10) not null, HtradePrice money not null, Hprice money not null, Htime varchar(10) not null, Hremark varchar(30) ) go create table EmployeeInfo ( EId int identity(001,1) primary key NOT NULL, Ename varchar(10) not NULL, Enamecode varchar(10) not NULL, Epwd varchar(10) not null, Esex varchar(4) not NULL, Ephone varchar(20) NULL, EIDcard varchar(20), EfamilyPlace Varchar(50) NULL, Edept varchar(10) not null, Einttime Datetime default(getdate()) not NULL ) go create table SalesDepartment ( Sid int identity(1001,1) primary key not null, SSalesDepartment varchar(20) not null, Sphone varchar(20) not null, Sremark varchar(50) null ) go create table Client ( Cid int identity(1,1) primary key not null, Cname varchar(10) not null, Csex varchar(10) not null, Cnamecord varchar(10) not null, Carea varchar(25) not null, Chandset varchar(20) null, Cfaxes varchar(20) null, Cremark varchar(50) null ) go create table Fill ( Fid int identity(001,1) primary key not null, FFillName varchar(15) not null, FlinkMan varchar(10) not null, Farea varchar(20) not null, FtouchTell varchar(20) not null, Fpostalcode varchar(20) not null ) go CREATE TABLE Quitbale ( Qid int IDENTITY (101, 1) primary key NOT NULL , QbalePlace varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , Qfill varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , Qphone int NULL , Qtime datetime NOT NULL DEFAULT (getdate()), Qstrandsize int NOT NULL , Qbrand varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , QspecType varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , Qunit varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , Qnum int NOT NULL , QenterMoney money NOT NULL , QquitgoodsMoney money NOT NULL , Qmoney money not null, Qarea varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , QinGoodRepairTime varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , QpaymentMode varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , Qremark varchar (40) COLLATE Chinese_PRC_CI_AS NULL ) go create table MobileSell ( Mid int identity(101,1) primary key not null, Mplace varchar(10) not null, Mclient varchar(10) not null, Mphone int null, Mdate Datetime default(getdate()) not NULL, MstrandNo int NOT NULL, MrankBrand varchar(10) not NULL, MspecType varchar(10) not NULL, Munit varchar(10) not null, MsellNum int not null, Msellprice money not null, Msellmoney money not null, Moperation varchar(10) not null, MinGoodRepairtime varchar(10) not null, Mpayment varchar(10) not null, Mremark varchar(40) null ) go create table OutFadeOdd ( Oid int IDENTITY (101, 1) primary key NOT NULL , OGoodplace varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , Oclient varchar (10) COLLATE Chinese_PRC_CI_AS NOT NULL , OtouchTell varchar(30) NULL , Oquittime Datetime default(getdate()) not NULL, OhandsetNum varchar(10) not null, OrankCards varchar(10) not null, OspecType varchar(10) not null, Ounit varchar(10) not null, OoutGoodsNum int not null, OenterPrice money NOT NULL , OoutPrice money NOT NULL , OskillNum varchar(10) not null, OinGoodRepairtime varchar(10) not null, OmodeType varchar(10) not null, Oremark varchar(30) not null ) go create table PhoneStock ( Pid int identity(101,1) primary key not null, PStorehouse varchar(10) not null, PfillMan varchar(10) not null, Pfilltell varchar(20) null, Ptime Datetime default(getdate()) not NULL, PhandsetNum varchar(20) NOT NULL, Prank varchar(10) not NULL, PspecType varchar(10) not NULL, Punit varchar(10) not NULL, PstockNum int not null, Pstockprice money not null, PretailPrice money not null, PstockMoney money not null, PproducingArea varchar(10) not NULL, PtradePrice money not null, PinGoodRepriaPrice varchar(10) not NULL, PpaymentType varchar(10) not NULL, Poperation varchar(10) not NULL, Premark varchar(50) not NULL, ) create table Question ( QId int identity(1,1) primary key not null, QQuestion varchar(200) not null, QPeopleName varchar(8) not null, QPriID int not null, Qread int not null, Qtime Datetime default(getdate()) not NULL ) go