// DataYP.cpp: implementation of the CDataYP class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "a1.h"
#include "DataYP.h"

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

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

CDataYP::CDataYP()
{
m_pstrlistFields_Names=new CStringList[2];
m_sTableName="tabypinfo";
m_sKeyField="yp_id";
m_pstrlistFields_Names[0].AddTail("yp_id");			m_pstrlistFields_Names[1].AddTail("藥品編號");
m_pstrlistFields_Names[0].AddTail("yp_name");		m_pstrlistFields_Names[1].AddTail("藥品名稱");
m_pstrlistFields_Names[0].AddTail("yp_jc");			m_pstrlistFields_Names[1].AddTail("藥品簡稱");
m_pstrlistFields_Names[0].AddTail("jixing");		m_pstrlistFields_Names[1].AddTail("劑型");
m_pstrlistFields_Names[0].AddTail("huowei");		m_pstrlistFields_Names[1].AddTail("貨位");
m_pstrlistFields_Names[0].AddTail("chandi");		m_pstrlistFields_Names[1].AddTail("產地");
m_pstrlistFields_Names[0].AddTail("guige");			m_pstrlistFields_Names[1].AddTail("規格");
m_pstrlistFields_Names[0].AddTail("danwei");		m_pstrlistFields_Names[1].AddTail("單位");
m_pstrlistFields_Names[0].AddTail("shangbiao");		m_pstrlistFields_Names[1].AddTail("商標");
m_pstrlistFields_Names[0].AddTail("pizhunwenhao");	m_pstrlistFields_Names[1].AddTail("批準文號");
m_pstrlistFields_Names[0].AddTail("jinjia");		m_pstrlistFields_Names[1].AddTail("進價");
m_pstrlistFields_Names[0].AddTail("pifajia");		m_pstrlistFields_Names[1].AddTail("批發價");
m_pstrlistFields_Names[0].AddTail("lingshoujia");	m_pstrlistFields_Names[1].AddTail("零售價");
m_pstrlistFields_Names[0].AddTail("pihao");			m_pstrlistFields_Names[1].AddTail("批號");
m_pstrlistFields_Names[0].AddTail("baozhiqi");		m_pstrlistFields_Names[1].AddTail("保質期");
m_pstrlistFields_Names[0].AddTail("huoyuan");		m_pstrlistFields_Names[1].AddTail("貨源");
m_pstrlistFields_Names[0].AddTail("beizhu");		m_pstrlistFields_Names[1].AddTail("備注");
this->data.yp_id="";
this->data.yp_name="";
this->data.yp_jc="";
this->data.jixing="";
this->data.huowei="";
this->data.chandi="";
this->data.guige="";
this->data.danwei="";
this->data.shangbiao="";
this->data.pizhunwenhao="";
this->data.jinjia=0.0;
this->data.pifajia=0.0;
this->data.lingshoujia=0.0;
this->data.pihao="";
this->data.baozhiqi="";
this->data.huoyuan="";
this->data.beizhu="";
}

CDataYP::~CDataYP()
{
delete [] m_pstrlistFields_Names;
}
bool CDataYP::IsCurValueIn()
{
	CString sql;
	sql.Format("select * from %s where %s = '%s'",this->m_sTableName,this->m_sKeyField,this->data.yp_id);
	return this->m_runsql.CheckSQLResult(sql);
}
bool CDataYP::InsertCurValue()
{
	if(this->IsCurValueIn())
	{
		AfxMessageBox("無法插入，有此字段");
		return false;

	}
	CString sql;data.yp_id.MakeUpper();

	m_runsql.m_recordset->Close();
	if(!LRunSql::BeginTrans())return false;

	sql.Format("insert into %s(yp_id,yp_name,yp_jc,jixing,huowei,chandi,guige,danwei,\
		shangbiao,pizhunwenhao,jinjia,pifajia,lingshoujia,pihao,baozhiqi,huoyuan,beizhu) \
		values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s',%f,%f,%f,'%s','%s','%s','%s')",
		this->m_sTableName,
	this->data.yp_id,this->data.yp_name,this->data.yp_jc,this->data.jixing,this->data.huowei,
	this->data.chandi,this->data.guige,this->data.danwei,this->data.shangbiao,this->data.pizhunwenhao,
	this->data.jinjia,this->data.pifajia,this->data.lingshoujia,this->data.pihao,this->data.baozhiqi,
	this->data.huoyuan,this->data.beizhu);
	if(!m_runsql.RunSQL(sql))
	{
		LRunSql::RollbackTrans();
		return false;
	}


	_variant_t value;CStringList slist;
	slist.RemoveAll();
	sql.Format("select * from tabck");
	m_runsql.CheckSQLResult(sql);
	while(!m_runsql.m_recordset->adoEOF)
	{
		value=m_runsql.m_recordset->GetCollect("ck_name");
		slist.AddTail((char*)(_bstr_t)value);
		m_runsql.m_recordset->MoveNext();
	}
	POSITION pos=NULL;
	for(pos=slist.GetHeadPosition();pos!=NULL;)
	{
		sql.Format("insert into tabkc(yp_id,ck_name,kc_number,alert_leverup,alert_leverdown) \
		values('%s','%s',0,100000,10)",data.yp_id,slist.GetNext(pos));
	m_runsql.RunSQL(sql);	
	}

	if(!LRunSql::CommitTrans())return false;
	return true;
}
bool CDataYP::DeleteCurValue()
{
	if(!IsCurValueIn())
	{
		AfxMessageBox("無法刪除，沒有此字段");
		return false;
	}
	CString sql;

	m_runsql.m_recordset->Close();
	if(!LRunSql::BeginTrans())return false;
	sql.Format("delete * from %s where %s = '%s'",
		this->m_sTableName,
		this->m_sKeyField,
		this->data.yp_id);

	this->m_runsql.RunSQL(sql);
	sql.Format("delete * from tabkc where yp_id = '%s'",data.yp_id);
	this->m_runsql.RunSQL(sql);
	if(!LRunSql::CommitTrans())return false;
	return true;	
}
bool CDataYP::UpdateCurValue()
{
	if(!this->IsCurValueIn()) 
	{
		AfxMessageBox("無法更新，沒有此字段");
		return false;
	}
	CString sql;
	sql.Format("update %s set yp_name='%s',yp_jc='%s',jixing='%s',huowei='%s',chandi='%s',guige='%s',danwei='%s',shangbiao='%s',pizhunwenhao='%s',jinjia=%f,pifajia=%f,lingshoujia=%f,pihao='%s',baozhiqi='%s',huoyuan='%s',beizhu='%s' where %s ='%s'",
		  m_sTableName,
	this->data.yp_name,
	this->data.yp_jc,
	this->data.jixing,
	this->data.huowei,
	this->data.chandi,
	this->data.guige,
	this->data.danwei,
	this->data.shangbiao,
	this->data.pizhunwenhao,
	this->data.jinjia,
	this->data.pifajia,
	this->data.lingshoujia,
	this->data.pihao,
	this->data.baozhiqi,
	this->data.huoyuan,
	this->data.beizhu,
	
	this->m_sKeyField,
	this->data.yp_id);
	return m_runsql.RunSQL(sql);
}