mrbaseinf.cs

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

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


		public int InsertMrBaseInf(EmpBaseData empBaseData)
		{
			SqlCommand command = new SqlCommand();

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

			SqlParameterCollection param = command.Parameters;

			SqlParameter paramTmp = new SqlParameter("@Identify",SqlDbType.Int);
			paramTmp.Direction = ParameterDirection.ReturnValue;
			param.Add(paramTmp);

			param.Add(paramChg(DepData.DEPID_FIELD),SqlDbType.Int);
			param.Add(paramChg(EmpBaseData.EMPNAME_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.LOGINID_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.PASSWORD_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SEX_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.EMPCODE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.EMAIL_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.OFFICETEL_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.OFFICEFAX_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.MOBILE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.POSITION_FIELD),SqlDbType.VarChar);

			param[paramChg(DepData.DEPID_FIELD)].SourceColumn = DepData.DEPID_FIELD;
			param[paramChg(EmpBaseData.EMPNAME_FIELD)].SourceColumn = EmpBaseData.EMPNAME_FIELD;
			param[paramChg(EmpBaseData.LOGINID_FIELD)].SourceColumn = EmpBaseData.LOGINID_FIELD;
			param[paramChg(EmpBaseData.PASSWORD_FIELD)].SourceColumn = EmpBaseData.PASSWORD_FIELD;
			param[paramChg(EmpBaseData.SEX_FIELD)].SourceColumn = EmpBaseData.SEX_FIELD;
			param[paramChg(EmpBaseData.EMPCODE_FIELD)].SourceColumn = EmpBaseData.EMPCODE_FIELD;
			param[paramChg(EmpBaseData.EMAIL_FIELD)].SourceColumn = EmpBaseData.EMAIL_FIELD;
			param[paramChg(EmpBaseData.OFFICETEL_FIELD)].SourceColumn = EmpBaseData.OFFICETEL_FIELD;
			param[paramChg(EmpBaseData.OFFICEFAX_FIELD)].SourceColumn = EmpBaseData.OFFICEFAX_FIELD;
			param[paramChg(EmpBaseData.MOBILE_FIELD)].SourceColumn = EmpBaseData.MOBILE_FIELD;
			param[paramChg(EmpBaseData.POSITION_FIELD)].SourceColumn = EmpBaseData.POSITION_FIELD;

			commandAdp.InsertCommand = command;
			int result = commandAdp.Update(empBaseData,EmpBaseData.EMP_TABLE_NAME);
			if(result>0)
				return (int)commandAdp.InsertCommand.Parameters["@Identify"].Value;
			else
				return 0;
		}

		public bool UpdateMrBaseInf(EmpBaseData empBaseData)
		{
			SqlCommand command = new SqlCommand();

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

			SqlParameterCollection param = command.Parameters;

			param.Add(paramChg(DepData.DEPID_FIELD),SqlDbType.Int);
			param.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			param.Add(paramChg(EmpBaseData.EMPNAME_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.LOGINID_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SEX_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.EMPCODE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.EMAIL_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.OFFICETEL_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.OFFICEFAX_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.MOBILE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.POSITION_FIELD),SqlDbType.VarChar);

			param[paramChg(DepData.DEPID_FIELD)].SourceColumn = DepData.DEPID_FIELD;
			param[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
			param[paramChg(EmpBaseData.EMPNAME_FIELD)].SourceColumn = EmpBaseData.EMPNAME_FIELD;
			param[paramChg(EmpBaseData.LOGINID_FIELD)].SourceColumn = EmpBaseData.LOGINID_FIELD;
			param[paramChg(EmpBaseData.SEX_FIELD)].SourceColumn = EmpBaseData.SEX_FIELD;
			param[paramChg(EmpBaseData.EMPCODE_FIELD)].SourceColumn = EmpBaseData.EMPCODE_FIELD;
			param[paramChg(EmpBaseData.EMAIL_FIELD)].SourceColumn = EmpBaseData.EMAIL_FIELD;
			param[paramChg(EmpBaseData.OFFICETEL_FIELD)].SourceColumn = EmpBaseData.OFFICETEL_FIELD;
			param[paramChg(EmpBaseData.OFFICEFAX_FIELD)].SourceColumn = EmpBaseData.OFFICEFAX_FIELD;
			param[paramChg(EmpBaseData.MOBILE_FIELD)].SourceColumn = EmpBaseData.MOBILE_FIELD;
			param[paramChg(EmpBaseData.POSITION_FIELD)].SourceColumn = EmpBaseData.POSITION_FIELD;

			commandAdp.UpdateCommand = command;
			commandAdp.Update(empBaseData,EmpBaseData.EMP_TABLE_NAME);
			if(empBaseData.HasErrors)
			{
				empBaseData.Tables[EmpBaseData.EMP_TABLE_NAME].GetErrors()[0].ClearErrors();
				return false;
			}
			else
			{
				empBaseData.AcceptChanges();
				return true;
			}
		}

		public bool UpdateEmpWelInf(EmpBaseData empData)
		{
			SqlCommand command = new SqlCommand();
			
			command.CommandText = "UpdateEmpWelInf";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameterCollection param = command.Parameters;

			param.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			param.Add(paramChg(EmpBaseData.ENTERDATE_FIELD),SqlDbType.DateTime);
			param.Add(paramChg(EmpBaseData.ENTERMODE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.POSILEVL_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SALALEVL_FIELD),SqlDbType.VarChar);

			param.Add(paramChg(EmpBaseData.ENDOFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.HOSPFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.HOUSFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.GRAVFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.UNEMFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.WELNOTE_FIELD),SqlDbType.Text);



			param[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
			param[paramChg(EmpBaseData.ENTERDATE_FIELD)].SourceColumn = EmpBaseData.ENTERDATE_FIELD;
			param[paramChg(EmpBaseData.ENTERMODE_FIELD)].SourceColumn = EmpBaseData.ENTERMODE_FIELD;
			param[paramChg(EmpBaseData.POSILEVL_FIELD)].SourceColumn = EmpBaseData.POSILEVL_FIELD;
			param[paramChg(EmpBaseData.SALALEVL_FIELD)].SourceColumn = EmpBaseData.SALALEVL_FIELD;

			param[paramChg(EmpBaseData.ENDOFLAG_FIELD)].SourceColumn = EmpBaseData.ENDOFLAG_FIELD;
			param[paramChg(EmpBaseData.HOSPFLAG_FIELD)].SourceColumn = EmpBaseData.HOSPFLAG_FIELD;
			param[paramChg(EmpBaseData.HOUSFLAG_FIELD)].SourceColumn = EmpBaseData.HOUSFLAG_FIELD;
			param[paramChg(EmpBaseData.GRAVFLAG_FIELD)].SourceColumn = EmpBaseData.GRAVFLAG_FIELD;
			param[paramChg(EmpBaseData.UNEMFLAG_FIELD)].SourceColumn = EmpBaseData.UNEMFLAG_FIELD;
			param[paramChg(EmpBaseData.WELNOTE_FIELD)].SourceColumn = EmpBaseData.WELNOTE_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 bool UpdateEmpPersInf(EmpBaseData empData)
		{
			SqlCommand command = new SqlCommand();
			
			command.CommandText = "UpdateEmpPersInf";
			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameterCollection param = command.Parameters;

			param.Add(paramChg(EmpBaseData.EMPID_FIELD),SqlDbType.Int);
			param.Add(paramChg(EmpBaseData.PROVINCE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.CITY_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.DISTRICT_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.STREET_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.POSTCODE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.TEL1_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.TEL2_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.BIRTHDAY_FIELD),SqlDbType.DateTime);
			param.Add(paramChg(EmpBaseData.IDCARDNO_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.NAPLACE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.PARTY_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.PERSNOTE_FIELD),SqlDbType.Text);

			param[paramChg(EmpBaseData.EMPID_FIELD)].SourceColumn = EmpBaseData.EMPID_FIELD;
			param[paramChg(EmpBaseData.PROVINCE_FIELD)].SourceColumn = EmpBaseData.PROVINCE_FIELD;
			param[paramChg(EmpBaseData.CITY_FIELD)].SourceColumn = EmpBaseData.CITY_FIELD;
			param[paramChg(EmpBaseData.DISTRICT_FIELD)].SourceColumn = EmpBaseData.DISTRICT_FIELD;
			param[paramChg(EmpBaseData.STREET_FIELD)].SourceColumn = EmpBaseData.STREET_FIELD;
			param[paramChg(EmpBaseData.POSTCODE_FIELD)].SourceColumn = EmpBaseData.POSTCODE_FIELD;
			param[paramChg(EmpBaseData.TEL1_FIELD)].SourceColumn = EmpBaseData.TEL1_FIELD;
			param[paramChg(EmpBaseData.TEL2_FIELD)].SourceColumn = EmpBaseData.TEL2_FIELD;
			param[paramChg(EmpBaseData.BIRTHDAY_FIELD)].SourceColumn = EmpBaseData.BIRTHDAY_FIELD;
			param[paramChg(EmpBaseData.IDCARDNO_FIELD)].SourceColumn = EmpBaseData.IDCARDNO_FIELD;
			param[paramChg(EmpBaseData.NAPLACE_FIELD)].SourceColumn = EmpBaseData.NAPLACE_FIELD;
			param[paramChg(EmpBaseData.PARTY_FIELD)].SourceColumn = EmpBaseData.PARTY_FIELD;
			param[paramChg(EmpBaseData.PERSNOTE_FIELD)].SourceColumn = EmpBaseData.PERSNOTE_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;
			}

		}

		private SqlCommand GetCommand()
		{
			SqlCommand command = new SqlCommand();

			command.CommandType = CommandType.StoredProcedure;
			command.Connection = con;

			SqlParameterCollection param = command.Parameters;


			SqlParameter paramTmp = new SqlParameter("@Identify",SqlDbType.Int);
			paramTmp.Direction = ParameterDirection.ReturnValue;
			param.Add(paramTmp);

			param.Add(paramChg(DepData.DEPID_FIELD),SqlDbType.Int);
			param.Add(paramChg(DepData.BRANCHID_FIELD),SqlDbType.Int);


			param.Add(paramChg(EmpBaseData.EMPNAME_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.LOGINID_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SEX_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.EMPCODE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.EMAIL_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.OFFICETEL_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.OFFICEFAX_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.MOBILE_FIELD),SqlDbType.VarChar);

			param.Add(paramChg(EmpBaseData.PROVINCE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.CITY_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.DISTRICT_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.STREET_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.POSTCODE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.TEL1_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.TEL2_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.BIRTHDAY_FIELD),SqlDbType.DateTime);
			param.Add(paramChg(EmpBaseData.IDCARDNO_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.NAPLACE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.PARTY_FIELD),SqlDbType.VarChar);

			param.Add(paramChg(EmpBaseData.EDUCAT1_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SCHOOL1_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SPECIAL1_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.GERTIME1_FIELD),SqlDbType.DateTime);
			param.Add(paramChg(EmpBaseData.EDUCAT2_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SCHOOL2_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SPECIAL2_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.GERTIME2_FIELD),SqlDbType.DateTime);
			param.Add(paramChg(EmpBaseData.QULI1_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.QULI2_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.QULI3_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.QULI4_FIELD),SqlDbType.VarChar);

			param.Add(paramChg(EmpBaseData.ENTERDATE_FIELD),SqlDbType.DateTime);
			param.Add(paramChg(EmpBaseData.ENTERMODE_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.POSILEVL_FIELD),SqlDbType.VarChar);
			param.Add(paramChg(EmpBaseData.SALALEVL_FIELD),SqlDbType.VarChar);

			param.Add(paramChg(EmpBaseData.ENDOFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.HOSPFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.HOUSFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.GRAVFLAG_FIELD),SqlDbType.Bit);
			param.Add(paramChg(EmpBaseData.UNEMFLAG_FIELD),SqlDbType.Bit);

			param.Add(paramChg(EmpBaseData.WELNOTE_FIELD),SqlDbType.Text);
			param.Add(paramChg(EmpBaseData.PERSNOTE_FIELD),SqlDbType.Text);
			param[paramChg(DepData.DEPID_FIELD)].SourceColumn = DepData.DEPID_FIELD;
			param[paramChg(DepData.BRANCHID_FIELD)].SourceColumn = DepData.BRANCHID_FIELD;



			param[paramChg(EmpBaseData.EMPNAME_FIELD)].SourceColumn = EmpBaseData.EMPNAME_FIELD;
			param[paramChg(EmpBaseData.LOGINID_FIELD)].SourceColumn = EmpBaseData.LOGINID_FIELD;
			param[paramChg(EmpBaseData.SEX_FIELD)].SourceColumn = EmpBaseData.SEX_FIELD;
			param[paramChg(EmpBaseData.EMPCODE_FIELD)].SourceColumn = EmpBaseData.EMPCODE_FIELD;
			param[paramChg(EmpBaseData.EMAIL_FIELD)].SourceColumn = EmpBaseData.EMAIL_FIELD;
			param[paramChg(EmpBaseData.OFFICETEL_FIELD)].SourceColumn = EmpBaseData.OFFICETEL_FIELD;
			param[paramChg(EmpBaseData.OFFICEFAX_FIELD)].SourceColumn = EmpBaseData.OFFICEFAX_FIELD;
			param[paramChg(EmpBaseData.MOBILE_FIELD)].SourceColumn = EmpBaseData.MOBILE_FIELD;

			param[paramChg(EmpBaseData.PROVINCE_FIELD)].SourceColumn = EmpBaseData.PROVINCE_FIELD;
			param[paramChg(EmpBaseData.CITY_FIELD)].SourceColumn = EmpBaseData.CITY_FIELD;
			param[paramChg(EmpBaseData.DISTRICT_FIELD)].SourceColumn = EmpBaseData.DISTRICT_FIELD;
			param[paramChg(EmpBaseData.STREET_FIELD)].SourceColumn = EmpBaseData.STREET_FIELD;
			param[paramChg(EmpBaseData.POSTCODE_FIELD)].SourceColumn = EmpBaseData.POSTCODE_FIELD;
			param[paramChg(EmpBaseData.TEL1_FIELD)].SourceColumn = EmpBaseData.TEL1_FIELD;
			param[paramChg(EmpBaseData.TEL2_FIELD)].SourceColumn = EmpBaseData.TEL2_FIELD;
			param[paramChg(EmpBaseData.BIRTHDAY_FIELD)].SourceColumn = EmpBaseData.BIRTHDAY_FIELD;
			param[paramChg(EmpBaseData.IDCARDNO_FIELD)].SourceColumn = EmpBaseData.IDCARDNO_FIELD;
			param[paramChg(EmpBaseData.NAPLACE_FIELD)].SourceColumn = EmpBaseData.NAPLACE_FIELD;
			param[paramChg(EmpBaseData.PARTY_FIELD)].SourceColumn = EmpBaseData.PARTY_FIELD;

			param[paramChg(EmpBaseData.EDUCAT1_FIELD)].SourceColumn = EmpBaseData.EDUCAT1_FIELD;
			param[paramChg(EmpBaseData.SCHOOL1_FIELD)].SourceColumn = EmpBaseData.SCHOOL1_FIELD;
			param[paramChg(EmpBaseData.SPECIAL1_FIELD)].SourceColumn = EmpBaseData.SPECIAL1_FIELD;
			param[paramChg(EmpBaseData.GERTIME1_FIELD)].SourceColumn = EmpBaseData.GERTIME1_FIELD;
			param[paramChg(EmpBaseData.EDUCAT2_FIELD)].SourceColumn = EmpBaseData.EDUCAT2_FIELD;
			param[paramChg(EmpBaseData.SCHOOL2_FIELD)].SourceColumn = EmpBaseData.SCHOOL2_FIELD;
			param[paramChg(EmpBaseData.SPECIAL2_FIELD)].SourceColumn = EmpBaseData.SPECIAL2_FIELD;
			param[paramChg(EmpBaseData.GERTIME2_FIELD)].SourceColumn = EmpBaseData.GERTIME2_FIELD;
			param[paramChg(EmpBaseData.QULI1_FIELD)].SourceColumn = EmpBaseData.QULI1_FIELD;
			param[paramChg(EmpBaseData.QULI2_FIELD)].SourceColumn = EmpBaseData.QULI2_FIELD;
			param[paramChg(EmpBaseData.QULI3_FIELD)].SourceColumn = EmpBaseData.QULI3_FIELD;
			param[paramChg(EmpBaseData.QULI4_FIELD)].SourceColumn = EmpBaseData.QULI4_FIELD;

			param[paramChg(EmpBaseData.ENTERDATE_FIELD)].SourceColumn = EmpBaseData.ENTERDATE_FIELD;
			param[paramChg(EmpBaseData.ENTERMODE_FIELD)].SourceColumn = EmpBaseData.ENTERMODE_FIELD;
			param[paramChg(EmpBaseData.POSILEVL_FIELD)].SourceColumn = EmpBaseData.POSILEVL_FIELD;
			param[paramChg(EmpBaseData.SALALEVL_FIELD)].SourceColumn = EmpBaseData.SALALEVL_FIELD;

			param[paramChg(EmpBaseData.ENDOFLAG_FIELD)].SourceColumn = EmpBaseData.ENDOFLAG_FIELD;
			param[paramChg(EmpBaseData.HOSPFLAG_FIELD)].SourceColumn = EmpBaseData.HOSPFLAG_FIELD;
			param[paramChg(EmpBaseData.HOUSFLAG_FIELD)].SourceColumn = EmpBaseData.HOUSFLAG_FIELD;
			param[paramChg(EmpBaseData.GRAVFLAG_FIELD)].SourceColumn = EmpBaseData.GRAVFLAG_FIELD;
			param[paramChg(EmpBaseData.UNEMFLAG_FIELD)].SourceColumn = EmpBaseData.UNEMFLAG_FIELD;

			param[paramChg(EmpBaseData.WELNOTE_FIELD)].SourceColumn = EmpBaseData.WELNOTE_FIELD;
			param[paramChg(EmpBaseData.PERSNOTE_FIELD)].SourceColumn = EmpBaseData.PERSNOTE_FIELD;

			return command;

		}

		public void Dispose()
		{
			Dispose(true);
			GC.SuppressFinalize(true);
		}

		protected virtual void Dispose(bool disposing)
		{
				
		}

		public MrBaseInf()
		{
			conStr = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString");
			con = new SqlConnection(conStr);
			commandAdp = new SqlDataAdapter();
		}
	}
}