public void InsertGuestBook(GuestBookInfo g) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[6]; objParams[0] = new SqlParameter("@gbTitle", g.Title); objParams[1] = new SqlParameter("@gbContent", g.Content); objParams[2] = new SqlParameter("@gbUserName", g.UserName); objParams[3] = new SqlParameter("@gbEmail", g.Email); objParams[4] = new SqlParameter("@gbAddTime", g.PostTime); objParams[5] = new SqlParameter("@userID", g.UserID); objSqlHelper.ExecuteNonQuery("je_Gb_InsertGuestBook", objParams); }
public GuestBookInfo GetGuestBookByID(int gbID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@gbID", SqlDbType.Int, 4); objParams[0].Value = gbID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Gb_GetGuestBookByID", objParams); GuestBookInfo item = new GuestBookInfo(); while (reader.Read()) { item.GbID = reader.GetInt32(reader.GetOrdinal("gbID")); item.Title = reader.GetString(reader.GetOrdinal("gbTitle")); item.Content = reader.GetString(reader.GetOrdinal("gbContent")); item.UserName = reader.GetString(reader.GetOrdinal("gbUserName")); item.Email = reader.GetString(reader.GetOrdinal("gbEmail")); item.PostTime = reader.GetDateTime(reader.GetOrdinal("gbAddTime")); } reader.Close(); return item; }
public IList<GuestBookInfo> GetGuestBook(int userID) { SqlHelper objSqlHelper = new SqlHelper(); List<GuestBookInfo> gbs = new List<GuestBookInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@userID", SqlDbType.Int, 4); objParams[0].Value = userID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Gb_GetGuestBook", objParams); while (reader.Read()) { GuestBookInfo item = new GuestBookInfo(); item.GbID = reader.GetInt32(reader.GetOrdinal("gbID")); item.Title = reader.GetString(reader.GetOrdinal("gbTitle")); item.Content = reader.GetString(reader.GetOrdinal("gbContent")); item.UserName = reader.GetString(reader.GetOrdinal("gbUserName")); item.Email = reader.GetString(reader.GetOrdinal("gbEmail")); item.PostTime = reader.GetDateTime(reader.GetOrdinal("gbAddTime")); item.SendUserID = reader.GetInt32(reader.GetOrdinal("sendUserID")); gbs.Add(item); } reader.Close(); return gbs; }
/// <summary> /// 添加留言 /// </summary> /// <param name="g"></param> public static void InsertGuestBook(GuestBookInfo g) { gbs.InsertGuestBook(g); }