/// <summary>
/// 增加一条数据
/// </summary>
public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords09sub 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.cBG_ItemCode != null)
{
strSql1.Append("cBG_ItemCode,");
strSql2.Append("'" + model.cBG_ItemCode + "',");
}
if (model.cBG_ItemName != null)
{
strSql1.Append("cBG_ItemName,");
strSql2.Append("'" + model.cBG_ItemName + "',");
}
if (model.cBG_CaliberKey1 != null)
{
strSql1.Append("cBG_CaliberKey1,");
strSql2.Append("'" + model.cBG_CaliberKey1 + "',");
}
if (model.cBG_CaliberKeyName1 != null)
{
strSql1.Append("cBG_CaliberKeyName1,");
strSql2.Append("'" + model.cBG_CaliberKeyName1 + "',");
}
if (model.cBG_CaliberKey2 != null)
{
strSql1.Append("cBG_CaliberKey2,");
strSql2.Append("'" + model.cBG_CaliberKey2 + "',");
}
if (model.cBG_CaliberKeyName2 != null)
{
strSql1.Append("cBG_CaliberKeyName2,");
strSql2.Append("'" + model.cBG_CaliberKeyName2 + "',");
}
if (model.cBG_CaliberKey3 != null)
{
strSql1.Append("cBG_CaliberKey3,");
strSql2.Append("'" + model.cBG_CaliberKey3 + "',");
}
if (model.cBG_CaliberKeyName3 != null)
{
strSql1.Append("cBG_CaliberKeyName3,");
strSql2.Append("'" + model.cBG_CaliberKeyName3 + "',");
}
if (model.cBG_CaliberCode1 != null)
{
strSql1.Append("cBG_CaliberCode1,");
strSql2.Append("'" + model.cBG_CaliberCode1 + "',");
}
if (model.cBG_CaliberName1 != null)
{
strSql1.Append("cBG_CaliberName1,");
strSql2.Append("'" + model.cBG_CaliberName1 + "',");
}
if (model.cBG_CaliberCode2 != null)
{
strSql1.Append("cBG_CaliberCode2,");
strSql2.Append("'" + model.cBG_CaliberCode2 + "',");
}
if (model.cBG_CaliberName2 != null)
{
strSql1.Append("cBG_CaliberName2,");
strSql2.Append("'" + model.cBG_CaliberName2 + "',");
}
if (model.cBG_CaliberCode3 != null)
{
strSql1.Append("cBG_CaliberCode3,");
strSql2.Append("'" + model.cBG_CaliberCode3 + "',");
}
if (model.cBG_CaliberName3 != null)
{
strSql1.Append("cBG_CaliberName3,");
strSql2.Append("'" + model.cBG_CaliberName3 + "',");
}
if (model.iBG_Ctrl != null)
{
strSql1.Append("iBG_Ctrl,");
strSql2.Append("" + (model.iBG_Ctrl ? 1 : 0) + ",");
}
if (model.cBG_Auditopinion != null)
{
strSql1.Append("cBG_Auditopinion,");
strSql2.Append("'" + model.cBG_Auditopinion + "',");
}
if (model.iBGSTSum != null)
{
strSql1.Append("iBGSTSum,");
strSql2.Append("" + model.iBGSTSum + ",");
}
if (model.iBGIASum != null)
{
strSql1.Append("iBGIASum,");
strSql2.Append("" + model.iBGIASum + ",");
}
if (model.cBG_CaliberKey4 != null)
{
strSql1.Append("cBG_CaliberKey4,");
strSql2.Append("'" + model.cBG_CaliberKey4 + "',");
}
if (model.cBG_CaliberKeyName4 != null)
{
strSql1.Append("cBG_CaliberKeyName4,");
strSql2.Append("'" + model.cBG_CaliberKeyName4 + "',");
}
if (model.cBG_CaliberKey5 != null)
{
strSql1.Append("cBG_CaliberKey5,");
strSql2.Append("'" + model.cBG_CaliberKey5 + "',");
}
if (model.cBG_CaliberKeyName5 != null)
{
strSql1.Append("cBG_CaliberKeyName5,");
strSql2.Append("'" + model.cBG_CaliberKeyName5 + "',");
}
if (model.cBG_CaliberKey6 != null)
{
strSql1.Append("cBG_CaliberKey6,");
strSql2.Append("'" + model.cBG_CaliberKey6 + "',");
}
if (model.cBG_CaliberKeyName6 != null)
{
strSql1.Append("cBG_CaliberKeyName6,");
strSql2.Append("'" + model.cBG_CaliberKeyName6 + "',");
}
if (model.cBG_CaliberCode4 != null)
{
strSql1.Append("cBG_CaliberCode4,");
strSql2.Append("'" + model.cBG_CaliberCode4 + "',");
}
if (model.cBG_CaliberName4 != null)
{
strSql1.Append("cBG_CaliberName4,");
strSql2.Append("'" + model.cBG_CaliberName4 + "',");
}
if (model.cBG_CaliberCode5 != null)
{
strSql1.Append("cBG_CaliberCode5,");
strSql2.Append("'" + model.cBG_CaliberCode5 + "',");
}
if (model.cBG_CaliberName5 != null)
{
strSql1.Append("cBG_CaliberName5,");
strSql2.Append("'" + model.cBG_CaliberName5 + "',");
}
if (model.cBG_CaliberCode6 != null)
{
strSql1.Append("cBG_CaliberCode6,");
strSql2.Append("'" + model.cBG_CaliberCode6 + "',");
}
if (model.cBG_CaliberName6 != null)
{
strSql1.Append("cBG_CaliberName6,");
strSql2.Append("'" + model.cBG_CaliberName6 + "',");
}
strSql.Append("insert into rdrecords09sub(");
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());
}
//U8V11.1
public int TransVouch_Audit_U8V111(SqlTransaction tran, string sCode, string sAccID, string sUserName)
{
string sErr = "";
int iCount = 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");
}
int iCodeCou = dtTr.Rows.Count;
DateTime dtmCode = BaseFunction.ReturnDate(dtTr.Rows[0]["dVerifyDate"]);
//审核调拨单
sSQL = @"UPDATE TransVouch SET cVerifyPerson = 'aaaaaa',dVerifyDate =dTVDate,dnverifytime = getdate() WHERE cTVCode = 'dddddd'";
sSQL = sSQL.Replace("aaaaaa", sUserName);
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',cccccc,@p5 output,@p6 output,default
select @p5, @p6
";
sSQL = sSQL.Replace("aaaaaa", lID.ToString());
sSQL = sSQL.Replace("bbbbbb", lIDDetails.ToString());
sSQL = sSQL.Replace("cccccc", iCodeCou.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]) - iCodeCou;
#region 其他入库单
//获得单据号
sSQL = "select cNumber from VoucherHistory with (ROWLOCK) WHERE (CardNumber = '0301') AND (cContent = '日期') AND (cContentRule = '日') AND (cSeed = 'aaaaaa') ORDER BY cNumber DESC";
sSQL = sSQL.Replace("aaaaaa", dtmCode.ToString("yyyyMMdd"));
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 = Convert.ToDateTime(dtTr.Rows[0]["dVerifyDate"]);;
string sCodeRD = lRd08Code.ToString();
while (sCodeRD.Length < 4)
{
sCodeRD = "0" + sCodeRD;
}
modRd08.cCode = "IN" + dtmCode.ToString("yyyyMMdd") + 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 = Convert.ToDateTime(dtTr.Rows[0]["dVerifyDate"]);
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;
if (dtTr.Rows[0]["cDefine1"].ToString().Trim() != "")
{
modRd08.cDefine1 = dtTr.Rows[0]["cDefine1"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine2"].ToString().Trim() != "")
{
modRd08.cDefine2 = dtTr.Rows[0]["cDefine2"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine3"].ToString().Trim() != "")
{
modRd08.cDefine3 = dtTr.Rows[0]["cDefine3"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine4"].ToString().Trim() != "")
{
modRd08.cDefine4 = BaseFunction.ReturnDate(dtTr.Rows[0]["cDefine4"]);
}
if (dtTr.Rows[0]["cDefine5"].ToString().Trim() != "")
{
modRd08.cDefine5 = BaseFunction.ReturnLong(dtTr.Rows[0]["cDefine5"]);
}
if (dtTr.Rows[0]["cDefine6"].ToString().Trim() != "")
{
modRd08.cDefine6 = BaseFunction.ReturnDate(dtTr.Rows[0]["cDefine6"]);
}
if (dtTr.Rows[0]["cDefine7"].ToString().Trim() != "")
{
modRd08.cDefine7 = BaseFunction.ReturnDecimal(dtTr.Rows[0]["cDefine7"]);
}
if (dtTr.Rows[0]["cDefine8"].ToString().Trim() != "")
{
modRd08.cDefine8 = dtTr.Rows[0]["cDefine8"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine9"].ToString().Trim() != "")
{
modRd08.cDefine9 = dtTr.Rows[0]["cDefine9"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine10"].ToString().Trim() != "")
{
modRd08.cDefine10 = dtTr.Rows[0]["cDefine10"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine11"].ToString().Trim() != "")
{
modRd08.cDefine11 = dtTr.Rows[0]["cDefine11"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine12"].ToString().Trim() != "")
{
modRd08.cDefine12 = dtTr.Rows[0]["cDefine12"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine13"].ToString().Trim() != "")
{
modRd08.cDefine13 = dtTr.Rows[0]["cDefine13"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine14"].ToString().Trim() != "")
{
modRd08.cDefine14 = dtTr.Rows[0]["cDefine14"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine15"].ToString().Trim() != "")
{
modRd08.cDefine15 = BaseFunction.ReturnLong(dtTr.Rows[0]["cDefine15"]);
}
if (dtTr.Rows[0]["cDefine16"].ToString().Trim() != "")
{
modRd08.cDefine16 = BaseFunction.ReturnDecimal(dtTr.Rows[0]["cDefine16"]);
}
DAL.RdRecord08 dalrd08 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.RdRecord08();
sSQL = dalrd08.Add(modRd08);
iCount += 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();
modRds08.cDefine22 = dtTr.Rows[i]["cDefine22"].ToString().Trim();
modRds08.cDefine23 = dtTr.Rows[i]["cDefine23"].ToString().Trim();
modRds08.cDefine24 = dtTr.Rows[i]["cDefine24"].ToString().Trim();
modRds08.cDefine25 = dtTr.Rows[i]["cDefine25"].ToString().Trim();
modRds08.cDefine28 = dtTr.Rows[i]["cDefine28"].ToString().Trim();
DAL.rdrecords08 dalRDs08 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords08();
sSQL = dalRDs08.Add(modRds08);
iCount += 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 = '日') AND (cSeed = 'bbbbbb'))
update VoucherHistory set cNumber = aaaaaa where (CardNumber = '0301') AND (cContent = '日期') AND (cContentRule = '日') AND (cSeed = 'bbbbbb')
else
insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)
values('0301','日期','日','bbbbbb','1',0)
";
sSQL = sSQL.Replace("aaaaaa", lRd08Code.ToString());
sSQL = sSQL.Replace("bbbbbb", dtmCode.ToString("yyyyMMdd"));
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
#endregion
#region 其他出库单
lID = -1;
lIDDetails = -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", lIDDetails.ToString());
sSQL = sSQL.Replace("cccccc", iCodeCou.ToString());
sSQL = sSQL.Replace("dddddd", sAccID);
dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
lID = BaseFunction.ReturnLong(dt.Rows[0][0]) - 1;
lIDDetails = BaseFunction.ReturnLong(dt.Rows[0][1]) - iCodeCou;
//获得单据号
sSQL = "select cNumber from VoucherHistory with (ROWLOCK) WHERE (CardNumber = '0302') AND (cContent = '日期') AND (cContentRule = '日') AND (cSeed = 'aaaaaa') ORDER BY cNumber DESC";
sSQL = sSQL.Replace("aaaaaa", dtmCode.ToString("yyyyMMdd"));
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 = Convert.ToDateTime(dtTr.Rows[0]["dVerifyDate"]);;
string sCodeRD09 = lRd09Code.ToString();
while (sCodeRD09.Length < 4)
{
sCodeRD09 = "0" + sCodeRD09;
}
modRd09.cCode = "OU" + dtmCode.ToString("yyyyMMdd") + 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 = Convert.ToDateTime(dtTr.Rows[0]["dVerifyDate"]);;
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;
if (dtTr.Rows[0]["cDefine1"].ToString().Trim() != "")
{
modRd09.cDefine1 = dtTr.Rows[0]["cDefine1"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine2"].ToString().Trim() != "")
{
modRd09.cDefine2 = dtTr.Rows[0]["cDefine2"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine3"].ToString().Trim() != "")
{
modRd09.cDefine3 = dtTr.Rows[0]["cDefine3"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine4"].ToString().Trim() != "")
{
modRd09.cDefine4 = BaseFunction.ReturnDate(dtTr.Rows[0]["cDefine4"]);
}
if (dtTr.Rows[0]["cDefine5"].ToString().Trim() != "")
{
modRd09.cDefine5 = BaseFunction.ReturnLong(dtTr.Rows[0]["cDefine5"]);
}
if (dtTr.Rows[0]["cDefine6"].ToString().Trim() != "")
{
modRd09.cDefine6 = BaseFunction.ReturnDate(dtTr.Rows[0]["cDefine6"]);
}
if (dtTr.Rows[0]["cDefine7"].ToString().Trim() != "")
{
modRd09.cDefine7 = BaseFunction.ReturnDecimal(dtTr.Rows[0]["cDefine7"]);
}
if (dtTr.Rows[0]["cDefine8"].ToString().Trim() != "")
{
modRd09.cDefine8 = dtTr.Rows[0]["cDefine8"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine9"].ToString().Trim() != "")
{
modRd09.cDefine9 = dtTr.Rows[0]["cDefine9"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine10"].ToString().Trim() != "")
{
modRd09.cDefine10 = dtTr.Rows[0]["cDefine10"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine11"].ToString().Trim() != "")
{
modRd09.cDefine11 = dtTr.Rows[0]["cDefine11"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine12"].ToString().Trim() != "")
{
modRd09.cDefine12 = dtTr.Rows[0]["cDefine12"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine13"].ToString().Trim() != "")
{
modRd09.cDefine13 = dtTr.Rows[0]["cDefine13"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine14"].ToString().Trim() != "")
{
modRd09.cDefine14 = dtTr.Rows[0]["cDefine14"].ToString().Trim();
}
if (dtTr.Rows[0]["cDefine15"].ToString().Trim() != "")
{
modRd09.cDefine15 = BaseFunction.ReturnLong(dtTr.Rows[0]["cDefine15"]);
}
if (dtTr.Rows[0]["cDefine16"].ToString().Trim() != "")
{
modRd09.cDefine16 = BaseFunction.ReturnDecimal(dtTr.Rows[0]["cDefine16"]);
}
DAL.RdRecord09 dalrd09 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.RdRecord09();
sSQL = dalrd09.Add(modRd09);
iCount += 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();
modRds09.cDefine22 = dtTr.Rows[i]["cDefine22"].ToString().Trim();
modRds09.cDefine23 = dtTr.Rows[i]["cDefine23"].ToString().Trim();
modRds09.cDefine24 = dtTr.Rows[i]["cDefine24"].ToString().Trim();
modRds09.cDefine25 = dtTr.Rows[i]["cDefine25"].ToString().Trim();
modRds09.cDefine28 = dtTr.Rows[i]["cDefine28"].ToString().Trim();
DAL.rdrecords09 dalRDs09 = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords09();
sSQL = dalRDs09.Add(modRds09);
iCount += 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);
Model.rdrecords09sub mod09Sub = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.rdrecords09sub();
mod09Sub.AutoID = modRds09.AutoID;
mod09Sub.ID = modRds09.ID;
mod09Sub.iBG_Ctrl = false;
mod09Sub.iBGSTSum = 0;
DAL.rdrecords09sub dal09Sub = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.rdrecords09sub();
sSQL = dal09Sub.Add(mod09Sub);
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 = '日') AND (cSeed = 'bbbbbb'))
update VoucherHistory set cNumber = aaaaaa where (CardNumber = '0302') AND (cContent = '日期') AND (cContentRule = '日') AND (cSeed = 'bbbbbb')
else
insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)
values('0302','日期','日','bbbbbb','1',0)
";
sSQL = sSQL.Replace("aaaaaa", lRd09Code.ToString());
sSQL = sSQL.Replace("bbbbbb", dtmCode.ToString("yyyyMMdd"));
DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
#endregion
return(iCount);
}
