123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609 |
- // CostCal.cpp : implementation file
- //
- #include "stdafx.h"
- #include "ylgl.h"
- #include "CostCal.h"
- #include "MyMdi.H"
- #include "ModifyDinDan.h"
- #include "InputPsw.h"
- #include "ImportPhoto.h"
- #include "ImportPhoto.h"
- #include "outsourcingDlg.h"
- #include "outsourcingDlg2.h"
- #include "outsourcing2.h"
- #include "outsourcing3.h"
- #include "outsourcing4.h"
- #ifdef _DEBUG
- #define new DEBUG_NEW
- #undef THIS_FILE
- static char THIS_FILE[] = __FILE__;
- #endif
- #pragma comment(lib, "Shlwapi.lib")
- /////////////////////////////////////////////////////////////////////////////
- // CostCal
- IMPLEMENT_DYNCREATE(CostCal, MyFormView)
- CostCal::CostCal()
- : MyFormView(CostCal::IDD)
- {
- //{{AFX_DATA_INIT(CostCal)
- m_filter = _T("");
- m_date2 = GetTmFromStr(g_date);
- m_date1 = m_date2-CTimeSpan(30, 0, 0, 0);
- //}}AFX_DATA_INIT
- } //m_date1 = m_date2-CTimeSpan(30, 0, 0, 0);
- CostCal::~CostCal()
- {
- }
- void CostCal::DoDataExchange(CDataExchange* pDX)
- {
- MyFormView::DoDataExchange(pDX);
- //{{AFX_DATA_MAP(CostCal)
- DDX_Control(pDX, IDC_COMBO1, m_combo1);
- DDX_Control(pDX, IDC_LIST2, m_List1);
- DDX_Control(pDX, IDC_STATIC1, m_static1);
- DDX_CBString(pDX, IDC_COMBO1, m_filter);
- DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_date1);
- DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER2, m_date2);
- //}}AFX_DATA_MAP
- }
- BEGIN_MESSAGE_MAP(CostCal, MyFormView)
- //{{AFX_MSG_MAP(CostCal)
- ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
- ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
- ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
- ON_WM_TIMER()
- ON_NOTIFY(NM_CLICK, IDC_LIST2, OnClickList2)
- ON_NOTIFY(DTN_DATETIMECHANGE, IDC_DATETIMEPICKER1, OnDatetimechangeDatetimepicker1)
- ON_NOTIFY(DTN_DATETIMECHANGE, IDC_DATETIMEPICKER2, OnDatetimechangeDatetimepicker2)
- //}}AFX_MSG_MAP
- ON_NOTIFY(NM_CUSTOMDRAW, IDC_LIST2, OnCustomdrawList)
- END_MESSAGE_MAP()
- /////////////////////////////////////////////////////////////////////////////
- // CostCal diagnostics
- #ifdef _DEBUG
- void CostCal::AssertValid() const
- {
- MyFormView::AssertValid();
- }
- void CostCal::Dump(CDumpContext& dc) const
- {
- MyFormView::Dump(dc);
- }
- #endif //_DEBUG
- /////////////////////////////////////////////////////////////////////////////
- // CostCal message handlers
- void CostCal::OnInitialUpdate()
- {
- MyFormView::OnInitialUpdate();
- // TODO: Add your specialized code here and/or call the base class
- CMyMdi Mdi;
- Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);
-
- // Here we create the outbar control using the splitter as its parent
- // and setting its id to the first pane.
- CRect rc2;
- GetWindowRect(rc2);
- ::MoveWindow(m_hWnd,g_rc.left,g_rc.top,g_rc.Width(),g_rc.Height(),TRUE);
- EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc,0);
-
- m_static1.SetFont (&g_titlefont);
- #ifdef CHILD_VERSION
- m_List1.SetHeadings("订单号,100;家长姓名,100;宝宝姓名,100;接单人,100;售价,100;成本,100;商品名称,100;单价,100;数量,100" );
- #else
- m_List1.SetHeadings("订单号,100;男宾姓名,100;女宾姓名,100;接单人,100;售价,100;成本,100;商品名称,100;单价,100;数量,100" );
- #endif
- m_List1.LoadColumnInfo (321);
- m_List1.m_bSortSupport=0;
- GetData(); // 与服务器通信,获取信息;
- for(int i=0; i<g_userarray.GetSize (); i++)
- {
- m_combo1.AddString (g_userarray.ElementAt (i).ElementAt (1) );
- }
-
- m_combo1.GetWindowRect (rc2);
- ScreenToClient(rc2);
- rc2.bottom +=200;
- m_combo1.MoveWindow (rc2);
- GetDlgItem(IDC_BUTclose)->GetWindowRect(rc2);
- SetComboHei(&m_combo1, rc2.Height ());
- }
- void CostCal::FillGrid()
- {
- m_List1.DeleteAllItems2 ();
- int ii=0;
- m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
- int count=0;
- if(m_filter.IsEmpty ())
- {
- for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
- {
- m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
- }
- }
- else
- {
- BOOL bFinded=0;
- for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
- {
- if(bFinded && m_List1array.ElementAt (ii).ElementAt (0).IsEmpty ())
- {
- m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
- continue;
- }
- if(m_List1array.ElementAt (ii).ElementAt (3)==m_filter )
- {
- bFinded=1;
- m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
- }
- else
- {
- bFinded=0;
- }
- }
- }
- m_List1.m_arLabels.SetSize(count, 1);
- ii=count;
- m_List1.m_LabelCount=ii;
- m_List1.SetItemCountEx (ii);
-
- double fsumcost=0;
- double fsumsale=0;
- float fcost=0;
- float fprice=0;
- int cot=0;
- CString scost;
- for(int i=m_List1.m_arLabels.GetSize ()-1; i>=0; i--)
- {
- fprice=GetSPPriceFromName(m_List1.m_arLabels.ElementAt (i).ElementAt (6));
- fcost+=atof(m_List1.m_arLabels.ElementAt (i).ElementAt (8))*fprice;
- scost.Format ("%0.2f", fprice);
-
- if(m_List1.m_arLabels.ElementAt (i).ElementAt (0)!="")
- {
- fsumcost+=fcost;
- fsumsale+=atof(m_List1.m_arLabels.ElementAt (i).ElementAt (4));
- scost.Format ("%0.2f", fcost);fcost=0;
-
- cot++;
- }
- }
- scost.Format ("%d", (int)fsumsale);
- SetDlgItemText(IDC_EDITmoney2, scost);
- scost.Format ("%d", (int)fsumcost);
- SetDlgItemText(IDC_EDITmoney3, scost);
- scost.Format ("%d", (int)(fsumsale-fsumcost));
- SetDlgItemText(IDC_EDITmoney4, scost);
-
- scost.Format ("%d", (int)(fsumsale/cot));
- SetDlgItemText(IDC_EDITmoney5, scost);
- scost.Format ("%d", (int)(fsumcost/cot));
- SetDlgItemText(IDC_EDITmoney6, scost);
- scost.Format ("%d", (int)((fsumsale-fsumcost)/cot));
- SetDlgItemText(IDC_EDITmoney7, scost);
-
- scost.Format ("%d", cot);
- SetDlgItemText(IDC_EDIT1, scost);
- ///////////////////////////////////////////////
- CString srate;
- if(fsumsale>0.1)
- {
- srate.Format("%0.1f", 100.0*(fsumsale-fsumcost)/fsumsale);
- srate+="%";
- }
- else
- srate="100%";
-
-
- scost.Format ("单数:%d 总售价:%d 总成本:%d 毛利:%d 毛利率:%s 平均售价:%d 平均成本:%d 平均毛利:%d",
- cot, (int)fsumsale, (int)fsumcost, (int)(fsumsale-fsumcost), srate,(int)(fsumsale/cot), (int)(fsumcost/cot), (int)((fsumsale-fsumcost)/cot));
- SetDlgItemText(IDC_EDIT1, scost);
-
- if(!g_id.IsEmpty ())
- {
- for(int i=0; i<m_List1.GetItemCount (); i++)
- {
- if(g_id==m_List1.GetItemText (i, 0))
- {
- m_List1.SetItemState(i,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);
- m_List1.EnsureVisible(i,FALSE);
- break;
- }
- }
- }
- }
- void CostCal::OnBUTclose()
- {
- // TODO: Add your control notification handler code here
- GetParent()->SendMessage(WM_CLOSE);
- }
- void CostCal::OnButton1()
- {
- // TODO: Add your control notification handler code here
- UpdateData();
- m_filter.TrimLeft ();
- m_filter.TrimRight ();
- FillGrid();
- }
- void CostCal::OnSelchangeCombo1()
- {
- // TODO: Add your control notification handler code here
- SetTimer(1, 100, NULL);
- }
- void CostCal::OnTimer(UINT nIDEvent)
- {
- // TODO: Add your message handler code here and/or call default
- KillTimer(nIDEvent);
- OnButton1();
- }
- BOOL CostCal::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_RETURN:
- OnButton1();
- return 1;
- case 0x43: // copy
- if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
- {
- GetFocus()->SendMessage(WM_COPY);
- return TRUE;
- }
- break;
- case 0x56: //Ctrl + V:
- if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
- {
- GetFocus()->SendMessage(WM_PASTE);
- return TRUE;
- }
- break;
- case 0x58: // cut
- if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
- {
- GetFocus()->SendMessage(WM_CUT);
- return TRUE;
- }
- break;
- case 0x5A: //undo
- case 0x59: //redo
- if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
- {
- GetFocus()->SendMessage(WM_UNDO);
- return TRUE;
- }
- break;
- }
- }
- return MyFormView::PreTranslateMessage(pMsg);
- }
- catch(...)
- {
- }
- }
- void CostCal::OnCustomdrawList ( NMHDR* pNMHDR, LRESULT* pResult )
- {
- NMLVCUSTOMDRAW* pLVCD = reinterpret_cast<NMLVCUSTOMDRAW*>( pNMHDR );
- // Take the default processing unless we set this to something else below.
- *pResult = 0;
- // First thing - check the draw stage. If it's the control's prepaint
- // stage, then tell Windows we want messages for every item.
- if ( CDDS_PREPAINT == pLVCD->nmcd.dwDrawStage )
- {
- *pResult = CDRF_NOTIFYITEMDRAW;
- }
- else if ( CDDS_ITEMPREPAINT == pLVCD->nmcd.dwDrawStage )
- {
- // This is the prepaint stage for an item. Here's where we set the
- // item's text color. Our return value will tell Windows to draw the
- // item itself, but it will use the new color we set here.
- // We'll cycle the colors through red, green, and light blue.
- COLORREF crText;
- int pos=pLVCD->nmcd.dwItemSpec;
- if(pos%2)
- pLVCD->clrTextBk = g_gridcol1;
- else
- pLVCD->clrTextBk = g_gridcol2;
- while(m_List1.m_arLabels.ElementAt (pos).ElementAt (0).IsEmpty ())
- {
- pos--;
- if(pos<1)break;
- }
- if(atof(m_List1.m_arLabels.ElementAt (pos).ElementAt (5))>atof(m_List1.m_arLabels.ElementAt (pos).ElementAt (4)))
- crText = RGB(220,0,0);
- else
- crText = RGB(20,133,20);
-
-
- // Store the color back in the NMLVCUSTOMDRAW struct.
- pLVCD->clrText = crText;
- // Tell Windows to paint the control itself.
- *pResult = CDRF_DODEFAULT;
- }
- }
- void CostCal::OnClickList2(NMHDR* pNMHDR, LRESULT* pResult)
- {
- // TODO: Add your control notification handler code here
- POSITION pos;
- pos=m_List1.GetFirstSelectedItemPosition();
- if(pos==NULL)
- {
- return;
- }
- int iItem=m_List1.GetNextSelectedItem(pos);
- g_id=m_List1.GetItemText (iItem, 0);
- while(g_id=="")
- {
- iItem--;
- g_id=m_List1.GetItemText (iItem, 0);
- }
- *pResult = 0;
- }
-
- void CostCal::GetData()
- {
- UpdateData();
- GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(0);
- GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(0);
- CString date1,date2;
- date1=m_date1.Format("%Y-%m-%d");
- date2=m_date2.Format("%Y-%m-%d");
-
- int g_nYearposTemp=g_nYearpos;
- int g_nYearposPre=-1;
- BOOL bNeedThisYear=0;
- if(g_nYearpos==-1 && g_hisyeararray.GetSize ())
- g_nYearposPre=0;
- if(g_nYearpos!=-1)
- bNeedThisYear=1;
-
- if(m_sparray.GetSize ()==0)
- {
- g_sendhead.bsql=0;
- g_sendhead.code[0]=224;
- g_sendhead.code[1]=4;
- g_sendhead.tabcount=2;
- CString filter="time1>='"+date1+"' and time1<='"+date2+"';";
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if(g_bSendOK==0)
- {
- GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
- GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
- g_nYearpos=g_nYearposTemp;
- return;
- }
- DataToArray(&m_List1array,&m_sparray);
- }
- else
- {
- g_sendhead.bsql=0;
- g_sendhead.code[0]=224;
- g_sendhead.tabcount=1;
- CString filter="time1>='"+date1+"' and time1<='"+date2+"'";
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if(g_bSendOK==0)
- {
- GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
- GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
- g_nYearpos=g_nYearposTemp;
- return;
- }
- DataToArray(&m_List1array);
- }
- if(bNeedThisYear)//加今年
- {
- g_nYearpos=-1;//今年
- CArray<CStringArray, CStringArray>ThisYearList1array;
- if(m_sparray.GetSize ()==0)
- {
- g_sendhead.bsql=0;
- g_sendhead.code[0]=224;
- g_sendhead.code[1]=4;
- g_sendhead.tabcount=2;
- CString filter="time1>='"+date1+"' and time1<='"+date2+"';";
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if(g_bSendOK==0)
- {
- GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
- GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
- g_nYearpos=g_nYearposTemp;
- return;
- }
- DataToArray(&ThisYearList1array,&m_sparray);
- }
- else
- {
- g_sendhead.bsql=0;
- g_sendhead.code[0]=224;
- g_sendhead.tabcount=1;
- CString filter="time1>='"+date1+"' and time1<='"+date2+"'";
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if(g_bSendOK==0)
- {
- GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
- GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
- g_nYearpos=g_nYearposTemp;
- return;
- }
- DataToArray(&ThisYearList1array);
- }
-
- int oldsize=m_List1array.GetSize ();
- m_List1array.SetSize(oldsize+ThisYearList1array.GetSize ());
- for(int i=oldsize; i<oldsize+ThisYearList1array.GetSize (); i++)
- {
- m_List1array.ElementAt (i).Copy(ThisYearList1array.ElementAt (i-oldsize));
- }
- }
- if(g_nYearposPre!=-1)//加去年
- {
- g_nYearpos=g_nYearposPre;
- CArray<CStringArray, CStringArray>ThisYearList1array;
- g_sendhead.bsql=0;
- g_sendhead.code[0]=224;
- g_sendhead.tabcount=1;
- CString filter="time1>='"+date1+"' and time1<='"+date2+"'";
- g_pMainWnd->ProcessChatMessageRequest2(filter);
- if(g_bSendOK==0)
- {
- GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
- GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
- g_nYearpos=g_nYearposTemp;
- return;
- }
- DataToArray(&ThisYearList1array);
- int oldsize=m_List1array.GetSize ();
- m_List1array.SetSize(oldsize+ThisYearList1array.GetSize ());
- for(int i=oldsize; i<oldsize+ThisYearList1array.GetSize (); i++)
- {
- m_List1array.ElementAt (i).Copy(ThisYearList1array.ElementAt (i-oldsize));
- }
- }
- g_nYearpos=g_nYearposTemp;
- // double fsumcost=0;
- // double fsumsale=0;
- float fcost=0;
- float fprice=0;
- // int cot=0;
- CString scost,name;
- for(int i=m_List1array.GetSize ()-1; i>=0; i--)
- {
- name=m_List1array.ElementAt (i).ElementAt (6);
- // name.MakeLower ();
- if(name.GetLength ()>2)
- {
- if(name.Right (2)=="x2"||name.Right (2)=="x3"||name.Right (2)=="x4"||name.Right (2)=="x5"||name.Right (2)=="x6"||name.Right (2)=="x7"||name.Right (2)=="x8"||name.Right (2)=="x9")
- {
- scost=name.Right (2);
- scost.Delete (0);
- name=name.Left (name.GetLength ()-2);
- // m_List1array.ElementAt (i).SetAt (6, name);
- m_List1array.ElementAt (i).SetAt (8, scost);
- }
- if(name.Right (2)=="X2"||name.Right (2)=="X3"||name.Right (2)=="X4"||name.Right (2)=="X5"||name.Right (2)=="X6"||name.Right (2)=="X7"||name.Right (2)=="X8"||name.Right (2)=="X9")
- {
- scost=name.Right (2);
- scost.Delete (0);
- name=name.Left (name.GetLength ()-2);
- // m_List1array.ElementAt (i).SetAt (6, name);
- m_List1array.ElementAt (i).SetAt (8, scost);
- }
- if(name.Right (3)=="X10")
- {
- scost=name.Right (3);
- scost.Delete (0);
- name=name.Left (name.GetLength ()-3);
- // m_List1array.ElementAt (i).SetAt (6, name);
- m_List1array.ElementAt (i).SetAt (8, scost);
- }
- if(name.Right (3)=="x10")
- {
- scost=name.Right (3);
- scost.Delete (0);
- name=name.Left (name.GetLength ()-3);
- // m_List1array.ElementAt (i).SetAt (6, name);
- m_List1array.ElementAt (i).SetAt (8, scost);
- }
- }
- fprice=GetSPPriceFromName(name);
- fcost+=atof(m_List1array.ElementAt (i).ElementAt (8))*fprice;
- scost.Format ("%0.2f", fprice);
- m_List1array.ElementAt (i).SetAt (7, scost);
- if(m_List1array.ElementAt (i).ElementAt (0)!="")
- {
- // fsumcost+=fcost;
- // fsumsale+=atof(m_List1array.ElementAt (i).ElementAt (4));
- scost.Format ("%0.2f", fcost);fcost=0;
- m_List1array.ElementAt (i).SetAt (5, scost);
- // cot++;
- }
- }
- /* scost.Format ("%d", (int)fsumsale);
- SetDlgItemText(IDC_EDITmoney2, scost);
- scost.Format ("%d", (int)fsumcost);
- SetDlgItemText(IDC_EDITmoney3, scost);
- scost.Format ("%d", (int)(fsumsale-fsumcost));
- SetDlgItemText(IDC_EDITmoney4, scost);
- scost.Format ("%d", (int)(fsumsale/cot));
- SetDlgItemText(IDC_EDITmoney5, scost);
- scost.Format ("%d", (int)(fsumcost/cot));
- SetDlgItemText(IDC_EDITmoney6, scost);
- scost.Format ("%d", (int)((fsumsale-fsumcost)/cot));
- SetDlgItemText(IDC_EDITmoney7, scost);
- scost.Format ("%d", cot);
- SetDlgItemText(IDC_EDIT1, scost);*/
- FillGrid();
- GetDlgItem(IDC_DATETIMEPICKER1)->EnableWindow(1);
- GetDlgItem(IDC_DATETIMEPICKER2)->EnableWindow(1);
- }
- float CostCal::GetSPPriceFromName(CString name)
- {
- int pos=name.Find (",");
- if(pos!=-1)
- {
- float fret=0.0;
- while(pos!=-1)
- {
- fret+=GetSPPriceFromName(name.Left (pos));
- name=name.Right (name.GetLength ()-pos-1);
- pos=name.Find (",");
- }
- fret+=GetSPPriceFromName(name);
- return fret;
- }
-
- for(int i=0; i<m_sparray.GetSize (); i++)
- {
- if(name==m_sparray.ElementAt (i).ElementAt (1))
- return atof(m_sparray.ElementAt (i).ElementAt (3));
- }
- return 0;
- }
- void CostCal::OnDatetimechangeDatetimepicker1(NMHDR* pNMHDR, LRESULT* pResult)
- {
- // TODO: Add your control notification handler code here
- GetData();
- *pResult = 0;
- }
- void CostCal::OnDatetimechangeDatetimepicker2(NMHDR* pNMHDR, LRESULT* pResult)
- {
- // TODO: Add your control notification handler code here
- GetData();
- *pResult = 0;
- }
-
|