/// <summary> /// 新增客户基础资料 /// </summary> /// <param name="itemType"></param> /// <param name="baseData"></param> public void AddCuster(BaseDataMoreModel baseData) { #region sql string sqlString = @"--DECLARE @FName VARCHAR(255), -- @FNumber VARCHAR(255), -- @FShortNumber VARCHAR(255), -- @FFullNumber VARCHAR(255) --SET @FName='测试FName' --SET @FNumber='测试FNumber' --SET @FShortNumber='测试FShortNumber' --SET @FFullNumber='测试FFullNumber' DECLARE @itemId int INSERT INTO t_Item ( FItemClassID, FParentID, FLevel, FName, FNumber, FShortNumber, FFullNumber, FDetail, UUID, FDeleted ) VALUES ( 1, 0, 1, @FName, @FNumber, @FShortNumber, @FFullNumber, 1, NEWID(), 0 ) select @itemId=fitemid FROM t_item WHERE FNumber=@FNumber INSERT INTO t_Organization ( FHelpCode, FShortName, FAddress, FStatus, FRegionID, FTrade, FContact, FPhone, FMobilePhone, FFax, FPostalCode, FEmail, FBank, FAccount, FTaxNum, FIsCreditMgr, FSaleMode, FValueAddRate, FProvinceID, FCityID, FCountry, FHomePage, Fcorperate, FCarryingAOS, FTypeID, FSaleID, FStockIDKeep, FCoSupplierID, FCyID, FSetID, FCIQNumber, FARAccountID, FPreAcctID, FOtherARAcctID, FPayTaxAcctID, FAPAccountID, FPreAPAcctID, FOtherAPAcctID, FfavorPolicy, Fdepartment, Femployee, FlastTradeAmount, FlastRPAmount, FmaxDealAmount, FminForeReceiveRate, FminReserverate, FdebtLevel, FPayCondition, FNameEN, FAddrEn, FCIQCode, FRegion, FManageType, FShortNumber, FNumber, FName, FParentID, FItemID ) VALUES ( NULL, NULL, NULL, 1072, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1057, '17', 0, 0, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, '0', '0', '0', '1', '1', 0, 0, NULL, NULL, NULL, 0, 0, @FShortNumber, @FNumber, @FName, 0, @itemId ) IF NOT EXISTS( SELECT * FROM Access_t_Organization WHERE FItemID = @itemId ) INSERT INTO Access_t_Organization ( FItemID, FParentIDX, FDataAccessView, FDataAccessEdit, FDataAccessDelete ) VALUES ( @itemId, 0, CONVERT(VARBINARY(7200), REPLICATE(CHAR(0), 7200)), CONVERT(VARBINARY(7200), REPLICATE(CHAR(0), 7200)), CONVERT(VARBINARY(7200), REPLICATE(CHAR(0), 7200)) ) ELSE UPDATE Access_t_Organization SET FParentIDX = 0, FDataAccessView = CONVERT(VARBINARY(7200), REPLICATE(CHAR(0), 7200)), FDataAccessEdit = CONVERT(VARBINARY(7200), REPLICATE(CHAR(0), 7200)), FDataAccessDelete = CONVERT(VARBINARY(7200), REPLICATE(CHAR(0), 7200)) WHERE FItemID = @itemId "; #endregion this.dbManager.Execute(sqlString, baseData); }
public void AddEmp(BaseDataMoreModel baseData) { #region sql string sqlString = @"--DECLARE @FName VARCHAR(255), -- @FNumber VARCHAR(255), -- @FShortNumber VARCHAR(255), -- @FFullNumber VARCHAR(255) --SET @FName='测试FName' --SET @FNumber='测试FNumber' --SET @FShortNumber='测试FShortNumber' --SET @FFullNumber='测试FFullNumber' DECLARE @itemId INT INSERT INTO t_Item ( FItemClassID, FParentID, FLevel, FName, FNumber, FShortNumber, FFullNumber, FDetail, UUID, FDeleted ) VALUES ( 3, 0, 1, @FName, @FNumber, @FShortNumber, @FFullNumber, 1, NEWID(), 0 ) select @itemId=fitemid FROM t_item WHERE FNumber=@FNumber INSERT INTO t_Emp ( FEmpGroup, FDepartmentID, FGender, FDegree, FPhone, FMobilePhone, FID, FDuty, FAccountName, FPersonalBank, FBankAccount, FProvinceID, FCityID, FAddress, FEmail, FNote, FIsCreditMgr, FProfessionalGroup, FJobTypeID, FAllotPercent, FOperationGroup, FOtherARAcctID, FPreARAcctID, FOtherAPAcctID, FPreAPAcctID, FAllotWeight, JiShuDengJi, ZhuDian, FShortNumber, FNumber, FName, FParentID, FItemID ) VALUES ( 0, 0, 1068, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', NULL, NULL, @FShortNumber, @FNumber, @FName, 0, @itemId ) DELETE FROM Access_t_Emp WHERE FItemID = @itemId INSERT INTO Access_t_Emp ( FItemID, FParentIDX, FDataAccessView, FDataAccessEdit, FDataAccessDelete ) VALUES ( @itemId, 0, CONVERT(VARBINARY(7200), REPLICATE(CHAR(255), 100)), CONVERT(VARBINARY(7200), REPLICATE(CHAR(255), 100)), CONVERT(VARBINARY(7200), REPLICATE(CHAR(255), 100)) )"; #endregion this.dbManager.Execute(sqlString, baseData); }