public OrderSharedPushMessageConfig GetOrderSharedPushMessageConfig() { try { OrderSharedPushMessageConfig model = DalShareOrderConfig.GetOrderSharedPushMessageConfig(); if (model != null) { if (!string.IsNullOrWhiteSpace(model.AndroidCommunicationValue)) { model.AndriodModel = JsonConvert.DeserializeObject <AndriodModel>(model.AndroidCommunicationValue); } if (!string.IsNullOrWhiteSpace(model.IOSCommunicationValue)) { model.IOSModel = JsonConvert.DeserializeObject <IOSModel>(model.IOSCommunicationValue); } } return(model); } catch (Exception ex) { Logger.Log(Level.Error, ex, "GetOrderSharedPushMessageConfig"); throw ex; } }
public static bool UpdateOrderSharedPushMessageConfig(OrderSharedPushMessageConfig model) { const string sql = @"UPDATE [Configuration].[dbo].[SE_OrderSharedPushMessageConfig] SET Type=@Type ,MessageTilte=@MessageTilte ,MessageContent=@MessageContent ,PushTitile=@PushTitile ,PushContent=@PushContent ,CreateTime=GETDATE() ,IOSCommunicationValue=@IOSCommunicationValue ,AndroidCommunicationValue=@AndroidCommunicationValue WHERE Id = @Id"; var sqlParameters = new SqlParameter[] { new SqlParameter("@Type", model.Type ?? string.Empty), new SqlParameter("@MessageTilte", model.MessageTilte ?? string.Empty), new SqlParameter("@MessageContent", model.MessageContent ?? string.Empty), new SqlParameter("@PushTitile", model.PushTitile ?? string.Empty), new SqlParameter("@PushContent", model.PushContent ?? string.Empty), new SqlParameter("@Id", model.Id), new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue ?? string.Empty), new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty), }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameters) > 0); }
public void AddPustMessageOprLog(OrderSharedPushMessageConfig model, string opr) { OprLog oprModel = new OprLog(); oprModel.Author = User.Identity.Name; oprModel.ChangeDatetime = DateTime.Now; oprModel.HostName = Request.UserHostName; oprModel.ObjectID = model.Id; oprModel.ObjectType = "SEOSPM"; oprModel.Operation = opr; OprLogManager.AddOprLog(oprModel); }
//------推送消息配置 public List <OrderSharedPushMessageConfig> GetOrderSharedPushMessageConfig(OrderSharedPushMessageConfig model, int pageSize, int pageIndex, out int recordCount) { try { return(DalShareOrderConfig.GetOrderSharedPushMessageConfig(model, pageSize, pageIndex, out recordCount)); } catch (Exception ex) { Logger.Log(Level.Error, ex, "GetOrderSharedPushMessageConfig"); throw ex; } }
public bool InsertOrderSharedPushMessageConfig(OrderSharedPushMessageConfig model, ref int newId) { try { return(DalShareOrderConfig.InsertOrderSharedPushMessageConfig(model, ref newId)); } catch (Exception ex) { Logger.Log(Level.Error, ex, "InsertOrderSharedPushMessageConfig"); throw ex; } }
public bool UpdateOrderSharedPushMessageConfig(OrderSharedPushMessageConfig model) { try { return(DalShareOrderConfig.UpdateOrderSharedPushMessageConfig(model)); } catch (Exception ex) { Logger.Log(Level.Error, ex, "UpdateOrderSharedPushMessageConfig"); throw ex; } }
public JsonResult DeleteMessage(int id) { bool result = false; OrderSharedPushMessageConfig model = new OrderSharedPushMessageConfig(); model.Id = id; if (ShareOrderConfigManager.DeleteOrderSharedPushMessageConfig(id)) { AddPustMessageOprLog(model, "删除"); result = true; } return(Json(result)); }
public ActionResult PushMessage(OrderSharedPushMessageConfig model, int pageIndex = 1, int pageSize = 20) { int count = 0; string strSql = string.Empty; var lists = ShareOrderConfigManager.GetOrderSharedPushMessageConfig(model, pageSize, pageIndex, out count); var list = new OutData <List <OrderSharedPushMessageConfig>, int>(lists, count); var pager = new PagerModel(pageIndex, pageSize) { TotalItem = count }; return(View(new ListModel <OrderSharedPushMessageConfig>(list.ReturnValue, pager))); }
public ActionResult EditMessage(int id = 0) { if (id == 0) { OrderSharedPushMessageConfig model = new OrderSharedPushMessageConfig(); model.IOSModel = new IOSModel(); model.AndriodModel = new AndriodModel(); return(View(model)); } else { OrderSharedPushMessageConfig model = ShareOrderConfigManager.GetOrderSharedPushMessageConfig(id); model.AndriodModel = JsonConvert.DeserializeObject <AndriodModel>(model.AndroidCommunicationValue); model.IOSModel = JsonConvert.DeserializeObject <IOSModel>(model.IOSCommunicationValue); return(View(model)); } }
public static bool InsertOrderSharedPushMessageConfig(OrderSharedPushMessageConfig model, ref int newId) { const string sql = @"INSERT INTO [Configuration].[dbo].[SE_OrderSharedPushMessageConfig] ( [Type] ,[MessageTilte] ,[MessageContent] ,[PushTitile] ,[PushContent] ,[CreateTime] ,IOSCommunicationValue ,AndroidCommunicationValue ) VALUES ( @Type ,@MessageTilte ,@MessageContent ,@PushTitile ,@PushContent ,GETDATE() ,@IOSCommunicationValue ,@AndroidCommunicationValue )SELECT @@IDENTITY "; var sqlParameters = new SqlParameter[] { new SqlParameter("@Type", model.Type ?? string.Empty), new SqlParameter("@MessageTilte", model.MessageTilte ?? string.Empty), new SqlParameter("@MessageContent", model.MessageContent ?? string.Empty), new SqlParameter("@PushTitile", model.PushTitile ?? string.Empty), new SqlParameter("@PushContent", model.PushContent ?? string.Empty), new SqlParameter("@Id", model.Id), new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue ?? string.Empty), new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty), }; newId = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlParameters)); return(newId > 0); }
public ActionResult SaveMessage(string data, string andriod, string ios) { OrderSharedPushMessageConfig model = JsonConvert.DeserializeObject <OrderSharedPushMessageConfig>(data); model.AndroidCommunicationValue = andriod; model.IOSCommunicationValue = ios; string js = "<script>alert(\"保存失败 \");location='/ShareOrderConfig/PushMessage';</script>"; if (model.Id != 0) { if (ShareOrderConfigManager.UpdateOrderSharedPushMessageConfig(model)) { AddPustMessageOprLog(model, "修改"); return(RedirectToAction("PushMessage")); } else { return(Content(js)); } } else { int id = 0; if (ShareOrderConfigManager.InsertOrderSharedPushMessageConfig(model, ref id)) { model.Id = id; AddPustMessageOprLog(model, "添加"); return(RedirectToAction("PushMessage")); } else { return(Content(js)); } } }
//------推送消息配置 public static List <OrderSharedPushMessageConfig> GetOrderSharedPushMessageConfig(OrderSharedPushMessageConfig model, int pageSize, int pageIndex, out int recordCount) { string sql = @"SELECT [Id] ,[Type] ,[MessageTilte] ,[MessageContent] ,[PushTitile] ,[PushContent] ,[CreateTime] ,[IOSCommunicationValue] ,[AndroidCommunicationValue] FROM [Configuration].[dbo].[SE_OrderSharedPushMessageConfig] AS A WITH (NOLOCK) ORDER BY A.[CreateTime] DESC OFFSET ( @PageIndex - 1 ) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY "; string sqlCount = @"SELECT Count(0) FROM [Configuration].[dbo].[SE_OrderSharedPushMessageConfig] AS A WITH (NOLOCK)"; var sqlParameters = new SqlParameter[] { new SqlParameter("@PageSize", pageSize), new SqlParameter("@PageIndex", pageIndex) }; recordCount = (int)SqlHelper.ExecuteScalar(connOnRead, CommandType.Text, sqlCount); return(SqlHelper.ExecuteDataTable(connOnRead, CommandType.Text, sql, sqlParameters).ConvertTo <OrderSharedPushMessageConfig>().ToList()); }