菜鸟求助：写一个DLL，实现对SQL数据库中表项的增加与删除！

功能代码如下：给我看看还有哪些需要修改的？// VehQueryDlg.cpp : implementation file
//#include "stdafx.h"
#include "JLDbInterFace.h"
#include "VehQueryDlg.h"#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif/////////////////////////////////////////////////////////////////////////////
// CVehQueryDlg dialog
CVehQueryDlg::CVehQueryDlg(CWnd* pParent /*=NULL*/)
: CDialog(CVehQueryDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CVehQueryDlg)
m_iChno = -1;
m_sPlate = _T("");
m_iSpeed1 = 0;
m_iSpeed2 = 0;
//}}AFX_DATA_INIT
}
void CVehQueryDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CVehQueryDlg)
DDX_Control(pDX, IDC_LIST3, m_list);
DDX_Control(pDX, IDC_DATETIMEPICKER4, m_dt4);
DDX_Control(pDX, IDC_DATETIMEPICKER3, m_dt3);
DDX_Control(pDX, IDC_DATETIMEPICKER2, m_dt2);
DDX_Control(pDX, IDC_DATETIMEPICKER1, m_dt1);
DDX_Control(pDX, IDC_BUTTON2, m_ShowContainer);
DDX_CBIndex(pDX, IDC_COMBO1, m_iChno);
DDX_Text(pDX, IDC_EDIT1, m_sPlate);
DDX_Text(pDX, IDC_EDIT2, m_iSpeed1);
DDX_Text(pDX, IDC_EDIT3, m_iSpeed2);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CVehQueryDlg, CDialog)
//{{AFX_MSG_MAP(CVehQueryDlg)
ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
ON_NOTIFY(LVN_ITEMCHANGED, IDC_LIST3, OnItemchangedList3)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()/////////////////////////////////////////////////////////////////////////////
// CVehQueryDlg message handlersBOOL CVehQueryDlg::OnInitDialog() 
{
CDialog::OnInitDialog();

//取主界面句柄
pMainDlg = (CEpCameraDlg*)AfxGetMainWnd();
m_AddFlag = FALSE;

//初始化列表
m_list.SendMessage (LVM_SETEXTENDEDLISTVIEWSTYLE, 0,
LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
m_list.InsertColumn(0,"序号",LVCFMT_LEFT,50);
m_list.InsertColumn(1,"车牌",LVCFMT_LEFT,75);
m_list.InsertColumn(2,"车牌颜色",LVCFMT_LEFT,70);
m_list.InsertColumn(3,"车速km/h",LVCFMT_LEFT,70);
m_list.InsertColumn(4,"通行时间",LVCFMT_LEFT,150);
m_list.InsertColumn(5,"车道编号",LVCFMT_LEFT,65);
m_list.InsertColumn(6,"图片文件",LVCFMT_LEFT,385);

m_iChno = 0;
m_sPlate = "";
m_iSpeed1 = 0;
m_iSpeed2 = 200;
UpdateData(FALSE);

//设置日期
CTime tempTime1;
tempTime1 = CTime::GetCurrentTime();
CTime tmpTimeDt1(tempTime1.GetYear(),tempTime1.GetMonth(),tempTime1.GetDay(),0,0,0);
m_dt1.SetTime(&tmpTimeDt1);
m_dt2.SetTime(&tmpTimeDt1);
m_dt3.SetTime(&tmpTimeDt1);
CTime tmpTimeDt2(tempTime1.GetYear(),tempTime1.GetMonth(),tempTime1.GetDay(),tempTime1.GetHour(),tempTime1.GetMinute(),tempTime1.GetSecond());
m_dt4.SetTime(&tmpTimeDt2);

return TRUE;  
}//查询数据
void CVehQueryDlg::OnButton1() 
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CString ls_time1,ls_time2;
CString ls_month,ls_day,ls_hour,ls_minute,ls_second;

//取出时间值
COleDateTime tempTime1,tempTime2;
m_dt1.GetTime(tempTime1);
m_dt2.GetTime(tempTime2); ls_month.Format("%d",100+tempTime1.GetMonth());
ls_month = ls_month.Right(2);
ls_day.Format("%d",100+tempTime1.GetDay());
ls_day = ls_day.Right(2);
ls_hour.Format("%d",100+tempTime2.GetHour());
ls_hour = ls_hour.Right(2);
ls_minute.Format("%d",100+tempTime2.GetMinute());
ls_minute = ls_minute.Right(2);
ls_second.Format("%d",100+tempTime2.GetSecond());
ls_second = ls_second.Right(2); ls_time1.Format("%d-%s-%s %s:%s:%s",tempTime1.GetYear(),ls_month,ls_day,ls_hour,ls_minute,ls_second); m_dt3.GetTime(tempTime1);
m_dt4.GetTime(tempTime2); ls_month.Format("%d",100+tempTime1.GetMonth());
ls_month = ls_month.Right(2);
ls_day.Format("%d",100+tempTime1.GetDay());
ls_day = ls_day.Right(2);
ls_hour.Format("%d",100+tempTime2.GetHour());
ls_hour = ls_hour.Right(2);
ls_minute.Format("%d",100+tempTime2.GetMinute());
ls_minute = ls_minute.Right(2);
ls_second.Format("%d",100+tempTime2.GetSecond());
ls_second = ls_second.Right(2); ls_time2.Format("%d-%s-%s %s:%s:%s",tempTime1.GetYear(),ls_month,ls_day,ls_hour,ls_minute,ls_second); //构建军SQL语句
CString ls_sql,ls_where;
ls_where.Format(" where (JGSJ >= '%s' and JGSJ <= '%s')",ls_time1,ls_time2);
//加入车道条件
if (m_iChno > 0)
{
ls_sql.Format("%s and CDBB = '%d'",ls_where,m_iChno);
ls_where = ls_sql;
}
//加入速度范围
ls_sql.Format("%s and (CLSD >= %d and CLSD <= %d)",ls_where,m_iSpeed1,m_iSpeed2);
ls_where = ls_sql;
//加入车牌号码
if (m_sPlate != "")
{
ls_sql.Format("%s and HPHM = '%s'",ls_where,m_sPlate);
ls_where = ls_sql;
} ls_sql = "Select * from CLTXForm" + ls_where + "order by JGSJ"; m_AddFlag = FALSE; 
//清空列表
m_list.DeleteAllItems();

//查询数据
_RecordsetPtr recodData;
recodData = pMainDlg->m_pConDbObj.GetData(ls_sql);
if (recodData==NULL) 
{
MessageBox("无符合条件记录!");
return ;
}
if (recodData->adoBOF)
{
recodData.Release();
MessageBox("无符合条件记录!");
return ;
}
else
{
recodData->MoveFirst();
_variant_t lv_data;
int li_index = 0;
CString ls_str;
while (!recodData->adoEOF)
{
ls_str.Format("%d",li_index);
li_index = m_list.InsertItem(m_list.GetItemCount(),ls_str);

lv_data = recodData->GetCollect("HPHM");
ls_str = vartostr(&lv_data);
m_list.SetItemText(li_index,1,ls_str); lv_data = recodData->GetCollect("HPYS");
ls_str = vartostr(&lv_data);
m_list.SetItemText(li_index,2,ls_str);

ls_str.Format("%d",long(recodData->GetCollect("CLSD")));
m_list.SetItemText(li_index,3,ls_str); lv_data = recodData->GetCollect("JGSJ");
ls_str = vartostr(&lv_data);
m_list.SetItemText(li_index,4,ls_str); lv_data = recodData->GetCollect("CDBB");
ls_str = vartostr(&lv_data);
m_list.SetItemText(li_index,5,ls_str); lv_data = recodData->GetCollect("TJTP");
ls_str = vartostr(&lv_data);
m_list.SetItemText(li_index,6,ls_str); li_index++;
recodData->MoveNext();
}
recodData.Release();
}
m_AddFlag = TRUE;
}
//关闭
void CVehQueryDlg::OnButton5() 
{
// TODO: Add your control notification handler code here
CDialog::OnCancel();
}void CVehQueryDlg::OnItemchangedList3(NMHDR* pNMHDR, LRESULT* pResult) 
{
// TODO: Add your control notification handler code here
NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;

if (m_AddFlag)
{
//取图片显示
for (int i=0;i<m_list.GetItemCount();i++)
{
if (m_list.GetItemState(i,LVIS_SELECTED)==LVIS_SELECTED)
{
CString ls_fileName;
ls_fileName = m_list.GetItemText(i,6);
LoadImgFileShow(ls_fileName);
break;
}
}
}

*pResult = 0;
}
void CVehQueryDlg::LoadImgFileShow(CString as_ImgFile)
{
CRect rect;
m_ShowContainer.GetClientRect(&rect);
pMainDlg->m_bmpObj.LoadJpgGifShow(m_ShowContainer.GetDC(),as_ImgFile,rect);
}