ASP.NET中的数据库操作类sqlhelper及方法使用指南

于 2010-01-19 12:45:00 发布
阅读量4.8k 收藏 4
点赞数
分类专栏： asp.net 文章标签： 数据库 asp.net object dataset search file

要在VS2005中使用sqlhelper类,必须把Microsoft.ApplicationBlocks.Data.dll引用到项目中.

1.通过存储过程查询的方法SqlHelper.ExecuteDataset(数据库连接字符, 存储过程字符, 参数数组);

2.通过字符串查询的方法SqlHelper.ExecuteDataset(数据库连接字符, CommandType.Text , 查询字符串,参数数组);

3.通过存储过程插入的方法SqlHelper.ExecuteScalar(数据库连接字符, 存储过程字符, 参数数组);

4.通过字符串插入的方法SqlHelper.ExecuteScalar(数据库连接字符, CommandType.Text , 插入及刷新字符串,参数数组);

5.通过存储过程刷新的方法SqlHelper.ExecuteNonQuery(数据库连接字符, 存储过程字符, 参数数组);

6.通过字符串刷新的方法SqlHelper.ExecuteNonQuery(数据库连接字符, CommandType.Text , 刷新字符串,参数数组);

运用实例

 

 

using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
using System.IO;

namespace SK.VideoDAL
{
 /// <summary>
 /// File 的摘要说明。
 /// </summary>
 public class File
 {
  
  /// <summary>
  /// 文件数据访问类
  /// </summary>
  public File()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }
  /// <summary>
  /// 添加文件
  /// </summary>
  /// <param name="FileClassID">文件分类编号</param>
  /// <param name="SetCommend">推荐方式</param>
  /// <param name="SetTop">固顶方式</param>
  /// <param name="Name">文件名称</param>
  /// <param name="Intro">简介</param>
  /// <param name="FileSize">大小</param>
  /// <param name="Grade">评级</param>
  /// <param name="Keyword">关键字</param>
  /// <param name="PreviewUrl">预览图地址</param>
  /// <param name="MemberID">发布人ID</param>
  /// <param name="FileTypeID">文件类别编号</param>
  /// <param name="DownRequire">下载要求</param>
  /// <param name="NeedPoint">下载所需点数</param>
  /// <param name="Status">状态</param>
  public object Add(object FileClassID,object SetCommend,object SetTop,object Name,object Intro,
   object FileSize,object Grade,object Keyword,object PreviewUrl,object MemberID,object FileTypeID,
   object DownRequire,object NeedPoint,object Status,object Actor,object Level,object Region)
  {
   SqlParameter[] oParms = new SqlParameter[17];
   oParms[0]=new SqlParameter("@FileClassID",FileClassID);
   oParms[1]=new SqlParameter("@SetCommend",SetCommend);
   oParms[2]=new SqlParameter("@SetTop",SetTop);
   oParms[3]=new SqlParameter("@Name",Name);
   oParms[4]=new SqlParameter("@Intro",Intro);
   oParms[5]=new SqlParameter("@FileSize",FileSize);
   oParms[6]=new SqlParameter("@Grade",Grade);
   oParms[7]=new SqlParameter("@Keyword",Keyword);
   oParms[8]=new SqlParameter("@PreviewUrl",PreviewUrl);
   oParms[9]=new SqlParameter("@MemberID",MemberID);
   oParms[10]=new SqlParameter("@FileTypeID",FileTypeID);
   oParms[11]=new SqlParameter("@DownRequire",DownRequire);
   oParms[12]=new SqlParameter("@NeedPoint",NeedPoint);
   oParms[13]=new SqlParameter("@Status",Status);
   oParms[14]=new SqlParameter("@Actor",Actor);
   oParms[15]=new SqlParameter("@Level",Level);
   oParms[16]=new SqlParameter("@Region",Region);
   
