lyfz_repos/经典版源码/lyfzClient/branches/715/ShangPin.cpp

// ShangPin.cpp : implementation file
//
#include "stdafx.h"
#include "ylgl.h"
#include "ShangPin.h"
#include "MyMdi.H"
#include "CharacterConvert.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// ShangPin IDC_COMBOsplb

IMPLEMENT_DYNCREATE(ShangPin, MyFormView)

ShangPin::ShangPin()
: MyFormView(ShangPin::IDD)
, m_etProductWidth(0)
, m_etProductHeight(0)
{
	//{{AFX_DATA_INIT(ShangPin)
	m_spbz = _T("");
	m_spdanwei = _T("");
	m_spid = _T("");
	m_spjiaga1 = _T("");
	m_spjiage2 = _T("");
	m_spname = _T("");
	m_spjiage3 = _T("");
	m_autoid = 0;
	m_radio1 = 0;
	//}}AFX_DATA_INIT
}

ShangPin::~ShangPin()
{
}

void ShangPin::DoDataExchange(CDataExchange* pDX)
{
	MyFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(ShangPin)
	DDX_Control(pDX, IDC_COMBOstatus, m_combostatus);
	DDX_Control(pDX, IDC_EDITspjiage3, m_editctrl3);
	DDX_Control(pDX, IDC_EDITspjiage2, m_editctrl2);
	DDX_Control(pDX, IDC_EDITspjiaga1, m_editctrl1);
	DDX_Control(pDX, IDC_EDITspname, m_SPNameEdit);
	DDX_Control(pDX, IDC_COMBOsplb, m_combosplb);
	DDX_Control(pDX, IDC_EDITspdanwei, m_SPDanWeiEdit);
	DDX_Control(pDX, IDC_LIST2, m_List1);
	DDX_Control(pDX, IDC_STATIC1, m_static1);
	DDV_MaxChars(pDX, m_spbz, 1000);
	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);
	DDX_Text(pDX, IDC_EDITspjiage3, m_spjiage3);
	DDX_Radio(pDX, IDC_RADIO1, m_radio1);
	//}}AFX_DATA_MAP
	DDX_Text(pDX, ET_PRODUCT_WIDTH, m_etProductWidth);
	DDX_Text(pDX, ET_PRODUCT_HEIGHT, m_etProductHeight);
}


BEGIN_MESSAGE_MAP(ShangPin, MyFormView)
	//{{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)
	ON_BN_CLICKED(IDC_RADIO1, OnRadio1)
	ON_BN_CLICKED(IDC_RADIO2, OnRadio2)
	ON_BN_CLICKED(IDC_RADIO9, OnRadio9)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

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

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

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

void ShangPin::OnInitialUpdate()
{
	MyFormView::OnInitialUpdate();
	// TODO: Add your specialized code here and/or call the base class
	if (IsHasRights2new(29) == 0)
	{
		GetDlgItem(IDC_BUTsave)->EnableWindow(0);
	}


	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_combostatus.GetWindowRect(rc2);
	ScreenToClient(rc2);
	rc2.bottom += 200;
	m_combostatus.MoveWindow(rc2);
	m_combostatus.AddString("上架");
	m_combostatus.AddString("下架");

	m_static1.SetFont(&g_titlefont);

	m_List1.SetHeadings("编号, 50;商品名称, 100;单位, 50;进价, 50;卖价, 50;制作费用,80;商品分类,100;状态,100; 宽,100; 高,100");
	m_List1.LoadColumnInfo(100);
	
	m_SPNameEdit.SetInput(TYPE_NUM | TYPE_WORD | TYPE_WWORD);
	m_SPDanWeiEdit.SetInput(TYPE_WORD | TYPE_WWORD);

	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);

	if (IsHasRights2new(29) == 0)
	{
		for (int i = 0; i < m_List1array.GetSize(); i++)
		{
			m_List1array.ElementAt(i).SetAt(3, "***");
			m_List1array.ElementAt(i).SetAt(4, "***");
			m_List1array.ElementAt(i).SetAt(5, "***");
		}
	}

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

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)
{
	UpdateData();
	m_List1.DeleteAllItems2();
	int ii = 0;
	m_List1.m_arLabels.SetSize(m_List1array.GetSize(), 1);
	int count = 0;
	if (m_radio1 == 2)
	{
		for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
		{
			if (m_List1array.ElementAt(ii).ElementAt(6) == str)
			{
				m_List1.m_arLabels.ElementAt(count++).Copy(m_List1array.ElementAt(ii));
			}
		}
	}
	else if (m_radio1 == 0)
	{
		for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
		{
			if (m_List1array.ElementAt(ii).ElementAt(6) == str && m_List1array.ElementAt(ii).ElementAt(7) != "下架")
			{
				m_List1.m_arLabels.ElementAt(count++).Copy(m_List1array.ElementAt(ii));
			}
		}
	}
	else
	{
		for (ii = 0; ii < m_List1.m_arLabels.GetSize(); ii++)
		{
			if (m_List1array.ElementAt(ii).ElementAt(6) == str && m_List1array.ElementAt(ii).ElementAt(7) == "下架")
			{
				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_spjiage3 = _T("");
	m_spname = _T("");
	m_etProductWidth = 0;
	m_etProductHeight = 0;
	UpdateData(false);
	AutoId();
}

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_spjiage3 = m_List1array.ElementAt(ii).ElementAt(5);
			m_spbz = m_List1array.ElementAt(ii).ElementAt(8);
			CString status = m_List1array.ElementAt(ii).ElementAt(7);
			m_combostatus.SetCurSel(m_combostatus.FindString(0, status));
			m_etProductWidth = atoi(m_List1array.ElementAt(ii).ElementAt(8));
			m_etProductHeight = atoi(m_List1array.ElementAt(ii).ElementAt(9));
			UpdateData(false);
			return;
		}
	}
}

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

