/// <summary> ///Save,保存方法,先删除,再增加 /// </summary> public void Save(RdRecords01 model, SqlTransaction tran = null, params string[] str) { string tran_flag = "1"; SqlConnection conn = new SqlConnection(Dal.DataHelper.constr); conn.Open(); if (tran == null) { tran_flag = "0"; tran = conn.BeginTransaction(); } try { Delete(model, tran, str); Add(model, tran); //如果传入事物,提交否则外层提交 if (tran_flag == "0") { tran.Commit(); conn.Close(); } } catch (Exception e) { if (tran_flag == "0") { tran.Rollback(); conn.Close(); } throw e; } }
//生成子表list 对应赋值 public List <RdRecords01> ZbsListMaker(List <MyRdRecords01> mylist) { List <RdRecords01> list = new List <RdRecords01>(); foreach (var i in mylist) { RdRecords01 m = new RdRecords01(); m.cInvCode = i.goods_code; m.iQuantity = i.number; m.ioriSum = i.number * i.unit_price; //原币价税合计 m.iOriMoney = Math.Round((decimal)(m.ioriSum / (1 + i.iTaxRate)), 2); //原币无税金额 m.iOriTaxPrice = m.ioriSum - m.iOriMoney; //原币税额 m.iUnitCost = Math.Round((decimal)m.iOriMoney / i.number, 2); //无税单价 m.iPrice = m.iOriMoney; //无税金额 m.iAPrice = m.iPrice; //暂估金额 m.iSQuantity = 0; //累计结算数量 m.iSNum = 0; //累计结算辅计量数量 m.iMoney = 0; //累计结算金额 m.fACost = m.iUnitCost; //暂估单价 m.iOriTaxCost = i.unit_price; //原币含税单价 m.iOriCost = m.iUnitCost; //原币无税单价 m.iTaxRate = i.iTaxRate; //税率 m.iTaxPrice = m.iOriTaxPrice; //本币税额 m.iSum = m.ioriSum; //本币价税合计 m.chVencode = i.u8_cVenCode; m.iSumBillQuantity = 0; //累计开票数量 list.Add(m); } return(list); }
/// <summary> /// 增加一条数据 /// </summary> public override void Add(dynamic obj, SqlTransaction tran = null) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into rdrecords01("); strSql.Append("AutoID,iPPrice,iMatSettleState,iBillSettleCount,bLPUseFree,iOriTrackID,coritracktype,cbaccounter,dbKeepDate,bCosting,iSumBillQuantity,bVMIUsed,cBatch,iVMISettleQuantity,iVMISettleNum,cvmivencode,iInvSNCount,cwhpersoncode,cwhpersonname,impcost,iIMOSID,iIMBSID,cbarvcode,cVouchCode,dbarvdate,iinvexchrate,corufts,comcode,iExpiratDateCalcu,cExpirationdate,dExpirationdate,cciqbookcode,iBondedSumQty,cInVouchCode,iordertype,iorderdid,iordercode,iorderseq,isodid,isotype,csocode,isoseq,cBatchProperty1,cBatchProperty2,cinvouchtype,cBatchProperty3,cBatchProperty4,cBatchProperty5,cBatchProperty6,cBatchProperty7,cBatchProperty8,cBatchProperty9,cBatchProperty10,cbMemo,iFaQty,iSOutQuantity,isTax,irowno,ipreuseqty,ipreuseinum,iDebitIDs,OutCopiedQuantity,iOldPartId,fOldQuantity,iSOutNum,cbsysbarcode,bmergecheck,iMergeCheckAutoId,bnoitemused,cReworkMOCode,iReworkMODetailsid,iProductType,cMainInvCode,iMainMoDetailsID,iShareMaterialFee,cFree1,cplanlotcode,bgift,iposflag,GCSourceId,GCSourceIds,GCUpCardNum,GCUpId,GCUpIds,cFree2,iFlag,ID,dSDate,iTax,iSQuantity,iSNum,iMoney,iFNum,iFQuantity,dVDate,cPosition,cDefine22,cInvCode,cDefine23,cDefine24,cDefine25,cDefine26,cDefine27,cItem_class,cItemCode,iPOsID,fACost,cName,iNum,cItemCName,cFree3,cFree4,cFree5,cFree6,cFree7,cFree8,cFree9,cFree10,cBarCode,iQuantity,iNQuantity,iNNum,cAssUnit,dMadeDate,iMassDate,cDefine28,cDefine29,cDefine30,cDefine31,cDefine32,iUnitCost,cDefine33,cDefine34,cDefine35,cDefine36,cDefine37,iCheckIds,cBVencode,chVencode,bGsp,cGspState,iPrice,iArrsId,cCheckCode,iCheckIdBaks,cRejectCode,iRejectIds,cCheckPersonCode,dCheckDate,iOriTaxCost,iOriCost,iOriMoney,iAPrice,iOriTaxPrice,ioriSum,iTaxRate,iTaxPrice,iSum,bTaxCost,cPOID,cMassUnit,iMaterialFee,iProcessCost,iPUnitCost,iProcessFee,dMSDate,iSMaterialFee,iSProcessFee,iOMoDID,strContractId,strCode,bChecked,bRelated,iOMoMID"); strSql.Append(") values ("); strSql.Append("@AutoID,@iPPrice,@iMatSettleState,@iBillSettleCount,@bLPUseFree,@iOriTrackID,@coritracktype,@cbaccounter,@dbKeepDate,@bCosting,@iSumBillQuantity,@bVMIUsed,@cBatch,@iVMISettleQuantity,@iVMISettleNum,@cvmivencode,@iInvSNCount,@cwhpersoncode,@cwhpersonname,@impcost,@iIMOSID,@iIMBSID,@cbarvcode,@cVouchCode,@dbarvdate,@iinvexchrate,@corufts,@comcode,@iExpiratDateCalcu,@cExpirationdate,@dExpirationdate,@cciqbookcode,@iBondedSumQty,@cInVouchCode,@iordertype,@iorderdid,@iordercode,@iorderseq,@isodid,@isotype,@csocode,@isoseq,@cBatchProperty1,@cBatchProperty2,@cinvouchtype,@cBatchProperty3,@cBatchProperty4,@cBatchProperty5,@cBatchProperty6,@cBatchProperty7,@cBatchProperty8,@cBatchProperty9,@cBatchProperty10,@cbMemo,@iFaQty,@iSOutQuantity,@isTax,@irowno,@ipreuseqty,@ipreuseinum,@iDebitIDs,@OutCopiedQuantity,@iOldPartId,@fOldQuantity,@iSOutNum,@cbsysbarcode,@bmergecheck,@iMergeCheckAutoId,@bnoitemused,@cReworkMOCode,@iReworkMODetailsid,@iProductType,@cMainInvCode,@iMainMoDetailsID,@iShareMaterialFee,@cFree1,@cplanlotcode,@bgift,@iposflag,@GCSourceId,@GCSourceIds,@GCUpCardNum,@GCUpId,@GCUpIds,@cFree2,@iFlag,@ID,@dSDate,@iTax,@iSQuantity,@iSNum,@iMoney,@iFNum,@iFQuantity,@dVDate,@cPosition,@cDefine22,@cInvCode,@cDefine23,@cDefine24,@cDefine25,@cDefine26,@cDefine27,@cItem_class,@cItemCode,@iPOsID,@fACost,@cName,@iNum,@cItemCName,@cFree3,@cFree4,@cFree5,@cFree6,@cFree7,@cFree8,@cFree9,@cFree10,@cBarCode,@iQuantity,@iNQuantity,@iNNum,@cAssUnit,@dMadeDate,@iMassDate,@cDefine28,@cDefine29,@cDefine30,@cDefine31,@cDefine32,@iUnitCost,@cDefine33,@cDefine34,@cDefine35,@cDefine36,@cDefine37,@iCheckIds,@cBVencode,@chVencode,@bGsp,@cGspState,@iPrice,@iArrsId,@cCheckCode,@iCheckIdBaks,@cRejectCode,@iRejectIds,@cCheckPersonCode,@dCheckDate,@iOriTaxCost,@iOriCost,@iOriMoney,@iAPrice,@iOriTaxPrice,@ioriSum,@iTaxRate,@iTaxPrice,@iSum,@bTaxCost,@cPOID,@cMassUnit,@iMaterialFee,@iProcessCost,@iPUnitCost,@iProcessFee,@dMSDate,@iSMaterialFee,@iSProcessFee,@iOMoDID,@strContractId,@strCode,@bChecked,@bRelated,@iOMoMID"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@AutoID", SqlDbType.BigInt, 8), new SqlParameter("@iPPrice", SqlDbType.Money, 8), new SqlParameter("@iMatSettleState", SqlDbType.Int, 4), new SqlParameter("@iBillSettleCount", SqlDbType.Int, 4), new SqlParameter("@bLPUseFree", SqlDbType.Bit, 1), new SqlParameter("@iOriTrackID", SqlDbType.BigInt, 8), new SqlParameter("@coritracktype", SqlDbType.NVarChar, 2), new SqlParameter("@cbaccounter", SqlDbType.NVarChar, 30), new SqlParameter("@dbKeepDate", SqlDbType.DateTime), new SqlParameter("@bCosting", SqlDbType.Bit, 1), new SqlParameter("@iSumBillQuantity", SqlDbType.Decimal, 17), new SqlParameter("@bVMIUsed", SqlDbType.Bit, 1), new SqlParameter("@cBatch", SqlDbType.NVarChar, 60), new SqlParameter("@iVMISettleQuantity", SqlDbType.Decimal, 17), new SqlParameter("@iVMISettleNum", SqlDbType.Decimal, 17), new SqlParameter("@cvmivencode", SqlDbType.NVarChar, 20), new SqlParameter("@iInvSNCount", SqlDbType.Int, 4), new SqlParameter("@cwhpersoncode", SqlDbType.NVarChar, 20), new SqlParameter("@cwhpersonname", SqlDbType.NVarChar, 50), new SqlParameter("@impcost", SqlDbType.Decimal, 17), new SqlParameter("@iIMOSID", SqlDbType.Int, 4), new SqlParameter("@iIMBSID", SqlDbType.Int, 4), new SqlParameter("@cbarvcode", SqlDbType.NVarChar, 30), new SqlParameter("@cVouchCode", SqlDbType.BigInt, 8), new SqlParameter("@dbarvdate", SqlDbType.NVarChar, 30), new SqlParameter("@iinvexchrate", SqlDbType.Decimal, 17), new SqlParameter("@corufts", SqlDbType.VarChar, 16), new SqlParameter("@comcode", SqlDbType.NVarChar, 30), new SqlParameter("@strContractGUID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@iExpiratDateCalcu", SqlDbType.SmallInt, 2), new SqlParameter("@cExpirationdate", SqlDbType.VarChar, 10), new SqlParameter("@dExpirationdate", SqlDbType.DateTime), new SqlParameter("@cciqbookcode", SqlDbType.NVarChar, 20), new SqlParameter("@iBondedSumQty", SqlDbType.Decimal, 17), new SqlParameter("@cInVouchCode", SqlDbType.NVarChar, 30), new SqlParameter("@iordertype", SqlDbType.TinyInt, 1), new SqlParameter("@iorderdid", SqlDbType.Int, 4), new SqlParameter("@iordercode", SqlDbType.NVarChar, 30), new SqlParameter("@iorderseq", SqlDbType.Int, 4), new SqlParameter("@isodid", SqlDbType.NVarChar, 40), new SqlParameter("@isotype", SqlDbType.TinyInt, 1), new SqlParameter("@csocode", SqlDbType.NVarChar, 40), new SqlParameter("@isoseq", SqlDbType.Int, 4), new SqlParameter("@cBatchProperty1", SqlDbType.Decimal, 17), new SqlParameter("@cBatchProperty2", SqlDbType.Decimal, 17), new SqlParameter("@cinvouchtype", SqlDbType.NVarChar, 2), new SqlParameter("@cBatchProperty3", SqlDbType.Decimal, 17), new SqlParameter("@cBatchProperty4", SqlDbType.Decimal, 17), new SqlParameter("@cBatchProperty5", SqlDbType.Decimal, 17), new SqlParameter("@cBatchProperty6", SqlDbType.NVarChar, 120), new SqlParameter("@cBatchProperty7", SqlDbType.NVarChar, 120), new SqlParameter("@cBatchProperty8", SqlDbType.NVarChar, 120), new SqlParameter("@cBatchProperty9", SqlDbType.NVarChar, 120), new SqlParameter("@cBatchProperty10", SqlDbType.DateTime), new SqlParameter("@cbMemo", SqlDbType.NVarChar, 255), new SqlParameter("@iFaQty", SqlDbType.Decimal, 17), new SqlParameter("@iSOutQuantity", SqlDbType.Decimal, 17), new SqlParameter("@isTax", SqlDbType.Decimal, 17), new SqlParameter("@irowno", SqlDbType.Int, 4), new SqlParameter("@strowguid", SqlDbType.UniqueIdentifier, 16), //new SqlParameter("@rowufts", SqlDbType.Timestamp,8) , new SqlParameter("@ipreuseqty", SqlDbType.Decimal, 17), new SqlParameter("@ipreuseinum", SqlDbType.Decimal, 17), new SqlParameter("@iDebitIDs", SqlDbType.Int, 4), new SqlParameter("@OutCopiedQuantity", SqlDbType.Decimal, 17), new SqlParameter("@iOldPartId", SqlDbType.Int, 4), new SqlParameter("@fOldQuantity", SqlDbType.Decimal, 17), new SqlParameter("@iSOutNum", SqlDbType.Decimal, 17), new SqlParameter("@cbsysbarcode", SqlDbType.NVarChar, 80), new SqlParameter("@bmergecheck", SqlDbType.Bit, 1), new SqlParameter("@iMergeCheckAutoId", SqlDbType.Int, 4), new SqlParameter("@bnoitemused", SqlDbType.TinyInt, 1), new SqlParameter("@cReworkMOCode", SqlDbType.NVarChar, 30), new SqlParameter("@iReworkMODetailsid", SqlDbType.Int, 4), new SqlParameter("@iProductType", SqlDbType.Int, 4), new SqlParameter("@cMainInvCode", SqlDbType.NVarChar, 30), new SqlParameter("@iMainMoDetailsID", SqlDbType.Int, 4), new SqlParameter("@iShareMaterialFee", SqlDbType.Decimal, 17), new SqlParameter("@cFree1", SqlDbType.NVarChar, 20), new SqlParameter("@cplanlotcode", SqlDbType.NVarChar, 80), new SqlParameter("@bgift", SqlDbType.SmallInt, 2), new SqlParameter("@iposflag", SqlDbType.SmallInt, 2), new SqlParameter("@GCSourceId", SqlDbType.Int, 4), new SqlParameter("@GCSourceIds", SqlDbType.Int, 4), new SqlParameter("@GCUpCardNum", SqlDbType.NVarChar, 100), new SqlParameter("@GCUpId", SqlDbType.Int, 4), new SqlParameter("@GCUpIds", SqlDbType.Int, 4), new SqlParameter("@cFree2", SqlDbType.NVarChar, 20), new SqlParameter("@iFlag", SqlDbType.TinyInt, 1), new SqlParameter("@ID", SqlDbType.BigInt, 8), new SqlParameter("@dSDate", SqlDbType.DateTime), new SqlParameter("@iTax", SqlDbType.Money, 8), new SqlParameter("@iSQuantity", SqlDbType.Decimal, 17), new SqlParameter("@iSNum", SqlDbType.Decimal, 17), new SqlParameter("@iMoney", SqlDbType.Money, 8), new SqlParameter("@iFNum", SqlDbType.Decimal, 17), new SqlParameter("@iFQuantity", SqlDbType.Decimal, 17), new SqlParameter("@dVDate", SqlDbType.DateTime), new SqlParameter("@cPosition", SqlDbType.NVarChar, 20), new SqlParameter("@cDefine22", SqlDbType.NVarChar, 60), new SqlParameter("@cInvCode", SqlDbType.NVarChar, 60), new SqlParameter("@cDefine23", SqlDbType.NVarChar, 60), new SqlParameter("@cDefine24", SqlDbType.NVarChar, 60), new SqlParameter("@cDefine25", SqlDbType.NVarChar, 60), new SqlParameter("@cDefine26", SqlDbType.Float, 8), new SqlParameter("@cDefine27", SqlDbType.Float, 8), new SqlParameter("@cItem_class", SqlDbType.NVarChar, 10), new SqlParameter("@cItemCode", SqlDbType.NVarChar, 60), new SqlParameter("@iPOsID", SqlDbType.BigInt, 8), new SqlParameter("@fACost", SqlDbType.Decimal, 17), new SqlParameter("@cName", SqlDbType.NVarChar, 255), new SqlParameter("@iNum", SqlDbType.Decimal, 17), new SqlParameter("@cItemCName", SqlDbType.NVarChar, 20), new SqlParameter("@cFree3", SqlDbType.NVarChar, 20), new SqlParameter("@cFree4", SqlDbType.NVarChar, 20), new SqlParameter("@cFree5", SqlDbType.NVarChar, 20), new SqlParameter("@cFree6", SqlDbType.NVarChar, 20), new SqlParameter("@cFree7", SqlDbType.NVarChar, 20), new SqlParameter("@cFree8", SqlDbType.NVarChar, 20), new SqlParameter("@cFree9", SqlDbType.NVarChar, 20), new SqlParameter("@cFree10", SqlDbType.NVarChar, 20), new SqlParameter("@cBarCode", SqlDbType.NVarChar, 200), new SqlParameter("@iQuantity", SqlDbType.Decimal, 17), new SqlParameter("@iNQuantity", SqlDbType.Decimal, 17), new SqlParameter("@iNNum", SqlDbType.Decimal, 17), new SqlParameter("@cAssUnit", SqlDbType.NVarChar, 35), new SqlParameter("@dMadeDate", SqlDbType.DateTime), new SqlParameter("@iMassDate", SqlDbType.Int, 4), new SqlParameter("@cDefine28", SqlDbType.NVarChar, 120), new SqlParameter("@cDefine29", SqlDbType.NVarChar, 120), new SqlParameter("@cDefine30", SqlDbType.NVarChar, 120), new SqlParameter("@cDefine31", SqlDbType.NVarChar, 120), new SqlParameter("@cDefine32", SqlDbType.NVarChar, 120), new SqlParameter("@iUnitCost", SqlDbType.Decimal, 17), new SqlParameter("@cDefine33", SqlDbType.NVarChar, 120), new SqlParameter("@cDefine34", SqlDbType.Int, 4), new SqlParameter("@cDefine35", SqlDbType.Int, 4), new SqlParameter("@cDefine36", SqlDbType.DateTime), new SqlParameter("@cDefine37", SqlDbType.DateTime), new SqlParameter("@iCheckIds", SqlDbType.BigInt, 8), new SqlParameter("@cBVencode", SqlDbType.NVarChar, 20), new SqlParameter("@chVencode", SqlDbType.NVarChar, 20), new SqlParameter("@bGsp", SqlDbType.Bit, 1), new SqlParameter("@cGspState", SqlDbType.NVarChar, 20), new SqlParameter("@iPrice", SqlDbType.Money, 8), new SqlParameter("@iArrsId", SqlDbType.BigInt, 8), new SqlParameter("@cCheckCode", SqlDbType.NVarChar, 30), new SqlParameter("@iCheckIdBaks", SqlDbType.BigInt, 8), new SqlParameter("@cRejectCode", SqlDbType.NVarChar, 30), new SqlParameter("@iRejectIds", SqlDbType.BigInt, 8), new SqlParameter("@cCheckPersonCode", SqlDbType.NVarChar, 20), new SqlParameter("@dCheckDate", SqlDbType.DateTime), new SqlParameter("@iOriTaxCost", SqlDbType.Decimal, 13), new SqlParameter("@iOriCost", SqlDbType.Decimal, 13), new SqlParameter("@iOriMoney", SqlDbType.Money, 8), new SqlParameter("@iAPrice", SqlDbType.Money, 8), new SqlParameter("@iOriTaxPrice", SqlDbType.Money, 8), new SqlParameter("@ioriSum", SqlDbType.Money, 8), new SqlParameter("@iTaxRate", SqlDbType.Decimal, 13), new SqlParameter("@iTaxPrice", SqlDbType.Money, 8), new SqlParameter("@iSum", SqlDbType.Money, 8), new SqlParameter("@bTaxCost", SqlDbType.Bit, 1), new SqlParameter("@cPOID", SqlDbType.NVarChar, 30), new SqlParameter("@cMassUnit", SqlDbType.SmallInt, 2), new SqlParameter("@iMaterialFee", SqlDbType.Money, 8), new SqlParameter("@iProcessCost", SqlDbType.Decimal, 17), new SqlParameter("@iPUnitCost", SqlDbType.Decimal, 17), new SqlParameter("@iProcessFee", SqlDbType.Money, 8), new SqlParameter("@dMSDate", SqlDbType.DateTime), new SqlParameter("@iSMaterialFee", SqlDbType.Money, 8), new SqlParameter("@iSProcessFee", SqlDbType.Money, 8), new SqlParameter("@iOMoDID", SqlDbType.Int, 4), new SqlParameter("@strContractId", SqlDbType.NVarChar, 64), new SqlParameter("@strCode", SqlDbType.NVarChar, 150), new SqlParameter("@bChecked", SqlDbType.Bit, 1), new SqlParameter("@bRelated", SqlDbType.Bit, 1), new SqlParameter("@iOMoMID", SqlDbType.BigInt, 8) }; RdRecords01 model = (RdRecords01)obj; parameters[0].Value = SqlNull(model.AutoID); parameters[1].Value = SqlNull(model.iPPrice); parameters[2].Value = SqlNull(model.iMatSettleState); parameters[3].Value = SqlNull(model.iBillSettleCount); parameters[4].Value = SqlNull(model.bLPUseFree); parameters[5].Value = SqlNull(model.iOriTrackID); parameters[6].Value = SqlNull(model.coritracktype); parameters[7].Value = SqlNull(model.cbaccounter); parameters[8].Value = SqlNull(model.dbKeepDate); parameters[9].Value = SqlNull(model.bCosting); parameters[10].Value = SqlNull(model.iSumBillQuantity); parameters[11].Value = SqlNull(model.bVMIUsed); parameters[12].Value = SqlNull(model.cBatch); parameters[13].Value = SqlNull(model.iVMISettleQuantity); parameters[14].Value = SqlNull(model.iVMISettleNum); parameters[15].Value = SqlNull(model.cvmivencode); parameters[16].Value = SqlNull(model.iInvSNCount); parameters[17].Value = SqlNull(model.cwhpersoncode); parameters[18].Value = SqlNull(model.cwhpersonname); parameters[19].Value = SqlNull(model.impcost); parameters[20].Value = SqlNull(model.iIMOSID); parameters[21].Value = SqlNull(model.iIMBSID); parameters[22].Value = SqlNull(model.cbarvcode); parameters[23].Value = SqlNull(model.cVouchCode); parameters[24].Value = SqlNull(model.dbarvdate); parameters[25].Value = SqlNull(model.iinvexchrate); parameters[26].Value = SqlNull(model.corufts); parameters[27].Value = SqlNull(model.comcode); parameters[28].Value = SqlNull(model.strContractGUID); parameters[29].Value = SqlNull(model.iExpiratDateCalcu); parameters[30].Value = SqlNull(model.cExpirationdate); parameters[31].Value = SqlNull(model.dExpirationdate); parameters[32].Value = SqlNull(model.cciqbookcode); parameters[33].Value = SqlNull(model.iBondedSumQty); parameters[34].Value = SqlNull(model.cInVouchCode); parameters[35].Value = SqlNull(model.iordertype); parameters[36].Value = SqlNull(model.iorderdid); parameters[37].Value = SqlNull(model.iordercode); parameters[38].Value = SqlNull(model.iorderseq); parameters[39].Value = SqlNull(model.isodid); parameters[40].Value = SqlNull(model.isotype); parameters[41].Value = SqlNull(model.csocode); parameters[42].Value = SqlNull(model.isoseq); parameters[43].Value = SqlNull(model.cBatchProperty1); parameters[44].Value = SqlNull(model.cBatchProperty2); parameters[45].Value = SqlNull(model.cinvouchtype); parameters[46].Value = SqlNull(model.cBatchProperty3); parameters[47].Value = SqlNull(model.cBatchProperty4); parameters[48].Value = SqlNull(model.cBatchProperty5); parameters[49].Value = SqlNull(model.cBatchProperty6); parameters[50].Value = SqlNull(model.cBatchProperty7); parameters[51].Value = SqlNull(model.cBatchProperty8); parameters[52].Value = SqlNull(model.cBatchProperty9); parameters[53].Value = SqlNull(model.cBatchProperty10); parameters[54].Value = SqlNull(model.cbMemo); parameters[55].Value = SqlNull(model.iFaQty); parameters[56].Value = SqlNull(model.iSOutQuantity); parameters[57].Value = SqlNull(model.isTax); parameters[58].Value = SqlNull(model.irowno); parameters[59].Value = SqlNull(model.strowguid); //parameters[60].Value = SqlNull(model.rowufts); parameters[60].Value = SqlNull(model.ipreuseqty); parameters[61].Value = SqlNull(model.ipreuseinum); parameters[62].Value = SqlNull(model.iDebitIDs); parameters[63].Value = SqlNull(model.OutCopiedQuantity); parameters[64].Value = SqlNull(model.iOldPartId); parameters[65].Value = SqlNull(model.fOldQuantity); parameters[66].Value = SqlNull(model.iSOutNum); parameters[67].Value = SqlNull(model.cbsysbarcode); parameters[68].Value = SqlNull(model.bmergecheck); parameters[69].Value = SqlNull(model.iMergeCheckAutoId); parameters[70].Value = SqlNull(model.bnoitemused); parameters[71].Value = SqlNull(model.cReworkMOCode); parameters[72].Value = SqlNull(model.iReworkMODetailsid); parameters[73].Value = SqlNull(model.iProductType); parameters[74].Value = SqlNull(model.cMainInvCode); parameters[75].Value = SqlNull(model.iMainMoDetailsID); parameters[76].Value = SqlNull(model.iShareMaterialFee); parameters[77].Value = SqlNull(model.cFree1); parameters[78].Value = SqlNull(model.cplanlotcode); parameters[79].Value = SqlNull(model.bgift); parameters[80].Value = SqlNull(model.iposflag); parameters[81].Value = SqlNull(model.GCSourceId); parameters[82].Value = SqlNull(model.GCSourceIds); parameters[83].Value = SqlNull(model.GCUpCardNum); parameters[84].Value = SqlNull(model.GCUpId); parameters[85].Value = SqlNull(model.GCUpIds); parameters[86].Value = SqlNull(model.cFree2); parameters[87].Value = SqlNull(model.iFlag); parameters[88].Value = SqlNull(model.ID); parameters[89].Value = SqlNull(model.dSDate); parameters[90].Value = SqlNull(model.iTax); parameters[91].Value = SqlNull(model.iSQuantity); parameters[92].Value = SqlNull(model.iSNum); parameters[93].Value = SqlNull(model.iMoney); parameters[94].Value = SqlNull(model.iFNum); parameters[95].Value = SqlNull(model.iFQuantity); parameters[96].Value = SqlNull(model.dVDate); parameters[97].Value = SqlNull(model.cPosition); parameters[98].Value = SqlNull(model.cDefine22); parameters[99].Value = SqlNull(model.cInvCode); parameters[100].Value = SqlNull(model.cDefine23); parameters[101].Value = SqlNull(model.cDefine24); parameters[102].Value = SqlNull(model.cDefine25); parameters[103].Value = SqlNull(model.cDefine26); parameters[104].Value = SqlNull(model.cDefine27); parameters[105].Value = SqlNull(model.cItem_class); parameters[106].Value = SqlNull(model.cItemCode); parameters[107].Value = SqlNull(model.iPOsID); parameters[108].Value = SqlNull(model.fACost); parameters[109].Value = SqlNull(model.cName); parameters[110].Value = SqlNull(model.iNum); parameters[111].Value = SqlNull(model.cItemCName); parameters[112].Value = SqlNull(model.cFree3); parameters[113].Value = SqlNull(model.cFree4); parameters[114].Value = SqlNull(model.cFree5); parameters[115].Value = SqlNull(model.cFree6); parameters[116].Value = SqlNull(model.cFree7); parameters[117].Value = SqlNull(model.cFree8); parameters[118].Value = SqlNull(model.cFree9); parameters[119].Value = SqlNull(model.cFree10); parameters[120].Value = SqlNull(model.cBarCode); parameters[121].Value = SqlNull(model.iQuantity); parameters[122].Value = SqlNull(model.iNQuantity); parameters[123].Value = SqlNull(model.iNNum); parameters[124].Value = SqlNull(model.cAssUnit); parameters[125].Value = SqlNull(model.dMadeDate); parameters[126].Value = SqlNull(model.iMassDate); parameters[127].Value = SqlNull(model.cDefine28); parameters[128].Value = SqlNull(model.cDefine29); parameters[129].Value = SqlNull(model.cDefine30); parameters[130].Value = SqlNull(model.cDefine31); parameters[131].Value = SqlNull(model.cDefine32); parameters[132].Value = SqlNull(model.iUnitCost); parameters[133].Value = SqlNull(model.cDefine33); parameters[134].Value = SqlNull(model.cDefine34); parameters[135].Value = SqlNull(model.cDefine35); parameters[136].Value = SqlNull(model.cDefine36); parameters[137].Value = SqlNull(model.cDefine37); parameters[138].Value = SqlNull(model.iCheckIds); parameters[139].Value = SqlNull(model.cBVencode); parameters[140].Value = SqlNull(model.chVencode); parameters[141].Value = SqlNull(model.bGsp); parameters[142].Value = SqlNull(model.cGspState); parameters[143].Value = SqlNull(model.iPrice); parameters[144].Value = SqlNull(model.iArrsId); parameters[145].Value = SqlNull(model.cCheckCode); parameters[146].Value = SqlNull(model.iCheckIdBaks); parameters[147].Value = SqlNull(model.cRejectCode); parameters[148].Value = SqlNull(model.iRejectIds); parameters[149].Value = SqlNull(model.cCheckPersonCode); parameters[150].Value = SqlNull(model.dCheckDate); parameters[151].Value = SqlNull(model.iOriTaxCost); parameters[152].Value = SqlNull(model.iOriCost); parameters[153].Value = SqlNull(model.iOriMoney); parameters[154].Value = SqlNull(model.iAPrice); parameters[155].Value = SqlNull(model.iOriTaxPrice); parameters[156].Value = SqlNull(model.ioriSum); parameters[157].Value = SqlNull(model.iTaxRate); parameters[158].Value = SqlNull(model.iTaxPrice); parameters[159].Value = SqlNull(model.iSum); parameters[160].Value = SqlNull(model.bTaxCost); parameters[161].Value = SqlNull(model.cPOID); parameters[162].Value = SqlNull(model.cMassUnit); parameters[163].Value = SqlNull(model.iMaterialFee); parameters[164].Value = SqlNull(model.iProcessCost); parameters[165].Value = SqlNull(model.iPUnitCost); parameters[166].Value = SqlNull(model.iProcessFee); parameters[167].Value = SqlNull(model.dMSDate); parameters[168].Value = SqlNull(model.iSMaterialFee); parameters[169].Value = SqlNull(model.iSProcessFee); parameters[170].Value = SqlNull(model.iOMoDID); parameters[171].Value = SqlNull(model.strContractId); parameters[172].Value = SqlNull(model.strCode); parameters[173].Value = SqlNull(model.bChecked); parameters[174].Value = SqlNull(model.bRelated); parameters[175].Value = SqlNull(model.iOMoMID); if (tran == null) { DataHelper.ExcuteNonQuery(strSql.ToString(), parameters, false); } else { DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false); } }