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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 交通/航空行业 > 查看源码
ShowAllClientDlg.cpp
资源名称：GPRS-GSM040806.rar　[点击查看]
上传用户：yffx2008
上传日期：2014-10-12
资源大小：12414k
文件大小：12k
源码类别：

交通/航空行业

开发平台：

Visual C++

ShowAllClientDlg.cpp：源码内容
  1. // ShowAllClientDlg.cpp : implementation file
  2. //
  4. #include "stdafx.h"
  5. #include "GpsSC.h"
  6. #include "ShowAllClientDlg.h"
  7. #include "ClientinfoSet.h"
  8. #include "EditclientinfoDlg.h"
  9. #include "MainFrm.h"
  11. #ifdef _DEBUG
  12. #define new DEBUG_NEW
  13. #undef THIS_FILE
  14. static char THIS_FILE[] = __FILE__;
  15. #endif
  17. //extern CGpsSCApp theApp;       // 在此引用应用类中的theApp来获取库连接指针
  18. /////////////////////////////////////////////////////////////////////////////
  19. // CShowAllClientDlg dialog
  22. CShowAllClientDlg::CShowAllClientDlg(CWnd* pParent /*=NULL*/)
  23. : CDialog(CShowAllClientDlg::IDD, pParent)
  24. {
  25. //{{AFX_DATA_INIT(CShowAllClientDlg)
  26. // NOTE: the ClassWizard will add member initialization here
  27. //}}AFX_DATA_INIT
  28. showallinfo = FALSE;
  29. }
  32. void CShowAllClientDlg::DoDataExchange(CDataExchange* pDX)
  33. {
  34. CDialog::DoDataExchange(pDX);
  35. //{{AFX_DATA_MAP(CShowAllClientDlg)
  36. DDX_Control(pDX, IDC_LIST1, m_listctrl);
  37. //}}AFX_DATA_MAP
  38. }
  41. BEGIN_MESSAGE_MAP(CShowAllClientDlg, CDialog)
  42. //{{AFX_MSG_MAP(CShowAllClientDlg)
  43. ON_BN_CLICKED(IDC_DELETECLIENT, OnDeleteclient)
  44. ON_BN_CLICKED(IDC_EDITCLIENT, OnEditclient)
  45. ON_WM_LBUTTONDBLCLK()
  46. ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
  47. ON_WM_CLOSE()
  48. ON_BN_CLICKED(IDC_SHOWALLINFO, OnShowinfo)
  49. //}}AFX_MSG_MAP
  50. END_MESSAGE_MAP()
  52. /////////////////////////////////////////////////////////////////////////////
  53. // CShowAllClientDlg message handlers
  55. BOOL CShowAllClientDlg::OnInitDialog() 
  56. {
  57. CDialog::OnInitDialog();
  59. // TODO: Add extra initialization here
  60. m_listctrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
  62. OnShowpartInfo();
  64. return TRUE;  // return TRUE unless you set the focus to a control
  65.               // EXCEPTION: OCX Property Pages should return FALSE
  66. }
  68. void CShowAllClientDlg::OnDeleteclient() 
  69. {
  70. // TODO: Add your control notification handler code here
  71. CClientinfoSet clientinfoSet;
  73. int nItemIndex = -1;
  74. nItemIndex = m_listctrl . GetNextItem ( nItemIndex, LVNI_SELECTED ) ;
  76. if((m_listctrl.GetNextItem ( -1, LVNI_SELECTED ) ) != -1)
  77. {
  78. if(AfxMessageBox("确定要删除这条记录吗？",1,NULL)==IDOK)
  79. {
  80. try
  81. {
  82. if(!clientinfoSet.IsOpen())
  83. clientinfoSet.Open();
  84. if(!clientinfoSet.IsEOF())
  85. clientinfoSet.MoveFirst();
  86. while(!clientinfoSet.IsEOF())
  87. {
  88. if(clientinfoSet.m_CarPhone==m_listctrl.GetItemText(nItemIndex,0))
  89. {
  90. //更新树状信息
  91. CMainFrame*  mainfrm=(CMainFrame*)AfxGetApp()->m_pMainWnd;
  92. mainfrm->DeleteTreeItem(clientinfoSet.m_CarNumber);
  93. clientinfoSet.Delete();
  94. m_listctrl.DeleteItem(nItemIndex);
  96. AfxMessageBox("删除记录成功！");
  97. break;
  98. }
  99. clientinfoSet.MoveNext();
  100. }
  101. }
  102. catch(CDBException* pEx)
  103. {
  104.          AfxMessageBox(pEx->m_strError);
  105. }
  106. }
  107. }
  108. else
  109. {
  110. AfxMessageBox("请选择一条记录");
  111. return;
  112. }
  113. }
  115. void CShowAllClientDlg::OnEditclient() 
  116. {
  117. // TODO: Add your control notification handler code here
  118. CClientinfoSet clientinfoSet;
  120. int i,nItemIndex = -1;
  121. i=0;
  122. nItemIndex = m_listctrl . GetNextItem ( nItemIndex, LVNI_SELECTED ) ;
  124. if((m_listctrl.GetNextItem ( -1, LVNI_SELECTED ) ) != -1)
  125. {
  126. CEditclientinfoDlg *dlg;
  127. dlg =new CEditclientinfoDlg();
  129. try{
  130. if(!clientinfoSet.IsOpen())
  131. clientinfoSet.Open();
  132. if(!clientinfoSet.IsEOF())
  133. clientinfoSet.MoveFirst();
  134. while(!clientinfoSet.IsEOF())
  135. {
  136. if(clientinfoSet.m_CarPhone==m_listctrl.GetItemText(nItemIndex,0))
  137. {
  138. dlg->m_ClientName         = clientinfoSet.m_ClientName;
  139. dlg->m_ClientAge          = clientinfoSet.m_ClientAge;
  140. dlg->m_ClientUnits        = clientinfoSet.m_ClientUnits;
  141. dlg->m_ClientDuty         = clientinfoSet.m_ClientDuty;
  142. dlg->m_ClientIDcard       = clientinfoSet.m_ClientIDcard;
  143. dlg->m_ClientDrivelicence = clientinfoSet.m_ClientDrivelicence;
  144. dlg->m_ClientPhone        = clientinfoSet.m_ClientPhone;
  145. dlg->m_ClientPassword     = clientinfoSet.m_ClientPassword;
  146. dlg->m_CarNumber          = clientinfoSet.m_CarNumber;
  147. dlg->m_CarType            = clientinfoSet.m_CarType;
  148. dlg->m_CarColor           = clientinfoSet.m_CarColor;
  149. dlg->m_CarEngine          = clientinfoSet.m_CarEngine;
  150. dlg->m_BatholithNo        = clientinfoSet.m_BatholithNo;
  151. dlg->m_CarPhone           = clientinfoSet.m_CarPhone;
  152. break;
  153. }
  154. i++;
  155. clientinfoSet.MoveNext();
  156. }
  157. }
  158. catch(CDBException *Exp)
  159. {
  160. AfxMessageBox(Exp->m_strError);
  161. }
  163. if(dlg->DoModal()==IDOK)
  164. {
  165. try
  166. {
  167. if(!clientinfoSet.IsOpen())
  168. clientinfoSet.Open();
  170. //判断是否车载电话重复（车载电话是关键字）
  171. if(dlg->m_CarPhone!=m_listctrl.GetItemText(nItemIndex,0))
  172. {
  173. if(!clientinfoSet.IsEOF())
  174. clientinfoSet.MoveFirst();
  175. while(!clientinfoSet.IsEOF())
  176. {
  177. if(clientinfoSet.m_CarPhone==dlg->m_CarPhone)
  178. {
  179. AfxMessageBox ( "已存在此车载电话号码!修改失败!" );
  180. return;
  181. }
  182. clientinfoSet.MoveNext();
  183. }
  184. clientinfoSet.MoveFirst();
  185. for(int j=0;j<i;j++)
  186. clientinfoSet.MoveNext();
  187. clientinfoSet.Edit();
  189. clientinfoSet.m_ClientName        =dlg->m_ClientName;
  190. clientinfoSet.m_ClientAge         =dlg->m_ClientAge;
  191. clientinfoSet.m_ClientUnits   =dlg->m_ClientUnits;
  192. clientinfoSet.m_ClientDuty   =dlg->m_ClientDuty;
  193. clientinfoSet.m_ClientIDcard      =dlg->m_ClientIDcard;
  194. clientinfoSet.m_ClientDrivelicence=dlg->m_ClientDrivelicence;
  195. clientinfoSet.m_ClientPhone   =dlg->m_ClientPhone;
  196. clientinfoSet.m_ClientPassword    =dlg->m_ClientPassword;
  197. clientinfoSet.m_CarNumber         =dlg->m_CarNumber;
  198. clientinfoSet.m_CarType   =dlg->m_CarType;
  199. clientinfoSet.m_CarColor   =dlg->m_CarColor;
  200. clientinfoSet.m_CarEngine   =dlg->m_CarEngine;
  201. clientinfoSet.m_BatholithNo   =dlg->m_BatholithNo;
  202. clientinfoSet.m_CarPhone   =dlg->m_CarPhone;
  204. clientinfoSet.Update();
  205. AfxMessageBox ( "修改成功!" );
  206. //更新树状信息
  207. CMainFrame*  mainfrm=(CMainFrame*)AfxGetApp()->m_pMainWnd;
  208. mainfrm->InsertTreeItem();
  209. }
  210. else
  211. {
  212. clientinfoSet.Edit();
  214. clientinfoSet.m_ClientName        =dlg->m_ClientName;
  215. clientinfoSet.m_ClientAge         =dlg->m_ClientAge;
  216. clientinfoSet.m_ClientUnits   =dlg->m_ClientUnits;
  217. clientinfoSet.m_ClientDuty   =dlg->m_ClientDuty;
  218. clientinfoSet.m_ClientIDcard      =dlg->m_ClientIDcard;
  219. clientinfoSet.m_ClientDrivelicence=dlg->m_ClientDrivelicence;
  220. clientinfoSet.m_ClientPhone   =dlg->m_ClientPhone;
  221. clientinfoSet.m_ClientPassword    =dlg->m_ClientPassword;
  222. clientinfoSet.m_CarNumber         =dlg->m_CarNumber;
  223. clientinfoSet.m_CarType   =dlg->m_CarType;
  224. clientinfoSet.m_CarColor   =dlg->m_CarColor;
  225. clientinfoSet.m_CarEngine   =dlg->m_CarEngine;
  226. clientinfoSet.m_BatholithNo   =dlg->m_BatholithNo;
  227. clientinfoSet.m_CarPhone   =dlg->m_CarPhone;
  229. clientinfoSet.Update();
  230. AfxMessageBox ( "修改成功!" );
  231. //更新树状信息
  232. CMainFrame*  mainfrm=(CMainFrame*)AfxGetApp()->m_pMainWnd;
  233. mainfrm->InsertTreeItem();
  234. }
  235. }
  236. catch(CDBException* pEx)
  237. {
  238.          AfxMessageBox(pEx->m_strError);
  239. }
  240. }
  241. delete dlg;
  242. }
  243. else
  244. {
  245. AfxMessageBox("请选择一条记录！");
  246. return;
  247. }
  249. if(showallinfo)
  250.     OnLoadallinfo();
  251. else
  252. OnLoadinfo();
  255. }
  257. void CShowAllClientDlg::OnLoadallinfo()
  258. {
  259. CClientinfoSet clientinfoSet;
  260. m_listctrl.DeleteAllItems();
  262. try
  263. {
  264. if(!clientinfoSet.IsOpen())
  265. clientinfoSet.Open();
  266. if(!clientinfoSet.IsEOF())
  267. clientinfoSet.MoveFirst();
  269. //显示所有信息
  270. while(!clientinfoSet.IsEOF())
  271. {
  272. int m_nItemCount = m_listctrl.GetItemCount();
  274. m_listctrl.InsertItem (m_nItemCount, clientinfoSet .m_CarPhone);
  275. m_listctrl.SetItemText(m_nItemCount,1, clientinfoSet .m_ClientName);
  276.           m_listctrl.SetItemText(m_nItemCount,2, clientinfoSet .m_ClientAge);
  277.          m_listctrl.SetItemText(m_nItemCount,3, clientinfoSet .m_ClientUnits);
  278.          m_listctrl.SetItemText(m_nItemCount,4, clientinfoSet .m_ClientDuty);
  279.           m_listctrl.SetItemText(m_nItemCount,5, clientinfoSet .m_ClientIDcard);
  280.          m_listctrl.SetItemText(m_nItemCount,6, clientinfoSet .m_ClientDrivelicence);
  281.          m_listctrl.SetItemText(m_nItemCount,7, clientinfoSet .m_ClientPhone);
  282.          m_listctrl.SetItemText(m_nItemCount,8, clientinfoSet .m_ClientPassword);
  283.          m_listctrl.SetItemText(m_nItemCount,9, clientinfoSet .m_CarNumber);
  284.          m_listctrl.SetItemText(m_nItemCount,10, clientinfoSet .m_CarType);
  285.          m_listctrl.SetItemText(m_nItemCount,11, clientinfoSet .m_CarColor);
  286.          m_listctrl.SetItemText(m_nItemCount,12, clientinfoSet .m_CarEngine);
  287.         m_listctrl.SetItemText(m_nItemCount,13, clientinfoSet .m_BatholithNo);
  289. clientinfoSet.MoveNext();
  290. }
  291. }
  292. catch(CDBException* pEx)
  293. {
  294. AfxMessageBox(pEx->m_strError);
  295. }
  297. }
  299. void CShowAllClientDlg::OnLButtonDblClk(UINT nFlags, CPoint point) 
  300. {
  301. // TODO: Add your message handler code here and/or call default
  303. CDialog::OnLButtonDblClk(nFlags, point);
  304. }
  306. void CShowAllClientDlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
  307. {
  308. // TODO: Add your control notification handler code here
  309. OnEditclient();
  311. *pResult = 0;
  312. }
  314. void CShowAllClientDlg::OnShowallinfo() 
  315. {
  316. // TODO: Add your control notification handler code here
  317. m_listctrl.DeleteAllItems();
  319. while(m_listctrl.DeleteColumn(0));
  321. m_listctrl.InsertColumn(0,"车载电话号码", LVCFMT_CENTER,100);
  322. m_listctrl.InsertColumn(1," 客户姓名", LVCFMT_CENTER,80);
  323. m_listctrl.InsertColumn(2,"年龄", LVCFMT_CENTER,50);
  324. m_listctrl.InsertColumn(3,"单位", LVCFMT_CENTER,150);
  325. m_listctrl.InsertColumn(4,"职务", LVCFMT_CENTER,100);
  326. m_listctrl.InsertColumn(5,"身份证号码", LVCFMT_CENTER,150);
  327. m_listctrl.InsertColumn(6,"驾驶证号码", LVCFMT_CENTER,120);
  328. m_listctrl.InsertColumn(7,"客户联系电话", LVCFMT_CENTER,100);
  329. m_listctrl.InsertColumn(8,"客户密码", LVCFMT_CENTER,70);
  330. m_listctrl.InsertColumn(9,"车牌号码", LVCFMT_CENTER,80);
  331. m_listctrl.InsertColumn(10,"车辆型号", LVCFMT_CENTER,100);
  332. m_listctrl.InsertColumn(11,"车辆颜色", LVCFMT_CENTER,70);
  333. m_listctrl.InsertColumn(12,"发动机编号", LVCFMT_CENTER,100);
  334. m_listctrl.InsertColumn(13,"底盘编号", LVCFMT_CENTER,100);
  336. OnLoadallinfo();
  337. }
  339. void CShowAllClientDlg::OnLoadinfo()
  340. {
  341. CClientinfoSet clientinfoset;
  342. m_listctrl.DeleteAllItems();
  344. try
  345. {
  346. if(!clientinfoset.IsOpen())
  347. clientinfoset.Open();
  348. if(!clientinfoset.IsEOF())
  349. clientinfoset.MoveFirst();
  351. //隐藏部分信息
  352. while(!clientinfoset.IsEOF())
  353. {
  354. int m_nItemCount = m_listctrl.GetItemCount();
  356. m_listctrl.InsertItem (m_nItemCount, clientinfoset.m_CarPhone);
  357. m_listctrl.SetItemText (m_nItemCount,1,clientinfoset.m_ClientName);
  358.          m_listctrl.SetItemText (m_nItemCount,2,clientinfoset.m_ClientPhone);
  359.          m_listctrl.SetItemText (m_nItemCount,3,clientinfoset.m_CarNumber);
  360. clientinfoset.MoveNext();
  361. }
  362. }
  363. catch(CDBException* pEx)
  364. {
  365. AfxMessageBox(pEx->m_strError);
  366. }
  368. }
  370. void CShowAllClientDlg::OnShowpartInfo()
  371. {
  372. m_listctrl.DeleteAllItems();
  373. while(m_listctrl.DeleteColumn(0));
  375. m_listctrl.InsertColumn(0,"车载电话号码",LVCFMT_CENTER,100);
  376. m_listctrl.InsertColumn(1," 客户姓名",LVCFMT_CENTER,80);
  377. m_listctrl.InsertColumn(2,"客户联系电话",LVCFMT_CENTER,100);
  378. m_listctrl.InsertColumn(3,"车牌号码",LVCFMT_CENTER,80);
  380. OnLoadinfo();
  381. }
  383. void CShowAllClientDlg::OnShowinfo()
  384. {
  385. if(showallinfo==FALSE)
  386. {
  387. OnShowallinfo();
  388. showallinfo = TRUE;
  389. }
  390. else
  391. {
  392. OnShowpartInfo();
  393. showallinfo= FALSE;
  394. }
  395. }
  397. void CShowAllClientDlg::OnClose() 
  398. {
  399. // TODO: Add your message handler code here and/or call default
  400. /* CClientinfoSet clientinfoset;
  401. clientinfoset.Close();*/
  403. CDialog::OnClose();
  404. }