Ejemplo n.º 1
0
        private void btnImprot_Click(object sender, EventArgs e)
        {
            try
            {
                gridViewPL.FocusedRowHandle -= 1;
                gridViewPL.FocusedRowHandle += 1;
            }
            catch { }

            try
            {
                if (txtEntryNo.Text.Trim() == "")
                {
                    txtEntryNo.Focus();
                    throw new Exception("Please set entry no");
                }

                int iCou = gridViewPL.RowCount;
                if (iCou == 0)
                {
                    throw new Exception("no data");
                }

                string sMCode = "";

                int           iCodeCou = gridViewPL.RowCount;
                string        sErr     = "";
                int           iCount   = 0;
                SqlConnection conn     = new SqlConnection(Conn);
                conn.Open();
                //启用事务
                SqlTransaction tran = conn.BeginTransaction();

                try
                {
                    if (lookUpEditWarehouseIN == null || lookUpEditWarehouseIN.Text.Trim() == "")
                    {
                        lookUpEditWarehouseIN.Focus();
                        throw new Exception("Please choose transfer-in warehouse");
                    }
                    if (lookUpEditWarehouseOUT == null || lookUpEditWarehouseOUT.Text.Trim() == "")
                    {
                        lookUpEditWarehouseOUT.Focus();
                        throw new Exception("Please choose transfer-out warehouse");
                    }

                    string sWhCodeIn  = lookUpEditWarehouseIN.EditValue.ToString().Trim();
                    string sWhCodeOut = lookUpEditWarehouseOUT.EditValue.ToString().Trim();

                    if (sWhCodeIn == sWhCodeOut)
                    {
                        throw new Exception("The warehouse can't be the same");
                    }
                    string sRdCodeIn   = "";
                    string sRdCodeOut  = "";
                    string sDepCodeIn  = "";
                    string sDepCodeOut = "";

                    string    sSQL   = @"
select * from _Code where VouchType = 'TransVouch'
";
                    DataTable dtCode = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                    if (dtCode != null && dtCode.Rows.Count > 0)
                    {
                        sRdCodeIn   = dtCode.Rows[0]["cRdCodeIn"].ToString().Trim();
                        sRdCodeOut  = dtCode.Rows[0]["cRdCodeOut"].ToString().Trim();
                        sDepCodeIn  = dtCode.Rows[0]["cDepCodeIn"].ToString().Trim();
                        sDepCodeOut = dtCode.Rows[0]["cDepCodeOut"].ToString().Trim();
                    }
                    else
                    {
                        throw new Exception("Please set _code [TransVouch]");
                    }

                    if (sWhCodeIn == "" || sWhCodeOut == "" || sRdCodeIn == "" || sRdCodeOut == "")
                    {
                        throw new Exception("Please set _code [TransVouchClaim]");
                    }

                    DateTime dLogDate = BaseFunction.ReturnDate(sLogDate);

                    //string sDate = dateEdit1.DateTime.ToString("yyyy-MM-dd");
                    string sDate = sLogDate;
                    sSQL = @"
select bflag_ST from gl_mend where iyear = aaaaaa and iperiod = bbbbbb
";
                    sSQL = sSQL.Replace("aaaaaa", dLogDate.Year.ToString());
                    sSQL = sSQL.Replace("bbbbbb", dLogDate.Month.ToString());
                    DataTable dtTemp = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                    if (BaseFunction.ReturnBool(dtTemp.Rows[0]["bflag_ST"]))
                    {
                        throw new Exception("The current date has been checked out");
                    }

                    string sDateTime = dateEditQuery.DateTime.ToString("yyyy-MM-dd");

                    bool bNeedTR = false;   //是否需要索赔调拨
                    #region 生成调拨单

                    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'tr',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", iCou.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;

                    ////获得单据号
                    sSQL = "select * from VoucherHistory with (ROWLOCK) Where CardNumber='0304' AND cSeed = 'aaaaaa'";
                    sSQL = sSQL.Replace("aaaaaa", dLogDate.ToString("yyyyMMdd"));
                    dt   = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];

                    long iCode = 0;
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        iCode = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]) + 1;
                        sSQL  = @"
update VoucherHistory set cNumber = aaaaaa where autoid = bbbbbb and CardNumber = '0304'
";
                        sSQL  = sSQL.Replace("aaaaaa", iCode.ToString());
                        sSQL  = sSQL.Replace("bbbbbb", dt.Rows[0]["AutoId"].ToString().Trim());
                        DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                    }
                    else
                    {
                        iCode = 1;
                        sSQL  = @"
insert into VoucherHistory(CardNumber, cContent, cContentRule, cSeed, cNumber, bEmpty)
values('0304','日期','日','aaaaaa',1,0)
";
                        sSQL  = sSQL.Replace("aaaaaa", dLogDate.ToString("yyyyMMdd"));
                        DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                    }
                    iCode += 1;
                    string sCode = iCode.ToString();
                    while (sCode.Length < 4)
                    {
                        sCode = "0" + sCode;
                    }
                    sCode = "TF" + dLogDate.ToString("yyyyMMdd") + sCode;

                    sSQL = @"
