Esempio n. 1
0
        /// <summary>
        /// 填充主表数据
        /// </summary>
        /// <returns></returns>
        private void FillBill(string cOrderNumber, string cNewEasOrder)
        {
            var iof = new InterfaceOracleFunction(Properties.Settings.Default.EasCon);

            mrbill.FID = iof.GetFID("FA1292B4");

            //制单人取生产订单审核人
            var cProductId = iof.GetProductOrderID(cOrderNumber);
            var cUserId    = iof.GetUserIDByOrderNumber(cProductId, "T_MM_ProductionOrder");

            mrbill.FCREATORID = string.IsNullOrEmpty(cUserId) ? "K7Li625bRC6r8uAH5mlIDRO33n8=" : cUserId;

            mrbill.FCREATETIME = DateTime.Now;
            //mrbill.FLASTUPDATEUSERID = "OWRO3YImRBq4cK8lmqmQ/RO33n8=";
            //mrbill.FLASTUPDATETIME = ;
            _storageUnit          = iof.GetStorageUnitByOrderNumber(cOrderNumber, "T_MM_FinishedRpt");
            mrbill.FCONTROLUNITID = _storageUnit;
            mrbill.FNUMBER        = cNewEasOrder;

            var dDate = iof.ReturnBizDate();

            mrbill.FBIZDATE      = dDate;
            mrbill.FAUDITORID    = "";
            mrbill.FSOURCEBILLID = iof.GetSourIDByOrderNumber(cOrderNumber, "T_MM_FinishedRpt");
            //mrbill.FSOURCEFUNCTION = "";
            //mrbill.FAUDITTIME = "";
            //单据状态为保存状态
            mrbill.FBASESTATUS        = "1";
            mrbill.FBIZTYPEID         = "Nz878AEgEADgAABFwKg/GiQHQ1w=";
            mrbill.FSOURCEBILLTYPEID  = "e3soUQaBR8un8D2R7UpNwkY+1VI=";
            mrbill.FBILLTYPEID        = "50957179-0105-1000-e000-0167c0a812fd463ED552";
            mrbill.FYEAR              = int.Parse(dDate.ToString("yyyy"));
            mrbill.FPERIOD            = int.Parse(dDate.ToString("MM"));
            mrbill.FSTORAGEORGUNITID  = _storageUnit;
            mrbill.FADMINORGUNITID    = iof.GetWorkShopIDByOrderNumber(cOrderNumber, "T_MM_FinishedRpt");
            mrbill.FSTOCKERID         = "";
            mrbill.FTOTALQTY          = 0;
            mrbill.FTOTALAMOUNT       = 0;
            mrbill.FFIVOUCHERED       = 0;
            mrbill.FTOTALSTANDARDCOST = 0;
            mrbill.FTOTALACTUALCOST   = 0;
            mrbill.FISREVERSED        = 0;
            mrbill.FTRANSACTIONTYPEID = "DawAAAAPoCqwCNyn";
            mrbill.FISINITBILL        = 0;
            //mrbill.FMODIFIERID = "OWRO3YImRBq4cK8lmqmQ/RO33n8=";
            //mrbill.FMODIFICATIONTIME = "03-7月 -14 04.25.49.939000000 下午";
            mrbill.FCOSTCENTERORGUNITID = mrbill.FADMINORGUNITID;
            mrbill.FISBACKFLUSHSUCCEED  = "5";
            mrbill.FMONTH            = int.Parse(dDate.ToString("yyyyMM"));
            mrbill.FDAY              = int.Parse(dDate.ToString("yyyyMMdd"));
            mrbill.FPROCESSORGUNITID = _storageUnit;
        }
