filemanage.cs

很好的啊！中小型企业用的

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// FileManage 的摘要说明
/// </summary>
public class FileManage
{
    SqlCommand myCommand;
    SqlConnection myConnection;
	public FileManage()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
       // String con = ConfigurationManager.AppSettings["MyConnection"].ToString();
        String con = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString.ToString();
        myConnection = new SqlConnection(con);
        myCommand = new SqlCommand();
        myCommand.Connection = myConnection;

	}

    public void CommentAddFile(string fileName, string filePath,int userId,int Flag,int departId,string Ftype) 
    {
        string str;
        if (Flag == 0)//普通用户申请
          str = "Insert into FileInfo(FileName,FilePath,CreatDate,FileState,userId,DepartId,fileType)values(@a,@b,@c,0,@d,@e,@f)"; //fielstate=0 表示普通用户申请
        else
            if(Flag==1)
              str = "Insert into FileInfo(FileName,FilePath,CreatDate,FileState,userId,DepartId,fileType)values(@a,@b,@c,1,@d,@e,@f)"; //fielstate=1 表示后勤人员申请
            else
              str = "Insert into FileInfo(FileName,FilePath,CreatDate,FileState,userId,DepartId,fileType)values(@a,@b,@c,2,@d,@e,@f)";
        myCommand.CommandText = str;
        myCommand.Parameters.Add("a", SqlDbType.Char,20);
        myCommand.Parameters["a"].Value = fileName;
        myCommand.Parameters.Add("b", SqlDbType.Char, 150);
        myCommand.Parameters["b"].Value = filePath;
        myCommand.Parameters.Add("c", SqlDbType.DateTime);
        myCommand.Parameters["c"].Value = DateTime.Now;
        myCommand.Parameters.Add("d", SqlDbType.Int);
        myCommand.Parameters["d"].Value = userId;
        myCommand.Parameters.Add("e", SqlDbType.Int);
        myCommand.Parameters["e"].Value = departId;
        myCommand.Parameters.Add("f", SqlDbType.Char,15);
        myCommand.Parameters["f"].Value = Ftype;
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();
    }

    //获取所有未经后勤部审核的文件

    public DataSet GetSingleFile(int userID)
    {
        string str;
        str = "Select * from FileInfo where  UserID= "+userID.ToString(); //fielstate=0 表示普通用户申请
        myCommand.CommandText = str;
        myConnection.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        da.Fill(ds);
        myConnection.Close();
        return ds;
    }

    public DataSet GetNoFile(int Flag)//Flag =0 后勤未审批的  Flag = 1 主管部未审批
    {
        string str;
        if (Flag == 0)// 
            str = "Select * from FileInfo where FileState =0 "; //fielstate=0 表示普通用户申请
        else
            if(Flag == 1)
              str = "Select *  from FileInfo where FileState =1 "; //fielstate=1 表示后勤人员申请
           else
              str = "Select *  from FileInfo where FileState =2 ";
        myCommand.CommandText = str;
        myConnection.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        da.Fill(ds);
        myConnection.Close();
        return ds;
    }

    //获取所有的文件
    public DataSet GetAllFile()
    {
        string str;
        str = "Select * from FileInfo  "; 
        myCommand.CommandText = str;
        myConnection.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        da.Fill(ds);
        myConnection.Close();
        return ds;
    }

    public void DeleteFile(int fileID)
    {
        string str;
        str = "Delete from FileInfo where fileId=@a ";
        myCommand.CommandText = str;
        myCommand.Parameters.Add("a", SqlDbType.Int);
        myCommand.Parameters["a"].Value = fileID;
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();
    }

    public void HouQinShenPi(int fileID)
    {
        string str;
        str = "update FileInfo set fileState=1  where fileId=@a ";
        myCommand.CommandText = str;
        myCommand.Parameters.Add("a", SqlDbType.Int);
        myCommand.Parameters["a"].Value = fileID;
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();
    }

    public void ZhuguanShenPi(int fileID)
    {
        string str;
        str = "update FileInfo set fileState=2  where fileId=@a ";
        myCommand.CommandText = str;
        myCommand.Parameters.Add("a", SqlDbType.Int);
        myCommand.Parameters["a"].Value = fileID;
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();
    }

    public void AddHouQinChuanye(int userId, int departId, int fileId,int Flag)
    {
        string str;
        if (Flag == 0)//普通用户申请
            str = "Insert into Chuanyue(fileid,userId,departId,CreateDate,flag)values("+fileId.ToString()+","+userId.ToString()+","+departId.ToString()+",'"+DateTime.Now.ToString()+"',0)"; //fielstate=0 表示普通用户申请
        else
            if (Flag == 1)
                str = "Insert into Chuanyue(fileid,userId,departId,CreateDate,flag)values(" + fileId.ToString() + "," + userId.ToString() + "," + departId.ToString() + ",'" + DateTime.Now.ToString() + "',1)"; //fielstate=1 表示后勤人员申请
            else
                str = "Insert into Chuanyue(fileid,userId,departId,CreateDate,flag)values(" + fileId.ToString() + "," + userId.ToString() + "," + departId.ToString() + ",'" + DateTime.Now.ToString() + "',2)";
        myCommand.CommandText = str;
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();
    }

   //获取所有的部门
    public DataSet GetAllDepart()
    {
        string str;
        str = "Select * from DepartInfo"; //fielstate=0 表示普通用户申请
        myCommand.CommandText = str;
        myConnection.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        da.Fill(ds);
        myConnection.Close();
        return ds;
    }

    //根据部门名称获取部门Id
    public int  GetDepartID(string name)
    {
        string str;
        int DepartId=-1;
        str = "Select DepartId from DepartInfo where  departName='" + name+"'"; //fielstate=0 表示普通用户申请
        myCommand.CommandText = str;
        myConnection.Open();
        SqlDataReader dr = myCommand.ExecuteReader();
        while (dr.Read())
        {
            DepartId = int.Parse(dr[0].ToString());
        }
        myConnection.Close();
        return DepartId;
    }

    //获取所已经经过主管部门审核的

    public DataSet GetAllShenheFile()
    {
        string str;
        str = "Select * from FileInfo where fileState=2";  
        myCommand.CommandText = str;
        myConnection.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        da.Fill(ds);
        myConnection.Close();
        return ds;
    }

    //获取需要传阅的信息
    public DataSet GetChuanyue(int flag)
    {
        string str;
        if (flag == 0)
        {
            str = "Select chuanyue.ID,chuanyue.fileId,FileName,UserName,chuanyue.CreateDate,DepartName,chuanyue.flag from FileInfo,UserInfo,Chuanyue,DepartInfo";
            str = str + " where Chuanyue.fileID = FileInfo.FileId and chuanyue.departId=departInfo.departId and userInfo.Userid=chuanyue.userID and chuanyue.flag=0";
        }
        else
            if (flag == 1)
            {
                str = "Select chuanyue.ID,chuanyue.fileId,FileName,UserName,chuanyue.CreateDate,DepartName,chuanyue.flag from FileInfo,UserInfo,Chuanyue,DepartInfo";
                str = str + " where Chuanyue.fileID = FileInfo.FileId and chuanyue.departId=departInfo.departId and userInfo.Userid=chuanyue.userID and chuanyue.flag=1";
            }
            else
            {
                str = "Select chuanyue.ID,chuanyue.fileId,FileName,UserName,chuanyue.CreateDate,DepartName,chuanyue.flag from FileInfo,UserInfo,Chuanyue,DepartInfo";
                str = str + " where Chuanyue.fileID = FileInfo.FileId and chuanyue.departId=departInfo.departId and userInfo.Userid=chuanyue.userID and chuanyue.flag=2";
            }
        myCommand.CommandText = str;
        myConnection.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        da.Fill(ds);
        myConnection.Close();
        return ds;
    }

    //用于查看所有的传阅
    public DataSet GetChuanyue()
    {
        string str;
        str = "Select chuanyue.ID,chuanyue.fileId,FileName,UserName,chuanyue.CreateDate,DepartName,chuanyue.flag from FileInfo,UserInfo,Chuanyue,DepartInfo";
        str = str + " where Chuanyue.fileID = FileInfo.FileId and chuanyue.departId=departInfo.departId and userInfo.Userid=chuanyue.userID";
        myCommand.CommandText = str;
        myConnection.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        da.Fill(ds);
        myConnection.Close();
        return ds;
    }

    public void HouQinChuanyueShenPi(int fileID)
    {
        string str;
        str = "update chuanyue set flag=1  where Id=@a ";
        myCommand.CommandText = str;
        myCommand.Parameters.Add("a", SqlDbType.Int);
        myCommand.Parameters["a"].Value = fileID;
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();
    }

    public void ZhuguanChuanyueShenPi(int fileID)
    {
        string str;
        str = "update chuanyue set flag=2  where Id=@a ";
        myCommand.CommandText = str;
        myCommand.Parameters.Add("a", SqlDbType.Int);
        myCommand.Parameters["a"].Value = fileID;
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();
    }


    public void DeleteChuanyue(int recordID)
    {
        string str;
        str = "Delete from Chuanyue where Id=@a ";
        myCommand.CommandText = str;
        myCommand.Parameters.Add("a", SqlDbType.Int);
        myCommand.Parameters["a"].Value = recordID;
        myConnection.Open();
        myCommand.ExecuteNonQuery();
        myConnection.Close();
    }
}