?? dlginputquery3.cpp
字號:
// DlgInputQuery3.cpp : implementation file
//
#include "stdafx.h"
#include "bbb.h"
#include "DlgInputQuery3.h"
#include "PrintDoc.h"
#include "PrintFram.h"
#include "PrintView.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern _ConnectionPtr m_pCon; //ADO連接對象
extern _RecordsetPtr m_pRs;
extern CBbbApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CDlgInputQuery3 dialog
CDlgInputQuery3::CDlgInputQuery3(CWnd* pParent /*=NULL*/)
: CDialog(CDlgInputQuery3::IDD, pParent)
{
//{{AFX_DATA_INIT(CDlgInputQuery3)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void CDlgInputQuery3::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDlgInputQuery3)
DDX_Control(pDX, IDC_LIST1, m_list);
DDX_Control(pDX, IDC_EDIT1, m_value);
DDX_Control(pDX, IDC_DATETIMEPICKER2, m_endtime);
DDX_Control(pDX, IDC_DATETIMEPICKER1, m_strtime);
DDX_Control(pDX, IDC_COMBO1, m_fields);
DDX_Control(pDX, IDC_CHECK2, m_check2);
DDX_Control(pDX, IDC_CHECK1, m_check1);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDlgInputQuery3, CDialog)
//{{AFX_MSG_MAP(CDlgInputQuery3)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDlgInputQuery3 message handlers
void CDlgInputQuery3::CancelQuery()
{
m_check1.SetCheck(0);
m_check2.SetCheck(0);
m_fields.SetCurSel(-1);
m_value.SetWindowText("");
CTime temp = CTime::GetCurrentTime();
m_strtime.SetTime(&temp);
m_endtime.SetTime(&temp);
m_list.DeleteAllItems();
}
BOOL CDlgInputQuery3::OnInitDialog()
{
CDialog::OnInitDialog();
m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_ONECLICKACTIVATE|
LVS_EX_INFOTIP|LVS_EX_SUBITEMIMAGES|LVS_EX_GRIDLINES );
//向表格中添加列
m_list.InsertColumn(0,"入庫單號");
m_list.InsertColumn(1,"書籍名稱");
m_list.InsertColumn(2,"條形碼");
m_list.InsertColumn(3,"作者");
m_list.InsertColumn(4,"出版社");
m_list.InsertColumn(5,"定價");
m_list.InsertColumn(6,"數(shù)量");
m_list.SetColumnWidth(0,100);
m_list.SetColumnWidth(1,100);
m_list.SetColumnWidth(2,100);
m_list.SetColumnWidth(3,80);
m_list.SetColumnWidth(4,80);
m_list.SetColumnWidth(5,60);
m_list.SetColumnWidth(6,60);
arrays[1] ="圖書名稱";
arrays[2] ="條形碼";
arrays[3] ="作者";
arrays[4] ="出版社";
arrays[5] ="價格";
arrays[6] ="數(shù)量";
arrays[0] ="入庫單號";
CancelQuery();
return TRUE;
}
BOOL CDlgInputQuery3::PreTranslateMessage(MSG* pMsg)
{
if (pMsg->message== WM_KEYDOWN)
if (pMsg->wParam ==13)
pMsg->wParam =9;
return CDialog::PreTranslateMessage(pMsg);
}
void CDlgInputQuery3::Print()
{
CBbbApp * app=(CBbbApp*)AfxGetApp();
app->m_main =app->m_pMainWnd;
app->m_pMainWnd = NULL;
report.m_plist = &m_list;
report.verinterval = 20;
report.title = "入庫單";
report.fields = arrays;
report.lmargin = 40;
report.rmargin = 40;
report.framtilte = "打印";
app->m_pDocManager->OnFileNew();
CPrintFram * temp=(CPrintFram*)app->m_pMainWnd;
temp->SetTitle(report.framtilte);
}
void CDlgInputQuery3::OnOK()
{
//
}
void CDlgInputQuery3::Query()
{
if ((m_check1.GetCheck() ==false)&&(m_check2.GetCheck()==false))
{
MessageBox("請設(shè)置查詢條件","提示",64);
return;
}
if ( (m_check1.GetCheck()==true)&&(m_check2.GetCheck()==false))
{
CString c_field,c_value;
m_fields.GetWindowText(c_field);
m_value.GetWindowText(c_value);
if (c_field.IsEmpty()||(c_value.IsEmpty()))
{
MessageBox("請設(shè)置查詢條件","提示",64);
return;
}
CString sql;
m_list.DeleteAllItems();
switch (m_fields.GetCurSel())
{
case 0:
{
c_field = "bookname";
sql.Format(" select a.instockid,b.bookname,b.barcode,\
b.author,b.bookconcern,a.unitprice,a.numbers from \
tb_instock_sub a inner join tb_bookinfo b on \
a.barcode = b.barcode and b.%s = '%s' ",c_field,c_value);
break;
}
case 1:
{
c_field = "barcode";
sql.Format(" select a.instockid,b.bookname,b.barcode,\
b.author,b.bookconcern,a.unitprice,a.numbers from \
tb_instock_sub a inner join tb_bookinfo b on \
a.barcode = b.barcode and b.%s = '%s' ",c_field,c_value);
break;
}
case 2:
{
c_field = "instockid";
sql.Format(" select a.instockid,b.bookname,b.barcode,\
b.author,b.bookconcern,a.unitprice,a.numbers from \
tb_instock_sub a inner join tb_bookinfo b on \
a.barcode = b.barcode and a.%s = '%s' ",c_field,c_value);
break;
}
case 3:
{
c_field = "Operator" ;
sql.Format(" select a.instockid,b.bookname,b.barcode,\
b.author,b.bookconcern,a.unitprice,a.numbers from \
tb_instock_sub a inner join tb_bookinfo b on \
a.barcode = b.barcode inner join tb_instorage_main \
c on a.instockid = c.id and c.%s = '%s' ",c_field,c_value);
break;
}
case 4:
{
c_field = "provider" ;
sql.Format(" select a.instockid,b.bookname,b.barcode,\
b.author,b.bookconcern,a.unitprice,a.numbers from \
tb_instock_sub a inner join tb_bookinfo b on \
a.barcode = b.barcode inner join tb_instorage_main \
c on a.instockid = c.id and c.%s = '%s' ",c_field,c_value);
break;
}
}
m_pRs->raw_Close();
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
int row = 0;
while (! m_pRs->adoEOF)
{
CString temp;
m_list.InsertItem(1000,"");
for (int i = 0;i<7;i++)
{
temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem((long)i)->Value;
m_list.SetItemText(row,i,temp);
}
m_pRs->MoveNext();
row +=1;
}
}
else if ((m_check1.GetCheck()==false)&&(m_check2.GetCheck()==true))
{
m_list.DeleteAllItems();
CString sql,c_starttime,c_endtime;
m_strtime.GetWindowText(c_starttime);
m_endtime.GetWindowText(c_endtime);
sql.Format(" select a.instockid,b.bookname,b.barcode,b.author,\
b.bookconcern,a.unitprice,a.numbers from tb_instock_sub a \
inner join tb_bookinfo b on a.barcode = b.barcode inner join \
tb_instorage_main c on a.instockid = c.id and c.intime between \
'%s' and '%s' ",c_starttime,c_endtime);
m_pRs->raw_Close();
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
int row = 0;
while (! m_pRs->adoEOF)
{
CString temp;
m_list.InsertItem(1000,"");
for (int i = 0;i<7;i++)
{
temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem((long)i)->Value;
m_list.SetItemText(row,i,temp);
}
m_pRs->MoveNext();
row +=1;
}
}
else
{
CString c_field,c_value;
m_fields.GetWindowText(c_field);
m_value.GetWindowText(c_value);
if (c_field.IsEmpty()||(c_value.IsEmpty()))
{
MessageBox("請設(shè)置查詢條件","提示",64);
return;
}
CString sql,c_starttime,c_endtime;
m_strtime.GetWindowText(c_starttime);
m_endtime.GetWindowText(c_endtime);
if (c_field.IsEmpty()||(c_value.IsEmpty()))
{
MessageBox("請設(shè)置查詢條件","提示",64);
return;
}
m_list.DeleteAllItems();
switch (m_fields.GetCurSel())
{
case 0:
{
c_field = "bookname";
sql.Format(" select a.instockid,b.bookname,b.barcode,b.author,\
b.bookconcern,a.unitprice,a.numbers from tb_instock_sub a \
inner join tb_bookinfo b on a.barcode = b.barcode and b.%s \
= '%s' inner join tb_instorage_main c on a.instockid = c.id \
and c.intime between '%s' and '%s' ",c_field,c_value,
c_starttime,c_endtime);
break;
}
case 1:
{
c_field = "barcode";
sql.Format(" select a.instockid,b.bookname,b.barcode,b.author,\
b.bookconcern,a.unitprice,a.numbers from tb_instock_sub \
a inner join tb_bookinfo b on a.barcode = b.barcode and \
b.%s = '%s' inner join tb_instorage_main c on a.instockid \
= c.id and c.intime between '%s' and '%s' ",c_field,
c_value,c_starttime,c_endtime);
break;
}
case 2:
{
c_field = "instockid";
sql.Format(" select a.instockid,b.bookname,b.barcode,b.author,\
b.bookconcern,a.unitprice,a.numbers from tb_instock_sub \
a inner join tb_bookinfo b on a.barcode = b.barcode and \
a.%s = '%s' inner join tb_instorage_main c on a.instockid \
= c.id and c.intime between '%s' and '%s' ",c_field,
c_value,c_starttime,c_endtime);
break;
}
case 3:
{
c_field = "Operator" ;
sql.Format(" select a.instockid,b.bookname,b.barcode,b.author,\
b.bookconcern,a.unitprice,a.numbers from tb_instock_sub \
a inner join tb_bookinfo b on a.barcode = b.barcode inner \
join tb_instorage_main c on a.instockid = c.id and c.%s = \
'%s' and c.intime between '%s' and '%s' ",c_field,
c_value,c_starttime,c_endtime);
break;
}
case 4:
{
c_field = "provider" ;
sql.Format(" select a.instockid,b.bookname,b.barcode,b.author,\
b.bookconcern,a.unitprice,a.numbers from tb_instock_sub \
a inner join tb_bookinfo b on a.barcode = b.barcode inner \
join tb_instorage_main c on a.instockid = c.id and c.%s = \
'%s' and c.intime between '%s' and '%s' ",c_field,
c_value,c_starttime,c_endtime);
break;
}
}
m_pRs->raw_Close();
m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
int row = 0;
while (! m_pRs->adoEOF)
{
CString temp;
m_list.InsertItem(1000,"");
for (int i = 0;i<7;i++)
{
temp = (TCHAR *)(_bstr_t)m_pRs->GetFields()->GetItem((long)i)->Value;
m_list.SetItemText(row,i,temp);
}
m_pRs->MoveNext();
row +=1;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -