DinDanFrom.cpp 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770
  1. // DinDanFrom.cpp : implementation file
  2. //
  3. #include "stdafx.h"
  4. #include "LYFZIPManage.h"
  5. #include "DinDanFrom.h"
  6. #include "MyMdi.h"
  7. #include "ModifyDinDan.h"
  8. #include "InputPsw.h"
  9. #include "ClientDlg.h"
  10. #include "TakeMoney2.h"
  11. #include "./helper/ffsco.h"
  12. #ifdef _DEBUG
  13. #define new DEBUG_NEW
  14. #undef THIS_FILE
  15. static char THIS_FILE[] = __FILE__;
  16. #endif
  17. #pragma comment(lib, "Shlwapi.lib")
  18. /////////////////////////////////////////////////////////////////////////////
  19. // DinDanFrom
  20. IMPLEMENT_DYNCREATE(DinDanFrom, CFormView)
  21. DinDanFrom::DinDanFrom()
  22. : CFormView(DinDanFrom::IDD)
  23. {
  24. //{{AFX_DATA_INIT(DinDanFrom)
  25. m_filter = _T("");
  26. //}}AFX_DATA_INIT
  27. }
  28. DinDanFrom::~DinDanFrom()
  29. {
  30. }
  31. void DinDanFrom::DoDataExchange(CDataExchange* pDX)
  32. {
  33. CFormView::DoDataExchange(pDX);
  34. //{{AFX_DATA_MAP(DinDanFrom)
  35. DDX_Control(pDX, IDC_COMBO5, m_combodatetime);
  36. DDX_Control(pDX, IDC_COMBO1, m_combo1);
  37. DDX_Control(pDX, IDC_LIST2, m_List1);
  38. DDX_Control(pDX, IDC_STATIC1, m_static1);
  39. DDX_CBString(pDX, IDC_COMBO1, m_filter);
  40. //}}AFX_DATA_MAP
  41. }
  42. BEGIN_MESSAGE_MAP(DinDanFrom, CFormView)
  43. //{{AFX_MSG_MAP(DinDanFrom)
  44. ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
  45. ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
  46. ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
  47. ON_WM_TIMER()
  48. ON_BN_CLICKED(IDC_BUTmodify2, OnBUTmodify2)
  49. ON_BN_CLICKED(IDC_BUTmodify3, OnBUTmodify3)
  50. ON_BN_CLICKED(IDC_BUTmodify4, OnBUTmodify4)
  51. ON_BN_CLICKED(IDC_BUTmodify, OnBUTmodify)
  52. ON_BN_CLICKED(IDC_BUTprint, OnBUTprint)
  53. ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
  54. ON_BN_CLICKED(IDC_BUTclient, OnBUTclient)
  55. ON_BN_CLICKED(IDC_BUTmoney, OnBUTmoney)
  56. //}}AFX_MSG_MAP
  57. END_MESSAGE_MAP()
  58. /////////////////////////////////////////////////////////////////////////////
  59. // DinDanFrom diagnostics
  60. #ifdef _DEBUG
  61. void DinDanFrom::AssertValid() const
  62. {
  63. CFormView::AssertValid();
  64. }
  65. void DinDanFrom::Dump(CDumpContext& dc) const
  66. {
  67. CFormView::Dump(dc);
  68. }
  69. #endif //_DEBUG
  70. /////////////////////////////////////////////////////////////////////////////
  71. // DinDanFrom message handlers
  72. void DinDanFrom::OnInitialUpdate()
  73. {
  74. CFormView::OnInitialUpdate();
  75. // TODO: Add your specialized code here and/or call the base class
  76. CMyMdi Mdi;
  77. Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);
  78. // Here we create the outbar control using the splitter as its parent
  79. // and setting its id to the first pane.
  80. CRect rc2;
  81. GetWindowRect(rc2);
  82. ::MoveWindow(m_hWnd,g_rc.left,g_rc.top,g_rc.Width(),g_rc.Height(),TRUE);
  83. EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc,0);
  84. m_static1.SetFont (&g_titlefont);
  85. m_List1.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;拍照,100;初修,100;选片,100;精修,100;设计,100;取件,100;预约时间,100;拍照时间,100;选片时间,100;取件时间,100;接单人,100;套系名称,100;套系价格,100;摄影师,100;化妆师,100;初修,100;选片,100;精修,100;设计师,100;录单,100;男宾电话,100;女宾电话,100" );
  86. m_List1.LoadColumnInfo (109);
  87. if(g_bShowOK==0)
  88. {
  89. CString filter="status3='未取'";
  90. g_sendhead.bsql=0;
  91. g_sendhead.code[0]=21;
  92. g_sendhead.tabcount=1;
  93. g_pMainWnd->ProcessChatMessageRequest2(filter);if(g_bSendOK==0)return;
  94. }
  95. else
  96. {
  97. g_sendhead.bsql=0;
  98. g_sendhead.code[0]=21;
  99. g_sendhead.tabcount=1;
  100. g_pMainWnd->ProcessChatMessageRequest2(21);if(g_bSendOK==0)return;
  101. }
  102. DataToArray(&m_List1array);
  103. m_combo1.AddString (g_user.name);
  104. for(int i=0; i<g_userarray.GetSize (); i++)
  105. {
  106. m_combo1.AddString (g_userarray.ElementAt (i).ElementAt (1) );
  107. }
  108. FillGrid();
  109. m_combo1.GetWindowRect (rc2);
  110. ScreenToClient(rc2);
  111. rc2.bottom +=200;
  112. m_combo1.MoveWindow (rc2);
  113. m_combodatetime.GetWindowRect (rc2);
  114. ScreenToClient(rc2);
  115. rc2.bottom +=400;
  116. m_combodatetime.MoveWindow (rc2);
  117. GetDlgItem(IDC_BUTprint)->EnableWindow(IsHasRights2new(3));
  118. GetDlgItem(IDC_BUTclient)->EnableWindow(IsHasRights2new(1));
  119. }
  120. void DinDanFrom::FillGrid()
  121. {
  122. m_List1.DeleteAllItems2 ();
  123. int ii=0;
  124. m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
  125. int count=0;
  126. if(m_filter.IsEmpty ())
  127. {
  128. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  129. {
  130. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  131. }
  132. }
  133. else
  134. {
  135. int type=GetType(m_filter);
  136. if(type==1)//电话
  137. {
  138. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  139. {
  140. if(m_List1array.ElementAt (ii).ElementAt (23).Find (m_filter)!=-1 || \
  141. m_List1array.ElementAt (ii).ElementAt (24).Find (m_filter)!=-1)
  142. {
  143. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  144. }
  145. }
  146. }
  147. else if(type==2)//拼音
  148. {
  149. m_filter.MakeUpper ();
  150. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  151. {
  152. if(m_List1array.ElementAt (ii).ElementAt (25).Find (m_filter)!=-1 || \
  153. m_List1array.ElementAt (ii).ElementAt (26).Find (m_filter)!=-1)
  154. {
  155. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  156. }
  157. }
  158. }
  159. else
  160. {
  161. for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
  162. {
  163. if(m_List1array.ElementAt (ii).ElementAt (0).Find (m_filter)!=-1 || \
  164. m_List1array.ElementAt (ii).ElementAt (1).Find (m_filter)!=-1 || \
  165. m_List1array.ElementAt (ii).ElementAt (2).Find (m_filter)!=-1 || \
  166. m_List1array.ElementAt (ii).ElementAt (13).Find (m_filter)!=-1 || \
  167. m_List1array.ElementAt (ii).ElementAt (23).Find (m_filter)!=-1 || \
  168. m_List1array.ElementAt (ii).ElementAt (24).Find (m_filter)!=-1 ||\
  169. m_List1array.ElementAt (ii).ElementAt (25).Find (m_filter)!=-1 || \
  170. m_List1array.ElementAt (ii).ElementAt (26).Find (m_filter)!=-1)
  171. {
  172. m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
  173. }
  174. }
  175. }
  176. }
  177. m_List1.m_arLabels.SetSize(count, 1);
  178. ii=count;
  179. m_List1.m_LabelCount=ii;
  180. m_List1.SetItemCountEx (ii);
  181. CString str;
  182. str.Format ("单数:%d", ii);
  183. SetDlgItemText(IDC_STATIC2, str);
  184. }
  185. void DinDanFrom::OnBUTclose()
  186. {
  187. // TODO: Add your control notification handler code here
  188. GetParent()->SendMessage(WM_CLOSE);
  189. }
  190. void DinDanFrom::OnButton1()
  191. {
  192. // TODO: Add your control notification handler code here
  193. UpdateData();
  194. m_filter.TrimLeft ();
  195. m_filter.TrimRight ();
  196. FillGrid();
  197. }
  198. void DinDanFrom::OnSelchangeCombo1()
  199. {
  200. // TODO: Add your control notification handler code here
  201. SetTimer(1, 100, NULL);
  202. }
  203. void DinDanFrom::OnTimer(UINT nIDEvent)
  204. {
  205. // TODO: Add your message handler code here and/or call default
  206. KillTimer(nIDEvent);
  207. OnButton1();
  208. }
  209. void DinDanFrom::OnBUTmodify2()
  210. {
  211. }
  212. void DinDanFrom::OnBUTmodify3()
  213. {
  214. POSITION pos;
  215. pos=m_List1.GetFirstSelectedItemPosition();
  216. if(pos==NULL)
  217. {
  218. return;
  219. }
  220. int iItem=m_List1.GetNextSelectedItem(pos);
  221. g_pMainWnd->PrintDinDan(m_List1.GetItemText (iItem, 0));
  222. }
  223. void DinDanFrom::OnBUTmodify4()
  224. {
  225. /* if(IsHasRights2new(3)==0)return;
  226. POSITION pos;
  227. pos=m_List1.GetFirstSelectedItemPosition();
  228. while(pos)
  229. {
  230. int iItem=m_List1.GetNextSelectedItem(pos);
  231. CString id = m_List1.GetItemText (iItem, 0);
  232. CString sql;
  233. sql= "delete from dindan where id='"+id+"'";
  234. g_sendhead.bsql=1;
  235. g_pMainWnd->ProcessChatMessageRequest2(sql);
  236. sql= "delete from dindansp where id='"+id+"'";
  237. g_sendhead.bsql=1;
  238. g_pMainWnd->ProcessChatMessageRequest2(sql);
  239. sql= "delete from photoprint where id='"+id+"'";
  240. g_sendhead.bsql=1;
  241. g_pMainWnd->ProcessChatMessageRequest2(sql);
  242. sql= "delete from dindanbukuan where id='"+id+"'";
  243. g_sendhead.bsql=1;
  244. g_pMainWnd->ProcessChatMessageRequest2(sql);
  245. sql= "delete from dindanbukuan2 where id='"+id+"'";
  246. g_sendhead.bsql=1;
  247. g_pMainWnd->ProcessChatMessageRequest2(sql);
  248. sql= "delete from client where id='"+id+"'";
  249. sql+=DINDAN_REF;
  250. CString ref1= SGLIN_REF;
  251. CString ref2= BUKUAN_REF;
  252. CString ref3= BUKUAN_REF2;
  253. ref3+=";50;55;56";
  254. ref1.Replace ("@@@",";");
  255. sql+=";";
  256. sql+=ref1;
  257. sql+=";";
  258. sql+=ref2;
  259. sql+=";";
  260. sql+=ref3;
  261. g_sendhead.bsql=1;
  262. g_pMainWnd->ProcessChatMessageRequest2(sql);
  263. }
  264. */
  265. }
  266. BOOL DinDanFrom::PreTranslateMessage(MSG* pMsg)
  267. {
  268. // TODO: Add your specialized code here and/or call the base class
  269. try
  270. {
  271. if(pMsg->message==WM_KEYDOWN)
  272. {
  273. switch (pMsg->wParam)
  274. {
  275. case VK_RETURN:
  276. OnButton1();
  277. return 1;
  278. case VK_F9:
  279. GetClientPhone();
  280. return 1;
  281. case 0x43: // copy
  282. if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
  283. {
  284. GetFocus()->SendMessage(WM_COPY);
  285. return TRUE;
  286. }
  287. break;
  288. case 0x56: //Ctrl + V:
  289. if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
  290. {
  291. GetFocus()->SendMessage(WM_PASTE);
  292. return TRUE;
  293. }
  294. break;
  295. case 0x58: // cut
  296. if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
  297. {
  298. GetFocus()->SendMessage(WM_CUT);
  299. return TRUE;
  300. }
  301. break;
  302. case 0x5A: //undo
  303. case 0x59: //redo
  304. if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
  305. {
  306. GetFocus()->SendMessage(WM_UNDO);
  307. return TRUE;
  308. }
  309. break;
  310. }
  311. }
  312. return CFormView::PreTranslateMessage(pMsg);
  313. }
  314. catch(...)
  315. {
  316. }
  317. }
  318. void DinDanFrom::OnBUTprint()
  319. {
  320. // TODO: Add your control notification handler code here
  321. if(IsHasRights2new(3)==0)return;
  322. POSITION pos;
  323. pos=m_List1.GetFirstSelectedItemPosition();
  324. if(pos==NULL)
  325. {
  326. return;
  327. }
  328. int iItem=m_List1.GetNextSelectedItem(pos);
  329. if(AfxMessageBox("警告! 此单相关资料将全部被删除? 确定吗?", MB_YESNO|MB_ICONSTOP)!=IDYES)return;
  330. CString id = m_List1.GetItemText (iItem, 0);
  331. CString sql;
  332. sql= "delete from dindan where id='"+id+"'";
  333. g_sendhead.bsql=1;
  334. g_pMainWnd->ProcessChatMessageRequest2(sql);
  335. sql= "delete from dindansp where id='"+id+"'";
  336. g_sendhead.bsql=1;
  337. g_pMainWnd->ProcessChatMessageRequest2(sql);
  338. sql= "delete from photoprint where id='"+id+"'";
  339. g_sendhead.bsql=1;
  340. g_pMainWnd->ProcessChatMessageRequest2(sql);
  341. sql= "delete from dindanbukuan where id='"+id+"'";
  342. g_sendhead.bsql=1;
  343. g_pMainWnd->ProcessChatMessageRequest2(sql);
  344. sql= "delete from dindanbukuan2 where id='"+id+"'";
  345. g_sendhead.bsql=1;
  346. g_pMainWnd->ProcessChatMessageRequest2(sql);
  347. sql= "delete from client where id='"+id+"'";
  348. sql+=DINDAN_REF;
  349. CString ref1= SGLIN_REF;
  350. CString ref2= BUKUAN_REF;
  351. CString ref3= BUKUAN_REF2;
  352. ref3+=";50;55;56";
  353. ref1.Replace ("@@@",";");
  354. sql+=";";
  355. sql+=ref1;
  356. sql+=";";
  357. sql+=ref2;
  358. sql+=";";
  359. sql+=ref3;
  360. g_sendhead.bsql=1;
  361. g_pMainWnd->ProcessChatMessageRequest2(sql);
  362. g_sendhead.bsql=0;
  363. g_sendhead.code[0]=21;
  364. g_sendhead.tabcount=1;
  365. g_pMainWnd->ProcessChatMessageRequest2(21);if(g_bSendOK==0)return;
  366. DataToArray(&m_List1array);
  367. FillGrid();
  368. }
  369. void DinDanFrom::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult)
  370. {
  371. // TODO: Add your control notification handler code here
  372. OnBUTmodify();
  373. *pResult = 0;
  374. }
  375. void DinDanFrom::OnBUTclient()
  376. {
  377. // TODO: Add your control notification handler code here
  378. POSITION pos;
  379. pos=m_List1.GetFirstSelectedItemPosition();
  380. if(pos==NULL)
  381. {
  382. return;
  383. }
  384. int iItem=m_List1.GetNextSelectedItem(pos);
  385. CClientDlg dlg;
  386. dlg.id=m_List1.GetItemText (iItem, 0);
  387. dlg.m_name1=m_List1.GetItemText (iItem, 1);
  388. dlg.m_name2=m_List1.GetItemText (iItem, 2);
  389. if(dlg.DoModal ()!=IDOK)return;
  390. for(int i=0; i<m_List1array.GetSize (); i++)
  391. {
  392. if(dlg.id==m_List1array.ElementAt (i).ElementAt (0))
  393. {
  394. m_List1array.ElementAt (i).SetAt (1, dlg.m_name1 );
  395. m_List1array.ElementAt (i).SetAt (2, dlg.m_name2 );
  396. FillGrid();
  397. break;
  398. }
  399. }
  400. }
  401. extern void LoadImageFromFile(Image **img, CString path);
  402. void DinDanFrom::OnBUTmoney()
  403. {
  404. CStringArray array;
  405. CString despath="D:\\20091128-005原";
  406. using namespace helper_coffs;
  407. ffsco o;
  408. o.dirs(0);
  409. o.find(LPCSTR(despath), LPCSTR("*.jpg"));
  410. ffsco::typeT coo;
  411. ffsco::typeT::iterator it;
  412. coo = o.co_file();
  413. for (it = coo.begin();
  414. coo.end() != it;
  415. it ++)
  416. {
  417. m_combodatetime.AddString ((*it).c_str());
  418. }
  419. for(int i=0; i<m_combodatetime.GetCount (); i++)
  420. {
  421. CString temp,temp2;
  422. m_combodatetime.GetLBText (i, temp);
  423. temp2.Format ("%s\\temp%03d.jpg", despath, i+1);
  424. ::rename (temp, temp2);
  425. }
  426. for(i=0; i<m_combodatetime.GetCount (); i++)
  427. {
  428. CString temp,temp2;
  429. temp.Format ("%s\\%03d.jpg", despath, i+1);
  430. temp2.Format ("%s\\temp%03d.jpg", despath, i+1);
  431. ::rename (temp2, temp);
  432. }
  433. }
  434. void FillLength(CString &str, int length)
  435. {
  436. while(str.GetLength ()<length)
  437. str+=" ";
  438. }
  439. void DinDanFrom::GetClientPhone()
  440. {//return;
  441. CStdioFile fp;
  442. if(::PathFileExists ("c:\\clientphone.txt"))
  443. {
  444. fp.Open ("c:\\clientphone.txt", CFile::modeWrite);
  445. fp.SeekToEnd ();
  446. }
  447. else
  448. fp.Open ("c:\\clientphone.txt", CFile::modeCreate|CFile::modeWrite);
  449. CString str;
  450. CString name,m_name1,m_name2;
  451. CString phone,m_phone1,m_phone2;
  452. CString txname,txprice;
  453. int leng1=20;
  454. int leng2=30;
  455. int leng3=20;
  456. int leng4=20;
  457. name="姓名";
  458. phone="电话";
  459. txname="套系";
  460. txprice="价格";
  461. FillLength(name, leng1);
  462. FillLength(phone, leng2);
  463. FillLength(txname, leng3);
  464. FillLength(txprice,leng4);
  465. str=name+phone+txname+txprice+"\r\n";
  466. // fp.WriteString (str);
  467. for(int i=0; i<m_List1.GetItemCount (); i++)
  468. {
  469. // if(atof(m_List1.GetItemText (i, 15))<600)continue;
  470. name.Empty ();
  471. phone.Empty ();
  472. m_name1=m_List1.GetItemText (i, 1);
  473. m_name2=m_List1.GetItemText (i, 2);
  474. m_phone1=m_List1.GetItemText (i, 23);
  475. m_phone2=m_List1.GetItemText (i, 24);
  476. txname=m_List1.GetItemText (i, 14);
  477. txprice=m_List1.GetItemText (i, 15);
  478. if(!m_name1.IsEmpty ())
  479. name=m_name1+",";
  480. name+=m_name2;
  481. name.TrimRight (",");
  482. if(!m_phone1.IsEmpty ())
  483. phone=m_phone1+",";
  484. phone+=m_phone2;phone.TrimRight (",");
  485. FillLength(name, leng1);
  486. FillLength(phone, leng2);
  487. FillLength(txname, leng3);
  488. FillLength(txprice,leng4);
  489. str=name+phone+txname+txprice+"\r\n";
  490. // fp.WriteString (str);
  491. if(!m_phone1.IsEmpty())
  492. fp.WriteString (m_phone1+"\r\n");
  493. if(!m_phone2.IsEmpty())
  494. fp.WriteString (m_phone2+"\r\n");
  495. }
  496. fp.Close ();
  497. MessageBox("电话已保存到c:\\clientphone.txt");
  498. }
  499. void DinDanFrom::OnBUTmodify()
  500. {
  501. /* //关闭服务器
  502. g_nSendCode=100;
  503. g_pMainWnd->ProcessChatMessageRequest2(1);
  504. g_nSendCode=0;
  505. */
  506. /*
  507. CString sql;
  508. CString oldname="鲁小梅";
  509. CString newname="小鲁";
  510. sql="update user set name='"+newname+"' where name='"+oldname+"'";
  511. sql+="***update renyuan set name='"+newname+"' where name='"+oldname+"'";
  512. sql+="***update dindanbukuan set ren='"+newname+"' where ren='"+oldname+"'";
  513. sql+="***update dindanbukuan2 set ren='"+newname+"' where ren='"+oldname+"'";
  514. sql+="***update dindanbukuan set ren2='"+newname+"' where ren2='"+oldname+"'";
  515. sql+="***update dindanbukuan2 set ren2='"+newname+"' where ren2='"+oldname+"'";
  516. sql+="***update gudingfeiyong set renyuan1='"+newname+"' where renyuan1='"+oldname+"'";
  517. sql+="***update gudingfeiyong set renyuan2='"+newname+"' where renyuan2='"+oldname+"'";
  518. sql+="***update singleincome set renyuan1='"+newname+"' where renyuan1='"+oldname+"'";
  519. sql+="***update singleincome set renyuan2='"+newname+"' where renyuan2='"+oldname+"'";
  520. sql+="***update dindan set ren='"+newname+"' where ren='"+oldname+"'";
  521. g_sendhead.bsql=1;
  522. g_pMainWnd->ProcessChatMessageRequest2(sql);
  523. sql="update dindan set waiter1='"+newname+"' where waiter1='"+oldname+"'";
  524. sql+="***update dindan set waiter2='"+newname+"' where waiter2='"+oldname+"'";
  525. sql+="***update dindan set waiter3='"+newname+"' where waiter3='"+oldname+"'";
  526. sql+="***update dindan set waiter4='"+newname+"' where waiter4='"+oldname+"'";
  527. sql+="***update dindan set waiter5='"+newname+"' where waiter5='"+oldname+"'";
  528. sql+="***update dindan set waiter6='"+newname+"' where waiter6='"+oldname+"'";
  529. sql+="***update dindan set waiter7='"+newname+"' where waiter7='"+oldname+"'";
  530. g_sendhead.bsql=1;
  531. g_pMainWnd->ProcessChatMessageRequest2(sql);*/
  532. /*
  533. CString sql;
  534. sql= "update dindan set status4='未修',waiter5='' where name2='王丽'";
  535. g_sendhead.bsql=1;
  536. g_pMainWnd->ProcessChatMessageRequest2(sql);
  537. */
  538. /*
  539. CString sql;
  540. sql= "update dindan set status4='未修' where status4=''";
  541. g_sendhead.bsql=1;
  542. g_pMainWnd->ProcessChatMessageRequest2(sql);
  543. */
  544. /*
  545. CString sql;
  546. sql= "update dindan set waiter1='',waiter3='',status='',status2='',status4='',time2='',time4='' where name1='唐微微'";
  547. g_sendhead.bsql=1;
  548. g_pMainWnd->ProcessChatMessageRequest2(sql);
  549. */
  550. /* CString sql;
  551. sql= "update dindan set status4='未调',status5='未设计'";
  552. g_sendhead.bsql=1;
  553. g_pMainWnd->ProcessChatMessageRequest2(sql);
  554. */
  555. /*CString sql;
  556. sql= "update path set path1='192.168.1.8',path2='192.168.1.8',path3='192.168.1.8' ";
  557. g_sendhead.bsql=1;
  558. g_pMainWnd->ProcessChatMessageRequest2(sql);
  559. */
  560. // TODO: Add your control notification handler code here
  561. POSITION pos;
  562. pos=m_List1.GetFirstSelectedItemPosition();
  563. if(pos==NULL)
  564. {
  565. return;
  566. }
  567. int iItem=m_List1.GetNextSelectedItem(pos);
  568. ModifyDinDan dlg;
  569. dlg.m_id = m_List1.GetItemText (iItem, 0);
  570. dlg.DoModal ();
  571. /* sql= "update dindan set id='20091018-009',time1='2009-10-18' where id='20091020-023' ";
  572. g_sendhead.bsql=1;
  573. g_pMainWnd->ProcessChatMessageRequest2(sql);
  574. sql= "update dindansp set id='20091018-009' where id='20091020-023' ";
  575. g_sendhead.bsql=1;
  576. g_pMainWnd->ProcessChatMessageRequest2(sql);
  577. MessageBox("ok"); */
  578. /*
  579. BYTE *pData;
  580. DWORD length;
  581. CFile fp;
  582. fp.Open (g_mainpath+"\\AutoUpdate.exe", CFile::modeRead);
  583. length=fp.GetLength ();
  584. pData=new BYTE[length];
  585. fp.Read (pData, length);
  586. fp.Close ();
  587. g_nSendCode=5;
  588. g_pMainWnd->ProcessChatMessageRequest2(pData, length);if(g_bSendOK==0)return;
  589. g_nSendCode=0;
  590. delete []pData;
  591. BYTE *pData;
  592. DWORD length;
  593. CFile fp;
  594. fp.Open (g_mainpath+"\\skin\\1.lia", CFile::modeRead);
  595. length=fp.GetLength ();
  596. pData=new BYTE[length];
  597. fp.Read (pData, length);
  598. fp.Close ();
  599. g_nSendCode=10;
  600. g_pMainWnd->ProcessChatMessageRequest2(pData, length);if(g_bSendOK==0)return;
  601. g_nSendCode=0;
  602. delete []pData;
  603. fp.Open (g_mainpath+"\\skin\\2.lia", CFile::modeRead);
  604. length=fp.GetLength ();
  605. pData=new BYTE[length];
  606. fp.Read (pData, length);
  607. fp.Close ();
  608. g_nSendCode=11;
  609. g_pMainWnd->ProcessChatMessageRequest2(pData, length);if(g_bSendOK==0)return;
  610. g_nSendCode=0;
  611. delete []pData;
  612. fp.Open (g_mainpath+"\\skin\\3.lia", CFile::modeRead);
  613. length=fp.GetLength ();
  614. pData=new BYTE[length];
  615. fp.Read (pData, length);
  616. fp.Close ();
  617. g_nSendCode=12;
  618. g_pMainWnd->ProcessChatMessageRequest2(pData, length);if(g_bSendOK==0)return;
  619. g_nSendCode=0;
  620. delete []pData;
  621. BYTE *pData;
  622. DWORD length;
  623. CFile fp;
  624. fp.Open (g_mainpath+"\\MSCHRT20.OCX", CFile::modeRead);
  625. length=fp.GetLength ();
  626. pData=new BYTE[length];
  627. fp.Read (pData, length);
  628. fp.Close ();
  629. g_nSendCode=16;
  630. g_pMainWnd->ProcessChatMessageRequest2(pData, length);if(g_bSendOK==0)return;
  631. g_nSendCode=0;
  632. delete []pData;
  633. BYTE *pData;
  634. DWORD length;
  635. CFile fp;
  636. fp.Open (g_mainpath+"\\skin\\004.lia", CFile::modeRead);
  637. length=fp.GetLength ();
  638. pData=new BYTE[length];
  639. fp.Read (pData, length);
  640. fp.Close ();
  641. g_nSendCode=17;
  642. g_pMainWnd->ProcessChatMessageRequest2(pData, length);if(g_bSendOK==0)return;
  643. g_nSendCode=0;
  644. delete []pData;
  645. BYTE *pData;
  646. DWORD length;
  647. CFile fp;
  648. fp.Open (g_mainpath+"\\复件 LYFZIPManage.exe", CFile::modeRead);
  649. length=fp.GetLength ();
  650. pData=new BYTE[length];
  651. fp.Read (pData, length);
  652. fp.Close ();
  653. g_nSendCode=4;
  654. g_pMainWnd->ProcessChatMessageRequest2(pData, length);if(g_bSendOK==0)return;
  655. g_nSendCode=0;
  656. delete []pData;
  657. CString sql;
  658. sql= "update version set version='102' ";
  659. g_sendhead.bsql=1;
  660. g_pMainWnd->ProcessChatMessageRequest2(sql);
  661. */
  662. }
  663. //]=34;
  664. //sql+=BUKUAN_REF2;
  665. /*
  666. int g_nYearposTemp=g_nYearpos;
  667. g_nYearpos=-1;
  668. g_pMainWnd->ProcessChatMessageRequest2(1);
  669. g_nYearpos=g_nYearposTemp;
  670. */