public void InsertImageBook(ImageBookInfo image) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[4]; objParams[0] = new SqlParameter("@ImageURL", image.ImageURL); objParams[1] = new SqlParameter("@LinkURL", image.LinkURL); objParams[2] = new SqlParameter("@ImageStation", image.ImageStation); objParams[3] = new SqlParameter("@IsMain", image.IsMain); objSqlHelper.ExecuteNonQuery("je_IB_InsertImageBook", objParams); }
public int UpdateImageBook(ImageBookInfo image) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[5]; objParams[0] = new SqlParameter("@ImageURL", image.ImageURL); objParams[1] = new SqlParameter("@LinkURL", image.LinkURL); objParams[2] = new SqlParameter("@ImageStation", image.ImageStation); objParams[3] = new SqlParameter("@IsMain", image.IsMain); objParams[4] = new SqlParameter("@ImageID", image.ImageID); return objSqlHelper.ExecuteNonQuery("je_IB_UpdateImageBook", objParams); }
public ImageBookInfo GetImageBookByID(int imageID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@imageID", SqlDbType.Int, 4); objParams[0].Value = imageID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_IB_GetImageBookByID", objParams); ImageBookInfo item = new ImageBookInfo(); while (reader.Read()) { item.ImageID = reader.GetInt32(reader.GetOrdinal("imageID")); item.ImageURL = reader.GetString(reader.GetOrdinal("ImageURL")); item.LinkURL = reader.GetString(reader.GetOrdinal("LinkURL")); item.ImageOrder = reader.GetInt32(reader.GetOrdinal("ImageOrder")); item.ImageStation = reader.GetInt32(reader.GetOrdinal("ImageStation")); item.IsMain = reader.GetBoolean(reader.GetOrdinal("IsMain")); item.AddDate = reader.GetDateTime(reader.GetOrdinal("AddDate")); } reader.Close(); return item; }
/// <summary> /// 更新图片信息 /// </summary> /// <param name="g"></param> public static int UpdateImageBook(ImageBookInfo image) { return imageBooks.UpdateImageBook(image); }
/// <summary> /// 添加图片信息 /// </summary> /// <param name="g"></param> public static void InsertImageBook(ImageBookInfo image) { imageBooks.InsertImageBook(image); }