public int DeleteDownClass(DownClassInfo downClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@catID", downClass.ID);
return objSqlHelper.ExecuteNonQuery("je_DC_DeleteDownClass", objParams);
}
public void InsertDownClass(DownClassInfo downClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@catName", downClass.ClassName);
objSqlHelper.ExecuteNonQuery("je_DC_InsertDownClass", objParams);
}
public int UpdateDownClass(DownClassInfo downClass)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[2];
objParams[0] = new SqlParameter("@catName", downClass.ClassName);
objParams[1] = new SqlParameter("@catID", downClass.ID);
return objSqlHelper.ExecuteNonQuery("je_DC_UpdateDownClass", objParams);
}
public DownClassInfo GetDownClassByID(int classID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@catID", SqlDbType.Int, 4);
objParams[0].Value = classID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_DC_GetDownClassByID", objParams);
DownClassInfo item = new DownClassInfo();
while (reader.Read())
{
item.ID = reader.GetInt32(reader.GetOrdinal("catID"));
item.ClassName = reader.GetString(reader.GetOrdinal("catName"));
item.Order = reader.GetInt32(reader.GetOrdinal("Order"));
item.AddDate = reader.GetDateTime(reader.GetOrdinal("AddDate"));
}
reader.Close();
return item;
}
/// <summary>
/// 删除下载类别信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int DeleteDownClass(DownClassInfo downClass)
{
return downClasses.DeleteDownClass(downClass);
}
/// <summary>
/// 更新下载类别信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int UpdateDownClass(DownClassInfo downClass)
{
return downClasses.UpdateDownClass(downClass);
}
/// <summary>
/// 添加下载类别信息
/// </summary>
/// <param name="link"></param>
public static void InsertDownClass(DownClassInfo downClass)
{
downClasses.InsertDownClass(downClass);
}