// AssetsSelectDlg.cpp : implementation file
//

#include "stdafx.h"
#include "AssetsMan.h"
#include "AssetsSelectDlg.h"
#include "Assets.h"
#include "columns.h"
#include "column.h"
#include "COMDEF.H"
#include "_recordset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAssetsSelectDlg dialog


CAssetsSelectDlg::CAssetsSelectDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAssetsSelectDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAssetsSelectDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CAssetsSelectDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAssetsSelectDlg)
	DDX_Control(pDX, IDC_TYPE_COMBO, m_type);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc1);
	DDX_Control(pDX, IDC_ADODC2, m_Adodc2);
	DDX_Control(pDX, IDC_DATAGRID1, m_DataGrid);
	DDX_Control(pDX, IDC_SEARCH_DATACOMBO, m_search);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAssetsSelectDlg, CDialog)
	//{{AFX_MSG_MAP(CAssetsSelectDlg)
	ON_CBN_SELCHANGE(IDC_TYPE_COMBO, OnSelchangeTypeCombo)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAssetsSelectDlg message handlers
// 刷新DataGrid數據，顯示所有固定資產信息
void CAssetsSelectDlg::RefreshData()
{
	CString csql;
	csql = "SELECT a.Id AS 編號,a.Aid AS 資產編號,a.Aname AS 資產名稱,a.TypeId,";
	csql += "t.TypeName AS 類型,a.Status AS 狀態,a.Model AS 型號,a.Producer AS 生產廠商,";
	csql += "a.UseDate AS 使用日期,a.UsedYear AS 使用年限,a.OrgPrice AS 原值,a.Ratio AS 殘值率,";
	csql += "a.DeptId, d.DeptName AS 使用部門,a.RepPerson AS 負責人,";
	csql += "a.AddWay AS 增加方式,a.PostDate AS 提交日期,";
	csql += "a.IsAudit,(CASE WHEN a.IsAudit=0 THEN '未審核' WHEN a.IsAudit=1 THEN '審核' WHEN a.IsAudit=2 THEN '變更' END) AS 是否審核";
	csql += " FROM Assets a,Departments d,Type t ";
	csql += " WHERE a.TypeId=t.TypeId AND a.DeptId=d.DeptId";
	// 判斷查詢條件
	if (cSearchValue == "")
		cSearchValue = "0";
	if(m_type.GetCurSel() == 1)			//按類別查詢
		csql = csql + " AND a.TypeId=" + cSearchValue;
	else if(m_type.GetCurSel() == 2)		//按部門查詢
		csql = csql + " AND a.DeptId=" + cSearchValue;
//MessageBox(csql);
	//設置記錄源
	m_Adodc1.SetRecordSource(csql);
	m_Adodc1.Refresh();

	//設置列寬度
	_variant_t vIndex;
	vIndex = long(0);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(2);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(3);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(4);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(5);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(6);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(7);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(100);
	vIndex = long(8);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(70);
	vIndex = long(9);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(10);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(11);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(12);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(13);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(14);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(15);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(16);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(70);
	vIndex = long(17);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(18);
	m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);
}

BOOL CAssetsSelectDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// 顯示全部固定資產信息
	m_type.SetCurSel(0);
	// 全部情況下隱藏列表 
	GetDlgItem(IDC_SEARCH_DATACOMBO)->ShowWindow(SW_HIDE);
	// 刷新列表
	RefreshData();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CAssetsSelectDlg::OnSelchangeTypeCombo() 
{
	int iSel;
	iSel = m_type.GetCurSel();  //讀取選擇的查詢類別	
	// 置查詢列表初始為空
	m_search.SetText("");
	if (iSel == 1)			// 按類別查詢
	{
		// 設置數據源（為查詢列表提供數據源）
		m_Adodc2.SetRecordSource("SELECT * FROM Type");
		m_Adodc2.Refresh();
		// 設置顯示列和綁定列
		m_search.SetListField("TypeName");
		m_search.SetBoundColumn("TypeId");
		m_search.Refresh();
		// 顯示列表
		GetDlgItem(IDC_SEARCH_DATACOMBO)->ShowWindow(SW_SHOW);
	}
	else if (iSel == 2)		// 按部門查詢
	{
		// 設置數據源（為查詢列表提供數據源）
		m_Adodc2.SetRecordSource("SELECT * FROM Departments");
		m_Adodc2.Refresh();
		// 設置顯示列和綁定列
		m_search.SetListField("DeptName");
		m_search.SetBoundColumn("DeptId");
		m_search.Refresh();
		GetDlgItem(IDC_SEARCH_DATACOMBO)->ShowWindow(SW_SHOW);
	}
	else					// 顯示全部資產記錄
	{
		// 隱藏列表 
		GetDlgItem(IDC_SEARCH_DATACOMBO)->ShowWindow(SW_HIDE);
	}
	UpdateData(FALSE);	
	//刷新記錄
	RefreshData();	
}

BEGIN_EVENTSINK_MAP(CAssetsSelectDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CAssetsSelectDlg)
	ON_EVENT(CAssetsSelectDlg, IDC_SEARCH_DATACOMBO, -600 /* Click */, OnClickSearchDatacombo, VTS_I2)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CAssetsSelectDlg::OnClickSearchDatacombo(short Area) 
{
	// 得到選擇的列值，刷新記錄
	cSearchValue = m_search.GetBoundText();
	RefreshData();	
}

void CAssetsSelectDlg::OnOK() 
{
	CardId = m_DataGrid.GetItem(0);			//記錄編號
	AssetsId = m_DataGrid.GetItem(1);		//固定資產編號
	AssetsName = m_DataGrid.GetItem(2);		//固定資產名稱
	
	CDialog::OnOK();
}