Пример #1
0
        public bool UpdateChemCloud_Dictionaries(ChemCloud_Dictionaries model)
        {
            bool result = true;
            ChemCloud_Dictionaries _ChemCloud_Dictionaries = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.Id == model.Id);

            if (_ChemCloud_Dictionaries != null)
            {
                _ChemCloud_Dictionaries.DictionaryTypeId = model.DictionaryTypeId;
                _ChemCloud_Dictionaries.DKey             = model.DKey;
                _ChemCloud_Dictionaries.DValue           = model.DValue;
                _ChemCloud_Dictionaries.DValue_En        = model.DValue_En;
                _ChemCloud_Dictionaries.Remarks          = model.Remarks;
                try
                {
                    context.SaveChanges();
                }
                catch (DbEntityValidationException dbEx)
                {
                    result = false;
                }
            }
            else
            {
                result = false;
            }
            return(result);
        }
Пример #2
0
        public ChemCloud_Dictionaries GetChemCloud_Dictionaries(long Id)
        {
            ChemCloud_Dictionaries _ChemCloud_Dictionaries
                = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.Id == Id);

            return(_ChemCloud_Dictionaries);
        }
Пример #3
0
        public List <ChemCloud_Dictionaries> GetChemCloud_Dictionariess(ChemCloud_Dictionaries model)
        {
            IQueryable <ChemCloud_Dictionaries> ChemCloud_Dictionariess = from item in base.context.ChemCloud_Dictionaries
                                                                          select item;

            if (model.DictionaryTypeId > 0)
            {
                ChemCloud_Dictionariess = from d in ChemCloud_Dictionariess
                                          where d.DictionaryTypeId.Equals(model.DictionaryTypeId)
                                          select d;
            }

            if (!string.IsNullOrWhiteSpace(model.DKey))
            {
                ChemCloud_Dictionariess = from d in ChemCloud_Dictionariess
                                          where d.DKey.Contains(model.DKey)
                                          select d;
            }

            if (!string.IsNullOrWhiteSpace(model.DValue))
            {
                ChemCloud_Dictionariess = from d in ChemCloud_Dictionariess
                                          where d.DValue.Contains(model.DValue)
                                          select d;
            }

            return(ChemCloud_Dictionariess.ToList <ChemCloud_Dictionaries>());
        }
Пример #4
0
        public JsonResult DictionariesPageModelList(int page, int rows, string dkey = "", string dvalue_en = "", string typeid = "0")
        {
            ChemCloud_Dictionaries casewhere = new ChemCloud_Dictionaries()
            {
                PageNo           = page,
                PageSize         = rows,
                DKey             = dkey,
                DictionaryTypeId = long.Parse(typeid)
            };
            PageModel <ChemCloud_Dictionaries> listpage =
                ServiceHelper.Create <IChemCloud_DictionariesService>().GetPage_ChemCloud_Dictionaries(casewhere);

            var collection =
                from item in listpage.Models.ToList()
                select new
            {
                Id = item.Id,
                DictionaryTypeId = item.DictionaryTypeId,
                TypeName         = ServiceHelper.Create <IChemCloud_DictionaryTypeService>().GetChemCloud_DictionaryType(item.DictionaryTypeId) == null ? "" : ServiceHelper.Create <IChemCloud_DictionaryTypeService>().GetChemCloud_DictionaryType(item.DictionaryTypeId).TypeName,
                DKey             = item.DKey,
                DValue           = item.DValue,
                DValue_En        = item.DValue_En,
                Remarks          = item.Remarks
            };

            return(Json(new { rows = collection, total = listpage.Total }));
        }
Пример #5
0
        public MessageSetting GetSetting(long Id)
        {
            MessageSetting         nums = context.MessageSetting.FindById <MessageSetting>(Id);
            ChemCloud_Dictionaries dict = (from item in context.ChemCloud_Dictionaries
                                           where item.DValue == nums.Languagetype.ToString() && item.DictionaryTypeId == 10
                                           select item).FirstOrDefault();

            nums.LanguageName = dict.DKey;
            return(nums);
        }
