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