📄 staffrecord.cpp

📁 企业办公管理系统, 企业办公管理系统
💻 CPP
📖 第 1 页 / 共 2 页
字号:
上一页 12
	cwnd_graduateSchool->EnableWindow(true);
	cwnd_major->EnableWindow(true);
	cwnd_identityNO->EnableWindow(true);
	cwnd_mobile->EnableWindow(true);
	cwnd_workType->EnableWindow(true);
	cwnd_remark->EnableWindow(true);
	
	cwnd_add->EnableWindow(false);
	cwnd_cancel->EnableWindow(true);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(true);
	cwnd_exit->EnableWindow(false);

	flag=1;

	UpdateData(false);	
}

void CStaffRecord::OnDelete() 
{
	UpdateData(true);

	CStaff staff;
	staff.sqlDelete(m_staffID);
	Refresh();


	m_staffID = _T("");
	m_staffName = _T("");
	m_duty = _T("");
	m_contractID = _T("");
	m_contractTerm = 0;
	m_department = _T("");
	m_sex = _T("");
	m_address = _T("");
	m_birthday = COleDateTime::GetCurrentTime();
	m_marriageCondition = _T("");
	m_postcode = _T("");
	m_telephone = _T("");
	m_nationality = _T("");
	m_eMail = _T("");
	m_educationLevel = _T("");
	m_QQ = _T("");
	m_graduateSchool = _T("");
	m_major = _T("");
	m_identityNO = _T("");
	m_mobile = _T("");
	m_workType = _T("");
	m_remark = _T("");

	cwnd_list->EnableWindow(true);
	cwnd_staffID->EnableWindow(false);
	cwnd_staffName->EnableWindow(false);
	cwnd_duty->EnableWindow(false);
	cwnd_contractID->EnableWindow(false);
	cwnd_contractTerm->EnableWindow(false);
	cwnd_department->EnableWindow(false);
	cwnd_sex->EnableWindow(false);
	cwnd_address->EnableWindow(false);
	cwnd_birthday->EnableWindow(false);
	cwnd_marriageCondition->EnableWindow(false);
	cwnd_postcode->EnableWindow(false);
	cwnd_telephone->EnableWindow(false);
	cwnd_nationality->EnableWindow(false);
	cwnd_eMail->EnableWindow(false);
	cwnd_educationLevel->EnableWindow(false);
	cwnd_QQ->EnableWindow(false);
	cwnd_graduateSchool->EnableWindow(false);
	cwnd_major->EnableWindow(false);
	cwnd_identityNO->EnableWindow(false);
	cwnd_mobile->EnableWindow(false);
	cwnd_workType->EnableWindow(false);
	cwnd_remark->EnableWindow(false);
	
	cwnd_add->EnableWindow(true);
	cwnd_cancel->EnableWindow(false);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(false);
	cwnd_exit->EnableWindow(true);
	
	UpdateData(false);
}

void CStaffRecord::OnModify() 
{
	
	cwnd_list->EnableWindow(true);
	cwnd_staffID->EnableWindow(false);
	cwnd_staffName->EnableWindow(true);
	cwnd_duty->EnableWindow(true);
	cwnd_contractID->EnableWindow(true);
	cwnd_contractTerm->EnableWindow(true);
	cwnd_department->EnableWindow(true);
	cwnd_sex->EnableWindow(true);
	cwnd_address->EnableWindow(true);
	cwnd_birthday->EnableWindow(true);
	cwnd_marriageCondition->EnableWindow(true);
	cwnd_postcode->EnableWindow(true);
	cwnd_telephone->EnableWindow(true);
	cwnd_nationality->EnableWindow(true);
	cwnd_eMail->EnableWindow(true);
	cwnd_educationLevel->EnableWindow(true);
	cwnd_QQ->EnableWindow(true);
	cwnd_graduateSchool->EnableWindow(true);
	cwnd_major->EnableWindow(true);
	cwnd_identityNO->EnableWindow(true);
	cwnd_mobile->EnableWindow(true);
	cwnd_workType->EnableWindow(true);
	cwnd_remark->EnableWindow(true);
	
	cwnd_add->EnableWindow(false);
	cwnd_cancel->EnableWindow(true);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(true);
	cwnd_exit->EnableWindow(false);

	flag=2;
	
}

