//保存体检统计信息
public bool addBgdcInfo(bean.jkBean jkbar)
{
int rt = 0;
string id = Result.GetNewId();
string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string status = "0";
String sql = "insert into zkhw_tj_bgdc (ID,aichive_no,id_number,bar_code,Caozuoyuan,SjName,Carcode,createtime,upload_status,duns) values ('" + id + "','" + jkbar.aichive_no + "','" + jkbar.id_number + "', '" + jkbar.bar_code + "', '" + jkbar.batch_no + "', '" + jkbar.Pic1 + "', '" + jkbar.Pic2 + "', '" + jkbar.Xzdm + "', '" + jkbar.Xianzhudi + "', '" + jkbar.XzjdName + "', '" + jkbar.CjwhName + "', '" + jkbar.JddwName + "', '" + jkbar.JdrName + "', '" + jkbar.ZrysName + "', '" + jkbar.Caozuoyuan + "', '" + jkbar.SjName + "', '" + jkbar.Carcode + "', '" + time + "', '" + status + "', '" + jkbar.duns + "')";
rt = DbHelperMySQL.ExecuteSql(sql);
return(rt == 0 ? false : true);
}
//打印条码并保存个人基础信息
public bool addJkInfo(bean.jkBean jkbar)
{
int rt = 0;
string id = Result.GetNewId();
string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string uploadstatus = "0";
String sql = "insert into zkhw_tj_jk (ID,aichive_no,id_number,bar_code,name,age,sex,Pic1,Pic2,village_code,address,Xzhuzhi,XzjdName,CjwhName,JddwName,JdrName,ZrysName,Caozuoyuan,SjName,Carcode,createtime,upload_status) values ('" + id + "','" + jkbar.aichive_no + "','" + jkbar.id_number + "', '" + jkbar.bar_code + "', '" + jkbar.name + "', '" + jkbar.age + "', '" + jkbar.sex + "', '" + jkbar.Pic1 + "', '" + jkbar.Pic2 + "', '" + jkbar.village_code + "', '" + jkbar.address + "', '" + jkbar.Xzhudi + "', '" + jkbar.XzjdName + "', '" + jkbar.CjwhName + "', '" + jkbar.JddwName + "', '" + jkbar.JdrName + "', '" + jkbar.ZrysName + "', '" + jkbar.Caozuoyuan + "', '" + jkbar.SjName + "', '" + jkbar.Carcode + "', '" + time + "', '" + uploadstatus + "')";
rt = DbHelperMySQL.ExecuteSql(sql);
return(rt == 0 ? false : true);
}
