// DataKH.cpp: implementation of the CDataKH class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "a1.h"
#include "DataKH.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CDataKH::CDataKH(bool iskh)
{
m_bKh=iskh;
m_pstrlistFields_Names=new CStringList[2];
if(m_bKh)
{
m_sTableName="tabkh";
m_sKeyField="kh_id";	
m_pstrlistFields_Names[0].AddTail("kh_id");			m_pstrlistFields_Names[1].AddTail("客戶編號");
m_pstrlistFields_Names[0].AddTail("kh_name");		m_pstrlistFields_Names[1].AddTail("客戶名稱");
}
else
{
m_sTableName="tabgys";
m_sKeyField="gys_id";	
m_pstrlistFields_Names[0].AddTail("gys_id");		m_pstrlistFields_Names[1].AddTail("供應商編號");
m_pstrlistFields_Names[0].AddTail("gys_name");		m_pstrlistFields_Names[1].AddTail("供應商名稱");

}
m_pstrlistFields_Names[0].AddTail("jc");			m_pstrlistFields_Names[1].AddTail("簡稱");
m_pstrlistFields_Names[0].AddTail("address");		m_pstrlistFields_Names[1].AddTail("地址");
m_pstrlistFields_Names[0].AddTail("area");			m_pstrlistFields_Names[1].AddTail("所在地區");
m_pstrlistFields_Names[0].AddTail("mail");			m_pstrlistFields_Names[1].AddTail("郵編");
m_pstrlistFields_Names[0].AddTail("phone");			m_pstrlistFields_Names[1].AddTail("電話");
m_pstrlistFields_Names[0].AddTail("fax");			m_pstrlistFields_Names[1].AddTail("傳真");
m_pstrlistFields_Names[0].AddTail("linkman");		m_pstrlistFields_Names[1].AddTail("聯系人");
m_pstrlistFields_Names[0].AddTail("lm_phone");		m_pstrlistFields_Names[1].AddTail("聯系人電話");
m_pstrlistFields_Names[0].AddTail("bank");			m_pstrlistFields_Names[1].AddTail("銀行");
m_pstrlistFields_Names[0].AddTail("accounts");		m_pstrlistFields_Names[1].AddTail("賬號");
m_pstrlistFields_Names[0].AddTail("taxpayer");		m_pstrlistFields_Names[1].AddTail("納稅人");
m_pstrlistFields_Names[0].AddTail("email");			m_pstrlistFields_Names[1].AddTail("E-mail");

data.kh_id="";
data.kh_name="";
data.jc="";
data.address="";
data.area="";
data.mail="";
data.phone="";
data.fax="";
data.linkman="";
data.lm_phone="";
data.bank="";
data.accounts="";
data.taxpayer="";
data.email="";

}

CDataKH::~CDataKH()
{
delete [] m_pstrlistFields_Names;
}
bool CDataKH::IsCurValueIn()
{
	CString sql;
	sql.Format("select * from %s where %s = '%s'",this->m_sTableName,this->m_sKeyField,this->data.kh_id);
	return this->m_runsql.CheckSQLResult(sql);

}
bool CDataKH::InsertCurValue()
{	if(this->IsCurValueIn())
	{
		AfxMessageBox("無法插入，有此字段");
		return false;

	}
	CString sql;
	if(m_bKh)
	sql.Format("insert into %s(kh_id,kh_name,jc,address,area,mail,phone,fax,\
		linkman,lm_phone,bank,accounts,taxpayer,email) \
		values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
		this->m_sTableName,
		data.kh_id,
		data.kh_name,
		data.jc,
		data.address,
		data.area,
		data.mail,
		data.phone,
		data.fax,
		data.linkman,
		data.lm_phone,
		data.bank,
		data.accounts,
		data.taxpayer,
		data.email
	);
	else
	{
		sql.Format("insert into %s(gys_id,gys_name,jc,address,area,mail,phone,fax,\
		linkman,lm_phone,bank,accounts,taxpayer,email) \
		values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
		this->m_sTableName,
		data.kh_id,
		data.kh_name,
		data.jc,
		data.address,
		data.area,
		data.mail,
		data.phone,
		data.fax,
		data.linkman,
		data.lm_phone,
		data.bank,
		data.accounts,
		data.taxpayer,
		data.email
	);
	}
	
	return m_runsql.RunSQL(sql);
}
bool CDataKH::DeleteCurValue()
{	if(!IsCurValueIn())
	{
		AfxMessageBox("無法刪除，沒有此字段");
		return false;
	}
	CString sql;
	sql.Format("delete * from %s where %s = '%s'",
		this->m_sTableName,
		this->m_sKeyField,
		this->data.kh_id);
	
	return m_runsql.RunSQL(sql);
}
bool CDataKH::UpdateCurValue()
{	if(!this->IsCurValueIn()) 
	{
		AfxMessageBox("無法更新，沒有此字段");
		return false;
	}
	CString sql;
	if(m_bKh)
	sql.Format("update %s set kh_name='%s',jc='%s',address='%s',area='%s',\
		mail='%s',phone='%s',fax='%s',linkman='%s',lm_phone='%s',\
		bank='%s',accounts='%s',taxpayer='%s',email='%s' where %s ='%s'",
		  m_sTableName,

		data.kh_name,
		data.jc,
		data.address,
		data.area,
		data.mail,
		data.phone,
		data.fax,
		data.linkman,
		data.lm_phone,
		data.bank,
		data.accounts,
		data.taxpayer,
		data.email,
	this->m_sKeyField,
	this->data.kh_id);
	else
	{
		sql.Format("update %s set gys_name='%s',jc='%s',address='%s',area='%s',\
		mail='%s',phone='%s',fax='%s',linkman='%s',lm_phone='%s',\
		bank='%s',accounts='%s',taxpayer='%s',email='%s' where %s ='%s'",
		  m_sTableName,

		data.kh_name,
		data.jc,
		data.address,
		data.area,
		data.mail,
		data.phone,
		data.fax,
		data.linkman,
		data.lm_phone,
		data.bank,
		data.accounts,
		data.taxpayer,
		data.email,
	this->m_sKeyField,
	this->data.kh_id);
	}
	return m_runsql.RunSQL(sql);
}