public SAL_OUTSTOCK__FEntity[] GetEntitys(string FBillNO)
{
List <SAL_OUTSTOCK__FEntity> lsof = new List <SAL_OUTSTOCK__FEntity>();
SqlParameter[] Param = new SqlParameter[] { new SqlParameter("@FBillNo", FBillNO) };
using (SqlDataReader sdrDetail = SqlHelper.ExecuteReader(strcon, CommandType.Text, "exec dbo.p_edb_GetEntitys @FBillNo", Param))
{
while (sdrDetail.Read())
{
string sFOwnerID = "01";
string sFUnitID = "Pcs";
string sFNumber = sdrDetail["FNumber"].ToString();
SAL_OUTSTOCK_BD_MATERIAL sFMaterialID = new SAL_OUTSTOCK_BD_MATERIAL(sFNumber);
SAL_OUTSTOCK__FEntity sof = new SAL_OUTSTOCK__FEntity(sFOwnerID, sFUnitID, sFMaterialID);
sof.FUnitID.FNumber = "Pcs";
sof.FBASEARQTY = (sdrDetail["FQty"] == null || sdrDetail["FQty"].ToString() == "" ? "1" : sdrDetail["FQty"].ToString());
sof.FPriceUnitQty = (sdrDetail["FQty"] == null || sdrDetail["FQty"].ToString() == "" ? "1" : sdrDetail["FQty"].ToString());
sof.FInventoryQty = (sdrDetail["FQty"] == null || sdrDetail["FQty"].ToString() == "" ? "1" : sdrDetail["FQty"].ToString());
sof.FRealQty = (sdrDetail["FQty"] == null || sdrDetail["FQty"].ToString() == "" ? "1": sdrDetail["FQty"].ToString());
sof.FPrice = (sdrDetail["FPrice"].ToString() == "" || sdrDetail["FPrice"] == null ? 0 : decimal.Parse(sdrDetail["FPrice"].ToString()));
sof.FTaxNetPrice = (sdrDetail["FPrice"].ToString() == "" || sdrDetail["FPrice"] == null ? 0 : decimal.Parse(sdrDetail["FPrice"].ToString()));
sof.FTaxPrice = (sdrDetail["FPrice"].ToString() == "" || sdrDetail["FPrice"] == null ? 0 : decimal.Parse(sdrDetail["FPrice"].ToString()));
sof.FIsFree = (sdrDetail["FPrice"].ToString() == "" || sdrDetail["FPrice"] == null || decimal.Parse(sdrDetail["FPrice"].ToString()) == 0 ? "true" :"false");
sof.F_PAEZ_Text3 = sdrDetail["FOut_tid"].ToString();
sof.FAmount = decimal.Parse(sdrDetail["FAmount"].ToString());
sof.FAmount_LC = decimal.Parse(sdrDetail["FAmount"].ToString());
sof.FAllAmount_LC = decimal.Parse(sdrDetail["FAmount"].ToString());
sof.FAllAmount = decimal.Parse(sdrDetail["FAmount"].ToString());
sof.FStockID.FNumber = sdrDetail["FStockID"].ToString(); //从中间表中取到的仓库值为1
lsof.Add(sof);
}
}
return(lsof.ToArray());
}
/// <summary>
/// 出库明细
/// </summary>
/// <param name="sFOwnerID">货主:FOwnerID (必填项)</param>
/// <param name="sFUnitID">库存单位:FUnitID (必填项)</param>
public SAL_OUTSTOCK__FEntity(string sFOwnerID, string sFUnitID, SAL_OUTSTOCK_BD_MATERIAL sFMaterialID)
{
FCustMatID = new SAL_OUTSTOCK_Sal_StoreMatMappingView();
//FAuxPropId = new BD_FLEXSITEMDETAILV_FAuxPropId();
FUnitID = new SAL_OUTSTOCK_BD_UNIT();
FUnitID.FNumber = sFUnitID;
//FBomID = new SAL_OUTSTOCK_ENG_BOM();
FOwnerID = new SAL_OUTSTOCK_BOS_ItemClass();
FOwnerID.FNumber = sFOwnerID;
FMaterialID = sFMaterialID;
//FLot = new SAL_OUTSTOCK_BD_BatchMainFile();
//FTaxCombination = new SAL_OUTSTOCK_BD_TAXMIX();
//FExtAuxUnitId = new SAL_OUTSTOCK_BD_UNIT();
FStockID = new SAL_OUTSTOCK_BD_STOCK();
FStockID.FNumber = "CK001";
//FStockLocID = new BD_FLEXVALUESDETAIL_FStockLocID();
//FStockStatusID = new SAL_OUTSTOCK_BD_StockStatus();
//FSalUnitID = new SAL_OUTSTOCK_BD_UNIT();
//FEOwnerSupplierId = new SAL_OUTSTOCK_BD_Supplier();
//FESettleStoreomerId = new SAL_OUTSTOCK_BD_Storeomer();
//FPriceListEntry = new SAL_OUTSTOCK_BD_SAL_PriceList();
//FTaxDetailSubEntity = new SAL_OUTSTOCK__FTaxDetailSubEntity[] { new SAL_OUTSTOCK__FTaxDetailSubEntity() };
//FSerialSubEntity = new SAL_OUTSTOCK__FSerialSubEntity[] { new SAL_OUTSTOCK__FSerialSubEntity() };
}
