public void InsertCatena(BookCatenaInfo catena)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[3];
objParams[0] = new SqlParameter("@catenaName", StringHelper.convertStr(catena.CatenaName));
objParams[1] = new SqlParameter("@catenaDec", StringHelper.convertStr(catena.CatenaDec));
objParams[2] = new SqlParameter("@addDate", DateTime.Now);
objSqlHelper.ExecuteNonQuery("je_Ct_InsertCatena", objParams);
}
public int UpdateCatena(BookCatenaInfo catena)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@catenaName", StringHelper.convertStr(catena.CatenaName));
objParams[1] = new SqlParameter("@catenaDec", StringHelper.convertStr(catena.CatenaDec));
objParams[2] = new SqlParameter("@addDate", DateTime.Now);
objParams[3] = new SqlParameter("@catenaID", catena.CatenaID);
return objSqlHelper.ExecuteNonQuery("je_Ct_UpdateCatena", objParams);
}
public IList<BookCatenaInfo> GetCatenas()
{
SqlHelper objSqlHelper = new SqlHelper();
List<BookCatenaInfo> catenas = new List<BookCatenaInfo>();
SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ct_GetCatenas");
while (reader.Read())
{
BookCatenaInfo item = new BookCatenaInfo();
item.CatenaID = reader.GetInt32(reader.GetOrdinal("catenaID"));
item.CatenaName = reader.GetString(reader.GetOrdinal("catenaName"));
item.CatenaDec = reader.GetString(reader.GetOrdinal("catenaDec"));
item.AddDate = reader.GetDateTime(reader.GetOrdinal("addDate"));
catenas.Add(item);
}
reader.Close();
return catenas;
}
public BookCatenaInfo GetCatenaByID(int catenaID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@catenaID", SqlDbType.Int, 4);
objParams[0].Value = catenaID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ct_GetCatenaByID", objParams);
BookCatenaInfo item = new BookCatenaInfo();
while (reader.Read())
{
item.CatenaID = reader.GetInt32(reader.GetOrdinal("catenaID"));
item.CatenaName = reader.GetString(reader.GetOrdinal("catenaName"));
item.CatenaDec = reader.GetString(reader.GetOrdinal("catenaDec"));
item.AddDate = reader.GetDateTime(reader.GetOrdinal("addDate"));
}
reader.Close();
return item;
}
/// <summary>
/// 更新图书系列信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int UpdateCatena(BookCatenaInfo catena)
{
return catenas.UpdateCatena(catena);
}
/// <summary>
/// 添加图书系列信息
/// </summary>
/// <param name="link"></param>
public static void InsertCatena(BookCatenaInfo catena)
{
catenas.InsertCatena(catena);
}
