// ShangPin.cpp : implementation file
//
#include "stdafx.h"
#include "LYFZIPManage.h"
#include "ShangPin.h"
#include "MyMdi.H"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// ShangPin

IMPLEMENT_DYNCREATE(ShangPin, CFormView)

ShangPin::ShangPin()
	: CFormView(ShangPin::IDD)
{
	//{{AFX_DATA_INIT(ShangPin)
	m_spbz = _T("");
	m_spdanwei = _T("");
	m_spid = _T("");
	m_spjiaga1 = _T("");
	m_spjiage2 = _T("");
	m_spname = _T("");
	m_autoid=0;
	//}}AFX_DATA_INIT
}

ShangPin::~ShangPin()
{
}

void ShangPin::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(ShangPin)
	DDX_Control(pDX, IDC_EDITspjiage2, m_editctrl2);
	DDX_Control(pDX, IDC_EDITspjiaga1, m_editctrl1);
	DDX_Control(pDX, IDC_COMBOsplb, m_combosplb);
	DDX_Control(pDX, IDC_LIST2, m_List1);
	DDX_Control(pDX, IDC_STATIC1, m_static1);
	DDX_Text(pDX, IDC_EDITspbz, m_spbz);
	DDX_Text(pDX, IDC_EDITspdanwei, m_spdanwei);
	DDX_Text(pDX, IDC_EDITspid, m_spid);
	DDX_Text(pDX, IDC_EDITspjiaga1, m_spjiaga1);
	DDX_Text(pDX, IDC_EDITspjiage2, m_spjiage2);
	DDX_Text(pDX, IDC_EDITspname, m_spname);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(ShangPin, CFormView)
	//{{AFX_MSG_MAP(ShangPin)
	ON_BN_CLICKED(IDC_BUTsave, OnBUTsave)
	ON_BN_CLICKED(IDC_BUTdel, OnBUTdel)
	ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
	ON_NOTIFY(NM_CLICK, IDC_LIST2, OnClickList2)
	ON_BN_CLICKED(IDC_BUTadd, OnBUTadd)
	ON_CBN_SELCHANGE(IDC_COMBOsplb, OnSelchangeCOMBOsplb)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// ShangPin diagnostics

#ifdef _DEBUG
void ShangPin::AssertValid() const
{
	CFormView::AssertValid();
}

void ShangPin::Dump(CDumpContext& dc) const
{
	CFormView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// ShangPin message handlers

void ShangPin::OnInitialUpdate() 
{
	CFormView::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_combosplb.GetWindowRect (rc2);
	ScreenToClient(rc2);
	rc2.bottom +=200;
	m_combosplb.MoveWindow (rc2);


	m_static1.SetFont (&g_titlefont);

	m_List1.SetHeadings( "编号, 50;商品名称, 100;单位, 50;进价, 50;卖价, 50;商品分类, 100" );
 	m_List1.LoadColumnInfo (100);

	g_sendhead.bsql=0;
	g_sendhead.code[0]=2;
	g_sendhead.code[1]=4;
	g_sendhead.tabcount=2;
	g_pMainWnd->ProcessChatMessageRequest2(2);if(g_bSendOK==0)return;
	DataToArray(&g_List1array, &m_List1array);

	for(int i=0; i<g_List1array.GetSize (); i++)
    	m_combosplb.AddString (g_List1array.ElementAt (i).ElementAt (0));

 	
	CString sql;
	sql="select max(spid) as cot from shangpin";
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
	m_autoid=g_ncount+1;
}

void ShangPin::OnSelchangeCOMBOsplb() 
{
	// TODO: Add your control notification handler code here
	int pos=m_combosplb.GetCurSel ();
	if(pos==-1)return;
	CString str;
	m_combosplb.GetLBText (pos, str);
	FillGrid(str);	
}

void ShangPin::FillGrid(CString str)
{
	m_List1.DeleteAllItems2 ();
	int ii=0;
	m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
	int count=0;
	for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
	{
		if(m_List1array.ElementAt (ii).ElementAt (5)==str)
		{
			m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
		}
	}
	m_List1.m_arLabels.SetSize(count, 1);
	ii=count;
	m_List1.m_LabelCount=ii;
	m_List1.SetItemCountEx (ii);
    OnBUTadd() ;
}

void ShangPin::OnBUTclose() 
{
	// TODO: Add your control notification handler code here
	GetParent()->SendMessage(WM_CLOSE);
}

void ShangPin::ClearCtrl()
{
	m_spbz = _T("");
	m_spdanwei = _T("");
	m_spjiaga1 = _T("");
	m_spjiage2 = _T("");
	m_spname = _T("");
	m_spid.Format ("%d", m_autoid);
	UpdateData(false);
}

void ShangPin::OnClickList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	ListSelChange();
	*pResult = 0;
}

