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()); }