filea.cs

专业的办公oa代码下载 c#语言编写 三层结构

			sqlParams["@flag"].Value=flag; 
			command.ExecuteNonQuery(); 
			mySqlConnection.Close();  
		}
		
		public void DeleteDoc(int Docid,int empid)
		{
			mySqlConnection.Open();
			SqlCommand command = mySqlConnection.CreateCommand();
			command.CommandText ="fmDocDelFlag"; 
			command.CommandType =CommandType.StoredProcedure; 
			SqlParameterCollection sqlParams = command.Parameters;
			sqlParams.Add(new SqlParameter(EMPID_PARM, SqlDbType.Int)); 
			sqlParams.Add(new SqlParameter(DOCID_PARM, SqlDbType.Int));   
			sqlParams[EMPID_PARM].Value=empid;
			sqlParams[DOCID_PARM].Value=Docid;
			command.ExecuteNonQuery(); 
			mySqlConnection.Close();  
		}

		public ArrayList GetDelFolderId(int folderid)
		{
			arrlist =new ArrayList();
			arrlist.Add(folderid);
			DataView dvdata = SubFolderView(folderid);
			AddToArrlist(arrlist,dvdata);
			return arrlist;
		}

		public static DataView SubFolderView(int folderid)
		{
			FileData filedata =(new FileA()).LoadhiFolder(folderid); 
			DataView dvdata =filedata.Tables[FileData.FMDOCFOLDER_TABLE].DefaultView;  
			return dvdata;
		}

		private  static void  AddToArrlist(ArrayList arrlist,DataView dvdata)
		{
			int recordId; 
			int recordcount;
			int i;
			recordcount=dvdata.Count;
			if(recordcount!=0)
			{
				for(i=0;i<recordcount ;i++)
				{
					recordId = Convert.ToInt32(dvdata[i].Row[0].ToString()); 
					arrlist.Add(recordId);
					DataView dv = SubFolderView(recordId);
					AddToArrlist(arrlist,dv);
				}
			}
		}
		
		public ArrayList GetDelDocId(ArrayList arrlist)
		{
			int i;
			int j;
			FileData filedata;
			arrlistDoc=new ArrayList();          
			for(i=0;i<arrlist.Count;i++)
			{
				int fid=Convert.ToInt32(arrlist[i].ToString(),10) ;
				filedata=SeachAllDocs(0);
				DataView dvdata = filedata.Tables[FileData.FMDOC_TABLE].DefaultView;  
				
				if(dvdata.Count!=0)
				{
					dvdata.RowFilter= "FolderId="+fid;
					int recordcount =dvdata.Count;
					for(j=0;j<recordcount;j++)
					{
						int recordid=Convert.ToInt32(dvdata[j].Row[0].ToString(),10);  
						arrlistDoc.Add(recordid); 
					
					}
				}
			}
			return arrlistDoc;
		}

		public ArrayList GetDelDocIdForReuse(ArrayList arrlist)
		{
			int i;
			int j;
			FileData filedata;
			arrlistDoc=new ArrayList();          
			for(i=0;i<arrlist.Count;i++)
			{
				int fid=Convert.ToInt32(arrlist[i].ToString(),10) ;
				filedata=SeachAllDocs(1);
				DataView dvdata = filedata.Tables[FileData.FMDOC_TABLE].DefaultView;  
				if(dvdata.Count!=0)
				{
					dvdata.RowFilter= "FolderId="+fid;
					int recordcount =dvdata.Count;
					for(j=0;j<recordcount;j++)
					{
						int recordid=Convert.ToInt32(dvdata[j].Row[0].ToString(),10);  
						arrlistDoc.Add(recordid); 
					}
				}
			}
			return arrlistDoc;
		}
		
		public FileData LoadRecycleFile()
		{
			dsCommand = new SqlDataAdapter("fmLoadRecycleFileInfo",CONN);
			if ( dsCommand == null )
			{
				throw new System.ObjectDisposedException( GetType().FullName );
			}            
			dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
			FileData data = new FileData();
			dsCommand.Fill(data,FileData.FMDOC_TABLE);
			return data;
		}
		
		public void DoRecycle(int opt,int docid)
		{
			mySqlConnection.Open();
			SqlCommand command = mySqlConnection.CreateCommand();
			command.CommandText ="fmDoRecycle";
			command.CommandType =CommandType.StoredProcedure; 
			SqlParameterCollection sqlParams = command.Parameters;
			sqlParams.Add(new SqlParameter(OPT_PARM, SqlDbType.Int)); 
			sqlParams.Add(new SqlParameter(DOCID_PARM, SqlDbType.Int));   
			sqlParams[OPT_PARM].Value=opt;
			sqlParams[DOCID_PARM].Value=docid;
			command.ExecuteNonQuery(); 
			mySqlConnection.Close();  
		}
		
		public string GetDocPath(int folderid)
		{
			int id=folderid;
			string path="C:";
			pathstack=new Stack();
			if(id==0)
			{
				return path+"\\";
			}
			else
			{
				pathstack.Push(id);
				int fid=gethifolderid(id);
				if(fid==0)
				{
					path=path+"\\"+FileA.getfoldername(id);
				}
				else
				{
					pathstack.Push(fid);
 
					id=fid;
					while(fid!=0)
					{   
						fid=gethifolderid(id);
						pathstack.Push(fid);
						id=fid;
					}
					pathstack.Pop();
					int recordcount=pathstack.Count;
					for(int j=0;j<recordcount;j++)
					{
						int foldid=Convert.ToInt32(pathstack.Pop()); 
						if(foldid!=0)
						{
							path=path+"\\"+FileA.getfoldername(foldid);
						}
					}
				}
				return path;
			}
		}
		
		public static int gethifolderid(int folderid)
		{
			FileData filedata = (new FileA()).LoadSubFolder(folderid); 
			DataView dv=filedata.Tables[FileData.FMDOCFOLDER_TABLE].DefaultView;
			int hifolder=Convert.ToInt32(dv[0].Row[2].ToString(),10);
			return hifolder;
		}
		
		public static string getfoldername(int folderid)
		{  
			FileData filedata = (new FileA()).LoadSubFolder(folderid); 
			DataView dv=filedata.Tables[FileData.FMDOCFOLDER_TABLE].DefaultView;
			string name=dv[0].Row[15].ToString();  
			return name;
		}
		
		public void DeleteFileCont(int filecontId)
		{
			mySqlConnection.Open();
			SqlCommand command = mySqlConnection.CreateCommand();
			command.CommandText ="fmDeleteFileCont";// 
			command.CommandType =CommandType.StoredProcedure; 
			SqlParameterCollection sqlParams = command.Parameters;
			sqlParams.Add(new SqlParameter(FIlECONTID_PARM, SqlDbType.Int)); 
			sqlParams[FIlECONTID_PARM].Value=filecontId;
			command.ExecuteNonQuery(); 
			mySqlConnection.Close();  
		}

		public void MoveFolder(int folderform,int folderto)
		{
			mySqlConnection.Open();
			SqlCommand command = mySqlConnection.CreateCommand();
			command.CommandText ="fmMoveFolder";// 
			command.CommandType =CommandType.StoredProcedure; 
			SqlParameterCollection sqlParams = command.Parameters;
			sqlParams.Add(new SqlParameter("@folderfrom", SqlDbType.Int)); 
			sqlParams.Add(new SqlParameter("@folderto", SqlDbType.Int)); 
			sqlParams["@folderfrom"].Value=folderform;
			sqlParams["@folderto"].Value=folderto;
			command.ExecuteNonQuery(); 
			mySqlConnection.Close();  
		}
		
		public void UpdateFileCont()
		{
			mySqlConnection.Open();
			SqlCommand command = mySqlConnection.CreateCommand();
			command.CommandText ="fmUpdateFileCont";// 
			command.CommandType =CommandType.StoredProcedure; 
			SqlParameterCollection sqlParams = command.Parameters;
			sqlParams.Add(new SqlParameter(DOCID_PARM, SqlDbType.Int)); 
			sqlParams.Add(new SqlParameter(OPT_PARM, SqlDbType.Int)); 
			sqlParams[DOCID_PARM].Value=0;
			sqlParams[OPT_PARM].Value=1;
			command.ExecuteNonQuery(); 
			mySqlConnection.Close();  
		}

		public void MoveDoc(int docid,int folderid)
		{
			mySqlConnection.Open();
			SqlCommand command = mySqlConnection.CreateCommand();
			command.CommandText ="fmMoveDoc";// 
			command.CommandType =CommandType.StoredProcedure; 
			SqlParameterCollection sqlParams = command.Parameters;
			sqlParams.Add(new SqlParameter(DOCID_PARM,SqlDbType.Int)); 
			sqlParams.Add(new SqlParameter(FOLDERID_PARM,SqlDbType.Int)); 
			sqlParams[DOCID_PARM].Value=docid;
			sqlParams[FOLDERID_PARM].Value=folderid;
			command.ExecuteNonQuery(); 
			mySqlConnection.Close();  
		}
		
		public void DeleteRight(int conid,int opt)
		{
			mySqlConnection.Open();
			SqlCommand command = mySqlConnection.CreateCommand();
			command.CommandText ="fmDeleteFolderRight";
			command.CommandType =CommandType.StoredProcedure; 
			SqlParameterCollection sqlParams = command.Parameters;
			sqlParams.Add(new SqlParameter("@ConId", SqlDbType.Int)); 
			sqlParams["@ConId"].Value=conid;
			sqlParams.Add(new SqlParameter("@opt", SqlDbType.Int)); 
			sqlParams["@opt"].Value=opt;
			command.ExecuteNonQuery(); 
			mySqlConnection.Close();  
		}
		
		public FileData SearchForDoc(string name,string keyword,string content,string empname)
		{
			mySqlConnection.Open();
			dsCommand = new SqlDataAdapter();
			dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
			dsCommand.SelectCommand.CommandText="fmSearchDoc";  
			dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure; 

			SqlParameterCollection sqlParams = dsCommand.SelectCommand.Parameters;
			sqlParams.Add(new SqlParameter("@docname", SqlDbType.NVarChar,50)); 
			sqlParams["@docname"].Value="%"+name+"%";
			sqlParams.Add(new SqlParameter("@keyword", SqlDbType.NVarChar,50)); 
			sqlParams["@keyword"].Value="%"+keyword+"%";
			sqlParams.Add(new SqlParameter("@content", SqlDbType.NVarChar,50)); 
			sqlParams["@content"].Value=content;
			sqlParams.Add(new SqlParameter("@empname", SqlDbType.NVarChar,50)); 
			sqlParams["@empname"].Value="%"+empname+"%";

			dsCommand.SelectCommand.ExecuteNonQuery();
			FileData data = new FileData();
			dsCommand.Fill(data,FileData.FMDOCFOLDER_TABLE);
			int count=data.Tables[FileData.FMDOCFOLDER_TABLE].DefaultView.Count;   
			mySqlConnection.Close(); 
			return data;
		
		}

		public string GetEmpName(int empid)
		{
			mySqlConnection.Open();
			dsCommand = new SqlDataAdapter();
			dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
			dsCommand.SelectCommand.CommandText="fmGetMrBaseInfo";  
			dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
			SqlParameterCollection sqlParams = dsCommand.SelectCommand.Parameters;
			sqlParams.Add(new SqlParameter("@opt", SqlDbType.Int)); 
			sqlParams["@opt"].Value=2;
			DataTable data = new DataTable();
			dsCommand.Fill(data);

			string empname;
			DataView dv=data.DefaultView;
			dv.RowFilter="Empid="+empid; 
			if(dv.Count!=0)
			{
				empname=dv[0].Row[1].ToString();   
			}
			else
			{
				empname="";
			}
			return empname;
		}
	}
}