//根据获取乡镇信息编号,获取对应的个人信息档案 public DataTable checkResidentBycode(string areacode) { DataSet ds = new DataSet(); string sql = "select * from resident_base_info where towns_code = '" + areacode + "'"; ds = DbHelperMySQL.QueryYpt(sql); return(ds.Tables[0]); }
public DataTable GetSlowDiseasesInfo() { DataSet ds = new DataSet(); string sql = "select * from slow_diseases_healthAdvice "; ds = DbHelperMySQL.QueryYpt(sql); return(ds.Tables[0]); }
//根据获取机构信息编号,获取对应的所有用户信息 public DataTable checkUsersBycode(string organcode) { DataSet ds = new DataSet(); string sql = "select * from ltd_user where organ_code = '" + organcode + "'"; ds = DbHelperMySQL.QueryYpt(sql); return(ds.Tables[0]); }
//获取阈值信息 public DataTable checkThresholdValue() { DataSet ds = new DataSet(); string sql = "select * from threshold_value where 1=1"; ds = DbHelperMySQL.QueryYpt(sql); return(ds.Tables[0]); }
//以下是初始化数据获取平台基础数据 //根据区县编号或乡镇编号,获取机构信息 public DataTable checkLtdOrganizationBycode(string areacode) { DataSet ds = new DataSet(); string sql = "select * from ltd_organization where towns_code = '" + areacode + "'"; ds = DbHelperMySQL.QueryYpt(sql); return(ds.Tables[0]); }
//根据团队编号,获取对应的团队成员信息 public DataTable checkTeanDoctorBycode(string code) { DataSet ds = new DataSet(); string sql = "select * from team_doctor where tean_no > '" + code + "'"; ds = DbHelperMySQL.QueryYpt(sql); return(ds.Tables[0]); }
//根据获取乡镇信息编号,获取对应的家医团队信息 public DataTable checkTeanInfoBycode(string areacode) { DataSet ds = new DataSet(); string sql = "select * from team_info where towns_code > '" + areacode + "'"; ds = DbHelperMySQL.QueryYpt(sql); return(ds.Tables[0]); }
public static DataTable GetShenHuaDataForYun(string a, string b, string c) { string sql = string.Format(@"select * from zkhw_temp_sh where status=0 and bar_code in ({0}) and (DATE_FORMAT(createtime,'%Y-%m-%d')>='{1}' and DATE_FORMAT(createtime,'%Y-%m-%d')<='{2}')", a, b, c); DataSet ds = DbHelperMySQL.QueryYpt(sql); if (ds != null) { return(ds.Tables[0]); } else { return(null); } }