public static List<Proxy.DrugCategory> ToList(BLL.Category v)
        {
            List<Proxy.DrugCategory> list = new List<Proxy.DrugCategory>();
            while (!v.EOF)
            {
                Proxy.DrugCategory t = new Proxy.DrugCategory();
              if(!v.IsColumnNull("ID"))
                     t.ID = v.ID;
              if(!v.IsColumnNull("CategoryName"))
                     t.CategoryName = v.CategoryName;
              if(!v.IsColumnNull("CategoryCode"))
                     t.CategoryCode = v.CategoryCode;
              if(!v.IsColumnNull("Description"))
                     t.Description = v.Description;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Zone> ToList(BLL.Zone v)
        {
            List<Zone> list = new List<Zone>();
            while (!v.EOF)
            {
                Zone t = new Zone();
                if (!v.IsColumnNull("ID"))
                    t.ID = v.ID;
                if (!v.IsColumnNull("ZoneName"))
                    t.ZoneName = v.ZoneName;
                if (!v.IsColumnNull("RegionId"))
                    t.RegionId = v.RegionId;
                if (!v.IsColumnNull("ZoneCode"))
                    t.ZoneCode = v.ZoneCode;
                //if(!v.IsColumnNull("IsDeleted"))
                //      t.IsDeleted = v.IsDeleted;
                //if(!v.IsColumnNull("UpdateTime"))
                //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<VEN> ToList(BLL.VEN v)
        {
            List<VEN> list = new List<VEN>();
            while (!v.EOF)
            {
                VEN t = new VEN();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Value"))
                    t.Value = v.Value;
              if(!v.IsColumnNull("Description"))
                    t.Description = v.Description;
              //if(!v.IsColumnNull("IsDeleted"))
              //      t.IsDeleted = v.IsDeleted;
              //if(!v.IsColumnNull("UpdateTime"))
              //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<StoreGroupDivision> ToList(BLL.SubAccount v)
        {
            List<StoreGroupDivision> list = new List<StoreGroupDivision>();
            while (!v.EOF)
            {
                StoreGroupDivision t = new StoreGroupDivision();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Name"))
                    t.Name = v.Name;
              if(!v.IsColumnNull("Descriptiont"))
                    t.Descriptiont = v.Descriptiont;
              if(!v.IsColumnNull("StoreGroupID"))
                    t.StoreGroupID = v.StoreGroupID;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Stores> ToList(BLL.Activity v)
        {
            List<Stores> list = new List<Stores>();
            while (!v.EOF)
            {
                Stores t = new Stores();
                if (!v.IsColumnNull("ID"))
                    t.ID = v.ID;
                if (!v.IsColumnNull("HospitalID"))
                    t.HospitalID = v.HospitalID;
                if (!v.IsColumnNull("StoreName"))
                    t.StoreName = v.StoreName;
                if (!v.IsColumnNull("UsesMovingAverage"))
                    t.UsesMovingAverage = v.UsesMovingAverage;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Woreda> ToList(BLL.Woreda v)
        {
            List<Woreda> list = new List<Woreda>();
            while (!v.EOF)
            {
                Woreda t = new Woreda();
                if (!v.IsColumnNull("ID"))
                    t.ID = v.ID;
                if (!v.IsColumnNull("WoredaName"))
                    t.WoredaName = v.WoredaName;
                if (!v.IsColumnNull("ZoneID"))
                    t.ZoneID = v.ZoneID;
                if (!v.IsColumnNull("WoredaCode"))
                    t.WoredaCode = v.WoredaCode;
                //if(!v.IsColumnNull("IsDeleted"))
                //      t.IsDeleted = v.IsDeleted;
                //if(!v.IsColumnNull("UpdateTime"))
                //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<ItemUnit> ToList(BLL.ItemUnit v)
        {
            List<ItemUnit> list = new List<ItemUnit>();
            while (!v.EOF)
            {
                ItemUnit t = new ItemUnit();
                if (!v.IsColumnNull("ID"))
                    t.ID = v.ID;
                if (!v.IsColumnNull("ItemID"))
                    t.ItemID = v.ItemID;
                if (!v.IsColumnNull("QtyPerUnit"))
                    t.QtyPerUnit = v.QtyPerUnit;
                if (!v.IsColumnNull("Text"))
                    t.Text = v.Text;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<StorageType> ToList(BLL.StorageType v)
        {
            List<StorageType> list = new List<StorageType>();
            while (!v.EOF)
            {
                StorageType t = new StorageType();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("StorageTypeName"))
                    t.StorageTypeName = v.StorageTypeName;
              if(!v.IsColumnNull("IsSubTypeOf"))
                    t.IsSubTypeOf = v.IsSubTypeOf;
              if(!v.IsColumnNull("Prefix"))
                    t.Prefix = v.Prefix;
              //if(!v.IsColumnNull("IsDeleted"))
              //      t.IsDeleted = v.IsDeleted;
              //if(!v.IsColumnNull("UpdateTime"))
              //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<StoreType> ToList(BLL.Mode v)
        {
            List<StoreType> list = new List<StoreType>();
            while (!v.EOF)
            {
                StoreType t = new StoreType();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("TypeName"))
                    t.TypeName = v.TypeName;
              if(!v.IsColumnNull("Description"))
                    t.Description = v.Description;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<User> ToList(BLL.User v)
        {
            List<User> list = new List<User>();
            while (!v.EOF)
            {
                User t = new User();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("FullName"))
                    t.FullName = v.FullName;
              if(!v.IsColumnNull("Address"))
                    t.Address = v.Address;
              if(!v.IsColumnNull("Mobile"))
                    t.Mobile = v.Mobile;
              if(!v.IsColumnNull("UserName"))
                    t.UserName = v.UserName;
              if(!v.IsColumnNull("Password"))
                    t.Password = v.Password;
              if(!v.IsColumnNull("UserType"))
                    t.UserType = v.UserType;
              if(!v.IsColumnNull("Active"))
                    t.Active = v.Active;
              //if(!v.IsColumnNull("IsDeleted"))
              //      t.IsDeleted = v.IsDeleted;
              //if(!v.IsColumnNull("UpdateTime"))
              //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<UserType> ToList(BLL.UserType v)
        {
            List<UserType> list = new List<UserType>();
            while (!v.EOF)
            {
                UserType t = new UserType();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Type"))
                    t.Type = v.Type;
              //if(!v.IsColumnNull("IsDeleted"))
              //      t.IsDeleted = v.IsDeleted;
              //if(!v.IsColumnNull("UpdateTime"))
              //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<DosageForm> ToList(BLL.DosageForm v)
        {
            List<DosageForm> list = new List<DosageForm>();
            while (!v.EOF)
            {
                DosageForm t = new DosageForm();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Form"))
                    t.Form = v.Form;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Supplier> ToList(BLL.Supplier v)
        {
            List<Supplier> list = new List<Supplier>();
            while (!v.EOF)
            {
                Supplier t = new Supplier();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("CompanyName"))
                    t.CompanyName = v.CompanyName;
              if(!v.IsColumnNull("Address"))
                    t.Address = v.Address;
              if(!v.IsColumnNull("Telephone"))
                    t.Telephone = v.Telephone;
              if(!v.IsColumnNull("ContactPerson"))
                    t.ContactPerson = v.ContactPerson;
              if(!v.IsColumnNull("Mobile"))
                    t.Mobile = v.Mobile;
              if(!v.IsColumnNull("CompanyInfo"))
                    t.CompanyInfo = v.CompanyInfo;
              if(!v.IsColumnNull("IsActive"))
                    t.IsActive = v.IsActive;
              if(!v.IsColumnNull("Email"))
                    t.Email = v.Email;
              //if(!v.IsColumnNull("IsDeleted"))
              //      t.IsDeleted = v.IsDeleted;
              //if(!v.IsColumnNull("UpdateTime"))
              //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<SupplyCategory> ToList(BLL.SupplyCategory v)
        {
            List<SupplyCategory> list = new List<SupplyCategory>();
            while (!v.EOF)
            {
                SupplyCategory t = new SupplyCategory();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Name"))
                    t.Name = v.Name;
              if(!v.IsColumnNull("ParentId"))
                    t.ParentId = v.ParentId;
              if(!v.IsColumnNull("Code"))
                    t.Code = v.Code;
              //if(!v.IsColumnNull("IsDeleted"))
              //      t.IsDeleted = v.IsDeleted;
              //if(!v.IsColumnNull("UpdateTime"))
              //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Product> ToList(BLL.Product v)
        {
            List<Product> list = new List<Product>();
            while (!v.EOF)
            {
                Product t = new Product();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Name"))
                    t.Name = v.IIN;
              if(!v.IsColumnNull("TypeID"))
                    t.TypeID = v.TypeID;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<ItemManufacturer> ToList(BLL.ItemManufacturer v)
        {
            List<ItemManufacturer> list = new List<ItemManufacturer>();
            while (!v.EOF)
            {
                ItemManufacturer t = new ItemManufacturer();
                if (!v.IsColumnNull("ID"))
                    t.ID = v.ID;
                if (!v.IsColumnNull("ItemID"))
                    t.ItemID = v.ItemID;
                if (!v.IsColumnNull("ManufacturerID"))
                    t.ManufacturerID = v.ManufacturerID;
                if (!v.IsColumnNull("PackageLevel"))
                    t.PackageLevel = v.PackageLevel;
                if (!v.IsColumnNull("QuantityPerLevel"))
                    t.QuantityPerLevel = v.QuantityPerLevel;
                if (!v.IsColumnNull("IsssuingDefault"))
                    t.IsssuingDefault = v.IsssuingDefault;
                if (!v.IsColumnNull("RecevingDefault"))
                    t.RecevingDefault = v.RecevingDefault;
                if (!v.IsColumnNull("BoxWidth"))
                    t.BoxWidth = v.BoxWidth;
                if (!v.IsColumnNull("BoxHeight"))
                    t.BoxHeight = v.BoxHeight;
                if (!v.IsColumnNull("BoxLength"))
                    t.BoxLength = v.BoxLength;
                if (!v.IsColumnNull("BrandName"))
                    t.BrandName = v.BrandName;
                if (!v.IsColumnNull("StackHeight"))
                    t.StackHeight = v.StackHeight;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<DisposalReasons> ToList(BLL.DisposalReasons v)
        {
            List<DisposalReasons> list = new List<DisposalReasons>();
            while (!v.EOF)
            {
                DisposalReasons t = new DisposalReasons();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Reason"))
                    t.Reason = v.Reason;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<ReceiptInvoiceDetail> ToList(BLL.ReceiptInvoiceDetail v)
        {
            List<ReceiptInvoiceDetail> list = new List<ReceiptInvoiceDetail>();
            while (!v.EOF)
            {
                ReceiptInvoiceDetail t = new ReceiptInvoiceDetail();
                if (!v.IsColumnNull("ID"))
                    t.ID = v.ID;
                if (!v.IsColumnNull("ReceiptInvoiceID"))
                    t.ReceiptInvoiceID = v.ReceiptInvoiceID;
                if (!v.IsColumnNull("ItemID"))
                    t.ItemID = v.ItemID;
                if (!v.IsColumnNull("HubID"))
                    t.HubID = v.HubID;
                if (!v.IsColumnNull("RequisitionNo"))
                    t.RequisitionNo = v.RequisitionNo;
                if (!v.IsColumnNull("STVNo"))
                    t.STVNo = v.STVNo;
                if (!v.IsColumnNull("AccountID"))
                    t.AccountID = v.AccountID;
                if (!v.IsColumnNull("ManufactureID"))
                    t.ManufactureID = v.ManufactureID;
                if (!v.IsColumnNull("Qty"))
                    t.Qty = v.Qty;
                if (!v.IsColumnNull("Batch"))
                    t.Batch = v.Batch;
                if (!v.IsColumnNull("Expiry"))
                    t.Expiry = v.Expiry;
                if (!v.IsColumnNull("ReceiptInvoiceType"))
                    t.ReceiptInvoiceType = v.ReceiptInvoiceType;
                if (!v.IsColumnNull("UnitCost"))
                    t.UnitCost = v.UnitCost;
                if (!v.IsColumnNull("TotalCost"))
                    t.TotalCost = v.TotalCost;
                if (!v.IsColumnNull("Margin"))
                    t.Margin = v.Margin;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Unit> ToList(BLL.Unit v)
        {
            List<Unit> list = new List<Unit>();
            while (!v.EOF)
            {
                Unit t = new Unit();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Name"))
                    t.Name = v.Unit;
              if(!v.IsColumnNull("Description"))
                    t.Description = v.Description;
              //if(!v.IsColumnNull("IsDeleted"))
              //      t.IsDeleted = v.IsDeleted;
              //if(!v.IsColumnNull("UpdateTime"))
              //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Items> ToList(BLL.Items v)
        {
            List<Items> list = new List<Items>();
            while (!v.EOF)
            {
                Items t = new Items();
                if (!v.IsColumnNull("ID"))
                    t.ID = v.ID;
                if (!v.IsColumnNull("StockCode"))
                    t.StockCode = v.StockCode;
                if (!v.IsColumnNull("Strength"))
                    t.Strength = v.Strength;
                if (!v.IsColumnNull("DosageFormID"))
                    t.DosageFormID = v.DosageFormID;
                if (!v.IsColumnNull("UnitID"))
                    t.UnitID = v.UnitID;
                if (!v.IsColumnNull("VEN"))
                    t.VEN = v.VEN;
                if (!v.IsColumnNull("ABC"))
                    t.ABC = v.ABC;
                if (!v.IsColumnNull("Cost"))
                    t.Cost = v.Cost;
                if (!v.IsColumnNull("EDL"))
                    t.EDL = v.EDL;
                if (!v.IsColumnNull("Pediatric"))
                    t.Pediatric = v.Pediatric;
                if (!v.IsColumnNull("IINID"))
                    t.IINID = v.IINID;
                if (!v.IsColumnNull("NeedExpiryBatch"))
                    t.NeedExpiryBatch = v.NeedExpiryBatch;
                if (!v.IsColumnNull("Code"))
                    t.Code = v.Code;
                if (!v.IsColumnNull("StockCodeDACA"))
                    t.StockCodeDACA = v.StockCodeDACA;
                if (!v.IsColumnNull("NearExpiryTrigger"))
                    t.NearExpiryTrigger = v.NearExpiryTrigger;
                if (!v.IsColumnNull("StorageTypeID"))
                    t.StorageTypeID = v.StorageTypeID;
                if (!v.IsColumnNull("IsStackStored"))
                    t.IsStackStored = v.IsStackStored;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<ItemSupplyCategory> ToList(BLL.ItemSupplyCategory v)
        {
            List<ItemSupplyCategory> list = new List<ItemSupplyCategory>();
            while (!v.EOF)
            {
                ItemSupplyCategory t = new ItemSupplyCategory();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("ItemID"))
                    t.ItemID = v.ItemID;
              if(!v.IsColumnNull("CategoryID"))
                    t.CategoryID = v.CategoryID;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Region> ToList(BLL.Region v)
        {
            List<Region> list = new List<Region>();
            while (!v.EOF)
            {
                Region t = new Region();
                if (!v.IsColumnNull("ID"))
                    t.ID = v.ID;
                if (!v.IsColumnNull("RegionName"))
                    t.RegionName = v.RegionName;
                if (!v.IsColumnNull("RegionCode"))
                    t.RegionCode = v.RegionCode;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<ABC> ToList(BLL.ABC v)
        {
            List<ABC> list = new List<ABC>();
            while (!v.EOF)
            {
                ABC t = new ABC();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Value"))
                    t.Value = v.Value;
              if(!v.IsColumnNull("Description"))
                    t.Description = v.Description;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<Route> ToList(BLL.Route v)
        {
            List<Route> list = new List<Route>();
            while (!v.EOF)
            {
                Route t = new Route();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.RouteID;
              if(!v.IsColumnNull("Name"))
                    t.Name = v.Name;
              //if(!v.IsColumnNull("HubID"))
              //      t.HubID = v.HubID;
              //if(!v.IsColumnNull("IsDeleted"))
              //      t.IsDeleted = v.IsDeleted;
              //if(!v.IsColumnNull("UpdateTime"))
              //      t.UpdateTime = v.UpdateTime;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }
        public static List<StoreGroup> ToList(BLL.StoreGroup v)
        {
            List<StoreGroup> list = new List<StoreGroup>();
            while (!v.EOF)
            {
                StoreGroup t = new StoreGroup();
              if(!v.IsColumnNull("ID"))
                    t.ID = v.ID;
              if(!v.IsColumnNull("Name"))
                    t.Name = v.Name;
              if(!v.IsColumnNull("StoreTypeID"))
                    t.StoreTypeID = v.StoreTypeID;

                list.Add(t);
                v.MoveNext();
            }
            return list;
        }