www.pudn.com > GSMTest1.rar > TransEditDlg.cpp

// TransEditDlg.cpp : implementation file 
// 
 
#include "stdafx.h" 
#include "GSMTest.h" 
#include "TransEditDlg.h" 
#include "TransGL.h" 
#include  
#include  
#include "database.h" 
 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#undef THIS_FILE 
static char THIS_FILE[] = __FILE__; 
#endif 
 
///////////////////////////////////////////////////////////////////////////// 
// CTransEditDlg dialog 
 
 
CTransEditDlg::CTransEditDlg(CWnd* pParent /*=NULL*/) 
	: CDialog(CTransEditDlg::IDD, pParent) 
{ 
	//{{AFX_DATA_INIT(CTransEditDlg) 
	m_strTel = _T(""); 
	m_sFactor = _T(""); 
	m_sIa = _T(""); 
	m_sIb = _T(""); 
	m_sIc = _T(""); 
	m_sTemp = _T(""); 
	m_sUa = _T(""); 
	m_sUb = _T(""); 
	m_sUc = _T(""); 
	m_sRemark = _T(""); 
	//}}AFX_DATA_INIT 
} 
 
 
void CTransEditDlg::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
	//{{AFX_DATA_MAP(CTransEditDlg) 
	DDX_Control(pDX, IDC_DUTYLIST, m_ctrDutylist); 
	DDX_Text(pDX, IDC_TEL, m_strTel); 
	DDV_MaxChars(pDX, m_strTel, 15); 
	DDX_Text(pDX, IDC_FACTOR, m_sFactor); 
	DDV_MaxChars(pDX, m_sFactor, 10); 
	DDX_Text(pDX, IDC_IA, m_sIa); 
	DDX_Text(pDX, IDC_IB, m_sIb); 
	DDX_Text(pDX, IDC_IC, m_sIc); 
	DDX_Text(pDX, IDC_TEMP, m_sTemp); 
	DDX_Text(pDX, IDC_UA, m_sUa); 
	DDX_Text(pDX, IDC_UB, m_sUb); 
	DDX_Text(pDX, IDC_UC, m_sUc); 
	DDX_Text(pDX, IDC_REMARK, m_sRemark); 
	DDV_MaxChars(pDX, m_sRemark, 200); 
	//}}AFX_DATA_MAP 
} 
 
 
BEGIN_MESSAGE_MAP(CTransEditDlg, CDialog) 
	//{{AFX_MSG_MAP(CTransEditDlg) 
	ON_BN_CLICKED(IDC_SAVE, OnSave) 
	ON_BN_CLICKED(IDC_ADDDUTY, OnAddduty) 
	ON_BN_CLICKED(IDC_DELDUTY, OnDelduty) 
	//}}AFX_MSG_MAP 
END_MESSAGE_MAP() 
 
///////////////////////////////////////////////////////////////////////////// 
// CTransEditDlg message handlers 
 
void CTransEditDlg::OnSave()  
{ 
	// TODO: Add your control notification handler code here 
	UpdateData(TRUE); 
	 
//	Data_Param strQuery;char SQL[300]; 
	CTransGL dlg; 
	CString info; 
 
	 
	m_sFactor.Replace("\'",""); 
	m_sTemp.Replace("\'",""); 
	m_sRemark.Replace("\'",""); 
	 
	if(m_strTel=="") 
	{ 
		AfxMessageBox("号码不能为空!"); 
		return; 
	} 
	 
 
	CDatabase database;	 
 
 
	if(!database.ConnectDB()) 
	{	 
		AfxMessageBox("连接服务器失败!"); 
		return; 
	} 
	 
	CString charset="set charset gb2312;";//使之正常显示中文,或用set character_set_results=gb2312; 
	database.ExecuteSQL(charset,charset.GetLength());//执行语句. 
	 
	if(m_strID=="add") 
	{ 
		//增加 
		info.Format("insert into trans_info (TRANS_TEL,Ia,Ib,Ic,Ua,Ub,Uc,F,Temp,Remark) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", 
			m_strTel,m_sIa,m_sIb,m_sIc,m_sUa,m_sUb,m_sUc,m_sFactor,m_sTemp,m_sRemark); 
		 
		 
		//strQuery.tab_name="trans_info (TEL,INFO)"; 
		//info.Format("\'%s\',\'%s\'",m_strTel,m_strInfo); 
		//sprintf(SQL,info); 
		//strQuery.insert_val=SQL;		 
		//if(!database.InsertRecord(&strQuery)) 
		if(!database.ExecuteSQL(info,info.GetLength())) 
		{ 
			AfxMessageBox("插入数据失败!"); 
			return; 
		} 
	} 
	else 
	{ 
		 
		info.Format("update trans_info set TRANS_TEL='%s',Ia='%s',Ib='%s',Ic='%s',Ua='%s',Ub='%s',Uc='%s',F='%s',Temp='%s',Remark='%s' where TRANS_ID='%s'", 
			m_strTel,m_sIa,m_sIb,m_sIc,m_sUa,m_sUb,m_sUc,m_sFactor,m_sTemp,m_sRemark,m_strID); 
		if(!database.ExecuteSQL(info,info.GetLength())) 
		{ 
			AfxMessageBox("编辑变压器信息失败!"); 
			return; 
		} 
	} 
	CDialog::OnOK(); 
	 
} 
#include "dutydlg.h" 
void CTransEditDlg::OnAddduty()  
{ 
	CDutyDlg dlg; 
	dlg.m_sID=m_strID; 
	if(dlg.DoModal()!=IDCANCEL) 
	{ 
		bindduty(); 
	} 
} 
 
void CTransEditDlg::bindduty() 
{ 
	m_ctrDutylist.DeleteAllItems(); 
 
	CDatabase 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="duty_info,trans_duty"; 
	result.select_exp="id,duty_name,duty_tel,remark"; 
	CString def; 
	def.Format("duty_info.duty_id=trans_duty.duty_id and trans_id=%s",m_strID); 
 
	result.where_def=def.GetBuffer(100); 
	 
	if(database.SelectRecord(&result)) 
	{ 
		int count=(int)database.GetRowNum();			 
		 
		for(int i=0;i