public HealthAssessExamModel GetModel(int PID) { StringBuilder builder = new StringBuilder(); builder.Append(" select * "); builder.Append(" from HEALTHHOUSE_ASSESS_EXAM "); builder.Append(" where PID=@PID "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PID", PID) }; DataSet set = MySQLHelper.Query(builder.ToString(), cmdParms); if (set != null) { // 将DataTable转为List IList <HealthAssessExamModel> list = CommonExtensions.DataTableToList <HealthAssessExamModel>(set.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
/// <summary> /// 获取体检数据类型的异常信息 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public HealthOverviewSetModel GetModel(string strWhere) { StringBuilder builder = new StringBuilder(); builder.Append(" select * "); builder.Append(" from HEALTHHOUSE_OVERVIEW_SET "); builder.Append(" where 1=1 "); if (!string.IsNullOrEmpty(strWhere)) { builder.Append(strWhere); } DataSet set = MySQLHelper.Query(builder.ToString()); if (set != null) { // 将DataTable转为List IList <HealthOverviewSetModel> list = CommonExtensions.DataTableToList <HealthOverviewSetModel>(set.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
/// <summary> /// 取得代码档选项资料 /// </summary> /// <param name="pCategory">代码类别</param> /// <param name="bIncludeNo">是否包含选项</param> /// <returns></returns> public IList <CodeBaseModel> GetCodeBaseByCategory(string pCategory, bool bIncludeNo = false) { DataSet ds = this.dal.GetCodeBaseByCategory(pCategory, bIncludeNo); if (ds != null && ds.Tables[0].Rows.Count > 0) { // 将DataTable转为List IList <CodeBaseModel> list = CommonExtensions.DataTableToList <CodeBaseModel>(ds.Tables[0]); return(list); } return(null); }
/// <summary> /// 健康指导 根据身份证取得资料 /// </summary> /// <param name="idCardNo"></param> /// <returns></returns> public HealthHouseGuideModel GetGuideData(string idCardNo) { DataSet ds = this.dal.GetGuideData(idCardNo); if (ds != null && ds.Tables != null && ds.Tables[0].Rows.Count > 0) { IList <HealthHouseGuideModel> list = CommonExtensions.DataTableToList <HealthHouseGuideModel>(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
/// <summary> /// 获取最新一笔体检的体检问询 /// </summary> /// <param name="IDCardNo">身份证</param> /// <returns></returns> public HealthAssessExamModel GetMaxModel(string IDCardNo) { StringBuilder builder = new StringBuilder(); builder.Append(@"SELECT a.PID,a.IDCardNo, a.MedicalHistory, a.FamilyHistory, a.HospitalHistory, a.TakingMedicine, a.DietaryHabit, a.DietaryNum, a.DietaryLaw, a.DietaryOther, a.ExerciseExistense, a.IsSmoke, a.IsDrink, a.ExerciseExistenseOther, a.ExerciseRate, a.ExerciseTimes, a.OldSelfCareability, a.GloomyScore, a.MedicalOther, a.FamilyOther "); builder.Append(" From HEALTHHOUSE_ASSESS_EXAM a "); builder.Append(" Left Join ARCHIVE_HEALTH_HOUSE b ON a.IDCardNo = b.IDCardNo and a.PID=b.ID "); builder.Append(" where a.IDCardNo=@IDCardNo "); builder.Append(" order by b.CheckDate DESC LIMIT 0,1 "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", IDCardNo) }; cmdParms[0].Value = IDCardNo; DataSet set = MySQLHelper.Query(builder.ToString(), cmdParms); if (set != null) { // 将DataTable转为List IList <HealthAssessExamModel> list = CommonExtensions.DataTableToList <HealthAssessExamModel>(set.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
/// <summary> /// 体检画面 根据身份证及检查日期取得资料 /// </summary> /// <param name="idCardNo"></param> /// <param name="checkDate"></param> /// <returns></returns> public HealthHouseModel GetData(string idCardNo, string checkDate) { DataSet ds = this.dal.GetData(idCardNo, checkDate); if (ds.Tables[0].Rows.Count > 0) { // 将DataTable转为List IList <HealthHouseModel> list = CommonExtensions.DataTableToList <HealthHouseModel>(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
/// <summary> /// 根据ID取得资料 /// </summary> /// <param name="idCardNo"></param> /// <param name="checkDate"></param> /// <returns></returns> public HealthHouseModel GetDataByID(int ID) { DataSet ds = this.dal.GetDataByID(ID); if (ds.Tables[0].Rows.Count > 0) { // 将DataTable转为List IList <HealthHouseModel> list = CommonExtensions.DataTableToList <HealthHouseModel>(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
public HealthHouseEcgModel GetModel(int PID) { DataSet ds = this.dal.GetModel(PID); if (ds != null) { // 将DataTable转为List IList <HealthHouseEcgModel> list = CommonExtensions.DataTableToList <HealthHouseEcgModel>(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
public HealthHousePhysicalAssistCheckModel GetModel(int OutKey) { DataSet ds = this.dal.GetModel(OutKey); if (ds != null) { // 将DataTable转为List IList <HealthHousePhysicalAssistCheckModel> list = CommonExtensions.DataTableToList <HealthHousePhysicalAssistCheckModel>(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
/// <summary> /// 获取健康指导 - 根据身份证号 /// </summary> /// <param name="idCardNo"></param> /// <returns></returns> public HealthHouseGuideModel GetHealthGuideByIdCardNo(int ID) { StringBuilder builder = new StringBuilder(); builder.Append(@"SELECT b.CustomerName ,b.Sex ,b.Birthday ,c.CheckDate ,a.Summary ,a.HealthGuid ,a.MedGuid FROM HEALTHHOUSE_HEALTH_GUIDE a LEFT JOIN ARCHIVE_BASEINFO b ON a.IDCardNo=b.IDCardNo LEFT JOIN ARCHIVE_CUSTOMERBASEINFO c ON a.IDCardNo=c.IDCardNo Where a.ID=@ID"); List <MySqlParameter> cmdParms = new List <MySqlParameter>(); cmdParms.Add(new MySqlParameter("@ID", ID)); DataSet ds = MySQLHelper.Query(builder.ToString(), cmdParms.ToArray()); if (ds != null) { IList <HealthHouseGuideModel> list = CommonExtensions.DataTableToList <HealthHouseGuideModel>(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }