Category

Development Platform
Home > SourceCode/Document > Internet-Socket-Network > WEB(ASP,PHP,...) > View Code
Directory.cs
Package: OAJP.rar　[view]
Upload User: jdb8708888
Upload Date: 2013-05-29
Package Size: 19971k
Code Size: 4k
Category:

WEB(ASP,PHP,...)

Development Platform:

C#

Directory.cs：Code Content
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  4. using System.IO;
  5. using System.Collections ;
  6. using System.Configuration;
  8. namespace UDS.Components
  9. {
  10. /// <summary>
  11. /// 目录管理
  12. /// </summary>
  13. public class DirectoryClass
  14. {
  15. #region 目录添加
  16. /// <summary>
  17. /// 目录添加
  18. /// </summary>
  19. public  void Add(int ParentID,string ProjectName,string ProjectRemark,string Wright,int Status,int Scale,DateTime StartDate,DateTime EndDate)
  20. {
  22. // 定义数据库操作类及DataReader
  23. Database data = new Database();
  25. // 执行存储过程，并返回SqlDataReader对象
  26. SqlParameter[] prams = {
  27.    data.MakeInParam("@ParentID" , SqlDbType.Int, 20, ParentID),
  28.    data.MakeInParam("@ProjectName" , SqlDbType.NVarChar, 20, ProjectName),
  29.    data.MakeInParam("@ProjectRemark" , SqlDbType.NVarChar, 400, ProjectRemark),
  30.    data.MakeInParam("@Wright" , SqlDbType.NVarChar, 40, Wright),
  31.    data.MakeInParam("@Status" , SqlDbType.Int, 40, Status),
  32.    data.MakeInParam("@Scale" , SqlDbType.Int, 20, Scale),
  33.    data.MakeInParam("@StartDate" , SqlDbType.DateTime, 30, StartDate),
  34.    data.MakeInParam("@EndDate" , SqlDbType.DateTime, 30, EndDate)
  35.    };
  37. try 
  38. {
  39. data.RunProc("sp_AddProject",prams);
  41. }
  42. catch(Exception ex)
  43. {
  44. Error.Log(ex.ToString());
  45. throw new Exception("项目添加出错",ex);
  46. }
  47. finally
  48. {
  49. data    = null;
  50. }
  52. }
  53. #endregion
  55. #region 获取某项目详细信息
  56. /// <summary>
  57. /// 获取某目录详细信息
  58. /// </summary>
  59. /// <param name="ClassID">目录ID</param>
  60. public SqlDataReader GetProjectDetail(int ClassID)
  61. {
  62. SqlDataReader dataReader = null;
  63. Database data = new Database();
  64. SqlParameter[] prams = 
  65. {
  66. data.MakeInParam("@TeamID", SqlDbType.Int, 20 ,ClassID)
  67. };
  68. try
  69. {
  70. data.RunProc("sp_GetTeamInfo",prams, out dataReader);
  71. return dataReader;
  72. }
  74. catch(Exception ex)
  75. {
  76. Error.Log(ex.ToString());
  77. return null;
  78. }
  80. }
  81. #endregion
  83. #region 修改某目录信息
  84. /// <summary>
  85. /// 修改某目录信息
  86. /// </summary>
  87. /// <param name="ClassID">目录ID</param>
  88. public void Revise(int ClassID,string ProjectName,string ProjectRemark,int Status,int Scale,DateTime StartDate,DateTime EndDate)
  89. {
  91. Database data = new Database();
  92. SqlParameter[] prams = {
  93.    data.MakeInParam("@ProjectID" , SqlDbType.Int, 20, ClassID),
  94.    data.MakeInParam("@ProjectName" , SqlDbType.NVarChar, 20, ProjectName),
  95.    data.MakeInParam("@ProjectRemark" , SqlDbType.NVarChar, 400, ProjectRemark),
  96.    data.MakeInParam("@Status" , SqlDbType.Int, 40, Status),
  97.    data.MakeInParam("@Scale" , SqlDbType.Int, 20, Scale),
  98.    data.MakeInParam("@StartDate" , SqlDbType.DateTime, 30, StartDate),
  99.    data.MakeInParam("@EndDate" , SqlDbType.DateTime, 30, EndDate)
  100.    };
  101. try
  102. {
  103. data.RunProc("sp_UpdateProject",prams);
  104. }
  106. catch(Exception ex)
  107. {
  108. Error.Log(ex.ToString());
  110. }
  112. }
  113. #endregion
  115. #region 删除某目录
  116. /// <summary>
  117. /// 删除某目录
  118. /// </summary>
  119. /// <param name="ClassID">项目ID</param>
  120. public void Delete(int ClassID)
  121. {
  123. Database data = new Database();
  124. SqlParameter[] prams = {
  125.    data.MakeInParam("@TeamID" , SqlDbType.Int, 20, ClassID),
  126. };
  127. try
  128. {
  129. data.RunProc("sp_DeleteTeam",prams);
  130. }
  132. catch(Exception ex)
  133. {
  134. Error.Log(ex.ToString());
  136. }
  138. }
  139. #endregion
  140. }
  141. }