Esempio n. 2
0
        /// <summary>
        /// 填充子表数据
        /// </summary>
        /// <returns></returns>
        private void FillBillEntry(string cOrderNumber, string cInvCode, string iQuantity, string cInvName, string cLotNo, int iRowIndex)
        {
            var iof = new InterfaceOracleFunction(Properties.Settings.Default.EasCon);

            mibillEntry.FPARENTID    = mibill.FID;
            mibillEntry.FSTORETYPEID = "181875d5-0105-1000-e000-0111c0a812fd97D461A6";

            var dDate = iof.ReturnBizDate();

            mibillEntry.FBIZDATE          = dDate.Date;
            mibillEntry.FSTORAGEORGUNITID = _storageUnit;
            mibillEntry.FCOMPANYORGUNITID = _storageUnit;



            mibillEntry.FMATERIALID = iof.GetInvCode(cInvCode);
            //数量
            var     cQty = iQuantity;
            decimal iQty;

            if (!decimal.TryParse(cQty, out iQty))
            {
                iQty = 0;
            }
            mibillEntry.FQTY        = iQty;
            mibillEntry.FBASEQTY    = iQty;
            mibillEntry.FUNITID     = iof.GetInvUnit(mibillEntry.FMATERIALID);
            mibillEntry.FBASEUNITID = mibillEntry.FUNITID;
            mibillEntry.FSEQ        = iRowIndex;
            mibillEntry.FID         = iof.GetFID("0924D401");

            mibillEntry.FSTOCKTRANSFERBILLID = iof.GetSourIDByOrderNumber(cOrderNumber, "T_IM_StockTransferBill");
            //获取调拨单分录ID
            if (string.IsNullOrEmpty(cLotNo))
            {
                mibillEntry.FSTOCKTRANSBILLENTRYID = iof.GetEntrySourIDByOrderNumber(mibillEntry.FSTOCKTRANSFERBILLID, mibillEntry.FMATERIALID, "T_IM_StockTransferBillEntry");
            }
            else
            {
                mibillEntry.FSTOCKTRANSBILLENTRYID = iof.GetEntrySourIDByOrderNumberAndLotNo(mibillEntry.FSTOCKTRANSFERBILLID, mibillEntry.FMATERIALID, "T_IM_StockTransferBillEntry", cLotNo);
            }

            if (string.IsNullOrEmpty(mibillEntry.FSTOCKTRANSBILLENTRYID))
            {
                mibillEntry.FSTOCKTRANSBILLENTRYID = iof.GetEntrySourIDByOrderNumber(mibillEntry.FSTOCKTRANSFERBILLID, mibillEntry.FMATERIALID, "T_IM_StockTransferBillEntry");
            }

            mibillEntry.FWAREHOUSEID          = iof.GetFIssueWarehouseIDByFID(mibillEntry.FSTOCKTRANSBILLENTRYID, "T_IM_StockTransferBillEntry");
            mibillEntry.FSTOCKTRANSFERBILLNUM = cOrderNumber;
            var cSeq = iof.GetEntrySeqByEntryFid(mibillEntry.FSTOCKTRANSBILLENTRYID, "T_IM_StockTransferBillEntry");
            int iSeq;

            if (!int.TryParse(cSeq, out iSeq))
            {
                iSeq = 1;
            }

            mibillEntry.FSTOCKTRANSFERBILLENTRYSEQ = iSeq;
            mibillEntry.FTOTALINWAREHSQTY          = 0;
            mibillEntry.FCANINWAREHSBASEQTY        = 0;
            mibillEntry.FBASEUNITACTUALCOST        = 0;
            mibillEntry.FCUSTOMERID = "";
            mibillEntry.FSUPPLIERID = "";
            mibillEntry.FPRICE      = 0;
            mibillEntry.FAMOUNT     = 0;
            //mibillEntry.FLOCATIONID = "0";
            //mibillEntry.FSTOCKERID = "0";
            //是否批次管理
            //var bLot = iof.GetBLotById(mibillEntry.FMATERIALID);
            var bLot = iof.GetBLotById(mibillEntry.FMATERIALID, mibillEntry.FSTORAGEORGUNITID);

            if (bLot.Equals("1"))
            {
                mibillEntry.FLOT = cLotNo;
            }
            else
            {
                mibillEntry.FLOT = "";
            }
            mibillEntry.FASSISTQTY        = 0;
            mibillEntry.FREVERSEQTY       = 0;
            mibillEntry.FRETURNSQTY       = 0;
            mibillEntry.FUNITSTANDARDCOST = 0;
            mibillEntry.FSTANDARDCOST     = 0;
            mibillEntry.FUNITACTUALCOST   = 0;
            mibillEntry.FACTUALCOST       = 0;
            mibillEntry.FISPRESENT        = 0;
            //mibillEntry.FMFG = "";
            //mibillEntry.FEXP = "";
            mibillEntry.FREVERSEBASEQTY = 0;
            mibillEntry.FRETURNBASEQTY  = 0;
            //mibillEntry.FPROJECTID = "0";
            //mibillEntry.FTRACKNUMBERID = "0";
            //mibillEntry.FASSISTPROPERTYID = "0";
            mibillEntry.FSOURCEBILLID = mibillEntry.FSTOCKTRANSFERBILLID;

            mibillEntry.FSOURCEBILLNUMBER   = cOrderNumber;
            mibillEntry.FSOURCEBILLENTRYID  = mibillEntry.FSTOCKTRANSBILLENTRYID;
            mibillEntry.FSOURCEBILLENTRYSEQ = iSeq;
            mibillEntry.FASSCOEFFICIENT     = 0;
            mibillEntry.FBASESTATUS         = 2;
            mibillEntry.FASSOCIATEQTY       = iQty;
            mibillEntry.FSOURCEBILLTYPEID   = "50957179-0105-1000-e003-3152c0a812fd463ED552";
        }
