public string QueryFrequence()
{
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryFrequence);
return(TypeChange.DataTableToXml(dt));
}
}
public string PharmAdviceCount()
{
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryPharmAdviceCount);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryLoaclDataCount()
{
string SqlText = @"Select Count(1) LoacalDataCount From [Patient]";
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlText);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryLisResult(string IllcaseNo)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[1];
sqlpar[0] = new SQLiteParameter("1", IllcaseNo);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryLisResult, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryCodeListByGroup(string GroupName)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[1];
sqlpar[0] = new SQLiteParameter("1", GroupName);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryCodeListByGroup, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryCheckApply(string InhosID)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[1];
sqlpar[0] = new SQLiteParameter("1", InhosID);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryCheckApply, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryDeptPatientCount(string DeptId, string InhosStatus)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[2];
sqlpar[0] = new SQLiteParameter("1", DeptId);
sqlpar[1] = new SQLiteParameter("2", InhosStatus);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryDeptPatientCount, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryCheckLogDetail(string InhosID, string LogType)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[2];
sqlpar[0] = new SQLiteParameter("1", InhosID);
sqlpar[1] = new SQLiteParameter("2", LogType);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryCheckLogDetail, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryPatientEmrDocDetail(string InhosID, string SectionNo)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[2];
sqlpar[0] = new SQLiteParameter("1", InhosID);
sqlpar[1] = new SQLiteParameter("2", SectionNo);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryPatientEmrDocDetail, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryDutyResentPatientList(string DoctorID, string DPTypes)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[2];
sqlpar[0] = new SQLiteParameter("1", DoctorID);
sqlpar[1] = new SQLiteParameter("2", DPTypes);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryDutyResentPatientList, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryAdviceByLike(string AdviceType, string AdviceFilter, string StandingType)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[3];
sqlpar[0] = new SQLiteParameter("1", AdviceType);
sqlpar[1] = new SQLiteParameter("2", "%" + AdviceFilter + "%");
sqlpar[2] = new SQLiteParameter("3", StandingType);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryAdviceByLike, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string QueryMyPatientList(string DoctorID, string InhosStatus)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[2];
sqlpar[0] = new SQLiteParameter("1", DoctorID);
sqlpar[1] = new SQLiteParameter("2", InhosStatus);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryMyPatient, sqlpar);
string str = TypeChange.DataTableToXml(dt);
return(str);
}
}
public string QueryAdviceCount(string InhosID, string StandingFlag)
{
SQLiteParameter[] sqlpar = new SQLiteParameter[4];
sqlpar[0] = new SQLiteParameter("1", InhosID);
sqlpar[1] = new SQLiteParameter("2", StandingFlag);
sqlpar[2] = new SQLiteParameter("3", InhosID);
sqlpar[3] = new SQLiteParameter("4", StandingFlag);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(SqlTools.SqlQueryAdviceCount, sqlpar);
return(TypeChange.DataTableToXml(dt));
}
}
public string GetUser(string userCode, string pwd)
{
string sql = @"select * from User where code=:1 and password=:2";
SQLiteParameter[] sqlpar = new SQLiteParameter[2];
sqlpar[0] = new SQLiteParameter("1", userCode);
sqlpar[1] = new SQLiteParameter("2", pwd);
using (SqliteDBHelper sqldb = new SqliteDBHelper())
{
DataTable dt = sqldb.Query(sql, sqlpar);
string str = TypeChange.DataTableToXml(dt);
return(TypeChange.DataTableToXml(dt));
}
}
public ActionResult ExecuteSQL(string sql, bool?IsExport)
{
try
{
if (IsExport.HasValue && IsExport.Value)
{
ExcelHelper excelHelper = new ExcelHelper();
excelHelper.AddSheet("Sheet1", SqliteDBHelper.Query(sql).Tables[0]);
excelHelper.Export();
return(Content(string.Empty));
}
else
{
SqliteDBHelper.ExecuteSql(sql);
}
ViewBag.Message = "SQL执行成功";
ViewBag.Access = "True";
}
catch (Exception ex)
{
ViewBag.Message = "执行错误" + ex.Message;
}
return(View());
}
