public DataTable Query_by_user(string username)
{
string baseSQL = "SELECT * FROM 用户表 where username = \"" + username + "\"";
DBHelperAccess dBHelperAccess = new DBHelperAccess(startpath);
DataTable dataTable = dBHelperAccess.SelectToDataTable(baseSQL);
dBHelperAccess.Close();
return(dataTable);
}
public DataTable Exportcount()
{
string baseSQL = "SELECT date_time, count(date_time) as peopleCount FROM 挂号表 group by date_time";
DBHelperAccess dBHelperAccess = new DBHelperAccess(startpath);
DataTable dataTable = dBHelperAccess.SelectToDataTable(baseSQL);
dBHelperAccess.Close();
return(dataTable);
}
public DataTable appointmentAll()//预约人数
{
string baseSQL = "SELECT * FROM 预约表";
DBHelperAccess dBHelperAccess = new DBHelperAccess(startpath);
DataTable dataTable = dBHelperAccess.SelectToDataTable(baseSQL);
dBHelperAccess.Close();
return(dataTable);
}
public DataTable Exportall()
{
string baseSQL = "SELECT * FROM 挂号表";
DBHelperAccess dBHelperAccess = new DBHelperAccess(startpath);
DataTable dataTable = dBHelperAccess.SelectToDataTable(baseSQL);
dBHelperAccess.Close();
return(dataTable);
}
public DataTable Query_by_patient_id(string id)
{
string baseSQL = "SELECT * FROM 病人信息索引表 where patient_id = \"" + id + "\"";
DBHelperAccess dBHelperAccess = new DBHelperAccess(startpath);
DataTable dataTable = dBHelperAccess.SelectToDataTable(baseSQL);
dBHelperAccess.Close();
return(dataTable);
}
public DataTable Query_dep(string dep, string type)
{
string date = DateTime.Now.ToString("yyyy/MM/dd");
string baseSQL = "SELECT 挂号表.* FROM 挂号表 where Department=\"" + dep + "\" and isPro=\"" + type + "\" and date_time=#" + date + "#";
DBHelperAccess dBHelperAccess = new DBHelperAccess(startpath);
DataTable dataTable = dBHelperAccess.SelectToDataTable(baseSQL);
dBHelperAccess.Close();
return(dataTable);
}