public ActionResult Edit(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.Sms.Edit(); if (id != 0) { var tb = (from p in db.Table <Entity.tbSms>() where p.Id == id select new Dto.Sms.Edit { Id = p.Id, SmsTitle = p.SmsTitle, PlanDate = p.PlanDate, SysUserId = p.tbSysUser.Id }).FirstOrDefault(); if (tb != null) { vm.SmsEdit = tb; } } return(View(vm)); } }
public static bool SendCheckCode(Models.Sms.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == decimal.Zero) { var smsId = 0; 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.SmsPIN = vm.SmsEdit.SmsPIN; 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.One; tbSmsTo.SendDate = vm.SmsEdit.PlanDate; tbSmsTo.tbSms = tb; db.Set <Entity.tbSmsTo>().Add(tbSmsTo); } if (db.SaveChanges() > 0) { smsId = tb.Id; XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了密码找回验证码短信"); //单独执行发短信的方法 return(SmsSendController.SmsSendCheckCode(smsId)); } return(false); } return(false); } else { return(false); } } }
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 }))); } }