public JsonResult EditMessageTask(MessageModelDM model) { model.OptUserName = UserContext.Current.Name; var reg = messageProvider.EditMessageTask(model); return(Json(new Ets.Model.Common.ResultModel(reg.DealFlag, reg.DealMsg), JsonRequestBehavior.DenyGet)); }
/// <summary> /// 添加消息任务 /// danny-20150617 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddMessageTask(MessageModelDM model) { string sql = string.Format(@" INSERT INTO [Message] ([PushWay] ,[MessageType] ,[Content] ,[SentStatus] ,[PushType] ,[PushTarget] ,[PushCity] ,[PushPhone] ,[SendType] ,[SendTime] ,[OverTime] ,[CreateBy] ,[CreateTime] ,[UpdateBy] ,[UpdateTime]) VALUES (@PushWay ,@MessageType ,@CONTENT ,@SentStatus ,@PushType ,@PushTarget ,@PushCity ,@PushPhone ,@SendType ,@SendTime ,@OverTime ,@CreateBy ,@CreateTime ,@UpdateBy ,getdate());"); var parm = DbHelper.CreateDbParameters(); parm.AddWithValue("@PushWay", model.PushWay); parm.AddWithValue("@MessageType", model.MessageType); parm.AddWithValue("@Content", model.Content); parm.AddWithValue("@SentStatus", model.SentStatus); parm.AddWithValue("@PushType", model.PushType); parm.AddWithValue("@PushTarget", model.PushTarget); parm.AddWithValue("@PushCity", model.PushCity ?? ""); parm.AddWithValue("@PushPhone", model.PushPhone); parm.AddWithValue("@SendType", model.SendType); parm.AddWithValue("@CreateTime", DateTime.Now); parm.AddWithValue("@SendTime", model.SendType == 1 ? DateTime.Now : model.SendTime);//如果=1 实时发布 parm.AddWithValue("@OverTime", model.OverTime); parm.AddWithValue("@CreateBy", model.OptUserName); parm.AddWithValue("@UpdateBy", model.OptUserName); return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0); }
/// <summary> /// 添加消息任务 /// danny-20150617 /// </summary> /// <param name="model"></param> /// <returns></returns> public DealResultInfo EditMessageTask(MessageModelDM model) { var dealReg = new DealResultInfo { DealFlag = false }; if (model.DealType == 1) { dealReg.DealFlag = messageDao.AddMessageTask(model); dealReg.DealMsg = dealReg.DealFlag ? "消息任务添加成功!" : "消息任务添加失败!"; } else { dealReg.DealFlag = messageDao.ModifyMessageTask(model); dealReg.DealMsg = dealReg.DealFlag ? "消息任务修改成功!" : "消息任务修改失败!"; } return(dealReg); }
/// <summary> /// 修改消息任务 /// danny-20150617 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool ModifyMessageTask(MessageModelDM model) { string sql = @"UPDATE Message SET PushWay=@PushWay, MessageType=@MessageType, Content=@Content, PushType=@PushType, "; if (model.PushType == 1) { sql += " PushTarget=@PushTarget,PushCity=@PushCity, "; } else { sql += " PushPhone=@PushPhone, "; } if (model.SendType == 2) { sql += " SendTime=@SendTime, "; } sql += @" SendType=@SendType WHERE Id = @Id;"; var parm = DbHelper.CreateDbParameters(); parm.AddWithValue("@PushWay", model.PushWay); parm.AddWithValue("@MessageType", model.MessageType); parm.AddWithValue("@Content", model.Content); parm.AddWithValue("@PushType", model.PushType); parm.AddWithValue("@PushTarget", model.PushTarget); parm.AddWithValue("@PushCity", model.PushCity); parm.AddWithValue("@PushPhone", model.PushPhone); parm.AddWithValue("@SendTime", model.SendTime.ToString("yyyy-MM-dd HH:mm:ss").StartsWith("0001") ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : model.SendTime.ToString("yyyy-MM-dd HH:mm:ss")); parm.AddWithValue("@SendType", model.SendType); parm.AddWithValue("@Id", model.Id); return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0); }