mrbaseinf.cs

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

			SqlCommand command = new SqlCommand();
			command.CommandText = "InsertMrVita";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			command.Parameters.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			command.Parameters.Add(paramChg(EmpVisaData.FDATE_FIELD),SqlDbType.DateTime);
			command.Parameters.Add(paramChg(EmpVisaData.TDATE_FIELD),SqlDbType.DateTime);
			command.Parameters.Add(paramChg(EmpVisaData.COMMPANY_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpVisaData.DEPNAME_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpVisaData.POSITION_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpVisaData.VISANOTE_FIELD),SqlDbType.Text);

			command.Parameters[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
			command.Parameters[paramChg(EmpVisaData.FDATE_FIELD)].SourceColumn = EmpVisaData.FDATE_FIELD;
			command.Parameters[paramChg(EmpVisaData.TDATE_FIELD)].SourceColumn = EmpVisaData.TDATE_FIELD;
			command.Parameters[paramChg(EmpVisaData.COMMPANY_FIELD)].SourceColumn = EmpVisaData.COMMPANY_FIELD;
			command.Parameters[paramChg(EmpVisaData.DEPNAME_FIELD)].SourceColumn = EmpVisaData.DEPNAME_FIELD;
			command.Parameters[paramChg(EmpVisaData.POSITION_FIELD)].SourceColumn = EmpVisaData.POSITION_FIELD;
			command.Parameters[paramChg(EmpVisaData.VISANOTE_FIELD)].SourceColumn = EmpVisaData.VISANOTE_FIELD;

			commandAdp.InsertCommand = command;

			commandAdp.Update(empData,EmpVisaData.EMPVISA_TABLE_NAME);

			if(empData.HasErrors)
			{
				empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
				return false;
			}
			else
			{
				empData.AcceptChanges();
				return true;
			}
		}

		public bool DeleteMrVita(int visaID)
		{
			SqlCommand command = new SqlCommand();

			command.CommandText = "DeleteMrVita";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameter param = new SqlParameter(paramChg(EmpVisaData.VISAID_FIELD),SqlDbType.Int);
			param.Value = visaID;
			command.Parameters.Add(param);
			int result =0;
			try
			{
				con.Open();
				result = command.ExecuteNonQuery();
				con.Close();
			}
			catch(Exception ex)
			{
				throw new ApplicationException(ex.ToString());
			}
			return (result>0)?true:false;
		}

		public DataSet GetEmpArcData(int empID)
		{
			SqlCommand command = new SqlCommand();
			command.CommandText = "GetEmpArcInf";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			param.Value = empID;
			command.Parameters.Add(param);

			commandAdp.SelectCommand = command;
			DataSet data = new DataSet();
			try
			{
				commandAdp.Fill(data);
			}
			catch(Exception ex)
			{
				throw new ApplicationException(ex.ToString());
			}
			return data;
		}

		public bool UpdateEmpEduInf(EmpBaseData empData)
		{
			SqlCommand command = new SqlCommand();

			command.CommandText = "UpdateEmpEduInf";
			command.CommandType =  CommandType.StoredProcedure;
			command.Connection = con;

			command.Parameters.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);

			command.Parameters.Add(paramChg(EmpBaseData.SCHOOL1_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpBaseData.SPECIAL1_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpBaseData.GERTIME1_FIELD),SqlDbType.DateTime);
			command.Parameters.Add(paramChg(EmpBaseData.EDUCAT1_FIELD),SqlDbType.VarChar);

			
			command.Parameters.Add(paramChg(EmpBaseData.SCHOOL2_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpBaseData.SPECIAL2_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpBaseData.GERTIME2_FIELD),SqlDbType.DateTime);
			command.Parameters.Add(paramChg(EmpBaseData.EDUCAT2_FIELD),SqlDbType.VarChar);

			command.Parameters.Add(paramChg(EmpBaseData.QULI1_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpBaseData.QULI2_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpBaseData.QULI3_FIELD),SqlDbType.VarChar);
			command.Parameters.Add(paramChg(EmpBaseData.QULI4_FIELD),SqlDbType.VarChar);

			command.Parameters.Add(paramChg(EmpBaseData.EDUNOTE_FIELD),SqlDbType.Text);

			command.Parameters[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;

			command.Parameters[paramChg(EmpBaseData.SCHOOL1_FIELD)].SourceColumn = EmpBaseData.SCHOOL1_FIELD;
			command.Parameters[paramChg(EmpBaseData.SPECIAL1_FIELD)].SourceColumn = EmpBaseData.SPECIAL1_FIELD;
			command.Parameters[paramChg(EmpBaseData.GERTIME1_FIELD)].SourceColumn = EmpBaseData.GERTIME1_FIELD;
			command.Parameters[paramChg(EmpBaseData.EDUCAT1_FIELD)].SourceColumn = EmpBaseData.EDUCAT1_FIELD;

			command.Parameters[paramChg(EmpBaseData.SCHOOL2_FIELD)].SourceColumn = EmpBaseData.SCHOOL2_FIELD;
			command.Parameters[paramChg(EmpBaseData.SPECIAL2_FIELD)].SourceColumn = EmpBaseData.SPECIAL2_FIELD;
			command.Parameters[paramChg(EmpBaseData.GERTIME2_FIELD)].SourceColumn = EmpBaseData.GERTIME2_FIELD;
			command.Parameters[paramChg(EmpBaseData.EDUCAT2_FIELD)].SourceColumn = EmpBaseData.EDUCAT2_FIELD;

			command.Parameters[paramChg(EmpBaseData.QULI1_FIELD)].SourceColumn = EmpBaseData.QULI1_FIELD;
			command.Parameters[paramChg(EmpBaseData.QULI2_FIELD)].SourceColumn = EmpBaseData.QULI2_FIELD;
			command.Parameters[paramChg(EmpBaseData.QULI3_FIELD)].SourceColumn = EmpBaseData.QULI3_FIELD;
			command.Parameters[paramChg(EmpBaseData.QULI4_FIELD)].SourceColumn = EmpBaseData.QULI4_FIELD;

			command.Parameters[paramChg(EmpBaseData.EDUNOTE_FIELD)].SourceColumn = EmpBaseData.EDUNOTE_FIELD;

			commandAdp.UpdateCommand = command;

			commandAdp.Update(empData,EmpBaseData.EMP_TABLE_NAME);

			if(empData.HasErrors)
			{
				empData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
				return false;
			}
			else
			{
				empData.AcceptChanges();
				return true;
			}

		}

		public DataSet GetEmpVisaData_By_VisaID(int visaID)
		{
			SqlCommand command = new SqlCommand();
			command.CommandText = "GetEmpVisaInfByVisaID";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameter param = new SqlParameter(paramChg(EmpVisaData.VISAID_FIELD),SqlDbType.Int);
			param.Value = visaID;
			command.Parameters.Add(param);

			commandAdp.SelectCommand = command;
			DataSet data = new DataSet();
			try
			{
				commandAdp.Fill(data);
			}
			catch(Exception ex)
			{
				throw new ApplicationException(ex.ToString());
			}
			return data;
		}

		public DataSet GetEmpVisaData(int empID)
		{
			SqlCommand command = new SqlCommand();

			command.CommandText = "GetEmpVisaInf";
			command.CommandType =  CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			param.Value = empID;
			command.Parameters.Add(param);

			commandAdp.SelectCommand = command;
			DataSet data = new DataSet();
			try
			{
				commandAdp.Fill(data);
			}
			catch(Exception ex)
			{
				throw new ApplicationException(ex.ToString());
			}
			return data;
		}

		public bool StopEmpLogin(int empID,int allowLogin)
		{
			SqlCommand command = new SqlCommand();

			command.Connection = con;
			command.CommandText = "StopEmpLogin";
			command.CommandType = CommandType.StoredProcedure;

			SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			param.Value = empID;
			command.Parameters.Add(paramChg(EmpBaseData.ALLOWLOGIN_FIELD),SqlDbType.Bit);
			command.Parameters[paramChg(EmpBaseData.ALLOWLOGIN_FIELD)].Value = allowLogin;

			command.Parameters.Add(param);
			try
			{
				con.Open();
				command.ExecuteNonQuery();
				con.Close();
			}
			catch
			{
				return false;
			}
			return true;
		}

		public DataSet GetEmpDataStoped()
		{
			SqlCommand command = new SqlCommand();

			command.Connection = con;
			command.CommandText = "GetEmpInfStoped";
			command.CommandType = CommandType.StoredProcedure;

			commandAdp.SelectCommand = command ;

			DataSet data = new DataSet();
			try
			{
				commandAdp.Fill(data);
			}
			catch(Exception ex)
			{
				throw new ApplicationException(ex.ToString());
			}
			return data;
		}

		public DataSet GetEmpPicData(int empID)
		{
			SqlCommand command = new SqlCommand();
				
			command.CommandText = "GetEmpPic";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			command.Parameters.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			command.Parameters[paramChg(EmpBaseData.EMPID_FIELD)].Value = empID;
			

			commandAdp.SelectCommand = command;

			DataSet data = new DataSet();
			try
			{
				commandAdp.Fill(data);
			}
			catch(Exception ex)
			{
				throw new ApplicationException(ex.ToString());
			}
			return data;
		}

		public void UpdateEmpPic(int empID,byte[] byteArray)
		{
			SqlCommand command = new SqlCommand();
			command.CommandText = "UpdateMrPhoto";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameterCollection param = command.Parameters;

			param.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			param.Add(paramChg(EmpBaseData.PHOTO_SIZE_FIELD),SqlDbType.Int);
			param.Add(paramChg(EmpBaseData.PHOTO_CONTENT_FIELD),SqlDbType.Image);

			param[paramChg(EmpBaseData.EMPID_FIELD)].Value = empID;
			if(byteArray != null)
			{
				param[paramChg(EmpBaseData.PHOTO_SIZE_FIELD)].Value = byteArray.Length;
				param[paramChg(EmpBaseData.PHOTO_CONTENT_FIELD)].Value = byteArray;
			}
			else
			{
				param[paramChg(EmpBaseData.PHOTO_SIZE_FIELD)].Value = DBNull.Value;
				param[paramChg(EmpBaseData.PHOTO_CONTENT_FIELD)].Value = DBNull.Value;
			}
			con.Open();
			command.ExecuteNonQuery();
			con.Close();
			
		}

		public DataSet GetEmpData_By_QueryStr(string branchID,string depID,string empName)
		{
			string queryStr = "select i.EmpID,i.LoginID,i.EmpName,i.Email,i.OfficeTel,i.OfficeFax,i.Mobile,i.PhotoSize,j.DepName,k.SimpleCode from mrBaseInf i,mrDepartment j,mrBranch k where i.AllowLogin = 1 and i.DepID = j.DepID and  k.BranchID = "+branchID ;

			if(empName!=string.Empty)
			{
				queryStr = queryStr + " and " ;
				queryStr = queryStr + " i.EmpName = '"+empName+"'";
			}
			if(depID!=string.Empty)
			{
				queryStr = queryStr + " and ";
				queryStr = queryStr + " i.DepID = "+depID;
			}
			else
			{
				queryStr = queryStr + " and ";
				queryStr = queryStr + " i.DepID in(select DepID from mrDepartment where BranchID = "+branchID+" )";
			}

			SqlCommand command = new SqlCommand();

			command.CommandText = queryStr;
			command.Connection = con;

			commandAdp.SelectCommand = command;

			DataSet data = new DataSet();
			try
			{
				commandAdp.Fill(data);
			}
			catch(Exception ex)
			{
				throw new ApplicationException(ex.ToString());
			}
			return data;
		}

		public DataSet GetEmpBaseData_By_EmpID(int empID)
		{
			SqlCommand command = new SqlCommand();

			command.CommandText = "GetEmpBaseInfByEmpID";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameter param = new SqlParameter(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			param.Value = empID;
			command.Parameters.Add(param);

			commandAdp.SelectCommand = command;

			DataSet data = new DataSet();
			try