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());
}
