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