public static PlannedOrder GetPlannedOrderFromPlnum(int plnum)
        {
            PlannedOrder objPlannedOrder = new PlannedOrder();

            DataTable dt = DataProvider.GetList("select * from PlannedOrder where plnum = " + plnum, null, false);

            foreach (DataRow row in dt.Rows)
            {
                objPlannedOrder = new PlannedOrder(row);
            }

            return(objPlannedOrder);
        }
        public static List <PlannedOrder> GetListPlannedOrder()
        {
            List <PlannedOrder> lst = new List <PlannedOrder>();

            DataTable dt = DataProvider.GetList("usp_GetListPlannedOrder", null, true);

            foreach (DataRow row in dt.Rows)
            {
                PlannedOrder objPlannedOrder = new PlannedOrder(row);

                lst.Add(objPlannedOrder);
            }

            return(lst);
        }