?? provide.cpp
字號:
// provide.cpp : implementation file
//
#include "stdafx.h"
#include "shop.h"
#include "provide.h"
#include "goodinformation.h"
#include "offer.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CShopApp theApp;
//static int quanju;
/////////////////////////////////////////////////////////////////////////////
// Cprovide dialog
Cprovide::Cprovide(CWnd* pParent /*=NULL*/)
: CDialog(Cprovide::IDD, pParent)
{
//{{AFX_DATA_INIT(Cprovide)
m_amount = _T("");
m_date = _T("");
m_goodno = _T("");
m_offno = _T("");
//}}AFX_DATA_INIT
}
void Cprovide::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(Cprovide)
DDX_Control(pDX, IDC_offno, m_offno1);
DDX_Control(pDX, IDC_goodno, m_goodno1);
DDX_Control(pDX, IDC_USERLIST, m_userlist);
DDX_Text(pDX, IDC_amount, m_amount);
DDX_Text(pDX, IDC_date, m_date);
DDX_CBString(pDX, IDC_goodno, m_goodno);
DDX_CBString(pDX, IDC_offno, m_offno);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(Cprovide, CDialog)
//{{AFX_MSG_MAP(Cprovide)
ON_NOTIFY(LVN_ITEMCHANGED, IDC_USERLIST, OnItemchangedUserlist)
ON_CBN_DROPDOWN(IDC_offno, OnDropdownoffno)
ON_CBN_SELCHANGE(IDC_goodno, OnSelchangegoodno)
ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
ON_CBN_KILLFOCUS(IDC_goodno, OnKillfocusgoodno)
ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// Cprovide message handlers
BOOL Cprovide::OnInitDialog()
{
CDialog::OnInitDialog();
fun();
quanju = 0;
fun11 = true;
fun22 = true;
// TODO: Add extra initialization here
::SendMessage(m_userlist.m_hWnd, LVM_SETEXTENDEDLISTVIEWSTYLE,LVS_EX_FULLROWSELECT, LVS_EX_FULLROWSELECT);//當被選中時，所有子項都處于選中狀態(tài)
//////////為列表控件添加列//////////
m_userlist.InsertColumn(0,"供應商編號",LVCFMT_LEFT,80);
m_userlist.InsertColumn(1,"商品編號",LVCFMT_LEFT,80);
m_userlist.InsertColumn (2,"數(shù)量",LVCFMT_LEFT,80);
m_userlist.InsertColumn(3,"日期",LVCFMT_LEFT,100);
//////////讀取數(shù)據(jù)庫中的信息添加到列表控件///////////
displayintheuserlist();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void Cprovide::displayintheuserlist()
{
//////////讀取數(shù)據(jù)庫中的信息添加到列表控件///////////
try
{
m_userlist.DeleteAllItems();
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("select * from provide order by offno",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
//m_bSuccess = TRUE;
while(!m_pRecordset->adoEOF)
{
voffno= m_pRecordset->GetCollect("offno");
vgoodno= m_pRecordset->GetCollect("goodno");
vamount = m_pRecordset->GetCollect("amount");
vdate= m_pRecordset->GetCollect("date");
//this->AbleFalse();
//this->LoadData();
//this->GetDlgItem(IDC_BUTTON4)->EnableWindow(FALSE);
//this->GetDlgItem(IDC_BUTTON2)->EnableWindow(FALSE);
nItem=m_userlist.InsertItem(0xffff,(_bstr_t)voffno);//先插第一個項
m_userlist.SetItem(nItem,1,1,(_bstr_t)vgoodno,NULL,0,0,0);
m_userlist.SetItem(nItem,2,1,(_bstr_t)vamount ,NULL,0,0,0);
m_userlist.SetItem(nItem,3,1,(_bstr_t)vdate ,NULL,0,0,0);
m_pRecordset->MoveNext();
}
}
catch(_com_error e)///捕捉異常
{
//AfxMessageBox("讀取數(shù)據(jù)庫失敗!");///顯示錯誤信息
}
}
void Cprovide::OnItemchangedUserlist(NMHDR* pNMHDR, LRESULT* pResult)
{
NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
// TODO: Add your control notification handler code here
if(pNMListView->uNewState&LVIS_SELECTED)
{
//UpdateData(true);
//SaveData();///保存舊數(shù)據(jù)
m_nCurrentSel = pNMListView->iItem;
LoadData0();///加載新數(shù)據(jù)
//m_cdelitem.EnableWindow();
}
*pResult = 0;
}
void Cprovide::LoadData0()
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("select * from provide order by offno",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
m_pRecordset->Move(m_nCurrentSel,_variant_t((long)adBookmarkFirst));//從第一條記錄移動
voffno = m_pRecordset->GetCollect("offno");
vgoodno = m_pRecordset->GetCollect("goodno");
vamount = m_pRecordset->GetCollect("amount");
vdate = m_pRecordset->GetCollect("date");
UpdateData(true);//使得控件顯示值
//m_num = vNum.lVal;
// m_name = (LPCTSTR)(_bstr_t)vName;
//m_sex = vSex.lVal;
/// m_brithday = vBrithday.lVal;
//m_tel=vTel.lVal;
//m_addr=vAddr.lVal;
m_offno= (LPCTSTR)(_bstr_t)voffno;
m_goodno = (LPCTSTR)(_bstr_t)vgoodno;
m_amount = (LPCTSTR)(_bstr_t)vamount;
m_date= (LPCTSTR)(_bstr_t)vdate;
//m_pRecordset->Move(m_nCurrentSel,_variant_t((long)adBookmarkFirst));//從第一條記錄移動
UpdateData(FALSE);//使得控件顯示值
}
void Cprovide::OnDropdownoffno()
{
//AfxMessageBox("讀取數(shù)據(jù)庫失敗!");
// AfxMessageBox("讀取數(shù)據(jù)庫失敗!");
//fun1();
}
void Cprovide::fun1()
{
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("select offno from provide order by offno",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
while(!m_pRecordset->adoEOF)
{
//// m_pRecordset->Move(m_nCurrentSel,_variant_t((long)adBookmarkFirst));//從第一條記錄移動
voffno = m_pRecordset->GetCollect("offno");
str1 = (LPCTSTR)(_bstr_t)voffno + '\r\n';
}
m_offno = str1;
}
catch(_com_error e)///捕捉異常
{
// AfxMessageBox("刪除記錄失敗!");///顯示錯誤信息
}
// UpdateData(true);//使得控件顯示值
//m_num = vNum.lVal;
// m_name = (LPCTSTR)(_bstr_t)vName;
//m_sex = vSex.lVal;
/// m_brithday = vBrithday.lVal;
//m_tel=vTel.lVal;
//m_addr=vAddr.lVal;m_offno
//m_pRecordset->Move(m_nCurrentSel,_variant_t((long)adBookmarkFirst));//從第一條記錄移動
UpdateData(FALSE);//使得控件顯示值
}
void Cprovide::fun()
{
CString vgoodno1;
try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("select goodno from good",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
while(!m_pRecordset->adoEOF)
{
vgoodno = m_pRecordset->GetCollect("goodno");
vgoodno1 = (LPCTSTR)(_bstr_t)vgoodno;
m_goodno1.AddString(vgoodno1);
m_pRecordset->MoveNext();
}
}
catch(_com_error e)///捕捉異常
{
//AfxMessageBox("讀取數(shù)據(jù)庫失敗!");///顯示錯誤信息
}
}
void Cprovide::funoffno()
{
CString voffno1 ,vgoodno1,vgoodno11,vgoodno12,sql1;
UpdateData(true);
for(int i=0;i<quanju;i++)
m_offno1.DeleteString(0);
quanju = 0;
try
{
m_goodno = "'"+m_goodno + "'";
sql1 = " select distinct offno from provide where goodno = " + m_goodno ;
m_pRecordset->Close();
m_pRecordset = NULL;
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)sql1,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
//m_pRecordset->Open("select offno,goodno from provide",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
while(!m_pRecordset->adoEOF)
{
voffno = m_pRecordset->GetCollect("offno");
//vgoodno = m_pRecordset->GetCollect("goodno");
voffno1 = (LPCTSTR)(_bstr_t)voffno;
//vgoodno1 = (LPCTSTR)(_bstr_t)vgoodno;
//AfxMessageBox("讀取數(shù)vvvvv據(jù)庫失敗!");
m_offno1.AddString(voffno1);
quanju = quanju + 1;
m_pRecordset->MoveNext();
}
}
catch(_com_error e)///捕捉異常
{
//AfxMessageBox("讀取數(shù)vvvvv據(jù)庫失敗!");///顯示錯誤信息
}
}
void Cprovide::OnSelchangegoodno()
{
//AfxMessageBox("讀取數(shù)據(jù)庫失敗!");
//funoffno();
//UpdateData(true);
// UpdateData(false);
}
void Cprovide::OnButton1()
{
UpdateData(true);//把控件的值傳給相應的變量
if (m_offno == "" || m_goodno == "")
{
AfxMessageBox("供應商編號或商品編號不能為空！！");
goto tiaozhuan;
}
m_pRecordset.CreateInstance(_uuidof(Recordset));//
m_pRecordset->Open("select * from provide",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
try
{
m_pRecordset->AddNew();
voffno = m_offno;
vgoodno = m_goodno;
vamount = m_amount;
vdate = m_date;
m_pRecordset->PutCollect("offno",voffno);
m_pRecordset->PutCollect("goodno",vgoodno);
m_pRecordset->PutCollect("amount",vamount);
m_pRecordset->PutCollect("date",vdate);
m_pRecordset->Update();
m_pRecordset->Close();
m_pRecordset = NULL;
displayintheuserlist();
AfxMessageBox("添加記錄成功!");
}
catch(_com_error e)///捕捉異常
{
AfxMessageBox("添加記錄失敗!");///顯示錯誤信息
}
tiaozhuan:
//m_vdeptno = "";
// m_vdeptname = "";
UpdateData(false);
}
void Cprovide::OnButton2()
{
UpdateData(true);
if(MessageBox("確定要刪除嗎?",0,
MB_OKCANCEL|MB_DEFBUTTON2|MB_ICONWARNING)==IDOK)
{
m_offno = "'"+m_offno + "'";
m_goodno = "'"+m_goodno + "'";
sql = "select * from provide where offno = "+m_offno + " and goodno = "+m_goodno;
//////////////////////////////////////////////////////////////////////////////
try
{
m_pRecordset->Close();
m_pRecordset = NULL;
m_pRecordset.CreateInstance(_uuidof(Recordset));//
m_pRecordset->Open( (_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
m_pRecordset->Delete(adAffectCurrent);
displayintheuserlist();
AfxMessageBox("刪除記錄成功!!");
}
catch(_com_error e)///捕捉異常
{
AfxMessageBox("刪除記錄失敗!");///顯示錯誤信息
}
}
}
void Cprovide::OnKillfocusgoodno()
{
funoffno();
//UpdateData(false);
}
void Cprovide::OnButton3()
{
Cgoodinformation dlg;
dlg.DoModal();
}
void Cprovide::OnButton4()
{
Coffer dlg;
dlg.DoModal();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -