//根据获取乡镇信息编号，获取对应的个人信息档案
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);
}
}