/// <summary> /// 保存调拨单扫描数量 /// </summary> /// <param name="dt"></param> /// <returns></returns> public int iSaveGetTransVouchChkQty(string sCode, DataTable dtBarCode, string sUid) { int iCou = 0; try { string sTrCode = sCode; SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString); conn.Open(); //启用事务 SqlTransaction tran = conn.BeginTransaction(); try { decimal dQtyScanSum = 0; // 累计扫描数量 for (int i = 0; i < dtBarCode.Rows.Count; i++) { dQtyScanSum = dQtyScanSum + ClsBaseDataInfo.ReturnObjectToDecimal(dtBarCode.Rows[i]["数量"]); } string sSQL = "select a.cTVCode as cCode,b.irowno,b.cInvCode ,b.iTVQuantity as iQuantity,b.cDefine29 as 已扫描数量,cast(null as decimal(16,6)) as 本次扫描数量,b.autoid from TransVouch a inner join TransVouchs b on a.cTVCode = b.cTVCode where a.cTVCode = '" + sCode + "' order by b.cInvCode"; DataTable dtRdRecord11 = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; sSQL = "select getdate()"; DataTable dtTime = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; DateTime dtmNow = BaseFunction.ReturnDate(dtTime.Rows[0][0]); string s_BarCodeRDCode = BaseFunction.ReturnDate(dtTime.Rows[0][0]).ToString("yyMMddHHmmss"); dtTime = null; _BarCodeRD DAL_BarCodeRD = new _BarCodeRD(); _BarCodeList DAL_BarCodeList = new _BarCodeList(); for (int i = 0; i < dtBarCode.Rows.Count; i++) { string sInvCode = dtBarCode.Rows[i]["存货编码"].ToString().Trim(); decimal dQtyBarCode = BaseFunction.ReturnDecimal(dtBarCode.Rows[i]["数量"]); //条形码中仅存货编码与入库单对应 DataRow[] drCode = dtRdRecord11.Select("cInvCode = '" + sInvCode + "'"); for (int j = 0; j < drCode.Length; j++) { if (dQtyBarCode <= 0) { break; } decimal diQuantity = BaseFunction.ReturnDecimal(drCode[j]["iQuantity"]); decimal dQtyScaned = BaseFunction.ReturnDecimal(drCode[j]["已扫描数量"]); decimal dQtyNow = BaseFunction.ReturnDecimal(drCode[j]["本次扫描数量"]); decimal d = diQuantity - dQtyScaned - dQtyNow; Model._BarCodeRD model_BarCodeRD = new TH.WebService.Model._BarCodeRD(); model_BarCodeRD.sCode = s_BarCodeRDCode; model_BarCodeRD.BarCode = dtBarCode.Rows[i]["条形码"].ToString().Trim(); model_BarCodeRD.sType = "调拨单"; model_BarCodeRD.ExsID = BaseFunction.ReturnLong(drCode[j]["autoid"]); model_BarCodeRD.ExCode = drCode[j]["cCode"].ToString().Trim(); model_BarCodeRD.ExRowNo = ClsBaseDataInfo.ReturnObjectToLong(drCode[j]["iRowNo"]); model_BarCodeRD.cInvCode = drCode[j]["cInvCode"].ToString().Trim(); model_BarCodeRD.CreateUid = dtBarCode.Rows[i]["制单人"].ToString().Trim(); model_BarCodeRD.CreateDate = dtmNow; model_BarCodeRD.XBarCode = dtBarCode.Rows[i]["箱码"].ToString().Trim(); model_BarCodeRD.RDType = 0; //条形码数量超出单据数量 if (dQtyBarCode >= d) { model_BarCodeRD.Qty = d; dQtyScanSum = dQtyScanSum - d; drCode[j]["本次扫描数量"] = BaseFunction.ReturnDecimal(drCode[j]["本次扫描数量"]) + d; dQtyBarCode = dQtyBarCode - d; } else { model_BarCodeRD.Qty = dQtyBarCode; dQtyScanSum = dQtyScanSum - dQtyBarCode; drCode[j]["本次扫描数量"] = BaseFunction.ReturnDecimal(drCode[j]["本次扫描数量"]) + dQtyBarCode; dQtyBarCode = 0; } sSQL = DAL_BarCodeRD.Add(model_BarCodeRD); iCou = iCou + DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = "update TransVouchs set cDefine29 = cast(isnull(cDefine29,0) as decimal(16,6)) + " + model_BarCodeRD.Qty.ToString() + " where autoid = " + model_BarCodeRD.ExsID.ToString(); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } } if (dQtyScanSum != 0) { throw new Exception("扫描数量未完全分配"); } if (iCou == 0) { throw new Exception("没有语句执行"); } #region 判断所有数量扫描后审核单据 sSQL = "select getdate()"; DataTable dTime = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; DateTime dTimeNow = ClsBaseDataInfo.ReturnObjectToDatetime(dTime.Rows[0][0]); sSQL = @" select case when sum(cast(isnull(b.cDefine29,0) as decimal(16,6))) <> sum(b.iTVQuantity) then 1 else 0 end as iCou from TransVouch a inner join TransVouchs b on a.cTVCode = b.cTVCode where a.cTVCode = '111111' group by a.cTVCode "; sSQL = sSQL.Replace("111111", sCode); DataTable dtTemp2 = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dtTemp2 != null && dtTemp2.Rows.Count == 1) { int iC = BaseFunction.ReturnInt(dtTemp2.Rows[0][0]); if (iC == 0) { sSQL = "update TransVouch set cVerifyPerson = '222222',dVerifyDate = '333333',dnverifytime = getdate() where cTVCode = '111111'"; sSQL = sSQL.Replace("111111", sCode); sSQL = sSQL.Replace("222222", sUid); sSQL = sSQL.Replace("333333", dTimeNow.ToString("yyyy-MM-dd")); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" select * from TransVouch a inner join TransVouchs b on a.cTVCode = b.cTVCode where a.cTVCode = '111111' order by autoid "; sSQL = sSQL.Replace("111111", sCode); DataTable dtTran = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; int iCouRow = dtTran.Rows.Count; #region 生成其他入库单据 //获得单据号 sSQL = "select cNumber from VoucherHistory Where CardNumber='0301' and cSeed = '" + dTimeNow.ToString("yyyyMM") + "'"; DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; long lCode = 0; if (dt != null && dt.Rows.Count > 0) { lCode = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]); lCode += 1; sSQL = "update VoucherHistory set cNumber = '" + lCode.ToString() + "' Where CardNumber='0301' and cSeed = '" + dTimeNow.ToString("yyyyMM") + "'"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } else { lCode = 1; sSQL = "insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)" + "values('0301','日期','月','" + dTimeNow.ToString("yyyyMM") + "','1',0)"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } sCode = lCode.ToString(); while (sCode.Length < 5) { sCode = "0" + sCode; } sCode = "QR" + dTimeNow.ToString("yyMM") + sCode; long lID = 0; long lIDDetails = 0; sSQL = @" declare @p5 int set @p5=111111 declare @p6 int set @p6=222222 exec sp_GetId N'',N'444444',N'rd',333333,@p5 output,@p6 output,default select @p5, @p6 "; sSQL = sSQL.Replace("111111", lID.ToString()); sSQL = sSQL.Replace("222222", lIDDetails.ToString()); sSQL = sSQL.Replace("333333", iCouRow.ToString()); sSQL = sSQL.Replace("444444", sAccID); dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; lID = ClsBaseDataInfo.ReturnObjectToLong(dt.Rows[0][0]) - 1; lIDDetails = ClsBaseDataInfo.ReturnObjectToLong(dt.Rows[0][1]) - iCouRow; lID += 1; Model.RdRecord08 modelr8 = new TH.WebService.Model.RdRecord08(); modelr8.ID = lID; modelr8.bRdFlag = 1; modelr8.cVouchType = "08"; modelr8.cBusType = "调拨入库"; modelr8.cSource = "调拨"; modelr8.cBusCode = sTrCode; modelr8.cWhCode = dtTran.Rows[0]["cIWhCode"].ToString().Trim(); modelr8.dDate = BaseFunction.ReturnDate(dTimeNow.ToString("yyyy-MM-dd")); modelr8.cCode = sCode; modelr8.cRdCode = dtTran.Rows[0]["cIRdCode"].ToString().Trim(); modelr8.cDepCode = dtTran.Rows[0]["cIDepCode"].ToString().Trim(); modelr8.bTransFlag = false; modelr8.cMaker = sUid; modelr8.bpufirst = false; modelr8.biafirst = false; modelr8.VT_ID = 67; modelr8.bIsSTQc = false; modelr8.bOMFirst = false; modelr8.bFromPreYear = false; modelr8.bIsComplement = 0; modelr8.iDiscountTaxType = 0; modelr8.ireturncount = 0; modelr8.iverifystate = 0; modelr8.iswfcontrolled = 0; modelr8.dnmaketime = dTimeNow; modelr8.bredvouch = 0; modelr8.iPrintCount = 0; DAL.RdRecord08 DALr8 = new RdRecord08(); sSQL = DALr8.Add(modelr8); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); for (int i = 0; i < dtTran.Rows.Count; i++) { Model.rdrecords08 modelr8s = new TH.WebService.Model.rdrecords08(); lIDDetails += 1; modelr8s.AutoID = lIDDetails; modelr8s.ID = lID; modelr8s.cInvCode = dtTran.Rows[i]["cInvCode"].ToString().Trim(); modelr8s.iQuantity = BaseFunction.ReturnDecimal(dtTran.Rows[i]["iTVQuantity"]); modelr8s.iNum = BaseFunction.ReturnDecimal(dtTran.Rows[i]["iTVNum"]); modelr8s.iTrIds = BaseFunction.ReturnLong(dtTran.Rows[i]["autoID"]); modelr8s.iNQuantity = BaseFunction.ReturnDecimal(dtTran.Rows[i]["iTVQuantity"]); modelr8s.irowno = BaseFunction.ReturnInt(dtTran.Rows[i]["irowno"]); DAL.rdrecords08 DALr8s = new rdrecords08(); sSQL = DALr8s.Add(modelr8s); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = "insert into IA_ST_UnAccountVouch08(idun,idsun,cvoutypeun,cbustypeun)values " + "('" + lID + "','" + lIDDetails + "','08','调拨入库')"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } #endregion #region 生成其他出库单据 //获得单据号 sSQL = "select cNumber from VoucherHistory Where CardNumber='0302' and cSeed = '" + dTimeNow.ToString("yyyyMM") + "'"; dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; lCode = 0; if (dt != null && dt.Rows.Count > 0) { lCode = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]); lCode += 1; sSQL = "update VoucherHistory set cNumber = '" + lCode.ToString() + "' Where CardNumber='0302' and cSeed = '" + dTimeNow.ToString("yyyyMM") + "'"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } else { lCode = 1; sSQL = "insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)" + "values('0302','日期','月','" + dTimeNow.ToString("yyyyMM") + "','1',0)"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } sCode = lCode.ToString(); while (sCode.Length < 5) { sCode = "0" + sCode; } sCode = "QC" + dTimeNow.ToString("yyMM") + sCode; lID = 0; lIDDetails = 0; sSQL = @" declare @p5 int set @p5=111111 declare @p6 int set @p6=222222 exec sp_GetId N'',N'444444',N'rd',333333,@p5 output,@p6 output,default select @p5, @p6 "; sSQL = sSQL.Replace("111111", lID.ToString()); sSQL = sSQL.Replace("222222", lIDDetails.ToString()); sSQL = sSQL.Replace("333333", iCouRow.ToString()); sSQL = sSQL.Replace("444444", sAccID); dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; lID = ClsBaseDataInfo.ReturnObjectToLong(dt.Rows[0][0]) - 1; lIDDetails = ClsBaseDataInfo.ReturnObjectToLong(dt.Rows[0][1]) - iCouRow; lID += 1; Model.RdRecord09 modelr9 = new TH.WebService.Model.RdRecord09(); modelr9.ID = lID; modelr9.bRdFlag = 0; modelr9.cVouchType = "09"; modelr9.cBusType = "调拨出库"; modelr9.cSource = "调拨"; modelr9.cBusCode = sTrCode; modelr9.cWhCode = dtTran.Rows[0]["cOWhCode"].ToString().Trim(); modelr9.dDate = BaseFunction.ReturnDate(dTimeNow.ToString("yyyy-MM-dd")); modelr9.cCode = sCode; modelr9.cRdCode = dtTran.Rows[0]["cORdCode"].ToString().Trim(); modelr9.cDepCode = dtTran.Rows[0]["cODepCode"].ToString().Trim(); modelr9.bTransFlag = false; modelr9.cMaker = sUid; modelr9.bpufirst = false; modelr9.biafirst = false; modelr9.VT_ID = 67; modelr9.bIsSTQc = false; modelr9.bOMFirst = false; modelr9.bFromPreYear = false; modelr9.bIsComplement = 0; modelr9.iDiscountTaxType = 0; modelr9.ireturncount = 0; modelr9.iverifystate = 0; modelr9.iswfcontrolled = 0; modelr9.dnmaketime = dTimeNow; modelr9.bredvouch = 0; modelr9.iPrintCount = 0; DAL.RdRecord09 DALr9 = new RdRecord09(); sSQL = DALr9.Add(modelr9); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); for (int i = 0; i < dtTran.Rows.Count; i++) { Model.rdrecords09 modelr9s = new TH.WebService.Model.rdrecords09(); lIDDetails += 1; modelr9s.AutoID = lIDDetails; modelr9s.ID = lID; modelr9s.cInvCode = dtTran.Rows[i]["cInvCode"].ToString().Trim(); modelr9s.iQuantity = BaseFunction.ReturnDecimal(dtTran.Rows[i]["iTVQuantity"]); modelr9s.iNum = BaseFunction.ReturnDecimal(dtTran.Rows[i]["iTVNum"]); modelr9s.iTrIds = BaseFunction.ReturnLong(dtTran.Rows[i]["autoID"]); modelr9s.iNQuantity = BaseFunction.ReturnDecimal(dtTran.Rows[i]["iTVQuantity"]); modelr9s.irowno = BaseFunction.ReturnInt(dtTran.Rows[i]["irowno"]); DAL.RdRecords09 DALr9s = new RdRecords09(); sSQL = DALr9s.Add(modelr9s); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = "insert into IA_ST_UnAccountVouch09(idun,idsun,cvoutypeun,cbustypeun)values " + "('" + lID + "','" + lIDDetails + "','09','调拨出库')"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } #endregion } //sSQL = "exec SP_ClearCurrentStock_ST"; //DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } #endregion tran.Commit(); } catch (Exception error) { tran.Rollback(); throw new Exception(error.Message); } } catch (Exception ee) { throw new Exception(ee.Message); } return(iCou); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(TH.WebService.Model.rdrecords08 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.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.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.chVencode != null) { strSql1.Append("chVencode,"); strSql2.Append("'" + model.chVencode + "',"); } 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.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.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.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.OutCopiedQuantity != null) { strSql1.Append("OutCopiedQuantity,"); strSql2.Append("" + model.OutCopiedQuantity + ","); } if (model.cbsysbarcode != null) { strSql1.Append("cbsysbarcode,"); strSql2.Append("'" + model.cbsysbarcode + "',"); } strSql.Append("insert into rdrecords08("); 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()); }