예제 #1
0
파일: RdRecord09.cs 프로젝트: chrgu000/DEMO
        /// <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());
        }
예제 #2
0
파일: clsU8.cs 프로젝트: chrgu000/DEMO
        //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);
        }