//U8V11.1
public int TransVouch_Audit_U8V111(SqlTransaction tran, string sCode, string sAccID, string sUserName)
{
string sErr = "";
int iCou = 0;
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 = @"
SELECT *
FROM dbo.TransVouch a INNER JOIN dbo.TransVouchs b ON a.ID = b.ID
WHERE a.cTVCode = 'aaaaaaaa'
";
sSQL = sSQL.Replace("aaaaaaaa", sCode);
DataTable dtTr = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
if (dtTr == null || dtTr.Rows.Count == 0)
{
throw new Exception("Audit err");
}
DateTime dtmCode = BaseFunction.ReturnDate(dtTr.Rows[0]["dVerifyDate"]);
//审核调拨单
sSQL = @"UPDATE TransVouch SET cVerifyPerson = 'aaaaaa',dVerifyDate = 'bbbbbb',dnverifytime = 'cccccc' WHERE cTVCode = 'dddddd'";
sSQL = sSQL.Replace("aaaaaa", sUserName);
sSQL = sSQL.Replace("bbbbbb", dNow.ToString("yyyy-MM-dd"));
sSQL = sSQL.Replace("cccccc", dNow.ToString("yyyy-MM-dd HH:mm:ss"));
sSQL = sSQL.Replace("dddddd", sCode);
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
long lID = -1;
long lIDDetails = -1;
sSQL = @"
declare @p5 int
set @p5=aaaaaa
declare @p6 int
set @p6=bbbbbb
exec sp_GetId N'00',N'dddddd',N'rd',1,@p5 output,@p6 output,default
select @p5, @p6
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
sSQL = sSQL.Replace("bbbbbb", lIDDetails.ToString());
sSQL = sSQL.Replace("dddddd", sAccID);
DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
lID = BaseFunction.ReturnLong(dt.Rows[0][0]) - 1;
lIDDetails = BaseFunction.ReturnLong(dt.Rows[0][1]) - 1;
#region 其他入库单
//获得单据号
sSQL = "select cNumber from VoucherHistory with (ROWLOCK) WHERE (CardNumber = '0301') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'aaaaaa') ORDER BY cNumber DESC";
sSQL = sSQL.Replace("aaaaaa", dtmCode.ToString("yyyy"));
dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
long lRd08Code = 0;
if (dt != null && dt.Rows.Count > 0)
{
lRd08Code = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]);
}
else
{
lRd08Code = 0;
}
lRd08Code += 1;
string sRd08Code = lRd08Code.ToString();
Model.RdRecord08 modRd08 = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.RdRecord08();
lID += 1;
modRd08.ID = lID;
modRd08.bRdFlag = 1;
modRd08.cVouchType = "08";
modRd08.cBusType = "调拨入库";
modRd08.cSource = "调拨";
modRd08.cBusCode = sCode;
if (dtTr.Rows[0]["cIWhCode"].ToString().Trim().ToString().Trim() == "")
{
throw new Exception("请设置转入仓库");
}
modRd08.cWhCode = dtTr.Rows[0]["cIWhCode"].ToString().Trim();
modRd08.dDate = dNowDate;
string sCodeRD = lRd08Code.ToString();
while (sCodeRD.Length < 6)
{
sCodeRD = "0" + sCodeRD;
}
modRd08.cCode = "MI" + dNowDate.Year.ToString() + sCodeRD;
if (dtTr.Rows[0]["cIRdCode"].ToString().Trim() == "")
{
throw new Exception("请设置入库类别");
}
modRd08.cRdCode = dtTr.Rows[0]["cIRdCode"].ToString().Trim();
if (dtTr.Rows[0]["cIDepCode"].ToString().Trim() != "")
{
modRd08.cDepCode = dtTr.Rows[0]["cIDepCode"].ToString().Trim();
}
if (dtTr.Rows[0]["cPersonCode"].ToString().Trim() != "")
{
modRd08.cPersonCode = dtTr.Rows[0]["cPersonCode"].ToString().Trim();
}
modRd08.bTransFlag = false;
modRd08.cMaker = dtTr.Rows[0]["cVerifyPerson"].ToString().Trim();
modRd08.cHandler = dtTr.Rows[0]["cVerifyPerson"].ToString().Trim();
modRd08.dVeriDate = dNowDate;
modRd08.bpufirst = false;
modRd08.biafirst = false;
modRd08.VT_ID = 67;
modRd08.bIsSTQc = false;
modRd08.bOMFirst = false;
modRd08.bFromPreYear = false;
modRd08.bIsComplement = 0;
modRd08.iDiscountTaxType = 0;
modRd08.ireturncount = 0;
modRd08.iverifystate = 0;
modRd08.iswfcontrolled = 0;
modRd08.dnmaketime = dNow;
modRd08.dnverifytime = dNow;
modRd08.cSourceLs = "1";
modRd08.iPrintCount = 0;
modRd08.csysbarcode = "||st08||" + modRd08.cCode;
DAL.RdRecord08 dalrd08 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.RdRecord08();
sSQL = dalrd08.Add(modRd08);
iCou += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
for (int i = 0; i < dtTr.Rows.Count; i++)
{
lIDDetails += 1;
Model.rdrecords08 modRds08 = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords08();
modRds08.AutoID = lIDDetails;
modRds08.ID = modRd08.ID;
modRds08.cInvCode = dtTr.Rows[i]["cInvCode"].ToString().Trim();
if (BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVNum"]) != 0)
{
modRds08.iNum = BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVNum"]);
}
modRds08.iQuantity = BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVQuantity"]);
modRds08.cBatch = dtTr.Rows[i]["cTVBatch"].ToString().Trim();
modRds08.cVouchCode = 0;
modRds08.iSOutNum = 0;
modRds08.iSOutQuantity = 0;
modRds08.iFlag = 0;
modRds08.iTrIds = BaseFunction.ReturnLong(dtTr.Rows[i]["autoID"]);
modRds08.iNQuantity = modRds08.iQuantity;
modRds08.iNNum = modRds08.iNNum;
modRds08.cMassUnit = 0;
modRds08.bCosting = true;
modRds08.bVMIUsed = false;
modRds08.iordertype = 0;
modRds08.irowno = BaseFunction.ReturnInt(dtTr.Rows[i]["irowno"]);
modRds08.cbsysbarcode = "||st08||" + modRd08.cCode + "|" + modRds08.irowno.ToString();
DAL.rdrecords08 dalRDs08 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords08();
sSQL = dalRDs08.Add(modRds08);
iCou += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
if exists
(select * from CurrentStock where cInvCode = '@cInvCode' and cWhCode = '@cWhCode'
and isnull(cFree1,'') = @cFree1
and isnull(cFree2,'') = @cFree2
and isnull(cFree3,'') = @cFree3
and isnull(cFree4,'') = @cFree4
and isnull(cFree5,'') = @cFree5
and isnull(cFree6,'') = @cFree6
and isnull(cFree7,'') = @cFree7
and isnull(cFree8,'') = @cFree8
and isnull(cFree9,'') = @cFree9
and isnull(cFree10,'') = @cFree10
and isnull(cBatch,'') = @cBatch
)
update CurrentStock set iQuantity = isnull(iQuantity,0) + @iQuantity
where cInvCode = '@cInvCode' and cWhCode = '@cWhCode'
and isnull(cFree1,'') = @cFree1
and isnull(cFree2,'') = @cFree2
and isnull(cFree3,'') = @cFree3
and isnull(cFree4,'') = @cFree4
and isnull(cFree5,'') = @cFree5
and isnull(cFree6,'') = @cFree6
and isnull(cFree7,'') = @cFree7
and isnull(cFree8,'') = @cFree8
and isnull(cFree9,'') = @cFree9
and isnull(cFree10,'') = @cFree10
and isnull(cBatch,'') = @cBatch
else
begin
declare @itemid varchar(20);
declare @iCount int;
select @iCount=count(itemid) from CurrentStock where cInvCode = '@cInvCode';
if( @iCount > 0 )
select @itemid=itemid from CurrentStock where cInvCode = '@cInvCode';
else
select @itemid=max(itemid+1) from CurrentStock
insert into CurrentStock(cWhCode,cInvCode,iQuantity,itemid, cFree1, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10,cBatch,iSoDid)
values('@cWhCode','@cInvCode', @iQuantity,isnull(@itemid,1), @cFree1, @cFree2, @cFree3, @cFree4, @cFree5, @cFree6, @cFree7, @cFree8, @cFree9, @cFree10,@cBatch,'')
end
";
sSQL = sSQL.Replace("@cInvCode", modRds08.cInvCode);
sSQL = sSQL.Replace("@cWhCode", modRd08.cWhCode);
sSQL = sSQL.Replace("@iQuantity", modRds08.iQuantity.ToString());
sSQL = sSQL.Replace("@iNum", modRds08.iNum.ToString());
sSQL = sSQL.Replace("@cFree10", modRds08.cFree10 == null ? "''" : "'" + modRds08.cFree10 + "'");
sSQL = sSQL.Replace("@cFree1", modRds08.cFree1 == null ? "''" : "'" + modRds08.cFree1 + "'");
sSQL = sSQL.Replace("@cFree2", modRds08.cFree2 == null ? "''" : "'" + modRds08.cFree2 + "'");
sSQL = sSQL.Replace("@cFree3", modRds08.cFree3 == null ? "''" : "'" + modRds08.cFree3 + "'");
sSQL = sSQL.Replace("@cFree4", modRds08.cFree4 == null ? "''" : "'" + modRds08.cFree4 + "'");
sSQL = sSQL.Replace("@cFree5", modRds08.cFree5 == null ? "''" : "'" + modRds08.cFree5 + "'");
sSQL = sSQL.Replace("@cFree6", modRds08.cFree6 == null ? "''" : "'" + modRds08.cFree6 + "'");
sSQL = sSQL.Replace("@cFree7", modRds08.cFree7 == null ? "''" : "'" + modRds08.cFree7 + "'");
sSQL = sSQL.Replace("@cFree8", modRds08.cFree8 == null ? "''" : "'" + modRds08.cFree8 + "'");
sSQL = sSQL.Replace("@cFree9", modRds08.cFree9 == null ? "''" : "'" + modRds08.cFree9 + "'");
sSQL = sSQL.Replace("@cBatch", modRds08.cBatch == null ? "''" : "'" + modRds08.cBatch + "'");
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
}
sSQL = @"
exec ST_SaveForStock N'08',N'aaaaaa',1,0 ,1
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
exec ST_SaveForTrackStock N'08',N'aaaaaa', 0 ,1
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
exec IA_SP_WriteUnAccountVouchForST 'aaaaaa',N'08'
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
if exists(select * from VoucherHistory where (CardNumber = '0301') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'bbbbbb'))
update VoucherHistory set cNumber = aaaaaa where (CardNumber = '0301') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'bbbbbb')
else
insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)
values('0301','日期','YYYY','bbbbbb','1',0)
";
sSQL = sSQL.Replace("aaaaaa", lRd08Code.ToString());
sSQL = sSQL.Replace("bbbbbb", dNow.ToString("yyyy"));
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
#endregion
#region 其他出库单
//获得单据号
sSQL = "select cNumber from VoucherHistory with (ROWLOCK) WHERE (CardNumber = '0302') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'aaaaaa') ORDER BY cNumber DESC";
sSQL = sSQL.Replace("aaaaaa", dtmCode.ToString("yyyy"));
dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
long lRd09Code = 0;
if (dt != null && dt.Rows.Count > 0)
{
lRd09Code = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]);
}
else
{
lRd09Code = 0;
}
lRd09Code += 1;
string sRd09Code = lRd09Code.ToString();
Model.RdRecord09 modRd09 = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.RdRecord09();
lID += 1;
modRd09.ID = lID;
modRd09.bRdFlag = 0;
modRd09.cVouchType = "09";
modRd09.cBusType = "调拨出库";
modRd09.cSource = "调拨";
modRd09.cBusCode = sCode;
if (dtTr.Rows[0]["cOWhCode"].ToString().Trim().ToString().Trim() == "")
{
throw new Exception("请设置转出仓库");
}
modRd09.cWhCode = dtTr.Rows[0]["cOWhCode"].ToString().Trim();
modRd09.dDate = dNowDate;
string sCodeRD09 = lRd09Code.ToString();
while (sCodeRD09.Length < 6)
{
sCodeRD09 = "0" + sCodeRD09;
}
modRd09.cCode = "MR" + dNowDate.Year.ToString() + sCodeRD09;
if (dtTr.Rows[0]["cORdCode"].ToString().Trim() == "")
{
throw new Exception("请设置出库类别");
}
modRd09.cRdCode = dtTr.Rows[0]["cORdCode"].ToString().Trim();
if (dtTr.Rows[0]["cODepCode"].ToString().Trim() != "")
{
modRd09.cDepCode = dtTr.Rows[0]["cODepCode"].ToString().Trim();
}
if (dtTr.Rows[0]["cPersonCode"].ToString().Trim() != "")
{
modRd09.cPersonCode = dtTr.Rows[0]["cPersonCode"].ToString().Trim();
}
modRd09.bTransFlag = false;
modRd09.cMaker = dtTr.Rows[0]["cVerifyPerson"].ToString().Trim();
modRd09.cHandler = dtTr.Rows[0]["cVerifyPerson"].ToString().Trim();
modRd09.dVeriDate = dNowDate;
modRd09.bpufirst = false;
modRd09.biafirst = false;
modRd09.VT_ID = 85;
modRd09.bIsSTQc = false;
modRd09.bOMFirst = false;
modRd09.bFromPreYear = false;
modRd09.bIsComplement = 0;
modRd09.iDiscountTaxType = 0;
modRd09.ireturncount = 0;
modRd09.iverifystate = 0;
modRd09.iswfcontrolled = 0;
modRd09.dnmaketime = dNow;
modRd09.dnverifytime = dNow;
modRd09.cSourceLs = "1";
modRd09.iPrintCount = 0;
modRd09.csysbarcode = "||st09||" + modRd09.cCode;
DAL.RdRecord09 dalrd09 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.RdRecord09();
sSQL = dalrd09.Add(modRd09);
iCou += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
for (int i = 0; i < dtTr.Rows.Count; i++)
{
lIDDetails += 1;
Model.rdrecords09 modRds09 = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords09();
modRds09.AutoID = lIDDetails;
modRds09.ID = modRd09.ID;
modRds09.cInvCode = dtTr.Rows[i]["cInvCode"].ToString().Trim();
if (BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVNum"]) != 0)
{
modRds09.iNum = BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVNum"]);
}
modRds09.iQuantity = BaseFunction.ReturnDecimal(dtTr.Rows[i]["iTVQuantity"]);
modRds09.cBatch = dtTr.Rows[i]["cTVBatch"].ToString().Trim();
modRds09.cVouchCode = 0;
modRds09.iSOutNum = 0;
modRds09.iSOutQuantity = 0;
modRds09.iFlag = 0;
modRds09.iTrIds = BaseFunction.ReturnLong(dtTr.Rows[i]["autoID"]);
modRds09.iNQuantity = modRds09.iQuantity;
modRds09.iNNum = modRds09.iNNum;
modRds09.cMassUnit = 0;
modRds09.bCosting = true;
modRds09.bVMIUsed = false;
modRds09.iordertype = 0;
modRds09.irowno = BaseFunction.ReturnInt(dtTr.Rows[i]["irowno"]);
modRds09.cbsysbarcode = "||st09||" + modRd09.cCode + "|" + modRds09.irowno.ToString();
DAL.rdrecords09 dalRDs09 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords09();
sSQL = dalRDs09.Add(modRds09);
iCou += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
if exists
(select * from CurrentStock where cInvCode = '@cInvCode' and cWhCode = '@cWhCode'
and isnull(cFree1,'') = @cFree1
and isnull(cFree2,'') = @cFree2
and isnull(cFree3,'') = @cFree3
and isnull(cFree4,'') = @cFree4
and isnull(cFree5,'') = @cFree5
and isnull(cFree6,'') = @cFree6
and isnull(cFree7,'') = @cFree7
and isnull(cFree8,'') = @cFree8
and isnull(cFree9,'') = @cFree9
and isnull(cFree10,'') = @cFree10
and isnull(cBatch,'') = @cBatch
)
update CurrentStock set iQuantity = isnull(iQuantity,0) - @iQuantity
where cInvCode = '@cInvCode' and cWhCode = '@cWhCode'
and isnull(cFree1,'') = @cFree1
and isnull(cFree2,'') = @cFree2
and isnull(cFree3,'') = @cFree3
and isnull(cFree4,'') = @cFree4
and isnull(cFree5,'') = @cFree5
and isnull(cFree6,'') = @cFree6
and isnull(cFree7,'') = @cFree7
and isnull(cFree8,'') = @cFree8
and isnull(cFree9,'') = @cFree9
and isnull(cFree10,'') = @cFree10
and isnull(cBatch,'') = @cBatch
else
begin
declare @itemid varchar(20);
declare @iCount int;
select @iCount=count(itemid) from CurrentStock where cInvCode = '@cInvCode';
if( @iCount > 0 )
select @itemid=itemid from CurrentStock where cInvCode = '@cInvCode';
else
select @itemid=max(itemid+1) from CurrentStock
insert into CurrentStock(cWhCode,cInvCode,iQuantity,itemid, cFree1, cFree2, cFree3, cFree4, cFree5, cFree6, cFree7, cFree8, cFree9, cFree10,cBatch,iSoDid)
values('@cWhCode','@cInvCode', @iQuantity,isnull(@itemid,1), @cFree1, @cFree2, @cFree3, @cFree4, @cFree5, @cFree6, @cFree7, @cFree8, @cFree9, @cFree10,@cBatch,'')
end
";
sSQL = sSQL.Replace("@cInvCode", modRds09.cInvCode);
sSQL = sSQL.Replace("@cWhCode", modRd09.cWhCode);
sSQL = sSQL.Replace("@iQuantity", modRds09.iQuantity.ToString());
sSQL = sSQL.Replace("@iNum", modRds09.iNum.ToString());
sSQL = sSQL.Replace("@cFree10", modRds09.cFree10 == null ? "''" : "'" + modRds09.cFree10 + "'");
sSQL = sSQL.Replace("@cFree1", modRds09.cFree1 == null ? "''" : "'" + modRds09.cFree1 + "'");
sSQL = sSQL.Replace("@cFree2", modRds09.cFree2 == null ? "''" : "'" + modRds09.cFree2 + "'");
sSQL = sSQL.Replace("@cFree3", modRds09.cFree3 == null ? "''" : "'" + modRds09.cFree3 + "'");
sSQL = sSQL.Replace("@cFree4", modRds09.cFree4 == null ? "''" : "'" + modRds09.cFree4 + "'");
sSQL = sSQL.Replace("@cFree5", modRds09.cFree5 == null ? "''" : "'" + modRds09.cFree5 + "'");
sSQL = sSQL.Replace("@cFree6", modRds09.cFree6 == null ? "''" : "'" + modRds09.cFree6 + "'");
sSQL = sSQL.Replace("@cFree7", modRds09.cFree7 == null ? "''" : "'" + modRds09.cFree7 + "'");
sSQL = sSQL.Replace("@cFree8", modRds09.cFree8 == null ? "''" : "'" + modRds09.cFree8 + "'");
sSQL = sSQL.Replace("@cFree9", modRds09.cFree9 == null ? "''" : "'" + modRds09.cFree9 + "'");
sSQL = sSQL.Replace("@cBatch", modRds09.cBatch == null ? "''" : "'" + modRds09.cBatch + "'");
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
}
sSQL = @"
exec ST_SaveForStock N'09',N'aaaaaa',1,0 ,1
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
exec ST_SaveForTrackStock N'09',N'aaaaaa', 0 ,1
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
exec IA_SP_WriteUnAccountVouchForST 'aaaaaa',N'09'
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
if (lID > 1000000000)
{
lID = lID - 1000000000;
}
if (lIDDetails > 1000000000)
{
lIDDetails = lIDDetails - 1000000000;
}
sSQL = "update UFSystem..UA_Identity set iFatherId = " + lID.ToString() + ",iChildId = " + lIDDetails + " where cAcc_Id = '" + sAccID + "' and cVouchType = 'rd'";
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
sSQL = @"
if exists(select * from VoucherHistory where (CardNumber = '0302') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'bbbbbb'))
update VoucherHistory set cNumber = aaaaaa where (CardNumber = '0302') AND (cContent = '日期') AND (cContentRule = 'YYYY') AND (cSeed = 'bbbbbb')
else
insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)
values('0302','日期','YYYY','bbbbbb','1',0)
";
sSQL = sSQL.Replace("aaaaaa", lRd09Code.ToString());
sSQL = sSQL.Replace("bbbbbb", dNow.ToString("yyyy"));
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
#endregion
return(iCou);
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords09 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.iTrIds != null)
{
strSql1.Append("iTrIds,");
strSql2.Append("" + model.iTrIds + ",");
}
if (model.cPosition != null)
{
strSql1.Append("cPosition,");
strSql2.Append("'" + model.cPosition + "',");
}
if (model.cDefine22 != null)
{
strSql1.Append("cDefine22,");
strSql2.Append("'" + model.cDefine22 + "',");
}
if (model.cDefine23 != null)
{
strSql1.Append("cDefine23,");
strSql2.Append("'" + model.cDefine23 + "',");
}
if (model.cDefine24 != null)
{
strSql1.Append("cDefine24,");
strSql2.Append("'" + model.cDefine24 + "',");
}
if (model.cDefine25 != null)
{
strSql1.Append("cDefine25,");
strSql2.Append("'" + model.cDefine25 + "',");
}
if (model.cDefine26 != null)
{
strSql1.Append("cDefine26,");
strSql2.Append("" + model.cDefine26 + ",");
}
if (model.cDefine27 != null)
{
strSql1.Append("cDefine27,");
strSql2.Append("" + model.cDefine27 + ",");
}
if (model.cItem_class != null)
{
strSql1.Append("cItem_class,");
strSql2.Append("'" + model.cItem_class + "',");
}
if (model.cItemCode != null)
{
strSql1.Append("cItemCode,");
strSql2.Append("'" + model.cItemCode + "',");
}
if (model.iDLsID != null)
{
strSql1.Append("iDLsID,");
strSql2.Append("" + model.iDLsID + ",");
}
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.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.isodid != null)
{
strSql1.Append("isodid,");
strSql2.Append("'" + model.isodid + "',");
}
if (model.isotype != null)
{
strSql1.Append("isotype,");
strSql2.Append("" + model.isotype + ",");
}
if (model.csocode != null)
{
strSql1.Append("csocode,");
strSql2.Append("'" + model.csocode + "',");
}
if (model.isoseq != null)
{
strSql1.Append("isoseq,");
strSql2.Append("" + model.isoseq + ",");
}
if (model.cBatchProperty1 != null)
{
strSql1.Append("cBatchProperty1,");
strSql2.Append("" + model.cBatchProperty1 + ",");
}
if (model.cBatchProperty2 != null)
{
strSql1.Append("cBatchProperty2,");
strSql2.Append("" + model.cBatchProperty2 + ",");
}
if (model.cBatchProperty3 != null)
{
strSql1.Append("cBatchProperty3,");
strSql2.Append("" + model.cBatchProperty3 + ",");
}
if (model.cBatchProperty4 != null)
{
strSql1.Append("cBatchProperty4,");
strSql2.Append("" + model.cBatchProperty4 + ",");
}
if (model.cBatchProperty5 != null)
{
strSql1.Append("cBatchProperty5,");
strSql2.Append("" + model.cBatchProperty5 + ",");
}
if (model.cBatchProperty6 != null)
{
strSql1.Append("cBatchProperty6,");
strSql2.Append("'" + model.cBatchProperty6 + "',");
}
if (model.cBatchProperty7 != null)
{
strSql1.Append("cBatchProperty7,");
strSql2.Append("'" + model.cBatchProperty7 + "',");
}
if (model.cBatchProperty8 != null)
{
strSql1.Append("cBatchProperty8,");
strSql2.Append("'" + model.cBatchProperty8 + "',");
}
if (model.cBatchProperty9 != null)
{
strSql1.Append("cBatchProperty9,");
strSql2.Append("'" + model.cBatchProperty9 + "',");
}
if (model.cBatchProperty10 != null)
{
strSql1.Append("cBatchProperty10,");
strSql2.Append("'" + model.cBatchProperty10 + "',");
}
if (model.cbMemo != null)
{
strSql1.Append("cbMemo,");
strSql2.Append("'" + model.cbMemo + "',");
}
if (model.irowno != null)
{
strSql1.Append("irowno,");
strSql2.Append("" + model.irowno + ",");
}
if (model.strowguid != null)
{
strSql1.Append("strowguid,");
strSql2.Append("'" + Guid.NewGuid().ToString() + "',");
}
if (model.rowufts != null)
{
strSql1.Append("rowufts,");
strSql2.Append("" + model.rowufts + ",");
}
if (model.ipreuseqty != null)
{
strSql1.Append("ipreuseqty,");
strSql2.Append("" + model.ipreuseqty + ",");
}
if (model.ipreuseinum != null)
{
strSql1.Append("ipreuseinum,");
strSql2.Append("" + model.ipreuseinum + ",");
}
if (model.cbsourcecodels != null)
{
strSql1.Append("cbsourcecodels,");
strSql2.Append("'" + model.cbsourcecodels + "',");
}
if (model.iGroupNO != null)
{
strSql1.Append("iGroupNO,");
strSql2.Append("" + model.iGroupNO + ",");
}
if (model.iDebitIDs != null)
{
strSql1.Append("iDebitIDs,");
strSql2.Append("" + model.iDebitIDs + ",");
}
if (model.idebitchildids != null)
{
strSql1.Append("idebitchildids,");
strSql2.Append("" + model.idebitchildids + ",");
}
if (model.iimosid != null)
{
strSql1.Append("iimosid,");
strSql2.Append("" + model.iimosid + ",");
}
if (model.cPOID != null)
{
strSql1.Append("cPOID,");
strSql2.Append("'" + model.cPOID + "',");
}
if (model.strContractId != null)
{
strSql1.Append("strContractId,");
strSql2.Append("'" + model.strContractId + "',");
}
if (model.strCode != null)
{
strSql1.Append("strCode,");
strSql2.Append("'" + model.strCode + "',");
}
if (model.cInVoucherLineID != null)
{
strSql1.Append("cInVoucherLineID,");
strSql2.Append("" + model.cInVoucherLineID + ",");
}
if (model.cInVoucherCode != null)
{
strSql1.Append("cInVoucherCode,");
strSql2.Append("'" + model.cInVoucherCode + "',");
}
if (model.cInVoucherType != null)
{
strSql1.Append("cInVoucherType,");
strSql2.Append("'" + model.cInVoucherType + "',");
}
if (model.cbsysbarcode != null)
{
strSql1.Append("cbsysbarcode,");
strSql2.Append("'" + model.cbsysbarcode + "',");
}
if (model.ipickedquantity != null)
{
strSql1.Append("ipickedquantity,");
strSql2.Append("" + model.ipickedquantity + ",");
}
if (model.ipickednum != null)
{
strSql1.Append("ipickednum,");
strSql2.Append("" + model.ipickednum + ",");
}
strSql.Append("insert into rdrecords09(");
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());
}
