數(shù)據(jù)庫課程設(shè)計(jì)倉儲(chǔ)管理系統(tǒng)

1、成績?cè)u(píng)閱人評(píng)閱日期計(jì)算機(jī)科學(xué)與技術(shù)系數(shù)據(jù)庫課程設(shè)計(jì)設(shè)計(jì)題目：倉儲(chǔ)管理銷售管理系統(tǒng) 班 級(jí)： 計(jì)算機(jī)06-2 學(xué) 號(hào)： 06034050226 姓 名： 徐 指導(dǎo)老師： 朱 興 統(tǒng) 2008 年 12 月 24日倉儲(chǔ)物資管理系統(tǒng)開發(fā)、運(yùn)行環(huán)境：windows下：運(yùn)用程序語言工具：數(shù)據(jù)庫工具：Microsoft Office Access 2003連接數(shù)據(jù)庫工具：Microsoft SQL Server2000二、需求分析：設(shè)備代碼信息：設(shè)備號(hào)、設(shè)備名稱現(xiàn)有庫存信息：設(shè)備號(hào)、現(xiàn)有庫存、警戒庫存、總數(shù)設(shè)備入庫信息：設(shè)備號(hào)、供應(yīng)商信息、采購價(jià)格數(shù)量、采購員設(shè)備出庫信息：設(shè)備號(hào)、使用部門、數(shù)量、時(shí)間、經(jīng)

2、手人部門需求信息：設(shè)備號(hào)、需求部門、需求數(shù)量、需求時(shí)間設(shè)備還庫信息：設(shè)備號(hào)、還庫時(shí)間、人、還庫數(shù)量、經(jīng)手人計(jì)劃采購信息：設(shè)備號(hào)、庫存信息、供應(yīng)信息、時(shí)間三、系統(tǒng)設(shè)計(jì)：1.系統(tǒng)功能的基本要求：產(chǎn)品入庫管理，可以填寫入庫單，確認(rèn)產(chǎn)品入庫；產(chǎn)品出庫管理，可以填寫出庫單，確認(rèn)出庫；借出管理，憑借條借出，然后能夠還庫；初始庫存設(shè)置，設(shè)置庫存的初始值，庫存的上下警戒限；可以進(jìn)行盤庫，反映每月、年的庫存情況；可以查詢產(chǎn)品入庫情況、出庫情況、當(dāng)前庫存情況，可以按出庫單、入庫單，產(chǎn)品、時(shí)間進(jìn)行查詢；2、數(shù)據(jù)庫要求：在數(shù)據(jù)庫中至少應(yīng)該包含下列數(shù)據(jù)表：庫存情況表；出庫單表；入庫單表；出庫臺(tái)帳；入庫臺(tái)帳；借條信息表，

3、反映，借出人，借出時(shí)間，借出產(chǎn)品，借出數(shù)量，還庫時(shí)間等。四、數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計(jì)（E-R圖）：現(xiàn)有庫存設(shè)備號(hào)現(xiàn)有庫存警戒庫存總數(shù)現(xiàn)有庫存（設(shè)備號(hào)、現(xiàn)有庫存、警戒庫存、總數(shù)）入 庫設(shè)備號(hào)供應(yīng)商信息采購價(jià)格數(shù)量采購員入庫（設(shè)備號(hào)、供應(yīng)商信息、采購價(jià)格數(shù)量、采購員）出 庫設(shè)備號(hào)使用部門數(shù)量、時(shí)間經(jīng)手人出庫（設(shè)備號(hào)、使用部門、數(shù)量、時(shí)間、經(jīng)手人）部門需求設(shè)備號(hào)需求部門需求數(shù)量需求時(shí)間部門需求（設(shè)備號(hào)、需求部門、需求數(shù)量、需求時(shí)間）設(shè)備還庫設(shè)備號(hào)還庫時(shí)間、人還庫數(shù)量經(jīng)手人設(shè)備還庫（設(shè)備號(hào)、還庫時(shí)間、人、還庫數(shù)量、經(jīng)手人）計(jì)劃采購設(shè)備號(hào)庫存信息供應(yīng)信息時(shí)間計(jì)劃采購（設(shè)備號(hào)、庫存信息、供應(yīng)信息、時(shí)間）入 庫現(xiàn)

