C# BLL.IsColumnNull方法代码示例

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

        private static void NotifyNewHelpMember(BLL.Member member)
        {
            var helpMember = new
            {
                MemberID = member.MemberID,
                Name = member.Name,
                TypeSpecID = member.MemberType.MemberTypeSpecDuration.MemberTypeSpecID,
                ProfilePic = (member.IsColumnNull(BLL.Member.ColumnNames.ProfilePic) ? "images/defaultavatar.png" : member.ProfilePic),
                IsOnline = member.IsOnLine,
                StatusMsg = member.s_StatusMsg,
                Status = member.s_Status
            };

            Microsoft.AspNet.SignalR.IHubContext _Rcontext = Microsoft.AspNet.SignalR.GlobalHost.ConnectionManager.GetHubContext<Chat2Connect.SRCustomHubs.ChatRoomHub>();
            _Rcontext.Clients.All.addNewHelpMember(helpMember);
        }

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