public JsonResult List(long?Id, int?MessageNameId, int?Status, int page, int rows) { MessageSetting.MessageModuleStatus?nullable; MessageSettingQuery messageQuery = new MessageSettingQuery() { Id = Id, Status = Status }; int?nullable1 = MessageNameId; if (nullable1.HasValue) { nullable = new MessageSetting.MessageModuleStatus?((MessageSetting.MessageModuleStatus)nullable1.GetValueOrDefault()); } else { nullable = null; } MessageSettingQuery messageQuery1 = messageQuery; messageQuery.MessageNameId = nullable; messageQuery.PageSize = rows; messageQuery.PageNo = page; PageModel <MessageSetting> settings = ServiceHelper.Create <IMessageSettingService>().GetSettings(messageQuery); IMessageSettingService messageService = ServiceHelper.Create <IMessageSettingService>(); IEnumerable <MessageSettingModel> array = from item in settings.Models.ToArray() select new MessageSettingModel() { Id = item.Id, MessageNameId = item.MessageNameId.ToDescription(), MessageContent = item.MessageContent, Languagetype = item.Languagetype, LanguageName = item.LanguageName, CreatDate = DateTime.Now, ActiveStatus = item.ActiveStatus, TitleId = (int)item.MessageNameId }; DataGridModel <MessageSettingModel> dataGridModel = new DataGridModel <MessageSettingModel>() { rows = array, total = settings.Total }; return(Json(dataGridModel)); }
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 }); }