select distinct * from Rdrecord01 
where id in (select id from Rdrecords01 where autoid = {0})
";
                    sSQL = string.Format(sSQL, gridViewPL.GetRowCellValue(0, gridColRds01ID));
                    DataTable dtRd = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];

                    Model.TransVouch mod = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.TransVouch();
                    mod.cTVCode = sCode;
                    mod.dTVDate = dLogDate;

                    mod.cOWhCode = sWhCodeOut;
                    mod.cIWhCode = sWhCodeIn;
                    mod.cIRdCode = sRdCodeIn;
                    mod.cORdCode = sRdCodeOut;

                    if (sDepCodeIn != "")
                    {
                        mod.cIDepCode = sDepCodeIn;
                    }
                    if (sDepCodeOut != "")
                    {
                        mod.cODepCode = sDepCodeOut;
                    }
                    mod.cPersonCode = null;
                    mod.cTVMemo     = txtMemo.Text.Trim();

                    if (dtRd.Rows[0]["cDefine1"].ToString().Trim() != "")
                    {
                        mod.cDefine1 = dtRd.Rows[0]["cDefine1"].ToString().Trim();
                    }
                    if (dtRd.Rows[0]["cDefine2"].ToString().Trim() != "")
                    {
                        mod.cDefine2 = dtRd.Rows[0]["cDefine2"].ToString().Trim();
                    }
                    if (dtRd.Rows[0]["cDefine3"].ToString().Trim() != "")
                    {
                        mod.cDefine3 = dtRd.Rows[0]["cDefine3"].ToString().Trim();
                    }
                    if (dtRd.Rows[0]["cDefine4"].ToString().Trim() != "")
                    {
                        mod.cDefine4 = BaseFunction.ReturnDate(dtRd.Rows[0]["cDefine4"]);
                    }
                    if (dtRd.Rows[0]["cDefine5"].ToString().Trim() != "")
                    {
                        mod.cDefine5 = BaseFunction.ReturnLong(dtRd.Rows[0]["cDefine5"]);
                    }
                    if (dtRd.Rows[0]["cDefine6"].ToString().Trim() != "")
                    {
                        mod.cDefine6 = BaseFunction.ReturnDate(dtRd.Rows[0]["cDefine6"]);
                    }
                    if (dtRd.Rows[0]["cDefine7"].ToString().Trim() != "")
                    {
                        mod.cDefine7 = BaseFunction.ReturnDecimal(dtRd.Rows[0]["cDefine7"]);
                    }
                    if (dtRd.Rows[0]["cDefine8"].ToString().Trim() != "")
                    {
                        mod.cDefine8 = dtRd.Rows[0]["cDefine8"].ToString().Trim();
                    }
                    if (dtRd.Rows[0]["cDefine9"].ToString().Trim() != "")
                    {
                        mod.cDefine9 = dtRd.Rows[0]["cDefine9"].ToString().Trim();
                    }
                    if (dtRd.Rows[0]["cDefine10"].ToString().Trim() != "")
                    {
                        mod.cDefine10 = dtRd.Rows[0]["cDefine10"].ToString().Trim();
                    }
                    mod.cAccounter = null;
                    mod.iNetLock   = 1;
                    lID           += 1;
                    mod.ID         = lID;
                    mod.VT_ID      = 89;
                    mod.cMaker     = sUserName;
                    mod.dnmaketime = dLogDate;

                    mod.cVerifyPerson = sUserName;
                    mod.dVerifyDate   = dLogDate;
                    mod.cPSPCode      = null;
                    mod.cMPoCode      = null;
                    mod.iQuantity     = 0;
                    mod.bTransFlag    = null;
                    //if (dtRd.Rows[0]["cDefine11"].ToString().Trim() != "")
                    //{
                    //    mod.cDefine11 = dtRd.Rows[0]["cDefine11"].ToString().Trim();
                    //}
                    mod.cDefine11 = txtEntryNo.Text.Trim();
                    if (dtRd.Rows[0]["cDefine12"].ToString().Trim() != "")
                    {
                        mod.cDefine12 = dtRd.Rows[0]["cDefine12"].ToString().Trim();
                    }
                    if (dtRd.Rows[0]["cDefine13"].ToString().Trim() != "")
                    {
                        mod.cDefine13 = dtRd.Rows[0]["cDefine13"].ToString().Trim();
                    }
                    if (dtRd.Rows[0]["cDefine14"].ToString().Trim() != "")
                    {
                        mod.cDefine14 = dtRd.Rows[0]["cDefine14"].ToString().Trim();
                    }
                    if (dtRd.Rows[0]["cDefine15"].ToString().Trim() != "")
                    {
                        mod.cDefine15 = BaseFunction.ReturnLong(dtRd.Rows[0]["cDefine5"]);
                    }
                    if (dtRd.Rows[0]["cDefine16"].ToString().Trim() != "")
                    {
                        mod.cDefine16 = BaseFunction.ReturnDecimal(dtRd.Rows[0]["cDefine16"]);
                    }

                    mod.iproorderid      = null;
                    mod.cTranRequestCode = null;
                    mod.cVersion         = null;
                    mod.BomId            = null;
                    mod.cFree1           = null;
                    mod.cFree2           = null;
                    mod.cFree3           = null;
                    mod.cFree4           = null;
                    mod.cFree5           = null;
                    mod.cFree6           = null;
                    mod.cFree7           = null;
                    mod.cFree8           = null;
                    mod.cFree9           = null;
                    mod.cFree10          = null;
                    mod.cAppTVCode       = null;
                    mod.csource          = "1";
                    mod.itransflag       = "正向";
                    mod.cModifyPerson    = null;
                    mod.dModifyDate      = null;
                    mod.dnmaketime       = DateTime.Now;
                    mod.dnmodifytime     = null;
                    mod.ireturncount     = null;
                    mod.iverifystate     = null;
                    mod.iswfcontrolled   = 0;
                    mod.csourceguid      = null;
                    mod.csysbarcode      = "||st12||" + mod.cTVCode;

                    mod.cDefine1        = txtEntryNo.Text.Trim();
                    mod.cCurrentAuditor = null;

                    DAL.TransVouch dalTR = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.TransVouch();
                    sSQL    = dalTR.Add(mod);
                    iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);

                    sMCode = sMCode + mod.cTVCode + "\n";

                    int iRow = 0;
                    for (int i = 0; i < gridViewPL.RowCount; i++)
                    {
                        if (!BaseFunction.ReturnBool(gridViewPL.GetRowCellValue(i, gridColSelected)))
                        {
                            continue;
                        }

                        long lRds01Autoid = BaseFunction.ReturnLong(gridViewPL.GetRowCellValue(i, gridColRds01ID));
                        if (lRds01Autoid == 0)
                        {
                            sErr = sErr + "Line " + (i + 1).ToString() + " purchase receipt warrant is not imported\n";
                            continue;
                        }

                        sSQL = @"
select autoid from Rdrecords01 where autoid = aaaaaaaa
";
                        sSQL = sSQL.Replace("aaaaaaaa", lRds01Autoid.ToString());
                        DataTable dtRds01 = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];

                        if (dtRds01 == null || dtRds01.Rows.Count == 0)
                        {
                            sErr = sErr + "Line " + (i + 1).ToString() + " purchase receipt warrant is not imported\n";
                            continue;
                        }


                        long lTRsID = BaseFunction.ReturnLong(gridViewPL.GetRowCellValue(i, gridColTrIDs));
                        if (lTRsID > 0)
                        {
                            sSQL = @"
select autoid from TransVouchs where autoid = aaaaaaaa
";
                            sSQL = sSQL.Replace("aaaaaaaa", lTRsID.ToString());
                            DataTable dtTRs01 = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];

                            if (dtTRs01 != null && dtTRs01.Rows.Count > 0)
                            {
                                sErr = sErr + "Line " + (i + 1).ToString() + " is imported\n";
                                continue;
                            }
                        }

                        Model.TransVouchs mods = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.TransVouchs();
                        mods.cTVCode     = mod.cTVCode;
                        mods.cInvCode    = gridViewPL.GetRowCellValue(i, gridColPARTNO).ToString().Trim();
                        mods.iTVNum      = null;
                        mods.iTVQuantity = BaseFunction.ReturnDecimal(gridViewPL.GetRowCellValue(i, gridColQUANTITY));
                        lIDDetails      += 1;
                        mods.autoID      = lIDDetails;
                        mods.ID          = mod.ID;
                        mods.bCosting    = true;

                        iRow            += 1;
                        mods.irowno      = iRow;
                        mods.coutposcode = null;
                        mods.cinposcode  = null;
                        //mods.cTVBatch = gridViewPL.GetRowCellValue(i, gridColcBatch).ToString().Trim();
                        mods.cDefine22 = gridViewPL.GetRowCellValue(i, gridColCONTAINERNO).ToString().Trim();
                        mods.cDefine23 = gridViewPL.GetRowCellValue(i, gridColBOXNO).ToString().Trim();
                        mods.cDefine24 = gridViewPL.GetRowCellValue(i, gridColCASENO).ToString().Trim();
                        mods.cDefine25 = gridViewPL.GetRowCellValue(i, gridColGWKGS).ToString().Trim();
                        mods.cDefine28 = gridViewPL.GetRowCellValue(i, gridColNWKGS).ToString().Trim();

                        mods.cbsysbarcode = "||st12|" + mod.cTVCode + "|" + iRow.ToString();
                        DAL.TransVouchs dalTRs = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.TransVouchs();
                        sSQL    = dalTRs.Add(mods);
                        iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);

                        //回写导入中间表 Rdrecords10_Import
                        sSQL = @"