Пример #6
0
        public JsonResult DictionaryAddFuc(string DictionaryTypeId = "0", string DKey = "", string DValue = "", string DValue_En = "", string Remarks = "")
        {
            ChemCloud_Dictionaries model = new ChemCloud_Dictionaries();

            model.DictionaryTypeId = long.Parse(DictionaryTypeId);
            model.DKey             = DKey;
            model.DValue           = DValue;
            model.DValue_En        = DValue_En;
            model.Remarks          = Remarks;
            bool result = ServiceHelper.Create <IChemCloud_DictionariesService>().AddChemCloud_Dictionaries(model);

            return(Json(new { success = result }));
        }
Пример #7
0
        public LawInfo GetLawInfo(long Id)
        {
            LawInfo model = context.LawInfo.FindById(Id);

            if (model != null)
            {
                ManagerInfo manaInfo = context.ManagerInfo.FirstOrDefault((ManagerInfo m) => m.Id == model.Auditor && m.ShopId == 0);
                model.UserName = (manaInfo == null ? "" : manaInfo.UserName);
                ChemCloud_Dictionaries dicts = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DictionaryTypeId == 10 && m.DValue == model.LanguageType.ToString());
                model.Language = dicts.DKey;
            }
            return(model);
        }
Пример #8
0
        public bool AddChemCloud_Dictionaries(ChemCloud_Dictionaries model)
        {
            context.ChemCloud_Dictionaries.Add(model);
            int i = context.SaveChanges();

            if (i > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #9
0
        public ApplyAmountInfo GetApplyById(long Id)
        {
            ApplyAmountInfo ApplyAmount = context.ApplyAmountInfo.FirstOrDefault((ApplyAmountInfo m) => m.Id == Id);
            UserMemberInfo  userInfo    = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id.Equals(ApplyAmount.ApplyUserId));

            ApplyAmount.ApplyName = (userInfo == null ? "" : userInfo.UserName);
            if (ApplyAmount != null)
            {
                UserMemberInfo userInfos = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id.Equals(ApplyAmount.AuthorId));
                ApplyAmount.AuthorName = (userInfo == null ? "" : userInfos.UserName);
                ChemCloud_Dictionaries dicts = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DictionaryTypeId == 1 && m.DValue == ApplyAmount.CoinType.ToString());
                ApplyAmount.CoinName = dicts.DKey;
            }
            return(ApplyAmount);
        }
Пример #10
0
        public PageModel <TechnicalInfo> GetTechInfos(TechnicalInfoQuery model, long?userId)
        {
            int pageNum = 0;
            IQueryable <TechnicalInfo> techInfo = from item in base.context.TechnicalInfo
                                                  select item;

            if (userId.HasValue && userId.Value != 0)
            {
                techInfo = (from a in techInfo where a.PublisherId == userId.Value select a);
            }
            string begin = model.BeginTime.ToString("yyyy/MM/dd");
            string end   = model.EndTime.ToString("yyyy/MM/dd");

            if (!string.IsNullOrWhiteSpace(begin) && !begin.Equals("0001/01/01") && !string.IsNullOrWhiteSpace(end) && !end.Equals("0001/01/01"))
            {
                techInfo = (from a in techInfo where a.PublishTime > model.BeginTime && a.PublishTime < model.EndTime select a);
            }
            if (model.Status.HasValue && model.Status != 0)
            {
                techInfo = (from a in techInfo where a.Status == model.Status select a);
            }
            if (!string.IsNullOrWhiteSpace(model.Title))
            {
                techInfo = (from a in techInfo where a.Title.Contains(model.Title) select a);
            }

            techInfo = techInfo.GetPage(out pageNum, model.PageNo, model.PageSize, (IQueryable <TechnicalInfo> d) =>
                                        from o in d
                                        orderby o.PublishTime descending
                                        select o);
            foreach (TechnicalInfo list in techInfo.ToList())
            {
                if (list != null)
                {
                    UserMemberInfo userInfo = context.UserMemberInfo.FindById(list.PublisherId);
                    list.PublisherName = (userInfo == null ? "" : userInfo.UserName);
                    ManagerInfo manaInfo = context.ManagerInfo.FirstOrDefault((ManagerInfo m) => m.Id == list.Auditor && m.ShopId == 0);
                    list.AuditorName = (manaInfo == null ? "" : manaInfo.UserName);
                    ChemCloud_Dictionaries dicts = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DictionaryTypeId == 10 && m.DValue == list.LanguageType.ToString());
                    list.Language = dicts == null ? "" : dicts.DKey;
                }
            }
            return(new PageModel <TechnicalInfo>
            {
                Models = techInfo,
                Total = pageNum
            });
        }
