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 }))); } }
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 }))); } }
public ActionResult ImportSendSms(List <string> strJson, int ImportType = 0) { using (var db = new XkSystem.Models.DbContext()) { var list = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Dto.Sms.Import> >(strJson[0]); //发短信代码 var listSms = new List <Entity.tbSms>(); if (ImportType == decimal.Zero)//模式1:短信内容一致,手机号不一样 { //短信详情 var tb = new Entity.tbSms(); tb.InputDate = DateTime.Now; tb.PlanDate = list.FirstOrDefault().PlanDate.ConvertToDateTime(); tb.SmsTitle = list.FirstOrDefault().SmsTitle; tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId); db.Set <Entity.tbSms>().Add(tb); listSms.Add(tb); foreach (var sms in list) { //发送信息 var tbSmsTo = new Entity.tbSmsTo(); tbSmsTo.Mobile = sms.Mobile; tbSmsTo.Retry = Convert.ToInt32(decimal.Zero); tbSmsTo.SendDate = list.FirstOrDefault().PlanDate.ConvertToDateTime(); tbSmsTo.Status = decimal.Zero; tbSmsTo.tbSms = tb; db.Set <Entity.tbSmsTo>().Add(tbSmsTo); XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("导入了短信手机信息"); } } else//模式2:短信内容不一致,手机号不一样 { foreach (var sms in list) { //短信详情 var tb = new Entity.tbSms(); tb.InputDate = DateTime.Now; tb.PlanDate = sms.PlanDate.ConvertToDateTime(); tb.SmsTitle = sms.SmsTitle; tb.tbSysUser = db.Set <Sys.Entity.tbSysUser>().Find(Code.Common.UserId); db.Set <Entity.tbSms>().Add(tb); listSms.Add(tb); //发送信息 var tbSmsTo = new Entity.tbSmsTo(); tbSmsTo.Mobile = sms.Mobile; tbSmsTo.Retry = Convert.ToInt32(decimal.Zero); tbSmsTo.SendDate = sms.PlanDate.ConvertToDateTime(); tbSmsTo.Status = decimal.Zero; 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("导入了短信"); } return(Json(new { Status = decimal.Zero, Message = "" })); } }