position.cs

自动化办公系统

using System;
using System.Data;
using System.Data.SqlClient;

namespace UDS.Components
{
	/// <summary>
	/// 部门处理类
	/// </summary>
	public class Position
	{

		public Position()
		{
		}
		/// <summary>
		/// 添加部门
		/// </summary>
		/// <param name="pid">本部门的父部门id</param>
		/// <param name="name">本部门的名称</param>
		/// <param name="description">本部门的描述</param>
		/// <returns>本部门分配到的id</returns>
		public static long Add(long ParentPositionID,string name,string description)
		{
			Database db = new Database();
			SqlParameter[] prams = new SqlParameter[3];
			
			prams[0] = new SqlParameter();
			prams[1] = new SqlParameter();
			prams[2] = new SqlParameter();
			
			
			prams[0].SqlDbType = SqlDbType.Int;
			prams[0].ParameterName = "@Position_ParentID";
			prams[0].Value = ParentPositionID;

			
			prams[1].SqlDbType = SqlDbType.VarChar;
			prams[1].Size = 255;
			prams[1].ParameterName = "@Position_Name";
			prams[1].Value = name.Trim();

			
			prams[2].SqlDbType = SqlDbType.Text;
			prams[2].ParameterName = "@Position_Remark";
			prams[2].Value = description.Trim();
			

			//prams[3] = new SqlParameter();
			//prams[3].SqlDbType = SqlDbType.Int;
			//prams[3].ParameterName = "@ID";
			//prams[3].Direction = ParameterDirection.ReturnValue;

			return (db.RunProc("sp_AddPosition",prams));
		}
		/// <summary>
		/// 添加考勤时间
		/// </summary>
		/// <param name="id">部门id</param>
		/// <param name="ondutytime">上班时间</param>
		/// <param name="offdutytime">下班时间</param>
		/// <returns></returns>
		public static int AddDutyTime(long PositionID,DateTime ondutytime,DateTime offdutytime)
		{
			Database db = new Database();
			SqlParameter[] prams = {
									   db.MakeInParam("@positionid",SqlDbType.Int,4,PositionID),
									   db.MakeInParam("@ondutytime",SqlDbType.DateTime,8,ondutytime),
									   db.MakeInParam("@offdutytime",SqlDbType.DateTime,8,offdutytime)
								   };
			return (db.RunProc("sp_WA_AddPositionDutyTime",prams));
		}
		/// <summary>
		/// 更改部门考勤时间
		/// </summary>
		/// <param name="id">部门id</param>
		/// <param name="ondutytime">上班时间</param>
		/// <param name="offdutytime">下班时间</param>
		/// <returns></returns>
		public static int UpdateDutyTime(long PositionID,DateTime ondutytime,DateTime offdutytime)
		{
			Database db = new Database();
			SqlParameter[] prams = {
									   db.MakeInParam("@positionid",SqlDbType.Int,4,PositionID),
									   db.MakeInParam("@ondutytime",SqlDbType.VarChar,20,ondutytime.ToShortTimeString()),
									   db.MakeInParam("@offdutytime",SqlDbType.VarChar,20,offdutytime.ToShortTimeString())
								   };
			return (db.RunProc("sp_WA_UpdatePositionDutyTime",prams));
		}

		public static int DeleteDutyTime(long PositionID)
		{
			Database db = new Database();
			SqlParameter[] prams = {
									   db.MakeInParam("@positionid",SqlDbType.Int,4,PositionID)
								   };
			return (db.RunProc("sp_WA_DeletePositionDutyTime",prams));
		}


		public static int Delete(long PositionID)
		{
			Database db = new Database();
			SqlParameter[] prams = {
										db.MakeInParam("@Position_id",SqlDbType.Int,4,PositionID)
								   };
			return(db.RunProc("sp_DeletePosition",prams));
		}

		public static int Modify(long PositionID,string dep_name,string dep_description)
		{
			Database db = new Database();
			SqlParameter[] prams = {
										db.MakeInParam("@position_id",SqlDbType.Int,4,PositionID),
										db.MakeInParam("@position_name",SqlDbType.VarChar,300,dep_name.Trim()),
										db.MakeInParam("@position_description",SqlDbType.VarChar,300,dep_description.Trim())
								   };
			return (db.RunProc("sp_UpdatePositionInfo",prams));
		}
		
		public SqlDataReader GetPositionInfo(long PositionID)
		{
			Database db = new Database();
			SqlDataReader dr;
			SqlParameter[] prams = {
									   db.MakeInParam("@position_id",SqlDbType.Int,4,PositionID)
								   };
			db.RunProc("sp_GetPositionInfo",prams,out dr);

			return dr;
			
		}

		public SqlDataReader GetPositionDutyTime(long PositionID)
		{
			Database db = new Database();
			SqlDataReader dr;
			SqlParameter[] prams = {
									   db.MakeInParam("@PositionID",SqlDbType.Int,4,PositionID)
								   };
			db.RunProc("sp_GetPositionDutyTime",prams,out dr);

			return dr;
			
		}
		public int MoveDeparement(long FromPositionID,long ToPositionID)
		{

			Database db = new Database();
			SqlParameter[] prams = {
									   db.MakeInParam("@FromPositionID",SqlDbType.Int,4,FromPositionID),
									   db.MakeInParam("@ToPositionID",SqlDbType.Int,4,ToPositionID),
								   };
			return (db.RunProc("sp_MovePosition",prams));

		}

		#region 人员职位级别更新
		/// <summary>
		/// 人员职位级别更新
		/// </summary>
		/// <param name="PositionID">职位ID</param>
		/// <param name="NewCaste">新职级</param>
		/// <returns>返回是否成功</returns>
		public static int UpdateCaste(long PositionID,int NewCaste) 
		{
			UDS.Components.Database db = new UDS.Components.Database();						

			SqlParameter[] prams = {
									   db.MakeInParam("@PositionID",SqlDbType.Int,4,PositionID),
									   db.MakeInParam("@NewCaste",SqlDbType.Int,4,NewCaste)
									
								   };
			return db.RunProc("sp_UpdatePositionCaste",prams);			
		}

		#endregion

		#region 获得职位名称
		/// <summary>
		/// 获得职位名称
		/// </summary>
		/// <param name="PositionID">职位ID</param>
		/// <returns>职位名称</returns>
		public static string GetPositionName(long PositionID) 
		{
			string PositionName = "";

			Database db = new Database();
			SqlDataReader dr;
			SqlParameter[] prams = {
									   db.MakeInParam("@position_id",SqlDbType.Int,4,PositionID)
								   };
			db.RunProc("sp_GetPositionInfo",prams,out dr);

			if(dr.Read())
			{
				PositionName = dr["Position_Name"].ToString();
			}

			dr.Close();

			return PositionName;
		}
		#endregion

	}
}