4、有庫存 出 庫還 庫部門需求設(shè)備采購實(shí)體關(guān)系（入庫、現(xiàn)有庫存、出庫、還庫、部門需求、設(shè)備采購）五、數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì)：表：用戶：Loginnamepasswordyu 21213 現(xiàn)有庫存：devicecodenow_numberhigh_numberlow_numbertotal_number0021630031670031210362004100304150052030415006530415007103041500851110設(shè)備代碼：device_codecodename001Pzkpfw IV002Tiger003Panther004Bf-109005Stuka006Me-26200

5、7Pzkpfw IV008電腦011Pzkpfw fg入庫：device_incodein_dateprovidertelenoin_numberpricebuyer0061983-6-9 10:21:21Grumman800-00001127100Bill0011983-6-9 12:20:08G.D.800-12345100Tom0021983-6-9 12:20:43Lockheed800-5432110Jack0041983-6-9 12:22:31M.D.800-1233211601700Deny0032004-7-23 11:26:09111110032004-7-23 11:33

6、:52111110022004-7-23 11:34:43111110082005-3-3 10:48:16求是01089*88888109888小指設(shè)備需求：device_needcodedepartmentbegin_dateend_dateneed_number002nowhere1983-6-9 12:23:331983-1-2 12:23:33100出庫：device_outcodedepartmentout_dateout_stateout_personout_numbertakerusage002nowhere1983-6-9 12:23:338Jerry100TomLunch.

7、002Math. Dept.2002-8-12 20:59:101Euler20HilbertLecture 32008辦公室2005-4-3 10:49:011小指8王江公司使用還庫：device_returncodereturn_datekeeperreturn_numberreturn_person0031983-6-9 12:24:16Minkovski100Euler0032002-8-11 21:04:05administer100golf0012002-8-12 20:49:05me10she0082005-6-3 10:49:55xiaozhi6小指設(shè)備采購：device_wa

8、ntbuycodenow_numbertotal_numbermax_numberbuy_numberproviderpricebuy_date0033060300300G.E.1502002-8-11 16:45:10002916030048廣州2004-7-19 10:38:09日志：howdodo_userdo_whatdo_datexiaozhi登錄數(shù)據(jù)庫2005-3-3 17:07:59用戶：Loginnamepasswordyu 21213 六、數(shù)據(jù)庫程序詳細(xì)設(shè)計(jì)：1、COM知識(shí)準(zhǔn)備_RecordsetPtr pRst = NULL;IADORecordBinding *picRs

