1.sql

将excel格式的文件销售订单导入数据库中

delete department where cdepcode='201'
GO
insert into department ([cDepCode],[bDepEnd],[cDepName],[iDepGrade],[cDepPerson],[cDepProp],[cDepPhone],[cDepAddress],[cDepMemo],[iCreLine],[cCreGrade],[iCreDate],[cOfferGrade],[iOfferRate],[bShop],[cDepGUID],[dDepBeginDate],[dDepEndDate],[vAuthorizeDoc],[vAuthorizeUnit],[cDepFax],[cDepPostCode],[cDepEmail],[cDepType])
values('201','1','本地销售部',2,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0','{E02C6EAE-E3A4-4740-B107-8DE71CFA0953}','2004-10-01',Null,Null,Null,Null,Null,Null,'部')
go
delete computationunit where ccomunitcode in('0201','0202')
GO
insert into computationunit ([cComunitCode],[cComUnitName],[cGroupCode],[cBarCode],[bMainUnit],[iChangRate],[iProportion],[iNumber],[cEnSingular],[cEnPlural],[cUnitRefInvCode])
values('0201','个','02',Null,'0',1,Null,1,Null,Null,Null)
insert into computationunit ([cComunitCode],[cComUnitName],[cGroupCode],[cBarCode],[bMainUnit],[iChangRate],[iProportion],[iNumber],[cEnSingular],[cEnPlural],[cUnitRefInvCode])
values('0202','台','02',Null,'1',1,Null,Null,Null,Null,Null)
go
delete customer where cCusCode='C55'
GO
insert into customer ([cCusCode],[cCusName],[cCusAbbName],[cCCCode],[cDCCode],[cTrade],[cCusAddress],[cCusPostCode],[cCusRegCode],[cCusBank],[cCusAccount],[dCusDevDate],[cCusLPerson],[cCusEmail],[cCusPerson],[cCusPhone],[cCusFax],[cCusBP],[cCusHand],[cCusPPerson],[iCusDisRate],[cCusCreGrade],[iCusCreLine],[iCusCreDate],[cCusPayCond],[cCusOAddress],[cCusOType],[cCusHeadCode],[cCusWhCode],[cCusDepart],[iARMoney],[dLastDate],[iLastMoney],[dLRDate],[iLRMoney],[dEndDate],[iFrequency],[cCusDefine1],[cCusDefine2],[cCusDefine3],[iCostGrade],[cCreatePerson],[cModifyPerson],[dModifyDate],[cRelVendor],[iId],[cPriceGroup],[cOfferGrade],[iOfferRate],[cCusDefine4],[cCusDefine5],[cCusDefine6],[cCusDefine7],[cCusDefine8],[cCusDefine9],[cCusDefine10],[cCusDefine11],[cCusDefine12],[cCusDefine13],[cCusDefine14],[cCusDefine15],[cCusDefine16],[cInvoiceCompany],[bCredit],[bCreditDate],[bCreditByHead],[bLicenceDate],[dLicenceSDate],[dLicenceEDate],[iLicenceADays],[bBusinessDate],[dBusinessSDate],[dBusinessEDate],[iBusinessADays],[bProxy],[dProxySDate],[dProxyEDate],[iProxyADays],[cMemo],[bLimitSale],[cCusContactCode],[cCusCountryCode],[cCusEnName],[cCusEnAddr1],[cCusEnAddr2],[cCusEnAddr3],[cCusEnAddr4],[cCusPortCode],[cPrimaryVen],[fCommisionRate],[fInsueRate],[bHomeBranch],[cBranchAddr],[cBranchPhone],[cBranchPerson],[cCusTradeCCode],[CustomerKCode],[bCusState],[bShop],[cCusBankCode],[cCusExch_name],[iCusGSPType],[iCusGSPAuth],[cCusGSPAuthNo],[cCusBusinessNo],[cCusLicenceNo],[bCusDomestic],[bCusOverseas],[cCusCreditCompany],[cCusSAProtocol],[cCusExProtocol],[cCusOtherProtocol],[fCusDiscountRate])
values('C55','上海朱仕实业有限公司','朱仕','01','01',Null,'上海','','123456789012345',Null,Null,'2006-08-24',Null,Null,'demo','010-62536654','010-62536645',Null,'456213544444',Null,0,Null,50000,30,Null,Null,Null,'01003',Null,Null,-590000,Null,0,'2006-09-30',90000,Null,0,Null,Null,Null,-1,'demo','demo','2006-11-01',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'c55','0','0','0','0',Null,Null,Null,'0',Null,Null,Null,'0',Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,Null,'0',Null,Null,Null,Null,Null,'1','0',Null,'人民币',0,Null,Null,Null,Null,'1','0','c55','01',Null,Null,Null)
go