//保存体检统计信息 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); }