//新增留言
public int InsertMessage(GHPost viewresult)
{
string sql = @"DECLARE @Uid int;
Set @Uid = (Select rowid
from HelpUser
where UserID = @UserID
)
INSERT INTO dbo.MessageBoard(
postid,userid,message)
VALUES(
@PostID,@Uid,@Message
)";
int Id;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@UserID", viewresult.UserID));
cmd.Parameters.Add(new SqlParameter("@PostID", viewresult.PostID));
cmd.Parameters.Add(new SqlParameter("@Message", viewresult.Message));
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
Id = Convert.ToInt32(cmd.ExecuteNonQuery());
conn.Close();
}
return(Id);
}
public JsonResult InsertMessage(GHPost insertData)
{
return(this.Json(lbService.InsertMessage(insertData)));
}
public int InsertMessage(GHPost viewresult)
{
return(lbDao.InsertMessage(viewresult));
}