update RdRecords01_Import set TrIDs = AAAAAA,EntryNO = 'CCCCCC'
WHERE AUTOID = BBBBBB
";
                        sSQL = sSQL.Replace("AAAAAA", mods.autoID.ToString());
                        sSQL = sSQL.Replace("BBBBBB", gridViewPL.GetRowCellValue(i, gridColAutoID).ToString());
                        sSQL = sSQL.Replace("CCCCCC", txtEntryNo.Text.Trim());
                        int iRet = DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                        if (iRet != 1)
                        {
                            sErr = sErr + "Line " + (i + 1) + " update dl err\n";
                        }

                        decimal dClaimQty = BaseFunction.ReturnDecimal(gridViewPL.GetRowCellValue(i, gridColClaimQty));

                        if (dClaimQty > 0)
                        {
                            bNeedTR = true;
                        }
                    }

                    if (iRow > 0)
                    {
                        clsU8 cls = new clsU8();
                        cls.TransVouch_Audit_U8V111(tran, mod.cTVCode, sAccID, sUserName);
                    }

                    #endregion


                    #region 生成索赔调拨单
                    if (bNeedTR)
                    {
                        sRdCodeIn   = "";
                        sRdCodeOut  = "";
                        sDepCodeIn  = "";
                        sDepCodeOut = "";

                        sSQL   = @"
select * from _Code where VouchType = 'TransVouchClaim'
";
                        dtCode = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                        if (dtCode != null && dtCode.Rows.Count > 0)
                        {
                            sRdCodeIn   = dtCode.Rows[0]["cRdCodeIn"].ToString().Trim();
                            sRdCodeOut  = dtCode.Rows[0]["cRdCodeOut"].ToString().Trim();
                            sDepCodeIn  = dtCode.Rows[0]["cDepCodeIn"].ToString().Trim();
                            sDepCodeOut = dtCode.Rows[0]["cDepCodeOut"].ToString().Trim();
                        }
                        else
                        {
                            throw new Exception("Please set _code [TransVouchClaim]");
                        }

                        if (sRdCodeIn == "" || sRdCodeOut == "")
                        {
                            throw new Exception("Please set _code [TransVouchClaim]");
                        }

                        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'tr',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", iCou.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 * from VoucherHistory with (ROWLOCK) Where CardNumber='0304' AND cSeed = 'aaaaaa'";
                        sSQL = sSQL.Replace("aaaaaa", dLogDate.ToString("yyyyMMdd"));
                        dt   = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];

                        iCode = 0;
                        if (dt != null && dt.Rows.Count > 0)
                        {
                            iCode = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]) + 1;
                            sSQL  = @"
