/// <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;
}
/// <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";
}
/// <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;
}
/// <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;
}