开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > .net编程 > 查看源码
FileA.cs
资源名称：ASP[1].NET.rar　[点击查看]
上传用户：autodoor
上传日期：2022-08-04
资源大小：9973k
文件大小：22k
源码类别：

.net编程

开发平台：

Others

FileA.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Collections; 
  4. using System.Data.SqlClient;
  7. using qminoa.Common;
  8. using qminoa.DA;    
  9. namespace qminoa.DA
  10. {
  11. public class FileA:IDisposable
  12. {
  13. private SqlDataAdapter dsCommand;
  14. private SqlConnection mySqlConnection;
  16. private const string DOCID_PARM = "@DocID"; 
  17. private const string FOLDERID_PARM     = "@FolderID";
  18. private const string HIFOLDERID_PARM    = "@HiFolderID";
  19. private const string FOLDERNAME_PARM     = "@FolderName";
  20. private const string FNAME_PARM ="@FName";
  21. private const string NOTE_PARM     = "@Note";
  22. private const string IHERCTR_PARM  = "@IherCtr";
  23. private const string CDATE_PARM  = "@CDate";
  24. private const string UDATE_PARM = "@UDate";
  25. private const string EMPID_PARM    = "@EmpID";
  26. private const string DDATE_PARM = "@DDate";
  27. private const string STATUS_PARM = "@Status";
  28. private const string DEMPID_PARM = "@dempid";
  29. private const string KEYWORD_PARM ="@keyword";
  30. private const string TYPEID_PARM ="@typeid";
  31. private const string LAYER_PARM = "@layer";//处理文档时用
  32. private const string FSIZE_PARM="@fsize";
  33. private const string FTYPE_PARM="@ftype";
  34. private const string FPATH_PARM="@fpath";
  35. private const string CONT_PARM="@Cont";
  36. private const string OPT_PARM="@opt";
  37. private const string FIlECONTID_PARM ="@filecontid";
  38. private const string SEARCHTEXT_PARM="@searchtext";
  39. private const string DOCTYPE_PARM="@doctype";
  40. public ArrayList arrlist;
  41. public ArrayList arrlistDoc;
  42. public Stack pathstack;
  43. public  string CONN=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
  45. public FileA()
  46. {
  47. mySqlConnection = new SqlConnection(CONN.ToString());
  48. }
  49. public void Dispose()
  50. {
  51. Dispose(true);
  52. GC.SuppressFinalize(true);
  53. }
  55. protected virtual void Dispose(bool disposing)
  56. {
  57. if (! disposing)
  58. return; 
  60. if (dsCommand != null)
  61. {
  62. if(dsCommand.SelectCommand != null)
  63. {    
  64. if( dsCommand.SelectCommand.Connection != null )
  65. dsCommand.SelectCommand.Connection.Dispose();
  66. dsCommand.SelectCommand.Dispose();
  67. }    
  68. dsCommand.Dispose();
  69. dsCommand = null;
  70. }
  71. }
  73. public FileData GetFolderTree()
  74. {
  75. dsCommand = new SqlDataAdapter("fmLoadFolderTree",CONN);
  76. if ( dsCommand == null )
  77. {
  78. throw new System.ObjectDisposedException( GetType().FullName );
  79. }            
  80. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
  81. FileData data = new FileData();
  82. dsCommand.Fill(data,FileData.FMDOCFOLDER_TABLE);
  83. return data;
  84. }
  86. public FileData LoadFile()
  87. {
  88. dsCommand = new SqlDataAdapter("fmLoadFileInfo",CONN);
  89. if ( dsCommand == null )
  90. {
  91. throw new System.ObjectDisposedException( GetType().FullName );
  92. }            
  93. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
  94. FileData data = new FileData();
  95. dsCommand.Fill(data,FileData.FMDOCFOLDER_TABLE);
  96. return data;
  97. }
  99. public FileData LoadSubFolder(int folderid)
  100. {
  101. mySqlConnection.Open();
  102. dsCommand = new SqlDataAdapter();
  103. dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
  104. dsCommand.SelectCommand.CommandText="fmloadsubfolder";  
  105. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure; 
  106. SqlParameterCollection sqlParams = dsCommand.SelectCommand.Parameters;
  107. sqlParams.Add(new SqlParameter(FOLDERID_PARM, SqlDbType.Int)); 
  108. sqlParams[FOLDERID_PARM].Value=folderid; 
  109. dsCommand.SelectCommand.ExecuteNonQuery();
  110. FileData data = new FileData();
  111. dsCommand.Fill(data,FileData.FMDOCFOLDER_TABLE);
  112. mySqlConnection.Close(); 
  113. return data;
  114. }
  116. public FileData LoadhiFolder(int folderid)
  117. {
  118. mySqlConnection.Open();
  119. dsCommand = new SqlDataAdapter();
  120. dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
  121. dsCommand.SelectCommand.CommandText="fmloadhifolderid";  
  122. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure; 
  123. SqlParameterCollection sqlParams = dsCommand.SelectCommand.Parameters;
  124. sqlParams.Add(new SqlParameter(FOLDERID_PARM, SqlDbType.Int)); 
  125. sqlParams[FOLDERID_PARM].Value=folderid; 
  126. dsCommand.SelectCommand.ExecuteNonQuery();
  127. FileData data = new FileData();
  128. dsCommand.Fill(data,FileData.FMDOCFOLDER_TABLE);
  129. mySqlConnection.Close(); 
  130. return data;
  131. }
  133. public  void ChangFolderInfo(int folderid,int hifolderid,string name,string note,DateTime Cdate,bool iherctr,int empid,int TypeId)
  134. {
  135. mySqlConnection.Open(); 
  136. SqlCommand command = mySqlConnection.CreateCommand();
  137. command.CommandText ="fmSaveFolder"; 
  138. command.CommandType =CommandType.StoredProcedure; 
  139. SqlParameterCollection sqlParams = command.Parameters;
  140. sqlParams.Add(new SqlParameter(FOLDERNAME_PARM, SqlDbType.NVarChar,64 ));
  141. sqlParams.Add(new SqlParameter(NOTE_PARM, SqlDbType.NVarChar,128 ));
  142. sqlParams.Add(new SqlParameter(FOLDERID_PARM, SqlDbType.Int));
  143. sqlParams.Add(new SqlParameter(HIFOLDERID_PARM, SqlDbType.Int));
  144. sqlParams.Add(new SqlParameter(CDATE_PARM, SqlDbType.DateTime));
  145. sqlParams.Add(new SqlParameter(EMPID_PARM, SqlDbType.Int));
  146. sqlParams.Add(new SqlParameter(IHERCTR_PARM, SqlDbType.Bit));
  147. sqlParams.Add(new SqlParameter(STATUS_PARM,SqlDbType.Bit));  
  148. sqlParams.Add(new SqlParameter(TYPEID_PARM,SqlDbType.Int));  
  149. sqlParams[FOLDERNAME_PARM].Value = name;
  150. sqlParams[NOTE_PARM].Value =note;
  151. sqlParams[FOLDERID_PARM].Value =folderid;
  152. sqlParams[HIFOLDERID_PARM].Value =hifolderid;
  153. sqlParams[CDATE_PARM].Value=Cdate;  
  154. sqlParams[IHERCTR_PARM].Value =iherctr;
  155. sqlParams[EMPID_PARM].Value =empid;
  156. sqlParams[STATUS_PARM].Value =0;
  157. sqlParams[TYPEID_PARM].Value =TypeId;
  158. command.ExecuteNonQuery(); 
  159. mySqlConnection.Close();    
  160. }
  162. public  void ChangDocInfo(int folderid,string name,string note,DateTime Cdate,string keyword,int empid,int TypeId,int layer)
  163. {
  164. mySqlConnection.Open(); 
  165. SqlCommand command = mySqlConnection.CreateCommand();
  166. command.CommandText ="fmSaveDoc"; 
  167. command.CommandType =CommandType.StoredProcedure; 
  168. SqlParameterCollection sqlParams = command.Parameters;
  169. sqlParams.Add(new SqlParameter(FOLDERID_PARM, SqlDbType.Int));  
  170. sqlParams.Add(new SqlParameter(FNAME_PARM, SqlDbType.NVarChar,64 ));
  171. sqlParams.Add(new SqlParameter(NOTE_PARM, SqlDbType.NVarChar,128 ));
  172. sqlParams.Add(new SqlParameter(CDATE_PARM, SqlDbType.DateTime));
  173. sqlParams.Add(new SqlParameter(EMPID_PARM, SqlDbType.Int));
  174. sqlParams.Add(new SqlParameter(LAYER_PARM, SqlDbType.Int));
  175. sqlParams.Add(new SqlParameter(TYPEID_PARM,SqlDbType.Int));
  176. sqlParams.Add(new SqlParameter(KEYWORD_PARM,SqlDbType.NVarChar,128)); 
  177. sqlParams.Add(new SqlParameter(STATUS_PARM,SqlDbType.Bit));
  178. sqlParams[FNAME_PARM].Value = name;
  179. sqlParams[NOTE_PARM].Value =note;
  180. sqlParams[FOLDERID_PARM].Value =folderid;
  181. sqlParams[CDATE_PARM].Value=Cdate;  
  182. sqlParams[EMPID_PARM].Value =empid;
  183. sqlParams[TYPEID_PARM].Value =TypeId;
  184. sqlParams[KEYWORD_PARM].Value =keyword;
  185. sqlParams[LAYER_PARM].Value =layer;
  186. sqlParams[STATUS_PARM].Value =0;
  187. command.ExecuteNonQuery(); 
  188. mySqlConnection.Close();    
  189. }
  191. public FileData LoadDocFolder(int FolderID)
  192. {
  193. mySqlConnection.Open(); 
  194. dsCommand = new SqlDataAdapter();
  195. if ( dsCommand == null )
  196. {
  197. throw new System.ObjectDisposedException( GetType().FullName );
  198. }            
  199. dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
  200. dsCommand.SelectCommand.Parameters.Add(FOLDERID_PARM,SqlDbType.Int);
  201. dsCommand.SelectCommand.Parameters[FOLDERID_PARM].Value=FolderID;  
  202. dsCommand.SelectCommand.CommandText="fmLoadDoc";  
  203. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
  204. dsCommand.SelectCommand.ExecuteNonQuery();
  205.    FileData data = new FileData();
  206. dsCommand.Fill(data,FileData.FMDOCFOLDER_TABLE);
  207. mySqlConnection.Close(); 
  208. return data;
  209. }
  211. public FileData GetAllTypes()
  212. {
  213. mySqlConnection.Open(); 
  214. dsCommand = new SqlDataAdapter();
  215. if ( dsCommand == null )
  216. {
  217. throw new System.ObjectDisposedException( GetType().FullName );
  218. }
  219. dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
  220. dsCommand.SelectCommand.CommandText="fmGetAllTypes";  
  221. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
  222. dsCommand.SelectCommand.ExecuteNonQuery();
  223. FileData data = new FileData();
  224. dsCommand.Fill(data,FileData.FMFILEATT_TABLE);
  225. mySqlConnection.Close(); 
  226. return data;
  227. }
  229. public FileData SeachAllDocs(int flag)
  230. {
  231. mySqlConnection.Open(); 
  232. dsCommand = new SqlDataAdapter();
  233. if ( dsCommand == null )
  234. {
  235. throw new System.ObjectDisposedException(GetType().FullName );
  236. }
  237. SqlCommand command = mySqlConnection.CreateCommand();
  238. command.CommandText ="fmSeachAllDocs"; 
  239. command.CommandType =CommandType.StoredProcedure; 
  240. SqlParameterCollection sqlParams = command.Parameters;
  241. sqlParams.Add(new SqlParameter("@flag", SqlDbType.Int));
  242. sqlParams["@flag"].Value = flag;
  243. dsCommand.SelectCommand= command;
  244. dsCommand.SelectCommand.ExecuteNonQuery();
  245. FileData data = new FileData();
  246. dsCommand.Fill(data,FileData.FMDOC_TABLE );
  247. mySqlConnection.Close(); 
  248. return data;
  249. }
  251. public FileData ShowAllFileCont()
  252. {
  253. mySqlConnection.Open();
  254. dsCommand = new SqlDataAdapter();
  255. if ( dsCommand == null )
  256. {
  257. throw new System.ObjectDisposedException( GetType().FullName );
  258. }
  259. dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
  260. dsCommand.SelectCommand.CommandText="fmGetAllFileCont";  
  261. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
  262. dsCommand.SelectCommand.ExecuteNonQuery();
  263. FileData data = new FileData();
  264. dsCommand.Fill(data,FileData.FILECONT_TABLE);
  265. mySqlConnection.Close(); 
  266. return data;
  267. }
  269. public FileData GetNullFileCont()
  270. {
  271. mySqlConnection.Open();
  272. dsCommand = new SqlDataAdapter();
  273. if ( dsCommand == null )
  274. {
  275. throw new System.ObjectDisposedException( GetType().FullName );
  276. }
  277. dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
  278. dsCommand.SelectCommand.CommandText="fmGetNullFileCont";  
  279. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
  280. dsCommand.SelectCommand.ExecuteNonQuery();
  281. FileData data = new FileData();
  282. dsCommand.Fill(data,FileData.FILECONT_TABLE);
  283. mySqlConnection.Close(); 
  284. return data;
  285. }
  287. public void InsertFileCont(int docid,string fname,string fpath,int size,string ftype,byte[] filecont,string dtype)
  288. {
  289. mySqlConnection.Open();
  290. SqlCommand command = mySqlConnection.CreateCommand();
  291. command.CommandText ="fmInsertFileCont"; 
  292. command.CommandType =CommandType.StoredProcedure; 
  293. SqlParameterCollection sqlParams = command.Parameters;
  294. sqlParams.Add(new SqlParameter(DOCID_PARM, SqlDbType.Int)); 
  295. sqlParams.Add(new SqlParameter(FNAME_PARM, SqlDbType.NVarChar,64 ));
  296. sqlParams.Add(new SqlParameter(FSIZE_PARM, SqlDbType.Int));
  297. sqlParams.Add(new SqlParameter(FTYPE_PARM, SqlDbType.NVarChar,128));
  298. sqlParams.Add(new SqlParameter(FPATH_PARM, SqlDbType.NVarChar,128));
  299. sqlParams.Add(new SqlParameter(CONT_PARM, SqlDbType.Image));
  300. sqlParams.Add(new SqlParameter(DOCTYPE_PARM,SqlDbType.NVarChar,10));
  301. sqlParams[DOCID_PARM].Value = docid;
  302. sqlParams[FNAME_PARM].Value = fname;
  303. sqlParams[FSIZE_PARM].Value = size;
  304. sqlParams[FPATH_PARM].Value = fpath;
  305. sqlParams[FTYPE_PARM].Value = ftype;
  306. sqlParams[CONT_PARM].Value = filecont;
  307. sqlParams[DOCTYPE_PARM].Value = dtype;
  308. command.ExecuteNonQuery(); 
  309. mySqlConnection.Close();     
  310. }
  312. public void DeleteFolder(int folderid,int empid,int flag)
  313. {
  314. mySqlConnection.Open();
  315. SqlCommand command = mySqlConnection.CreateCommand();
  316. command.CommandText ="fmFolderDelFlag"; 
  317. command.CommandType =CommandType.StoredProcedure; 
  318. SqlParameterCollection sqlParams = command.Parameters;
  319. sqlParams.Add(new SqlParameter(EMPID_PARM, SqlDbType.Int)); 
  320. sqlParams.Add(new SqlParameter(FOLDERID_PARM, SqlDbType.Int));   
  321. sqlParams.Add(new SqlParameter("@flag", SqlDbType.Int)); 
  322. sqlParams[EMPID_PARM].Value=empid;
  323. sqlParams[FOLDERID_PARM].Value=folderid;
  324. sqlParams["@flag"].Value=flag; 
  325. command.ExecuteNonQuery(); 
  326. mySqlConnection.Close();  
  327. }
  329. public void DeleteDoc(int Docid,int empid)
  330. {
  331. mySqlConnection.Open();
  332. SqlCommand command = mySqlConnection.CreateCommand();
  333. command.CommandText ="fmDocDelFlag"; 
  334. command.CommandType =CommandType.StoredProcedure; 
  335. SqlParameterCollection sqlParams = command.Parameters;
  336. sqlParams.Add(new SqlParameter(EMPID_PARM, SqlDbType.Int)); 
  337. sqlParams.Add(new SqlParameter(DOCID_PARM, SqlDbType.Int));   
  338. sqlParams[EMPID_PARM].Value=empid;
  339. sqlParams[DOCID_PARM].Value=Docid;
  340. command.ExecuteNonQuery(); 
  341. mySqlConnection.Close();  
  342. }
  344. public ArrayList GetDelFolderId(int folderid)
  345. {
  346. arrlist =new ArrayList();
  347. arrlist.Add(folderid);
  348. DataView dvdata = SubFolderView(folderid);
  349. AddToArrlist(arrlist,dvdata);
  350. return arrlist;
  351. }
  353. public static DataView SubFolderView(int folderid)
  354. {
  355. FileData filedata =(new FileA()).LoadhiFolder(folderid); 
  356. DataView dvdata =filedata.Tables[FileData.FMDOCFOLDER_TABLE].DefaultView;  
  357. return dvdata;
  358. }
  360. private  static void  AddToArrlist(ArrayList arrlist,DataView dvdata)
  361. {
  362. int recordId; 
  363. int recordcount;
  364. int i;
  365. recordcount=dvdata.Count;
  366. if(recordcount!=0)
  367. {
  368. for(i=0;i<recordcount ;i++)
  369. {
  370. recordId = Convert.ToInt32(dvdata[i].Row[0].ToString()); 
  371. arrlist.Add(recordId);
  372. DataView dv = SubFolderView(recordId);
  373. AddToArrlist(arrlist,dv);
  374. }
  375. }
  376. }
  378. public ArrayList GetDelDocId(ArrayList arrlist)
  379. {
  380. int i;
  381. int j;
  382. FileData filedata;
  383. arrlistDoc=new ArrayList();          
  384. for(i=0;i<arrlist.Count;i++)
  385. {
  386. int fid=Convert.ToInt32(arrlist[i].ToString(),10) ;
  387. filedata=SeachAllDocs(0);
  388. DataView dvdata = filedata.Tables[FileData.FMDOC_TABLE].DefaultView;  
  390. if(dvdata.Count!=0)
  391. {
  392. dvdata.RowFilter= "FolderId="+fid;
  393. int recordcount =dvdata.Count;
  394. for(j=0;j<recordcount;j++)
  395. {
  396. int recordid=Convert.ToInt32(dvdata[j].Row[0].ToString(),10);  
  397. arrlistDoc.Add(recordid); 
  399. }
  400. }
  401. }
  402. return arrlistDoc;
  403. }
  405. public ArrayList GetDelDocIdForReuse(ArrayList arrlist)
  406. {
  407. int i;
  408. int j;
  409. FileData filedata;
  410. arrlistDoc=new ArrayList();          
  411. for(i=0;i<arrlist.Count;i++)
  412. {
  413. int fid=Convert.ToInt32(arrlist[i].ToString(),10) ;
  414. filedata=SeachAllDocs(1);
  415. DataView dvdata = filedata.Tables[FileData.FMDOC_TABLE].DefaultView;  
  416. if(dvdata.Count!=0)
  417. {
  418. dvdata.RowFilter= "FolderId="+fid;
  419. int recordcount =dvdata.Count;
  420. for(j=0;j<recordcount;j++)
  421. {
  422. int recordid=Convert.ToInt32(dvdata[j].Row[0].ToString(),10);  
  423. arrlistDoc.Add(recordid); 
  424. }
  425. }
  426. }
  427. return arrlistDoc;
  428. }
  430. public FileData LoadRecycleFile()
  431. {
  432. dsCommand = new SqlDataAdapter("fmLoadRecycleFileInfo",CONN);
  433. if ( dsCommand == null )
  434. {
  435. throw new System.ObjectDisposedException( GetType().FullName );
  436. }            
  437. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
  438. FileData data = new FileData();
  439. dsCommand.Fill(data,FileData.FMDOC_TABLE);
  440. return data;
  441. }
  443. public void DoRecycle(int opt,int docid)
  444. {
  445. mySqlConnection.Open();
  446. SqlCommand command = mySqlConnection.CreateCommand();
  447. command.CommandText ="fmDoRecycle";
  448. command.CommandType =CommandType.StoredProcedure; 
  449. SqlParameterCollection sqlParams = command.Parameters;
  450. sqlParams.Add(new SqlParameter(OPT_PARM, SqlDbType.Int)); 
  451. sqlParams.Add(new SqlParameter(DOCID_PARM, SqlDbType.Int));   
  452. sqlParams[OPT_PARM].Value=opt;
  453. sqlParams[DOCID_PARM].Value=docid;
  454. command.ExecuteNonQuery(); 
  455. mySqlConnection.Close();  
  456. }
  458. public string GetDocPath(int folderid)
  459. {
  460. int id=folderid;
  461. string path="C:";
  462. pathstack=new Stack();
  463. if(id==0)
  464. {
  465. return path+"\";
  466. }
  467. else
  468. {
  469. pathstack.Push(id);
  470. int fid=gethifolderid(id);
  471. if(fid==0)
  472. {
  473. path=path+"\"+FileA.getfoldername(id);
  474. }
  475. else
  476. {
  477. pathstack.Push(fid);
  478.  
  479. id=fid;
  480. while(fid!=0)
  481. {   
  482. fid=gethifolderid(id);
  483. pathstack.Push(fid);
  484. id=fid;
  485. }
  486. pathstack.Pop();
  487. int recordcount=pathstack.Count;
  488. for(int j=0;j<recordcount;j++)
  489. {
  490. int foldid=Convert.ToInt32(pathstack.Pop()); 
  491. if(foldid!=0)
  492. {
  493. path=path+"\"+FileA.getfoldername(foldid);
  494. }
  495. }
  496. }
  497. return path;
  498. }
  499. }
  501. public static int gethifolderid(int folderid)
  502. {
  503. FileData filedata = (new FileA()).LoadSubFolder(folderid); 
  504. DataView dv=filedata.Tables[FileData.FMDOCFOLDER_TABLE].DefaultView;
  505. int hifolder=Convert.ToInt32(dv[0].Row[2].ToString(),10);
  506. return hifolder;
  507. }
  509. public static string getfoldername(int folderid)
  510. {  
  511. FileData filedata = (new FileA()).LoadSubFolder(folderid); 
  512. DataView dv=filedata.Tables[FileData.FMDOCFOLDER_TABLE].DefaultView;
  513. string name=dv[0].Row[15].ToString();  
  514. return name;
  515. }
  517. public void DeleteFileCont(int filecontId)
  518. {
  519. mySqlConnection.Open();
  520. SqlCommand command = mySqlConnection.CreateCommand();
  521. command.CommandText ="fmDeleteFileCont";// 
  522. command.CommandType =CommandType.StoredProcedure; 
  523. SqlParameterCollection sqlParams = command.Parameters;
  524. sqlParams.Add(new SqlParameter(FIlECONTID_PARM, SqlDbType.Int)); 
  525. sqlParams[FIlECONTID_PARM].Value=filecontId;
  526. command.ExecuteNonQuery(); 
  527. mySqlConnection.Close();  
  528. }
  530. public void MoveFolder(int folderform,int folderto)
  531. {
  532. mySqlConnection.Open();
  533. SqlCommand command = mySqlConnection.CreateCommand();
  534. command.CommandText ="fmMoveFolder";// 
  535. command.CommandType =CommandType.StoredProcedure; 
  536. SqlParameterCollection sqlParams = command.Parameters;
  537. sqlParams.Add(new SqlParameter("@folderfrom", SqlDbType.Int)); 
  538. sqlParams.Add(new SqlParameter("@folderto", SqlDbType.Int)); 
  539. sqlParams["@folderfrom"].Value=folderform;
  540. sqlParams["@folderto"].Value=folderto;
  541. command.ExecuteNonQuery(); 
  542. mySqlConnection.Close();  
  543. }
  545. public void UpdateFileCont()
  546. {
  547. mySqlConnection.Open();
  548. SqlCommand command = mySqlConnection.CreateCommand();
  549. command.CommandText ="fmUpdateFileCont";// 
  550. command.CommandType =CommandType.StoredProcedure; 
  551. SqlParameterCollection sqlParams = command.Parameters;
  552. sqlParams.Add(new SqlParameter(DOCID_PARM, SqlDbType.Int)); 
  553. sqlParams.Add(new SqlParameter(OPT_PARM, SqlDbType.Int)); 
  554. sqlParams[DOCID_PARM].Value=0;
  555. sqlParams[OPT_PARM].Value=1;
  556. command.ExecuteNonQuery(); 
  557. mySqlConnection.Close();  
  558. }
  560. public void MoveDoc(int docid,int folderid)
  561. {
  562. mySqlConnection.Open();
  563. SqlCommand command = mySqlConnection.CreateCommand();
  564. command.CommandText ="fmMoveDoc";// 
  565. command.CommandType =CommandType.StoredProcedure; 
  566. SqlParameterCollection sqlParams = command.Parameters;
  567. sqlParams.Add(new SqlParameter(DOCID_PARM,SqlDbType.Int)); 
  568. sqlParams.Add(new SqlParameter(FOLDERID_PARM,SqlDbType.Int)); 
  569. sqlParams[DOCID_PARM].Value=docid;
  570. sqlParams[FOLDERID_PARM].Value=folderid;
  571. command.ExecuteNonQuery(); 
  572. mySqlConnection.Close();  
  573. }
  575. public void DeleteRight(int conid,int opt)
  576. {
  577. mySqlConnection.Open();
  578. SqlCommand command = mySqlConnection.CreateCommand();
  579. command.CommandText ="fmDeleteFolderRight";
  580. command.CommandType =CommandType.StoredProcedure; 
  581. SqlParameterCollection sqlParams = command.Parameters;
  582. sqlParams.Add(new SqlParameter("@ConId", SqlDbType.Int)); 
  583. sqlParams["@ConId"].Value=conid;
  584. sqlParams.Add(new SqlParameter("@opt", SqlDbType.Int)); 
  585. sqlParams["@opt"].Value=opt;
  586. command.ExecuteNonQuery(); 
  587. mySqlConnection.Close();  
  588. }
  590. public FileData SearchForDoc(string name,string keyword,string content,string empname)
  591. {
  592. mySqlConnection.Open();
  593. dsCommand = new SqlDataAdapter();
  594. dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
  595. dsCommand.SelectCommand.CommandText="fmSearchDoc";  
  596. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure; 
  598. SqlParameterCollection sqlParams = dsCommand.SelectCommand.Parameters;
  599. sqlParams.Add(new SqlParameter("@docname", SqlDbType.NVarChar,50)); 
  600. sqlParams["@docname"].Value="%"+name+"%";
  601. sqlParams.Add(new SqlParameter("@keyword", SqlDbType.NVarChar,50)); 
  602. sqlParams["@keyword"].Value="%"+keyword+"%";
  603. sqlParams.Add(new SqlParameter("@content", SqlDbType.NVarChar,50)); 
  604. sqlParams["@content"].Value=content;
  605. sqlParams.Add(new SqlParameter("@empname", SqlDbType.NVarChar,50)); 
  606. sqlParams["@empname"].Value="%"+empname+"%";
  608. dsCommand.SelectCommand.ExecuteNonQuery();
  609. FileData data = new FileData();
  610. dsCommand.Fill(data,FileData.FMDOCFOLDER_TABLE);
  611. int count=data.Tables[FileData.FMDOCFOLDER_TABLE].DefaultView.Count;   
  612. mySqlConnection.Close(); 
  613. return data;
  615. }
  617. public string GetEmpName(int empid)
  618. {
  619. mySqlConnection.Open();
  620. dsCommand = new SqlDataAdapter();
  621. dsCommand.SelectCommand =  mySqlConnection.CreateCommand();
  622. dsCommand.SelectCommand.CommandText="fmGetMrBaseInfo";  
  623. dsCommand.SelectCommand.CommandType=CommandType.StoredProcedure;   
  624. SqlParameterCollection sqlParams = dsCommand.SelectCommand.Parameters;
  625. sqlParams.Add(new SqlParameter("@opt", SqlDbType.Int)); 
  626. sqlParams["@opt"].Value=2;
  627. DataTable data = new DataTable();
  628. dsCommand.Fill(data);
  630. string empname;
  631. DataView dv=data.DefaultView;
  632. dv.RowFilter="Empid="+empid; 
  633. if(dv.Count!=0)
  634. {
  635. empname=dv[0].Row[1].ToString();   
  636. }
  637. else
  638. {
  639. empname="";
  640. }
  641. return empname;
  642. }
  643. }
  644. }