public static List <WarehouseOperator> WarehouseOperatorsList(Guid warehouseID, int Type)
{
List <WarehouseOperator> operatorList;
operatorList = new List <WarehouseOperator>();
DataTable WarehouseOperator = ECX.DataAccess.SQLHelper.getDataTable(ConnectionString, "[GetAllWarehouseOperators]", warehouseID, Type);
foreach (DataRow r in WarehouseOperator.Rows)
{
WarehouseOperator pnm = new WarehouseOperator();
Common.DataRow2Object(r, pnm);
operatorList.Add(pnm);
}
return(operatorList);
}
public static List <WarehouseOperator> LICAll(Guid curentWareHouse)
{
List <WarehouseOperator> licList;
licList = new List <WarehouseOperator>();
DataTable WarehouseOperator = ECX.DataAccess.SQLHelper.getDataTable(ConnectionString, "GetAllLICs", curentWareHouse);
foreach (DataRow r in WarehouseOperator.Rows)
{
WarehouseOperator pnm = new WarehouseOperator();
Common.DataRow2Object(r, pnm);
licList.Add(pnm);
}
return(licList);
}
public static List <WarehouseOperator> GetLICByShed(Guid warehouseID, Guid ShedID)
{
List <WarehouseOperator> licList;
licList = new List <WarehouseOperator>();
DataTable WarehouseOperator = ECX.DataAccess.SQLHelper.getDataTable(ConnectionString, "[GetStackByShed]", warehouseID, ShedID);
foreach (DataRow r in WarehouseOperator.Rows)
{
WarehouseOperator pnm = new WarehouseOperator();
Common.DataRow2Object(r, pnm);
licList.Add(pnm);
}
return(licList);
}
public static List <WarehouseOperator> LICs(GINModel currentGIN)
{
List <WarehouseOperator> licList;
licList = new List <WarehouseOperator>();
DataTable WarehouseOperator = ECX.DataAccess.SQLHelper.getDataTable(ConnectionString, "GetLICs", currentGIN.WarehouseID, currentGIN.CommodityGradeID, currentGIN.PickupNoticesList[0].ProductionYear);
foreach (DataRow r in WarehouseOperator.Rows)
{
WarehouseOperator pnm = new WarehouseOperator();
Common.DataRow2Object(r, pnm);
licList.Add(pnm);
}
return(licList);
}