void CStaffRecord::OnSave() 
{
	UpdateData(true);

	if(flag==1)
	{
		CStaff staff;
		staff.SetStaffID(m_staffID);  //设定当前记录或者新加记录的员工编号
		staff.SetStaffName(m_staffName);  //设定当前记录或者新加记录的员工姓名
		staff.SetSex(m_sex);  //设定当前记录或者新加记录的性别
		staff.SetBirthday(m_birthday);  //设定当前记录或者新加记录的出生日期
		staff.SetNationality(m_nationality);  //设定当前记录或者新加记录的民族
		staff.SetMarriageCondition(m_marriageCondition);  //设定当前记录或者新加记录的婚姻状况
		staff.SetEducationLevel(m_educationLevel);  //设定当前记录或者新加记录的文化程度
		staff.SetGraduateSchool(m_graduateSchool);  //设定当前记录或者新加记录的毕业院校
		staff.SetTelephone(m_telephone);  //设定当前记录或者新加记录的电话
		staff.SetPostCode(m_postcode);  //设定当前记录或者新加记录的邮编
		staff.SetMobile(m_mobile);  //设定当前记录或者新加记录的手机
		staff.SetQQ(m_QQ);  //设定当前记录或者新加记录的QQ号码
		staff.SetEMail(m_eMail);  //设定当前记录或者新加记录的eMail
		staff.SetDepartment(m_department);  //设定当前记录或者新加记录的部门
		staff.SetDuty(m_duty);  //设定当前记录或者新加记录的职务
		staff.SetAddress(m_address);  //设定当前记录或者新加记录的地址
		staff.SetRemark(m_remark);  //设定当前记录或者新加记录的备注信息
		staff.GetContractID(m_contractID);   //合同编号
		staff.GetContractTerm(m_contractTerm); //合同期限
		staff.GetWorkType(m_workType);     //工种
		staff.GetIdentityNO(m_identityNO);   //身份证号
		staff.GetMajor(m_major);        //专业

		staff.sqlInsert();
	}
	else if(flag==2)
	{
		CStaff staff;
		staff.SetStaffID(m_staffID);  //设定当前记录或者新加记录的员工编号
		staff.SetStaffName(m_staffName);  //设定当前记录或者新加记录的员工姓名
		staff.SetSex(m_sex);  //设定当前记录或者新加记录的性别
		staff.SetBirthday(m_birthday);  //设定当前记录或者新加记录的出生日期
		staff.SetNationality(m_nationality);  //设定当前记录或者新加记录的民族
		staff.SetMarriageCondition(m_marriageCondition);  //设定当前记录或者新加记录的婚姻状况
		staff.SetEducationLevel(m_educationLevel);  //设定当前记录或者新加记录的文化程度
		staff.SetGraduateSchool(m_graduateSchool);  //设定当前记录或者新加记录的毕业院校
		staff.SetTelephone(m_telephone);  //设定当前记录或者新加记录的电话
		staff.SetPostCode(m_postcode);  //设定当前记录或者新加记录的邮编
		staff.SetMobile(m_mobile);  //设定当前记录或者新加记录的手机
		staff.SetQQ(m_QQ);  //设定当前记录或者新加记录的QQ号码
		staff.SetEMail(m_eMail);  //设定当前记录或者新加记录的eMail
		staff.SetDepartment(m_department);  //设定当前记录或者新加记录的部门
		staff.SetDuty(m_duty);  //设定当前记录或者新加记录的职务
		staff.SetAddress(m_address);  //设定当前记录或者新加记录的地址
		staff.SetRemark(m_remark);  //设定当前记录或者新加记录的备注信息
		staff.GetContractID(m_contractID);   //合同编号
		staff.GetContractTerm(m_contractTerm); //合同期限
		staff.GetWorkType(m_workType);     //工种
		staff.GetIdentityNO(m_identityNO);   //身份证号
		staff.GetMajor(m_major);        //专业

		staff.sqlUpdate(m_staffID);
	}
    Refresh();
	cwnd_list->EnableWindow(true);
	cwnd_staffID->EnableWindow(false);
	cwnd_staffName->EnableWindow(false);
	cwnd_duty->EnableWindow(false);
	cwnd_contractID->EnableWindow(false);
	cwnd_contractTerm->EnableWindow(false);
	cwnd_department->EnableWindow(false);
	cwnd_sex->EnableWindow(false);
	
	cwnd_address->EnableWindow(false);
	cwnd_birthday->EnableWindow(false);
	cwnd_marriageCondition->EnableWindow(false);
	cwnd_postcode->EnableWindow(false);
	cwnd_telephone->EnableWindow(false);
	cwnd_nationality->EnableWindow(false);
	cwnd_eMail->EnableWindow(false);
	cwnd_educationLevel->EnableWindow(false);
	cwnd_QQ->EnableWindow(false);
	cwnd_graduateSchool->EnableWindow(false);
	cwnd_major->EnableWindow(false);
	cwnd_identityNO->EnableWindow(false);
	cwnd_mobile->EnableWindow(false);
	cwnd_workType->EnableWindow(false);
	cwnd_remark->EnableWindow(false);
	
	cwnd_add->EnableWindow(true);
	cwnd_cancel->EnableWindow(false);
	cwnd_delete->EnableWindow(true);
	cwnd_modify->EnableWindow(true);
	cwnd_save->EnableWindow(false);
	cwnd_exit->EnableWindow(true);
	
	UpdateData(false);
	
}

