public ActionResult List(Models.Sms.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new
{
searchText = vm.SearchText,
dateSearchFrom = vm.DateSearchFrom,
dateSearchTo = vm.DateSearchTo,
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.Sms.List();
var tb = from p in db.Table <Entity.tbSms>()
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.SmsTitle.Contains(vm.SearchText));
}
//开始日期
if (string.IsNullOrEmpty(vm.DateSearchFrom))
{
vm.DateSearchFrom = DateTime.Now.AddDays(-7).ToString(XkSystem.Code.Common.StringToDate);
}
//结束日期
if (string.IsNullOrEmpty(vm.DateSearchTo))
{
vm.DateSearchTo = DateTime.Now.ToString(XkSystem.Code.Common.StringToDate);
}
var fromDate = Convert.ToDateTime(vm.DateSearchFrom);
var toDate = Convert.ToDateTime(vm.DateSearchTo).AddDays(1);
vm.SmsList = (from p in tb
where p.PlanDate >= fromDate && p.PlanDate < toDate
orderby p.PlanDate, p.InputDate
select new Dto.Sms.List
{
Id = p.Id,
SmsTitle = p.SmsTitle,
PlanDate = p.PlanDate,
InputDate = p.InputDate,
SysUserName = p.tbSysUser.UserName
}).ToPageList(vm.Page);
return(View(vm));
}
}
public ActionResult EditSms(Models.Sms.EditSms vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (vm.SmsEdit.Id > 0)
{
var tb = (from p in db.Table <Entity.tbSms>()
where p.Id == vm.SmsEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
tb.InputDate = DateTime.Now;
tb.PlanDate = vm.SmsEdit.PlanDate;
tb.SmsTitle = vm.SmsEdit.SmsTitle;
tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了短信");
}
}
else
{
error.AddError(Resources.LocalizedText.MsgNotFound);
}
}
}
var vmList = new Models.Sms.List();
return(Code.MvcHelper.Post(error, Url.Action("List", new
{
searchText = vmList.SearchText,
dateSearchFrom = vmList.DateSearchFrom,
dateSearchTo = vmList.DateSearchTo,
pageIndex = vmList.Page.PageIndex,
pageSize = vmList.Page.PageSize
})));
}
}
public ActionResult Edit(Models.Sms.Edit vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (vm.SmsEdit.Id == 0)
{
var tb = new Entity.tbSms();
tb.InputDate = DateTime.Now;
tb.PlanDate = vm.SmsEdit.PlanDate;
tb.SmsTitle = vm.SmsEdit.SmsTitle;
tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId);
db.Set <Entity.tbSms>().Add(tb);
//循环电话
var mobileArr = vm.SmsEdit.Mobile.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
foreach (var mobile in mobileArr)
{
var tbSmsTo = new Entity.tbSmsTo();
tbSmsTo.Mobile = mobile;
tbSmsTo.Retry = Convert.ToInt32(decimal.Zero);
tbSmsTo.Status = decimal.Zero;
tbSmsTo.SendDate = vm.SmsEdit.PlanDate;
tbSmsTo.tbSms = tb;
db.Set <Entity.tbSmsTo>().Add(tbSmsTo);
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了短信记录");
}
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了短信");
}
}
else
{
var tb = (from p in db.Table <Entity.tbSms>()
where p.Id == vm.SmsEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
tb.PlanDate = vm.SmsEdit.PlanDate;
tb.SmsTitle = vm.SmsEdit.SmsTitle;
tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了短信");
}
}
else
{
error.AddError(Resources.LocalizedText.MsgNotFound);
}
}
}
var vmList = new Models.Sms.List();
return(Code.MvcHelper.Post(error, Url.Action("List", new
{
searchText = vmList.SearchText,
dateSearchFrom = vmList.DateSearchFrom,
dateSearchTo = vmList.DateSearchTo,
pageIndex = vmList.Page.PageIndex,
pageSize = vmList.Page.PageSize
})));
}
}
public ActionResult SelectUserSend(Models.Sms.SelectUserSend vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (vm.SelectUserSendEdit.Id == 0)
{
var tb = new Entity.tbSms();
tb.InputDate = DateTime.Now;
tb.PlanDate = vm.SelectUserSendEdit.PlanDate;
tb.SmsTitle = vm.SelectUserSendEdit.SmsTitle;
tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId);
db.Set <Entity.tbSms>().Add(tb);
//循环电话
var userIds = vm.SelectUserSendEdit.Mobile.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
if (userIds.Count() == decimal.Zero)
{
var errorMsg = new { Status = decimal.Zero, Message = "请选择需要接受短信的人员" };
return(Json(errorMsg));
}
var tbSysUserList = (from p in db.Table <Sys.Entity.tbSysUser>()
where userIds.Contains(p.Id.ToString())
select p).ToList();
var addEntitySmsToList = new List <Entity.tbSmsTo>();
foreach (var user in tbSysUserList)
{
var tbSmsTo = new Entity.tbSmsTo();
tbSmsTo.Mobile = user.Mobile;
tbSmsTo.tbSysUser = user;
tbSmsTo.Retry = Convert.ToInt32(decimal.Zero);
tbSmsTo.SendDate = vm.SelectUserSendEdit.PlanDate;
tbSmsTo.Status = decimal.Zero;
tbSmsTo.tbSms = tb;
addEntitySmsToList.Add(tbSmsTo);
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了短信手机信息");
}
db.Set <Entity.tbSmsTo>().AddRange(addEntitySmsToList);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了短信");
}
}
else
{
var tb = (from p in db.Table <Entity.tbSms>()
where p.Id == vm.SelectUserSendEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
tb.InputDate = DateTime.Now;
tb.PlanDate = vm.SelectUserSendEdit.PlanDate;
tb.SmsTitle = vm.SelectUserSendEdit.SmsTitle;
tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了短信");
}
}
else
{
error.AddError(Resources.LocalizedText.MsgNotFound);
}
}
}
var vmList = new Models.Sms.List();
return(Code.MvcHelper.Post(error, Url.Action("List", new
{
searchText = vmList.SearchText,
dateSearchFrom = vmList.DateSearchFrom,
dateSearchTo = vmList.DateSearchTo,
pageIndex = vmList.Page.PageIndex,
pageSize = vmList.Page.PageSize
})));
}
}