Пример #11
0
        public ActionResult DictionariesEdit(long Id)
        {
            ChemCloud_DictionaryType query = new ChemCloud_DictionaryType()
            {
                IsEnabled = "1"
            };
            List <ChemCloud_DictionaryType> typelist =
                ServiceHelper.Create <IChemCloud_DictionaryTypeService>().GetChemCloud_DictionaryTypes(query);

            ViewBag.typelist = typelist;

            ChemCloud_Dictionaries _ChemCloud_Dictionaries =
                ServiceHelper.Create <IChemCloud_DictionariesService>().GetChemCloud_Dictionaries(Id);

            return(View(_ChemCloud_Dictionaries));
        }
Пример #12
0
        public List <LimitedAmount> GetLimitedAmountByRoleId(long roleId)
        {
            List <LimitedAmount> limitedLists = new List <LimitedAmount>();

            IQueryable <LimitedAmount> Limited = from item in context.LimitedAmount
                                                 where item.RoleId == roleId
                                                 select item;

            foreach (LimitedAmount list in Limited.ToList())
            {
                UserMemberInfo         userInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id == list.RoleId);
                ChemCloud_Dictionaries dictInfo = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DValue == list.CoinType.ToString() && m.DictionaryTypeId == 1);
                list.CoinTypeName = (dictInfo == null ? "" : dictInfo.DKey);
                limitedLists.Add(list);
            }
            return(limitedLists);
        }
Пример #13
0
        public PageModel <MargainBill> GetBill(BargainBillQuery billQueryModel)
        {
            int num;
            IQueryable <MargainBill> billsByQueryModel = GetbillsByQueryModel(billQueryModel, out num);

            foreach (MargainBill list in billsByQueryModel.ToList())
            {
                UserMemberInfo memberInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id.Equals(list.ShopId));
                list.ShopName = (memberInfo == null ? "" : memberInfo.UserName);
                ChemCloud_Dictionaries dictionaryInfo = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DictionaryTypeId == 1 && m.DValue == list.CoinType.ToString());
                list.CoinTypeName = (dictionaryInfo == null ? "" : dictionaryInfo.DKey);
            }
            return(new PageModel <MargainBill>()
            {
                Models = billsByQueryModel,
                Total = num
            });
        }
