public DownLoadInfo GetDownLoadByID(int downLoadID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@downID", SqlDbType.Int, 4);
objParams[0].Value = downLoadID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_DL_GetDownLoadByID", objParams);
DownLoadInfo item = new DownLoadInfo();
while (reader.Read())
{
item.ID = reader.GetInt32(reader.GetOrdinal("catID"));
item.ClassName = reader.GetString(reader.GetOrdinal("catName"));
item.DownID = reader.GetInt32(reader.GetOrdinal("DownID"));
item.DownName = reader.GetString(reader.GetOrdinal("DownName"));
item.Rate = reader.GetInt32(reader.GetOrdinal("Rate"));
item.Size = reader.GetInt32(reader.GetOrdinal("Size"));
item.Author = reader.GetString(reader.GetOrdinal("Author"));
item.Dec = reader.GetString(reader.GetOrdinal("Dec"));
item.DownURL = reader.GetString(reader.GetOrdinal("DownURL"));
item.AddDate = reader.GetDateTime(reader.GetOrdinal("AddDate"));
item.DownCount = reader.GetInt32(reader.GetOrdinal("DownCount"));
}
reader.Close();
return item;
}
public int DeleteDownLoad(DownLoadInfo downLoad)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@DownID", downLoad.DownID);
return objSqlHelper.ExecuteNonQuery("je_DL_DeleteDownLoad", objParams);
}
public int UpdateDownLoad(DownLoadInfo downLoad)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[8];
objParams[0] = new SqlParameter("@catID", downLoad.ID);
objParams[1] = new SqlParameter("@DownName", downLoad.DownName);
objParams[2] = new SqlParameter("@Rate", downLoad.Rate);
objParams[3] = new SqlParameter("@Author", downLoad.Author);
objParams[4] = new SqlParameter("@Size", downLoad.Size);
objParams[5] = new SqlParameter("@Dec", downLoad.Dec);
objParams[6] = new SqlParameter("@DownURL", downLoad.DownURL);
objParams[7] = new SqlParameter("@DownID", downLoad.DownID);
return objSqlHelper.ExecuteNonQuery("je_DL_UpdateDownLoad", objParams);
}
/// <summary>
/// 删除下载文件信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int DeleteDownLoad(DownLoadInfo downLoad)
{
return downLoads.DeleteDownLoad(downLoad);
}
/// <summary>
/// 更新下载文件信息
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int UpdateDownLoad(DownLoadInfo downLoad)
{
return downLoads.UpdateDownLoad(downLoad);
}
/// <summary>
/// 添加下载文件信息
/// </summary>
/// <param name="link"></param>
public static void InsertDownLoad(DownLoadInfo downLoad)
{
downLoads.InsertDownLoad(downLoad);
}
