/// <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.rdrecord32 model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.ID != null)
{
strSql1.Append("ID,");
strSql2.Append("" + model.ID + ",");
}
if (model.bRdFlag != null)
{
strSql1.Append("bRdFlag,");
strSql2.Append("" + model.bRdFlag + ",");
}
if (model.cVouchType != null)
{
strSql1.Append("cVouchType,");
strSql2.Append("'" + model.cVouchType + "',");
}
if (model.cBusType != null)
{
strSql1.Append("cBusType,");
strSql2.Append("'" + model.cBusType + "',");
}
if (model.cSource != null)
{
strSql1.Append("cSource,");
strSql2.Append("'" + model.cSource + "',");
}
if (model.cBusCode != null)
{
strSql1.Append("cBusCode,");
strSql2.Append("'" + model.cBusCode + "',");
}
if (model.cWhCode != null)
{
strSql1.Append("cWhCode,");
strSql2.Append("'" + model.cWhCode + "',");
}
if (model.dDate != null)
{
strSql1.Append("dDate,");
strSql2.Append("'" + model.dDate + "',");
}
if (model.cCode != null)
{
strSql1.Append("cCode,");
strSql2.Append("'" + model.cCode + "',");
}
if (model.cRdCode != null)
{
strSql1.Append("cRdCode,");
strSql2.Append("'" + model.cRdCode + "',");
}
if (model.cDepCode != null)
{
strSql1.Append("cDepCode,");
strSql2.Append("'" + model.cDepCode + "',");
}
if (model.cPersonCode != null)
{
strSql1.Append("cPersonCode,");
strSql2.Append("'" + model.cPersonCode + "',");
}
if (model.cPTCode != null)
{
strSql1.Append("cPTCode,");
strSql2.Append("'" + model.cPTCode + "',");
}
if (model.cSTCode != null)
{
strSql1.Append("cSTCode,");
strSql2.Append("'" + model.cSTCode + "',");
}
if (model.cCusCode != null)
{
strSql1.Append("cCusCode,");
strSql2.Append("'" + model.cCusCode + "',");
}
if (model.cVenCode != null)
{
strSql1.Append("cVenCode,");
strSql2.Append("'" + model.cVenCode + "',");
}
if (model.cOrderCode != null)
{
strSql1.Append("cOrderCode,");
strSql2.Append("'" + model.cOrderCode + "',");
}
if (model.cARVCode != null)
{
strSql1.Append("cARVCode,");
strSql2.Append("'" + model.cARVCode + "',");
}
if (model.cBillCode != null)
{
strSql1.Append("cBillCode,");
strSql2.Append("" + model.cBillCode + ",");
}
if (model.cDLCode != null)
{
strSql1.Append("cDLCode,");
strSql2.Append("" + model.cDLCode + ",");
}
if (model.cProBatch != null)
{
strSql1.Append("cProBatch,");
strSql2.Append("'" + model.cProBatch + "',");
}
if (model.cHandler != null)
{
strSql1.Append("cHandler,");
strSql2.Append("'" + model.cHandler + "',");
}
if (model.cMemo != null)
{
strSql1.Append("cMemo,");
strSql2.Append("'" + model.cMemo + "',");
}
if (model.bTransFlag != null)
{
strSql1.Append("bTransFlag,");
strSql2.Append("" + (model.bTransFlag ? 1 : 0) + ",");
}
if (model.cAccounter != null)
{
strSql1.Append("cAccounter,");
strSql2.Append("'" + model.cAccounter + "',");
}
if (model.cMaker != null)
{
strSql1.Append("cMaker,");
strSql2.Append("'" + model.cMaker + "',");
}
if (model.cDefine1 != null)
{
strSql1.Append("cDefine1,");
strSql2.Append("'" + model.cDefine1 + "',");
}
if (model.cDefine2 != null)
{
strSql1.Append("cDefine2,");
strSql2.Append("'" + model.cDefine2 + "',");
}
if (model.cDefine3 != null)
{
strSql1.Append("cDefine3,");
strSql2.Append("'" + model.cDefine3 + "',");
}
if (model.cDefine4 != null)
{
strSql1.Append("cDefine4,");
strSql2.Append("'" + model.cDefine4 + "',");
}
if (model.cDefine5 != null)
{
strSql1.Append("cDefine5,");
strSql2.Append("" + model.cDefine5 + ",");
}
if (model.cDefine6 != null)
{
strSql1.Append("cDefine6,");
strSql2.Append("'" + model.cDefine6 + "',");
}
if (model.cDefine7 != null)
{
strSql1.Append("cDefine7,");
strSql2.Append("" + model.cDefine7 + ",");
}
if (model.cDefine8 != null)
{
strSql1.Append("cDefine8,");
strSql2.Append("'" + model.cDefine8 + "',");
}
if (model.cDefine9 != null)
{
strSql1.Append("cDefine9,");
strSql2.Append("'" + model.cDefine9 + "',");
}
if (model.cDefine10 != null)
{
strSql1.Append("cDefine10,");
strSql2.Append("'" + model.cDefine10 + "',");
}
if (model.dKeepDate != null)
{
strSql1.Append("dKeepDate,");
strSql2.Append("'" + model.dKeepDate + "',");
}
if (model.dVeriDate != null)
{
strSql1.Append("dVeriDate,");
strSql2.Append("'" + model.dVeriDate + "',");
}
if (model.bpufirst != null)
{
strSql1.Append("bpufirst,");
strSql2.Append("" + (model.bpufirst ? 1 : 0) + ",");
}
if (model.biafirst != null)
{
strSql1.Append("biafirst,");
strSql2.Append("" + (model.biafirst ? 1 : 0) + ",");
}
if (model.iMQuantity != null)
{
strSql1.Append("iMQuantity,");
strSql2.Append("" + model.iMQuantity + ",");
}
if (model.dARVDate != null)
{
strSql1.Append("dARVDate,");
strSql2.Append("'" + model.dARVDate + "',");
}
if (model.cChkCode != null)
{
strSql1.Append("cChkCode,");
strSql2.Append("'" + model.cChkCode + "',");
}
if (model.dChkDate != null)
{
strSql1.Append("dChkDate,");
strSql2.Append("'" + model.dChkDate + "',");
}
if (model.cChkPerson != null)
{
strSql1.Append("cChkPerson,");
strSql2.Append("'" + model.cChkPerson + "',");
}
if (model.VT_ID != null)
{
strSql1.Append("VT_ID,");
strSql2.Append("" + model.VT_ID + ",");
}
if (model.bIsSTQc != null)
{
strSql1.Append("bIsSTQc,");
strSql2.Append("" + (model.bIsSTQc ? 1 : 0) + ",");
}
if (model.cDefine11 != null)
{
strSql1.Append("cDefine11,");
strSql2.Append("'" + model.cDefine11 + "',");
}
if (model.cDefine12 != null)
{
strSql1.Append("cDefine12,");
strSql2.Append("'" + model.cDefine12 + "',");
}
if (model.cDefine13 != null)
{
strSql1.Append("cDefine13,");
strSql2.Append("'" + model.cDefine13 + "',");
}
if (model.cDefine14 != null)
{
strSql1.Append("cDefine14,");
strSql2.Append("'" + model.cDefine14 + "',");
}
if (model.cDefine15 != null)
{
strSql1.Append("cDefine15,");
strSql2.Append("" + model.cDefine15 + ",");
}
if (model.cDefine16 != null)
{
strSql1.Append("cDefine16,");
strSql2.Append("" + model.cDefine16 + ",");
}
if (model.gspcheck != null)
{
strSql1.Append("gspcheck,");
strSql2.Append("'" + model.gspcheck + "',");
}
if (model.isalebillid != null)
{
strSql1.Append("isalebillid,");
strSql2.Append("'" + model.isalebillid + "',");
}
if (model.ufts != null)
{
strSql1.Append("ufts,");
strSql2.Append("" + model.ufts + ",");
}
if (model.iExchRate != null)
{
strSql1.Append("iExchRate,");
strSql2.Append("" + model.iExchRate + ",");
}
if (model.cExch_Name != null)
{
strSql1.Append("cExch_Name,");
strSql2.Append("'" + model.cExch_Name + "',");
}
if (model.cShipAddress != null)
{
strSql1.Append("cShipAddress,");
strSql2.Append("'" + model.cShipAddress + "',");
}
if (model.caddcode != null)
{
strSql1.Append("caddcode,");
strSql2.Append("'" + model.caddcode + "',");
}
if (model.bOMFirst != null)
{
strSql1.Append("bOMFirst,");
strSql2.Append("" + (model.bOMFirst ? 1 : 0) + ",");
}
if (model.bFromPreYear != null)
{
strSql1.Append("bFromPreYear,");
strSql2.Append("" + (model.bFromPreYear ? 1 : 0) + ",");
}
if (model.bIsLsQuery != null)
{
strSql1.Append("bIsLsQuery,");
strSql2.Append("" + (model.bIsLsQuery ? 1 : 0) + ",");
}
if (model.bIsComplement != null)
{
strSql1.Append("bIsComplement,");
strSql2.Append("" + model.bIsComplement + ",");
}
if (model.iDiscountTaxType != null)
{
strSql1.Append("iDiscountTaxType,");
strSql2.Append("" + model.iDiscountTaxType + ",");
}
if (model.ireturncount != null)
{
strSql1.Append("ireturncount,");
strSql2.Append("" + model.ireturncount + ",");
}
if (model.iverifystate != null)
{
strSql1.Append("iverifystate,");
strSql2.Append("" + model.iverifystate + ",");
}
if (model.iswfcontrolled != null)
{
strSql1.Append("iswfcontrolled,");
strSql2.Append("" + model.iswfcontrolled + ",");
}
if (model.cModifyPerson != null)
{
strSql1.Append("cModifyPerson,");
strSql2.Append("'" + model.cModifyPerson + "',");
}
if (model.dModifyDate != null)
{
strSql1.Append("dModifyDate,");
strSql2.Append("'" + model.dModifyDate + "',");
}
if (model.dnmaketime != null)
{
strSql1.Append("dnmaketime,");
strSql2.Append("'" + model.dnmaketime + "',");
}
if (model.dnmodifytime != null)
{
strSql1.Append("dnmodifytime,");
strSql2.Append("'" + model.dnmodifytime + "',");
}
if (model.dnverifytime != null)
{
strSql1.Append("dnverifytime,");
strSql2.Append("'" + model.dnverifytime + "',");
}
if (model.bredvouch != null)
{
strSql1.Append("bredvouch,");
strSql2.Append("" + model.bredvouch + ",");
}
if (model.iFlowId != null)
{
strSql1.Append("iFlowId,");
strSql2.Append("" + model.iFlowId + ",");
}
if (model.cPZID != null)
{
strSql1.Append("cPZID,");
strSql2.Append("'" + model.cPZID + "',");
}
if (model.cSourceLs != null)
{
strSql1.Append("cSourceLs,");
strSql2.Append("'" + model.cSourceLs + "',");
}
if (model.cSourceCodeLs != null)
{
strSql1.Append("cSourceCodeLs,");
strSql2.Append("'" + model.cSourceCodeLs + "',");
}
if (model.iPrintCount != null)
{
strSql1.Append("iPrintCount,");
strSql2.Append("" + model.iPrintCount + ",");
}
if (model.csysbarcode != null)
{
strSql1.Append("csysbarcode,");
strSql2.Append("'" + model.csysbarcode + "',");
}
if (model.cCurrentAuditor != null)
{
strSql1.Append("cCurrentAuditor,");
strSql2.Append("'" + model.cCurrentAuditor + "',");
}
if (model.cinvoicecompany != null)
{
strSql1.Append("cinvoicecompany,");
strSql2.Append("'" + model.cinvoicecompany + "',");
}
if (model.fEBweight != null)
{
strSql1.Append("fEBweight,");
strSql2.Append("" + model.fEBweight + ",");
}
if (model.cEBweightUnit != null)
{
strSql1.Append("cEBweightUnit,");
strSql2.Append("'" + model.cEBweightUnit + "',");
}
if (model.cEBExpressCode != null)
{
strSql1.Append("cEBExpressCode,");
strSql2.Append("'" + model.cEBExpressCode + "',");
}
if (model.bScanExpress != null)
{
strSql1.Append("bScanExpress,");
strSql2.Append("" + model.bScanExpress + ",");
}
strSql.Append("insert into rdrecord32(");
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());
}
