databasesoftwaredlg.cpp

易经起名卦例的存取,用户可以方便存取原名和改后的名字信息

// DataBaseSoftWareDlg.cpp : implementation file
//

#include "stdafx.h"
#include "DataBaseSoftWare.h"
#include "DataBaseSoftWareDlg.h"
#include "Columns.h"
#include "Column.h"
#include "SearchDialog.h"
#include "CopyData.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CDataBaseSoftWareApp theApp;
_RecordsetPtr m_pRecordset;
char *p=NULL;
/////////////////////////////////////////////////////////////////////////////
// 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()

/////////////////////////////////////////////////////////////////////////////
// CDataBaseSoftWareDlg dialog

CDataBaseSoftWareDlg::CDataBaseSoftWareDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDataBaseSoftWareDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDataBaseSoftWareDlg)
	m_name = _T("");
	m_cname = _T("");
	m_time1 = 0;
	m_time2 = 0;
	m_adress = _T("");
	m_fixnum = _T("");
	m_moblenum = _T("");
	m_CnameN = _T("");
	m_time3 = 0;
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
	isFirst=0;
	isNewName=0;
	indexId=-1;
	tempId=-1;
}

void CDataBaseSoftWareDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDataBaseSoftWareDlg)
	DDX_Control(pDX, ID_COURSE_EXECUTE, m_excute);
	DDX_Control(pDX, IDC_BUTTON_CopyData, m_copy);
	DDX_Control(pDX, IDC_MODIFY_STUDENT_BTN, m_modify);
	DDX_Control(pDX, IDC_LOOKFOR_STUDENT_BTN, m_stubt);
	DDX_Control(pDX, IDC_DEL_STUDENT_BTN, m_stu);
	DDX_Control(pDX, IDC_ADD_STUDENT_BTN, m_add);
	DDX_Control(pDX, IDC_Compuny, m_compuny);
	DDX_Control(pDX, IDC_COMBO_IsOut, m_isout);
	DDX_Control(pDX, IDC_COMBO_SEX, m_listsex);
	DDX_Text(pDX, IDC_EDIT_Name, m_name);
	DDX_Text(pDX, IDC_EDIT_CName, m_cname);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_time1);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER2, m_time2);
	DDX_Text(pDX, IDC_EDIT_Adress, m_adress);
	DDX_Text(pDX, IDC_EDIT_FixNum, m_fixnum);
	DDX_Text(pDX, IDC_EDIT_MobleNum, m_moblenum);
	DDX_Control(pDX, IDC_DATAGRID_Data, m_Datagrid);
	DDX_Text(pDX, IDC_EDIT_CNameN, m_CnameN);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER5, m_time3);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CDataBaseSoftWareDlg, CDialog)
	//{{AFX_MSG_MAP(CDataBaseSoftWareDlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_DEL_STUDENT_BTN, OnDelBtn)
	ON_BN_CLICKED(IDC_MODIFY_STUDENT_BTN, OnModifyBtn)
	ON_BN_CLICKED(IDC_ADD_STUDENT_BTN, OnAddBtn)
	ON_BN_CLICKED(ID_COURSE_EXECUTE, OnCourseExecute)
	ON_BN_CLICKED(IDC_RADIO_ChangeName, OnRADIOChangeName)
	ON_BN_CLICKED(IDC_RADIO_NewName, OnRADIONewName)
	ON_CBN_EDITCHANGE(IDC_Compuny, OnEditchangeCompuny)
	ON_CBN_SELENDOK(IDC_Compuny, OnSelendokCompuny)
	ON_BN_CLICKED(IDC_LOOKFOR_STUDENT_BTN, OnLookforStudentBtn)
	ON_BN_CLICKED(IDC_BUTTON_CopyData, OnBUTTONCopyData)
	ON_WM_SIZE()
	//}}AFX_MSG_MAP
	ON_MESSAGE(UM_UpdateData,OnUpdateData)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDataBaseSoftWareDlg message handlers

BOOL CDataBaseSoftWareDlg::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);
		}
	}

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon

	type = 0;

	m_pRecordset.CreateInstance("ADODB.Recordset");
	m_pRecordset->Open("SELECT * FROM user_data",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);       
	
	m_Datagrid.SetRefDataSource(NULL);
	m_Datagrid.SetRefDataSource((LPUNKNOWN)m_pRecordset);
	m_Datagrid.SetColumnHeaders(2) ;

	if(isFirst==0)
	{

	m_listsex.InsertString( 0,  "男" );//将行插入到指定位置
	m_listsex.InsertString( 1,  "女" );//将行插入到指定位置

	m_isout.InsertString( 0,  "本地" );//将行插入到指定位置
	m_isout.InsertString( 1,  "外地" );//将行插入到指定位置
	
	m_compuny.InsertString( 0,  "公司" );//将行插入到指定位置
	m_compuny.InsertString( 1,  "个人" );//将行插入到指定位置
	isFirst=1;

	}
	
	((CButton *)GetDlgItem(IDC_RADIO_NewName))->SetCheck(TRUE);//选上
	((CButton *)GetDlgItem(IDC_RADIO_ChangeName))->SetCheck(FALSE);//选上

	GetDlgItem(IDC_STATIC_Name)->SetWindowText("酿名：");

	GetDlgItem(IDC_STATIC_Cname)->EnableWindow(FALSE);
	GetDlgItem(IDC_EDIT_CNameN)->EnableWindow(FALSE);

	_variant_t var;
	var = long(0);
	m_Datagrid.GetColumns().GetItem(var).SetCaption("索引号");
	m_Datagrid.GetColumns().GetItem(var).SetWidth(40);
	var = long(1);
	m_Datagrid.GetColumns().GetItem(var).SetCaption("公司&个人");
	m_Datagrid.GetColumns().GetItem(var).SetWidth(50);
	var = long(2);
	m_Datagrid.GetColumns().GetItem(var).SetCaption("起名时间");
	m_Datagrid.GetColumns().GetItem(var).SetWidth(110);
	var = long(3);
	m_Datagrid.GetColumns().GetItem(var).SetCaption("名称&姓名");

	m_Datagrid.GetColumns().GetItem(var).SetWidth(130);
	var = long(4);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(30);
	var = long(5);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(90);
	var = long(6);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(80);
	var = long(7);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(60);
	var = long(8);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(130);
	var = long(9);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(110);
	var = long(10);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(90);
	var = long(11);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(50);
	var = long(12);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(100);