Пример #14
0
        public bool DeleteChemCloud_Dictionaries(long Id)
        {
            int i = 0;
            ChemCloud_Dictionaries _ChemCloud_Dictionaries = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.Id == Id);

            if (_ChemCloud_Dictionaries != null)
            {
                context.ChemCloud_Dictionaries.Remove(_ChemCloud_Dictionaries);
                i = context.SaveChanges();
            }
            if (i > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #15
0
        public PageModel <ChemCloud_Dictionaries> GetPage_ChemCloud_Dictionaries(ChemCloud_Dictionaries model)
        {
            IQueryable <ChemCloud_Dictionaries> ChemCloud_Dictionariess = from item in base.context.ChemCloud_Dictionaries
                                                                          select item;

            if (model.DictionaryTypeId > 0)
            {
                ChemCloud_Dictionariess = from d in ChemCloud_Dictionariess
                                          where d.DictionaryTypeId.Equals(model.DictionaryTypeId)
                                          select d;
            }

            if (!string.IsNullOrWhiteSpace(model.DKey))
            {
                ChemCloud_Dictionariess = from d in ChemCloud_Dictionariess
                                          where d.DKey.Contains(model.DKey)
                                          select d;
            }

            if (!string.IsNullOrWhiteSpace(model.DValue))
            {
                ChemCloud_Dictionariess = from d in ChemCloud_Dictionariess
                                          where d.DValue.Contains(model.DValue)
                                          select d;
            }

            Func <IQueryable <ChemCloud_Dictionaries>, IOrderedQueryable <ChemCloud_Dictionaries> > func = null;

            func = (IQueryable <ChemCloud_Dictionaries> d) =>
                   from o in d
                   orderby o.DictionaryTypeId descending
                   select o;
            int num = ChemCloud_Dictionariess.Count();

            ChemCloud_Dictionariess = ChemCloud_Dictionariess.GetPage(out num, model.PageNo, model.PageSize, func);
            return(new PageModel <ChemCloud_Dictionaries>()
            {
                Models = ChemCloud_Dictionariess,
                Total = num
            });
        }
Пример #16
0
        public PageModel <LawInfo> GetLawInfos(LawInfoQuery model, long?userId)
        {
            int pageNum = 0;
            IQueryable <LawInfo> lawInfo = from item in base.context.LawInfo
                                           select item;

            string begin = model.BeginTime.ToString("yyyy/MM/dd");
            string end   = model.EndTime.ToString("yyyy/MM/dd");

            if (!string.IsNullOrWhiteSpace(begin) && !begin.Equals("0001/01/01") && !string.IsNullOrWhiteSpace(end) && !end.Equals("0001/01/01"))
            {
                lawInfo = (from a in lawInfo where a.CreateTime > model.BeginTime && a.CreateTime < model.EndTime select a);
            }
            if (!string.IsNullOrWhiteSpace(model.Title))
            {
                lawInfo = (from a in lawInfo where a.Title.Contains(model.Title) select a);
            }

            lawInfo = lawInfo.GetPage(out pageNum, model.PageNo, model.PageSize, (IQueryable <LawInfo> d) =>
                                      from o in d
                                      orderby o.CreateTime descending
                                      select o);
            foreach (LawInfo list in lawInfo.ToList())
            {
                if (list.UserId != 0)
                {
                    ManagerInfo manaInfo = context.ManagerInfo.FirstOrDefault((ManagerInfo m) => m.Id == list.Auditor && m.ShopId == 0);
                    list.UserName = (manaInfo == null ? "" : manaInfo.UserName);
                    ChemCloud_Dictionaries dicts = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DictionaryTypeId == 10 && m.DValue == list.LanguageType.ToString());
                    list.Language = dicts.DKey;
                }
            }
            return(new PageModel <LawInfo>
            {
                Models = lawInfo,
                Total = pageNum
            });
        }