   return SqlHelper.ExecuteScalar(Data.ConnString, CommandType.Text ,"INSERT INTO [File] ( [FileClassID], SetCommend,SetTop,[Name],[Intro], [FileSize], [Grade], [Keyword], [PreviewUrl], MemberID,FileTypeID,[CreateTime], [UpdateTime],Downloads,Hits,DownRequire,NeedPoint,Status,Actor,[Level],Region) VALUES(@FileClassID,@SetCommend,@SetTop,@Name,@Intro,@FileSize,@Grade,@Keyword,@PreviewUrl,@MemberID,@FileTypeID,getdate(),getdate(),0,0,@DownRequire,@NeedPoint,@Status,@Actor,@Level,@Region); select @@IDENTITY", oParms);
  }
  /// <summary>
  /// 更新指定的文件信息
  /// </summary>
  /// <param name="FileID">文件编号</param>
  /// <param name="FileTypeID">文件类别编号</param>
  /// <param name="FileClassID">文件分类编号</param>
  /// <param name="SetCommend">推荐方式</param>
  /// <param name="SetTop">固顶方式</param>
  /// <param name="Name">文件名称</param>
  /// <param name="Intro">简介</param>
  /// <param name="FileSize">大小</param>
  /// <param name="Grade">评级</param>
  /// <param name="Keyword">关键字</param>
  /// <param name="PreviewUrl">预览图地址</param>
  /// <param name="DownRequire">下载要求</param>
  /// <param name="NeedPoint">下载所需点数</param>
  /// <param name="Status">状态</param>
  public void Update(object FileID,object FileTypeID,object FileClassID,object SetCommend,object SetTop,
   object Name,object Intro,object FileSize,object Grade,object Keyword,object PreviewUrl,
   object DownRequire,object NeedPoint,object Status,object Actor,object Level,object Region)
  {
   SqlParameter[] oParms = new SqlParameter[17];
   oParms[0]=new SqlParameter("@FileID",FileID);
   oParms[1]=new SqlParameter("@FileTypeID",FileTypeID);
   oParms[2]=new SqlParameter("@FileClassID",FileClassID);
   oParms[3]=new SqlParameter("@SetCommend",SetCommend);
   oParms[4]=new SqlParameter("@SetTop",SetTop);
   oParms[5]=new SqlParameter("@Name",Name);
   oParms[6]=new SqlParameter("@Intro",Intro);
   oParms[7]=new SqlParameter("@FileSize",FileSize);
   oParms[8]=new SqlParameter("@Grade",Grade);
   oParms[9]=new SqlParameter("@Keyword",Keyword);
   oParms[10]=new SqlParameter("@PreviewUrl",PreviewUrl);
   oParms[11]=new SqlParameter("@DownRequire",DownRequire);
   oParms[12]=new SqlParameter("@NeedPoint",NeedPoint);
   oParms[13]=new SqlParameter("@Status",Status);
   oParms[14]=new SqlParameter("@Actor",Actor);
   oParms[15]=new SqlParameter("@Level",Level);
   oParms[16]=new SqlParameter("@Region",Region);
   
   SqlHelper.ExecuteNonQuery(Data.ConnString, CommandType.Text," update [File] set FileTypeID=@FileTypeID,FileClassID=@FileClassID,SetCommend=@SetCommend,SetTop=@SetTop,[Name]=@Name,Intro=@Intro,FileSize=@FileSize,Grade=@Grade,Keyword=@Keyword,PreviewUrl=@PreviewUrl,UpdateTime=getdate(),DownRequire=@DownRequire,NeedPoint=@NeedPoint,Status=@Status,Actor=@Actor,[Level]=@Level,Region=@Region where FileID=@FileID", oParms);
  }
  /// <summary>
  /// 删除文件
  /// </summary>
  /// <param name="FileID">文件编号</param>
  public void Delete(object FileID)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Delete";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileID;
   
