12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165 |
- // Booking2.cpp : implementation file
- //
- #include "stdafx.h"
- #include "ylgl.h"
- #include "Booking2.h"
- //#include "InputMemberno.h"
- #include "SelMemberType.h"
- #include "AddMember.h"
- #include "InputCard2Dlg.h"
- #include "Login2.h"
- #ifdef _DEBUG
- #define new DEBUG_NEW
- #undef THIS_FILE
- static char THIS_FILE[] = __FILE__;
- #endif
- /////////////////////////////////////////////////////////////////////////////
- // Booking2 dialog time1
- Booking2::Booking2(CWnd* pParent /*=NULL*/)
- : CDialog(Booking2::IDD, pParent)
- {
- m_bModify = 0;
- m_bSave = 0;
- //}}AFX_DATA_INIT
- }
- void Booking2::DoDataExchange(CDataExchange* pDX)
- {
- CDialog::DoDataExchange(pDX);
- //{{AFX_DATA_MAP(Booking2)
- // NOTE: the ClassWizard will add DDX and DDV calls here
- //}}AFX_DATA_MAP
- }
- BEGIN_MESSAGE_MAP(Booking2, CDialog)
- ON_BN_CLICKED(IDC_BUTinfo1, OnBUTinfo1)
- ON_BN_CLICKED(IDC_BUTinfo2, OnBUTinfo2)
- ON_BN_CLICKED(IDC_BUTinfo3, OnBUTinfo3)
- ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
- ON_WM_CTLCOLOR()
- ON_BN_CLICKED(IDC_BUTinfo4, OnBUTinfo4)
- ON_BN_CLICKED(IDC_BUTsave, OnBUTsave)
- ON_BN_CLICKED(IDC_BUTnew, OnBUTnew)
- ON_BN_CLICKED(IDC_BUTprint, OnBUTprint)
- ON_BN_CLICKED(IDC_BUTimport, OnBUTimport)
- //}}AFX_MSG_MAP
- END_MESSAGE_MAP()
- /////////////////////////////////////////////////////////////////////////////
- // Booking2 message handlers
- void Booking2::OnBUTclose()
- {
- // TODO: Add your control notification handler code here
- if (m_bSave)
- CDialog::OnOK();
- else
- CDialog::OnCancel();
- }
- void Booking2::OnOK()
- {
- }
- void Booking2::OnCancel()
- {
- CDialog::OnCancel();
- }
- HBRUSH Booking2::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)
- {
- HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
- // TODO: Change any attributes of the DC here
- if (nCtlColor == CTLCOLOR_STATIC && pWnd->GetDlgCtrlID() == IDC_STATIC2)
- {
- pDC->SetBkMode(TRANSPARENT); //设置字体背景为透明
- return (HBRUSH)::GetStockObject(WHITE_BRUSH); // 设置背景色
- }
- // TODO: Return a different brush if the default is not desired
- return hbr;
- }
- extern BOOL CALLBACK EnumChildProc2(HWND hwnd, LPARAM lParam);
- BOOL Booking2::OnInitDialog()
- {
- CDialog::OnInitDialog();
- // TODO: Add extra initialization here
- if ( m_bModify == 0 )
- {
- // Jeff 2015-05-19 开单时隐藏按钮;
- GetDlgItem(IDC_BUTinfo4)->ShowWindow(SW_HIDE);
- }
- if (m_bModify == 1)
- {
- SetWindowText("预约单-修改");
- GetDlgItem(IDC_BUTnew)->ShowWindow(0);
- GetDlgItem(IDC_BUTimport)->ShowWindow(0);
- GetDlgItem(IDC_BUTprint)->EnableWindow(1);
- #if JEFF_DELETE_ON // 2015.03.24 使用店长密码,不需要这块禁用按钮;
- GetDlgItem(IDC_BUTsave)->EnableWindow(IsHasRights2new(1));
- #endif
- // 如果拍照状态OK,禁用拍照时间edit和拍照状态commbox.
- }
- else if (m_bModify == 2)
- {
- SetWindowText("历史预约单");
- GetDlgItem(IDC_BUTnew)->ShowWindow(0);
- GetDlgItem(IDC_BUTimport)->ShowWindow(0);
- GetDlgItem(IDC_BUTprint)->EnableWindow(1);
- GetDlgItem(IDC_BUTsave)->EnableWindow(0);
- }
- CRect rc2;
- GetWindowRect(rc2);
- int dty = g_screenhei - 768;
- if (0)//dty>0)
- {
- g_rc.bottom -= dty;
- MoveWindow(g_rc);
- g_WidthScale2 = (float)g_rc.Width() / (float)rc2.Width(); // new/Old
- g_HeightScale2 = (float)g_rc.Height() / (float)rc2.Height();
- EnumChildWindows(m_hWnd, (WNDENUMPROC)EnumChildProc2, 0);
- g_rc.bottom += dty;
- MoveWindow(g_rc);
- }
- else
- {
- MoveWindow(g_rc);
- g_WidthScale2 = (float)g_rc.Width() / (float)rc2.Width(); // new/Old
- g_HeightScale2 = (float)g_rc.Height() / (float)rc2.Height();
- EnumChildWindows(m_hWnd, (WNDENUMPROC)EnumChildProc2, 0);
- }
- CRect rc;
- GetDlgItem(IDC_STATIC1)->GetWindowRect(rc);
- ScreenToClient(rc);
- GetDlgItem(IDC_STATIC2)->GetWindowRect(rc2);
- ScreenToClient(rc2);
- rc2.left = 0;
- rc2.top = 0;
- rc2.bottom = rc.top - 2;
- GetDlgItem(IDC_STATIC2)->MoveWindow(rc2);
- GetDlgItem(IDC_STATIC3)->MoveWindow(rc2);
- rc = rc2;
- rc.top = rc.bottom;
- rc.bottom += 1;
- GetDlgItem(IDC_STATIC4)->MoveWindow(rc);
- GetDlgItem(IDC_STATIC1)->GetWindowRect(rc2);
- ScreenToClient(rc2);
- rc.top = rc2.bottom;
- rc.bottom = rc.top + 1;
- GetDlgItem(IDC_STATIC5)->MoveWindow(rc);
- OnBUTinfo1();
- return TRUE; // return TRUE unless you set the focus to a control
- // EXCEPTION: OCX Property Pages should return FALSE
- }
- // Jeff 按钮:订单资料(第一个选项页,读取所有数据)
- void Booking2::OnBUTinfo1()//订单资料按钮;
- {
- // TODO: Add your control notification handler code here
- if (m_page1.GetSafeHwnd())m_page1.ShowWindow(SW_HIDE);
- if (m_page2.GetSafeHwnd())m_page2.ShowWindow(SW_HIDE);
- if (m_page3.GetSafeHwnd())m_page3.ShowWindow(SW_HIDE);
- if (m_page4.GetSafeHwnd())m_page4.ShowWindow(SW_HIDE);
- if (m_page1.GetSafeHwnd() == NULL)
- {
- CRect rc;
- GetDlgItem(IDC_STATIC1)->GetWindowRect(rc);
- ScreenToClient(rc);
- m_page1.m_rc = m_page2.m_rc = m_page3.m_rc = m_page4.m_rc = rc;
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 6; // 套系表taoxi;
- g_sendhead.code[1] = 7; // 套系商品1taoxishangpin1;
- g_sendhead.code[2] = 10; // 套系商品2taoxishangpin2;
- g_sendhead.code[3] = 4; // 商品shangpin;
- g_sendhead.code[4] = 82; // 冲印面积area;
- g_sendhead.code[5] = 68; // 人员管理membermanage;
- g_sendhead.code[6] = 127; // membercard2;
- g_sendhead.code[7] = 130; // membermanageblue;
- g_sendhead.code[8] = 131; // membercard2blue;
- g_sendhead.code[9] = 77; // taoxifg;
- g_sendhead.tabcount = 10; // 总共10个表;
- g_pMainWnd->ProcessChatMessageRequest2("show<>'隐藏'");
- DataToArray(
- &m_page1.m_List1array, \
- &m_page1.m_List2array, \
- &m_page1.m_List3array, \
- &m_page1.m_sparray, \
- &m_page2.m_areaarray, \
- &m_page3.m_List1array, \
- &m_page3.m_List2array, \
- &m_page3.m_List3array, \
- &m_page3.m_List4array, \
- &m_page3.m_List5array);
- if (m_bModify) // 预约单 - 修改;
- {
- //AfxMessageBox("+++++++++++++++++");
- CString id = m_id;
- g_sendhead.bsql = 0;
- CString filter = "id='" + id + "';id='" + id + "' and kind<>'5';id='" + id + "';id='" + id + "'";
- g_sendhead.code[0] = 11; // dindan;
- g_sendhead.code[1] = 56; // dindansp;
- g_sendhead.code[2] = 150; // dindanjd;
- #ifdef CHILD_VERSION
- g_sendhead.code[3] = 94; // client;
- #else
- g_sendhead.code[3]=52; // client;
- #endif
- g_sendhead.tabcount = 4; // 共4张表;
- g_bNoConnDlg = 1; // 设置连接服务器状态为:需要
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- g_bNoConnDlg = 0;
- if (g_bSendOK == 0)
- {
- CDialog::OnCancel();
- return;
- }
- CArray<CStringArray, CStringArray>ClientArray;
- DataToArray(&g_List1array, &m_page1.m_Bakarray, &m_page1.m_List1arrayM, &ClientArray);
- m_page2.m_name1 = g_List1array.ElementAt(0).ElementAt(4);
- m_page2.m_name2 = g_List1array.ElementAt(0).ElementAt(5);
- m_page1.m_id = m_id;
- m_page1.m_taoxiid = g_List1array.ElementAt(0).ElementAt(6);
- m_page1.m_taoxiname = g_List1array.ElementAt(0).ElementAt(7);
- m_page1.m_taoxijiage = g_List1array.ElementAt(0).ElementAt(8);
- // m_page1.m_zs = g_List1array.ElementAt (0).ElementAt (9);
- CString zs = g_List1array.ElementAt(0).ElementAt(9);
- int pos = zs.Find("\\");
- if (pos != -1)
- {
- m_page1.m_zs = zs.Left(pos);
- m_page1.m_zs2 = zs.Right(zs.GetLength() - pos - 1);
- }
- else
- {
- m_page1.m_zs = zs;
- m_page1.m_zs2 = "";
- }
- m_page1.m_growthtxselname = g_List1array.ElementAt(0).ElementAt(54);
- m_page4.m_time1 = g_List1array.ElementAt(0).ElementAt(10);
- m_page4.m_time2 = g_List1array.ElementAt(0).ElementAt(11);
- #if JEFF_TEST_ON // 将结婚日期换到m_page2中显示;
- #ifndef CHILD_VERSION
- m_page2.m_time3 = g_List1array.ElementAt(0).ElementAt(12);
- #endif
- #else
- m_page4.m_time3 = g_List1array.ElementAt(0).ElementAt(12);
- #endif
- m_page4.m_time4 = g_List1array.ElementAt(0).ElementAt(21);
- m_page4.m_time5 = g_List1array.ElementAt(0).ElementAt(22);
- m_page4.m_time6 = g_List1array.ElementAt(0).ElementAt(48);
- m_page4.m_time8 = g_List1array.ElementAt(0).ElementAt(72);
- m_page4.m_time9 = g_List1array.ElementAt(0).ElementAt(73);
- m_page4.m_time10 = g_List1array.ElementAt(0).ElementAt(74);
- m_page3.m_bm = g_List1array.ElementAt(0).ElementAt(13);
- m_page3.m_ren = g_List1array.ElementAt(0).ElementAt(14);
- m_page1.m_payed1 = g_List1array.ElementAt(0).ElementAt(16);
- m_page4.m_status1 = g_List1array.ElementAt(0).ElementAt(25);
- m_page3.m_clothescount = g_List1array.ElementAt(0).ElementAt(26);
- m_page3.m_clothescount2 = g_List1array.ElementAt(0).ElementAt(27);
- m_page3.m_outside = g_List1array.ElementAt(0).ElementAt(28);
- m_page3.m_outside2 = g_List1array.ElementAt(0).ElementAt(29);
- m_page3.m_style = g_List1array.ElementAt(0).ElementAt(30);
- m_page3.m_memberno = g_List1array.ElementAt(0).ElementAt(47);
- m_page4.m_status2 = g_List1array.ElementAt(0).ElementAt(32);
- m_page4.m_status3 = g_List1array.ElementAt(0).ElementAt(33);
- m_page4.m_waiter1 = g_List1array.ElementAt(0).ElementAt(34);
- m_page4.m_waiter2 = g_List1array.ElementAt(0).ElementAt(35);
- m_page4.m_waiter3 = g_List1array.ElementAt(0).ElementAt(36);
- m_page4.m_waiter4 = g_List1array.ElementAt(0).ElementAt(37);
- m_page1.m_bz = g_List1array.ElementAt(0).ElementAt(38);
- m_page4.m_waiter5 = g_List1array.ElementAt(0).ElementAt(42);
- m_page4.m_waiter7 = g_List1array.ElementAt(0).ElementAt(43);
- m_page4.m_waiter8 = g_List1array.ElementAt(0).ElementAt(76); // Jeff 看版人
- m_page4.m_status4 = g_List1array.ElementAt(0).ElementAt(44);
- m_page4.m_status5 = g_List1array.ElementAt(0).ElementAt(45);
- m_page4.m_status6 = g_List1array.ElementAt(0).ElementAt(46);
- m_page4.m_status8 = g_List1array.ElementAt(0).ElementAt(55); // Jeff 看版状态
- m_page1.m_txtype = g_List1array.ElementAt(0).ElementAt(52);
- #ifdef LKAY_VERSION
- m_page1.m_dindantype = g_List1array.ElementAt (0).ElementAt (63);
- m_page1.m_contractno = g_List1array.ElementAt (0).ElementAt (64);
- m_page1.m_contractno2 = g_List1array.ElementAt (0).ElementAt (65);
- m_page3.m_cfno = g_List1array.ElementAt (0).ElementAt (66);
- m_page3.m_from = g_List1array.ElementAt (0).ElementAt (67);
- m_page3.m_reason = g_List1array.ElementAt (0).ElementAt (68);
- m_page4.m_time7 = g_List1array.ElementAt (0).ElementAt (69);
- m_page4.m_waiter12 = g_List1array.ElementAt (0).ElementAt (50);
- m_page4.m_waiter13 = g_List1array.ElementAt (0).ElementAt (70);
- m_page4.m_waiter14 = g_List1array.ElementAt (0).ElementAt (71);
- #else
- m_page1.m_from = g_List1array.ElementAt(0).ElementAt(67);
- #endif
- /////////////////////////////////
- #ifdef CHILD_VERSION
- m_page2.m_name1 = ClientArray.ElementAt(0).ElementAt(1);
- m_page2.m_name2 = ClientArray.ElementAt(0).ElementAt(2);
- m_page2.m_phone1 = ClientArray.ElementAt(0).ElementAt(3);
- m_page2.m_phone2 = ClientArray.ElementAt(0).ElementAt(4);
- m_page2.m_qq1 = ClientArray.ElementAt(0).ElementAt(5);
- m_page2.m_addr1 = ClientArray.ElementAt(0).ElementAt(6);
- m_page2.m_birthday1 = ClientArray.ElementAt(0).ElementAt(7);
- m_page2.m_area = ClientArray.ElementAt(0).ElementAt(8);
- m_page2.m_sex = ClientArray.ElementAt(0).ElementAt(9);
- m_page2.m_zodiac = ClientArray.ElementAt(0).ElementAt(10);
- m_page2.m_check1 = atoi(ClientArray.ElementAt(0).ElementAt(11));
- #ifdef LKAY_VERSION
- if(IsHasRights2new(1)==0)
- {
- m_page2.m_addr1="***";
- m_page2.m_phone1="***";
- m_page2.m_phone2="***";
- m_page2.m_qq1="***";
- }
- #else
- #if JEFF_TEST_OFF // 当修改预约单时,没有权限的用户登陆会显示成*号;
- if(IsHasRights2new(1)==0 && IsHasRights2new(31)==0)
- {
- m_page2.m_addr1="***";
- m_page2.m_phone1="***";
- m_page2.m_phone2="***";
- m_page2.m_qq1="***";
- }
- #endif
- #endif
- ///////////////////////////////////
- #else
- m_page2.m_name1=ClientArray.ElementAt (0).ElementAt (1);
- m_page2.m_name2=ClientArray.ElementAt (0).ElementAt (2);
- m_page2.m_phone1=ClientArray.ElementAt (0).ElementAt (3);
- m_page2.m_phone2=ClientArray.ElementAt (0).ElementAt (4);
- m_page2.m_qq1=ClientArray.ElementAt (0).ElementAt (5);
- m_page2.m_qq2=ClientArray.ElementAt (0).ElementAt (6);
- m_page2.m_addr1=ClientArray.ElementAt (0).ElementAt (7);
- m_page2.m_addr2=ClientArray.ElementAt (0).ElementAt (8);
- m_page2.m_occupation1=ClientArray.ElementAt (0).ElementAt (9);
- m_page2.m_occupation2=ClientArray.ElementAt (0).ElementAt (10);
- m_page2.m_birthday1=ClientArray.ElementAt (0).ElementAt (11);
- m_page2.m_birthday2=ClientArray.ElementAt (0).ElementAt (12);
- m_page2.m_area=ClientArray.ElementAt (0).ElementAt (13);
- m_page2.m_area2=ClientArray.ElementAt (0).ElementAt (14);
- m_page2.m_check1=atoi(ClientArray.ElementAt (0).ElementAt (15));
- m_page2.m_check2=atoi(ClientArray.ElementAt (0).ElementAt (16));
- #if JEFF_TEST_ON // 将m_page4的结婚日期复选框改由m_page2显示;
- m_page2.m_check3=atoi(ClientArray.ElementAt (0).ElementAt (17));
- #else
- m_page4.m_check3=atoi(ClientArray.ElementAt (0).ElementAt (17));
- #endif
- #if JEFF_TEST_OFF // 当修改预约单时,没有权限的用户登陆会显示成*号;
- if(IsHasRights2new(1)==0 && IsHasRights2new(31)==0)
- {
- m_page2.m_addr1="***";
- m_page2.m_phone1="***";
- m_page2.m_phone2="***";
- m_page2.m_qq1="***";
- }
- #endif
- #endif
- }
- m_page1.Create(BookingPage1::IDD, this);
- #ifdef CHILD_VERSION
- m_page2.Create(IDD_DLGBookingPage22, this);
- #else
- m_page2.Create (IDD_DLGBookingPage2, this);
- #endif
- m_page3.Create(IDD_DLGBookingPage3, this);
- m_page4.Create(IDD_DLGBookingPage4, this);
- }
- #if JEFF_TEST_ON // 当修改预约单时,没有权限的用户登陆会显示成*号;
- if (m_bModify) // 预约单 - 修改;
- {
- if (IsHasRights2new(1) == 0 && IsHasRights2new(31) == 0)
- m_page2.SetPasswordChar();
- }
- #endif
- m_page1.ShowWindow(SW_SHOW);
- CString str;
- #ifdef CHILD_VERSION
- str = "\r\n\r\n 1. 预约单录入-订单资料\r\n 2. 请在下方录入订单资料后点客人资料进一步录入,打*号的内容是必填项目\r\n 3. 宝宝成长套系录入:可在套系类别中添加一个'成长套系', 然后选择套系类别为成长套系";
- #else
- str="\r\n\r\n 1. 预约单录入-订单资料\r\n 2. 请在下方录入订单资料后点客人资料进一步录入,打*号的内容是必填项目\r\n ";
- #endif
- GetDlgItem(IDC_STATIC2)->SetWindowText(str);
- }
- // Jeff 按钮:客人资料
- void Booking2::OnBUTinfo2() //客人资料按钮;
- {
- // TODO: Add your control notification handler code here
- if (m_page1.GetSafeHwnd())m_page1.ShowWindow(SW_HIDE);
- if (m_page2.GetSafeHwnd())m_page2.ShowWindow(SW_HIDE);
- if (m_page3.GetSafeHwnd())m_page3.ShowWindow(SW_HIDE);
- if (m_page4.GetSafeHwnd())m_page4.ShowWindow(SW_HIDE);
- m_page2.ShowWindow(SW_SHOW);
- CString str;
- str = "\r\n\r\n 1. 预约单录入-客人资料\r\n 2. 请在下方录入客人资料后点其它资料进一步录入,打*号的内容是必填项目";
- GetDlgItem(IDC_STATIC2)->SetWindowText(str);
- }
- // Jeff 按钮:其它资料;
- void Booking2::OnBUTinfo3() //其他资料按钮;
- {
- // TODO: Add your control notification handler code here
- if (m_page1.GetSafeHwnd())m_page1.ShowWindow(SW_HIDE);
- if (m_page2.GetSafeHwnd())m_page2.ShowWindow(SW_HIDE);
- if (m_page3.GetSafeHwnd())m_page3.ShowWindow(SW_HIDE);
- if (m_page4.GetSafeHwnd())m_page4.ShowWindow(SW_HIDE);
- #if JEFF_TEST_ON
- // 传参:顾客姓名,顾客手机号,顾客订单号,顾客订单套系价格;
- // 不区分儿童和婚纱版本,统一使用顾客1的姓名和手机号;
- m_page3.m_strCustomer = m_page2.m_name1;
- m_page3.m_strPhone = m_page2.m_phone1;
- m_page3.m_strOrderNum = m_page1.m_id;
- m_page3.m_strTaoxiJiaoge = m_page1.m_taoxijiage;
- #endif
- m_page3.ShowWindow(SW_SHOW);
- CString str;
- str = "\r\n\r\n 1. 预约单录入-其它资料\r\n 2. 请在下方录入其它资料后点日期安排进一步录入,打*号的内容是必填项目";
- GetDlgItem(IDC_STATIC2)->SetWindowText(str);
- if (m_bModify == 0) m_page3.ShowMemberDlg();
- }
- // Jeff 按钮:时间安排;
- void Booking2::OnBUTinfo4() //时间安排按钮;
- {
- // Jeff.add;
- if (m_bModify == 1)
- {
- SetDlgItemText(IDC_BUTinfo4, "流程查看");
- }
- // TODO: Add your control notification handler code here
- if (m_page1.GetSafeHwnd())m_page1.ShowWindow(SW_HIDE);
- if (m_page2.GetSafeHwnd())m_page2.ShowWindow(SW_HIDE);
- if (m_page3.GetSafeHwnd())m_page3.ShowWindow(SW_HIDE);
- if (m_page4.GetSafeHwnd())m_page4.ShowWindow(SW_HIDE);
- m_page4.ShowWindow(SW_SHOW);
- CString str;
- str = "\r\n\r\n 1. 预约单录入-日期安排\r\n 2. 请在下方录入客人拍照日期,选片日期,选片人等信息后点保存订单";
- GetDlgItem(IDC_STATIC2)->SetWindowText(str);
- }
- extern BOOL CovertDate(CString &date, CString &date2);
- // Jeff 按钮:保存订单;
- void Booking2::OnBUTsave() //保存订单
- {
- m_bSave = 1;
- if (this->m_bModify)
- {
- OnBUTsave2();
- return;
- }
- // TODO: Add your control notification handler code here
- if (!m_page1.CheckOK())
- {
- AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
- OnBUTinfo1(); return;
- }
- if (!m_page2.CheckOK())
- {
- AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
- OnBUTinfo2(); return;
- }
- if (!m_page3.CheckOK())
- {
- AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
- OnBUTinfo3(); return;
- }
- if (!m_page4.CheckOK())
- {
- AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
- OnBUTinfo4(); return;
- }
- CString id = m_page1.m_id;
- CString sql;
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(121)))
- {
- g_bNoConnDlg = 1;
- CString date = g_date;
- sql = "select count(*) as cot from dindan where id='" + id + "' ";
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- g_bNoConnDlg = 0;
- if (g_bSendOK == 0)return;
- if (g_ncount)
- {
- AfxMessageBox("已有此单号的订单,请重新编写单号!", MB_ICONINFORMATION);
- OnBUTinfo1();
- return;
- }
- }
- else
- {
- g_bNoConnDlg = 1;
- CString date = g_date;
- sql = "select count(*) as cot from dindan where id='" + id + "' ";
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- g_bNoConnDlg = 0;
- if (g_bSendOK == 0)return;
- if (g_ncount) // Jeff 查询dindan表时返回的记录数:g_ncount;
- {
- g_bNoConnDlg = 1;
- CString date = g_date; date.Replace("-", "");
- sql = "select max(id) as cot from dindan where id like '" + date + "%' ";
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);
- g_bNoConnDlg = 0;
- if (g_bSendOK == 0)return;
- date.Replace("-", "");
- id.Format("%s-%03d", date, g_ncount + 1);
- }
- }
- if (IsHasRights2(0) == 0)
- return;
- // TODO: Add your control notification handler code here
- CString m_taoxiid = m_page1.m_taoxiid;
- CString taoxiname = m_page1.m_taoxiname;
- CString m_growthtxselname = m_page1.m_growthtxselname;
- CString m_taoxijiage = m_page1.m_taoxijiage;
- CString m_payed1 = m_page1.m_payed1;
- // CString m_zs=m_page1.m_zs;
- CString m_zs = m_page1.m_zs + "\\" + m_page1.m_zs2;
- CString txtype = m_page1.m_txtype;
- CString m_bz = m_page1.m_bz;
- CString m_authorize = m_page1.m_authorize;
- BOOL m_bGrowthTX = m_page1.m_bGrowthTX;
- #ifdef LKAY_VERSION
- CString m_dindantype=m_page1.m_dindantype;
- CString m_contractno=m_page1.m_contractno;
- CString m_contractno2=m_page1.m_contractno2;
- CString m_cfno=m_page3.m_cfno;
- CString m_from=m_page3.m_from;
- CString m_reason=m_page3.m_reason;
- CString m_time7=m_page4.m_time7;
- CString m_waiter12=m_page4.m_waiter12;
- CString m_waiter13=m_page4.m_waiter13;
- CString m_waiter14=m_page4.m_waiter14;
- #else
- CString m_from = m_page1.m_from;
- #endif
- CString bm = m_page3.m_bm;
- CString ren = m_page3.m_ren;
- CString m_clothescount = m_page3.m_clothescount;
- CString m_clothescount2 = m_page3.m_clothescount2;
- CString m_outside = m_page3.m_outside;
- CString m_outside2 = m_page3.m_outside2;
- CString m_style = m_page3.m_style;
- CString strmoney = "0";
- CString m_discount;
- if (atof(m_taoxijiage) > 0 && (m_page1.m_saleprice1 + m_page1.m_saleprice2) > 0)
- m_discount.Format("%0.2f", min(10.0, (atof(m_taoxijiage) * 10) / (m_page1.m_saleprice1 + m_page1.m_saleprice2)));
- else
- m_discount = "0";
- #ifdef CHILD_VERSION
- CString m_name1 = m_page2.m_name1;
- CString m_name2 = m_page2.m_name2;
- CString m_phone1 = m_page2.m_phone1;
- CString m_phone2 = m_page2.m_phone2;
- CString m_qq1 = m_page2.m_qq1;
- CString m_addr1 = m_page2.m_addr1;
- CString m_birthday1 = m_page2.m_birthday1;
- CString m_area = m_page2.m_area;
- BOOL m_check1 = m_page2.m_check1;
- CString m_zodiac = m_page2.m_zodiac;
- CString m_sex = m_page2.m_sex;
- CString m_birthday2, m_qq2, m_addr2;
- #else
- CString m_name1=m_page2.m_name1;
- CString m_name2=m_page2.m_name2;
- CString m_phone1=m_page2.m_phone1;
- CString m_phone2=m_page2.m_phone2;
- CString m_qq1=m_page2.m_qq1;
- CString m_qq2=m_page2.m_qq2;
- CString m_addr1=m_page2.m_addr1;
- CString m_addr2=m_page2.m_addr2;
- CString m_occupation1=m_page2.m_occupation1;
- CString m_occupation2=m_page2.m_occupation2;
- CString m_birthday1=m_page2.m_birthday1;
- CString m_birthday2=m_page2.m_birthday2;
- CString m_area=m_page2.m_area;
- CString m_area2=m_page2.m_area2;
- BOOL m_check1=m_page2.m_check1;
- BOOL m_check2=m_page2.m_check2;
- #endif
- CString m_time1 = m_page4.m_time1;
- CString m_time2 = m_page4.m_time2;
- #if JEFF_TEST_ON // 结婚日期;
- #ifndef CHILD_VERSION
- CString m_time3 = m_page2.m_time3;
- #else
- CString m_time3 = _T("");
- #endif
- #else
- CString m_time3 = m_page4.m_time3;
- #endif
- CString m_time4 = m_page4.m_time4;
- CString m_time5 = m_page4.m_time5;
- CString m_time6 = m_page4.m_time6;
- CString m_time8 = m_page4.m_time8;
- CString m_time9 = m_page4.m_time9;
- CString m_time10 = m_page4.m_time10;
- CString m_waiter1 = m_page4.m_waiter1;
- CString m_waiter2 = m_page4.m_waiter2;
- CString m_waiter3 = m_page4.m_waiter3;
- CString m_waiter4 = m_page4.m_waiter4;
- CString m_waiter5 = m_page4.m_waiter5;
- CString m_waiter7 = m_page4.m_waiter7;
- CString m_waiter8 = m_page4.m_waiter8; // Jeff 看版人waiter8
- CString m_status1 = m_page4.m_status1;
- CString m_status2 = m_page4.m_status2;
- CString m_status3 = m_page4.m_status3;
- CString m_status4 = m_page4.m_status4;
- CString m_status5 = m_page4.m_status5;
- CString m_status6 = m_page4.m_status6;
- //CString m_status8=m_page4.m_status8; // Jeff 看版状态status8
- #if JEFF_TEST_ON
- #ifndef CHILD_VERSION
- BOOL m_check3 = m_page2.m_check3;
- #else
- BOOL m_check3 = FALSE;
- #endif
- #else
- BOOL m_check3 = m_page4.m_check3;
- #endif
- CString str, str2;
- CString strRes1, strRes2;
- GetFirstLetter(m_name1, strRes1);
- GetFirstLetter(m_name2, strRes2);
- CString m_memberno = m_page3.m_memberno;
- CString m_membernotemp = m_memberno;
- if (m_page3.m_type)m_memberno.Empty();
- if (txtype == "成长套系" && m_growthtxselname.IsEmpty() == 0)
- {
- taoxiname += "cztx";
- }
- // Jeff add;
- CString strInputTime;
- strInputTime = CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S");
- // end;
- #if 0 // Jeff 原版
- sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from]) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s')",
- id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,
- m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_memberno,txtype,m_phone1,m_phone2,m_authorize,m_from
- );
- #else// Jeff添加看设计人和看设计状态;
- #if 0// Jeff:原没有选片录入和录入时间;
- sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s')",
- id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname, m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,
- m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,
- m_memberno,txtype,m_phone1,m_phone2,m_authorize,m_from);
- #else
- sql.Format("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[authorize],[from],[xplrr],[xplrtime])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s')",
- id, m_growthtxselname, strmoney, m_name1, m_name2, m_taoxiid, taoxiname, m_taoxijiage, m_zs,
- m_time1, m_time2, m_time3, m_time4, m_time5, m_time6, m_time8, m_time9, m_time10, bm, ren, m_discount, m_payed1,
- m_status1, m_status2, m_status3, m_status4, m_status5, m_status6, FilterBZ(m_bz), strRes1, strRes2,
- m_clothescount, m_clothescount2, m_outside, m_outside2, m_style, m_waiter1, m_waiter2, m_waiter3, m_waiter4, m_waiter5, g_user.name, m_waiter7, m_waiter8,
- m_memberno, txtype, m_phone1, m_phone2, m_authorize, m_from, g_user.name, CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S"));
- #endif
- #endif
- #ifdef LKAY_VERSION
- #if 0 // Jeff 原版
- sql.Format ("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[dindantype],[contractno1],[contractno2],[cfno],[from],[reason],[time7],[waiter12],[waiter13],[waiter14],[authorize])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
- id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1,
- m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,
- m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,
- m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,
- g_user.name,m_waiter7,m_memberno,txtype,m_phone1,m_phone2,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,m_authorize);
- #else // Jeff添加看设计人和看设计状态;
- sql.Format ("insert into [dindan]([id],[growthtxselname],[money1],[name1],[name2],[taoxiid],[taoxiname],[taoxijiage],[taoxizs],[time1],[time2],[time3],[time4],[time5],[time6],[time8],[time9],[time10],[bm],[ren],[discount],[payed1],[status],[status2],[status3],[status4],[status5],[status6],[status7],[status8],[urgent],[bz],[pinyin1],[pinyin2],[clothescount],[clothescount2],[outside],[outside2],[style],[waiter1],[waiter2],[waiter3],[waiter4],[waiter5],[waiter6],[waiter7],[waiter8],[memberno],[txtype],[tichenren1],[tichenren2],[tichenren3],[tichenren4],[tichenren5],[phone1],[phone2],[dindantype],[contractno1],[contractno2],[cfno],[from],[reason],[time7],[waiter12],[waiter13],[waiter14],[authorize],[xplrr],[xplrtime]) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','未刻','未看','否','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','','','','','','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
- id,m_growthtxselname,strmoney,m_name1,m_name2,m_taoxiid,taoxiname,m_taoxijiage,m_zs,m_time1,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,bm,ren,m_discount,m_payed1,
- m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,
- m_memberno,txtype,m_phone1,m_phone2,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,m_authorize,g_user.name,CTime::GetCurrentTime().Format("%Y-%m-%d %H:%M:%S"));
- #endif
- #endif
- CString sql2;
- CStringArray idarray;
- idarray.Add(id);
- #ifdef CHILD_VERSION
- sql2.Format("###insert into [client]([name1],[name2],[phone1],[phone2],[qq1],[addr1],[birthday1],[id],[area],[sex],[zodiac],[check1])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d')", m_name1, m_name2, m_phone1, m_phone2, m_qq1, m_addr1, m_birthday1, id, m_area, m_sex, m_zodiac, m_check1);
- sql += sql2;
- if (txtype == "成长套系" && m_growthtxselname.IsEmpty() == 0)
- {
- CString sqltemp = sql;
- CString taoxinametemp = taoxiname.Left(taoxiname.GetLength() - 4);
- CString m_selname = m_growthtxselname;
- int pos = m_selname.Find(",");
- CStringArray selnamearray;
- while (pos != -1)
- {
- selnamearray.Add(m_selname.Left(pos));
- m_selname = m_selname.Right(m_selname.GetLength() - pos - 1);
- pos = m_selname.Find(",");
- }
- selnamearray.Add(m_selname);
- int idpos = atoi(id.Right(3));
- CString newid, temp;
- for (int ii = 0; ii < selnamearray.GetSize(); ii++)
- {
- taoxinametemp = taoxiname; taoxinametemp += selnamearray.ElementAt(ii);
- if (ii == 0)
- {
- sql.Replace(taoxiname, taoxinametemp);
- continue;
- }
- newid.Format("%s%03d", id.Left(id.GetLength() - 3), ++idpos); idarray.Add(newid);
- temp = sqltemp;
- temp.Replace(id, newid);
- temp.Replace(taoxiname, taoxinametemp);
- sql += "###" + temp;
- }
- }
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(39)))
- {
- CString m_content3 = g_cominfoarray.ElementAt(0).ElementAt(40);
- CString str, timestamp;
- timestamp = "msgtimestamp";
- {
- CString name;
- if (!m_name1.IsEmpty())
- name = m_name1 + ",";
- name += m_name2;
- name.TrimRight(",");
- if (name.IsEmpty() == 0 && CheckPhoneType(m_phone1) != -1 && CheckBadWords(name, 0))
- {
- str = name + m_content3;
- str.Replace("xxx小朋友", "");
- int count = GetLengthEx(str) / MSG_LENGTH;
- if (GetLengthEx(str) % MSG_LENGTH)
- count++;
- CString scount;
- scount.Format("%d", count);
- #if JEFF_TEST_ON
- sql2.Format(INSERT_SENDREG, _T("3"), m_phone1, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
- sql += _T("###") + sql2;
- #else
- sql2="###insert into [sendreg]([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone1+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
- sql+=sql2;
- #endif
- }
- }
- }
- #else
- sql2.Format ("###insert into [client]([name1],[name2],[phone1],[phone2],[qq1],[qq2],[addr1],[addr2],[occupation1],[occupation2],[birthday1],[birthday2],[id],[area],[area2],[check1],[check2],[check3])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%d','%d')",m_name1,m_name2,m_phone1,m_phone2,m_qq1,m_qq2,m_addr1,m_addr2,m_occupation1,m_occupation2,m_birthday1,m_birthday2,id,m_area,m_area2,m_check1,m_check2,m_check3);
- sql+=sql2;
- if(txtype=="成长套系" && m_growthtxselname.IsEmpty ()==0)
- {
- CString sqltemp=sql;
- CString taoxinametemp=taoxiname.Left(taoxiname.GetLength()-4);
- CString m_selname=m_growthtxselname;
- int pos=m_selname.Find (",");
- CStringArray selnamearray;
- while(pos!=-1)
- {
- selnamearray.Add (m_selname.Left (pos));
- m_selname=m_selname.Right (m_selname.GetLength ()-pos-1);
- pos=m_selname.Find (",");
- }
- selnamearray.Add (m_selname);
- int idpos=atoi(id.Right (3));
- CString newid,temp;
- for(int ii=0; ii<selnamearray.GetSize (); ii++)
- {
- taoxinametemp=taoxiname;taoxinametemp+=selnamearray.ElementAt (ii);
- if(ii==0)
- {
- sql.Replace (taoxiname, taoxinametemp);
- continue;
- }
- newid.Format ("%s%03d", id.Left (id.GetLength ()-3), ++idpos);idarray.Add(newid);
- temp=sqltemp;
- temp.Replace (id, newid);
- temp.Replace (taoxiname, taoxinametemp);
- sql+="###"+temp;
- }
- }
- if(atoi(g_cominfoarray.ElementAt(0).ElementAt(39)))
- {
- CString m_content3 = g_cominfoarray.ElementAt(0).ElementAt(40);
- CString str,timestamp;
- timestamp="msgtimestamp";
- int pos=m_content3.Find("xxx先生/女士");
- if(pos!=-1)
- {
- if(m_name1.IsEmpty ()==0 && CheckPhoneType(m_phone1)!=-1 && CheckBadWords(m_name1,0))
- {
- str=m_content3;
- #ifdef LYFZ_VERSION
- str.Replace ("xxx先生/女士", m_name1);
- #else
- str.Replace ("xxx先生/女士", m_name1+"先生");
- #endif
- int count=GetLengthEx(str)/MSG_LENGTH;
- if(GetLengthEx(str)%MSG_LENGTH)
- count++;
- CString scount;
- scount.Format ("%d", count);
- #if JEFF_TEST_ON
- sql2.Format(INSERT_SENDREG, _T("3"), m_phone1, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
- sql += _T("###") + sql2;
- #else
- sql2="###insert into [sendreg]([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone1+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
- sql+=sql2;
- #endif
- }
- #ifndef LYFZ_VERSION
- if(m_name2.IsEmpty ()==0 && CheckPhoneType(m_phone2)!=-1 && CheckBadWords(m_name2,0) )
- {
- str=m_content3;
- str.Replace ("xxx先生/女士", m_name2+"女士");
- int count=GetLengthEx(str)/MSG_LENGTH;
- if(GetLengthEx(str)%MSG_LENGTH)
- count++;
- CString scount;
- scount.Format ("%d", count);
- CTime tm=CTime::GetCurrentTime ();
- tm+=CTimeSpan(0,0,0,3);
- timestamp=tm.Format ("%Y%m%d%H%M%S");
- timestamp="msgtimexxstamp";
- #if JEFF_TEST_ON
- sql2.Format(INSERT_SENDREG, _T("3"), m_phone2, str, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
- sql += _T("###") + sql2;
- #else
- sql2="###insert into [sendreg]([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone2+"','"+str+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
- sql+=sql2;
- #endif
- }
- #endif
- }
- }
- #endif
- ////////////////////////
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本
- {
- CString timestamp;
- CTime tm = CTime::GetCurrentTime();
- CTimeSpan dt(0, 0, 0, 1);
- timestamp = tm.Format("%Y%m%d%H%M%S");
- CString phone, clothescount;
- if (m_time2 != "")
- {
- phone = m_phone1 + " " + m_phone2;
- phone.TrimLeft();
- if (m_clothescount != "")
- clothescount = "服装:" + m_clothescount;
- sql2.Format("###insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time2, 0, "未到", id);
- sql += sql2;
- }
- if (m_time4 != "")
- {
- tm += dt;
- timestamp = tm.Format("%Y%m%d%H%M%S");
- phone = m_phone1 + " " + m_phone2;
- phone.TrimLeft();
- if (m_clothescount != "")
- clothescount = "服装:" + m_clothescount;
- sql2.Format("###insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time4, 1, "未到", id);
- sql += sql2;
- }
- if (m_time6 != "")
- {
- tm += dt;
- timestamp = tm.Format("%Y%m%d%H%M%S");
- phone = m_phone1 + " " + m_phone2;
- phone.TrimLeft();
- if (m_clothescount != "")
- clothescount = "服装:" + m_clothescount;
- sql2.Format("###insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time6, 2, "未到", id);
- sql += sql2;
- }
- if (m_time5 != "")
- {
- tm += dt;
- timestamp = tm.Format("%Y%m%d%H%M%S");
- phone = m_phone1 + " " + m_phone2;
- phone.TrimLeft();
- if (m_clothescount != "")
- clothescount = "服装:" + m_clothescount;
- sql2.Format("###insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time5, 3, "未到", id);
- sql += sql2;
- }
- }
- ////////////////////////////
- sql2 = "###" + id + "$$$" + m_memberno;
- sql += sql2;
- //AfxMessageBox(sql); //Jeff输出SQL语句
- // LOG4C((LOG_NOTICE,"sql=%s",sql.GetBuffer(0)));sql.ReleaseBuffer();
- // printf("Jeff:%s\n\n", sql.GetBuffer(0));sql.ReleaseBuffer(); //控制台输出;
- // printf("Jeff:sql语句长度=%d\n\n",strlen(sql.GetBuffer(0))+1 );sql.ReleaseBuffer();
- //Sleep(2000);system("cls");
- m_memberno = m_membernotemp;
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- // printf("Jeff:Booking2发送订单SQL成功,等待接收....\n\n");
- CArray<CStringArray, CStringArray>sparray;
- if (m_bGrowthTX)
- sparray.SetSize(m_page1.m_List1arraygrowthbak.GetSize() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount(), 1);
- else
- sparray.SetSize(m_page1.m_List1.GetItemCount() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount(), 1);
- int realcount = 0;
- int i;
- if (m_bGrowthTX)
- {
- for (i = 0; i < m_page1.m_List1arraygrowthbak.GetSize(); i++)
- {
- int arraygrowthbaksize = m_page1.m_List1arraygrowthbak.ElementAt(i).GetSize();
- str = m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(1);
- str.TrimLeft();
- str.TrimRight();
- if (str.IsEmpty())
- continue;
- sparray.ElementAt(realcount).Add(id);
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(0));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(2));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(3));
- sparray.ElementAt(realcount).Add("1");
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(1));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(4));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(5));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(arraygrowthbaksize - 1));
- realcount++;
- }
- }
- else
- {
- for (i = 0; i < m_page1.m_List1.GetItemCount(); i++)
- {
- str = m_page1.m_List1.GetItemText(i, 1);
- str.TrimLeft(); str.TrimRight();
- if (str.IsEmpty())
- continue;
- sparray.ElementAt(realcount).Add(id);
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 0));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 2));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 3));
- sparray.ElementAt(realcount).Add("1");
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 1));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 4));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 5));
- realcount++;
- }
- }
- for (i = 0; i < m_page1.m_List3.GetItemCount(); i++)
- {
- str = m_page1.m_List3.GetItemText(i, 1);
- str.TrimLeft(); str.TrimRight();
- if (str.IsEmpty())continue;
- sparray.ElementAt(realcount).Add(id);
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 0));
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 2));
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 3));
- sparray.ElementAt(realcount).Add("2");
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 1));
- sparray.ElementAt(realcount).Add("");
- sparray.ElementAt(realcount).Add("");
- realcount++;
- }
- for (i = 0; i < m_page1.m_listbox1.GetCount(); i++)
- {
- m_page1.m_listbox1.GetText(i, str);
- sparray.ElementAt(realcount).Add(id);
- sparray.ElementAt(realcount).Add(str);
- realcount++;
- }
- if (realcount == 0)
- {
- sparray.SetSize(1, 1);
- sparray.ElementAt(0).Add(id);
- }
- else if (idarray.GetSize() > 1)
- {
- sparray.SetSize(realcount + 1, 1);
- sparray.ElementAt(realcount).Add("成长套系");
- for (int a = 0; a < idarray.GetSize(); a++)
- {
- sparray.ElementAt(realcount).Add(idarray.ElementAt(a));
- }
- }
- else
- sparray.SetSize(realcount, 1);
- realcount = sparray.GetSize();
- sparray.SetSize(realcount + 1, 1);
- sparray.ElementAt(realcount).Add(g_user.name);
- CMemFile memfile;
- CArchive ar(&memfile, CArchive::store);
- for (int ii = 0; ii < sparray.GetSize(); ii++)
- {
- sparray.ElementAt(ii).Serialize(ar);
- }
- ar.Close();
- int length = memfile.GetLength();
- BYTE *pData = memfile.Detach();
- int size = sparray.GetSize();
- BYTE *pData2 = new BYTE[length + sizeof(int)];
- memcpy(pData2, pData, length);
- memcpy(pData2 + length, &size, sizeof(int));
- delete[]pData;
- length += sizeof(int);
- g_nSendCode = 3;
- g_pMainWnd->ProcessChatMessageRequest2(pData2, length);
- g_nSendCode = 0;
- delete[]pData2;
- if (g_bSendOK == 0)
- return;
- #ifndef CHILD_VERSION
- if(m_time3.IsEmpty ()==0)
- {
- CString date=m_time3;
- CString date2;
- if(m_check3)
- CovertDate(date, date2);
- sql.Format ("update dindansp set hqdate='%s' where id='%s'", date, id);
- if(atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本
- {
- CString timestamp;
- CTime tm=CTime::GetCurrentTime ();
- CTimeSpan dt(0,0,0,10);
- tm+=dt;
- timestamp=tm.Format ("%Y%m%d%H%M%S");
- CString phone,clothescount,content;
- for( i=0; i<m_page1.m_List3.GetItemCount (); i++)
- {
- str=m_page1.m_List3.GetItemText (i, 1);
- str.TrimLeft (); str.TrimRight ();
- if(str.IsEmpty ())continue;
- content+=str;
- content+=",";
- }
- content.TrimRight (",");
- if(content!="")
- {
- phone=m_phone1+" "+m_phone2;
- phone.TrimLeft ();
- if(m_clothescount!="")
- clothescount="服装:"+m_clothescount;
- sql2.Format ("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[content],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s','%s')",
- m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,date,4,"未到",content,id);
- sql+=sql2;
- }
- }
- ////////////////////////////
- g_sendhead.bsql=1;
- g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
- }
- #endif
- AfxMessageBox("保存成功!", MB_ICONINFORMATION);
- CString m_type = m_page3.m_type;
- if (m_type == 1 || m_type == 3)
- {
- if (m_type == 1)
- {
- CString m_point;
- m_point.Format("%d", atol(m_taoxijiage));
- CString m_card2no = m_page3.m_memberno2;
- CString date2 = m_page3.m_memberno2date;
- CString m_name = m_page3.m_membernoname;
- CString m_sex = m_page3.m_membernosex;
- CString m_phone = m_page3.m_membernophone;
- CString sql;
- sql = "delete from membercard2 where [card2no]='" + m_card2no + "'";
- sql += "@@@insert into memberreg([memberno],[dindanid],[money],[date],[card2no],[type],[taoxi],[date2])values('" + m_memberno + "','" + id + "','" + m_point + "','" + g_date + "','" + m_card2no + "','转介绍','" + taoxiname + "','" + date2 + "')";
- sql += "@@@";
- m_point.Format("%d", (int)(atof(m_taoxijiage)*GetPointScale()));
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(51)))
- {
- CString m_content5 = g_cominfoarray.ElementAt(0).ElementAt(52);
- CString content, timestamp;
- CString name;
- if (!m_name1.IsEmpty())
- name = m_name1 + ",";
- name += m_name2;
- name.TrimRight(",");
- CString name2 = m_name;
- #ifndef CHILD_VERSION
- if(m_sex=="男")
- name2+="先生";
- else if(m_sex=="女")
- name2+="女士";
- #endif
- content.Format("%s您好,您的朋友%s为您积分%s分.", name2, name, m_point);
- content += m_content5;
- timestamp = "msgtimestamp";
- if (CheckPhoneType(m_phone) != -1 && CheckBadWords(content, 0))
- {
- int count = GetLengthEx(content) / MSG_LENGTH;
- if (GetLengthEx(content) % MSG_LENGTH)
- count++;
- CString scount;
- scount.Format("%d", count);
- #if JEFF_TEST_ON
- CString sql2 = _T("");
- sql2.Format(INSERT_SENDREG, _T("5"), m_phone, content, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
- sql += sql2;
- #else
- CString sql2="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+content+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
- sql+=sql2;
- #endif
- sql += "@@@";
- }
- }
- sql += m_memberno;
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- }
- else if (m_type == 3)
- {
- CString m_rate;
- CString filter = "[memberno]='" + m_memberno + "'";
- g_sendhead.bsql = 0;
- g_sendhead.code[0] = 132;
- g_sendhead.tabcount = 1;
- g_pMainWnd->ProcessChatMessageRequest2(filter); if (g_bSendOK == 0)return;
- DataToArray(&g_List1array);
- CString m_bluescale1;
- CString m_bluescale2;
- CString m_bluescale3;
- CString m_bluescale4;
- CString m_bluescale5;
- CString m_bluescale6;
- CString m_bluescale7;
- CString m_bluescale8;
- CString m_bluescale9;
- CString m_bluescale10;
- CString str = (g_cominfoarray.ElementAt(0).ElementAt(119));
- if (str == "")
- str = "5,10,15,20,50,0,0,0,0,0";
- int pos = str.Find(",");
- m_bluescale1 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(",");
- m_bluescale2 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(",");
- m_bluescale3 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(",");
- m_bluescale4 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(",");
- m_bluescale5 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(",");
- m_bluescale6 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(",");
- m_bluescale7 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(",");
- m_bluescale8 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(",");
- m_bluescale9 = str.Left(pos);
- str = str.Right(str.GetLength() - pos - 1);
- m_bluescale10 = str.Left(pos);
- if (g_List1array.GetSize() % 10 == 0)
- m_rate = m_bluescale1 + "%";
- else if (g_List1array.GetSize() % 10 == 1)
- m_rate = m_bluescale2 + "%";
- else if (g_List1array.GetSize() % 10 == 2)
- m_rate = m_bluescale3 + "%";
- else if (g_List1array.GetSize() % 10 == 3)
- m_rate = m_bluescale4 + "%";
- else if (g_List1array.GetSize() % 10 == 4)
- m_rate = m_bluescale5 + "%";
- else if (g_List1array.GetSize() % 10 == 5)
- m_rate = m_bluescale6 + "%";
- else if (g_List1array.GetSize() % 10 == 6)
- m_rate = m_bluescale7 + "%";
- else if (g_List1array.GetSize() % 10 == 7)
- m_rate = m_bluescale8 + "%";
- else if (g_List1array.GetSize() % 10 == 8)
- m_rate = m_bluescale9 + "%";
- else if (g_List1array.GetSize() % 10 == 9)
- m_rate = m_bluescale10 + "%";
- else
- m_rate = "0%";
- float frate = atof(m_rate) / 100.0;
- CString m_point;
- m_point.Format("%d", (int)(min(atof(m_taoxijiage), atof(m_page3.m_membernojiage))*frate));
- BOOL bCheck = 1;
- if (atof(m_taoxijiage) < atof(m_page3.m_membernojiage))
- {
- AfxMessageBox("此套系金额小于主套系,无法返现!");
- bCheck = 0;
- }
- if (bCheck)
- {
- CString m_card2no = m_page3.m_memberno2;
- CString date2 = m_page3.m_memberno2date;
- CString m_name = m_page3.m_membernoname;
- CString m_sex = m_page3.m_membernosex;
- CString m_phone = m_page3.m_membernophone;
- CString sql;
- sql = "delete from membercard2blue where [card2no]='" + m_card2no + "'";
- sql += "~~~insert into memberregblue([memberno],[dindanid],[money],[date],[card2no],[type],[taoxi],[date2])values('" + m_memberno + "','" + id + "','" + m_point + "','" + g_date + "','" + m_card2no + "','转介绍','" + taoxiname + "','" + date2 + "')";
- sql += "~~~";
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(51)))
- {
- CString m_content5 = g_cominfoarray.ElementAt(0).ElementAt(52);
- CString content, timestamp;
- CString name;
- if (!m_name1.IsEmpty())
- name = m_name1 + ",";
- name += m_name2;
- name.TrimRight(",");
- CString name2 = m_name;
- #ifndef CHILD_VERSION
- if(m_sex=="男")
- name2+="先生";
- else if(m_sex=="女")
- name2+="女士";
- #endif
- content.Format("%s您好,您的朋友%s为您返现金%s元.", name2, name, m_point);
- content += m_content5;
- timestamp = "msgtimestamp";
- if (CheckPhoneType(m_phone) != -1 && CheckBadWords(content, 0))
- {
- int count = GetLengthEx(content) / MSG_LENGTH;
- if (GetLengthEx(content) % MSG_LENGTH)
- count++;
- CString scount;
- scount.Format("%d", count);
- #if JEFF_TEST_ON
- CString sql2 = _T("");
- sql2.Format(INSERT_SENDREG, _T("5"), m_phone, content, timestamp, scount, _T("0"), _T("0"), _T("0"), _T("系统自动发送"));
- sql += sql2;
- #else
- CString sql2="insert into sendreg([phones],[content],[timestamp],[msgcount],[status],[issended],[isautosend],[ren]) values('"+m_phone+"','"+content+"','"+timestamp+"','"+scount+"','0','0','0','系统自动发送')";
- sql+=sql2;
- #endif
- sql += "~~~";
- }
- }
- sql += m_memberno;
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- }
- }
- }
- CString phone;
- BOOL bNeedCard = 0;
- if (m_type == 1 || m_type == 2 || m_type == 3)
- bNeedCard = 1;
- if (m_memberno.IsEmpty())
- bNeedCard = 1;
- if (bNeedCard)
- {
- SelMemberType dlg;
- if (dlg.DoModal() == IDOK)
- {
- if (dlg.m_type == 0)
- {
- AddMember dlg;
- if (m_name2 != "")
- dlg.m_name = m_name2;
- else
- dlg.m_name = m_name1;
- if (m_phone2 != "")
- dlg.m_phone = m_phone2;
- else
- dlg.m_phone = m_phone1;
- if (m_birthday2 != "")
- dlg.m_birthday = m_birthday2;
- else
- dlg.m_birthday = m_birthday1;
- if (m_qq2 != "")
- dlg.m_qq = m_qq2;
- else
- dlg.m_qq = m_qq1;
- if (m_addr2 != "")
- dlg.m_addr = m_addr2;
- else
- dlg.m_addr = m_addr1;
- if (dlg.DoModal() == IDOK)
- {
- if (AfxMessageBox("会员添加成功,是否发放副卡?", MB_YESNO | MB_ICONINFORMATION) == IDYES)
- {
- InputCard2Dlg dlg2;
- dlg2.m_name = dlg.m_name;
- dlg2.m_no = dlg.m_memberno;
- dlg2.DoModal();
- }
- sql = "update dindan set [memberno]='" + dlg.m_memberno + "' where [id]='" + id + "'";
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- }
- }
- else
- {
- AddMember dlg;
- dlg.m_mode = 1;
- if (m_name2 != "")
- dlg.m_name = m_name2;
- else
- dlg.m_name = m_name1;
- if (m_phone2 != "")
- dlg.m_phone = m_phone2;
- else
- dlg.m_phone = m_phone1;
- if (m_birthday2 != "")
- dlg.m_birthday = m_birthday2;
- else
- dlg.m_birthday = m_birthday1;
- if (m_qq2 != "")
- dlg.m_qq = m_qq2;
- else
- dlg.m_qq = m_qq1;
- if (m_addr2 != "")
- dlg.m_addr = m_addr2;
- else
- dlg.m_addr = m_addr1;
- dlg.m_jiage = m_taoxijiage;
- if (dlg.DoModal() == IDOK)
- {
- if (AfxMessageBox("会员添加成功,是否发放副卡?", MB_YESNO | MB_ICONINFORMATION) == IDYES)
- {
- InputCard2Dlg dlg2;
- dlg2.m_mode = 1;
- dlg2.m_name = dlg.m_name;
- dlg2.m_no = dlg.m_memberno;
- dlg2.DoModal();
- }
- sql = "update dindan set [memberno]='" + dlg.m_memberno + "' where [id]='" + id + "'";
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- }
- }
- }
- }
- GetDlgItem(IDC_BUTprint)->EnableWindow(1);
- if (!m_bModify)
- GetDlgItem(IDC_BUTsave)->EnableWindow(0);
- }
- // Jeff 保存"预约单-修改"的数据;
- void Booking2::OnBUTsave2()//保存修改;
- {
- // TODO: Add your control notification handler code here
- if (!m_page1.CheckOK())
- {
- AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
- OnBUTinfo1(); return;
- }
- if (!m_page2.CheckOK())
- {
- AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
- OnBUTinfo2(); return;
- }
- if (!m_page3.CheckOK())
- {
- AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
- OnBUTinfo3(); return;
- }
- if (!m_page4.CheckOK())
- {
- AfxMessageBox("资料不全,打*号的项目必须填写!", MB_ICONINFORMATION);
- OnBUTinfo4(); return;
- }
- // 修改预约单的权限索引 == 1 ?
- #if JEFF_TEST_ON // [3/24/2015 Jeff]
- if ( m_page4.m_bModify )
- {
- Login2 dlg;
- dlg.m_mode = 4;
- if (dlg.DoModal() != IDOK)return;
- if (IsHasRightsnew2(1, dlg.m_rights) == 0)return;
- }
- else
- {
- if(IsHasRights2(1)==0)
- return;
- }
-
- #else // 不使用权限,使用实时密码;
- if(IsHasRights2(1)==0)
- return;
- #endif
- // TODO: Add your control notification handler code here
- CString id = m_id;
- CString m_taoxiid = m_page1.m_taoxiid;
- CString taoxiname = m_page1.m_taoxiname;
- CString m_growthtxselname = m_page1.m_growthtxselname;
- CString m_taoxijiage = m_page1.m_taoxijiage;
- CString m_payed1 = m_page1.m_payed1;
- // CString m_zs=m_page1.m_zs;
- CString m_zs = m_page1.m_zs + "\\" + m_page1.m_zs2;
- CString txtype = m_page1.m_txtype;
- CString m_bz = m_page1.m_bz;
- CString bm = m_page3.m_bm;
- CString ren = m_page3.m_ren;
- CString m_clothescount = m_page3.m_clothescount;
- CString m_clothescount2 = m_page3.m_clothescount2;
- CString m_outside = m_page3.m_outside;
- CString m_outside2 = m_page3.m_outside2;
- CString m_style = m_page3.m_style;
- CString strmoney = "0";
- BOOL m_bGrowthTX = m_page1.m_bGrowthTX;
- #ifdef LKAY_VERSION
- CString m_dindantype=m_page1.m_dindantype;
- CString m_contractno=m_page1.m_contractno;
- CString m_contractno2=m_page1.m_contractno2;
- CString m_cfno=m_page3.m_cfno;
- CString m_from=m_page3.m_from;
- CString m_reason=m_page3.m_reason;
- CString m_time7=m_page4.m_time7;
- CString m_waiter12=m_page4.m_waiter12;
- CString m_waiter13=m_page4.m_waiter13;
- CString m_waiter14=m_page4.m_waiter14;
- #else
- CString m_from = m_page1.m_from;
- #endif
- #ifdef CHILD_VERSION
- CString m_name1 = m_page2.m_name1;
- CString m_name2 = m_page2.m_name2;
- CString m_phone1 = m_page2.m_phone1;
- CString m_phone2 = m_page2.m_phone2;
- CString m_qq1 = m_page2.m_qq1;
- CString m_addr1 = m_page2.m_addr1;
- CString m_birthday1 = m_page2.m_birthday1;
- CString m_area = m_page2.m_area;
- BOOL m_check1 = m_page2.m_check1;
- CString m_zodiac = m_page2.m_zodiac;
- CString m_sex = m_page2.m_sex;
- #else
- CString m_name1=m_page2.m_name1;
- CString m_name2=m_page2.m_name2;
- CString m_phone1=m_page2.m_phone1;
- CString m_phone2=m_page2.m_phone2;
- CString m_qq1=m_page2.m_qq1;
- CString m_qq2=m_page2.m_qq2;
- CString m_addr1=m_page2.m_addr1;
- CString m_addr2=m_page2.m_addr2;
- CString m_occupation1=m_page2.m_occupation1;
- CString m_occupation2=m_page2.m_occupation2;
- CString m_birthday1=m_page2.m_birthday1;
- CString m_birthday2=m_page2.m_birthday2;
- CString m_area=m_page2.m_area;
- CString m_area2=m_page2.m_area2;
- BOOL m_check1=m_page2.m_check1;
- BOOL m_check2=m_page2.m_check2;
- #endif
- CString m_time1 = m_page4.m_time1;
- CString m_time2 = m_page4.m_time2;
- CString m_time3 = m_page4.m_time3;
- CString m_time4 = m_page4.m_time4;
- CString m_time5 = m_page4.m_time5;
- CString m_time6 = m_page4.m_time6;
- CString m_time8 = m_page4.m_time8;
- CString m_time9 = m_page4.m_time9;
- CString m_time10 = m_page4.m_time10;
- CString m_time2old = m_page4.m_time2old;
- CString m_time4old = m_page4.m_time4old;
- CString m_time5old = m_page4.m_time5old;
- CString m_time6old = m_page4.m_time6old;
- CString m_waiter1 = m_page4.m_waiter1;
- CString m_waiter2 = m_page4.m_waiter2;
- CString m_waiter3 = m_page4.m_waiter3;
- CString m_waiter4 = m_page4.m_waiter4;
- CString m_waiter5 = m_page4.m_waiter5;
- CString m_waiter7 = m_page4.m_waiter7;
- CString m_waiter8 = m_page4.m_waiter8; //Jeff 看版人 waiter8
- CString m_status1 = m_page4.m_status1;
- CString m_status2 = m_page4.m_status2;
- CString m_status3 = m_page4.m_status3;
- CString m_status4 = m_page4.m_status4;
- CString m_status5 = m_page4.m_status5;
- CString m_status6 = m_page4.m_status6;
- CString m_status8 = m_page4.m_status8; // Jeff 看版状态 status8
- BOOL m_check3 = m_page4.m_check3;
- CString waiter3_old = m_page4.m_waiter3_old;// Jeff add;
- CString sql, str, str2;
- CString strRes1, strRes2;
- GetFirstLetter(m_name1, strRes1);
- GetFirstLetter(m_name2, strRes2);
- CString m_memberno = m_page3.m_memberno;
- if (m_page3.m_type == 1 || m_page3.m_type == 3)//副卡
- m_memberno = m_page3.m_memberno2;
- CString m_membernotemp = m_memberno;
- if (m_page3.m_type)m_memberno.Empty();
- #if 0 // Jeff Old Edition
- sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s' where id='%s' ",
- m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
- m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,
- bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,m_from,id);
- #else // Jeff update;
- if (waiter3_old == m_waiter3)// 选片人未更改;
- {
- sql.Format("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s', taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s' where id='%s' ",
- m_name1, m_name2, m_taoxiid, taoxiname, m_zs, m_time2, m_time3, m_time4, m_time5, m_time6, m_time8, m_time9, m_time10,
- m_waiter1, m_waiter2, m_waiter3, m_waiter4, m_waiter5, g_user.name, m_waiter7, m_waiter8, m_status1, m_status2, m_status3, m_status4, m_status5, m_status6, m_status8,
- bm, ren, FilterBZ(m_bz), strRes1, strRes2, m_clothescount, m_clothescount2, m_outside, m_outside2, m_style, m_taoxijiage, txtype, m_growthtxselname, m_phone1, m_phone2, m_memberno, m_from, id);
- }
- else
- {
- sql.Format("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s', taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[from]='%s',[xplrr]='%s',[xplrtime]='msgtimestamp2' where id='%s' ",
- m_name1, m_name2, m_taoxiid, taoxiname, m_zs, m_time2, m_time3, m_time4, m_time5, m_time6, m_time8, m_time9, m_time10, m_waiter1, m_waiter2, m_waiter3, m_waiter4, m_waiter5, g_user.name, m_waiter7, m_waiter8,
- m_status1, m_status2, m_status3, m_status4, m_status5, m_status6, m_status8, bm, ren, FilterBZ(m_bz), strRes1, strRes2, m_clothescount, m_clothescount2, m_outside, m_outside2, m_style, m_taoxijiage, txtype, m_growthtxselname, m_phone1, m_phone2, m_memberno, m_from, g_user.name, id
- );
- }
- // Jeff.add 2014.08.30;
- CString strSQL;
- if (m_status1 == "OK") // 若整体的订单拍照状态为OK,则设置订单下所有景点的拍照状态都为OK;
- {
- strSQL.Format("***update dindanjd set status='OK' where id='%s'", id);
- sql += strSQL;
- }
- #endif
- #ifdef LKAY_VERSION
- #if 0// Jeff Old Edition
- sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s' where id='%s' ",
- m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
- m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,
- bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,
- m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,id);
- #else // Jeff update
- if(waiter3_old == m_waiter3)
- {
- sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s' where id='%s' ",
- m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
- m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,m_status8,
- bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,
- m_phone1,m_phone2,m_memberno,m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,id);
- }
- else
- {
- sql.Format ("update dindan set name1='%s',name2='%s',taoxiid='%s',taoxiname='%s',taoxizs='%s',time2='%s',time3='%s',time4='%s',time5='%s',time6='%s',time8='%s',time9='%s',time10='%s',waiter1='%s',waiter2='%s',waiter3='%s',waiter4='%s',waiter5='%s',waiter6='%s',waiter7='%s',waiter8='%s',status='%s',status2='%s',status3='%s',status4='%s',status5='%s',status6='%s',status8='%s',bm='%s',ren='%s',bz='%s',pinyin1='%s',pinyin2='%s',clothescount='%s',clothescount2='%s',outside='%s',outside2='%s',style='%s',taoxijiage='%s',txtype='%s',growthtxselname='%s',[phone1]='%s',[phone2]='%s',[memberno]='%s',[dindantype]='%s',[contractno1]='%s',[contractno2]='%s',[cfno]='%s',[from]='%s',[reason]='%s',[time7]='%s',[waiter12]='%s',[waiter13]='%s',[waiter14]='%s',[xplrr]='%s',[xplrtime]='msgtimestamp2' where id='%s' ",
- m_name1,m_name2,m_taoxiid,taoxiname,m_zs,m_time2,m_time3,m_time4,m_time5,m_time6,m_time8,m_time9,m_time10,
- m_waiter1,m_waiter2,m_waiter3,m_waiter4,m_waiter5,g_user.name,m_waiter7,m_waiter8,
- m_status1,m_status2,m_status3,m_status4,m_status5,m_status6,m_status8,
- bm,ren,FilterBZ(m_bz),strRes1,strRes2,m_clothescount,m_clothescount2,
- m_outside,m_outside2,m_style,m_taoxijiage,txtype,m_growthtxselname,m_phone1,m_phone2,m_memberno,
- m_dindantype,m_contractno,m_contractno2,m_cfno,m_from,m_reason,m_time7,m_waiter12,m_waiter13,m_waiter14,g_user.name,id);
- }
- #endif
- #endif
- #if JEFF_TEST_ON
- // 2015-05-30 若取件状态OK,写日志;
- if ( m_status3 == _T("OK") )
- {
- CString strLog;
- strLog.Format(_T(" 订单:%s 在预约修改中被设置为取件OK"),id);
- WriteLog(strLog);
- }
- #endif
- CString sql2;
- #ifdef CHILD_VERSION
- sql2.Format("***update [client] set [name1]='%s',[name2]='%s',[phone1]='%s',[phone2]='%s',[qq1]='%s',[addr1]='%s',[birthday1]='%s',[area]='%s',[sex]='%s',[zodiac]='%s',[check1]='%d' where [id]='%s' ",
- m_name1, m_name2, m_phone1, m_phone2, m_qq1, m_addr1, m_birthday1, m_area, m_sex, m_zodiac, m_check1, id);
- #else
- sql2.Format ("***update [client] set [name1]='%s',[name2]='%s',[phone1]='%s',[phone2]='%s',[qq1]='%s',[qq2]='%s',[addr1]='%s',[addr2]='%s',[occupation1]='%s',[occupation2]='%s',[birthday1]='%s',[birthday2]='%s',[area]='%s',[area2]='%s',[check1]='%d',[check2]='%d',[check3]='%d' where [id]='%s' ",
- m_name1,m_name2,m_phone1,m_phone2,m_qq1,m_qq2,m_addr1,m_addr2,m_occupation1,m_occupation2,m_birthday1,m_birthday2,m_area,m_area2,m_check1,m_check2,m_check3,id);
- #endif
- sql += sql2;
- ////////////////////////
- if (atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本
- {
- CString timestamp;
- CTime tm = CTime::GetCurrentTime();
- CTimeSpan dt(0, 0, 0, 1);
- timestamp = tm.Format("%Y%m%d%H%M%S");
- CString phone, clothescount;
- if (m_time2 != "" && m_time2old != m_time2)
- {
- phone = m_phone1 + " " + m_phone2;
- phone.TrimLeft();
- if (m_clothescount != "")
- clothescount = "服装:" + m_clothescount;
- if (m_time2old == "")
- sql2.Format("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time2, 0, "未到", id);
- else
- sql2.Format("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time2, id, 0);
- sql += sql2;
- // AfxMessageBox(sql2);
- }
- if (m_time4 != "" && m_time4old != m_time4)
- {
- tm += dt;
- timestamp = tm.Format("%Y%m%d%H%M%S");
- phone = m_phone1 + " " + m_phone2;
- phone.TrimLeft();
- if (m_clothescount != "")
- clothescount = "服装:" + m_clothescount;
- if (m_time4old == "")
- sql2.Format("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time4, 1, "未到", id);
- else
- sql2.Format("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time4, id, 1);
- sql += sql2;
- }
- if (m_time6 != "" && m_time6old != m_time6)
- {
- tm += dt;
- timestamp = tm.Format("%Y%m%d%H%M%S");
- phone = m_phone1 + " " + m_phone2;
- phone.TrimLeft();
- if (m_clothescount != "")
- clothescount = "服装:" + m_clothescount;
- if (m_time6old == "")
- sql2.Format("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time6, 2, "未到", id);
- else
- sql2.Format("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time6, id, 2);
- sql += sql2;
- }
- if (m_time5 != "" && m_time5old != m_time5)
- {
- tm += dt;
- timestamp = tm.Format("%Y%m%d%H%M%S");
- phone = m_phone1 + " " + m_phone2;
- phone.TrimLeft();
- if (m_clothescount != "")
- clothescount = "服装:" + m_clothescount;
- if (m_time5old == "")
- sql2.Format("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1 + m_name2, phone, "", taoxiname, m_taoxijiage, m_waiter1, m_waiter2, ren, m_taoxijiage, clothescount, g_user.name, timestamp, m_time5, 3, "未到", id);
- else
- sql2.Format("***update [todaytake] set [date]='%s' where [id]='%s' and [mode]='%d'", m_time5, id, 3);
- sql += sql2;
- }
- }
- ////////////////////////////
- #ifndef CHILD_VERSION
- if(m_time3.IsEmpty ()==0)
- {
- CString date=m_time3;
- CString date2;
- if(m_check3)
- CovertDate(date, date2);
- sql2.Format ("***update dindansp set hqdate='%s' where id='%s' and hqdate is null", date, id);
- sql+=sql2;
- if(0)//atoi(g_cominfoarray.ElementAt(0).ElementAt(117)))//新摄控本
- {
- CString timestamp;
- CTime tm=CTime::GetCurrentTime ();
- CTimeSpan dt(0,0,0,10);
- tm+=dt;
- timestamp=tm.Format ("%Y%m%d%H%M%S");
- CString phone,clothescount,content;
- for(int i=0; i<m_page1.m_List3.GetItemCount (); i++)
- {
- str=m_page1.m_List3.GetItemText (i, 2);
- str.TrimLeft (); str.TrimRight ();
- if(str.IsEmpty ())continue;
- content+=str;
- content+=",";
- }
- content.TrimRight (",");
- if(content!="")
- {
- phone=m_phone1+" "+m_phone2;
- phone.TrimLeft ();
- if(m_clothescount!="")
- clothescount="服装:"+m_clothescount;
- sql2.Format ("***insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[content])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')",
- m_name1+m_name2,phone,"",taoxiname,m_taoxijiage,m_waiter1,m_waiter2,ren,m_taoxijiage,clothescount,g_user.name,timestamp,date,4,"未到",content);
- sql+=sql2;
- }
- }
- ////////////////////////////
- }
- #endif
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- CArray<CStringArray, CStringArray>sparray;
- if (m_bGrowthTX)
- sparray.SetSize(m_page1.m_List1arraygrowthbak.GetSize() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount(), 1);
- else
- sparray.SetSize(m_page1.m_List1.GetItemCount() + m_page1.m_List3.GetItemCount() + m_page1.m_listbox1.GetCount(), 1);
- int realcount = 0;
- int i;
- if (m_bGrowthTX)
- {
- for (i = 0; i < m_page1.m_List1arraygrowthbak.GetSize(); i++)
- {
- int arraygrowthbaksize = m_page1.m_List1arraygrowthbak.ElementAt(i).GetSize();
- str = m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(2);
- str.TrimLeft();
- str.TrimRight();
- if (str.IsEmpty())
- continue;
- sparray.ElementAt(realcount).Add(id);
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(0));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(1));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(2));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(3));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(4));
- sparray.ElementAt(realcount).Add("1");
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(5));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(6));
- sparray.ElementAt(realcount).Add(m_page1.m_List1arraygrowthbak.ElementAt(i).ElementAt(arraygrowthbaksize - 1));
- realcount++;
- }
- }
- else
- {
- for (i = 0; i < m_page1.m_List1.GetItemCount(); i++)
- {
- str = m_page1.m_List1.GetItemText(i, 2);
- str.TrimLeft(); str.TrimRight();
- if (str.IsEmpty())
- continue;
- sparray.ElementAt(realcount).Add(id);
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 0));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 1));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 2));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 3));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 4));
- sparray.ElementAt(realcount).Add("1");
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 5));
- sparray.ElementAt(realcount).Add(m_page1.m_List1.GetItemText(i, 6));
- realcount++;
- }
- }
- for (i = 0; i < m_page1.m_List3.GetItemCount(); i++)
- {
- str = m_page1.m_List3.GetItemText(i, 2);
- str.TrimLeft(); str.TrimRight();
- if (str.IsEmpty())continue;
- sparray.ElementAt(realcount).Add(id);
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 0));
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 1));
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 2));
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 3));
- sparray.ElementAt(realcount).Add(m_page1.m_List3.GetItemText(i, 4));
- sparray.ElementAt(realcount).Add("2");
- sparray.ElementAt(realcount).Add("");
- sparray.ElementAt(realcount).Add("");
- realcount++;
- }
- for (i = 0; i < m_page1.m_listbox1.GetCount(); i++)
- {
- m_page1.m_listbox1.GetText(i, str);
- sparray.ElementAt(realcount).Add(id);
- sparray.ElementAt(realcount).Add(str);
- realcount++;
- }
- sparray.SetSize(realcount, 1);
- if (realcount == 0)
- {
- sparray.SetSize(1, 1);
- sparray.ElementAt(0).Add(id);
- realcount++;
- }
- sparray.SetSize(realcount + 1, 1);
- sparray.ElementAt(realcount).Add(g_user.name);
- CMemFile memfile;
- CArchive ar(&memfile, CArchive::store);
- for (int ii = 0; ii < sparray.GetSize(); ii++)
- {
- sparray.ElementAt(ii).Serialize(ar);
- }
- ar.Close();
- int length = memfile.GetLength();
- BYTE *pData = memfile.Detach();
- int size = sparray.GetSize();
- BYTE *pData2 = new BYTE[length + sizeof(int)];
- memcpy(pData2, pData, length);
- memcpy(pData2 + length, &size, sizeof(int));
- delete[]pData;
- length += sizeof(int);
- g_nSendCode = 8;
- g_pMainWnd->ProcessChatMessageRequest2(pData2, length);
- g_nSendCode = 0;
- delete[]pData2;
- if (g_bSendOK == 0)return;
- #ifdef CHILD_VERSION
- if (m_time3.IsEmpty() == 0)
- {
- sql.Format("update dindansp set hqdate='%s' where id='%s'", m_time3, id);
- g_sendhead.bsql = 1;
- g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
- }
- #endif
- AfxMessageBox("保存成功!", MB_ICONINFORMATION);
- }
- void Booking2::OnBUTnew()
- {
- // TODO: Add your control notification handler code here
- m_page1.NewDan();
- m_page2.NewDan();
- m_page3.NewDan();
- m_page4.NewDan();
- OnBUTinfo1();
- GetDlgItem(IDC_BUTprint)->EnableWindow(0); GetDlgItem(IDC_BUTsave)->EnableWindow(1);
- }
- void Booking2::OnBUTprint()
- {
- // TODO: Add your control notification handler code here
- g_pMainWnd->PrintDinDan(m_page1.m_id);
- }
- void Booking2::OnBUTimport()
- {
- if (AfxMessageBox("是否导入订单?", MB_YESNO | MB_ICONINFORMATION) != IDYES)
- return;
- CFileDialog fdlg(true, NULL, "", OFN_HIDEREADONLY, "影楼订单文件(*.*)|*.dan||");
- if (fdlg.DoModal() != IDOK)
- return;
- CString path = fdlg.GetFileName();
- CArray<CStringArray, CStringArray>g_Sel1array[20];//精英团队
- CArray<CStringArray, CStringArray>g_Sel2array[20];//景点介绍
- CArray<CStringArray, CStringArray>g_Sel3array[20];//套系内容
- CArray<CStringArray, CStringArray>g_Sel4array[20];//产品展示
- CArray<CStringArray, CStringArray>g_Sel5array[20];//礼服介绍
- CString g_name1;
- CString g_name2;
- CString g_phone1;
- CString g_phone2;
- CString g_price1;
- CString g_price2;
- CString m_taoxiname;
- {
- CString str = path;
- int pos = str.Find(".");
- if (pos == -1)return;
- str = str.Left(pos);
- pos = str.Find(" ");
- if (pos == -1)return;
- g_name1 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(" ");
- if (pos == -1)return;
- g_name2 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(" ");
- if (pos == -1)return;
- g_phone1 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1);
- pos = str.Find(" ");
- if (pos == -1)return;
- g_phone2 = str.Left(pos); str = str.Right(str.GetLength() - pos - 1);
- }
- int length[100];
- CFile fp;
- fp.Open(path, CFile::modeRead);
- int fileleng = fp.GetLength();
- int memlength = fileleng - sizeof(int) * 100;
- for (int i = 0; i < 100; i++)
- fp.Read(length + i, sizeof(int));
- for (i = 0; i < 20; i++)
- g_Sel1array[i].SetSize(length[i]);
- for (i = 0; i < 20; i++)
- g_Sel2array[i].SetSize(length[20 + i]);
- for (i = 0; i < 20; i++)
- g_Sel3array[i].SetSize(length[40 + i]);
- for (i = 0; i < 20; i++)
- g_Sel4array[i].SetSize(length[60 + i]);
- for (i = 0; i < 20; i++)
- g_Sel5array[i].SetSize(length[80 + i]);
- BYTE *pData = new BYTE[memlength];
- fp.Read(pData, memlength);
- fp.Close();
- CMemFile memfile;
- memfile.Attach(pData, memlength);
- CArchive ar(&memfile, CArchive::load);
- for (i = 0; i < 20; i++)
- {
- for (int j = 0; j < length[i]; j++)
- g_Sel1array[i].ElementAt(j).Serialize(ar);
- }
- for (i = 0; i < 20; i++)
- {
- for (int j = 0; j < g_Sel2array[i].GetSize(); j++)
- g_Sel2array[i].ElementAt(j).Serialize(ar);
- }
- for (i = 0; i < 20; i++)
- {
- for (int j = 0; j < g_Sel3array[i].GetSize(); j++)
- g_Sel3array[i].ElementAt(j).Serialize(ar);
- }
- for (i = 0; i < 20; i++)
- {
- for (int j = 0; j < g_Sel4array[i].GetSize(); j++)
- g_Sel4array[i].ElementAt(j).Serialize(ar);
- }
- for (i = 0; i < 20; i++)
- {
- for (int j = 0; j < g_Sel5array[i].GetSize(); j++)
- g_Sel5array[i].ElementAt(j).Serialize(ar);
- }
- ar.Close();
- memfile.Detach();
- delete[]pData;
- if (g_Sel5array[19].GetSize())
- {
- g_price1 = g_Sel5array[19].ElementAt(0).ElementAt(0);
- g_price2 = g_Sel5array[19].ElementAt(0).ElementAt(1);
- }
- else
- {
- g_price1 = g_price2 = "";
- }
- CStringArray array;
- for (i = 0; i < 19; i++)
- {
- for (int j = 0; j < g_Sel3array[i].GetSize(); j++)
- {
- if (g_Sel3array[i].ElementAt(j).GetSize() < 2)continue;
- int count = g_Sel3array[i].ElementAt(j).GetSize();
- for (int a = 1; a < count; a++)
- {
- if (a == 1)
- {
- m_taoxiname = g_Sel3array[i].ElementAt(j).ElementAt(a);
- // m_combotaoxiname.InsertString (0, taoxiname);
- // m_combotaoxiname.SetCurSel (0);
- }
- else
- {
- CString str = g_Sel3array[i].ElementAt(j).ElementAt(a);
- CString dir, name;
- int pos = str.ReverseFind('\\');
- dir = str.Left(pos);
- name = str.Right(str.GetLength() - pos - 1);
- array.Add(name);
- }
- }
- }
- }
- for (i = 0; i < 19; i++)
- {
- for (int j = 0; j < g_Sel4array[i].GetSize(); j++)
- {
- int count = g_Sel4array[i].ElementAt(j).GetSize();
- for (int a = 1; a < count; a++)
- {
- array.Add(g_Sel4array[i].ElementAt(j).ElementAt(a));
- }
- }
- }
- for (i = 0; i < array.GetSize(); i++)
- {
- int pos = m_page1.m_List1.GetItemCount();
- CString str;
- if (pos)
- {
- if (m_page1.m_List1.GetItemText(pos - 1, 0).IsEmpty() && m_page1.m_List1.GetItemText(pos - 1, 1).IsEmpty())
- {
- pos--;
- m_page1.m_List1.SetItemText(pos, 0, "");
- m_page1.m_List1.SetItemText(pos, 1, array.ElementAt(i));
- m_page1.m_List1.SetItemText(pos, 2, "");
- m_page1.m_List1.SetItemText(pos, 3, "1");
- }
- else
- {
- m_page1.m_List1.InsertItem(pos, "");
- m_page1.m_List1.SetItemText(pos, 1, array.ElementAt(i));
- m_page1.m_List1.SetItemText(pos, 2, "");
- m_page1.m_List1.SetItemText(pos, 3, "1");
- }
- }
- else
- {
- m_page1.m_List1.InsertItem(pos, "");
- m_page1.m_List1.SetItemText(pos, 1, array.ElementAt(i));
- m_page1.m_List1.SetItemText(pos, 2, "");
- m_page1.m_List1.SetItemText(pos, 3, "1");
- }
- }
- if (g_Sel5array[19].GetSize())
- {
- g_price1 = g_Sel5array[19].ElementAt(0).ElementAt(0);
- g_price2 = g_Sel5array[19].ElementAt(0).ElementAt(1);
- }
- else
- {
- g_price1 = g_price2 = "";
- }
- OnBUTnew();
- m_page1.m_taoxiname = m_taoxiname;
- m_page1.m_taoxijiage = g_price1;
- m_page1.m_payed1 = g_price2;
- m_page1.UpdateData(0);
- m_page2.m_name1 = g_name1;
- m_page2.m_name2 = g_name2;
- m_page2.m_phone1 = g_phone1;
- m_page2.m_phone2 = g_phone2;
- m_page2.UpdateData(0);
- }
- BOOL Booking2::PreTranslateMessage(MSG* pMsg)
- {
- // TODO: Add your specialized code here and/or call the base class
- try
- {
- if (pMsg->message == WM_KEYDOWN)
- {
- switch (pMsg->wParam)
- {
- case VK_ESCAPE:
- if (m_bModify)CDialog::OnCancel();
- return 1;
- }
- }
- return CDialog::PreTranslateMessage(pMsg);
- }
- catch (...)
- {
- }
- }
|