/// <summary> /// 审核发货单 /// </summary> /// <param name="sCode"></param> /// <param name="tran"></param> private string AuditDispatchList(string sCode, SqlTransaction tran) { string sRDCode = ""; 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 = " Update DispatchList SET cVerifier=N'" + sUserName + "',dverifydate= '" + dNowDate.ToString("yyyy-MM-dd") + "',dverifysystime='" + dNow.ToString("yyyy-MM-dd HH:mm:ss") + "' WHERE cDLCode = '" + sCode + "' "; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" select d.cRdCode,a.*,b.* from DispatchList a inner join DispatchLists b on a.DLID = b.DLID left join DispatchLists_extradefine c on b.iDLsID = c.iDLsID left join SaleType d on a.cSTCode = d.cSTCode where a.cDLCode = 'aaaaaa' "; sSQL = sSQL.Replace("aaaaaa", sCode); DataTable dtDispatch = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; //获得单据号 sSQL = "select max(cNumber) as cNumber From VoucherHistory with (NOLOCK) Where CardNumber='0303' and cContent is NULL"; DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; long lRdCode = 0; if (dt != null && dt.Rows.Count > 0) { lRdCode = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]); } else { lRdCode = 0; } lRdCode += 1; string sRdCode = lRdCode.ToString(); while (sRdCode.Length < 10) { sRdCode = "0" + sRdCode; } long lID = -1; long lIDDisDetails = -1; sSQL = @" declare @p5 int set @p5=aaaaaa declare @p6 int set @p6=bbbbbb exec sp_GetId N'00',N'dddddd',N'rd',cccccc,@p5 output,@p6 output,default select @p5, @p6 "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); sSQL = sSQL.Replace("bbbbbb", lIDDisDetails.ToString()); sSQL = sSQL.Replace("cccccc", 1.ToString()); sSQL = sSQL.Replace("dddddd", sAccID); dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; lID = BaseFunction.ReturnLong(dt.Rows[0][0]) - 1; lIDDisDetails = BaseFunction.ReturnLong(dt.Rows[0][1]) - 1; Model.rdrecord32 model = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecord32(); lID += 1; model.ID = lID; model.bRdFlag = 0; model.cVouchType = "32"; model.cBusType = "普通销售"; model.cSource = "发货单"; model.cCode = sRdCode; model.cBusCode = sCode; if (sRdCode == "") { sRDCode = sRDCode + model.cRdCode; } else { sRDCode = sRDCode + "," + model.cRdCode; } model.cRdCode = dtDispatch.Rows[0]["cRdCode"].ToString().Trim(); if (model.cRdCode.Trim() == "") { throw new Exception("Please set saletype"); } //model.bIsLsQuery model.cWhCode = dtDispatch.Rows[0]["cWhCode"].ToString().Trim(); model.dDate = dNowDate; model.cDepCode = dtDispatch.Rows[0]["cDepCode"].ToString().Trim(); model.cSTCode = dtDispatch.Rows[0]["cSTCode"].ToString().Trim(); model.cCusCode = dtDispatch.Rows[0]["cCusCode"].ToString().Trim(); model.cDLCode = BaseFunction.ReturnLong(dtDispatch.Rows[0]["DLID"]); model.cMaker = sUserName; model.cDefine1 = dtDispatch.Rows[0]["cDefine1"].ToString().Trim(); model.cDefine2 = dtDispatch.Rows[0]["cDefine2"].ToString().Trim(); model.cDefine3 = dtDispatch.Rows[0]["cDefine3"].ToString().Trim(); model.cDefine4 = BaseFunction.ReturnDate(dtDispatch.Rows[0]["cDefine4"]); model.cDefine5 = BaseFunction.ReturnLong(dtDispatch.Rows[0]["cDefine5"]); model.cDefine6 = BaseFunction.ReturnDate(dtDispatch.Rows[0]["cDefine6"]); model.cDefine7 = BaseFunction.ReturnDecimal(dtDispatch.Rows[0]["cDefine7"]); model.cDefine8 = dtDispatch.Rows[0]["cDefine8"].ToString().Trim(); model.cDefine9 = dtDispatch.Rows[0]["cDefine9"].ToString().Trim(); model.cDefine10 = dtDispatch.Rows[0]["cDefine10"].ToString().Trim(); model.bpufirst = false; model.biafirst = false; model.VT_ID = 87; model.bIsSTQc = false; model.cDefine11 = dtDispatch.Rows[0]["cDefine11"].ToString().Trim(); model.cDefine12 = dtDispatch.Rows[0]["cDefine12"].ToString().Trim(); model.cDefine13 = dtDispatch.Rows[0]["cDefine13"].ToString().Trim(); model.cDefine14 = dtDispatch.Rows[0]["cDefine14"].ToString().Trim(); model.cDefine15 = BaseFunction.ReturnLong(dtDispatch.Rows[0]["cDefine15"]); model.cDefine16 = BaseFunction.ReturnDecimal(dtDispatch.Rows[0]["cDefine16"]); model.cShipAddress = dtDispatch.Rows[0]["cShipAddress"].ToString().Trim(); model.bOMFirst = false; model.bFromPreYear = false; model.bIsComplement = 0; model.iDiscountTaxType = 0; model.ireturncount = 0; model.iverifystate = 0; model.iswfcontrolled = 0; model.dnmaketime = dNow; model.dnverifytime = dNow; model.bredvouch = 0; model.iPrintCount = 0; model.cinvoicecompany = model.cCusCode; DAL.rdrecord32 dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecord32(); sSQL = dal.Add(model); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); for (int i = 0; i < dtDispatch.Rows.Count; i++) { Model.rdrecords32 models = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords32(); lIDDisDetails += 1; models.AutoID = lIDDisDetails; models.ID = lID; models.cInvCode = dtDispatch.Rows[i]["cInvCode"].ToString().Trim(); if (BaseFunction.ReturnDecimal(dtDispatch.Rows[i]["iNum"]) != 0) { models.iNum = BaseFunction.ReturnDecimal(dtDispatch.Rows[i]["iNum"]); models.iNNum = BaseFunction.ReturnDecimal(dtDispatch.Rows[i]["iNum"]); } models.iQuantity = BaseFunction.ReturnDecimal(dtDispatch.Rows[i]["iQuantity"]); models.cBatch = dtDispatch.Rows[i]["cBatch"].ToString().Trim(); models.iFlag = 0; models.cDefine22 = dtDispatch.Rows[i]["cDefine22"].ToString().Trim(); models.cDefine23 = dtDispatch.Rows[i]["cDefine23"].ToString().Trim(); models.cDefine24 = dtDispatch.Rows[i]["cDefine24"].ToString().Trim(); models.cDefine25 = dtDispatch.Rows[i]["cDefine25"].ToString().Trim(); models.cDefine26 = BaseFunction.ReturnDecimal(dtDispatch.Rows[i]["cDefine26"]); models.cDefine27 = BaseFunction.ReturnDecimal(dtDispatch.Rows[i]["cDefine27"]); models.cDefine28 = dtDispatch.Rows[i]["cDefine28"].ToString().Trim(); models.cDefine29 = dtDispatch.Rows[i]["cDefine29"].ToString().Trim(); models.cDefine30 = dtDispatch.Rows[i]["cDefine30"].ToString().Trim(); models.cDefine31 = dtDispatch.Rows[i]["cDefine31"].ToString().Trim(); models.cDefine32 = dtDispatch.Rows[i]["cDefine32"].ToString().Trim(); models.cDefine33 = dtDispatch.Rows[i]["cDefine33"].ToString().Trim(); models.cDefine34 = BaseFunction.ReturnInt(dtDispatch.Rows[i]["cDefine34"]); models.cDefine35 = BaseFunction.ReturnInt(dtDispatch.Rows[i]["cDefine35"]); models.cDefine36 = BaseFunction.ReturnDate(dtDispatch.Rows[i]["cDefine36"]); models.iDLsID = BaseFunction.ReturnLong(dtDispatch.Rows[i]["iDLsID"]); models.iNQuantity = BaseFunction.ReturnDecimal(dtDispatch.Rows[i]["iQuantity"]); models.bLPUseFree = false; models.iRSRowNO = 0; models.iOriTrackID = 0; models.bCosting = true; models.bVMIUsed = false; models.cbdlcode = sCode; models.iExpiratDateCalcu = 0; models.iorderdid = BaseFunction.ReturnInt(dtDispatch.Rows[i]["iSOsID"]); models.iordertype = 1; models.iordercode = dtDispatch.Rows[i]["cSourceCode"].ToString().Trim(); models.ipesotype = 0; models.ipesodid = dtDispatch.Rows[i]["cSourceCode"].ToString().Trim(); models.cpesocode = dtDispatch.Rows[i]["cSourceCode"].ToString().Trim(); models.ipesoseq = BaseFunction.ReturnInt(dtDispatch.Rows[i]["iorderrowno"]); models.iorderseq = BaseFunction.ReturnInt(dtDispatch.Rows[i]["iorderrowno"]); models.isotype = 0; models.irowno = i + 1; models.bIAcreatebill = false; models.bsaleoutcreatebill = false; models.isaleoutid = 0; models.bneedbill = true; DAL.rdrecords32 dals = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords32(); sSQL = dals.Add(models); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } if (lID > 1000000000) { lID = lID - 1000000000; } if (lIDDisDetails > 1000000000) { lIDDisDetails = lIDDisDetails - 1000000000; } sSQL = "update UFSystem..UA_Identity set iFatherId = " + lID.ToString() + ",iChildId = " + lIDDisDetails + " where cAcc_Id = '" + sAccID + "' and cVouchType = 'rd'"; DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" if exists(select * from VoucherHistory Where CardNumber='0303' and cContent is NULL) update VoucherHistory set cNumber = bbbbbb Where CardNumber='0303' and cContent is NULL else insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty) values('0303',null,null,null,'bbbbbb',0) "; sSQL = sSQL.Replace("aaaaaa", dNow.ToString("yyyy")); sSQL = sSQL.Replace("bbbbbb", lRdCode.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" exec IA_SP_WriteUnAccountVouchForST32 aaaaaa,N'32',N'发货单',N'普通销售' "; sSQL = sSQL.Replace("aaaaaa", lID.ToString()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" Update DispatchList SET cSaleOut=N'aaaaaa' WHERE DispatchList.DLID=bbbbbb "; sSQL = sSQL.Replace("aaaaaa", sRdCode); sSQL = sSQL.Replace("bbbbbb", dtDispatch.Rows[0]["DLID"].ToString().Trim()); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); return(sRdCode); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords32 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.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.iSBsID != null) { strSql1.Append("iSBsID,"); strSql2.Append("" + model.iSBsID + ","); } if (model.iSendQuantity != null) { strSql1.Append("iSendQuantity,"); strSql2.Append("" + model.iSendQuantity + ","); } if (model.iSendNum != null) { strSql1.Append("iSendNum,"); strSql2.Append("" + model.iSendNum + ","); } if (model.iEnsID != null) { strSql1.Append("iEnsID,"); strSql2.Append("" + model.iEnsID + ","); } 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.iRefundInspectFlag != null) { strSql1.Append("iRefundInspectFlag,"); strSql2.Append("" + model.iRefundInspectFlag + ","); } if (model.strContractId != null) { strSql1.Append("strContractId,"); strSql2.Append("'" + model.strContractId + "',"); } if (model.strCode != null) { strSql1.Append("strCode,"); strSql2.Append("'" + model.strCode + "',"); } 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.ipesodid != null) { strSql1.Append("ipesodid,"); strSql2.Append("'" + model.ipesodid + "',"); } if (model.ipesotype != null) { strSql1.Append("ipesotype,"); strSql2.Append("" + model.ipesotype + ","); } if (model.cpesocode != null) { strSql1.Append("cpesocode,"); strSql2.Append("'" + model.cpesocode + "',"); } if (model.ipesoseq != null) { strSql1.Append("ipesoseq,"); strSql2.Append("" + model.ipesoseq + ","); } 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.iDebitIDs != null) { strSql1.Append("iDebitIDs,"); strSql2.Append("" + model.iDebitIDs + ","); } if (model.fsettleqty != null) { strSql1.Append("fsettleqty,"); strSql2.Append("" + model.fsettleqty + ","); } if (model.fretqtywkp != null) { strSql1.Append("fretqtywkp,"); strSql2.Append("" + model.fretqtywkp + ","); } if (model.fretqtyykp != null) { strSql1.Append("fretqtyykp,"); strSql2.Append("" + model.fretqtyykp + ","); } if (model.cbsysbarcode != null) { strSql1.Append("cbsysbarcode,"); strSql2.Append("'" + model.cbsysbarcode + "',"); } if (model.bIAcreatebill != null) { strSql1.Append("bIAcreatebill,"); strSql2.Append("" + (model.bIAcreatebill ? 1 : 0) + ","); } if (model.bsaleoutcreatebill != null) { strSql1.Append("bsaleoutcreatebill,"); strSql2.Append("" + (model.bsaleoutcreatebill ? 1 : 0) + ","); } if (model.isaleoutid != null) { strSql1.Append("isaleoutid,"); strSql2.Append("" + model.isaleoutid + ","); } if (model.bneedbill != null) { strSql1.Append("bneedbill,"); strSql2.Append("" + (model.bneedbill ? 1 : 0) + ","); } strSql.Append("insert into rdrecords32("); 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()); }