//	m_Datagrid.GetColumns().GetItem(var).SetCaption("起名时间");
	var = long(13);
	m_Datagrid.GetColumns().GetItem(var).SetWidth(0);
	m_Datagrid.SetGridHeadCenter();
	
	m_Datagrid.Refresh();
	
	UpdateData(FALSE);

	GetDlgItem(IDC_MODIFY_STUDENT_BTN)->EnableWindow(FALSE);
	ModifyStyle(0, WS_SIZEBOX);
/*
	static DLGCTLINFO dcMenuGroup[] = 
	{
		
		{IDC_ADD_STUDENT_BTN, MOVEY, 100},
		{IDC_MODIFY_STUDENT_BTN, MOVEY, 100},
		{IDC_DEL_STUDENT_BTN, MOVEY, 100},
		//		{IDC_BUTTON_SendUserM, MOVEX, 100},
		{ID_COURSE_EXECUTE, MOVEY, 100},
		{IDC_LOOKFOR_STUDENT_BTN, MOVEY, 100},

		{ID_COURSE_EXECUTE, MOVEY, 100},
		{IDC_BUTTON_CopyData, MOVEY, 100},

		
		{IDC_STATIC_1, ELASTICX, 100},
		{IDC_STATIC_2, ELASTICX, 100},
		{IDC_STATIC_3, ELASTICXY, 100},
		{IDC_STATIC_4, MOVEX, 100},
		
		{IDC_STATIC_5, MOVEX, 100},
		
		{IDC_STATIC_ICCIDST, MOVEX, 100},
		{IDC_STATIC_ICCID, MOVEX, 100},
		{IDC_STATIC_BPM, MOVEX, 100},
		{IDC_STATIC_BMessage, MOVEX, 100},
		{IDC_STATIC_UserSelectPn, MOVEX, 100},
		{IDC_STATIC_SelectPn, MOVEX, 100},
		
		
		
		//		{IDC_FRAME, ELASTICXY, 100},
		{IDC_PICTURE, ELASTICXY, 100},
		{IDD_DIALOGFRAME, ELASTICXY, 100},
		
		{IDC_EDIT_UserName, ELASTICX, 100},
		{IDC_EDIT_UserIDcard, ELASTICX, 100},
		{IDC_DATAGRID_Data, ELASTICX, 100},
		{IDC_RICHEDIT_InputFailCause, ELASTICXY, 100},
		
		
		
		
	};
	SetControlProperty(dcMenuGroup, sizeof(dcMenuGroup)/sizeof(DLGCTLINFO));
	
	ModifyStyle(0, WS_SIZEBOX);

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

void CDataBaseSoftWareDlg::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 CDataBaseSoftWareDlg::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();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CDataBaseSoftWareDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

//void CDataBaseSoftWareDlg::OnSearch() 
//{
	// TODO: Add your control notification handler code here
//	if(!UpdateData())
//		return;
//	CString m_strSQl,temp="%";
//	GetDlgItem(IDC_EDIT_SearchTime)->GetWindowText(m_DataTime);
//	GetDlgItem(IDC_EDIT_SEARCHNAME)->GetWindowText(m_DataName);


//}

void CDataBaseSoftWareDlg::OnDelBtn() 
{
	// TODO: Add your control notification handler code here

	if(AfxMessageBox("确定删除此客户信息吗？",MB_YESNO)==IDYES)
		type = 2;
	
}

void CDataBaseSoftWareDlg::OnModifyBtn() 
{
	// TODO: Add your control notification handler code here

	if(AfxMessageBox("确定删除此课程吗？",MB_YESNO)==IDYES)
		type = 3;
	m_Datagrid.SetAllowUpdate(1);
	GetDlgItem(IDC_MODIFY_STUDENT_BTN)->EnableWindow(FALSE);
}

void CDataBaseSoftWareDlg::OnAddBtn() 
{
	
	// TODO: Add your control notification handler code here
	
	m_name = "";
	m_cname = "";
	m_adress = "";
	m_fixnum = "";
	m_moblenum = "";
	m_CnameN = "";