void CStaffRecord::OnCancellation() 
{
	m_staffID = _T("");
	m_staffName = _T("");
	m_duty = _T("");
	m_contractID = _T("");
	m_contractTerm = 0;
	m_department = _T("");
	m_sex = _T("");
	m_address = _T("");
	m_birthday = COleDateTime::GetCurrentTime();
	m_marriageCondition = _T("");
	m_postcode = _T("");
	m_telephone = _T("");
	m_nationality = _T("");
	m_eMail = _T("");
	m_educationLevel = _T("");
	m_QQ = _T("");
	m_graduateSchool = _T("");
	m_major = _T("");
	m_identityNO = _T("");
	m_mobile = _T("");
	m_workType = _T("");
	m_remark = _T("");

	cwnd_list->EnableWindow(true);
	cwnd_staffID->EnableWindow(false);
	cwnd_staffName->EnableWindow(false);
	cwnd_duty->EnableWindow(false);
	cwnd_contractID->EnableWindow(false);
	cwnd_contractTerm->EnableWindow(false);
	cwnd_department->EnableWindow(false);
	cwnd_sex->EnableWindow(false);
	cwnd_address->EnableWindow(false);
	cwnd_birthday->EnableWindow(false);
	cwnd_marriageCondition->EnableWindow(false);
	cwnd_postcode->EnableWindow(false);
	cwnd_telephone->EnableWindow(false);
	cwnd_nationality->EnableWindow(false);
	cwnd_eMail->EnableWindow(false);
	cwnd_educationLevel->EnableWindow(false);
	cwnd_QQ->EnableWindow(false);
	cwnd_graduateSchool->EnableWindow(false);
	cwnd_major->EnableWindow(false);
	cwnd_identityNO->EnableWindow(false);
	cwnd_mobile->EnableWindow(false);
	cwnd_workType->EnableWindow(false);
	cwnd_remark->EnableWindow(false);
	
	cwnd_add->EnableWindow(true);
	cwnd_cancel->EnableWindow(false);
	cwnd_delete->EnableWindow(false);
	cwnd_modify->EnableWindow(false);
	cwnd_save->EnableWindow(false);
	cwnd_exit->EnableWindow(true);

	UpdateData(false);
	
}

void CStaffRecord::OnExit() 
{
	this->OnCancel();	
}

void CStaffRecord::Refresh()
{
	m_list.DeleteAllItems();
	_RecordsetPtr m_pRecordset;

	CString strSQL;
	strSQL="select * from staff";
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
	if (SUCCEEDED(hTRes))
	{
		hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
		int i=0;
		
		while(!(m_pRecordset->adoEOF))
		{
			m_list.InsertItem(i,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffID")));
			m_list.SetItemText(i,1,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName")));
			m_list.SetItemText(i,2,((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("duty")));
			
			i++;
			if(!(m_pRecordset->adoEOF))
				m_pRecordset->MoveNext();
		}
	}
}
上一页 12
💿 文件大小 3138 K
👤 上传用户 wzsq12
📂 所属分类企业管理
🏷️ 相关标签

#管理系统
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -