【VC开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了VC开源代码-DataYP.cpp的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
// 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);
}
上一篇:
fDialogEx.frm
下一篇:
防止代码变质的思考与方法