public JsonResult SaveLeaveMessage(Model.TD_Donation_LeaveMsg model)
{
if (string.IsNullOrEmpty(model.Message))
{
return(GetErrorResult("请输入留言内容"));
}
if (model.Message.Length > 2000)
{
return(GetErrorResult("内容不能超过2000字"));
}
model.LeaveMsgID = Guid.NewGuid().ToString();
model.CreateTime = DateTime.Now;
var member = MemberData.GetMember();
if (member != null)
{
model.HeaderImage = member.HeaderImage;
model.MemberID = member.MemberID;
model.NickName = member.NickName;
}
int result = leaveMsgBLL.Add(model);
if (result > 0)
{
return(GetSucceedResult(new
{
}, "保存成功"));
}
else
{
return(GetErrorResult("保存失败"));
}
}
public int Add(Model.TD_Donation_LeaveMsg model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TD_Donation_LeaveMsg(");
strSql.Append("LeaveMsgID,DonationID,MemberID,NickName,HeaderImage,Message,CreateTime");
strSql.Append(") values (");
strSql.Append("@LeaveMsgID,@DonationID,@MemberID,@NickName,@HeaderImage,@Message,@CreateTime");
strSql.Append(") ");
MySqlParameter[] parameters =
{
new MySqlParameter("@LeaveMsgID", model.LeaveMsgID),
new MySqlParameter("@DonationID", model.DonationID),
new MySqlParameter("@MemberID", model.MemberID),
new MySqlParameter("@NickName", model.NickName),
new MySqlParameter("@HeaderImage", model.HeaderImage),
new MySqlParameter("@Message", model.Message),
new MySqlParameter("@CreateTime", model.CreateTime)
};
return(MySqlHelperUtil.ExecuteNonQuery(strSql.ToString(), parameters));
}
public int Add(Model.TD_Donation_LeaveMsg model)
{
return(dal.Add(model));
}
