/// <summary>
/// 增加一条数据
/// </summary>
public string Add(UFIDA.U8.UAP.CustomApp.ControlForm.Model.RdRecord09 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.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.iBG_OverFlag != null)
{
strSql1.Append("iBG_OverFlag,");
strSql2.Append("" + model.iBG_OverFlag + ",");
}
if (model.cBG_Auditor != null)
{
strSql1.Append("cBG_Auditor,");
strSql2.Append("'" + model.cBG_Auditor + "',");
}
if (model.cBG_AuditTime != null)
{
strSql1.Append("cBG_AuditTime,");
strSql2.Append("'" + model.cBG_AuditTime + "',");
}
if (model.ControlResult != null)
{
strSql1.Append("ControlResult,");
strSql2.Append("" + model.ControlResult + ",");
}
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.ctransflag != null)
{
strSql1.Append("ctransflag,");
strSql2.Append("'" + model.ctransflag + "',");
}
if (model.csysbarcode != null)
{
strSql1.Append("csysbarcode,");
strSql2.Append("'" + model.csysbarcode + "',");
}
if (model.cCurrentAuditor != null)
{
strSql1.Append("cCurrentAuditor,");
strSql2.Append("'" + model.cCurrentAuditor + "',");
}
strSql.Append("insert into RdRecord09(");
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 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);
}