3.0

yuliqi

于 2010-03-11 20:22:00 发布

阅读量167

点赞数

文章标签： sql insert null

本文链接：https://blog.youkuaiyun.com/yuliqi/article/details/5371269

版权

CString sql="select count(*) as t from tbl_personinfo where id='"+id+"'";
m_DateDriver.ExecuteSQL(sql);
int count;
m_DateDriver.GetIntValue("t",count);
if(count!=0)
{
  sql="update tbl_personinfo set Phone='"+phone+"', NAME='"+name+"',Starttime='"+starttime+"',Endtime='"+endtime+"' ,Memo='"+memo+"' where ID='"+id+"'";
}
else
{
  sql="insert into tbl_personinfo(ID,NAME,Starttime,Endtime,Phone,Memo,State) values('"+id+"','"+name+"','"+starttime+"','"+endtime+"','"+phone+"','"+memo+"',+0)";
}
if(m_DateDriver.ExecuteSQL(sql)&&m_CurStat==MODIFY)
{
  MSGTYPE msgtype=FORMNOTIFYLISTTOREFRESH;
  ::SendMessage(AfxGetMainWnd()->m_hWnd,FORMNOTIFYLIST_REFRESH,(WPARAM)msgtype,NULL);
}