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