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