Пример #17
0
        /// <summary>
        /// 限额申请列表
        /// </summary>
        /// <param name="Status">申请状态</param>
        /// <param name="Start_datetime">开始时间</param>
        /// <param name="End_datetime">结束时间</param>
        /// <param name="page"></param>
        /// <param name="rows"></param>
        /// <param name="userId">当前用户</param>
        /// <param name="Applicant">申请人(0:子账户申请;1:我的申请)</param>
        /// <returns></returns>
        public PageModel <ApplyAmountInfo> GetApplyAmounts(int?Status, DateTime?Start_datetime, DateTime?End_datetime, int page, int rows, long userId, int Applicant)
        {
            PageModel <ApplyAmountInfo>  res             = new PageModel <ApplyAmountInfo>();
            IQueryable <ApplyAmountInfo> GetApplyAmounts = from item in base.context.ApplyAmountInfo
                                                           //where item.AuthorId == userId
                                                           select item;

            if (Applicant == 0)
            {
                GetApplyAmounts = from d in GetApplyAmounts
                                  where d.AuthorId == userId
                                  select d;
            }
            else
            {
                GetApplyAmounts = from d in GetApplyAmounts
                                  where d.ApplyUserId == userId
                                  select d;
            }
            if (Status.HasValue && Status.Value != 3)
            {
                GetApplyAmounts = from d in GetApplyAmounts
                                  where (int)d.ApplyStatus == Status.Value
                                  select d;
            }
            if (Start_datetime != null && End_datetime != null)
            {
                End_datetime    = Convert.ToDateTime(End_datetime).AddDays(1).AddMilliseconds(-1);
                GetApplyAmounts = GetApplyAmounts.Where(x => x.ApplyDate >= Start_datetime && x.ApplyDate <= End_datetime).OrderByDescending(x => x.ApplyDate);
            }
            else if (Start_datetime != null)
            {
                GetApplyAmounts = GetApplyAmounts.Where(x => x.ApplyDate >= Start_datetime).OrderByDescending(x => x.ApplyDate);
            }
            else if (End_datetime != null)
            {
                End_datetime    = Convert.ToDateTime(End_datetime).AddDays(1).AddMilliseconds(-1);
                GetApplyAmounts = GetApplyAmounts.Where(x => x.ApplyDate <= End_datetime).OrderByDescending(x => x.ApplyDate);
            }

            Func <IQueryable <ApplyAmountInfo>, IOrderedQueryable <ApplyAmountInfo> > func = null;

            func = (IQueryable <ApplyAmountInfo> d) =>
                   from o in d
                   orderby o.ApplyStatus ascending
                   select o;
            int num = GetApplyAmounts.Count();

            GetApplyAmounts = GetApplyAmounts.GetPage(out num, page, rows, func);
            foreach (ApplyAmountInfo list in GetApplyAmounts.ToList())
            {
                UserMemberInfo userInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id.Equals(list.ApplyUserId));
                list.ApplyName = (userInfo == null ? "" : userInfo.UserName);
                if (list.AuthorId != 0)
                {
                    UserMemberInfo userInfos = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id.Equals(list.AuthorId));
                    list.AuthorName = (userInfo == null ? "" : userInfos.UserName);
                    ChemCloud_Dictionaries dicts = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DictionaryTypeId == 1 && m.DValue == list.CoinType.ToString());
                    list.CoinName = dicts.DKey;
                }
            }
            res.Models = GetApplyAmounts;
            res.Total  = num;
            return(res);
        }
Пример #18
0
        public PageModel <MargainBill> GetBargain <Tout>(BargainQuery bargainQuery)
        {
            IQueryable <MargainBill> platform = context.MargainBill.AsQueryable <MargainBill>();

            if (bargainQuery.StartDate.HasValue)
            {
                DateTime value = bargainQuery.StartDate.Value;
                platform =
                    from d in platform
                    where d.CreateDate >= value
                    select d;
            }
            if (bargainQuery.EndDate.HasValue)
            {
                DateTime dateTime  = bargainQuery.EndDate.Value;
                DateTime dateTime1 = dateTime.AddDays(1).AddSeconds(-1);
                platform =
                    from d in platform
                    where d.CreateDate <= dateTime1
                    select d;
            }
            if (bargainQuery.ShopId.HasValue)
            {
                platform = from item in platform
                           where item.ShopId == bargainQuery.ShopId
                           select item;
            }

            if (!string.IsNullOrWhiteSpace(bargainQuery.BillNo))
            {
                platform = from item in platform
                           where item.BillNo == bargainQuery.BillNo
                           select item;
            }

            if (bargainQuery.BillStatus.HasValue)
            {
                platform = from item in platform
                           where item.BillStatus == bargainQuery.BillStatus
                           select item;
            }
            //筛选掉已删除的询盘
            platform = from item in platform
                       where item.BillStatus != EnumBillStatus.BargainDelete
                       select item;

            int num = platform.Count();

            platform = platform.GetPage(out num, bargainQuery.PageNo, bargainQuery.PageSize);
            foreach (MargainBill list in platform.ToList())
            {
                UserMemberInfo memberInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id.Equals(list.MemberId));
                list.MemberName = memberInfo.UserName;
                ChemCloud_Dictionaries dictionaryInfo = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DictionaryTypeId == 1 && m.DValue == list.CoinType.ToString());
                list.CoinTypeName = (dictionaryInfo == null ? "" : dictionaryInfo.DKey);
            }

            return(new PageModel <MargainBill>()
            {
                Models = platform,
                Total = num
            });
        }
