// DlgRkQuery.cpp : implementation file
//

#include "stdafx.h"
#include "a1.h"
#include "DlgRkQuery.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgRkQuery dialog


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


void CDlgRkQuery::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgRkQuery)
	DDX_Control(pDX, IDC_LIST_RK_VIEW, m_listRK);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgRkQuery, CDialog)
	//{{AFX_MSG_MAP(CDlgRkQuery)
	ON_BN_CLICKED(IDC_BUTTON_OK, OnButtonOk)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST_RK_VIEW, OnDblclkListRkView)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgRkQuery message handlers

void CDlgRkQuery::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDlgRkQuery::OnButtonOk() 
{
	int mark=this->m_listRK.GetSelectionMark();
	if(mark>=0)
	{
		
		m_sRk_ph=m_listRK.GetItemText(mark,0);
		this->EndDialog(0);
	}
	else
		return ;

}

bool CDlgRkQuery::InitRkListView()
{
	this->m_listRK.ModifyStyle(LVS_EDITLABELS, 0L);		//禁止標題編輯
	m_listRK.ModifyStyle(0L, LVS_REPORT);			//設為Report類型
	m_listRK.ModifyStyle(0L, LVS_SHOWSELALWAYS);		//始終高亮度被選中的表項
	m_listRK.SetBkColor(RGB(0,200,200));
	m_listRK.SetTextBkColor(RGB(0,200,200));
	m_listRK.ModifyStyle(LVS_OWNERDRAWFIXED ,0L);
	m_listRK.SetExtendedStyle( LVS_EX_FULLROWSELECT |		//允許整行選中
		LVS_EX_HEADERDRAGDROP |		//允許整列拖動
		LVS_EX_GRIDLINES |	//畫出網格線
	//	LVS_EX_ONECLICKACTIVATE |	//單擊選中表項
		LVS_EX_FLATSB				//扁平風格的滾動條	
	//	LVS_EX_UNDERLINEHOT 
		);	
	int i=0;
	m_listRK.InsertColumn( i, "入庫票號" );
	m_listRK.InsertColumn( 1, "藥品編號" );
	m_listRK.InsertColumn( 2, "藥品名稱" );
	m_listRK.InsertColumn( 3, "供應商編號" );
	m_listRK.InsertColumn( 4, "供應商名稱" );
	m_listRK.InsertColumn( 5, "倉庫名稱" );
	m_listRK.InsertColumn( 6, "應收金額" );
	m_listRK.InsertColumn( 7, "實收金額" );
	m_listRK.InsertColumn( 8, "未收金額" );
	m_listRK.InsertColumn( 9, "品種數" );
	m_listRK.InsertColumn( 10, "日期" );
	m_listRK.InsertColumn( 11, "結算方式" );
	m_listRK.InsertColumn( 12, "是否結清" );
	m_listRK.InsertColumn( 13, "操作員" );
	m_listRK.InsertColumn( 14, "經手人" );


	for( i=0; i<15; i++ )
	{
		m_listRK.SetColumnWidth( i, LVSCW_AUTOSIZE_USEHEADER );
	}
	
	m_listRK.Invalidate();
	return true;
}

bool CDlgRkQuery::RefreshRkListView(CString sql)
{

//	if(!this->m_runsql.CheckSQLResult(sql));
//	_variant_t value;
	m_listRK.DeleteAllItems();
	m_listRK.SetRedraw(false);

	_variant_t value;

/*	CString del_sql;
	del_sql.Format("delete * from %s",this->m_sLstables[this->m_iCurTable]);
	int i=0;
	try{
	sql_=del_sql;
	m_recordset=m_database->Execute(sql_,NULL,adCmdText);
	sql_=sql;
	m_recordset=m_database->Execute(sql_,NULL,adCmdText);
	sql.Format("select * from %s",this->m_sLstables[this->m_iCurTable]);
	sql_=sql;
	m_recordset=m_database->Execute(sql_,NULL,adCmdText);

	m_recordset->MoveFirst();*/
	int i=0;
	if(m_runsql.CheckSQLResult(sql))
	{
		while(!this->m_runsql.m_recordset->adoEOF)
		{
			value=m_runsql.m_recordset->GetCollect("rk_ph");
			if(value.vt!=NULL)
			{
				this->m_listRK.InsertItem(i,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("yp_id");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,1,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("yp_name");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,2,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("gys_id");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,3,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("gys_name");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,4,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("ck_name");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,5,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("yf");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,6,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("sf");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,7,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("wf");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,8,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("pzs");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,9,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("rq");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,10,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("jsfs");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,11,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("is_jq");
			if(value.vt!=NULL)
			{
				CString isjq;
				bool a=value.boolVal;
				if(a)isjq="已結清";
				else isjq="未結清";
				this->m_listRK.SetItemText(i,12,isjq);
			}
			value=m_runsql.m_recordset->GetCollect("czy");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,13,(char*)(_bstr_t)value);
			}
			value=m_runsql.m_recordset->GetCollect("jsr");
			if(value.vt!=NULL)
			{
				this->m_listRK.SetItemText(i,14,(char*)(_bstr_t)value);
			}
			m_runsql.m_recordset->MoveNext();

		}
	
		for( i=0; i<15; i++ )
		{
			m_listRK.SetColumnWidth( i, LVSCW_AUTOSIZE );
		}
	}
	else
	{
		m_listRK.DeleteAllItems();
		for( i=0; i<15; i++ )
		{
			m_listRK.SetColumnWidth( i, LVSCW_AUTOSIZE_USEHEADER);
		}

	}
	m_listRK.SetRedraw(true);
	m_listRK.Invalidate();	
	return true;
}


BOOL CDlgRkQuery::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	this->InitRkListView();
	this->RefreshRkListView("select * from viewrk");
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgRkQuery::OnDblclkListRkView(NMHDR* pNMHDR, LRESULT* pResult) 
{
this->OnButtonOk();
	*pResult = 0;
}