📄 dlgviewneed.cpp

📁 此系统中
💻 CPP
字号:
// DlgViewNeed.cpp : implementation file
//

#include "stdafx.h"
#include "DMS2.h"
#include "DlgViewNeed.h"
#include "DataBinding.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgViewNeed dialog


CDlgViewNeed::CDlgViewNeed(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgViewNeed::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgViewNeed)
	m_end = 0;
	m_start = 0;
	m_dept = _T("");
	m_number = 0.0f;
	m_code = _T("");
	m_Send = _T("");
	m_Sstart = _T("");
	m_Snumber = _T("");
	//}}AFX_DATA_INIT
}


void CDlgViewNeed::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgViewNeed)
	DDX_Control(pDX, IDC_BTN_VNDEL, m_DEL);
	DDX_Control(pDX, IDC_EDIT_DNNUMBER, m_NUMBER0);
	DDX_Control(pDX, IDC_EDIT_DNDEPT, m_DEPT);
	DDX_Control(pDX, IDC_DATETIMEPICKER_DNSTART, m_START0);
	DDX_Control(pDX, IDC_DATETIMEPICKER_DNEND, m_END0);
	DDX_Control(pDX, IDC_EDIT_VNNUMBER, m_NUMBER);
	DDX_Control(pDX, IDC_EDIT_VNEND, m_END);
	DDX_Control(pDX, IDC_EDIT_VNSTART, m_START);
	DDX_Control(pDX, IDC_EDIT_VNCODE, m_CODE);
	DDX_Control(pDX, IDC_LIST_VN, m_list);
	DDX_Control(pDX, IDC_COMBO_DNCODE, m_devs);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_DNEND, m_end);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_DNSTART, m_start);
	DDX_Text(pDX, IDC_EDIT_DNDEPT, m_dept);
	DDX_Text(pDX, IDC_EDIT_DNNUMBER, m_number);
	DDV_MinMaxFloat(pDX, m_number, 1.f, 10000.f);
	DDX_Text(pDX, IDC_EDIT_VNCODE, m_code);
	DDX_Text(pDX, IDC_EDIT_VNEND, m_Send);
	DDX_Text(pDX, IDC_EDIT_VNSTART, m_Sstart);
	DDX_Text(pDX, IDC_EDIT_VNNUMBER, m_Snumber);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgViewNeed, CDialog)
	//{{AFX_MSG_MAP(CDlgViewNeed)
	ON_BN_CLICKED(IDC_BTN_VNDEL, OnBtnVndel)
	ON_NOTIFY(NM_CLICK, IDC_LIST_VN, OnClickListVn)
	ON_BN_CLICKED(IDC_BTN_DNADD, OnBtnDnadd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgViewNeed message handlers

void CDlgViewNeed::OnBtnVndel() 
{
	// TODO: Add your control notification handler code here
	CString sql_;
	sql_.Format("DELETE FROM DEVICE_NEED WHERE code='%s' AND department='%s'",
		m_code, m_dept);
	_bstr_t sql = sql_;

 	try
	{
		m_DBCnt->Execute(sql, NULL, adCmdText);
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		return;
    } 
	MessageBox("完成操作！");
	m_log->AddLog("删除需求信息");

	RefreshData();
}

void CDlgViewNeed::OnClickListVn(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here

	u=2;

	int i = m_list.GetSelectionMark();

	m_code = m_list.GetItemText(i,0);
	m_dept = m_list.GetItemText(i,1);
	m_Sstart = m_list.GetItemText(i,2);
	m_Send = m_list.GetItemText(i,3);
	m_Snumber = m_list.GetItemText(i,4);
	
	see();
	UpdateData(FALSE);
	
	*pResult = 0;
}

BOOL CDlgViewNeed::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	u=1;
	// TODO: Add extra initialization here
	m_list.InsertColumn(0,"设备号");
	m_list.InsertColumn(1,"需求部门");
	m_list.InsertColumn(2,"开始时间");
	m_list.InsertColumn(3,"结束时间");
	m_list.InsertColumn(4,"数量");
	
	RECT rect;
	m_list.GetWindowRect(&rect);
	int wid = rect.right - rect.left;
	m_list.SetColumnWidth(0,wid/5);
	m_list.SetColumnWidth(1,wid/5);
	m_list.SetColumnWidth(2,wid/5);
	m_list.SetColumnWidth(3,wid/5);
	m_list.SetColumnWidth(4,wid/5);

	m_list.SetBkColor(RGB(177,151,240));
	m_list.SetTextColor(RGB(0,0,0));
	m_list.SetTextBkColor(RGB(177,151,240));
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP|LVS_SORTASCENDING|LVS_NOCOLUMNHEADER|LVS_AUTOARRANGE);


	RefreshData();

	

	see();


	m_start = CTime::GetCurrentTime();
	m_end = m_start;

	_RecordsetPtr pRst = NULL;
	IADORecordBinding   *picRs = NULL;  //Interface Pointer declared.(VC++ Extensions)   
	CDevCodeRs rs;

	try
	{
		_bstr_t strSQL("SELECT * FROM DEVICE_CODE");

		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst = m_DBCnt->Execute(strSQL, NULL, adCmdText);
		
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));

		int i = 0;
		while (!pRst->adoEOF)
		{
			m_devs.AddString(rs.m_sz_code);
			pRst->MoveNext();
		}
		picRs->Release();
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		EndDialog(0);
		return TRUE;
    } 

	UpdateData(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}


