/// <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);
}
}
