?? publicquery.cpp
字號:
// PublicQuery.cpp : implementation file
//
#include "stdafx.h"
#include "SoftDocSystem.h"
#include "PublicQuery.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CPublicQuery dialog
extern CString PublicUserName;
CPublicQuery::CPublicQuery(CWnd* pParent /*=NULL*/)
: CDialog(CPublicQuery::IDD, pParent)
{
//{{AFX_DATA_INIT(CPublicQuery)
m_SoftName = _T("");
m_SoftNumber = _T("");
m_Xinghao = _T("");
m_SoftType = _T("");
m_Author = _T("");
m_GeShi = _T("");
m_Stime = 0;
m_Etime = 0;
//}}AFX_DATA_INIT
}
void CPublicQuery::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CPublicQuery)
DDX_Control(pDX, IDC_COMBO5, m_AuthorCtrl);
DDX_Control(pDX, IDC_COMBO3, m_XinghaoCtrl);
DDX_Control(pDX, IDC_LIST1, m_List);
DDX_Control(pDX, IDC_TAB1, m_Tab);
DDX_CBString(pDX, IDC_COMBO1, m_SoftName);
DDX_CBString(pDX, IDC_COMBO2, m_SoftNumber);
DDX_CBString(pDX, IDC_COMBO3, m_Xinghao);
DDX_CBString(pDX, IDC_COMBO4, m_SoftType);
DDX_CBString(pDX, IDC_COMBO5, m_Author);
DDX_CBString(pDX, IDC_COMBO6, m_GeShi);
DDX_DateTimeCtrl(pDX, IDC_DATETIME1, m_Stime);
DDX_DateTimeCtrl(pDX, IDC_DATETIME2, m_Etime);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CPublicQuery, CDialog)
//{{AFX_MSG_MAP(CPublicQuery)
ON_NOTIFY(TCN_SELCHANGE, IDC_TAB1, OnSelchangeTab)
ON_BN_CLICKED(IDC_CHECK8, OnCheck8)
ON_BN_CLICKED(IDC_CHECK7, OnCheck7)
ON_WM_CLOSE()
ON_BN_CLICKED(IDC_BUTTON2, OnPrint)
ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
ON_WM_DESTROY()
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CPublicQuery message handlers
BOOL CPublicQuery::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
//初始化TAB空間
TC_ITEM* m_pTCItem;
m_pTCItem=new TC_ITEM;
m_pTCItem->mask=TCIF_TEXT;
m_pTCItem->pszText="軟件文檔庫存";
m_Tab.InsertItem(0,m_pTCItem);
m_pTCItem->pszText="用戶資料";
m_Tab.InsertItem(1,m_pTCItem);
m_pTCItem->pszText="借出文檔";
m_Tab.InsertItem(2,m_pTCItem);
m_pTCItem->pszText="作廢文檔";
m_Tab.InsertItem(3,m_pTCItem);
m_pTCItem->pszText="交易記錄";
m_Tab.InsertItem(4,m_pTCItem);
m_pTCItem->pszText="操作日志";
m_Tab.InsertItem(5,m_pTCItem);
ConnectDataBase();
InitList();
GetDlgItem(IDC_DATETIME1)->EnableWindow(false);
GetDlgItem(IDC_DATETIME2)->EnableWindow(false);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CPublicQuery::InitList()
{
UpdateData();
m_List.DeleteAllItems ();//狀態報告
for (int i=m_ListNumber-1;i>-1;i--)
m_List.DeleteColumn(i);
int Choice=m_Tab.GetCurSel();
switch(Choice)
{
case 0:
{
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,"所屬系統");
m_List.InsertColumn (7,"軟件編號");
m_List.InsertColumn (8,"入庫日期");
m_ListNumber=9;
RECT rect;
m_List.GetWindowRect(& rect);
int wid=(rect.right -rect.left );
m_List.SetColumnWidth(0,wid/8);
m_List.SetColumnWidth(1,wid/5);
m_List.SetColumnWidth(2,wid/10);
m_List.SetColumnWidth(3,wid/5);
m_List.SetColumnWidth(4,wid/4);
m_List.SetExtendedStyle (LVS_EX_FULLROWSELECT);
break; }
case 1:
{
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_ListNumber=6;
RECT rect;
m_List.GetWindowRect(& rect);
int wid=(rect.right -rect.left )/5;
m_List.SetColumnWidth(0,wid);
m_List.SetColumnWidth(1,wid);
m_List.SetColumnWidth(2,wid);
m_List.SetColumnWidth(3,wid);
m_List.SetColumnWidth(4,wid);
m_List.SetExtendedStyle (LVS_EX_FULLROWSELECT);
break; }
case 2:
{
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_ListNumber=6;
RECT rect;
m_List.GetWindowRect(& rect);
int wid=(rect.right -rect.left );
m_List.SetColumnWidth(0,wid/8);
m_List.SetColumnWidth(1,wid/5);
m_List.SetColumnWidth(2,wid/10);
m_List.SetColumnWidth(3,wid/5);
m_List.SetColumnWidth(4,wid/4);
m_List.SetExtendedStyle (LVS_EX_FULLROWSELECT);
break; }
case 3:
{
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,"所屬系統");
m_List.InsertColumn (7,"軟件編號");
m_List.InsertColumn (8,"入庫時間");
m_List.InsertColumn (9,"作廢日期");
m_ListNumber=10;
RECT rect;
m_List.GetWindowRect(& rect);
int wid=(rect.right -rect.left );
m_List.SetColumnWidth(0,wid/8);
m_List.SetColumnWidth(1,wid/5);
m_List.SetColumnWidth(2,wid/10);
m_List.SetColumnWidth(3,wid/5);
m_List.SetColumnWidth(4,wid/4);
m_List.SetExtendedStyle (LVS_EX_FULLROWSELECT);
break; }
case 4:
{
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,"交易時間");
m_ListNumber=7;
RECT rect;
m_List.GetWindowRect(& rect);
int wid=(rect.right -rect.left );
m_List.SetColumnWidth(0,wid/8);
m_List.SetColumnWidth(1,wid/5);
m_List.SetColumnWidth(2,wid/10);
m_List.SetColumnWidth(3,wid/5);
m_List.SetColumnWidth(4,wid/4);
m_List.SetExtendedStyle (LVS_EX_FULLROWSELECT);
break; }
case 5:
{
m_List.InsertColumn (0,"日志編號");
m_List.InsertColumn (1,"操作者");
m_List.InsertColumn (2,"操作類型");
m_List.InsertColumn (3,"操作內容");
m_List.InsertColumn (4,"操作時間");
m_ListNumber=5;
RECT rect;
m_List.GetWindowRect(& rect);
int wid=(rect.right -rect.left );
m_List.SetColumnWidth(0,wid/8);
m_List.SetColumnWidth(2,wid/10);
m_List.SetColumnWidth(3,wid/5);
m_List.SetColumnWidth(4,wid/4);
m_List.SetExtendedStyle (LVS_EX_FULLROWSELECT);
break; }
}
}
void CPublicQuery::OnSelchangeTab(NMHDR* pNMHDR, LRESULT* pResult)
{
// TODO: Add your control notification handler code here
UpdateData();
GetDlgItem(IDC_LIST1)->ShowWindow(SW_HIDE);
InitList();
GetDlgItem(IDC_LIST1)->ShowWindow(SW_SHOW);
((CButton*)GetDlgItem(IDC_CHECK8))->SetCheck(false);
int Choice=m_Tab.GetCurSel();
switch(Choice){
case 0:
{GetDlgItem(IDC_COMBO1)->EnableWindow(true);
GetDlgItem(IDC_COMBO2)->EnableWindow(true);
GetDlgItem(IDC_COMBO3)->EnableWindow(true);
GetDlgItem(IDC_COMBO4)->EnableWindow(true);
GetDlgItem(IDC_COMBO5)->EnableWindow(true);
((CButton*)GetDlgItem(IDC_CHECK7))->SetCheck(false);
GetDlgItem(IDC_CHECK7)->EnableWindow(false);
break;
}
case 1:
{GetDlgItem(IDC_COMBO1)->EnableWindow(false);
GetDlgItem(IDC_COMBO2)->EnableWindow(false);
GetDlgItem(IDC_COMBO3)->EnableWindow(false);
GetDlgItem(IDC_COMBO4)->EnableWindow(false);
GetDlgItem(IDC_COMBO5)->EnableWindow(false);
GetDlgItem(IDC_COMBO6)->EnableWindow(false);
((CButton*)GetDlgItem(IDC_CHECK7))->SetCheck(false);
GetDlgItem(IDC_CHECK7)->EnableWindow(false);
break;
}
case 2:
{GetDlgItem(IDC_COMBO1)->EnableWindow(false);
GetDlgItem(IDC_COMBO2)->EnableWindow(false);
GetDlgItem(IDC_COMBO3)->EnableWindow(false);
GetDlgItem(IDC_COMBO4)->EnableWindow(false);
GetDlgItem(IDC_COMBO5)->EnableWindow(false);
GetDlgItem(IDC_COMBO6)->EnableWindow(false);
((CButton*)GetDlgItem(IDC_CHECK7))->SetCheck(false);
GetDlgItem(IDC_CHECK7)->EnableWindow(false);
break;
}
case 3:
{GetDlgItem(IDC_COMBO1)->EnableWindow(false);
GetDlgItem(IDC_COMBO2)->EnableWindow(false);
GetDlgItem(IDC_COMBO3)->EnableWindow(false);
GetDlgItem(IDC_COMBO4)->EnableWindow(false);
GetDlgItem(IDC_COMBO5)->EnableWindow(false);
GetDlgItem(IDC_COMBO6)->EnableWindow(false);
((CButton*)GetDlgItem(IDC_CHECK7))->SetCheck(false);
GetDlgItem(IDC_CHECK7)->EnableWindow(false);
break;
}
case 4:
{GetDlgItem(IDC_COMBO1)->EnableWindow(false);
GetDlgItem(IDC_COMBO2)->EnableWindow(false);
GetDlgItem(IDC_COMBO3)->EnableWindow(false);
GetDlgItem(IDC_COMBO4)->EnableWindow(false);
GetDlgItem(IDC_COMBO5)->EnableWindow(false);
GetDlgItem(IDC_COMBO6)->EnableWindow(false);
((CButton*)GetDlgItem(IDC_CHECK7))->SetCheck(false);
GetDlgItem(IDC_CHECK7)->EnableWindow(true);
break;
}
case 5:
{GetDlgItem(IDC_COMBO1)->EnableWindow(false);
GetDlgItem(IDC_COMBO2)->EnableWindow(false);
GetDlgItem(IDC_COMBO3)->EnableWindow(false);
GetDlgItem(IDC_COMBO4)->EnableWindow(false);
GetDlgItem(IDC_COMBO5)->EnableWindow(false);
GetDlgItem(IDC_COMBO6)->EnableWindow(false);
((CButton*)GetDlgItem(IDC_CHECK7))->SetCheck(false);
GetDlgItem(IDC_CHECK7)->EnableWindow(true);
break;
}
}
*pResult = 0;
}
void CPublicQuery::FindSoftWare()
{
//條件查詢
CString sql_,str2,str;
_RecordsetPtr Myset;
CString geshi[6];
geshi[1]="軟盤";
geshi[2]="光盤";
geshi[4]="文本";
geshi[3]="硬盤";
geshi[5]="其他";
_variant_t Holder;
sql_="select * from SoftDocInfo where";
m_SoftName.TrimRight(" ");
m_Xinghao.TrimRight (" ");
m_SoftType.TrimRight (" ");
str.Format (" 軟件類型 ='%s'",m_SoftType);
if(!m_SoftType.IsEmpty ())sql_+=str;
str.Format (" and 軟件名稱 ='%s'", m_SoftName);
if(!m_SoftName.IsEmpty ())sql_+=str;
str.Format (" and 所屬型號 ='%s'",m_Xinghao);
if(!m_Xinghao.IsEmpty ())sql_+=str;
str.Format(" and 作者 ='%s'",m_Author);
if(!m_Author.IsEmpty ())sql_+=str;
str.Format (" or 軟件編號 ='%s'",m_SoftNumber);
if(!m_SoftNumber.IsEmpty ())sql_+=str;
str.Format (" and %s ='在家'",m_GeShi);
if(!m_GeShi.IsEmpty ())sql_+=str;
//查找所需軟件穩當
Myset.CreateInstance (__uuidof(Recordset));
_bstr_t Mysql=sql_;
_bstr_t source=m_strSource;
m_List.DeleteAllItems ();
try{
Myset->Open (Mysql,source,adOpenDynamic,adLockOptimistic,adCmdText);
}
catch(_com_error &e){
AfxMessageBox(e.ErrorMessage());return;}
int Shumu=0;
while(!Myset->adoEOF)//記錄數
{Shumu+=1;
Myset->MoveNext ();}
if(Shumu<1)return;
Myset->MoveFirst ();
int i=0;
int j=0;
CString mystr;
CString softnumber,softname,softauthor,softtype,softfunction,softxinghao,softxitong,softdate;
while(!Myset->adoEOF ){
//每一入庫格式一行
Holder=Myset->GetCollect ("軟件名稱");
if(Holder.vt!=VT_NULL)
{softname=(char*)(_bstr_t)Holder;
softname.TrimRight(" ");}
Holder=Myset->GetCollect ("軟件編號");
if(Holder.vt!=VT_NULL)
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -