Пример #1
0
        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);
        }
Пример #2
0
        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);
        }
Пример #3
0
        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);
        }
Пример #4
0
        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);
        }