Esempio n. 3
0
        /// <summary>
        /// 填充子表数据
        /// </summary>
        /// <returns></returns>
        private void FillBillEntry(string cOrderNumber, string cInvCode, string iQuantity, string cInvName, string cLotNo, int iRowIndex)
        {
            var iof = new InterfaceOracleFunction(Properties.Settings.Default.EasCon);

            mrbillEntry.FID               = iof.GetFID("DBE1161E");
            mrbillEntry.FSEQ              = iRowIndex;
            mrbillEntry.FSOURCEBILLID     = iof.GetSourIDByOrderNumber(cOrderNumber, "T_MM_FinishedRpt");
            mrbillEntry.FSOURCEBILLNUMBER = cOrderNumber;
            //物料ID
            mrbillEntry.FMATERIALID = iof.GetInvCode(cInvCode);

            mrbillEntry.FSOURCEBILLENTRYID = iof.GetEntrySourIDByOrderNumber(mrbillEntry.FSOURCEBILLID, mrbillEntry.FMATERIALID, "T_MM_FinishedRptEntry");
            var cSeq = iof.GetEntrySeqByEntryFid(mrbillEntry.FSOURCEBILLENTRYID, "T_MM_FinishedRptEntry");
            int iSeq;

            if (!int.TryParse(cSeq, out iSeq))
            {
                iSeq = 1;
            }

            mrbillEntry.FSOURCEBILLENTRYSEQ = iSeq;
            mrbillEntry.FASSCOEFFICIENT     = 0;
            mrbillEntry.FBASESTATUS         = 2;

            //数量
            var     cQty = iQuantity;
            decimal iQty;

            if (!decimal.TryParse(cQty, out iQty))
            {
                iQty = 0;
            }
            mrbillEntry.FASSOCIATEQTY     = iQty;
            mrbillEntry.FSOURCEBILLTYPEID = "e3soUQaBR8un8D2R7UpNwkY+1VI=";

            mrbillEntry.FUNITID           = iof.GetInvUnit(mrbillEntry.FMATERIALID);
            mrbillEntry.FBASEUNITID       = mrbillEntry.FUNITID;
            mrbillEntry.FSTORAGEORGUNITID = _storageUnit;
            mrbillEntry.FCOMPANYORGUNITID = _storageUnit;
            mrbillEntry.FWAREHOUSEID      = iof.GetWarehouseIDByfID(mrbillEntry.FSOURCEBILLENTRYID, "T_MM_FinishedRptEntry");
            //是否批次管理
            //var bLot = iof.GetBLotById(mrbillEntry.FMATERIALID);
            var bLot = iof.GetBLotById(mrbillEntry.FMATERIALID, mrbillEntry.FSTORAGEORGUNITID);

            if (bLot.Equals("1"))
            {
                mrbillEntry.FLOT = cLotNo;
            }
            else
            {
                mrbillEntry.FLOT = "";
            }

            mrbillEntry.FQTY               = iQty;
            mrbillEntry.FASSISTQTY         = 0;
            mrbillEntry.FBASEQTY           = iQty;
            mrbillEntry.FREVERSEQTY        = 0;
            mrbillEntry.FRETURNSQTY        = 0;
            mrbillEntry.FPRICE             = 0;
            mrbillEntry.FAMOUNT            = 0;
            mrbillEntry.FUNITSTANDARDCOST  = 0;
            mrbillEntry.FSTANDARDCOST      = 0;
            mrbillEntry.FUNITACTUALCOST    = 0;
            mrbillEntry.FACTUALCOST        = 0;
            mrbillEntry.FISPRESENT         = 0;
            mrbillEntry.FPARENTID          = mrbill.FID;
            mrbillEntry.FMANUBILLID        = iof.GetFProductionOrderID(mrbill.FSOURCEBILLID);
            mrbillEntry.FREVERSEBASEQTY    = 0;
            mrbillEntry.FRETURNBASEQTY     = 0;
            mrbillEntry.FCOSTOBJECTID      = iof.GetCostByID(mrbillEntry.FMATERIALID, _storageUnit);//iof.GetCostByID(mrbillEntry.FMATERIALID)
            mrbillEntry.FRECQTY            = 0;
            mrbillEntry.FBASERECQTY        = 0;
            mrbillEntry.FMANUBILLNUMBER    = iof.GetWorkOrder(mrbillEntry.FMANUBILLID);
            mrbillEntry.FRECEIVEQTY        = iQty;
            mrbillEntry.FMANUBILLENTRYSEQ  = 0;
            mrbillEntry.FSALEORDERENTRYSEQ = 0;

            var dDate = iof.ReturnBizDate();

            mrbillEntry.FBIZDATE             = dDate;
            mrbillEntry.FCOSTCENTERORGUNITID = iof.GetWorkShopIDByOrderNumber(cOrderNumber);;
            mrbillEntry.FADMINORGUNITID      = mrbillEntry.FCOSTCENTERORGUNITID;
        }
