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