gongyingshangjibenziliao.cpp

面向软件工程的Visual C++网络程序开发

// Gongyingshangjibenziliao.cpp : implementation file
//

#include "stdafx.h"
#include "falcon_jxc.h"
#include "Gongyingshangjibenziliao.h"
#include "mainfrm.h"
#include "FALCON_JXCView.h"
#include "message.h"
#include "Gyszlmx.h"

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

/////////////////////////////////////////////////////////////////////////////
// CGongyingshangjibenziliao dialog


CGongyingshangjibenziliao::CGongyingshangjibenziliao(CWnd* pParent /*=NULL*/)
	: CDialog(CGongyingshangjibenziliao::IDD, pParent)
{
	//{{AFX_DATA_INIT(CGongyingshangjibenziliao)
	m_strCombo1 = _T("");
	m_strGuanjianzi1 = _T("");
	m_strCombo2 = _T("");
	m_strGuanjianzi2 = _T("");
	//}}AFX_DATA_INIT
	m_iRow = 1;
	m_iSelRow = 0;
	m_iColNum = 13;//数据库的列数
}


void CGongyingshangjibenziliao::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CGongyingshangjibenziliao)
	DDX_Control(pDX, IDC_COMBO2, m_ctrCombo2);
	DDX_Control(pDX, IDC_COMBO1, m_ctrCombo1);
	DDX_CBString(pDX, IDC_COMBO1, m_strCombo1);
	DDX_Text(pDX, IDC_EDIT1, m_strGuanjianzi1);
	DDX_CBString(pDX, IDC_COMBO2, m_strCombo2);
	DDX_Text(pDX, IDC_EDIT2, m_strGuanjianzi2);
	DDX_Control(pDX, IDC_MSFLEXGRID1, m_CMSFlexGrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CGongyingshangjibenziliao, CDialog)
	//{{AFX_MSG_MAP(CGongyingshangjibenziliao)
	ON_BN_CLICKED(IDC_SHANCHU, OnShanchu)
	ON_BN_CLICKED(IDC_TIANJIAN, OnTianjian)
	ON_BN_CLICKED(IDC_XIUGAI, OnXiugai)
	ON_BN_CLICKED(IDC_CHAZHAO, OnChazhao)
	ON_BN_CLICKED(IDC_QUEDING, OnQueding)
	ON_BN_CLICKED(ID_TUICHU, OnTuichu)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CGongyingshangjibenziliao message handlers
BOOL CGongyingshangjibenziliao::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here	
	m_CMSFlexGrid.SetRows(m_iRow);
	m_CMSFlexGrid.SetCols(m_iColNum);
	m_CMSFlexGrid.SetTextMatrix(0,0,"商家编码");	
	m_CMSFlexGrid.SetTextMatrix(0,1,"名称");	
	m_CMSFlexGrid.SetTextMatrix(0,2,"联系人");	
	m_CMSFlexGrid.SetTextMatrix(0,3,"职务");	
	m_CMSFlexGrid.SetTextMatrix(0,4,"地址");	
	m_CMSFlexGrid.SetTextMatrix(0,5,"城市");	
	m_CMSFlexGrid.SetTextMatrix(0,6,"邮编");	
	m_CMSFlexGrid.SetTextMatrix(0,7,"电话");	
	m_CMSFlexGrid.SetTextMatrix(0,8,"传真");	
	m_CMSFlexGrid.SetTextMatrix(0,9,"开户银行");	
	m_CMSFlexGrid.SetTextMatrix(0,10,"银行帐号");	
	m_CMSFlexGrid.SetTextMatrix(0,11,"网址");	
	m_CMSFlexGrid.SetTextMatrix(0,12,"电子邮箱");	

	m_ctrCombo1.AddString("商家编码");
	m_ctrCombo1.AddString("名称");
	m_ctrCombo1.AddString("联系人");
	m_ctrCombo1.AddString("电话");
	m_ctrCombo1.SetCurSel(0);
	   
	m_ctrCombo2.AddString("电话");
	m_ctrCombo2.AddString("联系人");
	m_ctrCombo2.AddString("名称");
	m_ctrCombo2.AddString("商家编码");
	m_ctrCombo2.SetCurSel(0);

	CMainFrame* pwnd=(CMainFrame*)AfxGetApp()->m_pMainWnd;
	CFALCON_JXCView* pView=(CFALCON_JXCView*)pwnd->GetActiveView();
	CFALCON_JXCDoc* pDoc=	pView->GetDocument();

	if(pDoc->ConnectToServer())
	{

		pDoc->SendMsg("",1920);
	}
	else
		return FALSE;

a:
	if(pDoc->m_b2920)
	{
		if (pDoc->m_pMsg->ShortMessage != "")
		{
			m_iRow += pDoc->m_iRow;
			m_CMSFlexGrid.SetRows(m_iRow);
			CString str;
			int n = 0;
			for(int i = 1; i <= pDoc->m_iRow; i++)
			{
				str = pDoc->m_StrArray[n];
				m_CMSFlexGrid.SetTextMatrix(i,0,str);
				str = pDoc->m_StrArray[n+1];
				m_CMSFlexGrid.SetTextMatrix(i,1,str);
				str = pDoc->m_StrArray[n+2];
				m_CMSFlexGrid.SetTextMatrix(i,2,str);
				str = pDoc->m_StrArray[n+3];
				m_CMSFlexGrid.SetTextMatrix(i,3,str);
				str = pDoc->m_StrArray[n+4];
				m_CMSFlexGrid.SetTextMatrix(i,4,str);
				str = pDoc->m_StrArray[n+5];
				m_CMSFlexGrid.SetTextMatrix(i,5,str);
				str = pDoc->m_StrArray[n+6];
				m_CMSFlexGrid.SetTextMatrix(i,6,str);
				str = pDoc->m_StrArray[n+7];
				m_CMSFlexGrid.SetTextMatrix(i,7,str);
				str = pDoc->m_StrArray[n+8];
				m_CMSFlexGrid.SetTextMatrix(i,8,str);
				str = pDoc->m_StrArray[n+9];
				m_CMSFlexGrid.SetTextMatrix(i,9,str);
				str = pDoc->m_StrArray[n+10];
				m_CMSFlexGrid.SetTextMatrix(i,10,str);
				str = pDoc->m_StrArray[n+11];
				m_CMSFlexGrid.SetTextMatrix(i,11,str);
				str = pDoc->m_StrArray[n+12];
				m_CMSFlexGrid.SetTextMatrix(i,12,str);
				n += m_iColNum;
			}
		}
		pDoc->m_b2920=false;
	}
	else
	{
		pDoc->ProcessReadMessage();
		goto a;
	}
	m_bModi = FALSE;
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CGongyingshangjibenziliao::OnTianjian() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CGyszlmx dlg;

	CString str;
	if(dlg.DoModal() == IDOK)
	{
		if(m_iRow != 1)
		{
			for(int i = 1; i < m_iRow; i++)
			{
				if(dlg.m_strBianma == m_CMSFlexGrid.GetTextMatrix(i,0))
				{
					AfxMessageBox("该编码供应商已存在!");
					return;
				}
			}
		}
		m_iRow++;
		m_CMSFlexGrid.SetRows(m_iRow);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,0,dlg.m_strBianma);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,1,dlg.m_strMingcheng);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,2,dlg.m_strLianxiren);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,3,dlg.m_strZhiwu);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,4,dlg.m_strDizhi);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,5,dlg.m_strChengshi);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,6,dlg.m_strYoubian);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,7,dlg.m_strGysdianhua);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,8,dlg.m_strChuanzhen);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,9,dlg.m_strKaihuyinhang);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,10,dlg.m_strZhanghao);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,11,dlg.m_strWangzhi);
		m_CMSFlexGrid.SetTextMatrix(m_iRow-1,12,dlg.m_strEmail);
 		m_bModi = TRUE;
	}
}

void CGongyingshangjibenziliao::OnChazhao() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CMainFrame* pwnd=(CMainFrame*)AfxGetApp()->m_pMainWnd;
	CFALCON_JXCView* pView=(CFALCON_JXCView*)pwnd->GetActiveView();
	CFALCON_JXCDoc* pDoc = pView->GetDocument();

	if(m_strGuanjianzi1 == "" && m_strGuanjianzi2 =="")
	{
		AfxMessageBox("请输入关键字!");
		return;
	}

	CString strRequest;
	strRequest = m_strCombo1;
	strRequest += CHARFLAG;
	strRequest += m_strGuanjianzi1;
	strRequest += CHARFLAG;
	strRequest += m_strCombo2;
	strRequest += CHARFLAG;
	strRequest += m_strGuanjianzi2;
	strRequest += CHARFLAG;
	
	if(pDoc->ConnectToServer())
	{

		pDoc->SendMsg(strRequest,1922);//发送根据关键字查询供应商资料的请求
	}
	else
		return;

