usermag.cpp

一个ＶＣ写的药品管理系统

// UserMag.cpp : implementation file
//

#include "stdafx.h"
#include "medicine.h"
#include "UserMag.h"

#include "_recordset.h"
#include "columns.h"
#include "column.h"
#include "COMDEF.H"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUserMag dialog


CUserMag::CUserMag(CWnd* pParent /*=NULL*/)
	: CDialog(CUserMag::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUserMag)
	m_Place = _T("");
	m_Pos = _T("");
	m_UserId = _T("");
	m_UserName = _T("");
	m_WorkNo = _T("");
	m_ChooseInfo = _T("");
	m_Other = _T("");
	//}}AFX_DATA_INIT
}


void CUserMag::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUserMag)
	DDX_Control(pDX, IDC_TYPE, m_Type);
	DDX_Control(pDX, IDC_AUTHORITY, m_Authority);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_DataGrid);
	DDX_Text(pDX, IDC_PLACE, m_Place);
	DDX_Text(pDX, IDC_POS, m_Pos);
	DDX_Text(pDX, IDC_USERID, m_UserId);
	DDX_Text(pDX, IDC_USERNAME, m_UserName);
	DDX_Text(pDX, IDC_WORKNO, m_WorkNo);
	DDX_Text(pDX, IDC_CHOOSEINFO, m_ChooseInfo);
	DDX_Text(pDX, IDC_OTHER, m_Other);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CUserMag, CDialog)
	//{{AFX_MSG_MAP(CUserMag)
	ON_BN_CLICKED(IDC_NEW, OnNew)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CUserMag message handlers

int CUserMag::DoModal() 
{
	// TODO: Add your specialized code here and/or call the base class
	
	return CDialog::DoModal();
}

BOOL CUserMag::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_Authority.SetCurSel(0);
	m_Type.SetCurSel(0);
	RefreshData();
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CUserMag::RefreshData()
{
	/*	CString Authority;
	CString UserName,UserId,WorkNo,Pos,Other,Place;*/
	UpdateData(TRUE);// 将控件上的信息及时更新到对应的变量
	CString cSql;
	cSql = "select  UserName as'姓名',WorkNo as";
	cSql+="'工作号',Pos as'职位', Authority as ";
	cSql+="'权限', UserId as'身份证号',Place as'地址', Other as";
	cSql+="'其他'from Users";
	m_Adodc.SetRecordSource(cSql);
	m_Adodc.Refresh();

	m_Adodc.SetRecordSource((LPCTSTR)(_bstr_t)cSql);
	m_Adodc.Refresh();

	// 设置列宽度
	_variant_t vIndex;
	//long将整数转换为_variant_t类型，从而可以在CColumns::GetItem()函数中使用
	vIndex = long(0);//姓名
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(1);  //工作号
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(2);  //职位
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(3);  //权限
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(4);  //身份证号
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(100);
	vIndex = long(5);  //地址
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(100);
	vIndex = long(6); //其他
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(100);
}

BEGIN_EVENTSINK_MAP(CUserMag, CDialog)
    //{{AFX_EVENTSINK_MAP(CUserMag)
	ON_EVENT(CUserMag, IDC_DATAGRID1, -601 /* DblClick */, OnDblClickDataGrid, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CUserMag::OnDblClickDataGrid() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if(m_Adodc.GetRecordset().GetEof()==1)
	{
		MessageBox("没有数据");
		return;
	}
	/*	CString Authority;
	CString UserName,UserId,WorkNo,Pos,Other,Place;*/
	m_Pos = m_DataGrid.GetItem(2);
	m_UserId =m_DataGrid.GetItem(4);
	m_UserName =m_DataGrid.GetItem(0);
	m_WorkNo = m_DataGrid.GetItem(1);
	m_Other=m_DataGrid.GetItem(6);
	if(m_DataGrid.GetItem(6)=="超级管理员")
	{
		m_Authority.SetCurSel(1);
	}
	else
	{
		m_Authority.SetCurSel(0);
	}
	UpdateData(FALSE);
}

void CUserMag::OnNew() 
{
	// TODO: Add your control notification handler code here	
	m_Place = _T("");
	m_Pos = _T("");
	m_UserId = _T("");
	m_UserName = _T("");
	//m_WorkNo = _T("");
	m_Other = _T("");
	m_Authority.SetCurSel(0);

		
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_RecordsetPtr m_pRecordset;
	//设置SELECT语句
	_bstr_t vSQL="select Max(WorkNo) wNo from Users" ;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		CUserMag();
	else
	{
		//InPrice = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("InPrice"));
		int no=(atoi)((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("wNo"))+1;
		CString s;
		s.Format("%d",no);
		m_WorkNo=s;
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
	UpdateData(FALSE);
}