slabhisformview.cpp

开发环境为VC++ 的数据库管理系统

// SlabHisFormView.cpp : implementation file
//

#include "stdafx.h"
#include "mestang.h"
#include "SlabHisFormView.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSlabHisFormView

IMPLEMENT_DYNCREATE(CSlabHisFormView, CFormView)

CSlabHisFormView::CSlabHisFormView()
	: CFormView(CSlabHisFormView::IDD)
{
	//{{AFX_DATA_INIT(CSlabHisFormView)
	m_date_search = 0;
	//}}AFX_DATA_INIT
}

CSlabHisFormView::~CSlabHisFormView()
{
}

void CSlabHisFormView::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSlabHisFormView)
	DDX_Control(pDX, IDC_SHIFT_SEARCH, m_shift_search);
	DDX_Control(pDX, IDC_CONDICTION, m_condic_select);
	DDX_Control(pDX, IDC_LIST_SLAB_HIS, m_list_slab_his);
	DDX_DateTimeCtrl(pDX, IDC_DATE_INPUT_SEARCH, m_date_search);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSlabHisFormView, CFormView)
	//{{AFX_MSG_MAP(CSlabHisFormView)
	ON_WM_DESTROY()
	ON_BN_CLICKED(IDHisSearch, OnHisSearch)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSlabHisFormView diagnostics

#ifdef _DEBUG
void CSlabHisFormView::AssertValid() const
{
	CFormView::AssertValid();
}

void CSlabHisFormView::Dump(CDumpContext& dc) const
{
	CFormView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CSlabHisFormView message handlers

void CSlabHisFormView::OnInitialUpdate() 
{
	CFormView::OnInitialUpdate();
	
	// TODO: Add your specialized code here and/or call the base class
	//设置列表框控件字体
	CFont m_ListFont;
    m_ListFont.CreateFont(16,0,0,0,FW_NORMAL, 0,0,0,DEFAULT_CHARSET, OUT_CHARACTER_PRECIS, CLIP_CHARACTER_PRECIS,DEFAULT_QUALITY, DEFAULT_PITCH | FF_DONTCARE, "Times New Roman");
    m_list_slab_his.SetFont(&m_ListFont);

	//设置LIST_SLAB_HIS的框架大小
	m_list_slab_his.SetWindowPos(NULL,0,0,1242,616,SWP_NOMOVE|SWP_NOZORDER | SWP_NOACTIVATE);
	m_list_slab_his.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_INFOTIP | LVS_EDITLABELS);
	m_list_slab_his.SetBkColor(RGB(224,255,255));
	m_list_slab_his.SetTextBkColor(RGB(230 ,230 ,250));
	m_list_slab_his.SetTextColor(RGB(85 ,26 ,139 ));
	//设置列表框LIST_SLAB_HIS标题名字
	int k=0;
	m_list_slab_his.InsertColumn(k++,"炉号",LVCFMT_CENTER,100);
	m_list_slab_his.InsertColumn(k++,"入库数(块)",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"已挂料数(块)",LVCFMT_CENTER,100);	
	m_list_slab_his.InsertColumn(k++,"库存数(块)",LVCFMT_CENTER,100);		
	m_list_slab_his.InsertColumn(k++,"板坯类型",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"钢种",LVCFMT_CENTER,60);
	m_list_slab_his.InsertColumn(k++,"板坯厚度(mm)",LVCFMT_CENTER,80);	
	m_list_slab_his.InsertColumn(k++,"板坯宽度(mm)",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"板坯长度(mm)",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"班次",LVCFMT_CENTER,80);	
	m_list_slab_his.InsertColumn(k++,"操作者",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"入库日期",LVCFMT_CENTER,140);	
	m_list_slab_his.InsertColumn(k++,"C",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"Si",LVCFMT_CENTER,80);	
	m_list_slab_his.InsertColumn(k++,"Mn",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"P",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"S",LVCFMT_CENTER,80);	
	m_list_slab_his.InsertColumn(k++,"Nb",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"V",LVCFMT_CENTER,80);	
	m_list_slab_his.InsertColumn(k++,"Ti",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"Al",LVCFMT_CENTER,60);	
	m_list_slab_his.InsertColumn(k++,"Cu",LVCFMT_CENTER,80);
    m_list_slab_his.InsertColumn(k++,"Ni",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"元素1",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"元素1含量",LVCFMT_CENTER,80);	
	m_list_slab_his.InsertColumn(k++,"元素2",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"元素2含量",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"元素3",LVCFMT_CENTER,80);
	m_list_slab_his.InsertColumn(k++,"元素3含量",LVCFMT_CENTER,80);
	m_condic_select.SetCurSel(0);
	m_shift_search.SetCurSel(0);
	m_date_search = CTime::GetCurrentTime();
	UpdateData(false);
}

void CSlabHisFormView::OnDestroy() 
{
	CFormView::OnDestroy();
	
	// TODO: Add your message handler code here
	
}

void CSlabHisFormView::OnHisSearch() 
{
	// TODO: Add your control notification handler code here
	m_list_slab_his.DeleteAllItems();	
	UpdateData(TRUE);
	int condiction_no = m_condic_select.GetCurSel();
	CString select_shift,select_date,si;
	switch(condiction_no)
	{
	case 1:
		{
			m_shift_search.GetLBText(m_shift_search.GetCurSel(),si);
			select_shift.Format("'%s'",si);
			select_date = m_date_search.Format("'%Y-%m-%d'");   //CTime->CString
			theApp.open_mes();
			resultset &rs_cast = *(theApp.cn).select ("select * from  CAST_RECORD where SHIFT="+select_shift+" and INPUT_DATE="+select_date+" order by STEEL_TYPE desc");
			SlabInfo_List_Update(m_list_slab_his,rs_cast);	
			theApp.cn.close();
			break;
		}
	default:
		{
			theApp.open_mes();
			resultset &rs_cast = *(theApp.cn).select ("select * from  CAST_RECORD  order by STEEL_TYPE desc");
			SlabInfo_List_Update(m_list_slab_his,rs_cast);	
			theApp.cn.close();
			break;
		}
	}	
}