a: 
	if(pDoc->m_b2922)
	{
		if(pDoc->m_pMsg->ShortMessage != "")
		{
			m_iRow = pDoc->m_iRow+1;
			m_CMSFlexGrid.SetRows(m_iRow);
			CString str;
			for(int i = 1; i < m_iRow; i++)
			{
				for(int j = 0; j < m_iColNum; j++)
				{
					str = pDoc->m_StrArray[j+(i-1)*m_iColNum];
					m_CMSFlexGrid.SetTextMatrix(i,j,str);
				}
				UpdateData(FALSE);
			}
		}
		else 
		{
			m_iRow = 1;
			m_CMSFlexGrid.SetRows(m_iRow);
			UpdateData(FALSE);
			AfxMessageBox("查询结果为0!");
					
		}
		pDoc->m_b2922=false;
	}
	else
	{
		pDoc->ProcessReadMessage();
		goto a;
	}
	
}

void CGongyingshangjibenziliao::OnShanchu() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CMainFrame* pwnd = (CMainFrame*)AfxGetApp()->m_pMainWnd;
	CFALCON_JXCView* pView = (CFALCON_JXCView*)pwnd->GetActiveView();
	CFALCON_JXCDoc* pDoc = pView->GetDocument();
	CString str,strDel;
	
	if (m_iSelRow >0)
	{	
		str.Format("是否删除供应商 %s 的资料?",m_CMSFlexGrid.GetTextMatrix(m_iSelRow,0));
		if(AfxMessageBox(str,MB_YESNO) == IDYES)
		{
			//删除数据库内容
			strDel = m_CMSFlexGrid.GetTextMatrix(m_iSelRow,0);
			if(pDoc->ConnectToServer())
			{
				pDoc->SendMsg(strDel,1923);//发送删除"供应商基本资料"请求
			}
			else
			{
				AfxMessageBox("连接数据库失败!");
				return;
			}
			//刷新显示

			if(m_iRow > 2)
			{
				m_CMSFlexGrid.RemoveItem(m_iSelRow);
				m_iRow--;
				m_CMSFlexGrid.SetRows(m_iRow);
			}
			else
			{
				m_iRow--;
				m_CMSFlexGrid.SetRows(m_iRow);
			}
		}
	}
	else 
	{
		AfxMessageBox("请选择要删除的记录!");
		return;
	}
}

void CGongyingshangjibenziliao::OnXiugai() 
{
	// TODO: Add your control notification handler code here
	
}

BEGIN_EVENTSINK_MAP(CGongyingshangjibenziliao, CDialog)
    //{{AFX_EVENTSINK_MAP(CGongyingshangjibenziliao)
	ON_EVENT(CGongyingshangjibenziliao, IDC_MSFLEXGRID1, -600 /* Click */, OnClickMsflexgrid1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CGongyingshangjibenziliao::OnClickMsflexgrid1() 
{
	// TODO: Add your control notification handler code here
	m_iSelRow = m_CMSFlexGrid.GetRow();
}

void CGongyingshangjibenziliao::OnQueding() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CMainFrame* pwnd=(CMainFrame*)AfxGetApp()->m_pMainWnd;
	CFALCON_JXCView* pView=(CFALCON_JXCView*)pwnd->GetActiveView();
	CFALCON_JXCDoc* pDoc=	pView->GetDocument();
	CString strInsert,str;

	str.Format("%d",m_iRow-1);
	strInsert = str;
	strInsert+=CHARFLAG;
	str.Format("%d",m_iColNum);
	strInsert += str;
	strInsert+=CHARFLAG;
	for(int i = 1; i < m_iRow; i++)
	{
		for(int j = 0; j < m_iColNum; j++)
		{
			strInsert += m_CMSFlexGrid.GetTextMatrix(i,j);
			strInsert+=CHARFLAG;
		}
	}

	if(pDoc->ConnectToServer())
	{

		pDoc->SendMsg(strInsert,1921);//发送存储"供应商基本资料"请求
//		m_CMSFlexGrid.SetRows(1);	//是否清屏？
 		m_bModi = FALSE;
	}
	else
		return;
	
	/*/////////////////////
	添加打印函数
	*/////////////////////
	
//	OnOK();
}

void CGongyingshangjibenziliao::OnOK() 
{
	//Dummy OnOk function!
}

void CGongyingshangjibenziliao::OnCancel() 
{
	//Dummy OnCancel function!
}

void CGongyingshangjibenziliao::OnTuichu() 
{
	// TODO: Add your control notification handler code here
	if (m_bModi)
	{
		if(AfxMessageBox("添加表项尚未保存，是否保存?", MB_YESNO | MB_ICONQUESTION) == IDYES)
		{
			OnQueding();
		}
	}

	CDialog::OnCancel();
}