?? jstrans.cpp
字號:
// JStrans.cpp : implementation file
//
#include "stdafx.h"
#include "GSMTest.h"
#include "JStrans.h"
#include "TransGL.h"
#include <winsock.h>
#include <mysql.h>
#include "database.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CJStrans dialog
CJStrans::CJStrans(CWnd* pParent /*=NULL*/)
: CDialog(CJStrans::IDD, pParent)
{
//{{AFX_DATA_INIT(CJStrans)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void CJStrans::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CJStrans)
DDX_Control(pDX, IDC_LIST1, m_add_jslist);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CJStrans, CDialog)
//{{AFX_MSG_MAP(CJStrans)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CJStrans message handlers
BOOL CJStrans::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
m_add_jslist.InsertColumn(0,"數量",LVCFMT_CENTER,80,0);
m_add_jslist.InsertColumn(1,"變壓器ID",LVCFMT_CENTER,160,1);
m_add_jslist.InsertColumn(2,"變壓器TEL",LVCFMT_CENTER,160,1);
m_add_jslist.InsertColumn(3,"備注",LVCFMT_LEFT,280,10);
m_add_jslist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
showalltrans();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CJStrans::showalltrans()
{
m_add_jslist.DeleteAllItems();
CDatabase1 database;
if(!database.ConnectDB())
{
return;
}
CString charset="set charset gb2312;";//使之正常顯示中文,或用set character_set_results=gb2312;
database.ExecuteSQL(charset,charset.GetLength());//執行語句.
Data_Param result;
result.tab_name="trans_info";
result.select_exp="TRANS_num,TRANS_ID,TRANS_TEL,remark";
CString def1;
def1="TRANS_TEL NOT IN (SELECT TRANS_TEL FROM TRANS_js)";
// def1="(trans_info.TRANS_TEL)!=(trans_js.trans_tel)";
result.where_def=def1.GetBuffer(100);
if(database.SelectRecord(&result))
{
int count=(int)database.GetRowNum();
for(int i=0;i<count;i++)
{
database.SeekData(i);
MYSQL_ROW row=database.GetRecord();
m_add_jslist.InsertItem(i,row[0]);
m_add_jslist.SetItemText(i,1,row[1]);
m_add_jslist.SetItemText(i,2,row[2]);
m_add_jslist.SetItemText(i,3,row[3]);
}
}
}
void CJStrans::OnOK()
{
// TODO: Add extra validation here
int count=m_add_jslist.GetSelectedCount();
POSITION pos=m_add_jslist.GetFirstSelectedItemPosition();
if(pos==NULL)
{
AfxMessageBox("請選擇變壓器!");
return;
}
int nItem = m_add_jslist.GetNextSelectedItem(pos);
num=m_add_jslist.GetItemText(nItem,2);
/* CDatabase1 database;
if(!database.ConnectDB())
{
AfxMessageBox("連接服務器失敗!");
return;
}
CString charset="set names 'gb2312'";//使之正常顯示中文,或用set character_set_results=gb2312;
database.ExecuteSQL(charset,charset.GetLength());//執行語句.
CString sSQL;
while (count--)
{
int nItem = m_add_jslist.GetNextSelectedItem(pos);
sSQL.Format("select trans_num from trans_js where TRANS_TEL='%s'",
m_add_jslist.GetItemText(nItem,2));
database.ExecuteSQL(sSQL,sSQL.GetLength());
int cnt=(int)database.GetRowNum();
if(cnt<=0)
{
num=m_add_jslist.GetItemText(nItem,2);
sSQL.Format("insert into trans_js (TRANS_TEL) values ('%s')",
m_add_jslist.GetItemText(nItem,2));
if(!database.ExecuteSQL(sSQL,sSQL.GetLength()))
{
AfxMessageBox("操作失敗!");
break;
}
}
}*/
CDialog::OnOK();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -