sampledlg.cpp

visual C++ mysql Connect Source

// SampleDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Sample.h"
#include "SampleDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSampleDlg dialog

CSampleDlg::CSampleDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSampleDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSampleDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CSampleDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSampleDlg)
	DDX_Control(pDX, IDC_TREE, m_Tree);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CSampleDlg, CDialog)
	//{{AFX_MSG_MAP(CSampleDlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSampleDlg message handlers

BOOL CSampleDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// Add "About..." menu item to system menu.

	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	// TODO: Add extra initialization here
	// 飘府牧飘费狼 檬扁拳
	///////////////////////////////////////////////////////////////////////
	HBITMAP hBmp;

	m_TreeImageList.m_hImageList = ::ImageList_Create(16, 16, 
		ILC_COLOR24, 1, 1);
	hBmp = (HBITMAP)::LoadBitmap(AfxGetInstanceHandle(),
		MAKEINTRESOURCE(IDB_TREE));

	::ImageList_Add(m_TreeImageList.m_hImageList, hBmp, NULL);
	::DeleteObject(hBmp);
	m_Tree.SetImageList(&m_TreeImageList, TVSIL_NORMAL);

	TV_INSERTSTRUCT tvInsert;

	if(m_Tree.GetCount() > 0)
	{	m_Tree.DeleteAllItems(); }

	HTREEITEM* hItem = NULL;
	HTREEITEM* hSub = NULL;
	HTREEITEM* hSub2 = NULL;
	HTREEITEM* hSub3 = NULL;
	/////////////////////////////////////////////////////////////////////////
	
	long i=0, j=0, k=0;
	char Query[128];
	DWORD ln = 0, loop = 0;

	if(strcmp(g_MyInfo.id, ADMINISTRATOR_ID) == 0)
	{
		// 包府磊 拌沥栏肺 肺弊牢窃
		ZeroMemory(&Query[0], sizeof(Query));

		// 刚历 1技措 荤侩磊甸阑 八祸
		sprintf(Query, "SELECT * FROM %s WHERE %s=%d ORDER BY %s", 
			TABLE, LEVEL, 1, LEVEL, LAST_NUMBER);

		if(mysql_query(&g_MySQL, Query))
		{
			MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
			return -1;
		}
		else
		{
			MYSQL_RES *result = mysql_store_result(&g_MySQL);

			hItem = new HTREEITEM[result->row_count];
			ZeroMemory(&hItem[0], sizeof(HTREEITEM) * result->row_count);

			if(result)
			{
				MYSQL_ROW row;
				for(i=0; i<result->row_count; i++)
				{
					row = mysql_fetch_row(result);
					hItem[i] = m_Tree.InsertItem(InsertItem(&tvInsert, row[0], 0, NULL));
				}

				loop = result->row_count;
			}
		}

		ZeroMemory(&Query[0], sizeof(Query));
		// 促澜 技措甸 荤侩磊 八祸(2技措)
		sprintf(Query, "SELECT * FROM %s WHERE %s=%d ORDER BY %s", 
					TABLE, LEVEL, 2, LEVEL);
		if(mysql_query(&g_MySQL, Query))
		{
			MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
			return -1;
		}
		else
		{
			MYSQL_RES *result = mysql_store_result(&g_MySQL);

			hSub = new HTREEITEM[result->row_count];
			ZeroMemory(&hSub[0], sizeof(HTREEITEM) * result->row_count);

			if(result)
			{
				MYSQL_ROW row;
				for(i=0; i<result->row_count; i++)
				{
					row = mysql_fetch_row(result);
					
					for(j=0; j<loop; j++)
					{
						if(hItem[j] != NULL)
						{
							CString string = m_Tree.GetItemText(hItem[j]);
							if(strcmp(string.GetBuffer(0), row[2]) == 0)
							{
								hSub[i] = m_Tree.InsertItem(InsertItem(&tvInsert, row[0], 0, hItem[j]));
								break;
							}
						}
					}
				}

				loop = result->row_count;
			}
		}

		ZeroMemory(&Query[0], sizeof(Query));
		// 促澜 技措甸 荤侩磊 八祸(3技措)
		sprintf(Query, "SELECT * FROM %s WHERE %s=%d ORDER BY %s", 
					TABLE, LEVEL, 3, LEVEL);
		if(mysql_query(&g_MySQL, Query))
		{
			MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
			return -1;
		}
		else
		{
			MYSQL_RES *result = mysql_store_result(&g_MySQL);

			hSub2 = new HTREEITEM[result->row_count];
			ZeroMemory(&hSub2[0], sizeof(HTREEITEM) * result->row_count);

			if(result)
			{
				MYSQL_ROW row;
				for(i=0; i<result->row_count; i++)
				{
					row = mysql_fetch_row(result);
					
					for(j=0; j<loop; j++)
					{
						if(hSub[j] != NULL)
						{
							CString string = m_Tree.GetItemText(hSub[j]);
							if(strcmp(string.GetBuffer(0), row[2]) == 0)
							{
								hSub2[i] = m_Tree.InsertItem(InsertItem(&tvInsert, row[0], 0, hSub[j]));
								break;
							}
						}
					}
				}

				loop = result->row_count;
			}
		}

		ZeroMemory(&Query[0], sizeof(Query));
		// 促澜 技措甸 荤侩磊 八祸(4技措)
		sprintf(Query, "SELECT * FROM %s WHERE %s=%d ORDER BY %s", 
					TABLE, LEVEL, 4, LEVEL);
		if(mysql_query(&g_MySQL, Query))
		{
			MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
			return -1;
		}
		else
		{
			MYSQL_RES *result = mysql_store_result(&g_MySQL);

			hSub3 = new HTREEITEM[result->row_count];
			ZeroMemory(&hSub3[0], sizeof(HTREEITEM) * result->row_count);

			if(result)
			{
				MYSQL_ROW row;
				for(i=0; i<result->row_count; i++)
				{
					row = mysql_fetch_row(result);
					
					for(j=0; j<loop; j++)
					{
						if(hSub2[j] != NULL)
						{
							CString string = m_Tree.GetItemText(hSub2[j]);
							if(strcmp(string.GetBuffer(0), row[2]) == 0)
							{
								hSub3[i] = m_Tree.InsertItem(InsertItem(&tvInsert, row[0], 0, hSub2[j]));
								break;
							}
						}
					}
				}

				loop = result->row_count;
			}
		}
				
		delete []hItem;
		delete []hSub;
		delete []hSub2;
		delete []hSub3;
	}
	else
	{
		// 包府磊 拌沥捞 酒丛
		MYSQL_RES *result = NULL;
		MYSQL_ROW row;
		DWORD *pNum;

		ZeroMemory(&Query[0], sizeof(Query));
		// 老馆
		// 八祸: 眠玫牢捞 唱牢 荤恩
		sprintf(Query, "SELECT * FROM %s WHERE %s='%s' ORDER BY %s", 
			TABLE, RECOMMENDER, g_MyInfo.id, LAST_NUMBER);
		
		if(mysql_query(&g_MySQL, Query))
		{
			MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
			return -1;
		}
		else
		{
			MYSQL_RES *result = mysql_store_result(&g_MySQL);
			if(result)
			{
				if(result->row_count)
				{
					// 扼牢 备窍扁
					pNum = new DWORD[result->row_count];

					for(i=0; i<result->row_count; i++)
					{
						row = mysql_fetch_row(result);
						pNum[i] = atoi(row[4]);

						ZeroMemory(&Query[0], sizeof(Query));
						// 八祸: 官肺 关 磊侥苞 扼牢捞 鞍绊,
						// 饭骇捞 唱焊促 臭篮 荤恩
						sprintf(Query, "SELECT * FROM %s WHERE %s > %d AND %s=%d ORDER BY %s", 
							TABLE, LEVEL, g_MyInfo.lv, LAST_NUMBER, pNum[i], LEVEL);
						if(mysql_query(&g_MySQL, Query))
						{
							MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
							return -1;
						}
						else
						{
							MYSQL_RES *result2 = mysql_store_result(&g_MySQL);
							hItem = new HTREEITEM[result2->row_count];
							ZeroMemory(&hItem[0], sizeof(HTREEITEM) * result2->row_count);
							if(result2)
							{
								if(result2->row_count)
								{
									for(j=0; j<result2->row_count; j++)
									{
										row = mysql_fetch_row(result2);
										if(g_MyInfo.lv+1 == atoi(row[3]))
										{
											hItem[j] = m_Tree.InsertItem(InsertItem(&tvInsert, row[0], 0, NULL));
										}
										else
										{
											for(k=0; k<result2->row_count; k++)
											{
												if(hItem[k] != NULL)
												{
													CString Temp = m_Tree.GetItemText(hItem[k]);
													if(strcmp(Temp.GetBuffer(0), row[2]) == 0)
													{
														hItem[j] = m_Tree.InsertItem(InsertItem(&tvInsert, row[0], 0, hItem[k]));
													}
												}
											}
										}
									}
								}
							}
							delete []hItem;
							if(g_MyInfo.lv >= 1)
							{	break; }
						}
					}
					delete []pNum;
				}
			}
		}
	}

	return TRUE;  // return TRUE  unless you set the focus to a control
}

void CSampleDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CSampleDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

HCURSOR CSampleDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CSampleDlg::GetTreeItem(HTREEITEM hItem, TVITEM* TvEx, int nLen)
{
	char pData[64];
	ZeroMemory(pData, sizeof(pData));

	TvEx->mask = TVIF_TEXT | TVIF_IMAGE;
	TvEx->pszText = pData;
	TvEx->cchTextMax = nLen;
	TvEx->hItem = hItem;
	m_Tree.GetItem(TvEx);
}

void CSampleDlg::InitTreeCtrl()
{

}

TV_INSERTSTRUCT* CSampleDlg::InsertItem(TV_INSERTSTRUCT *intv, char *name, int nBitmapSel, HTREEITEM pParent)
{
	ZeroMemory(intv, sizeof(intv));

	intv->hParent = pParent;
	intv->hInsertAfter = TVI_LAST;
	intv->item.mask = TVIF_TEXT|TVIF_IMAGE;
	intv->item.state =0;
	intv->item.stateMask = 0;
	intv->item.cchTextMax = 60;
	intv->item.cChildren = 0;
	intv->item.iImage = nBitmapSel;
	intv->item.iSelectedImage = NULL;
	intv->item.pszText = name;

	return intv;
}