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