开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 酒店行业 > 查看源码
UserDlg.cpp
资源名称：jdcy.rar　[点击查看]
上传用户：sztwq510
上传日期：2013-06-26
资源大小：4045k
文件大小：13k
源码类别：

酒店行业

开发平台：

Java

UserDlg.cpp：源码内容
  1. // UserDlg.cpp : implementation file
  2. //
  4. #include "stdafx.h"
  5. #include "MyPos.h"
  6. #include "UserDlg.h"
  8. #ifdef _DEBUG
  9. #define new DEBUG_NEW
  10. #undef THIS_FILE
  11. static char THIS_FILE[] = __FILE__;
  12. #endif
  14. /////////////////////////////////////////////////////////////////////////////
  15. // CUserDlg dialog
  16. extern CMyPosApp theApp;
  18. CUserDlg::CUserDlg(CWnd* pParent /*=NULL*/)
  19. : CDialog(CUserDlg::IDD, pParent)
  20. {
  21. //{{AFX_DATA_INIT(CUserDlg)
  22. m_Listuser = _T("");
  23. m_datebirth = _T("");
  24. m_duty = _T("");
  25. m_jiguan = _T("");
  26. m_logname = _T("");
  27. m_username = _T("");
  28. m_number = _T("");
  29. m_upwd = _T("");
  30. m_sex = _T("");
  31. //}}AFX_DATA_INIT
  32. }
  35. void CUserDlg::DoDataExchange(CDataExchange* pDX)
  36. {
  37. CDialog::DoDataExchange(pDX);
  38. //{{AFX_DATA_MAP(CUserDlg)
  39. DDX_Control(pDX, IDC_CHECK1, m_oCheck1);
  40. DDX_Control(pDX, IDC_CHECK2, m_oCheck2);
  41. DDX_Control(pDX, IDC_CHECK3, m_oCheck3);
  42. DDX_Control(pDX, IDC_CHECK4, m_oCheck4);
  43. DDX_Control(pDX, IDC_CHECK5, m_oCheck5);
  44. DDX_Control(pDX, IDC_CHECK6, m_oCheck6);
  45. DDX_Control(pDX, IDC_CHECK7, m_oCheck7);
  46. DDX_Control(pDX, IDC_CHECK8, m_oCheck8);
  47. DDX_Control(pDX, IDC_CHECK9, m_oCheck9);
  48. DDX_Control(pDX, IDC_EDIT_USERID, m_oUserid);
  49. DDX_Control(pDX, IDC_EDIT_DISCOUNT, m_oDiscount);
  50. DDX_Control(pDX, IDC_EDIT_NUMBER, m_oNumber);
  51. DDX_Control(pDX, IDC_EDIT_LOGNAME, m_oLogname);
  52. DDX_Control(pDX, IDC_EDIT_JIGUAN, m_oJiguan);
  53. DDX_Control(pDX, IDC_EDIT_DUTY, m_oDuty);
  54. DDX_Control(pDX, IDC_EDIT_DATEBIRTH, m_oDatebirth);
  55. DDX_Control(pDX, IDC_EDIT_PWD, m_oPwd);
  56. DDX_Control(pDX, IDC_EDIT_USERNAME, m_oUsername);
  57. DDX_Control(pDX, IDC_COMBO_SEX, m_oSex);
  58. DDX_Control(pDX, IDC_LIST_USER, m_oListuser);
  59. DDX_LBString(pDX, IDC_LIST_USER, m_Listuser);
  60. DDX_Text(pDX, IDC_EDIT_DATEBIRTH, m_datebirth);
  61. DDX_Text(pDX, IDC_EDIT_DUTY, m_duty);
  62. DDX_Text(pDX, IDC_EDIT_JIGUAN, m_jiguan);
  63. DDX_Text(pDX, IDC_EDIT_LOGNAME, m_logname);
  64. DDX_Text(pDX, IDC_EDIT_USERNAME, m_username);
  65. DDX_Text(pDX, IDC_EDIT_NUMBER, m_number);
  66. DDX_Text(pDX, IDC_EDIT_PWD, m_upwd);
  67. DDX_CBString(pDX, IDC_COMBO_SEX, m_sex);
  68. //}}AFX_DATA_MAP
  69. }
  72. BEGIN_MESSAGE_MAP(CUserDlg, CDialog)
  73. //{{AFX_MSG_MAP(CUserDlg)
  74. ON_BN_CLICKED(IDC_BUTTON_UADD, OnButtonUadd)
  75. ON_BN_CLICKED(IDC_BUTTON_UDEL, OnButtonUdel)
  76. ON_BN_CLICKED(IDC_BUTTON_USAVE, OnButtonUsave)
  77. ON_LBN_SELCHANGE(IDC_LIST_USER, OnSelchangeListUser)
  78. //}}AFX_MSG_MAP
  79. END_MESSAGE_MAP()
  81. /////////////////////////////////////////////////////////////////////////////
  82. // CUserDlg message handlers
  84. BOOL CUserDlg::OnInitDialog() 
  85. {
  86. CDialog::OnInitDialog();
  88. ReadToListbox();
  90. m_oListuser.SelectString(-1, theApp.name);//设置选中项
  91. OnSelchangeListUser();
  93. return TRUE;  // return TRUE unless you set the focus to a control
  94.               // EXCEPTION: OCX Property Pages should return FALSE
  95. }
  97. void CUserDlg::OnButtonUadd() 
  98. {
  99. //Clear the edit and combobox content.
  100. m_oDatebirth.SetWindowText("");
  101. m_oDuty.SetWindowText("");
  102. m_oJiguan.SetWindowText("");
  103. m_oLogname.SetWindowText("");
  104. m_oUsername.SetWindowText("");
  105. m_oNumber.SetWindowText("");
  106. m_oPwd.SetWindowText("");
  107. m_oDiscount.SetWindowText("");
  108. m_oSex.SetCurSel(0);
  109. m_oCheck1.SetCheck(0);
  110. m_oCheck2.SetCheck(0);
  111. m_oCheck3.SetCheck(0);
  112. m_oCheck4.SetCheck(0);
  113. m_oCheck5.SetCheck(0);
  114. m_oCheck6.SetCheck(0);
  115. m_oCheck7.SetCheck(0);
  116. m_oCheck8.SetCheck(0);
  117. m_oCheck9.SetCheck(0);
  119. lNewID=GenNewID();
  120. // m_oListuser.SetCurSel(-1);
  121. }
  123. void CUserDlg::OnButtonUdel() 
  124. {
  125. CString sql, stemp;
  126. int iOption;
  127. _RecordsetPtr m_pRecordset;
  129. iOption = m_oListuser.GetCurSel();
  130. if(iOption>=0)
  131. {
  132. m_oListuser.GetText(iOption, stemp);//得到选中项的文本
  134. sql="select * from USERS where NAME='"+stemp+"'";
  135. try
  136. { 
  137. m_pRecordset.CreateInstance("ADODB.Recordset");
  138. m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
  140. if(AfxMessageBox("要删除此用户吗？",MB_YESNO)==IDYES)
  141. {
  142. CString slogid=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LOGINID");
  143. if(slogid=="Admin")
  144. {
  145. MessageBox("不能删除系统管理员！");
  146. return;
  147. }
  148. m_pRecordset->Delete(adAffectCurrent);///删除当前记录
  149. m_oListuser.DeleteString(iOption);
  150. OnButtonUadd();//Clear the edit text.
  151. }
  152. else
  153. return;
  154. m_pRecordset->Update();   
  155. }
  156. catch(_com_error e)///捕捉异常
  157. {
  158. CString temp;
  159. temp.Format("删除用户出错:%s",e.ErrorMessage());
  160. AfxMessageBox(temp);
  161. return;
  162. }
  163. }
  164. }
  166. void CUserDlg::OnButtonUsave() 
  167. {
  168. CString sql="select * from USERS";
  169. CString temp,snewid,spower;
  170. CString name,sdiscount;
  171. _RecordsetPtr m_pRecordset;
  173. UpdateData();
  175. //检查数据完整性
  176. if(m_username.IsEmpty()||m_logname.IsEmpty()||m_upwd.IsEmpty())
  177. {
  178. AfxMessageBox("请输入姓名、登录名称和密码！");
  179. return;
  180. }
  181. m_oUsername.GetWindowText(name);//Get the current text in edit.
  183. if(AfxMessageBox("保存修改吗？",MB_YESNO)==IDYES)
  184. {
  185. int sex=m_oSex.GetCurSel();
  186. if(sex==0) m_sex="0";
  187. if(sex==1) m_sex="1";
  189. m_oDiscount.GetWindowText(sdiscount);
  191. if(m_oCheck1.GetCheck()==1)
  192. spower="[Basedoc]";
  193. if(m_oCheck2.GetCheck()==1)
  194. spower=spower+"[Stat]";
  195. if(m_oCheck3.GetCheck()==1)
  196. spower=spower+"[Sysmain]";
  197. if(m_oCheck4.GetCheck()==1)
  198. spower=spower+"[RF]";
  199. if(m_oCheck5.GetCheck()==1)
  200. spower=spower+"[DelBill]";
  201. if(m_oCheck6.GetCheck()==1)
  202. spower=spower+"[CallBill]";
  203. if(m_oCheck7.GetCheck()==1)
  204. spower=spower+"[Deldata]";
  205. if(m_oCheck8.GetCheck()==1)
  206. spower=spower+"[Hang]";
  207. if(m_oCheck9.GetCheck()==1)
  208. spower=spower+"[Recheck]";
  210. if(lNewID>atol(suserid))
  211. {
  212. snewid.Format("%d",lNewID);
  213. if(bRepeat(name)==TRUE)
  214. {
  215. AfxMessageBox("用户名重复，请重新输入!");
  216. return;
  217. }
  218. try
  219. { 
  220. m_pRecordset.CreateInstance("ADODB.Recordset");
  221. m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
  223.    m_pRecordset->AddNew();//insert the current into database.
  224. m_pRecordset->PutCollect("ID",_variant_t(snewid));
  225. m_pRecordset->PutCollect("NAME",_variant_t(m_username));
  226. m_pRecordset->PutCollect("LOGINID",_variant_t(m_logname));
  227. m_pRecordset->PutCollect("PSD",_variant_t(m_upwd));
  228. m_pRecordset->PutCollect("TITLE",_variant_t(m_duty));
  229. m_pRecordset->PutCollect("SEX",_variant_t(m_sex));
  230. m_pRecordset->PutCollect("DATEBIRTH",_variant_t(m_datebirth));
  231. m_pRecordset->PutCollect("HOME",_variant_t(m_jiguan));
  232. m_pRecordset->PutCollect("EMPLOYNUMBER",_variant_t(m_number));
  233. m_pRecordset->PutCollect("DISCOUNT",_variant_t(sdiscount));
  234. m_pRecordset->PutCollect("POWER",_variant_t(spower));
  236. m_pRecordset->Update();//保存到库中    
  238. m_oListuser.AddString(m_username);
  239. m_oListuser.SelectString(-1,m_username);
  241. m_pRecordset->Close();
  242. UpdateData(FALSE);
  243. }
  244. catch(_com_error e)///捕捉异常
  245. {
  246. CString temp;
  247. temp.Format("保存用户资料出错:%s",e.ErrorMessage());
  248. AfxMessageBox(temp);
  249. return;
  250. }
  251. }
  252. else
  253. {
  254. _variant_t RecordsAffected;
  255. if(sdiscount=="")
  256. sdiscount="0";
  257. sql="Update USERS set NAME='"+m_username+
  258. "',LOGINID='"+m_logname+
  259. "',PSD='"+m_upwd+
  260. "',TITLE='"+m_duty+
  261. "',SEX='"+m_sex+
  262. "',DATEBIRTH='"+m_datebirth+
  263. "',HOME='"+m_jiguan+ 
  264. "',EMPLOYNUMBER='"+m_number+
  265. "',DISCOUNT="+sdiscount+
  266. ",POWER='"+spower+"' where ID="+suserid+"";
  267. try
  268. { 
  269. theApp.m_pConnection->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
  270. ReadToListbox();
  271. UpdateData(FALSE);
  272. }
  273. catch(_com_error e)///捕捉异常
  274. {
  275. CString temp;
  276. temp.Format("修改用户资料出错:%s",e.ErrorMessage());
  277. AfxMessageBox(temp);
  278. return;
  279. }
  280. }
  281. }
  282. }
  287. void CUserDlg::OnSelchangeListUser() //Read selected user info into controls.
  288. {
  289. CString stemp,sql,sex,spower;
  290. int iOption; 
  291. _RecordsetPtr m_pRecordset;
  293. m_oCheck1.SetCheck(0);
  294. m_oCheck2.SetCheck(0);
  295. m_oCheck3.SetCheck(0);
  296. m_oCheck4.SetCheck(0);
  297. m_oCheck5.SetCheck(0);
  298. m_oCheck6.SetCheck(0);
  299. m_oCheck7.SetCheck(0);
  300. m_oCheck8.SetCheck(0);
  301. m_oCheck9.SetCheck(0);
  303. iOption = m_oListuser.GetCurSel();
  304. m_oListuser.GetText(iOption, stemp);//得到选中项的文本
  306. sql="select * from USERS where NAME='"+stemp+"'";
  307. try
  308. {
  309. m_pRecordset.CreateInstance("ADODB.Recordset");
  310. m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
  312. lNewID=0;
  313. //Read selected user info into controls.
  314. if(!m_pRecordset->adoEOF)
  315. {
  316. m_oUserid.SetWindowText((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ID"));
  317. m_oUserid.GetWindowText(suserid);
  318. m_oPwd.SetWindowText((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PSD"));
  319. m_oUsername.SetWindowText((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("NAME"));
  320. m_oDuty.SetWindowText((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("TITLE"));
  321. m_oDatebirth.SetWindowText((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DATEBIRTH"));
  322. m_oJiguan.SetWindowText((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("HOME"));
  323. m_oNumber.SetWindowText((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("EMPLOYNUMBER"));
  324. m_oDiscount.SetWindowText((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DISCOUNT"));
  325. CString slogid=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LOGINID");
  326. if(slogid=="Admin")
  327. m_oLogname.SetReadOnly(TRUE);
  328. else
  329. m_oLogname.SetReadOnly(FALSE);
  330. m_oLogname.SetWindowText(slogid);
  332. sex=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("SEX");//Set sex combobox string.
  333. if(sex=="0")
  334. m_oSex.SetCurSel(0);
  335. if(sex=="1")
  336. m_oSex.SetCurSel(1);
  338. spower=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("POWER");
  339. if(spower.Find("Basedoc")>0)
  340. m_oCheck1.SetCheck(1);
  341. if(spower.Find("Stat")>0)
  342. m_oCheck2.SetCheck(1);
  343. if(spower.Find("Sysmain")>0)
  344. m_oCheck3.SetCheck(1);
  345. if(spower.Find("RF")>0)
  346. m_oCheck4.SetCheck(1);
  347. if(spower.Find("DelBill")>0)
  348. m_oCheck5.SetCheck(1);
  349. if(spower.Find("CallBill")>0)
  350. m_oCheck6.SetCheck(1);
  351. if(spower.Find("Deldata")>0)
  352. m_oCheck7.SetCheck(1);
  353. if(spower.Find("Hang")>0)
  354. m_oCheck8.SetCheck(1);
  355. if(spower.Find("Recheck")>0)
  356. m_oCheck9.SetCheck(1);
  357. }
  358. m_pRecordset->Close();
  359. }
  360. catch(_com_error e)///捕捉异常
  361. {
  362. CString temp;
  363. temp.Format("显示用户信息出错:%s",e.ErrorMessage());
  364. AfxMessageBox(temp);
  365. return;
  366. }
  367. }
  369. long CUserDlg::GenNewID()
  370. {
  371. CString sql;
  372. long NewID;
  373. _RecordsetPtr m_pRecordset; //Must define it in function!!!!
  375. sql="SELECT Max(ID) FROM USERS";
  376. try
  377. { 
  378. m_pRecordset.CreateInstance("ADODB.Recordset");
  379. m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
  381. _variant_t vIndex = (long)0;//How to get field value in only 1 record and 1 field condition.
  382. _variant_t vtemp = m_pRecordset->GetCollect(vIndex);
  383. if(vtemp.lVal>0) 
  384. NewID =(long)(m_pRecordset->GetCollect(vIndex))+1;///取得第一个字段的值(MAX ID)加1后放入id变量.
  385. else
  386. NewID=1;
  387. m_pRecordset->Close();
  388. }
  389. catch(_com_error e)///捕捉异常
  390. {
  391. CString stemp;
  392. stemp.Format("获得ID最大值出错:%s",e.ErrorMessage());
  393. AfxMessageBox(stemp);
  394. }
  395. return NewID;
  396. }
  398. BOOL CUserDlg::bRepeat(CString strFieldValue)
  399. {
  400. CString sql;
  401. BOOL br;
  402. _RecordsetPtr m_pRecordset; //Must define it in function!!!!
  404. sql="SELECT * FROM USERS WHERE NAME='";
  405. sql=sql+strFieldValue+"'";
  406. try
  407. { 
  408. m_pRecordset.CreateInstance("ADODB.Recordset");
  409. m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
  411. if(m_pRecordset->adoEOF)
  412. br=FALSE;
  413. if(!m_pRecordset->adoEOF)
  414. br=TRUE;
  415. m_pRecordset->Close();
  416. }
  417. catch(_com_error e)///捕捉异常
  418. {
  419. CString stemp;
  420. stemp.Format("查找用户名出错:%s",e.ErrorMessage());
  421. AfxMessageBox(stemp);
  422. }
  423. return br;
  424. }
  427. void CUserDlg::ReadToListbox()
  428. {
  429. _RecordsetPtr m_pRecordset;
  431. //Read user name from database into listbox。
  432. m_oListuser.ResetContent();
  433. CString sql="select * from USERS";
  434. try
  435. {
  436. m_pRecordset.CreateInstance("ADODB.Recordset");
  437. m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
  438. while(!m_pRecordset->adoEOF)
  439. {
  440. m_oListuser.AddString((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("NAME"));
  441. m_pRecordset->MoveNext();
  442. }
  443. m_pRecordset->Close();
  444. }
  445. catch(_com_error e)///捕捉异常
  446. {
  447. CString temp;
  448. temp.Format("列表框读取用户名出错:%s",e.ErrorMessage());
  449. AfxMessageBox(temp);
  450. }
  451. }