   SqlHelper.ExecuteNonQuery(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回指定的文件信息
  /// </summary>
  /// <param name="FileID">文件编号</param>
  /// <returns></returns>
  public DataRow Info(object FileID)
  {
   SqlParameter[] oParms =new SqlParameter[1];
   oParms[0] = new SqlParameter("@FileID",FileID);

   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,"select * from [File] where FileID=@FileID",oParms).Tables[0].Rows[0];
  }
  /// <summary>
  /// 指定分类的文件列表(按更新时间排序)
  /// </summary>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="PageSize"></param>
  /// <param name="PageIndex"></param>
  /// <returns></returns>
  public DataSet List(object FileClassID,object PageSize,object PageIndex,object ImageFileSmall_Null)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_List";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileClassID;
   oParms[1].Value=PageSize;
   oParms[2].Value=PageIndex;
   oParms[3].Value=0;
   oParms[4].Value=ImageFileSmall_Null;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 指定分类的文件列表(按大小排序)
  /// </summary>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="PageSize"></param>
  /// <param name="PageIndex"></param>
  /// <returns></returns>
  public DataSet List_OrderBySize(object FileClassID,object PageSize,object PageIndex,object ImageFileSmall_Null)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_List_OrderBySize";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileClassID;
   oParms[1].Value=PageSize;
   oParms[2].Value=PageIndex;
   oParms[3].Value=0;
   oParms[4].Value=ImageFileSmall_Null;
  
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 指定分类的文件列表(按评级排序)
  /// </summary>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="PageSize"></param>
  /// <param name="PageIndex"></param>
  /// <returns></returns>
  public DataSet List_OrderByGrade(object FileClassID,object PageSize,object PageIndex,object ImageFileSmall_Null)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_List_OrderByGrade";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileClassID;
   oParms[1].Value=PageSize;
   oParms[2].Value=PageIndex;
   oParms[3].Value=0;
   oParms[4].Value=ImageFileSmall_Null;

   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 指定分类的文件列表(按人气排序)
  /// </summary>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="PageSize"></param>
  /// <param name="PageIndex"></param>
  /// <returns></returns>
  public DataSet List_OrderByDownloads(object FileClassID,object PageSize,object PageIndex,object ImageFileSmall_Null)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_List_OrderByDownloads";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileClassID;
   oParms[1].Value=PageSize;
   oParms[2].Value=PageIndex;
   oParms[3].Value=0;
   oParms[4].Value=ImageFileSmall_Null;
 
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 指定分类的文件总数
  /// </summary>
  /// <param name="FileClassID">分类编号</param>
  /// <returns></returns>
  public int List_Count(object FileClassID)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_List";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileClassID;
   oParms[1].Value=0;
   oParms[2].Value=0;
   oParms[3].Value=1;
   