update VoucherHistory set cNumber = aaaaaa where autoid = bbbbbb and CardNumber = '0304'
";
                            sSQL  = sSQL.Replace("aaaaaa", iCode.ToString());
                            sSQL  = sSQL.Replace("bbbbbb", dt.Rows[0]["AutoId"].ToString().Trim());
                            DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                        }
                        else
                        {
                            iCode = 1;
                            sSQL  = @"
insert into VoucherHistory(CardNumber, cContent, cContentRule, cSeed, cNumber, bEmpty)
values('0304','日期','日','aaaaaa',1,0)
";
                            sSQL  = sSQL.Replace("aaaaaa", dLogDate.ToString("yyyyMMdd"));
                            DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                        }
                        iCode += 1;
                        sCode  = iCode.ToString();
                        while (sCode.Length < 4)
                        {
                            sCode = "0" + sCode;
                        }
                        sCode = "TF" + dLogDate.ToString("yyyyMMdd") + sCode;

                        mod         = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.TransVouch();
                        mod.cTVCode = sCode;
                        mod.dTVDate = dLogDate;

                        mod.cOWhCode = lookUpEditWarehouseIN.EditValue.ToString().Trim();
                        if (mod.cOWhCode.ToUpper().StartsWith("A"))
                        {
                            mod.cIWhCode = "A61";
                        }
                        if (mod.cOWhCode.ToUpper().StartsWith("B"))
                        {
                            mod.cIWhCode = "B61";
                        }

                        if (mod.cIWhCode == null || mod.cIWhCode.Trim() == "")
                        {
                            throw new Exception("Please set claim warehouse");
                        }

                        mod.cIRdCode = sRdCodeOut;
                        mod.cORdCode = sRdCodeIn;

                        mod.cIDepCode = sDepCodeIn;
                        mod.cODepCode = sDepCodeOut;

                        mod.cPersonCode = null;
                        mod.cTVMemo     = txtMemo.Text.Trim();

                        if (dtRd.Rows[0]["cDefine1"].ToString().Trim() != "")
                        {
                            mod.cDefine1 = dtRd.Rows[0]["cDefine1"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine2"].ToString().Trim() != "")
                        {
                            mod.cDefine2 = dtRd.Rows[0]["cDefine2"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine3"].ToString().Trim() != "")
                        {
                            mod.cDefine3 = dtRd.Rows[0]["cDefine3"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine4"].ToString().Trim() != "")
                        {
                            mod.cDefine4 = BaseFunction.ReturnDate(dtRd.Rows[0]["cDefine4"]);
                        }
                        if (dtRd.Rows[0]["cDefine5"].ToString().Trim() != "")
                        {
                            mod.cDefine5 = BaseFunction.ReturnLong(dtRd.Rows[0]["cDefine5"]);
                        }
                        if (dtRd.Rows[0]["cDefine6"].ToString().Trim() != "")
                        {
                            mod.cDefine6 = BaseFunction.ReturnDate(dtRd.Rows[0]["cDefine6"]);
                        }
                        if (dtRd.Rows[0]["cDefine7"].ToString().Trim() != "")
                        {
                            mod.cDefine7 = BaseFunction.ReturnDecimal(dtRd.Rows[0]["cDefine7"]);
                        }
                        if (dtRd.Rows[0]["cDefine8"].ToString().Trim() != "")
                        {
                            mod.cDefine8 = dtRd.Rows[0]["cDefine8"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine9"].ToString().Trim() != "")
                        {
                            mod.cDefine9 = dtRd.Rows[0]["cDefine9"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine10"].ToString().Trim() != "")
                        {
                            mod.cDefine10 = dtRd.Rows[0]["cDefine10"].ToString().Trim();
                        }
                        mod.cAccounter = null;
                        mod.iNetLock   = 1;
                        lID           += 1;
                        mod.ID         = lID;
                        mod.VT_ID      = 89;
                        mod.cMaker     = sUserName;
                        mod.dnmaketime = dLogDate;

                        mod.cVerifyPerson = sUserName;
                        mod.dVerifyDate   = dLogDate;
                        mod.cPSPCode      = null;
                        mod.cMPoCode      = null;
                        mod.iQuantity     = 0;
                        mod.bTransFlag    = null;
                        if (dtRd.Rows[0]["cDefine11"].ToString().Trim() != "")
                        {
                            mod.cDefine11 = dtRd.Rows[0]["cDefine11"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine12"].ToString().Trim() != "")
                        {
                            mod.cDefine12 = dtRd.Rows[0]["cDefine12"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine13"].ToString().Trim() != "")
                        {
                            mod.cDefine13 = dtRd.Rows[0]["cDefine13"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine14"].ToString().Trim() != "")
                        {
                            mod.cDefine14 = dtRd.Rows[0]["cDefine14"].ToString().Trim();
                        }
                        if (dtRd.Rows[0]["cDefine15"].ToString().Trim() != "")
                        {
                            mod.cDefine15 = BaseFunction.ReturnLong(dtRd.Rows[0]["cDefine5"]);
                        }
                        if (dtRd.Rows[0]["cDefine16"].ToString().Trim() != "")
                        {
                            mod.cDefine16 = BaseFunction.ReturnDecimal(dtRd.Rows[0]["cDefine16"]);
                        }
                        mod.iproorderid      = null;
                        mod.cTranRequestCode = null;
                        mod.cVersion         = null;
                        mod.BomId            = null;
                        mod.cFree1           = null;
                        mod.cFree2           = null;
                        mod.cFree3           = null;
                        mod.cFree4           = null;
                        mod.cFree5           = null;
                        mod.cFree6           = null;
                        mod.cFree7           = null;
                        mod.cFree8           = null;
                        mod.cFree9           = null;
                        mod.cFree10          = null;
                        mod.cAppTVCode       = null;
                        mod.csource          = "1";
                        mod.itransflag       = "正向";
                        mod.cModifyPerson    = null;
                        mod.dModifyDate      = null;
                        mod.dnmaketime       = DateTime.Now;
                        mod.dnmodifytime     = null;
                        mod.ireturncount     = null;
                        mod.iverifystate     = null;
                        mod.iswfcontrolled   = 0;
                        mod.csourceguid      = null;
                        mod.csysbarcode      = "||st12||" + mod.cTVCode;

                        mod.cDefine1        = txtEntryNo.Text.Trim();
                        mod.cCurrentAuditor = null;

                        dalTR   = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.TransVouch();
                        sSQL    = dalTR.Add(mod);
                        iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);

                        sMCode = sMCode + mod.cTVCode + "\n";

                        iRow = 0;
                        for (int i = 0; i < gridViewPL.RowCount; i++)
                        {
                            if (!BaseFunction.ReturnBool(gridViewPL.GetRowCellValue(i, gridColSelected)))
                            {
                                continue;
                            }



                            decimal dQty      = BaseFunction.ReturnDecimal(gridViewPL.GetRowCellValue(i, gridColQUANTITY));
                            decimal dClaimQty = BaseFunction.ReturnDecimal(gridViewPL.GetRowCellValue(i, gridColClaimQty));
                            if (dClaimQty < 0 || dClaimQty > dQty)
                            {
                                sErr = sErr + "Line " + (i + 1).ToString() + " the claim quantity is wrong\n";
                                continue;
                            }
                            if (dClaimQty == 0)
                            {
                                continue;
                            }

                            long lRds01Autoid = BaseFunction.ReturnLong(gridViewPL.GetRowCellValue(i, gridColRds01ID));
                            if (lRds01Autoid == 0)
                            {
                                sErr = sErr + "Line " + (i + 1).ToString() + " purchase receipt warrant is not imported\n";
                                continue;
                            }

                            sSQL = @"
select autoid from Rdrecords01 where autoid = aaaaaaaa
";
                            sSQL = sSQL.Replace("aaaaaaaa", lRds01Autoid.ToString());
                            DataTable dtRds01 = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];

                            if (dtRds01 == null || dtRds01.Rows.Count == 0)
                            {
                                sErr = sErr + "Line " + (i + 1).ToString() + " purchase receipt warrant is not imported\n";
                                continue;
                            }


                            long lTRsID = BaseFunction.ReturnLong(gridViewPL.GetRowCellValue(i, gridColTrIDs));
                            if (lTRsID > 0)
                            {
                                sSQL = @"
select autoid from TransVouchs where autoid = aaaaaaaa
";
                                sSQL = sSQL.Replace("aaaaaaaa", lTRsID.ToString());
                                DataTable dtTRs01 = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];

                                if (dtTRs01 != null && dtTRs01.Rows.Count > 0)
                                {
                                    sErr = sErr + "Line " + (i + 1).ToString() + " is imported\n";
                                    continue;
                                }
                            }

                            Model.TransVouchs mods = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.TransVouchs();
                            mods.cTVCode  = mod.cTVCode;
                            mods.cInvCode = gridViewPL.GetRowCellValue(i, gridColPARTNO).ToString().Trim();
                            mods.iTVNum   = null;

                            mods.iTVQuantity = dClaimQty;
                            lIDDetails      += 1;
                            mods.autoID      = lIDDetails;
                            mods.ID          = mod.ID;
                            mods.bCosting    = true;

                            iRow            += 1;
                            mods.irowno      = iRow;
                            mods.coutposcode = null;
                            mods.cinposcode  = null;
                            //mods.cTVBatch = gridViewPL.GetRowCellValue(i, gridColcBatch).ToString().Trim();
                            mods.cDefine22 = gridViewPL.GetRowCellValue(i, gridColCONTAINERNO).ToString().Trim();
                            mods.cDefine23 = gridViewPL.GetRowCellValue(i, gridColBOXNO).ToString().Trim();
                            mods.cDefine24 = gridViewPL.GetRowCellValue(i, gridColCASENO).ToString().Trim();
                            mods.cDefine25 = gridViewPL.GetRowCellValue(i, gridColGWKGS).ToString().Trim();
                            mods.cDefine28 = gridViewPL.GetRowCellValue(i, gridColNWKGS).ToString().Trim();

                            mods.cbsysbarcode = "||st12|" + mod.cTVCode + "|" + iRow.ToString();
                            DAL.TransVouchs dalTRs = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.TransVouchs();
                            sSQL    = dalTRs.Add(mods);
                            iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);

                            //回写导入中间表 Rdrecords10_Import
                            sSQL = @"
update RdRecords01_Import set TrIDsClaim = AAAAAA,ClaimQty = DDDDDD
WHERE AUTOID = BBBBBB
";
                            sSQL = sSQL.Replace("AAAAAA", mods.autoID.ToString());
                            sSQL = sSQL.Replace("BBBBBB", gridViewPL.GetRowCellValue(i, gridColAutoID).ToString());
                            sSQL = sSQL.Replace("DDDDDD", BaseFunction.ReturnDecimal(gridViewPL.GetRowCellValue(i, gridColClaimQty)).ToString().Trim());
                            int iRet = DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                        }

                        if (iRow > 0)
                        {
                            clsU8 cls = new clsU8();
                            cls.TransVouch_Audit_U8V111(tran, mod.cTVCode, sAccID, sUserName);
                        }
                    }

                    #endregion

                    if (sErr != "")
                    {
                        throw new Exception(sErr);
                    }

                    if (iCount > 0)
                    {
                        tran.Commit();
                        MessageBox.Show("Success:\n" + sMCode);

                        SetTxtNull();
                    }
                    else
                    {
                        throw new Exception("Save failed");
                    }
                }
                catch (Exception error)
                {
                    tran.Rollback();
                    throw new Exception(error.Message);
                }
            }
            catch (Exception ee)
            {
                FrmMsgBox frm = new FrmMsgBox();
                frm.richTextBox1.Text = ee.Message;
                frm.ShowDialog();
            }
        }
Ejemplo n.º 2
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                gridView1.FocusedRowHandle -= 1;
                gridView1.FocusedRowHandle += 1;
            }
            catch { }

            txtBarCode.Focus();
            string sErr = "";

            int iCount = 0;

            try
            {
                string sProcess     = gridView1.GetRowCellValue(0, gridColProcess).ToString().Trim();
                string sProcessNext = gridView1.GetRowCellValue(0, gridColProcessNext).ToString().Trim();
                if (sProcess == sProcessNext)
                {
                    throw new Exception("Process is err");
                }

                SqlConnection conn = new SqlConnection(Conn);
                conn.Open();
                SqlTransaction tran = conn.BeginTransaction();
                try
                {
                    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"));

                    int    iYear   = dNow.Year;
                    int    iPeriod = dNow.Month;
                    string s期间     = BaseFunction.ReturnDate(iYear.ToString() + "-" + iPeriod.ToString() + "-01").ToString("yyyyMM");
                    sSQL = "select isnull(bflag_ST,0) as bflag from GL_mend where iYPeriod = '" + s期间 + "'";
                    DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                    if (dt == null || dt.Rows.Count == 0)
                    {
                        throw new Exception("Access module state failure");
                    }
                    int i结账 = BaseFunction.ReturnInt(dt.Rows[0]["bflag"]);
                    if (i结账 > 0)
                    {
                        throw new Exception(dNow.ToString("yyyy-MM") + " have checked out");
                    }

                    //判断是否转入质检工序
                    bool bIQCIn = false;  //材料入库检验
                    bool bOQCIn = false;  //产品销售出库检验
                    sSQL = @"
select cWhMemo
from Warehouse 
where cWhCode = '{0}'
";
                    sSQL = string.Format(sSQL, lookUpEditProcessNext.EditValue.ToString().Trim());
                    dt   = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                    if (dt.Rows[0]["cWhMemo"].ToString().Trim().ToLower().Contains("iqc"))
                    {
                        bIQCIn = true;
                    }
                    if (dt.Rows[0]["cWhMemo"].ToString().Trim().ToLower().Contains("oqc"))
                    {
                        bOQCIn = true;
                    }


                    //判断是否从质检工序转出
                    bool bIQCOut = false;  //材料入库检验工序转出
                    bool bOQCOut = false;  //产品销售出库检验工序转出
                    sSQL = @"
select cWhMemo
from Warehouse 
where cWhCode = '{0}'
";
                    sSQL = string.Format(sSQL, lookUpEditProcess.EditValue.ToString().Trim());
                    dt   = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                    if (dt.Rows[0]["cWhMemo"].ToString().Trim().ToLower().Contains("iqc"))
                    {
                        bIQCOut = true;
                    }
                    if (dt.Rows[0]["cWhMemo"].ToString().Trim().ToLower().Contains("oqc"))
                    {
                        bOQCOut = true;
                    }

                    #region 流转

                    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'tr',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);
                    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;

                    ////获得单据号
                    sSQL = "select * from VoucherHistory with (ROWLOCK) Where CardNumber='0304' AND cContentRule = 'YYYY' AND cSeed = 'aaaaaa'";
                    sSQL = sSQL.Replace("aaaaaa", dNow.ToString("yyyy"));
                    dt   = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];

                    long lCode = 0;
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        lCode = BaseFunction.ReturnLong(dt.Rows[0]["cNumber"]);
                    }
                    else
                    {
                        lCode = 0;
                    }
                    lCode += 1;
                    string sCode = lCode.ToString();
                    while (sCode.Length < 6)
                    {
                        sCode = "0" + sCode;
                    }
                    sCode = "TR" + dNow.ToString("yyyy") + sCode;

                    Model.TransVouch mod = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.TransVouch();
                    mod.cTVCode     = sCode;
                    mod.dTVDate     = dNowDate;
                    mod.cOWhCode    = lookUpEditProcess.EditValue.ToString().Trim();
                    mod.cIWhCode    = lookUpEditProcessNext.EditValue.ToString().Trim();
                    mod.cODepCode   = null;
                    mod.cIDepCode   = null;
                    mod.cPersonCode = null;
                    mod.cIRdCode    = "TI";
                    mod.cORdCode    = "TO";
                    mod.cTVMemo     = null;
                    mod.cDefine1    = null;
                    mod.cDefine2    = null;
                    mod.cDefine3    = null;
                    mod.cDefine4    = null;
                    mod.cDefine5    = null;
                    mod.cDefine6    = null;
                    mod.cDefine7    = null;
                    mod.cDefine8    = null;
                    mod.cDefine9    = null;
                    mod.cDefine10   = null;
                    mod.cAccounter  = null;
                    mod.iNetLock    = 1;
                    lID            += 1;
                    mod.ID          = lID;
                    mod.VT_ID       = 89;
                    mod.cMaker      = sUserName;
                    mod.dnmaketime  = dNow;

                    mod.cVerifyPerson    = sUserName;
                    mod.dVerifyDate      = dNowDate;
                    mod.cPSPCode         = null;
                    mod.cMPoCode         = null;
                    mod.iQuantity        = 0;
                    mod.bTransFlag       = null;
                    mod.cDefine11        = null;
                    mod.cDefine12        = null;
                    mod.cDefine13        = null;
                    mod.cDefine14        = null;
                    mod.cDefine15        = null;
                    mod.cDefine16        = null;
                    mod.iproorderid      = null;
                    mod.cTranRequestCode = null;
                    mod.cVersion         = null;
                    mod.BomId            = null;
                    mod.cFree1           = null;
                    mod.cFree2           = null;
                    mod.cFree3           = null;
                    mod.cFree4           = null;
                    mod.cFree5           = null;
                    mod.cFree6           = null;
                    mod.cFree7           = null;
                    mod.cFree8           = null;
                    mod.cFree9           = null;
                    mod.cFree10          = null;
                    mod.cAppTVCode       = null;
                    mod.csource          = "1";
                    mod.itransflag       = "正向";
                    mod.cModifyPerson    = null;
                    mod.dModifyDate      = null;
                    mod.dnmaketime       = dNow;
                    mod.dnmodifytime     = null;
                    mod.ireturncount     = null;
                    mod.iverifystate     = null;
                    mod.iswfcontrolled   = 0;
                    mod.csourceguid      = null;
                    mod.csysbarcode      = "||st12||" + mod.cTVCode;
                    DAL.TransVouch dalTR = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.TransVouch();
                    sSQL    = dalTR.Add(mod);
                    iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                    mod.cCurrentAuditor = null;

                    int iRow = 0;
                    for (int i = 0; i < gridView1.RowCount; i++)
                    {
                        if (!BaseFunction.ReturnBool(gridView1.GetRowCellValue(i, gridColchoose)))
                        {
                            continue;
                        }

                        string sBarCode = gridView1.GetRowCellValue(i, gridColLotNO).ToString().Trim();
                        sSQL = @"
select * from _BarCodeLabel  where [BarCode] = '{0}' and iSOsID = {1}";
                        sSQL = string.Format(sSQL, sBarCode, gridView1.GetRowCellValue(i, gridColiSOsID).ToString());
                        dt   = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                        if (dt == null || dt.Rows.Count == 0)
                        {
                            sErr = sErr + "row " + (i + 1).ToString() + "is not exists \n";
                            continue;
                        }
                        if (dt.Rows[0]["CloseUid"].ToString().Trim() != "")
                        {
                            sErr = sErr + "row " + (i + 1).ToString() + " is closed \n";
                            continue;
                        }
                        if (dt.Rows[0]["Process"].ToString().Trim().ToLower() != lookUpEditProcess.EditValue.ToString().Trim().ToLower())
                        {
                            sErr = sErr + "row " + (i + 1).ToString() + "  process is changed \n";
                            continue;
                        }
                        if (BaseFunction.ReturnDecimal(dt.Rows[0]["LotQTY"]) != BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColLOTQTY)))
                        {
                            sErr = sErr + "row " + (i + 1).ToString() + " number is changed \n";
                            continue;
                        }
                        if (dt.Rows[0]["IQCStatus"].ToString() != gridView1.GetRowCellValue(i, gridColIQCStatus).ToString().Trim())
                        {
                            sErr = sErr + "row " + (i + 1).ToString() + " iqcstatus is changed \n";
                            continue;
                        }
                        if (dt.Rows[0]["OQCStatus"].ToString() != gridView1.GetRowCellValue(i, gridColOQCStatus).ToString().Trim())
                        {
                            sErr = sErr + "row " + (i + 1).ToString() + " iqcstatus is changed \n";
                            continue;
                        }

                        iRow += 1;
                        Model.BarStatus model = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.BarStatus();
                        model.BarCode = sBarCode;
                        model.iSOsID  = BaseFunction.ReturnLong(gridView1.GetRowCellValue(i, gridColiSOsID));
                        model.Type    = "工序流转";
                        if (bIQCIn)
                        {
                            model.Type = "IQC";

                            sSQL = @"
update  _IQC_RMDF set ClosedUid = '{0}',dtmClose = getdate()
where LotNo = '{1}' and iSOsID = '{2}' and isnull(ClosedUid,'') <> ''
";
                            sSQL = string.Format(sSQL, sUserID, model.BarCode, model.iSOsID);
                            DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                        }
                        if (bOQCIn)
                        {
                            model.Type = "OQC";
                        }

                        model.RoutingFrom = lookUpEditProcess.EditValue.ToString().Trim();
                        model.RoutingTo   = lookUpEditProcessNext.EditValue.ToString().Trim();
                        model.UpdateTime  = dNow;
                        model.QTY         = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColLOTQTY));
                        model.CreateUid   = sUserID;
                        model.CreateDate  = dNow;
                        DAL.BarStatus dal = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.BarStatus();
                        sSQL    = dal.Add(model);
                        iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);

                        //回写上一道工序的结束时间
                        sSQL = @"
declare @iID int 
select @iID = max(iID)
from _BarStatus
where [BarCode] = '{0}' and iSOsID = '{1}'
    and iID < (
        select max(iID) as maxID
        from _BarStatus
        where [BarCode] = '{0}' and iSOsID = '{1}'
    )

update _BarStatus set EndTime = '{2}' where iID = @iID and [BarCode] = '{0}' and iSOsID = '{1}'
";
                        sSQL = string.Format(sSQL, sBarCode, model.iSOsID, dNow);
                        DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);

                        if (bIQCOut)
                        {
                            sSQL = @"
select *
from _BarCodeLabel
where [BarCode] = '{0}' and iSOsID = '{1}'
";
                            sSQL = string.Format(sSQL, sBarCode, model.iSOsID);
                            DataTable dtQC       = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                            string    sIQCStatus = dtQC.Rows[0]["IQCStatus"].ToString().Trim().ToLower();
                            sIQCStatus = sIQCStatus.Replace(" ", "");
                            if (!sIQCStatus.ToLower().StartsWith("iqc"))
                            {
                                sErr = sErr + "row " + (i + 1).ToString() + " IQC not passed \n";
                                continue;
                            }
                        }
                        if (bOQCOut)
                        {
                            sSQL = @"
select *
from _BarCodeLabel
where [BarCode] = '{0}' and iSOsID = '{1}'
";
                            sSQL = string.Format(sSQL, sBarCode, model.iSOsID);
                            DataTable dtQC       = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0];
                            string    sOQCStatus = dtQC.Rows[0]["OQCStatus"].ToString().Trim().ToLower();
                            sOQCStatus = sOQCStatus.Replace(sOQCStatus, " ");
                            if (sOQCStatus == "oqc-ONHOLD".ToLower())
                            {
                                sErr = sErr + "row " + (i + 1).ToString() + " OQC onhold \n";
                                continue;
                            }
                        }

                        //回写 BarCodeLabel
                        sSQL = "update [_BarCodeLabel] set process = '" + model.RoutingTo + "',Status = '流转' where [BarCode] = '" + sBarCode + "' and iSOsID = '" + model.iSOsID + "'";
                        DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);

                        if (bIQCIn)
                        {
                            sSQL = "update [_BarCodeLabel] set IQCStatus = 'Pending IQC',Status = 'IQC' where [BarCode] = '" + sBarCode + "' and iSOsID = '" + model.iSOsID + "'";
                            int iRunCou = DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                        }
                        if (bOQCIn)
                        {
                            sSQL = "update [_BarCodeLabel] set OQCStatus = 'Pending OQC',Status = 'OQC' where [BarCode] = '" + sBarCode + "' and iSOsID = '" + model.iSOsID + "'";
                            DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                        }

                        Model.TransVouchs mods = new UFIDA.U8.UAP.CustomApp.ControlForm.Model.TransVouchs();
                        mods.cTVCode     = mod.cTVCode;
                        mods.cInvCode    = gridView1.GetRowCellValue(i, gridColItemNO).ToString().Trim();
                        mods.iTVNum      = null;
                        mods.iTVQuantity = BaseFunction.ReturnDecimal(gridView1.GetRowCellValue(i, gridColLOTQTY));
                        lIDDetails      += 1;
                        mods.autoID      = lIDDetails;
                        mods.ID          = mod.ID;
                        mods.bCosting    = true;
                        mods.irowno      = iRow;
                        mods.coutposcode = null;
                        mods.cinposcode  = null;
                        mods.cTVBatch    = gridView1.GetRowCellValue(i, gridColcBatch).ToString().Trim();


                        mods.cbsysbarcode = "||st12|" + mod.cTVCode + "|" + iRow.ToString();
                        DAL.TransVouchs dalTRs = new UFIDA.U8.UAP.CustomApp.ControlForm.DAL.TransVouchs();
                        sSQL    = dalTRs.Add(mods);
                        iCount += DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);
                    }

                    if (sErr.Length > 0)
                    {
                        throw new Exception(sErr);
                    }

                    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 = 'tr'";
                    DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);


                    sSQL = @"
                    if exists(select * from VoucherHistory where CardNumber='0304' AND cContentRule = 'YYYY' AND cSeed = 'bbbbbb')
                        update VoucherHistory set cNumber = aaaaaa  where CardNumber = '0304' AND cContentRule = 'YYYY' AND cSeed = 'bbbbbb'
                    else
                        insert into VoucherHistory(CardNumber,cContent,cContentRule,cSeed,cNumber,bEmpty)
                        values('0304','日期','YYYY','bbbbbb','aaaaaa',0)
                    ";
                    sSQL = sSQL.Replace("aaaaaa", lCode.ToString());
                    sSQL = sSQL.Replace("bbbbbb", dNow.ToString("yyyy"));
                    DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL);

                    clsU8 cls = new clsU8();
                    cls.TransVouch_Audit_U8V111(tran, mod.cTVCode, sAccID, sUserName);


                    #endregion

                    if (iCount > 0)
                    {
                        tran.Commit();

                        MessageBox.Show("OK\n");

                        SetTxtNull();

                        gridControl1.DataSource = DbHelperSQL.Query(sSQLBar);
                        txtBarCode.Focus();
                    }
                }
                catch (Exception ee)
                {
                    tran.Rollback();
                    throw new Exception(ee.Message);
                }
            }
            catch (Exception ee)
            {
                FrmMsgBox frm = new FrmMsgBox();
                frm.richTextBox1.Text = ee.Message;
                frm.ShowDialog();
            }
            gridColScanTime.SortOrder = DevExpress.Data.ColumnSortOrder.Descending;
        }