Пример #19
0
        public PageModel <MessageSetting> GetSettings(MessageSettingQuery messageSettingQueryModel)
        {
            IQueryable <MessageSetting> MessageSettings = context.MessageSetting.AsQueryable <MessageSetting>();

            MessageSettings =
                from item in MessageSettings
                select item;

            if (messageSettingQueryModel.Id > 0)
            {
                MessageSettings =
                    from item in MessageSettings
                    where item.Id == messageSettingQueryModel.Id
                    select item;
            }
            if (messageSettingQueryModel.MessageNameId.HasValue && messageSettingQueryModel.MessageNameId.Value != 0)
            {
                MessageSetting.MessageModuleStatus value = messageSettingQueryModel.MessageNameId.Value;
                DateTime dateTime = DateTime.Now.Date.AddSeconds(-1);
                MessageSetting.MessageModuleStatus ActiveStatu = value;

                if (ActiveStatu == MessageSetting.MessageModuleStatus.OrderCreated)
                {
                    MessageSettings =
                        from d in MessageSettings
                        where (int)d.MessageNameId == 1
                        select d;
                }
                else
                {
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.OrderPay)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 2
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.OrderShipping)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 3
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.OrderRefund)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 4
                            select d;
                    }
                    //if (ActiveStatu == MessageSetting.MessageModuleStatus.FindPassWord)
                    //{
                    //    MessageSettings =
                    //    from d in MessageSettings
                    //    where (int)d.MessageNameId == 5
                    //    select d;
                    //}
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.ShopAudited)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 6
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.ShopResult)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 7
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.CertificationApply)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 8
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.ConfirmPay)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 9
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.CertificationResult)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 10
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.LogisticsRece)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 11
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.LogisticsClearance)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 12
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.LogisticsSignIn)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 13
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.MemberRegister)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 14
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.SupplierRegister)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 15
                            select d;
                    }

                    if (ActiveStatu == MessageSetting.MessageModuleStatus.GoodsPayment)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 16
                            select d;
                    }

                    if (ActiveStatu == MessageSetting.MessageModuleStatus.RegisterMailContent)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 17
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.RegisterMailContent_GYS)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 18
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.XunPan)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 19
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.CustomMessage)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 20
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.LimitedAount)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 21
                            select d;
                    }
                    if (ActiveStatu == MessageSetting.MessageModuleStatus.ApplyPass)
                    {
                        MessageSettings =
                            from d in MessageSettings
                            where (int)d.MessageNameId == 22
                            select d;
                    }
                }
            }
            if (messageSettingQueryModel.Status.HasValue && messageSettingQueryModel.Status.Value != 0)
            {
                MessageSettings = from d in MessageSettings where (int)d.ActiveStatus == messageSettingQueryModel.Status select d;
            }
            int num = MessageSettings.Count();

            foreach (MessageSetting ms in MessageSettings.ToList())
            {
                ChemCloud_Dictionaries dicts = context.ChemCloud_Dictionaries.FirstOrDefault((ChemCloud_Dictionaries m) => m.DictionaryTypeId == 10 && m.DValue == ms.Languagetype.ToString());
                ms.LanguageName = dicts.DKey;
            }
            MessageSettings = MessageSettings.GetPage(out num, messageSettingQueryModel.PageNo, messageSettingQueryModel.PageSize);
            return(new PageModel <MessageSetting>()
            {
                Models = MessageSettings,
                Total = num
            });
        }