   return Convert.ToInt32(SqlHelper.ExecuteScalar(Data.ConnString, spName, oParms));
  }
  /// <summary>
  /// 返回指定分类的下载排行
  /// </summary>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="Num">记录数</param>
  /// <returns></returns>
  public DataSet DownTop(object FileClassID,object Num,object ImageFileSmall_Null)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_DownTop";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileClassID;
   oParms[1].Value=Num;
   oParms[2].Value=ImageFileSmall_Null;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回指定分类的最新文件
  /// </summary>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="Num">记录数</param>
  /// <returns></returns>
  public DataSet NewTop(object FileClassID,object Num,object ImageFileSmall_Null)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_NewTop";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileClassID;
   oParms[1].Value=Num;
   oParms[2].Value=ImageFileSmall_Null;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 分类推荐排行
  /// </summary>
  /// <param name="FileClassID"></param>
  /// <param name="Num"></param>
  /// <returns></returns>
  public DataSet CommendTop(object FileClassID,object Num,object ImageFileSmall_Null)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_CommendTop";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=FileClassID;
   oParms[1].Value=Num;
   oParms[2].Value=ImageFileSmall_Null;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回最新的文件
  /// </summary>
  /// <param name="Num">数量</param>
  /// <returns></returns>
  public DataSet NewTop(object Num,object ImageFileSmall)
  {
   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Top {0} a.FileID,a.[Name] as FileName,a.FileClassID,a.Intro,a.UpdateTime,a.Downloads,a.Hits,b.ClassName,case when c.ImageFileSmall is null then '{1}' else c.ImageFileSmall end as ImageFileSmall from [File] a LEFT JOIN FileClass b ON a.FileClassID=b.FileClassID LEFT JOIN FilePicture c ON a.FileID=c.FileID and c.IsPre=1 where a.Status=1 order by a.UpdateTime desc",Num,ImageFileSmall));
  }

  /// <summary>
  /// 返回最新视频
  /// </summary>
  /// <param name="Num">返回数量条数</param>
  /// <returns></returns>
  public DataSet NewTop(object Num)
  {
   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Top {0} a.FileID,a.[Name] as FileName,a.FileClassID,a.Intro,a.UpdateTime,a.Downloads,a.Hits,b.ClassName from [File] a LEFT JOIN FileClass b ON a.FileClassID=b.FileClassID order by a.UpdateTime desc",Num));
  }
  /// <summary>
  /// 返回所有视频的下载排行
  /// </summary>
  /// <param name="Num">数量</param>
  /// <returns></returns>
  public DataSet DownloadTop_AllFile(object Num)
  {
   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Top {0} a.FileID,a.[Name] as FileName,a.FileClassID,a.UpdateTime,a.Downloads,a.Hits from [File] a LEFT JOIN FileClass b ON a.FileClassID=b.FileClassID order by a.Downloads desc",Num));
  }
  /// <summary>
  /// 返回所有视频的点击排行
  /// </summary>
  /// <param name="Num">数量</param>
  /// <returns></returns>
  public DataSet HitsTop_AllFile(object Num)
  {
   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Top {0} a.FileID,a.[Name] as FileName,a.FileClassID,a.UpdateTime,a.Downloads,a.Hits,b.ClassName from [File] a LEFT JOIN FileClass b ON a.FileClassID=b.FileClassID order by a.Hits desc",Num));
  }
  /// <summary>
  /// 返回所有视频的最新推荐
  /// </summary>
  /// <param name="Num">数量</param>
  /// <returns></returns>
  public DataSet CommendTop_AllFile(object Num)
  {
   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Top {0} a.FileID,a.[Name] as FileName,b.ClassName,a.FileClassID,a.UpdateTime,a.Downloads,a.Hits from [File] a LEFT JOIN FileClass b ON a.FileClassID=b.FileClassID where a.SetCommend!=0 order by a.UpdateTime desc",Num));
  }

  
  /// <summary>
  /// 返回所有软件的下载排行
  /// </summary>
  /// <param name="Num">数量</param>
  /// <returns></returns>
  public DataSet DownloadTop_AllFile(object Num,object ImageFileSmall)
  {
   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Top {0} a.FileID,a.[Name] as FileName,a.FileClassID,a.UpdateTime,a.Downloads,a.Hits,b.ClassName,case when c.ImageFileSmall is null then '{1}' else c.ImageFileSmall end as ImageFileSmall from [File] a LEFT JOIN FileClass b ON a.FileClassID=b.FileClassID LEFT JOIN FilePicture c ON a.FileID=c.FileID and c.IsPre=1 where a.Status=1 order by a.Downloads desc",Num,ImageFileSmall));
  }
  /// <summary>
  /// 返回所有软件的最新推荐
  /// </summary>
  /// <param name="Num">数量</param>
  /// <returns></returns>
  public DataSet CommendTop_AllFile(object Num,object ImageFileSmall)
  {
   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Top {0} a.FileID,a.[Name] as FileName,a.FileClassID,a.UpdateTime,a.Downloads,a.Hits,b.ClassName,case when c.ImageFileSmall is null then '{1}' else c.ImageFileSmall end as ImageFileSmall from [File] a LEFT JOIN FileClass b ON a.FileClassID=b.FileClassID LEFT JOIN FilePicture c ON a.FileID=c.FileID and c.IsPre=1 where a.SetCommend!=0 and a.Status=1 order by a.UpdateTime desc",Num,ImageFileSmall));
  }
  
  /// <summary>
  /// 返回符合条件的文件列表
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="PageSize">每页数</param>
  /// <param name="PageIndex">页码</param>
  /// <returns></returns>
  public DataSet Search(object Name,object FileClassID,object PageSize,object PageIndex)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=FileClassID;
   oParms[2].Value=PageSize;
   oParms[3].Value=PageIndex;
   oParms[4].Value=0;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回搜索结果行数
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="FileClassID">文件分类</param>
  /// <returns></returns>
  public int Search_Count(object Name,object FileClassID)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=FileClassID;
   oParms[2].Value=0;
   oParms[3].Value=0;
   oParms[4].Value=1;
   
   return Convert.ToInt32(SqlHelper.ExecuteScalar(Data.ConnString, spName, oParms));
  }
  /// <summary>
  /// 返回符合条件的文件列表
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="PageSize">每页数</param>
  /// <param name="PageIndex">页码</param>
  /// <returns></returns>
  public DataSet Search_Name(object Name,object FileClassID,object PageSize,object PageIndex)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_Name";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=FileClassID;
   oParms[2].Value=PageSize;
   oParms[3].Value=PageIndex;
   oParms[4].Value=0;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回搜索结果行数
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="FileClassID">文件分类</param>
  /// <returns></returns>
  public int Search_Name_Count(object Name,object FileClassID)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_Name";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=FileClassID;
   oParms[2].Value=0;
   oParms[3].Value=0;
   oParms[4].Value=1;
   
   return Convert.ToInt32(SqlHelper.ExecuteScalar(Data.ConnString, spName, oParms));
  }
  /// <summary>
  /// 返回符合条件的文件列表
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="FileClassID">分类编号</param>
  /// <param name="PageSize">每页数</param>
  /// <param name="PageIndex">页码</param>
  /// <returns></returns>
  public DataSet Search_Intro(object Name,object FileClassID,object PageSize,object PageIndex)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_Intro";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=FileClassID;
   oParms[2].Value=PageSize;
   oParms[3].Value=PageIndex;
   oParms[4].Value=0;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回搜索结果行数
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="FileClassID">文件分类</param>
  /// <returns></returns>
  public int Search_Intro_Count(object Name,object FileClassID)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_Intro";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=FileClassID;
   oParms[2].Value=0;
   oParms[3].Value=0;
   oParms[4].Value=1;
   
   return Convert.ToInt32(SqlHelper.ExecuteScalar(Data.ConnString, spName, oParms));
  }
  /// <summary>
  /// 返回符合条件的文件列表(不定分类)
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="PageSize">每页数</param>
  /// <param name="PageIndex">页码</param>
  /// <returns></returns>
  public DataSet Search_AllClass(object Name,object PageSize,object PageIndex)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_AllClass";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=PageSize;
   oParms[2].Value=PageIndex;
   oParms[3].Value=0;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回搜索结果行数(不定分类)
  /// </summary>
  /// <param name="Name"></param>
  /// <returns></returns>
  public int Search_AllClass_Count(object Name)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_AllClass";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=0;
   oParms[2].Value=0;
   oParms[3].Value=1;
   
   return Convert.ToInt32(SqlHelper.ExecuteScalar(Data.ConnString, spName, oParms));
  }
  /// <summary>
  /// 返回符合条件的文件列表(不定分类)
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="PageSize">每页数</param>
  /// <param name="PageIndex">页码</param>
  /// <returns></returns>
  public DataSet Search_AllClass_Name(object Name,object PageSize,object PageIndex)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_AllClass_Name";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=PageSize;
   oParms[2].Value=PageIndex;
   oParms[3].Value=0;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回搜索结果行数(不定分类)
  /// </summary>
  /// <param name="Name"></param>
  /// <returns></returns>
  public int Search_AllClass_Name_Count(object Name)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_AllClass_Name";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=0;
   oParms[2].Value=0;
   oParms[3].Value=1;
   
   return Convert.ToInt32(SqlHelper.ExecuteScalar(Data.ConnString, spName, oParms));
  }
  /// <summary>
  /// 返回符合条件的文件列表(不定分类)
  /// </summary>
  /// <param name="Name">文件名称</param>
  /// <param name="PageSize">每页数</param>
  /// <param name="PageIndex">页码</param>
  /// <returns></returns>
  public DataSet Search_AllClass_Intro(object Name,object PageSize,object PageIndex)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_AllClass_Intro";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=PageSize;
   oParms[2].Value=PageIndex;
   oParms[3].Value=0;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 返回搜索结果行数(不定分类)
  /// </summary>
  /// <param name="Name"></param>
  /// <returns></returns>
  public int Search_AllClass_Intro_Count(object Name)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Search_AllClass_Intro";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=Name;
   oParms[1].Value=0;
   oParms[2].Value=0;
   oParms[3].Value=1;
   
   return Convert.ToInt32(SqlHelper.ExecuteScalar(Data.ConnString, spName, oParms));
  }
  /// <summary>
  /// 不可见的文件列表
  /// </summary>
  /// <param name="PageSize"></param>
  /// <param name="PageIndex"></param>
  /// <returns></returns>
  public DataSet List_NeedAudit(object PageSize,object PageIndex)
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_List_NeedAudit";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=PageSize;
   oParms[1].Value=PageIndex;
   oParms[2].Value=0;
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms);
  }
  /// <summary>
  /// 不可见的文件数量
  /// </summary>
  /// <returns></returns>
  public int List_NeedAudit_Count()
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_List_NeedAudit";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   oParms[0].Value=0;
   oParms[1].Value=0;
   oParms[2].Value=1;
   
   return Convert.ToInt32(SqlHelper.ExecuteScalar(Data.ConnString, spName, oParms));
  }
  /// <summary>
  /// 返回相关的文件
  /// </summary>
  /// <param name="FileID">当前文件编号</param>
  /// <param name="Keyword">关键字</param>
  /// <param name="Num">数量</param>
  /// <returns></returns>
  public DataSet RelatedList(object FileID,object Keyword,object Num)
  {
   SqlParameter[] oParms = new SqlParameter[2];
   oParms[0]=new SqlParameter("@FileID",FileID);
   oParms[1]=new SqlParameter("@Keyword",Keyword);

   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Top {0} a.FileID,a.[Name] as FileName,a.FileClassID,a.UpdateTime,a.Downloads,a.Hits from [File] a LEFT JOIN FileClass b ON a.FileClassID=b.FileClassID where a.Status=1 and a.FileID!=@FileID and a.Keyword!='' and a.Keyword like '%'+@Keyword+'%'order by a.UpdateTime desc",Num),oParms);
  }
  /// <summary>
  /// 浏览加1　
  /// </summary>
  /// <param name="FileID">编号</param>
  public void HitAddOne(object FileID)
  {
   SqlParameter[] oParms = new SqlParameter[1];
   oParms[0]=new SqlParameter("@FileID",FileID);
   SqlHelper.ExecuteNonQuery(Data.ConnString,CommandType.Text,"update [File] set Hits=Hits+1 where FileID=@FileID",oParms);
  }
  /// <summary>
  /// 下载加1
  /// </summary>
  /// <param name="FileID">编号</param>
  public void DownloadAddOne(object FileID)
  {
   SqlParameter[] oParms = new SqlParameter[1];
   oParms[0]=new SqlParameter("@FileID",FileID);
   SqlHelper.ExecuteNonQuery(Data.ConnString,CommandType.Text,"update [File] set Downloads=Downloads+1 where FileID=@FileID",oParms);
  }
  /// <summary>
  /// 统计软件信息
  /// </summary>
  /// <returns></returns>
  public DataRow Total()
  {
   string spName;
   SqlParameter[] oParms;
   spName = "File_Total";
   oParms = SqlHelperParameterCache.GetSpParameterSet(Data.ConnString, spName);
   
   return SqlHelper.ExecuteDataset(Data.ConnString, spName, oParms).Tables[0].Rows[0];
  }
  /// <summary>
  /// 修改文件类别编号
  /// </summary>
  /// <param name="FileID">文件编号</param>
  /// <param name="FileTypeID">文件类别编号</param>
  public void UpdateFileTypeID(object FileID,object FileTypeID)
  {
   SqlParameter[] oParms = new SqlParameter[2];
   oParms[0]=new SqlParameter("@FileID",FileID);
   oParms[1]=new SqlParameter("@FileTypeID",FileTypeID);

   SqlHelper.ExecuteNonQuery(Data.ConnString,CommandType.Text,"update [File] set FileTypeID=@FileTypeID where FileID=@FileID",oParms);
  }
  /// <summary>
  /// 统计各用户发布的文件数量
  /// </summary>
  /// <param name="BeginDate">开始时间</param>
  /// <param name="EndDate">结束时间</param>
  /// <returns></returns>
  public DataSet Total_Member(object BeginDate,object EndDate)
  {
   return SqlHelper.ExecuteDataset(Data.ConnString,CommandType.Text,String.Format("select Count(a.FileID) as FileCount,a.MemberID from [File] a  where a.MemberID is not null and CreateTime >='{0}' and CreateTime<='{1}' Group by a.MemberID order by Count(FileID) desc",BeginDate,EndDate));
  }

 


 }
}
/

zky0901
关注
  • 0
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值