【VC开源代码栏目提醒】:以下是网学会员为您推荐的VC开源代码-DlgRkQuery.cpp,希望本篇文章对您学习有所帮助。
// 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;
}
上一篇:
DlgRj.cpp
下一篇:
学术论文摘要的定义及写作基本要求