9、 = NULL; /Interface Pointer declared.(VC+ Extensions) CDevBuyRs rs;try_bstr_t strSQL(SELECT * FROM DEVICE_WANTBUY);TESTHR(pRst.CreateInstance(_uuidof(Recordset);pRst = m_DBCnt-Execute(strSQL, NULL, adCmdText);TESTHR(pRst-QueryInterface(_uuidof(IADORecordBinding),(LPVOID*)&picRs);TESTHR(picRs-BindToR

10、ecordset(&rs);int i = 0;while (!pRst-adoEOF)m_list.InsertItem(0, rs.m_sz_code);m_list.SetItemText(i, 1, rs.m_sz_now);m_list.SetItemText(i, 2, rs.m_sz_total);m_list.SetItemText(i, 3, rs.m_sz_max);m_list.SetItemText(i, 4, rs.m_sz_buy);m_list.SetItemText(i, 5, rs.m_sz_provider);m_list.SetItemText(i, 6,

11、 rs.m_sz_price);m_list.SetItemText(i, 7, rs.m_sz_date);pRst-MoveNext();picRs-Release();pRst-Close();catch(_com_error& e) AfxMessageBox(e.ErrorMessage();m_list.SetRedraw(TRUE);return;2.1、日志模塊class CLogMngr public:CLogMngr();virtual CLogMngr();public:bool AddLog(LPCSTR op);void Setup(_ConnectionPtr cn

12、nt, CString& user)m_DBCnt = cnnt;m_user = user;protected:_ConnectionPtr m_DBCnt;CString m_user;bool CLogMngr:AddLog(LPCSTR op)CTime tm = CTime:GetCurrentTime();CString sql_;sql_.Format(INSERT INTO HOWDO (do_user,do_what,do_date) VALUES(%s,%s,%d-%d-%d %d:%d:%d),m_user, op, tm.GetYear(), tm.GetMonth()

13、, tm.GetDay(),tm.GetHour(), tm.GetMinute(), tm.GetSecond();_bstr_t sql = sql_;trym_DBCnt-Execute(sql,NULL,adCmdText);catch(_com_error& e) CString Error = e.ErrorMessage(); AfxMessageBox(e.ErrorMessage();return false; return true;2.2、void CDlgViewLog:OnBtnVlrmall() /_bstr_t strSQL(TRUNCATE TABLE HOWD

14、O);_bstr_t strSQL(DELETE * FROM HOWDO); trym_DBCnt-Execute(strSQL,NULL,adCmdText);catch(_com_error& e) AfxMessageBox(e.ErrorMessage();EndDialog(0); RefreshData();3、登陸窗口/* * 在這里彈出用戶登錄對(duì)話框*/CDlgLogIn dlg;doif (!dlg.DoModal()EndDialog(0); while (dlg.m_UsrName.GetLength()=0);/* * 登錄數(shù)據(jù)庫，若失敗，則關(guān)閉程序。*/trym_D

15、BCnt.CreateInstance(_uuidof(Connection);CString sql_;sql_.Format(DSN=DMS;UID=%s;PWD=%s,dlg.m_UsrName,dlg.m_UsrPwd);_bstr_t sql=sql_;m_DBCnt-Open(sql,-1);m_logMngr.Setup(m_DBCnt,dlg.m_UsrName);m_logMngr.AddLog(登錄數(shù)據(jù)庫);catch(_com_error& e) AfxMessageBox(e.ErrorMessage();this-EndDialog(0); void CDMSDlg:

16、OnDestroy() CDialog:OnDestroy();m_DBCnt-Close();4、主對(duì)話框void CDMSDlg:OnBtnDevcode() CDlgDevcode dlg;dlg.Setup(m_DBCnt,&m_logMngr);this-ShowWindow(SW_HIDE);dlg.DoModal();this-ShowWindow(SW_SHOW);5、設(shè)備代碼管理窗口BOOL CDlgDevcode:OnInitDialog() CDialog:OnInitDialog();m_list.InsertColumn(0,設(shè)備號(hào));m_list.InsertCol

17、umn(1,設(shè)備名);RECT rect;m_list.GetWindowRect(&rect);int wid = rect.right - rect.left;m_list.SetColumnWidth(0,wid/2);m_list.SetColumnWidth(1,wid/2);yle(LVS_EX_FULLROWSELECT);RefreshData();return TRUE; / return TRUE unless you set the focus to a control / EXCEPTION: OCX Property Pages should return FALSE

18、BEGIN_MESSAGE_MAP(CDlgDevcode, CDialog)/AFX_MSG_MAP(CDlgDevcode)ON_NOTIFY(NM_CLICK, IDC_LIST_DEVCODE, OnClickListDevcode)ON_BN_CLICKED(IDC_BTN_DCADD, OnBtnDcadd)ON_BN_CLICKED(IDC_BTN_DCDEL, OnBtnDcdel)ON_BN_CLICKED(IDC_BTN_DCUPD, OnBtnDcupd)/AFX_MSG_MAPEND_MESSAGE_MAP()void CDlgDevcode:OnClickListDe

19、vcode(NMHDR* pNMHDR, LRESULT* pResult) int i = m_list.GetSelectionMark();m_code = m_list.GetItemText(i,0);m_name = m_list.GetItemText(i,1);UpdateData(FALSE);*pResult = 0;/ DlgDevcode.cpp : implementation file/#include stdafx.h#include DMS.h#include DlgDevcode.h#ifdef _DEBUG#define new DEBUG_NEW#unde

20、f THIS_FILEstatic char THIS_FILE = _FILE_;#endif/ CDlgDevcode dialogCDlgDevcode:CDlgDevcode(CWnd* pParent /*=NULL*/): CDialog(CDlgDevcode:IDD, pParent)/AFX_DATA_INIT(CDlgDevcode)m_code = _T();m_name = _T();/AFX_DATA_INITm_DBCnt = NULL;m_log = NULL;void CDlgDevcode:DoDataExchange(CDataExchange* pDX)C

21、Dialog:DoDataExchange(pDX);/AFX_DATA_MAP(CDlgDevcode)DDX_Control(pDX, IDC_LIST_DEVCODE, m_list);DDX_Text(pDX, IDC_EDIT_DCCODE, m_code);DDX_Text(pDX, IDC_EDIT_DCNAME, m_name);/AFX_DATA_MAPBEGIN_MESSAGE_MAP(CDlgDevcode, CDialog)/AFX_MSG_MAP(CDlgDevcode)ON_NOTIFY(NM_CLICK, IDC_LIST_DEVCODE, OnClickList

22、Devcode)ON_BN_CLICKED(IDC_BTN_DCADD, OnBtnDcadd)ON_BN_CLICKED(IDC_BTN_DCDEL, OnBtnDcdel)ON_BN_CLICKED(IDC_BTN_DCUPD, OnBtnDcupd)/AFX_MSG_MAPEND_MESSAGE_MAP()/ CDlgDevcode message handlersvoid CDlgDevcode:RefreshData()m_list.DeleteAllItems();m_list.SetRedraw(FALSE);_bstr_t strSQL(SELECT * FROM DEVICE

23、_CODE);_RecordsetPtr MySet; int i = 0;tryMySet.CreateInstance(_uuidof(Recordset); MySet = m_DBCnt-Execute(strSQL,NULL,adCmdText);_variant_t Holder;while(!MySet-adoEOF) Holder = MySet-GetCollect(code);if(Holder.vt!=VT_NULL)m_list.InsertItem(i, (char*)(_bstr_t)Holder); Holder = MySet-GetCollect(name);

24、if(Holder.vt!=VT_NULL)m_list.SetItemText(i, 1, (char*)(_bstr_t)Holder);MySet-MoveNext(); catch(_com_error& e) essage();m_list.SetRedraw(TRUE);return; m_list.SetRedraw(TRUE);BOOL CDlgDevcode:OnInitDialog() CDialog:OnInitDialog();m_list.InsertColumn(0,設(shè)備號(hào));m_list.InsertColumn(1,設(shè)備名);RECT rect;tWindowR

25、ect(&rect);int wid = rect.right - rect.left;m_list.SetColumnWidth(0,wid/2);m_list.SetColumnWidth(1,wid/2);m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);RefreshData();return TRUE; / return TRUE unless you set the focus to a control / EXCEPTION: OCX Property Pages should return FALSEvoid CDlgDevcode:O

26、nClickListDevcode(NMHDR* pNMHDR, LRESULT* pResult) int i = m_list.GetSelectionMark();m_code = m_list.GetItemText(i,0);m_name = m_list.GetItemText(i,1);UpdateData(FALSE);*pResult = 0;void CDlgDevcode:OnBtnDcadd() UpdateData();CString sql_;sql_.Format(INSERT INTO DEVICE_CODE (code,name) VALUES(%s,%s),

27、 m_code, m_name);_bstr_t sql = sql_;trym_DBCnt-Execute(sql,NULL,adCmdText);catch(_com_error& e) AfxMessageBox(e.ErrorMessage();return; m_log-AddLog(添加設(shè)備記錄。); RefreshData(); void CDlgDevcode:OnBtnDcdel() UpdateData();CString sql_;sql_.Format(DELETE FROM DEVICE_CODE WHERE CODE=%s,m_code);_bstr_t sql =

28、 sql_;trym_DBCnt-Execute(sql,NULL,adCmdText); catch(_com_error& e) AfxMessageBox(e.ErrorMessage();return; m_log-AddLog(刪除設(shè)備記錄。); RefreshData(); void CDlgDevcode:OnBtnDcupd() UpdateData();CString sql_;sql_.Format(UPDATE DEVICE_CODE SET NAME=%s WHERE CODE=%s,m_name,m_code);_bstr_t sql = sql_;trym_DBCn

29、t-Execute(sql,NULL,adCmdText); catch(_com_error& e) AfxMessageBox(e.ErrorMessage();return; m_log-AddLog(更新設(shè)備記錄。); RefreshData(); 7、庫存信息管理窗口BOOL CDlgDev:OnInitDialog() CDialog:OnInitDialog();m_list.InsertColumn(0,設(shè)備號(hào));m_list.InsertColumn(1,現(xiàn)存數(shù)量);m_list.InsertColumn(2,最大數(shù)量);m_list.InsertColumn(3,最小數(shù)量)

30、;m_list.InsertColumn(4,總數(shù));RECT rect;m_list.GetWindowRect(&rect);int wid = rect.right - rect.left;m_list.SetColumnWidth(0,wid/5);m_list.SetColumnWidth(1,wid/5);m_list.SetColumnWidth(2,wid/5);m_list.SetColumnWidth(3,wid/5);m_list.SetColumnWidth(4,wid/5);m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);_

31、RecordsetPtr pRst = NULL;IADORecordBinding *picRs = NULL; /Interface Pointer declared.(VC+ Extensions) CDevCodeRs rs;try_bstr_t strSQL(SELECT * FROM DEVICE_CODE);TESTHR(pRst.CreateInstance(_uuidof(Recordset);pRst = m_DBCnt-Execute(strSQL, NULL, adCmdText);TESTHR(pRst-QueryInterface(_uuidof(IADORecor

32、dBinding),(LPVOID*)&picRs);TESTHR(picRs-BindToRecordset(&rs);int i = 0;while (!pRst-adoEOF)m_devs.AddString(rs.m_sz_code);pRst-MoveNext();picRs-Release();pRst-Close();catch(_com_error& e) AfxMessageBox(e.ErrorMessage();EndDialog(0);return TRUE; RefreshData();return TRUE; / return TRUE unless you set

33、 the focus to a control / EXCEPTION: OCX Property Pages should return FALSE8、設(shè)備入庫信息管理void CDlgViewDevIn:OnBtnViupdate() if (!UpdateData()return; CString sql_;sql_.Format(CString(SELECT * FROM DEVICE_IN WHERE in_date=)+DATEFMT, m_date);_bstr_t sql = sql_;_RecordsetPtr pRst = NULL;IADORecordBinding *p

34、icRs = NULL; /Interface Pointer declared.(VC+ Extensions) CDevInRs rs;tryTESTHR(pRst.CreateInstance(_uuidof(Recordset);pRst-Open(sql,_variant_t(IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdText); TESTHR(pRst-QueryInterface(_uuidof(IADORecordBinding),(LPVOID*)&picRs);TESTHR(picRs-Bi

35、ndToRecordset(&rs);strcpy(rs.m_sz_code,m_code);strcpy(rs.m_sz_date,m_date);strcpy(rs.m_sz_provider, m_provider);strcpy(rs.m_sz_tel, m_tel);rs.m_f_number = m_number;rs.m_f_price = m_price;strcpy(rs.m_sz_buyer, m_buyer);TESTHR(picRs-Update(&rs);picRs-Release();pRst-Close();catch(_com_error& e) AfxMess

36、ageBox(e.ErrorMessage();return; MessageBox(完成操作！);m_log-AddLog(修改入庫信息);RefreshData();void CDlgViewDevIn:OnBtnVidel() if (!UpdateData()return;CString sql_;/sql_.Format(CString(DELETE FROM DEVICE_IN WHERE in_date=)+DATEFMT, m_date);sql_.Format(DELETE FROM DEVICE_IN WHERE in_date=#%s#, m_date);_bstr_t

37、sql = sql_;trym_DBCnt-Execute(sql, NULL, adCmdText);/錯(cuò)誤catch(_com_error& e) AfxMessageBox(e.ErrorMessage();return; MessageBox(完成操作！);m_log-AddLog(刪除入庫信息);RefreshData();9、設(shè)備入庫窗口/ DlgDevIn.cppvoid CDlgDevIn:OnBtnDiadd() if (m_devs.GetCurSel()=CB_ERR)MessageBox(請(qǐng)選擇一個(gè)設(shè)備);return;if (!UpdateData()return;_

38、RecordsetPtr pRst = NULL;CDevInRs rs;tryTESTHR(pRst.CreateInstance(_uuidof(Recordset);pRst-Open(device_in,_variant_t(IDispatch*)m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdTable); m_devs.GetWindowText(rs.m_sz_code,11);sprintf(rs.m_sz_date,%d-%d-%d %d:%d:%d,m_date.GetYear(), m_date.GetMonth(),

39、m_date.GetDay(),m_time.GetHour(), m_time.GetMinute(), m_time.GetSecond();strcpy(rs.m_sz_provider, m_provider);strcpy(rs.m_sz_tel, m_tel);rs.m_f_number = m_number;rs.m_f_price = m_price;strcpy(rs.m_sz_buyer, m_buyer); COleSafeArray vaFieldlist, vaValuelist;rs.FillFieldsArray(vaFieldlist,vaValuelist);

40、/m_DBCnt-BeginTrans();TESTHR(pRst-AddNew(vaFieldlist, vaValuelist);pRst-Close(); m_DBCnt-BeginTrans();CString sql_;sql_.Format(SELECT * FROM device WHERE code=%s, rs.m_sz_code);_bstr_t sql = sql_;pRst-Open(sql, _variant_t(IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdText);if (pRst-

41、GetRecordCount()=0)CDevRs rsDev;strcpy(rsDev.m_sz_code, rs.m_sz_code);rsDev.m_f_cur = rs.m_f_number;rsDev.m_f_total = rs.m_f_number;rsDev.m_f_max = 1;rsDev.m_f_min = 1;COleSafeArray vaFields, vaValues;rsDev.FillFieldsArray(vaFields,vaValues);TESTHR(pRst-AddNew(vaFields, vaValues); else CDevRs rsDev;

42、IADORecordBinding *picRs = NULL; /Interface Pointer declared.(VC+ Extensions) TESTHR(pRst-QueryInterface(_uuidof(IADORecordBinding),(LPVOID*)&picRs);TESTHR(picRs-BindToRecordset(&rsDev);strcpy(rsDev.m_sz_code, rs.m_sz_code);rsDev.m_f_cur = rs.m_f_number + rsDev.m_f_cur;rsDev.m_f_total = rs.m_f_numbe

43、r + rsDev.m_f_total;TESTHR(picRs-Update(&rsDev);picRs-Release();pRst-Close();m_DBCnt-CommitTrans();/2catch(_com_error& e)AfxMessageBox(e.ErrorMessage();m_DBCnt-RollbackTrans();return; MessageBox(完成操作！);m_log-AddLog(添加入庫信息);EndDialog(0);10、設(shè)備采購報(bào)表管理void CDlgReport:OnCloseupComboRpdevs() char buf64;m_d

44、evs.GetWindowText(buf,64);if (strlen(buf)Execute(strSQL, NULL, adCmdText);TESTHR(pRst-QueryInterface(_uuidof(IADORecordBinding),(LPVOID*)&picRs);TESTHR(picRs-BindToRecordset(&rs1);m_name.Format(%s,rs1.m_sz_name);picRs-Release();pRst-Close();catch(_com_error& e) AfxMessageBox(e.ErrorMessage(); tryCSt

45、ring sql;sql.Format(SELECT * FROM DEVICE WHERE code=%s,buf);strSQL = sql;TESTHR(pRst.CreateInstance(_uuidof(Recordset);pRst-Open(strSQL, _variant_t(IDispatch *) m_DBCnt, true), adOpenKeyset, adLockOptimistic, adCmdText);if (pRst-GetRecordCount()!=1)m_max = 0;m_cur = 0;m_total = 0; elseTESTHR(pRst-Qu

46、eryInterface(_uuidof(IADORecordBinding),(LPVOID*)&picRs);TESTHR(picRs-BindToRecordset(&rs2);m_max = rs2.m_f_max;m_cur = rs2.m_f_cur;m_total = rs2.m_f_total;picRs-Release();pRst-Close();catch(_com_error& e) AfxMessageBox(e.ErrorMessage(); UpdateData(FALSE);11、庫存報(bào)警窗口設(shè)計(jì)void CDlgDevAlert:SearchOver()_Re

47、cordsetPtr pRst = NULL;IADORecordBinding *picRs = NULL; /Interface Pointer declared.(VC+ Extensions) CDevRs rs;try_bstr_t strSQL(SELECT * FROM DEVICE WHERE now_numberhigh_number);TESTHR(pRst.CreateInstance(_uuidof(Recordset);pRst = m_DBCnt-Execute(strSQL, NULL, adCmdText);TESTHR(pRst-QueryInterface(

48、_uuidof(IADORecordBinding),(LPVOID*)&picRs);TESTHR(picRs-BindToRecordset(&rs);int i = 0;char buf64;while (!pRst-adoEOF)m_list.InsertItem(0, rs.m_sz_code);sprintf(buf,%f,rs.m_f_cur); m_list.SetItemText(i, 1, buf);sprintf(buf,%f,rs.m_f_max);m_list.SetItemText(i, 2, buf);sprintf(buf,%f,rs.m_f_min);m_li

49、st.SetItemText(i, 3, buf);sprintf(buf,%f,rs.m_f_total);m_list.SetItemText(i, 4, buf);pRst-MoveNext();picRs-Release();pRst-Close();catch(_com_error& e) AfxMessageBox(e.ErrorMessage();return; void CDlgDevAlert:SearchBelow()_RecordsetPtr pRst = NULL;IADORecordBinding *picRs = NULL; /Interface Pointer declared.(VC+ Extensions) CDevRs rs;try_bstr_t strSQL(SELECT