123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169 |
- // Dlg_CardProPerty.cpp : 实现文件
- //
- #include "stdafx.h"
- #include "StoneU_Door.h"
- #include "Dlg_CardProPerty.h"
- #include ".\dlg_cardproperty.h"
- #include "Global.h"
- #include "DBConnection.h"
- // CDlg_CardProPerty 对话框
- IMPLEMENT_DYNAMIC(CDlg_CardProPerty, CDialog)
- CDlg_CardProPerty::CDlg_CardProPerty(CWnd* pParent /*=NULL*/)
- : CDialog(CDlg_CardProPerty::IDD, pParent)
- , m_sEdit_Name(_T(""))
- , m_sEdit_CardNumber(_T(""))
- , m_sEdit_Class(_T(""))
- , m_sEdit_Remarks(_T(""))
- , m_sEdit_JobNumber(_T(""))
- {
- m_nID = -1;
- }
- CDlg_CardProPerty::~CDlg_CardProPerty()
- {
- }
- void CDlg_CardProPerty::DoDataExchange(CDataExchange* pDX)
- {
- CDialog::DoDataExchange(pDX);
- DDX_Text(pDX, IDC_EDIT_NAME, m_sEdit_Name);
- DDX_Text(pDX, IDC_EDIT_CARDNUMBER, m_sEdit_CardNumber);
- DDX_Text(pDX, IDC_EDIT_CALSS, m_sEdit_Class);
- DDX_Text(pDX, IDC_EDIT_DOOR1NAME, m_sEdit_Remarks);
- DDX_Text(pDX, IDC_EDIT_JOBNUMBER, m_sEdit_JobNumber);
- }
- BEGIN_MESSAGE_MAP(CDlg_CardProPerty, CDialog)
- ON_WM_CTLCOLOR()
- ON_WM_ERASEBKGND()
- ON_BN_CLICKED(IDOK, OnBnClickedOk)
- END_MESSAGE_MAP()
- // CDlg_CardProPerty 消息处理程序
- BOOL CDlg_CardProPerty::OnInitDialog()
- {
- CDialog::OnInitDialog();
- // TODO: 在此添加额外的初始化
- switch( m_nOperate )
- {
- case ADD:
- {
- UpdateData();
- }
- break;
- case EDIT:
- {
- if( ReadCard( m_nID,m_sEdit_Name,m_sEdit_CardNumber,m_sEdit_Class,m_sEdit_JobNumber,m_sEdit_Remarks ) )
- {
- UpdateData( false );
- }
- }
- break;
- }
- return TRUE; // return TRUE unless you set the focus to a control
- // 异常: OCX 属性页应返回 FALSE
- }
- HBRUSH CDlg_CardProPerty::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)
- {
- HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
- // TODO: 在此更改 DC 的任何属性
- // TODO: 如果默认的不是所需画笔,则返回另一个画笔
- return hbr;
- }
- BOOL CDlg_CardProPerty::OnEraseBkgnd(CDC* pDC)
- {
- // TODO: 在此添加消息处理程序代码和/或调用默认值
- return CDialog::OnEraseBkgnd(pDC);
- }
- void CDlg_CardProPerty::OnBnClickedOk()
- {
- UpdateData();
- int nIndex = 0;
-
- switch( m_nOperate )
- {
- case ADD:
- nIndex = InsertCardInfo( (char *)(LPCTSTR)m_sEdit_Name,(char *)(LPCTSTR)m_sEdit_CardNumber,(char *)(LPCTSTR)m_sEdit_Class,(char *)(LPCTSTR)m_sEdit_JobNumber,(char *)(LPCTSTR)m_sEdit_Remarks );
- break;
- case EDIT:
- nIndex = UpdateCardInfo( m_nID,(char *)(LPCTSTR)m_sEdit_Name,(char *)(LPCTSTR)m_sEdit_CardNumber,(char *)(LPCTSTR)m_sEdit_Class,(char *)(LPCTSTR)m_sEdit_JobNumber,(char *)(LPCTSTR)m_sEdit_Remarks );
- break;
- }
- if( nIndex>0 )
- {
- m_nID = nIndex;
- OnOK();
- }
- }
- bool CDlg_CardProPerty::ReadCard( int iID,CString &sName,CString &sCardNumber,CString &sClass,CString &sJobNumber,CString &sRemarks )
- {
- bool bRet = false;
- CHAR strSQLText[MAX_SQL_LENGTH + 1] = "";
- list<string> list1,list2,list3,list4,list5,list6;
- list<string>::iterator it_list1,it_list2,it_list3,it_list4,it_list5,it_list6;
- if(!_stricmp(g_strDBType, "PGSQL"))
- {
- sprintf(strSQLText, "select id, susername, scardnumber,sclass,sjobnumber,sremarks from t_door_card where id=%d",iID );
- }
- else
- {
- sprintf(strSQLText, "select id, susername, scardnumber,sclass,sjobnumber,sremarks from t_door_card where id=%d",iID );
- }
- int nRet = GetFieldValueList6( strSQLText,list1,list2,list3,list4,list5,list6);
- if( 0 == list1.size() || 0 == list2.size() )
- {
- return bRet;
- }
- if( nRet != -1 )
- {
- bRet = true;
- for( it_list1=list1.begin(),it_list2=list2.begin(),it_list3=list3.begin(),
- it_list4=list4.begin(),it_list5=list5.begin(),it_list6=list6.begin();
- it_list1!=list1.end() && it_list2!=list2.end() && it_list3!=list3.end() &&
- it_list4!=list4.end() && it_list5!=list5.end() && it_list6!=list6.end();
- it_list1++,it_list2++,it_list3++,
- it_list4++,it_list5++,it_list6++ )
- {
- sName = (*it_list2).c_str();
- sCardNumber = (*it_list3).c_str();
- sClass = (*it_list4).c_str();
- sJobNumber = (*it_list5).c_str();
- sRemarks = (*it_list6).c_str();
- }
- }
- for( it_list1=list1.begin(),it_list2=list2.begin(),it_list3=list3.begin(),it_list4=list4.begin(),it_list5=list5.begin(),it_list6=list6.begin();
- it_list1!=list1.end(),it_list2!=list2.end(),it_list3!=list3.end(),it_list4!=list4.end(),it_list5!=list5.end(),it_list6!=list6.end();)
- {
- list1.erase(it_list1++);
- list2.erase(it_list2++);
- list3.erase(it_list3++);
- list4.erase(it_list4++);
- list5.erase(it_list5++);
- list6.erase(it_list6++);
- }
- return bRet;
- }
|