void CDlgViewNeed::RefreshData()
{
	m_list.DeleteAllItems();
	m_list.SetRedraw(FALSE);	
	
	_RecordsetPtr pRst = NULL;
	
	IADORecordBinding   *picRs = NULL;  //Interface Pointer declared.(VC++ Extensions)   
	CDevNeedRs rs;
	try
	{
		_bstr_t strSQL("SELECT * FROM DEVICE_NEED");

		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst = m_DBCnt->Execute(strSQL, NULL, adCmdText);
		
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));

		int i = 0;
		while (!pRst->adoEOF)
		{
			m_list.InsertItem(0, rs.m_sz_code);
			m_list.SetItemText(i, 1, rs.m_sz_dept);
			m_list.SetItemText(i, 2, rs.m_sz_start);
			m_list.SetItemText(i, 3, rs.m_sz_end);
			m_list.SetItemText(i, 4, rs.m_sz_number);

			pRst->MoveNext();
		}
		picRs->Release();
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		m_list.SetRedraw(TRUE);	
		return;
    } 

	m_list.SetRedraw(TRUE);	
}

void CDlgViewNeed::OnBtnDnadd() 
{
	// TODO: Add your control notification handler code here
	if(u==2){
		u=1;
		see();
		return;
	}

	if (m_devs.GetCurSel()==CB_ERR)
	{
		MessageBox("请选择一个设备");
		return;
	}

	if (!UpdateData())
		return;

	if (m_dept.GetLength()<=0)
	{
		MessageBox("部门一项不能为空！");
		return;
	}

	_RecordsetPtr pRst = NULL;
	CDevNeedRs rs;

	try
	{
		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst->Open("device_need",_variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdTable);
      		
		m_devs.GetWindowText(rs.m_sz_code,11);
		strcpy(rs.m_sz_dept, m_dept);
		sprintf(rs.m_sz_start,"%d-%d-%d",
			m_start.GetYear(), m_start.GetMonth(), m_start.GetDay());
		sprintf(rs.m_sz_end,"%d-%d-%d",
			m_end.GetYear(), m_end.GetMonth(), m_end.GetDay());
		sprintf(rs.m_sz_number, "%f",m_number);

		COleSafeArray vaFieldlist, vaValuelist;
		rs.FillFieldsArray(vaFieldlist,vaValuelist);
		TESTHR(pRst->AddNew(vaFieldlist, vaValuelist));
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		return;
    } 

	RefreshData();
	MessageBox("完成操作！");
	m_log->AddLog("添加需求信息");

//	EndDialog(0);
}




void CDlgViewNeed::see()
{
	switch(u){
	case 1:
		m_CODE.EnableWindow(false);//使这个控件失效
		m_CODE.ShowWindow(false);//使这个控件不显示

		m_START.EnableWindow(false);
		m_START.ShowWindow(false);

		m_END.EnableWindow(false);
		m_END.ShowWindow(false);

		m_NUMBER.EnableWindow(false);
		m_NUMBER.ShowWindow(false);

		m_DEL.EnableWindow(false);



		m_devs.EnableWindow(true);//使这个控件失效
		m_devs.ShowWindow(true);//使这个控件显示

		m_START0.EnableWindow(true);
		m_START0.ShowWindow(true);

		m_DEPT.EnableWindow(true);

		m_END0.EnableWindow(true);
		m_END0.ShowWindow(true);

		m_NUMBER0.EnableWindow(true);
		m_NUMBER0.ShowWindow(true);
		break;




	case 2:
		m_CODE.EnableWindow(false);//使这个控件失效
		m_CODE.ShowWindow(true);//使这个控件显示

		m_START.EnableWindow(false);
		m_START.ShowWindow(true);

		m_DEPT.EnableWindow(false);

		m_END.EnableWindow(false);
		m_END.ShowWindow(true);

		m_NUMBER.EnableWindow(false);
		m_NUMBER.ShowWindow(true);

		m_DEL.EnableWindow(true);
		/////***********************************///////
		m_devs.EnableWindow(false);//使这个控件失效
		m_devs.ShowWindow(false);//使这个控件不显示

		m_START0.EnableWindow(false);
		m_START0.ShowWindow(false);

		m_END0.EnableWindow(false);
		m_END0.ShowWindow(false);

		m_NUMBER0.EnableWindow(false);
		m_NUMBER0.ShowWindow(false);
	}
}
💿 文件大小 347 K
👤 上传用户 glossary
📂 所属分类企业管理
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -