private List <CmessageBoard> getBySql_BooksMessage(string sql, List <SqlParameter> paras)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=DESKTOP-QC55GV4\SQLEXPRESS;Initial Catalog=RentBookdb;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = sql;
if (paras != null)
{
foreach (SqlParameter p in paras)
{
cmd.Parameters.Add(p);
}
}
SqlDataReader reader = cmd.ExecuteReader();
List <CmessageBoard> list = new List <CmessageBoard>();
while (reader.Read())
{
CmessageBoard x = new CmessageBoard();
x.bm_id = (int)reader["bm_id"];
x.b_id = reader["b_id"].ToString();
x.m_id = reader["m_id"].ToString();
x.bm_Message = reader["bm_Message"].ToString();
x.bm_MessageTime = (DateTime)reader["bm_MessageTime"];
x.bm_Score = (int)reader["bm_score"];
list.Add(x);
}
con.Close();
return(list);
}
public void delete_BooksMessage(CmessageBoard p)
{
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("M_ID", (object)p.m_id));
executeSql_BooksMessage("delete from BooksMessage where m_id=@M_ID", list);
}
public void create__BooksMessage(CmessageBoard p)
{
string sql = "insert into BooksMessage(";
sql += "bm_Message";
sql += ")values(";
sql += "@BM_MESSAGE)";
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("BM_MESSAGE", (object)p.bm_Message));
executeSql_BooksMessage(sql, paras);
}
