📄 infoeditdlg.cpp
字号:
// InfoEditDlg.cpp : implementation file
//
#include "stdafx.h"
#include "Classsystem.h"
#include "InfoEditDlg.h"
#include "Employees.h"
#include "ADOConn.h"
extern CUsers curUser;
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CInfoEditDlg dialog
CInfoEditDlg::CInfoEditDlg(CWnd* pParent /*=NULL*/)
: CDialog(CInfoEditDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CInfoEditDlg)
m_Birth = 0;
m_Grade = _T("");
m_Major = _T("");
m_Memo = _T("");
m_EmpName = _T("");
m_Badge = _T("");
//}}AFX_DATA_INIT
}
void CInfoEditDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CInfoEditDlg)
DDX_Control(pDX, IDC_SEX_COMBO, m_Sex);
DDX_DateTimeCtrl(pDX, IDC_BIRTH, m_Birth);
DDX_Text(pDX, IDC_GRADE_EDIT, m_Grade);
DDV_MaxChars(pDX, m_Grade, 2);
DDX_Text(pDX, IDC_MAJOR_EDIT, m_Major);
DDV_MaxChars(pDX, m_Major, 20);
DDX_Text(pDX, IDC_MEMO_EDIT, m_Memo);
DDX_Text(pDX, IDC_EMPNAME_EDIT, m_EmpName);
DDV_MaxChars(pDX, m_EmpName, 8);
DDX_Text(pDX, IDC_BADGE_EDIT, m_Badge);
DDV_MaxChars(pDX, m_Badge, 6);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CInfoEditDlg, CDialog)
//{{AFX_MSG_MAP(CInfoEditDlg)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CInfoEditDlg message handlers
void CInfoEditDlg::OnOK()
{
// TODO: Add extra validation here
UpdateData(TRUE);
CEmployees emp;
if(m_Badge=="")
{
MessageBeep(0);
MessageBox("请输入学号!");
return;
}
if(m_EmpName=="")
{
MessageBox("请输入姓名!");
return;
}
//将用户输入的数据赋值到对象dep中,为更新数据库做准备
emp.SetEmp_Name(m_EmpName);
int index;
index = m_Sex.GetCurSel();
if (index == 0)
emp.SetSex("男");
else
emp.SetSex("女");
emp.SetBirth(m_Birth.Format("%Y-%m-%d"));
emp.SetId_Card(m_Grade);
emp.SetBadgeId(m_Badge);
//emp.SetDep_Id(DepId);
emp.SetPosition(m_Major);
emp.SetMemo(m_Memo);
if (DepId == 0) //表示插入数据
//判断部门名称是否存在
if (emp.HaveName(m_EmpName) == 1)
{
MessageBox("员工姓名已经存在,请重新输入!");
return;
}
else
//返回插入记录的编号
emp.sql_insert();
else
{
//如果用户修改了部门名称,则判断新部门名称是否存在
if (m_EmpName != EmpName)
{
if (emp.HaveName(m_EmpName) == 1)
{
MessageBox("员工姓名已经存在,请重新输入!");
return;
}
}
//根据DepId的值更新记录
CString cEmpId;
cEmpId=m_Badge;
emp.sql_update(cEmpId);
}
CDialog::OnOK();
}
BOOL CInfoEditDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
//设置性别
if (cSex == "男")
m_Sex.SetCurSel(0);
else
m_Sex.SetCurSel(1);
//如果是添加新员工,则将设置和删除照片的按钮置灰
if (DepId == 0)
GetDlgItem(IDC_MAJOR_EDIT)->EnableWindow(FALSE);
// ReplaceSel(IDC_MAJOR_EDIT)->EnableWindow(FALSE);
else //读取照片图像信息
{
//将当前员工记录读取到m_pRs对象中
CString cEmpId;
cEmpId=EmpId;
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置SELECT语句
_bstr_t vSQL;
vSQL = "SELECT * FROM xs WHERE 学号='" + cEmpId+"'";
//执行SELETE语句
_RecordsetPtr m_pRs;
m_pRs = m_AdoConn.GetRecordSet(vSQL);
}
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -