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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > WEB源码(ASP,PHP,...) > 查看源码
Department.cs
资源名称：OAJP.rar　[点击查看]
上传用户：jdb8708888
上传日期：2013-05-29
资源大小：19971k
文件大小：5k
源码类别：

WEB源码(ASP,PHP,...)

开发平台：

C#

Department.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  5. namespace UDS.Components
  6. {
  7. /// <summary>
  8. /// 部门处理类
  9. /// </summary>
  10. public class Department
  11. {
  13. public Department()
  14. {
  15. }
  16. /// <summary>
  17. /// 添加部门
  18. /// </summary>
  19. /// <param name="pid">本部门的父部门id</param>
  20. /// <param name="name">本部门的名称</param>
  21. /// <param name="description">本部门的描述</param>
  22. /// <returns>本部门分配到的id</returns>
  23. public static long Add(long ParentDepartmentID,string name,string description)
  24. {
  25. Database db = new Database();
  26. SqlParameter[] prams = new SqlParameter[3];
  28. prams[0] = new SqlParameter();
  29. prams[1] = new SqlParameter();
  30. prams[2] = new SqlParameter();
  33. prams[0].SqlDbType = SqlDbType.Int;
  34. prams[0].ParameterName = "@Dept_ParentID";
  35. prams[0].Value = ParentDepartmentID;
  38. prams[1].SqlDbType = SqlDbType.VarChar;
  39. prams[1].Size = 255;
  40. prams[1].ParameterName = "@Dept_Name";
  41. prams[1].Value = name;
  44. prams[2].SqlDbType = SqlDbType.Text;
  45. prams[2].ParameterName = "@Dept_Remark";
  46. prams[2].Value = description;
  49. //prams[3] = new SqlParameter();
  50. //prams[3].SqlDbType = SqlDbType.Int;
  51. //prams[3].ParameterName = "@ID";
  52. //prams[3].Direction = ParameterDirection.ReturnValue;
  54. return (db.RunProc("sp_AddDepartment",prams));
  55. }
  56. /// <summary>
  57. /// 添加考勤时间
  58. /// </summary>
  59. /// <param name="id">部门id</param>
  60. /// <param name="ondutytime">上班时间</param>
  61. /// <param name="offdutytime">下班时间</param>
  62. /// <returns></returns>
  63. public static int AddDutyTime(long DepartmentID,DateTime ondutytime,DateTime offdutytime)
  64. {
  65. Database db = new Database();
  66. SqlParameter[] prams = {
  67.    db.MakeInParam("@departmentid",SqlDbType.Int,4,DepartmentID),
  68.    db.MakeInParam("@ondutytime",SqlDbType.DateTime,8,ondutytime),
  69.    db.MakeInParam("@offdutytime",SqlDbType.DateTime,8,offdutytime)
  70.    };
  71. return (db.RunProc("sp_WA_AddDepartmentDutyTime",prams));
  72. }
  73. /// <summary>
  74. /// 更改部门考勤时间
  75. /// </summary>
  76. /// <param name="id">部门id</param>
  77. /// <param name="ondutytime">上班时间</param>
  78. /// <param name="offdutytime">下班时间</param>
  79. /// <returns></returns>
  80. public static int UpdateDutyTime(long DepartmentID,DateTime ondutytime,DateTime offdutytime)
  81. {
  82. Database db = new Database();
  83. SqlParameter[] prams = {
  84.    db.MakeInParam("@departmentid",SqlDbType.Int,4,DepartmentID),
  85.    db.MakeInParam("@ondutytime",SqlDbType.VarChar,20,ondutytime.ToShortTimeString()),
  86.    db.MakeInParam("@offdutytime",SqlDbType.VarChar,20,offdutytime.ToShortTimeString())
  87.    };
  88. return (db.RunProc("sp_WA_UpdateDepartmentDutyTime",prams));
  89. }
  91. public static int DeleteDutyTime(long DepartmentID)
  92. {
  93. Database db = new Database();
  94. SqlParameter[] prams = {
  95.    db.MakeInParam("@departmentid",SqlDbType.Int,4,DepartmentID)
  96.    };
  97. return (db.RunProc("sp_WA_DeleteDepartmentDutyTime",prams));
  98. }
  101. public static int Delete(long DepartmentID)
  102. {
  103. Database db = new Database();
  104. SqlParameter[] prams = {
  105. db.MakeInParam("@Dept_id",SqlDbType.Int,4,DepartmentID)
  106.    };
  107. return(db.RunProc("sp_DeleteDepartment",prams));
  108. }
  110. public static int Modify(long DepartmentID,string dep_name,string dep_description)
  111. {
  112. Database db = new Database();
  113. SqlParameter[] prams = {
  114. db.MakeInParam("@dept_id",SqlDbType.Int,4,DepartmentID),
  115. db.MakeInParam("@dept_name",SqlDbType.VarChar,300,dep_name),
  116. db.MakeInParam("@dept_description",SqlDbType.VarChar,300,dep_description)
  117.    };
  118. return (db.RunProc("sp_UpdateDepartmentInfo",prams));
  119. }
  121. public SqlDataReader GetDepartmentInfo(long DepartmentID)
  122. {
  123. Database db = new Database();
  124. SqlDataReader dr;
  125. SqlParameter[] prams = {
  126.    db.MakeInParam("@dept_id",SqlDbType.Int,4,DepartmentID)
  127.    };
  128. db.RunProc("sp_GetDepartmentInfo",prams,out dr);
  130. return dr;
  132. }
  134. public SqlDataReader GetDepartmentDutyTime(long DepartmentID)
  135. {
  136. Database db = new Database();
  137. SqlDataReader dr;
  138. SqlParameter[] prams = {
  139.    db.MakeInParam("@DeptID",SqlDbType.Int,4,DepartmentID)
  140.    };
  141. db.RunProc("sp_GetDepartmentDutyTime",prams,out dr);
  143. return dr;
  145. }
  146. public int MoveDeparement(long FromDepartmentID,long ToDepartmentID)
  147. {
  149. Database db = new Database();
  150. SqlParameter[] prams = {
  151.    db.MakeInParam("@FromDepartmentID",SqlDbType.Int,4,FromDepartmentID),
  152.    db.MakeInParam("@ToDepartmentID",SqlDbType.Int,4,ToDepartmentID),
  153.    };
  154. return (db.RunProc("sp_MoveDepartment",prams));
  156. }
  158. }
  159. }