private List <OutStockDetails_Model> GetKeeperList(string keeperno)
{
List <OutStockDetails_Model> lstKeeper = new List <OutStockDetails_Model>();
try
{
OutStockDetails_Model keeper;
using (SqlDataReader dr = _db.GetKeeperList(keeperno))
{
while (dr.Read())
{
keeper = new OutStockDetails_Model();
keeper.MaterialKeeperNo = dr["UserNo"].ToDBString();
keeper.MaterialKeeperName = dr["UserName"].ToDBString();
lstKeeper.Add(keeper);
}
}
return(lstKeeper);
}
catch //(Exception ex)
{
return(lstKeeper);
}
}
private List <OutStockDetails_Model> CreateMaterialRequestByProductDetails(ref OutStock_Model OutStockModel, IRfcTable rtb)
{
List <OutStockDetails_Model> lstPrdReturnDetails = null;
if (rtb != null)
{
if (rtb.RowCount > 0)
{
lstPrdReturnDetails = new List <OutStockDetails_Model>();
}
foreach (var itemRtb in rtb)
{
OutStockModel.Plant = itemRtb.GetString("WERKS");
OutStockModel.PlantName = itemRtb.GetString("WNAME");
OutStockModel.MoveType = string.Empty;
OutStockDetails_Model item = new OutStockDetails_Model();
item.VoucherNo = itemRtb.GetString("EBELN");
item.RowNo = itemRtb.GetString("EBELP");
item.MaterialNo = itemRtb.GetString("MATNR");
item.MaterialDesc = itemRtb.GetString("MAKTX");
item.Unit = itemRtb.GetString("MEINS");
item.Plant = itemRtb.GetString("WERKS");
item.PlantName = itemRtb.GetString("WNAME");
item.StorageLoc = itemRtb.GetString("LGORT");
item.OutStockQty = itemRtb.GetInt("BDMNG");
item.OldOutStockQtySAP = itemRtb.GetInt("YFSL");
item.WaitOutStockQty = itemRtb.GetInt("KFSL");
item.RemainStockQtySAP = itemRtb.GetInt("YLKC");
lstPrdReturnDetails.Add(item);
}
}
return(null);
}
private List <OutStockDetails_Model> CreateMaterialRequestDetails(ref OutStock_Model OutStockModel, IRfcTable rtb)
{
List <OutStockDetails_Model> lstPrdReturnDetails = null;
if (rtb != null)
{
if (rtb.RowCount > 0)
{
lstPrdReturnDetails = new List <OutStockDetails_Model>();
}
foreach (var itemRtb in rtb)
{
OutStockModel.VoucherNo = itemRtb.GetString("BEDNR");
OutStockModel.Plant = itemRtb.GetString("WERKS");
OutStockModel.PlantName = itemRtb.GetString("NAME1");
OutStockModel.MoveType = itemRtb.GetString("BWART");
OutStockDetails_Model item = new OutStockDetails_Model();
item.VoucherNo = itemRtb.GetString("BEDNR");
item.RowNo = itemRtb.GetString("BSPOS");
item.MaterialNo = itemRtb.GetString("MATNR");
item.MaterialDesc = itemRtb.GetString("MAKTX");
item.Unit = itemRtb.GetString("MEINS");
item.Plant = itemRtb.GetString("WERKS");
item.PlantName = itemRtb.GetString("NAME1");
item.StorageLoc = itemRtb.GetString("LGORT");
item.OutStockQty = itemRtb.GetInt("BDMNG");
item.ProDel = itemRtb.GetString("XLOEK");
item.ReserveNumber = itemRtb.GetString("RSNUM");
//item.ReserveRowNo = itemRtb.GetString("RSPOS");
item.RequstReason = itemRtb.GetString("CR_TXT");
lstPrdReturnDetails.Add(item);
}
}
return(lstPrdReturnDetails);
}
private List <OutStockDetails_Model> CreateMaterialRequestByProductDetails(ref OutStock_Model OutStockModel, IRfcTable rtb)
{
List <OutStockDetails_Model> lstPrdReturnDetails = null;
if (rtb != null)
{
if (rtb.RowCount > 0)
{
lstPrdReturnDetails = new List <OutStockDetails_Model>();
}
foreach (var itemRtb in rtb)
{
OutStockModel.VoucherNo = itemRtb.GetString("AUFNR").TrimStart('0');
OutStockModel.Plant = itemRtb.GetString("WERKS");
OutStockModel.PlantName = itemRtb.GetString("NAME1");
OutStockModel.MoveType = itemRtb.GetString("BWART");
OutStockDetails_Model item = new OutStockDetails_Model();
item.VoucherNo = itemRtb.GetString("AUFNR").TrimStart('0');
item.RowNo = string.Empty;
item.MaterialNo = itemRtb.GetString("MATNR");
item.MaterialDesc = itemRtb.GetString("MAKTX");
item.Unit = itemRtb.GetString("MEINS");
item.Plant = itemRtb.GetString("WERKS");
item.PlantName = itemRtb.GetString("NAME1");
item.StorageLoc = itemRtb.GetString("LGORT");
item.OutStockQty = itemRtb.GetInt("ZBDMNG");
item.ProRecoil = itemRtb.GetString("RGEKZ");
item.ProDel = itemRtb.GetString("XLOEK");
item.ProVirtual = itemRtb.GetString("DUMPS");
item.ReserveNumber = itemRtb.GetString("RSNUM");
item.ReserveRowNo = itemRtb.GetString("RSPOS");
lstPrdReturnDetails.Add(item);
}
}
return(null);
}