Esempio n. 4
0
        /// <summary>
        /// 填充子表数据
        /// </summary>
        /// <returns></returns>
        private void FillBillEntry(string cOrderNumber, string cInvCode, string iQuantity, string cInvName, string cLotNo, int iRowIndex)
        {
            var iof = new InterfaceOracleFunction(Properties.Settings.Default.EasCon);

            var dDate = iof.ReturnBizDate();

            mrbillEntry.FID         = iof.GetFID("11774BB4");
            mrbillEntry.FSEQ        = iRowIndex;
            mrbillEntry.FMATERIALID = iof.GetInvCode(cInvCode);

            mrbillEntry.FSOURCEBILLID       = iof.GetSourIDByOrderNumber(cOrderNumber, "T_MM_ProductionOrder");
            mrbillEntry.FSOURCEBILLNUMBER   = cOrderNumber;
            mrbillEntry.FSOURCEBILLENTRYID  = iof.GetEntrySourIDByOrderNumber(mrbillEntry.FSOURCEBILLID, mrbillEntry.FMATERIALID, "T_MM_ProductionOrderSEntry");
            mrbillEntry.FSOURCEBILLENTRYSEQ = 0;
            mrbillEntry.FASSCOEFFICIENT     = 0;
            mrbillEntry.FBASESTATUS         = 2;

            //数量
            var     cQty = iQuantity;
            decimal iQty;

            if (!decimal.TryParse(cQty, out iQty))
            {
                iQty = 0;
            }
            mrbillEntry.FASSOCIATEQTY     = iQty;
            mrbillEntry.FSOURCEBILLTYPEID = "ejIZHXXTQliYCQJg9t4Re0Y+1VI=";

            mrbillEntry.FUNITID           = iof.GetInvUnit(mrbillEntry.FMATERIALID);
            mrbillEntry.FBASEUNITID       = mrbillEntry.FUNITID;
            mrbillEntry.FSTORAGEORGUNITID = _storageUnit;
            mrbillEntry.FCOMPANYORGUNITID = _storageUnit;
            mrbillEntry.FWAREHOUSEID      = iof.GetDefaultWarehouseIDByfID(mrbillEntry.FSOURCEBILLENTRYID, "T_MM_ProductionOrderSEntry");
            mrbillEntry.FLOCATIONID       = "";
            //是否批次管理
            //var bLot = iof.GetBLotById(mrbillEntry.FMATERIALID);
            var bLot = iof.GetBLotById(mrbillEntry.FMATERIALID, mrbillEntry.FSTORAGEORGUNITID);

            if (bLot.Equals("1"))
            {
                mrbillEntry.FLOT = cLotNo;
            }
            else
            {
                mrbillEntry.FLOT = "";
            }
            mrbillEntry.FQTY              = iQty;
            mrbillEntry.FASSISTQTY        = 0;
            mrbillEntry.FBASEQTY          = iQty;
            mrbillEntry.FREVERSEQTY       = 0;
            mrbillEntry.FRETURNSQTY       = 0;
            mrbillEntry.FPRICE            = 0;
            mrbillEntry.FAMOUNT           = 0;
            mrbillEntry.FUNITSTANDARDCOST = 0;
            mrbillEntry.FSTANDARDCOST     = 0;
            mrbillEntry.FUNITACTUALCOST   = 0;
            mrbillEntry.FACTUALCOST       = 0;
            mrbillEntry.FISPRESENT        = 0;
            mrbillEntry.FPARENTID         = mrbill.FID;
            mrbillEntry.FPRODUCTIDID      = "";
            mrbillEntry.FORDERNUMBER      = cOrderNumber;
            mrbillEntry.FPOBILLENTRYID    = "";
            //生产日期、失效日期
            //mrbillEntry.FEXP = "25-12月-16 12.00.00.000000000 上午";
            //mrbillEntry.FMFG = "10-1月 -14 12.00.00.000000000 上午";
            mrbillEntry.FREVERSEBASEQTY     = 0;
            mrbillEntry.FRETURNBASEQTY      = 0;
            mrbillEntry.FBASEUNITACTUALCOST = 0;
            mrbillEntry.FCOSTOBJECTID       = iof.GetCostByOrderNumber(cOrderNumber, _storageUnit);
            mrbillEntry.FUNRETURNEDBASEQTY  = iQty;
            mrbillEntry.FORDERBILLID        = mrbillEntry.FSOURCEBILLID;
            //生产线
            //mrbillEntry.FPRODUCTLINEID = "riQAAAAALs1tMiVM";
            mrbillEntry.FISSUEQTY             = 0;
            mrbillEntry.FBASEISSUEQTY         = 0;
            mrbillEntry.FPRODUCTLINEWPID      = "";
            mrbillEntry.FFACARDQTY            = 0;
            mrbillEntry.FSUBWRITTENOFFQTY     = 0;
            mrbillEntry.FSUBWRITTENOFFBASEQTY = 0;
            mrbillEntry.FSUBUNWRITEOFFQTY     = iQty;
            mrbillEntry.FSUBUNWRITEOFFBASEQTY = iQty;
            mrbillEntry.FCOREBILLTYPEID       = "ejIZHXXTQliYCQJg9t4Re0Y+1VI=";
            mrbillEntry.FCOREORDERENTRYSEQ    = 0;
            mrbillEntry.FCOREBILLNUMBER       = cOrderNumber;
            mrbillEntry.FCOREBILLID           = mrbillEntry.FSOURCEBILLID;
            mrbillEntry.FCOREBILLENTRYID      = mrbillEntry.FSOURCEBILLENTRYID;
            mrbillEntry.FCOREBILLENTRYSE      = 0;
            mrbillEntry.FOPERATIONNO          = 0;
            mrbillEntry.FISADMEASURE          = 0;
            //根据流程生产订单,判断是否返工
            if (mrbillEntry.FMATERIALID.Equals(cProProduct))
            {
                var cProductType = iof.GetProductType(cOrderNumber, "T_MM_ProductionOrder");
                mrbillEntry.FISREWORK = cProductType.Equals("20") ? 1 : 0;
            }
            else
            {
                mrbillEntry.FISREWORK = 0;
            }


            mrbillEntry.FSCWRITTENOFFAMOUNT   = 0;
            mrbillEntry.FSCUNWRITTENOFFAMOUNT = 0;
            mrbillEntry.FSUPPLYWAREHOUSEID    = "";
            mrbillEntry.FSETTLEPRICE          = 0;
            mrbillEntry.FBIZDATE = dDate;

            mrbillEntry.FCOSTCENTERORGUNITID = mrbill.FCOSTCENTERORGUNITID;
            mrbillEntry.FADMINORGUNITID      = mrbill.FCOSTCENTERORGUNITID;
        }