SalarySet3.cpp 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585
  1. // SalarySet3.cpp : implementation file
  2. //
  3. #include "stdafx.h"
  4. #include "ylgl.h"
  5. #include "SalarySet3.h"
  6. #include "MyMdi.H"
  7. #include "InputWork.h"
  8. #include "InputWork2.h"
  9. #include "InputWork3.h"
  10. #ifdef _DEBUG
  11. #define new DEBUG_NEW
  12. #undef THIS_FILE
  13. static char THIS_FILE[] = __FILE__;
  14. #endif
  15. /////////////////////////////////////////////////////////////////////////////
  16. // SalarySet3 IDC_EDITmoney2
  17. IMPLEMENT_DYNCREATE(SalarySet3, MyFormView)
  18. SalarySet3::SalarySet3()
  19. : MyFormView(SalarySet3::IDD)
  20. {
  21. //{{AFX_DATA_INIT(SalarySet3)
  22. m_year = atoi(g_date.Mid(0, 4));
  23. m_month = atoi(g_date.Mid(5, 2));
  24. m_day = atoi(g_date.Mid(8, 2));
  25. m_bInit = 0;
  26. m_radio1 = 2;
  27. //}}AFX_DATA_INIT
  28. }
  29. SalarySet3::~SalarySet3()
  30. {
  31. }
  32. void SalarySet3::DoDataExchange(CDataExchange* pDX)
  33. {
  34. MyFormView::DoDataExchange(pDX);
  35. //{{AFX_DATA_MAP(SalarySet3)
  36. DDX_Control(pDX, IDC_LIST7, m_List4);
  37. DDX_Control(pDX, IDC_LIST4, m_List3);
  38. DDX_Control(pDX, IDC_LIST3, m_List2);
  39. DDX_Control(pDX, IDC_SPIN3, m_spinday);
  40. DDX_Control(pDX, IDC_SPIN2, m_spinmonth);
  41. DDX_Control(pDX, IDC_SPIN1, m_spinyear);
  42. DDX_Control(pDX, IDC_LIST2, m_List1);
  43. DDX_Control(pDX, IDC_STATIC1, m_static1);
  44. DDX_Text(pDX, IDC_EDITyear, m_year);
  45. DDV_MinMaxUInt(pDX, m_year, 1900, 3000);
  46. DDX_Text(pDX, IDC_EDITmonth, m_month);
  47. DDV_MinMaxUInt(pDX, m_month, 1, 12);
  48. DDX_Text(pDX, IDC_EDITday, m_day);
  49. DDV_MinMaxUInt(pDX, m_day, 1, 31);
  50. DDX_Radio(pDX, IDC_RADIO3, m_radio1);
  51. //}}AFX_DATA_MAP
  52. }
  53. BEGIN_MESSAGE_MAP(SalarySet3, MyFormView)
  54. //{{AFX_MSG_MAP(SalarySet3)
  55. ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
  56. ON_EN_CHANGE(IDC_EDITyear, OnChangeEDITyear)
  57. ON_EN_CHANGE(IDC_EDITmonth, OnChangeEDITmonth)
  58. ON_EN_CHANGE(IDC_EDITday, OnChangeEDITday)
  59. ON_BN_CLICKED(IDC_RADIO3, OnRadio3)
  60. ON_BN_CLICKED(IDC_RADIO4, OnRadio4)
  61. ON_BN_CLICKED(IDC_RADIO5, OnRadio5)
  62. ON_BN_CLICKED(IDC_RADIO6, OnRadio6)
  63. ON_BN_CLICKED(IDC_RADIO7, OnRadio7)
  64. ON_BN_CLICKED(IDC_RADIO8, OnRadio8)
  65. ON_BN_CLICKED(IDC_RADIO9, OnRadio9)
  66. ON_BN_CLICKED(IDC_RADIO10, OnRadio10)
  67. ON_BN_CLICKED(IDC_RADIO11, OnRadio11)
  68. ON_BN_CLICKED(IDC_RADIO12, OnRadio12)
  69. ON_BN_CLICKED(IDC_RADIO13, OnRadio13)
  70. ON_BN_CLICKED(IDC_BUTprint, OnBUTprint)
  71. ON_BN_CLICKED(IDC_BUTprint2, OnBUTprint2)
  72. //}}AFX_MSG_MAP
  73. END_MESSAGE_MAP()
  74. /////////////////////////////////////////////////////////////////////////////
  75. // SalarySet3 diagnostics
  76. #ifdef _DEBUG
  77. void SalarySet3::AssertValid() const
  78. {
  79. MyFormView::AssertValid();
  80. }
  81. void SalarySet3::Dump(CDumpContext& dc) const
  82. {
  83. MyFormView::Dump(dc);
  84. }
  85. #endif //_DEBUG
  86. /////////////////////////////////////////////////////////////////////////////
  87. // SalarySet3 message handlers
  88. void SalarySet3::OnInitialUpdate()
  89. {
  90. MyFormView::OnInitialUpdate();
  91. m_List1.ShowWindow(SW_HIDE);
  92. m_List2.ShowWindow(SW_HIDE);
  93. m_List3.ShowWindow(SW_SHOW);
  94. m_List4.ShowWindow(SW_HIDE);
  95. // TODO: Add your specialized code here and/or call the base class
  96. CMyMdi Mdi;
  97. Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);
  98. // Here we create the outbar control using the splitter as its parent
  99. // and setting its id to the first pane.
  100. CRect rc2;
  101. GetWindowRect(rc2);
  102. ::MoveWindow(m_hWnd, g_rc.left, g_rc.top, g_rc.Width(), g_rc.Height(), TRUE);
  103. EnumChildWindows(m_hWnd, (WNDENUMPROC)EnumChildProc, 0);
  104. GetDlgItem(IDC_BUTprint)->EnableWindow(IsHasRights2new(17));
  105. GetDlgItem(IDC_BUTprint2)->EnableWindow(IsHasRights2new(61));
  106. m_static1.SetFont(&g_titlefont);
  107. #ifdef CHILD_VERSION
  108. GetDlgItem(IDC_RADIO4)->SetWindowText("引导师");
  109. #endif
  110. #ifdef CHILD_VERSION
  111. m_List1.SetHeadings("订单号,100;家长姓名,100;宝宝姓名,100;摄影师,100;日期,100;衣服套数(外景),100;衣服套数(内景),100;加挑照片,100;套系名称,100;套系价格,100;录入日期,100;录入人,100;手机,100;固定电话,100");
  112. m_List2.SetHeadings("订单号,100;家长姓名,100;宝宝姓名,100;化妆师,100;日期,100;衣服套数(外景),100;衣服套数(内景),100;加挑照片,100;套系名称,100;套系价格,100;录入日期,100;录入人,100;手机,100;固定电话,100");
  113. m_List3.SetHeadings("订单号,100;家长姓名,100;宝宝姓名,100;数码师,100;日期,100;完成内容,100;数量,100;套系名称,100;套系价格,100;录入日期,100;录入人,100;手机,100;固定电话,100");
  114. m_List4.SetHeadings("订单号,100;家长姓名,100;宝宝姓名,100;门市,100;套系名称,100;套系价格,100;手机,100;固定电话,100");
  115. #else
  116. m_List1.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;摄影师,100;日期,100;衣服套数(外景),100;衣服套数(内景),100;加挑照片,100;套系名称,100;套系价格,100;录入日期,100;录入人,100;男宾电话,100;女宾电话,100" );
  117. m_List2.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;化妆师,100;日期,100;衣服套数(外景),100;衣服套数(内景),100;加挑照片,100;套系名称,100;套系价格,100;录入日期,100;录入人,100;男宾电话,100;女宾电话,100" );
  118. m_List3.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;数码师,100;日期,100;完成内容,100;数量,100;套系名称,100;套系价格,100;录入日期,100;录入人,100;男宾电话,100;女宾电话,100" );
  119. m_List4.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;门市,100;套系名称,100;套系价格,100;男宾电话,100;女宾电话,100" );
  120. #endif
  121. m_List1.LoadColumnInfo(174);
  122. m_List2.LoadColumnInfo(175);
  123. m_List3.LoadColumnInfo(176);
  124. m_List4.LoadColumnInfo(177);
  125. m_spinyear.SetRange(1900, 3000);
  126. m_spinmonth.SetRange(1, 12);
  127. m_spinday.SetRange(1, 31);
  128. m_bInit = 1;
  129. DateChange();
  130. }
  131. void SalarySet3::FillGrid()
  132. {
  133. int ii = 0;
  134. if (m_radio1 == 0)
  135. {
  136. m_List1.DeleteAllItems2();
  137. m_List1.m_arLabels.SetSize(m_List1array.GetSize(), 1);
  138. int count = 0;
  139. for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
  140. {
  141. m_List1.m_arLabels.ElementAt(count++).Copy(m_List1array.ElementAt(ii));
  142. }
  143. m_List1.m_arLabels.SetSize(count, 1);
  144. ii = count;
  145. m_List1.m_LabelCount = ii;
  146. m_List1.SetItemCountEx(ii);
  147. }
  148. else if (m_radio1 == 1)
  149. {
  150. m_List2.DeleteAllItems2();
  151. m_List2.m_arLabels.SetSize(m_List2array.GetSize(), 1);
  152. int count = 0;
  153. for (ii = 0; ii < m_List2.m_arLabels.GetSize(); ii++)
  154. {
  155. m_List2.m_arLabels.ElementAt(count++).Copy(m_List2array.ElementAt(ii));
  156. }
  157. m_List2.m_arLabels.SetSize(count, 1);
  158. ii = count;
  159. m_List2.m_LabelCount = ii;
  160. m_List2.SetItemCountEx(ii);
  161. }
  162. else if (m_radio1 == 2)
  163. {
  164. m_List3.DeleteAllItems2();
  165. m_List3.m_arLabels.SetSize(m_List3array.GetSize(), 1);
  166. int count = 0;
  167. for (ii = 0; ii < m_List3.m_arLabels.GetSize(); ii++)
  168. {
  169. m_List3.m_arLabels.ElementAt(count++).Copy(m_List3array.ElementAt(ii));
  170. }
  171. m_List3.m_arLabels.SetSize(count, 1);
  172. ii = count;
  173. m_List3.m_LabelCount = ii;
  174. m_List3.SetItemCountEx(ii);
  175. }
  176. else if (m_radio1 == 3)
  177. {
  178. m_List4.DeleteAllItems2();
  179. m_List4.m_arLabels.SetSize(m_List4array.GetSize(), 1);
  180. int count = 0;
  181. for (ii = 0; ii < m_List4.m_arLabels.GetSize(); ii++)
  182. {
  183. m_List4.m_arLabels.ElementAt(count++).Copy(m_List4array.ElementAt(ii));
  184. }
  185. m_List4.m_arLabels.SetSize(count, 1);
  186. ii = count;
  187. m_List4.m_LabelCount = ii;
  188. m_List4.SetItemCountEx(ii);
  189. }
  190. CString str;
  191. str.Format("单数:%d", ii);
  192. SetDlgItemText(IDC_STATIC2, str);
  193. }
  194. void SalarySet3::OnBUTclose()
  195. {
  196. GetParent()->SendMessage(WM_CLOSE);
  197. }
  198. void SalarySet3::OnChangeEDITyear()
  199. {
  200. DateChange();
  201. }
  202. void SalarySet3::OnChangeEDITmonth()
  203. {
  204. DateChange();
  205. }
  206. void SalarySet3::OnChangeEDITday()
  207. {
  208. DateChange();
  209. }
  210. void SalarySet3::DateChange()
  211. {
  212. if (m_bInit == 0)return;
  213. m_spinyear.EnableWindow(0);
  214. m_spinmonth.EnableWindow(0);
  215. m_spinday.EnableWindow(0);
  216. UpdateData();
  217. int i = 0;
  218. int g_nYearposTemp = g_nYearpos;
  219. BOOL bThisYear = 0;
  220. BOOL bLastYear = 0;
  221. #if JEFF_TEST_ON // 2015开始禁用跨年数据;
  222. if (m_year >= 2014 && m_year <= atoi(g_date.Left(4)) && g_hisyeararray.GetSize())
  223. {
  224. g_nYearpos = -1;
  225. bThisYear = 1;
  226. }
  227. else if (m_year <= 2013 && g_hisyeararray.GetSize())
  228. {
  229. g_nYearpos = GetYearPos(m_year);
  230. bLastYear = 1;
  231. }
  232. #else
  233. if (m_year == atoi(g_date.Left(4)) && g_hisyeararray.GetSize())
  234. bThisYear = 1;
  235. else if (m_year <= atoi(g_date.Left(4)) - 1 && g_hisyeararray.GetSize())
  236. bLastYear = 1;
  237. g_nYearpos = GetYearPos(m_year);
  238. #endif
  239. CString sql, strdate, strdate2;
  240. strdate.Format("%04d-%02d-%02d", m_year, m_month, m_day);
  241. CRect rc;
  242. m_static1.GetWindowRect(rc);
  243. ScreenToClient(rc);
  244. InvalidateRect(rc);
  245. COleDateTime dtDay(m_year, m_month, m_day, 0, 0, 0);
  246. int nDayWeek = dtDay.GetDayOfWeek() - 1; //得到星期几,1=Sunday, 2=Monday,
  247. CString DayOfWeek[7] = { "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" };
  248. CString sdate;
  249. if (nDayWeek >= 0 && nDayWeek <= 6)
  250. sdate = DayOfWeek[nDayWeek];
  251. else
  252. sdate = "无效日期";
  253. CString dindanfilter = strdate;
  254. dindanfilter.Replace("-", "");
  255. dindanfilter = ";id like '" + dindanfilter + "%'";
  256. //m_static1.SetWindowText (strdate+"("+sdate+")员工工作");
  257. m_static1.SetWindowText(strdate + "(" + sdate + ")计件提成");
  258. sql.Format("datetime='" + strdate + "' and type='数码师'");
  259. sql += dindanfilter;
  260. g_sendhead.bsql = 0;
  261. g_sendhead.code[0] = 144;
  262. g_sendhead.tabcount = 1;
  263. g_pMainWnd->ProcessChatMessageRequest2(sql);
  264. if (g_bSendOK == 0)
  265. {
  266. g_nYearpos = g_nYearposTemp;
  267. m_spinyear.EnableWindow(1);
  268. m_spinmonth.EnableWindow(1);
  269. m_spinday.EnableWindow(1);
  270. return;
  271. }
  272. DataToArray(&m_List3array);
  273. if (bThisYear)
  274. {
  275. g_nYearpos = 0;//去年
  276. g_sendhead.bsql = 0;
  277. g_sendhead.code[0] = 144;
  278. g_sendhead.tabcount = 1;
  279. CString sql, strdate, strdate2;
  280. strdate.Format("%04d-%02d-%02d", m_year, m_month, m_day);
  281. sql.Format("datetime='" + strdate + "' and type='数码师'");
  282. sql += dindanfilter;
  283. g_pMainWnd->ProcessChatMessageRequest2(sql);
  284. if (g_bSendOK == 0)
  285. {
  286. g_nYearpos = g_nYearposTemp;
  287. m_spinyear.EnableWindow(1);
  288. m_spinmonth.EnableWindow(1);
  289. m_spinday.EnableWindow(1);
  290. return;
  291. }
  292. CArray<CStringArray, CStringArray>LastYearm_List3array;
  293. DataToArray(&LastYearm_List3array);
  294. int oldsize = m_List3array.GetSize();
  295. int newsize = LastYearm_List3array.GetSize();
  296. m_List3array.SetSize(oldsize + LastYearm_List3array.GetSize());
  297. for (i = oldsize; i < oldsize + LastYearm_List3array.GetSize(); i++)
  298. {
  299. m_List3array.ElementAt(i).Copy(LastYearm_List3array.ElementAt(i - oldsize));
  300. }
  301. }
  302. else if (bLastYear)
  303. {
  304. g_nYearpos = -1;//今年
  305. g_sendhead.bsql = 0;
  306. g_sendhead.code[0] = 144;
  307. g_sendhead.tabcount = 1;
  308. CString sql, strdate, strdate2;
  309. strdate.Format("%04d-%02d-%02d", m_year, m_month, m_day);
  310. sql.Format("datetime='" + strdate + "' and type='数码师'");
  311. sql += dindanfilter;
  312. g_pMainWnd->ProcessChatMessageRequest2(sql);
  313. if (g_bSendOK == 0)
  314. {
  315. g_nYearpos = g_nYearposTemp;
  316. m_spinyear.EnableWindow(1);
  317. m_spinmonth.EnableWindow(1);
  318. m_spinday.EnableWindow(1);
  319. return;
  320. }
  321. CArray<CStringArray, CStringArray>LastYearm_List3array;
  322. DataToArray(&LastYearm_List3array);
  323. int oldsize = m_List3array.GetSize();
  324. int newsize = LastYearm_List3array.GetSize();
  325. m_List3array.SetSize(oldsize + LastYearm_List3array.GetSize());
  326. for (i = oldsize; i < oldsize + LastYearm_List3array.GetSize(); i++)
  327. {
  328. m_List3array.ElementAt(i).Copy(LastYearm_List3array.ElementAt(i - oldsize));
  329. }
  330. }
  331. g_nYearpos = g_nYearposTemp;
  332. FillGrid();
  333. m_spinyear.EnableWindow(1);
  334. m_spinmonth.EnableWindow(1);
  335. m_spinday.EnableWindow(1);
  336. }
  337. void SalarySet3::KindChange()
  338. {
  339. }
  340. void SalarySet3::OnRadio3()
  341. {
  342. UpdateData();
  343. m_List1.ShowWindow(SW_SHOW);
  344. m_List2.ShowWindow(SW_HIDE);
  345. m_List3.ShowWindow(SW_HIDE);
  346. m_List4.ShowWindow(SW_HIDE);
  347. GetDlgItem(IDC_BUTprint)->EnableWindow(IsHasRights2new(17));
  348. GetDlgItem(IDC_BUTprint2)->EnableWindow(IsHasRights2new(61));
  349. FillGrid();
  350. }
  351. void SalarySet3::OnRadio4()
  352. {
  353. UpdateData();
  354. m_List2.ShowWindow(SW_SHOW);
  355. m_List1.ShowWindow(SW_HIDE);
  356. m_List3.ShowWindow(SW_HIDE);
  357. m_List4.ShowWindow(SW_HIDE);
  358. GetDlgItem(IDC_BUTprint)->EnableWindow(IsHasRights2new(17));
  359. GetDlgItem(IDC_BUTprint2)->EnableWindow(IsHasRights2new(61));
  360. FillGrid();
  361. }
  362. void SalarySet3::OnRadio5()
  363. {
  364. UpdateData();
  365. m_List3.ShowWindow(SW_SHOW);
  366. m_List2.ShowWindow(SW_HIDE);
  367. m_List1.ShowWindow(SW_HIDE);
  368. m_List4.ShowWindow(SW_HIDE);
  369. GetDlgItem(IDC_BUTprint)->EnableWindow(IsHasRights2new(17));
  370. GetDlgItem(IDC_BUTprint2)->EnableWindow(IsHasRights2new(61));
  371. FillGrid();
  372. }
  373. void SalarySet3::OnRadio6()
  374. {
  375. UpdateData();
  376. m_List4.ShowWindow(SW_SHOW);
  377. m_List2.ShowWindow(SW_HIDE);
  378. m_List3.ShowWindow(SW_HIDE);
  379. m_List1.ShowWindow(SW_HIDE);
  380. GetDlgItem(IDC_BUTprint)->EnableWindow(0);
  381. GetDlgItem(IDC_BUTprint2)->EnableWindow(0);
  382. FillGrid();
  383. }
  384. void SalarySet3::OnRadio9()
  385. {
  386. UpdateData();
  387. KindChange();
  388. }
  389. void SalarySet3::OnRadio7()
  390. {
  391. UpdateData();
  392. KindChange();
  393. }
  394. void SalarySet3::OnRadio8()
  395. {
  396. UpdateData();
  397. KindChange();
  398. }
  399. void SalarySet3::OnRadio10()
  400. {
  401. UpdateData();
  402. KindChange();
  403. }
  404. void SalarySet3::OnRadio11()
  405. {
  406. UpdateData();
  407. KindChange();
  408. }
  409. void SalarySet3::OnRadio12()
  410. {
  411. UpdateData();
  412. KindChange();
  413. }
  414. void SalarySet3::OnRadio13()
  415. {
  416. UpdateData();
  417. KindChange();
  418. }
  419. void SalarySet3::OnBUTprint()
  420. {
  421. // TODO: Add your control notification handler code here
  422. if (m_radio1 == 3)return;
  423. if (m_radio1 == 0)
  424. {
  425. InputWork dlg;
  426. dlg.DoModal();
  427. }
  428. else if (m_radio1 == 1)
  429. {
  430. InputWork dlg;
  431. dlg.m_mode = 1;
  432. dlg.DoModal();
  433. }
  434. else if (m_radio1 == 2)
  435. {
  436. InputWork3 dlg;
  437. dlg.DoModal();
  438. }
  439. DateChange();
  440. }
  441. void SalarySet3::OnBUTprint2() // 删除按钮;
  442. {
  443. // TODO: Add your control notification handler code here
  444. UpdateData();
  445. if (IsHasRights2new(61) == 0)return;
  446. if (m_radio1 == 3)return;
  447. CString sql;
  448. if (m_radio1 == 0)
  449. {
  450. POSITION pos;
  451. pos = m_List1.GetFirstSelectedItemPosition();
  452. if (pos == NULL)
  453. {
  454. AfxMessageBox("请先选中您要删除的项目!", MB_ICONINFORMATION);
  455. return;
  456. }
  457. if (AfxMessageBox("确定删除吗?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;
  458. int iItem = m_List1.GetNextSelectedItem(pos);
  459. CString id = m_List1.GetItemText(iItem, 0);
  460. CString name = m_List1.GetItemText(iItem, 3);
  461. CString date = m_List1.GetItemText(iItem, 4);
  462. CString count1 = m_List1.GetItemText(iItem, 5);
  463. CString count2 = m_List1.GetItemText(iItem, 6);
  464. CString count3 = m_List1.GetItemText(iItem, 7);
  465. sql.Format("delete from mywork where [id]='%s' and [name]='%s' and [datetime]='%s' and [count1]='%s' and [count2]='%s' and [count3]='%s' and [type]='摄影师'", id, name, date, count1, count2, count3);
  466. }
  467. else if (m_radio1 == 1)
  468. {
  469. POSITION pos;
  470. pos = m_List2.GetFirstSelectedItemPosition();
  471. if (pos == NULL)
  472. {
  473. AfxMessageBox("请先选中您要删除的项目!", MB_ICONINFORMATION);
  474. return;
  475. }
  476. if (AfxMessageBox("确定删除吗?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;
  477. int iItem = m_List2.GetNextSelectedItem(pos);
  478. CString id = m_List2.GetItemText(iItem, 0);
  479. CString name = m_List2.GetItemText(iItem, 3);
  480. CString date = m_List2.GetItemText(iItem, 4);
  481. CString count1 = m_List2.GetItemText(iItem, 5);
  482. CString count2 = m_List2.GetItemText(iItem, 6);
  483. CString count3 = m_List2.GetItemText(iItem, 7);
  484. sql.Format("delete from mywork where [id]='%s' and [name]='%s' and [datetime]='%s' and [count1]='%s' and [count2]='%s' and [count3]='%s' and [type]='化妆师'", id, name, date, count1, count2, count3);
  485. }
  486. else if (m_radio1 == 2)
  487. {
  488. POSITION pos;
  489. pos = m_List3.GetFirstSelectedItemPosition();
  490. if (pos == NULL)
  491. {
  492. AfxMessageBox("请先选中您要删除的项目!", MB_ICONINFORMATION);
  493. return;
  494. }
  495. if (AfxMessageBox("确定删除吗?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;
  496. int iItem = m_List3.GetNextSelectedItem(pos);
  497. CString id = m_List3.GetItemText(iItem, 0);
  498. CString name = m_List3.GetItemText(iItem, 3);
  499. CString date = m_List3.GetItemText(iItem, 4);
  500. CString count1 = m_List3.GetItemText(iItem, 5);
  501. CString count2 = m_List3.GetItemText(iItem, 6);
  502. sql.Format("delete from mywork where [id]='%s' and [name]='%s' and [datetime]='%s' and [count2]='%s' and [count1]='%s' and [type]='数码师'", id, name, date, count1, count2);
  503. }
  504. #ifdef CHILD_VERSION
  505. sql.Replace("化妆", "引导");
  506. #endif
  507. g_sendhead.bsql = 1;
  508. g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
  509. AfxMessageBox("删除成功!", MB_ICONINFORMATION);
  510. DateChange();
  511. }
  512. /************************************************************************/
  513. /* 函数:[10/24/2016 IT];
  514. /* 描述:;
  515. /* 参数:;
  516. /* [IN] :;
  517. /* [OUT] :;
  518. /* [IN/OUT] :;
  519. /* 返回:void;
  520. /* 注意:;
  521. /* 示例:;
  522. /*
  523. /* 修改:;
  524. /* 日期:;
  525. /* 内容:;
  526. /************************************************************************/
  527. void SalarySet3::HideCustomerPhone() // 隐藏顾客联系电话;
  528. {
  529. }