void ShangPin::OnBUTsave()	// 保存按钮;
{
	UpdateData();
	if(m_spdanwei != _T(""))
	{
		char szspdanwei[4096] = {0};
		ascii2utf8(m_spdanwei, szspdanwei);
		if(IsExistNumInString(szspdanwei))
		{
			MessageBox(_T("不能输入数字"));
			return;
		}
	}

	m_spname.TrimRight();
	if (m_spid.IsEmpty() || m_spname.IsEmpty() || m_spjiaga1.IsEmpty() || m_spjiage2.IsEmpty())
	{
		AfxMessageBox("资料不全!", MB_ICONINFORMATION); return;
	}

	if (m_spname.Find("/") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}
	if (m_spname.Find("\\") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}
	if (m_spname.Find(":") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}
	if (m_spname.Find("*") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}
	if (m_spname.Find("?") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}
	if (m_spname.Find("\"") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}
	if (m_spname.Find("<") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}
	if (m_spname.Find(">") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}
	if (m_spname.Find("|") != -1)
	{
		AfxMessageBox("产品名称中请不要包含以下字符 /\\:*?\"<>|", MB_ICONINFORMATION); return;
	}

	CString sql;
	CString splb;
	int pos = m_combosplb.GetCurSel();
	if (pos == -1)return;
	m_combosplb.GetLBText(pos, splb);

	CString status;
	pos = m_combostatus.GetCurSel();
	if (pos == -1)
	{
		AfxMessageBox("资料不全!", MB_ICONINFORMATION);
		return;
	}
	m_combostatus.GetLBText(pos, status);

	if (m_oldspid.IsEmpty())//新增
	{
		if (IsExist())
		{
			AfxMessageBox("已有此商品记录,请重新输入!", MB_ICONINFORMATION);
			return;
		}
		sql.Format("insert into shangpin(spid,spname,spdanwei,spjiaga1,spjiage2,spjiage3,splb,spbz,hide, [width], [height])values('%s','%s','%s','%s','%s','%s','%s','%s','%s', '%d', '%d')",
			m_spid, m_spname, m_spdanwei, m_spjiaga1, m_spjiage2, m_spjiage3, splb, m_spbz, status, m_etProductWidth, m_etProductHeight);

		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',spjiage3='%s',splb='%s', spbz='%s', hide='%s', [width] = '%d', [height] = '%d' where spid='%s' ",
			m_spid, m_spname, m_spdanwei, m_spjiaga1, m_spjiage2, m_spjiage3, splb, m_spbz, status, m_etProductWidth, m_etProductHeight,(m_oldspid));

		g_sendhead.bsql = 1;
		g_pMainWnd->ProcessChatMessageRequest2(sql);
		if (g_bSendOK == 0)return;
		GetData();
		OnSelchangeCOMBOsplb();
	}
	OnBUTadd();
}

void ShangPin::OnBUTdel()
{
	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='%s' ", id);
	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_spname == m_List1array.ElementAt(i).ElementAt(1))
		{
			CString str;
			str.Format("此产品已存在于类别:%s中", m_List1array.ElementAt(i).ElementAt(6));
			AfxMessageBox(str, MB_ICONINFORMATION);
			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 MyFormView::PreTranslateMessage(pMsg);
	}
	catch (...)
	{
	}

	return TRUE;
}

void ShangPin::AutoId()
{
	UpdateData();
	int pos = m_combosplb.GetCurSel();
	if (pos == -1)return;
	CString type;
	m_combosplb.GetLBText(pos, type);
	CString strRes1;
	ChinesePinYin::GetFirstLetter(type, strRes1);
	int begin = 1;

	BOOL bFind = 1;
	while (bFind)
	{
		int i = 0;
		m_spid.Format("%s%03d", strRes1, begin++);
		for ( i = 0; i < m_List1array.GetSize(); i++)
		{
			if (m_spid == m_List1array.ElementAt(i).ElementAt(0))
			{
				break;
			}
		}
		if (i == m_List1array.GetSize())bFind = 0;
	}
	UpdateData(false);
}

void ShangPin::OnRadio1()
{
	// TODO: Add your control notification handler code here
	OnSelchangeCOMBOsplb();
}

void ShangPin::OnRadio2()
{
	// TODO: Add your control notification handler code here
	OnSelchangeCOMBOsplb();
}

void ShangPin::OnRadio9()
{
	// TODO: Add your control notification handler code here
	OnSelchangeCOMBOsplb();
}