public ActionResult AddOrUpdate()
{
try
{
string id = Request.Form["txtId"].ToStringEx();
var txtKeyWord = Request.Form["txtKeyWord"].ToStringEx();
var selectReplyType = Request.Form["selectReplyType"].ToInt32();
var selectMessageType = Request.Form["selectMessageType"].ToInt32();
var txtContent = Request.Form["txtContent"].ToStringEx();
var selectState = Request.Form["selectState"].ToInt32();
var state = Request.Form["selectState"].ToInt32();
if (id.IsNotNullOrWhiteSpace())
{
//修改
Model.AutoReply model = new BLL.AutoReplys().GetModelById(id);
model.ID = id;
model.Keyword = txtKeyWord;
model.ReplyType = selectReplyType;
model.MessageType = selectMessageType;
model.ReplyIdList = txtContent;
model.state = state;
if (new BLL.AutoReplys().Update(model))
{
return(Content("1"));
}
else
{
return(Content("2"));
}
}
else
{
//新增
Model.AutoReply model = new Model.AutoReply();
model.ID = Guid.NewGuid().ToStringEx();
model.Keyword = txtKeyWord;
model.ReplyType = selectReplyType;
model.MessageType = selectMessageType;
model.ReplyIdList = txtContent;
model.state = state;
if (new BLL.AutoReplys().Add(model))
{
return(Content("3"));
}
else
{
return(Content("4"));
}
}
}
catch (Exception err)
{
return(Content(err.Message));
}
return(Content("0"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.AutoReply model)
{
var strSql = new StringBuilder();
strSql.Append("update CZB_AutoReply set ");
strSql.Append("MessageType=@MessageType,");
strSql.Append("Keyword=@Keyword,");
strSql.Append("ReplyType=@ReplyType,");
strSql.Append("ReplyIdList=@ReplyIdList,");
strSql.Append("Creater=@Creater,");
strSql.Append("Createtime=@Createtime,");
strSql.Append("Updater=@Updater,");
strSql.Append("Updatetime=@Updatetime,");
strSql.Append("state=@state");
strSql.Append(" where ");
strSql.Append("ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50),
new SqlParameter("@MessageType", SqlDbType.Int, 4),
new SqlParameter("@Keyword", SqlDbType.NVarChar, 255),
new SqlParameter("@ReplyType", SqlDbType.Int, 4),
new SqlParameter("@ReplyIdList", SqlDbType.NVarChar, 500),
new SqlParameter("@Creater", SqlDbType.NVarChar, 50),
new SqlParameter("@Createtime", SqlDbType.DateTime),
new SqlParameter("@Updater", SqlDbType.NVarChar, 50),
new SqlParameter("@Updatetime", SqlDbType.DateTime),
new SqlParameter("@state", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.MessageType;
parameters[2].Value = model.Keyword;
parameters[3].Value = model.ReplyType;
parameters[4].Value = model.ReplyIdList;
parameters[5].Value = model.Creater;
parameters[6].Value = model.Createtime;
parameters[7].Value = model.Updater;
parameters[8].Value = model.Updatetime;
parameters[9].Value = model.state;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.AutoReply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CZB_AutoReply(");
strSql.Append("ID,MessageType,Keyword,ReplyType,ReplyIdList,Creater,Createtime,Updater,Updatetime,state)");
strSql.Append(" values (");
strSql.Append("@ID,@MessageType,@Keyword,@ReplyType,@ReplyIdList,@Creater,@Createtime,@Updater,@Updatetime,@state)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50),
new SqlParameter("@MessageType", SqlDbType.Int, 4),
new SqlParameter("@Keyword", SqlDbType.NVarChar, 255),
new SqlParameter("@ReplyType", SqlDbType.Int, 4),
new SqlParameter("@ReplyIdList", SqlDbType.NVarChar, 500),
new SqlParameter("@Creater", SqlDbType.NVarChar, 50),
new SqlParameter("@Createtime", SqlDbType.DateTime),
new SqlParameter("@Updater", SqlDbType.NVarChar, 50),
new SqlParameter("@Updatetime", SqlDbType.DateTime),
new SqlParameter("@state", SqlDbType.Int, 4)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.MessageType;
parameters[2].Value = model.Keyword;
parameters[3].Value = model.ReplyType;
parameters[4].Value = model.ReplyIdList;
parameters[5].Value = model.Creater;
parameters[6].Value = model.Createtime;
parameters[7].Value = model.Updater;
parameters[8].Value = model.Updatetime;
parameters[9].Value = model.state;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Model.AutoReply model)
{
return(dal.Add(model));
}
/// <summary>
/// 修改一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(Model.AutoReply model)
{
return(dal.Update(model));
}
