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); }