void ShangPin::ListSelChange()
{
	POSITION pos; 
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{OnBUTadd();
		return;	
	}
	int iItem=m_List1.GetNextSelectedItem(pos);
	
	m_oldspid=m_List1.GetItemText (iItem, 0);		
    for(int ii=0; ii<m_List1array.GetSize (); ii++)
	{
		if(m_List1array.ElementAt (ii).ElementAt (0)==m_oldspid)
		{	
			m_spid = m_List1array.ElementAt (ii).ElementAt (0);
			m_spname = m_List1array.ElementAt (ii).ElementAt (1); 
			m_spdanwei = m_List1array.ElementAt (ii).ElementAt (2);
			m_spjiaga1 = m_List1array.ElementAt (ii).ElementAt (3);
			m_spjiage2 = m_List1array.ElementAt (ii).ElementAt (4);
			m_spbz = m_List1array.ElementAt (ii).ElementAt (6);
			UpdateData(false);
			return;
		}
	}
}

void ShangPin::OnBUTadd() 
{
	// TODO: Add your control notification handler code here
	m_oldspid.Empty ();
	ClearCtrl();
}

void ShangPin::OnBUTsave() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_spid.IsEmpty () || m_spname.IsEmpty () || m_spjiage2.IsEmpty ())
	{
		AfxMessageBox("资料不全!", MB_ICONINFORMATION);return;
	}
	CString sql;
	CString splb;
	int pos=m_combosplb.GetCurSel ();
	if(pos==-1)return;
	m_combosplb.GetLBText (pos, splb);

	if(m_oldspid.IsEmpty ())//新增
	{
	 
		if(IsExist())
		{
			AfxMessageBox("已有此编号的商品,请重新编号", MB_ICONINFORMATION);
			return;
		}
sql.Format ("insert into shangpin(spid,spname,spdanwei,spjiaga1,spjiage2,splb,spbz)\
values('%s','%s','%s','%s','%s','%s','%s')", m_spid,m_spname,m_spdanwei,m_spjiaga1,m_spjiage2,splb,m_spbz);
sql+=SP_REF;
g_sendhead.bsql=1;
	    g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
		GetData();
		OnSelchangeCOMBOsplb();
		m_autoid++;
	}
	else//修改
	{
		if(m_oldspid!=m_spid)
		{
		if(IsExist())
		{
			AfxMessageBox("已有此编号的商品,请重新编号", MB_ICONINFORMATION);
			return;
		}
		}

sql.Format ("update shangpin set spid='%s',spname='%s',spdanwei='%s',spjiaga1='%s',spjiage2='%s',splb='%s',spbz='%s' where spid=%d ", m_spid,m_spname,m_spdanwei,m_spjiaga1,m_spjiage2,splb,m_spbz, atol(m_oldspid));
sql+=SP_REF;
g_sendhead.bsql=1;
	    g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
		GetData();
		OnSelchangeCOMBOsplb();
	}
	OnBUTadd();
}

void ShangPin::OnBUTdel() 
{
	// TODO: Add your control notification handler code here
	POSITION pos; 
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		return;	
	}
	if(AfxMessageBox("确认删除吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;
	int iItem=m_List1.GetNextSelectedItem(pos);
	CString id=m_List1.GetItemText (iItem, 0);
	CString sql;
	sql.Format ("delete from shangpin where spid=%d ", atol(id));
	sql+=SP_REF;
	g_sendhead.bsql=1;
	    g_pMainWnd->ProcessChatMessageRequest2(sql);if(g_bSendOK==0)return;
		GetData();
		OnSelchangeCOMBOsplb();
}

void ShangPin::GetData()
{
	g_sendhead.bsql=0;
	g_sendhead.code[0]=4;
	g_sendhead.tabcount=1;
	g_pMainWnd->ProcessChatMessageRequest2(4);if(g_bSendOK==0)return;
	DataToArray(&m_List1array);
}

BOOL ShangPin::IsExist()
{
	for(int i=0; i<m_List1array.GetSize (); i++)
	{
    	if(m_spid==m_List1array.ElementAt (i).ElementAt (0))return 1;
	}
	return 0;
}

BOOL ShangPin::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 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 CFormView::PreTranslateMessage(pMsg);
	}
	catch(...)
	{
	}
}