//U8V11.1 public int TransVouch_Audit_U8V111(SqlTransaction tran, string sCode, string sAccID, string sUserName) { string sErr = ""; int iCou = 0; string sSQL = "select getdate()"; DateTime dNow = BaseFunction.ReturnDate(DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0].Rows[0][0]); DateTime dNowDate = BaseFunction.ReturnDate(dNow.ToString("yyyy-MM-dd")); sSQL = @" SELECT * FROM dbo.TransVouch a INNER JOIN dbo.TransVouchs b ON a.ID = b.ID WHERE a.cTVCode = 'aaaaaaaa' "; sSQL = sSQL.Replace("aaaaaaaa", sCode); DataTable dtTr = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dtTr == null || dtTr.Rows.Count == 0) { throw new Exception("Audit err"); } DateTime dtmCode = BaseFunction.ReturnDate(dtTr.Rows[0]["dVerifyDate"]); //审核调拨单 sSQL = @"UPDATE TransVouch SET cVerifyPerson = 'aaaaaa',dVerifyDate = 'bbbbbb',dnverifytime = 'cccccc' WHERE cTVCode = 'dddddd'"; sSQL = sSQL.Replace("aaaaaa", sUserName); sSQL = sSQL.Replace("bbbbbb", dNow.ToString("yyyy-MM-dd")); sSQL = sSQL.Replace("cccccc", dNow.ToString("yyyy-MM-dd HH:mm:ss")); sSQL = sSQL.Replace("dddddd", sCode); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); long lID = -1; long lIDDetails = -1; sSQL = @" declare @p5 int set @p5=aaaaaa declare @p6 int set @p6=bbbbbb exec sp_GetId N'00',N'dddddd',N'rd',1,@p5 output,@p6 output,default select @p5, @p6 "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); sSQL = sSQL.Replace("bbbbbb", lIDDetails.ToString()); sSQL = sSQL.Replace("dddddd", sAccID); DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; lID = BaseFunction.ReturnLong(dt.Rows[0][0]) - 1; lIDDetails = BaseFunction.ReturnLong(dt.Rows[0][1]) - 1; #region 其他入库单 //获得单据号 sSQL = "select cNumber from VoucherHistory with (ROWLOCK) WHERE (CardNumber = '0301') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'aaaaaa') ORDER BY cNumber DESC"; sSQL = sSQL.Replace("aaaaaa", dtmCode.ToString("yyyy")); dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; long lRd08Code = 0; if (dt != null && dt.Rows.Count > 0) { lRd08Code = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]); } else { lRd08Code = 0; } lRd08Code += 1; string sRd08Code = lRd08Code.ToString(); Model.RdRecord08 modRd08 = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.RdRecord08(); lID += 1; modRd08.ID = lID; modRd08.bRdFlag = 1; modRd08.cVouchType = "08"; modRd08.cBusType = "调拨入库"; modRd08.cSource = "调拨"; modRd08.cBusCode = sCode; if (dtTr.Rows[0]["cIWhCode"].ToString().Trim().ToString().Trim() == "") { throw new Exception("请设置转入仓库"); } modRd08.cWhCode = dtTr.Rows[0]["cIWhCode"].ToString().Trim(); modRd08.dDate = dNowDate; string sCodeRD = lRd08Code.ToString(); while (sCodeRD.Length < 6) { sCodeRD = "0" + sCodeRD; } modRd08.cCode = "MI" + dNowDate.Year.ToString() + sCodeRD; if (dtTr.Rows[0]["cIRdCode"].ToString().Trim() == "") { throw new Exception("请设置入库类别"); } modRd08.cRdCode = dtTr.Rows[0]["cIRdCode"].ToString().Trim(); if (dtTr.Rows[0]["cIDepCode"].ToString().Trim() != "") { modRd08.cDepCode = dtTr.Rows[0]["cIDepCode"].ToString().Trim(); } if (dtTr.Rows[0]["cPersonCode"].ToString().Trim() != "") { modRd08.cPersonCode = dtTr.Rows[0]["cPersonCode"].ToString().Trim(); } modRd08.bTransFlag = false; modRd08.cMaker = dtTr.Rows[0]["cVerifyPerson"].ToString().Trim(); modRd08.cHandler = dtTr.Rows[0]["cVerifyPerson"].ToString().Trim(); modRd08.dVeriDate = dNowDate; modRd08.bpufirst = false; modRd08.biafirst = false; modRd08.VT_ID = 67; modRd08.bIsSTQc = false; modRd08.bOMFirst = false; modRd08.bFromPreYear = false; modRd08.bIsComplement = 0; modRd08.iDiscountTaxType = 0; modRd08.ireturncount = 0; modRd08.iverifystate = 0; modRd08.iswfcontrolled = 0; modRd08.dnmaketime = dNow; modRd08.dnverifytime = dNow; modRd08.cSourceLs = "1"; modRd08.iPrintCount = 0; modRd08.csysbarcode = "||st08||" + modRd08.cCode; DAL.RdRecord08 dalrd08 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.RdRecord08(); sSQL = dalrd08.Add(modRd08); iCou += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); for (int i = 0; i < dtTr.Rows.Count; i++) { lIDDetails += 1; Model.rdrecords08 modRds08 = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords08(); modRds08.AutoID = lIDDetails; modRds08.ID = modRd08.ID; modRds08.cInvCode = dtTr.Rows[i]["cInvCode"].ToString().Trim(); if (BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVNum"]) != 0) { modRds08.iNum = BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVNum"]); } modRds08.iQuantity = BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVQuantity"]); modRds08.cBatch = dtTr.Rows[i]["cTVBatch"].ToString().Trim(); modRds08.cVouchCode = 0; modRds08.iSOutNum = 0; modRds08.iSOutQuantity = 0; modRds08.iFlag = 0; modRds08.iTrIds = BaseFunction.ReturnLong(dtTr.Rows[i]["autoID"]); modRds08.iNQuantity = modRds08.iQuantity; modRds08.iNNum = modRds08.iNNum; modRds08.cMassUnit = 0; modRds08.bCosting = true; modRds08.bVMIUsed = false; modRds08.iordertype = 0; modRds08.irowno = BaseFunction.ReturnInt(dtTr.Rows[i]["irowno"]); modRds08.cbsysbarcode = "||st08||" + modRd08.cCode + "|" + modRds08.irowno.ToString(); DAL.rdrecords08 dalRDs08 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords08(); sSQL = dalRDs08.Add(modRds08); iCou += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" if exists (select * from CurrentStock where cInvCode = '@cInvCode' and cWhCode = '@cWhCode' and isnull(cFree1,'') = @cFree1 and isnull(cFree2,'') = @cFree2 and isnull(cFree3,'') = @cFree3 and isnull(cFree4,'') = @cFree4 and isnull(cFree5,'') = @cFree5 and isnull(cFree6,'') = @cFree6 and isnull(cFree7,'') = @cFree7 and isnull(cFree8,'') = @cFree8 and isnull(cFree9,'') = @cFree9 and isnull(cFree10,'') = @cFree10 and isnull(cBatch,'') = @cBatch ) update CurrentStock set iQuantity = isnull(iQuantity,0) + @iQuantity where cInvCode = '@cInvCode' and cWhCode = '@cWhCode' and isnull(cFree1,'') = @cFree1 and isnull(cFree2,'') = @cFree2 and isnull(cFree3,'') = @cFree3 and isnull(cFree4,'') = @cFree4 and isnull(cFree5,'') = @cFree5 and isnull(cFree6,'') = @cFree6 and isnull(cFree7,'') = @cFree7 and isnull(cFree8,'') = @cFree8 and isnull(cFree9,'') = @cFree9 and isnull(cFree10,'') = @cFree10 and isnull(cBatch,'') = @cBatch else begin declare @itemid varchar(20); declare @iCount int; select @iCount=count(itemid) from CurrentStock where cInvCode = '@cInvCode'; if( @iCount > 0 ) select @itemid=itemid from CurrentStock where cInvCode = '@cInvCode'; else select @itemid=max(itemid+1) from CurrentStock insert into CurrentStock(cWhCode,cInvCode,iQuantity,itemid, cFree1, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10,cBatch,iSoDid) values('@cWhCode','@cInvCode', @iQuantity,isnull(@itemid,1), @cFree1, @cFree2, @cFree3, @cFree4, @cFree5, @cFree6, @cFree7, @cFree8, @cFree9, @cFree10,@cBatch,'') end "; sSQL = sSQL.Replace("@cInvCode", modRds08.cInvCode); sSQL = sSQL.Replace("@cWhCode", modRd08.cWhCode); sSQL = sSQL.Replace("@iQuantity", modRds08.iQuantity.ToString()); sSQL = sSQL.Replace("@iNum", modRds08.iNum.ToString()); sSQL = sSQL.Replace("@cFree10", modRds08.cFree10 == null ? "''" : "'" + modRds08.cFree10 + "'"); sSQL = sSQL.Replace("@cFree1", modRds08.cFree1 == null ? "''" : "'" + modRds08.cFree1 + "'"); sSQL = sSQL.Replace("@cFree2", modRds08.cFree2 == null ? "''" : "'" + modRds08.cFree2 + "'"); sSQL = sSQL.Replace("@cFree3", modRds08.cFree3 == null ? "''" : "'" + modRds08.cFree3 + "'"); sSQL = sSQL.Replace("@cFree4", modRds08.cFree4 == null ? "''" : "'" + modRds08.cFree4 + "'"); sSQL = sSQL.Replace("@cFree5", modRds08.cFree5 == null ? "''" : "'" + modRds08.cFree5 + "'"); sSQL = sSQL.Replace("@cFree6", modRds08.cFree6 == null ? "''" : "'" + modRds08.cFree6 + "'"); sSQL = sSQL.Replace("@cFree7", modRds08.cFree7 == null ? "''" : "'" + modRds08.cFree7 + "'"); sSQL = sSQL.Replace("@cFree8", modRds08.cFree8 == null ? "''" : "'" + modRds08.cFree8 + "'"); sSQL = sSQL.Replace("@cFree9", modRds08.cFree9 == null ? "''" : "'" + modRds08.cFree9 + "'"); sSQL = sSQL.Replace("@cBatch", modRds08.cBatch == null ? "''" : "'" + modRds08.cBatch + "'"); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } sSQL = @" exec ST_SaveForStock N'08',N'aaaaaa',1,0 ,1 "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" exec ST_SaveForTrackStock N'08',N'aaaaaa', 0 ,1 "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" exec IA_SP_WriteUnAccountVouchForST 'aaaaaa',N'08' "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" if exists(select * from VoucherHistory where (CardNumber = '0301') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'bbbbbb')) update VoucherHistory set cNumber = aaaaaa where (CardNumber = '0301') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'bbbbbb') else insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty) values('0301','日期','YYYY','bbbbbb','1',0) "; sSQL = sSQL.Replace("aaaaaa", lRd08Code.ToString()); sSQL = sSQL.Replace("bbbbbb", dNow.ToString("yyyy")); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); #endregion #region 其他出库单 //获得单据号 sSQL = "select cNumber from VoucherHistory with (ROWLOCK) WHERE (CardNumber = '0302') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'aaaaaa') ORDER BY cNumber DESC"; sSQL = sSQL.Replace("aaaaaa", dtmCode.ToString("yyyy")); dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; long lRd09Code = 0; if (dt != null && dt.Rows.Count > 0) { lRd09Code = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]); } else { lRd09Code = 0; } lRd09Code += 1; string sRd09Code = lRd09Code.ToString(); Model.RdRecord09 modRd09 = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.RdRecord09(); lID += 1; modRd09.ID = lID; modRd09.bRdFlag = 0; modRd09.cVouchType = "09"; modRd09.cBusType = "调拨出库"; modRd09.cSource = "调拨"; modRd09.cBusCode = sCode; if (dtTr.Rows[0]["cOWhCode"].ToString().Trim().ToString().Trim() == "") { throw new Exception("请设置转出仓库"); } modRd09.cWhCode = dtTr.Rows[0]["cOWhCode"].ToString().Trim(); modRd09.dDate = dNowDate; string sCodeRD09 = lRd09Code.ToString(); while (sCodeRD09.Length < 6) { sCodeRD09 = "0" + sCodeRD09; } modRd09.cCode = "MR" + dNowDate.Year.ToString() + sCodeRD09; if (dtTr.Rows[0]["cORdCode"].ToString().Trim() == "") { throw new Exception("请设置出库类别"); } modRd09.cRdCode = dtTr.Rows[0]["cORdCode"].ToString().Trim(); if (dtTr.Rows[0]["cODepCode"].ToString().Trim() != "") { modRd09.cDepCode = dtTr.Rows[0]["cODepCode"].ToString().Trim(); } if (dtTr.Rows[0]["cPersonCode"].ToString().Trim() != "") { modRd09.cPersonCode = dtTr.Rows[0]["cPersonCode"].ToString().Trim(); } modRd09.bTransFlag = false; modRd09.cMaker = dtTr.Rows[0]["cVerifyPerson"].ToString().Trim(); modRd09.cHandler = dtTr.Rows[0]["cVerifyPerson"].ToString().Trim(); modRd09.dVeriDate = dNowDate; modRd09.bpufirst = false; modRd09.biafirst = false; modRd09.VT_ID = 85; modRd09.bIsSTQc = false; modRd09.bOMFirst = false; modRd09.bFromPreYear = false; modRd09.bIsComplement = 0; modRd09.iDiscountTaxType = 0; modRd09.ireturncount = 0; modRd09.iverifystate = 0; modRd09.iswfcontrolled = 0; modRd09.dnmaketime = dNow; modRd09.dnverifytime = dNow; modRd09.cSourceLs = "1"; modRd09.iPrintCount = 0; modRd09.csysbarcode = "||st09||" + modRd09.cCode; DAL.RdRecord09 dalrd09 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.RdRecord09(); sSQL = dalrd09.Add(modRd09); iCou += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); for (int i = 0; i < dtTr.Rows.Count; i++) { lIDDetails += 1; Model.rdrecords09 modRds09 = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords09(); modRds09.AutoID = lIDDetails; modRds09.ID = modRd09.ID; modRds09.cInvCode = dtTr.Rows[i]["cInvCode"].ToString().Trim(); if (BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVNum"]) != 0) { modRds09.iNum = BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVNum"]); } modRds09.iQuantity = BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVQuantity"]); modRds09.cBatch = dtTr.Rows[i]["cTVBatch"].ToString().Trim(); modRds09.cVouchCode = 0; modRds09.iSOutNum = 0; modRds09.iSOutQuantity = 0; modRds09.iFlag = 0; modRds09.iTrIds = BaseFunction.ReturnLong(dtTr.Rows[i]["autoID"]); modRds09.iNQuantity = modRds09.iQuantity; modRds09.iNNum = modRds09.iNNum; modRds09.cMassUnit = 0; modRds09.bCosting = true; modRds09.bVMIUsed = false; modRds09.iordertype = 0; modRds09.irowno = BaseFunction.ReturnInt(dtTr.Rows[i]["irowno"]); modRds09.cbsysbarcode = "||st09||" + modRd09.cCode + "|" + modRds09.irowno.ToString(); DAL.rdrecords09 dalRDs09 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords09(); sSQL = dalRDs09.Add(modRds09); iCou += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" if exists (select * from CurrentStock where cInvCode = '@cInvCode' and cWhCode = '@cWhCode' and isnull(cFree1,'') = @cFree1 and isnull(cFree2,'') = @cFree2 and isnull(cFree3,'') = @cFree3 and isnull(cFree4,'') = @cFree4 and isnull(cFree5,'') = @cFree5 and isnull(cFree6,'') = @cFree6 and isnull(cFree7,'') = @cFree7 and isnull(cFree8,'') = @cFree8 and isnull(cFree9,'') = @cFree9 and isnull(cFree10,'') = @cFree10 and isnull(cBatch,'') = @cBatch ) update CurrentStock set iQuantity = isnull(iQuantity,0) - @iQuantity where cInvCode = '@cInvCode' and cWhCode = '@cWhCode' and isnull(cFree1,'') = @cFree1 and isnull(cFree2,'') = @cFree2 and isnull(cFree3,'') = @cFree3 and isnull(cFree4,'') = @cFree4 and isnull(cFree5,'') = @cFree5 and isnull(cFree6,'') = @cFree6 and isnull(cFree7,'') = @cFree7 and isnull(cFree8,'') = @cFree8 and isnull(cFree9,'') = @cFree9 and isnull(cFree10,'') = @cFree10 and isnull(cBatch,'') = @cBatch else begin declare @itemid varchar(20); declare @iCount int; select @iCount=count(itemid) from CurrentStock where cInvCode = '@cInvCode'; if( @iCount > 0 ) select @itemid=itemid from CurrentStock where cInvCode = '@cInvCode'; else select @itemid=max(itemid+1) from CurrentStock insert into CurrentStock(cWhCode,cInvCode,iQuantity,itemid, cFree1, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10,cBatch,iSoDid) values('@cWhCode','@cInvCode', @iQuantity,isnull(@itemid,1), @cFree1, @cFree2, @cFree3, @cFree4, @cFree5, @cFree6, @cFree7, @cFree8, @cFree9, @cFree10,@cBatch,'') end "; sSQL = sSQL.Replace("@cInvCode", modRds09.cInvCode); sSQL = sSQL.Replace("@cWhCode", modRd09.cWhCode); sSQL = sSQL.Replace("@iQuantity", modRds09.iQuantity.ToString()); sSQL = sSQL.Replace("@iNum", modRds09.iNum.ToString()); sSQL = sSQL.Replace("@cFree10", modRds09.cFree10 == null ? "''" : "'" + modRds09.cFree10 + "'"); sSQL = sSQL.Replace("@cFree1", modRds09.cFree1 == null ? "''" : "'" + modRds09.cFree1 + "'"); sSQL = sSQL.Replace("@cFree2", modRds09.cFree2 == null ? "''" : "'" + modRds09.cFree2 + "'"); sSQL = sSQL.Replace("@cFree3", modRds09.cFree3 == null ? "''" : "'" + modRds09.cFree3 + "'"); sSQL = sSQL.Replace("@cFree4", modRds09.cFree4 == null ? "''" : "'" + modRds09.cFree4 + "'"); sSQL = sSQL.Replace("@cFree5", modRds09.cFree5 == null ? "''" : "'" + modRds09.cFree5 + "'"); sSQL = sSQL.Replace("@cFree6", modRds09.cFree6 == null ? "''" : "'" + modRds09.cFree6 + "'"); sSQL = sSQL.Replace("@cFree7", modRds09.cFree7 == null ? "''" : "'" + modRds09.cFree7 + "'"); sSQL = sSQL.Replace("@cFree8", modRds09.cFree8 == null ? "''" : "'" + modRds09.cFree8 + "'"); sSQL = sSQL.Replace("@cFree9", modRds09.cFree9 == null ? "''" : "'" + modRds09.cFree9 + "'"); sSQL = sSQL.Replace("@cBatch", modRds09.cBatch == null ? "''" : "'" + modRds09.cBatch + "'"); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } sSQL = @" exec ST_SaveForStock N'09',N'aaaaaa',1,0 ,1 "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" exec ST_SaveForTrackStock N'09',N'aaaaaa', 0 ,1 "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" exec IA_SP_WriteUnAccountVouchForST 'aaaaaa',N'09' "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); if (lID > 1000000000) { lID = lID - 1000000000; } if (lIDDetails > 1000000000) { lIDDetails = lIDDetails - 1000000000; } sSQL = "update UFSystem..UA_Identity set iFatherId = " + lID.ToString() + ",iChildId = " + lIDDetails + " where cAcc_Id = '" + sAccID + "' and cVouchType = 'rd'"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" if exists(select * from VoucherHistory where (CardNumber = '0302') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'bbbbbb')) update VoucherHistory set cNumber = aaaaaa where (CardNumber = '0302') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'bbbbbb') else insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty) values('0302','日期','YYYY','bbbbbb','1',0) "; sSQL = sSQL.Replace("aaaaaa", lRd09Code.ToString()); sSQL = sSQL.Replace("bbbbbb", dNow.ToString("yyyy")); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); #endregion return(iCou); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords09 model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.AutoID != null) { strSql1.Append("AutoID,"); strSql2.Append("" + model.AutoID + ","); } if (model.ID != null) { strSql1.Append("ID,"); strSql2.Append("" + model.ID + ","); } if (model.cInvCode != null) { strSql1.Append("cInvCode,"); strSql2.Append("'" + model.cInvCode + "',"); } if (model.iNum != null) { strSql1.Append("iNum,"); strSql2.Append("" + model.iNum + ","); } if (model.iQuantity != null) { strSql1.Append("iQuantity,"); strSql2.Append("" + model.iQuantity + ","); } if (model.iUnitCost != null) { strSql1.Append("iUnitCost,"); strSql2.Append("" + model.iUnitCost + ","); } if (model.iPrice != null) { strSql1.Append("iPrice,"); strSql2.Append("" + model.iPrice + ","); } if (model.iAPrice != null) { strSql1.Append("iAPrice,"); strSql2.Append("" + model.iAPrice + ","); } if (model.iPUnitCost != null) { strSql1.Append("iPUnitCost,"); strSql2.Append("" + model.iPUnitCost + ","); } if (model.iPPrice != null) { strSql1.Append("iPPrice,"); strSql2.Append("" + model.iPPrice + ","); } if (model.cBatch != null) { strSql1.Append("cBatch,"); strSql2.Append("'" + model.cBatch + "',"); } if (model.cVouchCode != null) { strSql1.Append("cVouchCode,"); strSql2.Append("" + model.cVouchCode + ","); } if (model.cInVouchCode != null) { strSql1.Append("cInVouchCode,"); strSql2.Append("'" + model.cInVouchCode + "',"); } if (model.cinvouchtype != null) { strSql1.Append("cinvouchtype,"); strSql2.Append("'" + model.cinvouchtype + "',"); } if (model.iSOutQuantity != null) { strSql1.Append("iSOutQuantity,"); strSql2.Append("" + model.iSOutQuantity + ","); } if (model.iSOutNum != null) { strSql1.Append("iSOutNum,"); strSql2.Append("" + model.iSOutNum + ","); } if (model.coutvouchid != null) { strSql1.Append("coutvouchid,"); strSql2.Append("" + model.coutvouchid + ","); } if (model.coutvouchtype != null) { strSql1.Append("coutvouchtype,"); strSql2.Append("'" + model.coutvouchtype + "',"); } if (model.iSRedOutQuantity != null) { strSql1.Append("iSRedOutQuantity,"); strSql2.Append("" + model.iSRedOutQuantity + ","); } if (model.iSRedOutNum != null) { strSql1.Append("iSRedOutNum,"); strSql2.Append("" + model.iSRedOutNum + ","); } if (model.cFree1 != null) { strSql1.Append("cFree1,"); strSql2.Append("'" + model.cFree1 + "',"); } if (model.cFree2 != null) { strSql1.Append("cFree2,"); strSql2.Append("'" + model.cFree2 + "',"); } if (model.iFlag != null) { strSql1.Append("iFlag,"); strSql2.Append("" + model.iFlag + ","); } if (model.iFNum != null) { strSql1.Append("iFNum,"); strSql2.Append("" + model.iFNum + ","); } if (model.iFQuantity != null) { strSql1.Append("iFQuantity,"); strSql2.Append("" + model.iFQuantity + ","); } if (model.dVDate != null) { strSql1.Append("dVDate,"); strSql2.Append("'" + model.dVDate + "',"); } if (model.iTrIds != null) { strSql1.Append("iTrIds,"); strSql2.Append("" + model.iTrIds + ","); } if (model.cPosition != null) { strSql1.Append("cPosition,"); strSql2.Append("'" + model.cPosition + "',"); } if (model.cDefine22 != null) { strSql1.Append("cDefine22,"); strSql2.Append("'" + model.cDefine22 + "',"); } if (model.cDefine23 != null) { strSql1.Append("cDefine23,"); strSql2.Append("'" + model.cDefine23 + "',"); } if (model.cDefine24 != null) { strSql1.Append("cDefine24,"); strSql2.Append("'" + model.cDefine24 + "',"); } if (model.cDefine25 != null) { strSql1.Append("cDefine25,"); strSql2.Append("'" + model.cDefine25 + "',"); } if (model.cDefine26 != null) { strSql1.Append("cDefine26,"); strSql2.Append("" + model.cDefine26 + ","); } if (model.cDefine27 != null) { strSql1.Append("cDefine27,"); strSql2.Append("" + model.cDefine27 + ","); } if (model.cItem_class != null) { strSql1.Append("cItem_class,"); strSql2.Append("'" + model.cItem_class + "',"); } if (model.cItemCode != null) { strSql1.Append("cItemCode,"); strSql2.Append("'" + model.cItemCode + "',"); } if (model.iDLsID != null) { strSql1.Append("iDLsID,"); strSql2.Append("" + model.iDLsID + ","); } if (model.cName != null) { strSql1.Append("cName,"); strSql2.Append("'" + model.cName + "',"); } if (model.cItemCName != null) { strSql1.Append("cItemCName,"); strSql2.Append("'" + model.cItemCName + "',"); } if (model.cFree3 != null) { strSql1.Append("cFree3,"); strSql2.Append("'" + model.cFree3 + "',"); } if (model.cFree4 != null) { strSql1.Append("cFree4,"); strSql2.Append("'" + model.cFree4 + "',"); } if (model.cFree5 != null) { strSql1.Append("cFree5,"); strSql2.Append("'" + model.cFree5 + "',"); } if (model.cFree6 != null) { strSql1.Append("cFree6,"); strSql2.Append("'" + model.cFree6 + "',"); } if (model.cFree7 != null) { strSql1.Append("cFree7,"); strSql2.Append("'" + model.cFree7 + "',"); } if (model.cFree8 != null) { strSql1.Append("cFree8,"); strSql2.Append("'" + model.cFree8 + "',"); } if (model.cFree9 != null) { strSql1.Append("cFree9,"); strSql2.Append("'" + model.cFree9 + "',"); } if (model.cFree10 != null) { strSql1.Append("cFree10,"); strSql2.Append("'" + model.cFree10 + "',"); } if (model.cBarCode != null) { strSql1.Append("cBarCode,"); strSql2.Append("'" + model.cBarCode + "',"); } if (model.iNQuantity != null) { strSql1.Append("iNQuantity,"); strSql2.Append("" + model.iNQuantity + ","); } if (model.iNNum != null) { strSql1.Append("iNNum,"); strSql2.Append("" + model.iNNum + ","); } if (model.cAssUnit != null) { strSql1.Append("cAssUnit,"); strSql2.Append("'" + model.cAssUnit + "',"); } if (model.dMadeDate != null) { strSql1.Append("dMadeDate,"); strSql2.Append("'" + model.dMadeDate + "',"); } if (model.iMassDate != null) { strSql1.Append("iMassDate,"); strSql2.Append("" + model.iMassDate + ","); } if (model.cDefine28 != null) { strSql1.Append("cDefine28,"); strSql2.Append("'" + model.cDefine28 + "',"); } if (model.cDefine29 != null) { strSql1.Append("cDefine29,"); strSql2.Append("'" + model.cDefine29 + "',"); } if (model.cDefine30 != null) { strSql1.Append("cDefine30,"); strSql2.Append("'" + model.cDefine30 + "',"); } if (model.cDefine31 != null) { strSql1.Append("cDefine31,"); strSql2.Append("'" + model.cDefine31 + "',"); } if (model.cDefine32 != null) { strSql1.Append("cDefine32,"); strSql2.Append("'" + model.cDefine32 + "',"); } if (model.cDefine33 != null) { strSql1.Append("cDefine33,"); strSql2.Append("'" + model.cDefine33 + "',"); } if (model.cDefine34 != null) { strSql1.Append("cDefine34,"); strSql2.Append("" + model.cDefine34 + ","); } if (model.cDefine35 != null) { strSql1.Append("cDefine35,"); strSql2.Append("" + model.cDefine35 + ","); } if (model.cDefine36 != null) { strSql1.Append("cDefine36,"); strSql2.Append("'" + model.cDefine36 + "',"); } if (model.cDefine37 != null) { strSql1.Append("cDefine37,"); strSql2.Append("'" + model.cDefine37 + "',"); } if (model.iCheckIds != null) { strSql1.Append("iCheckIds,"); strSql2.Append("" + model.iCheckIds + ","); } if (model.cBVencode != null) { strSql1.Append("cBVencode,"); strSql2.Append("'" + model.cBVencode + "',"); } if (model.bGsp != null) { strSql1.Append("bGsp,"); strSql2.Append("" + (model.bGsp ? 1 : 0) + ","); } if (model.cGspState != null) { strSql1.Append("cGspState,"); strSql2.Append("'" + model.cGspState + "',"); } if (model.cCheckCode != null) { strSql1.Append("cCheckCode,"); strSql2.Append("'" + model.cCheckCode + "',"); } if (model.iCheckIdBaks != null) { strSql1.Append("iCheckIdBaks,"); strSql2.Append("" + model.iCheckIdBaks + ","); } if (model.cRejectCode != null) { strSql1.Append("cRejectCode,"); strSql2.Append("'" + model.cRejectCode + "',"); } if (model.iRejectIds != null) { strSql1.Append("iRejectIds,"); strSql2.Append("" + model.iRejectIds + ","); } if (model.cCheckPersonCode != null) { strSql1.Append("cCheckPersonCode,"); strSql2.Append("'" + model.cCheckPersonCode + "',"); } if (model.dCheckDate != null) { strSql1.Append("dCheckDate,"); strSql2.Append("'" + model.dCheckDate + "',"); } if (model.cMassUnit != null) { strSql1.Append("cMassUnit,"); strSql2.Append("" + model.cMassUnit + ","); } if (model.bChecked != null) { strSql1.Append("bChecked,"); strSql2.Append("" + (model.bChecked ? 1 : 0) + ","); } if (model.iEqDID != null) { strSql1.Append("iEqDID,"); strSql2.Append("" + model.iEqDID + ","); } if (model.bLPUseFree != null) { strSql1.Append("bLPUseFree,"); strSql2.Append("" + (model.bLPUseFree ? 1 : 0) + ","); } if (model.iRSRowNO != null) { strSql1.Append("iRSRowNO,"); strSql2.Append("" + model.iRSRowNO + ","); } if (model.iOriTrackID != null) { strSql1.Append("iOriTrackID,"); strSql2.Append("" + model.iOriTrackID + ","); } if (model.coritracktype != null) { strSql1.Append("coritracktype,"); strSql2.Append("'" + model.coritracktype + "',"); } if (model.cbaccounter != null) { strSql1.Append("cbaccounter,"); strSql2.Append("'" + model.cbaccounter + "',"); } if (model.dbKeepDate != null) { strSql1.Append("dbKeepDate,"); strSql2.Append("'" + model.dbKeepDate + "',"); } if (model.bCosting != null) { strSql1.Append("bCosting,"); strSql2.Append("" + (model.bCosting ? 1 : 0) + ","); } if (model.bVMIUsed != null) { strSql1.Append("bVMIUsed,"); strSql2.Append("" + (model.bVMIUsed ? 1 : 0) + ","); } if (model.iVMISettleQuantity != null) { strSql1.Append("iVMISettleQuantity,"); strSql2.Append("" + model.iVMISettleQuantity + ","); } if (model.iVMISettleNum != null) { strSql1.Append("iVMISettleNum,"); strSql2.Append("" + model.iVMISettleNum + ","); } if (model.cvmivencode != null) { strSql1.Append("cvmivencode,"); strSql2.Append("'" + model.cvmivencode + "',"); } if (model.iInvSNCount != null) { strSql1.Append("iInvSNCount,"); strSql2.Append("" + model.iInvSNCount + ","); } if (model.cwhpersoncode != null) { strSql1.Append("cwhpersoncode,"); strSql2.Append("'" + model.cwhpersoncode + "',"); } if (model.cwhpersonname != null) { strSql1.Append("cwhpersonname,"); strSql2.Append("'" + model.cwhpersonname + "',"); } if (model.cserviceoid != null) { strSql1.Append("cserviceoid,"); strSql2.Append("'" + model.cserviceoid + "',"); } if (model.cbserviceoid != null) { strSql1.Append("cbserviceoid,"); strSql2.Append("'" + model.cbserviceoid + "',"); } if (model.iinvexchrate != null) { strSql1.Append("iinvexchrate,"); strSql2.Append("" + model.iinvexchrate + ","); } if (model.cbdlcode != null) { strSql1.Append("cbdlcode,"); strSql2.Append("'" + model.cbdlcode + "',"); } if (model.corufts != null) { strSql1.Append("corufts,"); strSql2.Append("'" + model.corufts + "',"); } if (model.strContractGUID != null) { strSql1.Append("strContractGUID,"); strSql2.Append("'" + Guid.NewGuid().ToString() + "',"); } if (model.iExpiratDateCalcu != null) { strSql1.Append("iExpiratDateCalcu,"); strSql2.Append("" + model.iExpiratDateCalcu + ","); } if (model.cExpirationdate != null) { strSql1.Append("cExpirationdate,"); strSql2.Append("'" + model.cExpirationdate + "',"); } if (model.dExpirationdate != null) { strSql1.Append("dExpirationdate,"); strSql2.Append("'" + model.dExpirationdate + "',"); } if (model.cciqbookcode != null) { strSql1.Append("cciqbookcode,"); strSql2.Append("'" + model.cciqbookcode + "',"); } if (model.iBondedSumQty != null) { strSql1.Append("iBondedSumQty,"); strSql2.Append("" + model.iBondedSumQty + ","); } if (model.ccusinvcode != null) { strSql1.Append("ccusinvcode,"); strSql2.Append("'" + model.ccusinvcode + "',"); } if (model.ccusinvname != null) { strSql1.Append("ccusinvname,"); strSql2.Append("'" + model.ccusinvname + "',"); } if (model.iorderdid != null) { strSql1.Append("iorderdid,"); strSql2.Append("" + model.iorderdid + ","); } if (model.iordertype != null) { strSql1.Append("iordertype,"); strSql2.Append("" + model.iordertype + ","); } if (model.iordercode != null) { strSql1.Append("iordercode,"); strSql2.Append("'" + model.iordercode + "',"); } if (model.iorderseq != null) { strSql1.Append("iorderseq,"); strSql2.Append("" + model.iorderseq + ","); } if (model.isodid != null) { strSql1.Append("isodid,"); strSql2.Append("'" + model.isodid + "',"); } if (model.isotype != null) { strSql1.Append("isotype,"); strSql2.Append("" + model.isotype + ","); } if (model.csocode != null) { strSql1.Append("csocode,"); strSql2.Append("'" + model.csocode + "',"); } if (model.isoseq != null) { strSql1.Append("isoseq,"); strSql2.Append("" + model.isoseq + ","); } if (model.cBatchProperty1 != null) { strSql1.Append("cBatchProperty1,"); strSql2.Append("" + model.cBatchProperty1 + ","); } if (model.cBatchProperty2 != null) { strSql1.Append("cBatchProperty2,"); strSql2.Append("" + model.cBatchProperty2 + ","); } if (model.cBatchProperty3 != null) { strSql1.Append("cBatchProperty3,"); strSql2.Append("" + model.cBatchProperty3 + ","); } if (model.cBatchProperty4 != null) { strSql1.Append("cBatchProperty4,"); strSql2.Append("" + model.cBatchProperty4 + ","); } if (model.cBatchProperty5 != null) { strSql1.Append("cBatchProperty5,"); strSql2.Append("" + model.cBatchProperty5 + ","); } if (model.cBatchProperty6 != null) { strSql1.Append("cBatchProperty6,"); strSql2.Append("'" + model.cBatchProperty6 + "',"); } if (model.cBatchProperty7 != null) { strSql1.Append("cBatchProperty7,"); strSql2.Append("'" + model.cBatchProperty7 + "',"); } if (model.cBatchProperty8 != null) { strSql1.Append("cBatchProperty8,"); strSql2.Append("'" + model.cBatchProperty8 + "',"); } if (model.cBatchProperty9 != null) { strSql1.Append("cBatchProperty9,"); strSql2.Append("'" + model.cBatchProperty9 + "',"); } if (model.cBatchProperty10 != null) { strSql1.Append("cBatchProperty10,"); strSql2.Append("'" + model.cBatchProperty10 + "',"); } if (model.cbMemo != null) { strSql1.Append("cbMemo,"); strSql2.Append("'" + model.cbMemo + "',"); } if (model.irowno != null) { strSql1.Append("irowno,"); strSql2.Append("" + model.irowno + ","); } if (model.strowguid != null) { strSql1.Append("strowguid,"); strSql2.Append("'" + Guid.NewGuid().ToString() + "',"); } if (model.rowufts != null) { strSql1.Append("rowufts,"); strSql2.Append("" + model.rowufts + ","); } if (model.ipreuseqty != null) { strSql1.Append("ipreuseqty,"); strSql2.Append("" + model.ipreuseqty + ","); } if (model.ipreuseinum != null) { strSql1.Append("ipreuseinum,"); strSql2.Append("" + model.ipreuseinum + ","); } if (model.cbsourcecodels != null) { strSql1.Append("cbsourcecodels,"); strSql2.Append("'" + model.cbsourcecodels + "',"); } if (model.iGroupNO != null) { strSql1.Append("iGroupNO,"); strSql2.Append("" + model.iGroupNO + ","); } if (model.iDebitIDs != null) { strSql1.Append("iDebitIDs,"); strSql2.Append("" + model.iDebitIDs + ","); } if (model.idebitchildids != null) { strSql1.Append("idebitchildids,"); strSql2.Append("" + model.idebitchildids + ","); } if (model.iimosid != null) { strSql1.Append("iimosid,"); strSql2.Append("" + model.iimosid + ","); } if (model.cPOID != null) { strSql1.Append("cPOID,"); strSql2.Append("'" + model.cPOID + "',"); } if (model.strContractId != null) { strSql1.Append("strContractId,"); strSql2.Append("'" + model.strContractId + "',"); } if (model.strCode != null) { strSql1.Append("strCode,"); strSql2.Append("'" + model.strCode + "',"); } if (model.cInVoucherLineID != null) { strSql1.Append("cInVoucherLineID,"); strSql2.Append("" + model.cInVoucherLineID + ","); } if (model.cInVoucherCode != null) { strSql1.Append("cInVoucherCode,"); strSql2.Append("'" + model.cInVoucherCode + "',"); } if (model.cInVoucherType != null) { strSql1.Append("cInVoucherType,"); strSql2.Append("'" + model.cInVoucherType + "',"); } if (model.cbsysbarcode != null) { strSql1.Append("cbsysbarcode,"); strSql2.Append("'" + model.cbsysbarcode + "',"); } if (model.ipickedquantity != null) { strSql1.Append("ipickedquantity,"); strSql2.Append("" + model.ipickedquantity + ","); } if (model.ipickednum != null) { strSql1.Append("ipickednum,"); strSql2.Append("" + model.ipickednum + ","); } strSql.Append("insert into rdrecords09("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); return(strSql.ToString()); }