public ActionResult List(Models.SmsConfig.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, pageSize = vm.Page.PageSize, pageCount = vm.Page.PageCount, pageIndex = vm.Page.PageIndex }))); }
public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.SmsConfig.List(); var tb = from p in db.Table <Entity.tbSmsConfig>() select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.SmsServer.Contains(vm.SearchText)); } vm.SmsConfigList = (from p in tb orderby p.No select new Dto.SmsConfig.List { Id = p.Id, No = p.No, SmsServer = p.SmsServer, SmsAccount = p.SmsAccount, SmsPassword = p.SmsPassword, SmsUrl = p.SmsUrl, SmsServerType = p.SmsServerType, SmsFreeSignName = p.SmsFreeSignName, SmsTemplateCode = p.SmsTemplateCode, Status = p.Status, IsDefault = p.IsDefault }).ToPageList(vm.Page); foreach (var a in vm.SmsConfigList) { a.SmsAccount = Code.Common.DESDeCode(a.SmsAccount); a.SmsPassword = Code.Common.DESDeCode(a.SmsPassword); a.SmsUrl = Code.Common.DESDeCode(a.SmsUrl); a.SmsFreeSignName = Code.Common.DESDeCode(a.SmsFreeSignName); a.SmsTemplateCode = Code.Common.DESDeCode(a.SmsTemplateCode); } return(View(vm)); } }
public ActionResult Export() { using (var db = new XkSystem.Models.DbContext()) { var file = System.IO.Path.GetTempFileName(); var vm = new Models.SmsConfig.List(); var tb = from p in db.Table <Entity.tbSmsConfig>() select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.SmsServer.Contains(vm.SearchText)); } vm.SmsConfigList = (from p in tb orderby p.No select new Dto.SmsConfig.List { Id = p.Id, No = p.No, SmsServer = p.SmsServer, SmsAccount = p.SmsAccount, SmsPassword = p.SmsPassword, SmsUrl = p.SmsUrl, SmsServerType = p.SmsServerType, SmsFreeSignName = p.SmsFreeSignName, SmsTemplateCode = p.SmsTemplateCode, Status = p.Status, IsDefault = p.IsDefault }).ToPageList(vm.Page); foreach (var a in vm.SmsConfigList) { a.SmsAccount = Code.Common.DESDeCode(a.SmsAccount); a.SmsPassword = Code.Common.DESDeCode(a.SmsPassword); a.SmsUrl = Code.Common.DESDeCode(a.SmsUrl); a.SmsFreeSignName = Code.Common.DESDeCode(a.SmsFreeSignName); a.SmsTemplateCode = Code.Common.DESDeCode(a.SmsTemplateCode); } var dt = new System.Data.DataTable(); dt.Columns.AddRange(new System.Data.DataColumn[] { new System.Data.DataColumn("排序"), new System.Data.DataColumn("短信服务"), new System.Data.DataColumn("服务类型"), new System.Data.DataColumn("短信账户"), new System.Data.DataColumn("短信密码"), new System.Data.DataColumn("短信地址(阿里)"), new System.Data.DataColumn("短信签名(阿里)"), new System.Data.DataColumn("短信模版(阿里)"), new System.Data.DataColumn("状态"), new System.Data.DataColumn("是否默认"), }); foreach (var a in vm.SmsConfigList) { var dr = dt.NewRow(); dr["排序"] = a.No; dr["短信服务"] = a.SmsServer; dr["服务类型"] = a.SmsServerTypeName; dr["短信账户"] = a.SmsAccount; dr["短信密码"] = a.SmsPassword; dr["短信地址(阿里)"] = a.SmsUrl; dr["短信签名(阿里)"] = a.SmsFreeSignName; dr["短信模版(阿里)"] = a.SmsTemplateCode; dr["状态"] = a.Status ? "已启用" : "未启用"; dr["是否默认"] = a.IsDefault ? "已激活" : "未激活"; dt.Rows.Add(dr); } Code.NpoiHelper.DataTableToExcel(file, dt); if (string.IsNullOrEmpty(file) == false) { return(File(file, Code.Common.DownloadType, Code.Common.ExportByExcel)); } else { return(View()); } } }