/// <summary> /// 获取组织机构 /// </summary> /// <returns></returns> public List <OrgEntity> GetOrg() { string ProjectId = OperatorProvider.Provider.CurrentUser.ProjectId; string sql1 = @"select case when cp.ParentCompanyCode='1' then '0' else cp.ParentCompanyCode end as pid,cp.CompanyCode as id,cp.CompanyFullName as Name,'Org' as TypeName,cast(cp.OrgType as varchar) as OrgType,pc.ProjectId from TbCompany cp left join TbProjectCompany pc on cp.CompanyCode=pc.CompanyCode where pc.ProjectId=@ProjectId and cp.OrgType!=1 order by cp.id asc"; DataTable dt1 = Db.Context.FromSql(sql1).AddInParameter("@ProjectId", DbType.String, ProjectId).ToDataTable(); string sql2 = "select CompanyCode as id,CompanyFullName as Name,'Org' as TypeName,OrgType from TbCompany where OrgType=1"; DataTable dt2 = Db.Context.FromSql(sql2).ToDataTable(); if (dt2 != null && dt2.Rows.Count > 0) { DataTable dt3 = dt1.Select("pid='0'").CopyToDataTable(); for (int i = 0; i < dt2.Rows.Count; i++) { DataRow newRow = dt1.NewRow(); newRow["pid"] = dt3.Rows[0]["id"]; newRow["id"] = dt2.Rows[i]["id"]; newRow["Name"] = dt2.Rows[i]["Name"]; newRow["TypeName"] = dt2.Rows[i]["TypeName"]; newRow["OrgType"] = dt2.Rows[i]["OrgType"]; newRow["ProjectId"] = dt3.Rows[0]["ProjectId"]; dt1.Rows.Add(newRow); } } return(ModelConvertHelper <OrgEntity> .ToList(dt1)); }
///// <summary> ///// 新增、修改 ///// </summary> ///// <param name="jdata"></param> ///// <returns></returns> //[HttpGet] //public HttpResponseMessage SaveCompanyData(string jdata) //{ // try // { // //{"type":"add","model":{"CompanyCode":"001003002","ParentCompanyCode":"001003","CompanyFullName":"二工区","Address":"广州市","IsEnable": 0,"OrgType":3}} // JObject jo = (JObject)JsonConvert.DeserializeObject(jdata); // string modelstr = jo["model"] == null ? "" : jo["model"].ToString(); // string type = jo["type"] == null ? "" : jo["type"].ToString(); // if (string.IsNullOrWhiteSpace(modelstr) || string.IsNullOrWhiteSpace(type)) // return AjaxResult.Error("参数错误").ToJsonApi(); // var model = JsonEx.JsonToObj<TbCompany>(modelstr); // if (type == "add") // { // var data = cit.Insert(model, true); // return data.ToJsonApi(); // } // else // { // var data = cit.Update(model, true); // return data.ToJsonApi(); // } // } // catch (Exception) // { // return AjaxResult.Error("操作失败").ToJsonApi(); // } //} ///// <summary> ///// 删除 ///// </summary> ///// <param name="keyValue"></param> ///// <returns></returns> //[HttpGet] //public HttpResponseMessage DeleteCompanyData(string companyCode) //{ // var data = cit.Delete(companyCode, true); // return data.ToJsonApi(); //} /// <summary> /// 获取组织机构地址 /// </summary> /// <returns></returns> public HttpResponseMessage GetCompanyList(string url) { try { var dataJson = Get(strBMUrl + url); JObject jo = (JObject)JsonConvert.DeserializeObject(dataJson); string modelstr = jo["data"] == null ? "" : jo["data"].ToString(); if (string.IsNullOrWhiteSpace(modelstr)) { return(AjaxResult.Error("参数错误").ToJsonApi()); } DataTable dt = ToDataTable(modelstr); dt.Columns["OrgId"].ColumnName = "CompanyCode"; dt.Columns["OrgName"].ColumnName = "CompanyFullName"; dt.Columns["ParentOrgId"].ColumnName = "ParentCompanyCode"; dt.Columns["Address"].ColumnName = "Address"; dt.Columns["OrgType"].ColumnName = "OrgType"; DataColumn dc = new DataColumn("IsEnable", typeof(int)); dc.DefaultValue = 0; dt.Columns.Add(dc); List <TbCompany> model = ModelConvertHelper <TbCompany> .ToList(dt); var data = cit.InsertNew(model, true); return(AjaxResult.Success(data).ToJsonApi()); } catch (Exception) { return(AjaxResult.Error("操作失败").ToJsonApi()); } }
public List <TbAreaAdministration> GetParentAreaJosn(string AreaCode) { string sql = @"select * from TbAreaAdministration where FK_AreaCode is null or FK_AreaCode='" + AreaCode + "'"; var model = Db.Context.FromSql(sql).ToDataTable(); var modelList = ModelConvertHelper <TbAreaAdministration> .ToList(model); return(modelList); }
/// <summary> /// 取得对应条件的五官科资料 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public List <RecordsVisceraFunctionModel> GetModelList(string strWhere, string conn = "") { // 取得五官资料 DataTable dt = this.dal.GetList(strWhere, conn).Tables[0]; // 将DataTable转为List List <RecordsVisceraFunctionModel> list = ModelConvertHelper <RecordsVisceraFunctionModel> .ToList(dt); return(list); }
/// <summary> /// 取得对应条件的外科资料 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public List <RecordsPhysicalExamModel> GetSurgicalList(string strWhere, string conn = "") { // 取得外科资料 DataTable dt = this.dal.GetSurgicalList(strWhere, conn).Tables[0]; // 将DataTable转为List List <RecordsPhysicalExamModel> list = ModelConvertHelper <RecordsPhysicalExamModel> .ToList(dt); return(list); }
/// <summary> /// 取得对应条件的X光资料 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public List <RecordsAssistCheckModel> GetChestXList(string strWhere, string conn = "") { // 取得X光资料 DataTable dt = this.dal.GetChestXList(strWhere, conn).Tables[0]; // 将DataTable转为List List <RecordsAssistCheckModel> list = ModelConvertHelper <RecordsAssistCheckModel> .ToList(dt); return(list); }
public TbFlowDefineResponse GetFlowDefine(string keyvalue) { var dt = Db.Context.From <TbFlowDefine>() .Select( TbFlowDefine._.All, TbSysMenu._.MenuName) .LeftJoin <TbSysMenu>((a, c) => a.FormCode == c.MenuCode).Where(p => p.FlowCode == keyvalue).ToDataTable(); var list = ModelConvertHelper <TbFlowDefineResponse> .ToList(dt); return(list[0]); }
public List <RecordsMedicationModel> GetMaxModelList(string strWhere) { DataSet ds = this.dal.GetMaxList(strWhere); if (ds == null) { return(null); } return(ModelConvertHelper <RecordsMedicationModel> .ToList(ds.Tables[0])); }
/// <summary> /// 取得对应条件的内科资料 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public IList <InternalMedicineModel> GetInternalMedicine(string startDate, string endDate, int startIndex, int endIndex, string conn) { DataSet ds = dal.GetInternalMedicine(startDate, endDate, startIndex, endIndex, conn); if (ds != null && ds.Tables.Count > 0) { return(ModelConvertHelper <InternalMedicineModel> .ToList(ds.Tables[0])); } return(new List <InternalMedicineModel>()); }
/// <summary> /// 获取体检问询住院、免疫接种史资料内容 /// </summary> /// <param name="startDate">开始日期</param> /// <param name="endDate">结束日期</param> /// <returns></returns> public IList <History> GetHistory(string startDate, string endDate, string conn) { DataSet ds = dal.GetHistory(startDate, endDate, conn); if (ds != null && ds.Tables.Count > 0) { return(ModelConvertHelper <History> .ToList(ds.Tables[0])); } return(new List <History>()); }
/// <summary> /// 取得对应条件的X光资料 /// </summary> /// <param name="strWhere"></param> /// <returns></returns> public IList <RecordsAssistCheckModel> GetRecordsChestX(string startDate, string endDate, int startIndex, int endIndex, string conn) { DataSet ds = dal.GetRecordsChestX(startDate, endDate, startIndex, endIndex, conn); if (ds != null && ds.Tables.Count > 0) { return(ModelConvertHelper <RecordsAssistCheckModel> .ToList(ds.Tables[0])); } return(new List <RecordsAssistCheckModel>()); }
/// <summary> /// 获取资料内容 /// </summary> /// <param name="startDate">开始日期</param> /// <param name="endDate">结束日期</param> /// <param name="deviceType">设备类型 20:血压 24:血糖 39:身高体重 33:尿仪 22:体温 40:体重</param> /// <param name="startIndex">开始笔数</param> /// <param name="endIndex">结束笔数</param> /// <returns></returns> public IList <DeviceInfoModel> GetDeviceInfo(string startDate, string endDate, string deviceType, int startIndex, int endIndex, string conn) { DataSet ds = dal.GetDeviceInfo(startDate, endDate, deviceType, startIndex, endIndex, conn); if (ds != null && ds.Tables.Count > 0) { return(ModelConvertHelper <DeviceInfoModel> .ToList(ds.Tables[0])); } return(new List <DeviceInfoModel>()); }
public List <RecordsIllnessHistoryInfoModel> GetModelList(string strWhere) { DataSet ds = this.dal.GetList(strWhere); if (ds == null) { return(null); } return(ModelConvertHelper <RecordsIllnessHistoryInfoModel> .ToList(ds.Tables[0])); }
/// <summary> /// 获取智力评估资料内容 /// </summary> /// <param name="startDate">开始日期</param> /// <param name="endDate">结束日期</param> /// <param name="startIndex">开始笔数</param> /// <param name="endIndex">结束笔数</param> /// <returns></returns> public IList <OldIntelligenceModel> GetIntelligence(string startDate, string endDate, string conn) { DataSet ds = dal.GetIntelligence(startDate, endDate, conn); if (ds != null && ds.Tables.Count > 0) { return(ModelConvertHelper <OldIntelligenceModel> .ToList(ds.Tables[0])); } return(new List <OldIntelligenceModel>()); }
/// <summary> /// 获取体检问询资料内容 /// </summary> /// <param name="startDate">开始日期</param> /// <param name="endDate">结束日期</param> /// <param name="startIndex">开始笔数</param> /// <param name="endIndex">结束笔数</param> /// <returns></returns> public IList <DataUploadModel> GetMedicalEnquiry(string startDate, string endDate, int startIndex, int endIndex, string conn) { DataSet ds = dal.GetMedicalEnquiry(startDate, endDate, startIndex, endIndex, conn); if (ds != null && ds.Tables.Count > 0) { return(ModelConvertHelper <DataUploadModel> .ToList(ds.Tables[0])); } return(new List <DataUploadModel>()); }
/// <summary> /// 获取体检问询用药资料内容 /// </summary> /// <param name="startDate">开始日期</param> /// <param name="endDate">结束日期</param> /// <returns></returns> public IList <RecordsMedicationModel> GetMedication(string startDate, string endDate, string conn) { DataSet ds = dal.GetMedication(startDate, endDate, conn); if (ds != null && ds.Tables.Count > 0) { return(ModelConvertHelper <RecordsMedicationModel> .ToList(ds.Tables[0])); } return(new List <RecordsMedicationModel>()); }
public List <DeviceInfoModel> GetMaxModelList(string strWhere, string conn = "") { DataSet ds = this.dal.GetMaxList(strWhere, conn); if (ds == null) { return(null); } return(ModelConvertHelper <DeviceInfoModel> .ToList(ds.Tables[0])); }
/// <summary> /// 根据体检外键取得资料 /// </summary> /// <param name="OutKey"></param> /// <returns></returns> public RecordsGeneralConditionModel GetModelByOutKey(int OutKey) { DataSet ds = dal.GetModelByOutKey(OutKey); List <RecordsGeneralConditionModel> list = ModelConvertHelper <RecordsGeneralConditionModel> .ToList((ds.Tables[0])); if (list.Count > 0) { return(list[0]); } return(new RecordsGeneralConditionModel()); }
/// <summary> /// 查询 /// </summary> /// <param name="where"></param> /// <returns></returns> public OtherAssessSetModel GetModel(string where = "") { DataSet ds = dal.GetList(where); if (ds != null && ds.Tables.Count > 0) { List<OtherAssessSetModel> list = ModelConvertHelper<OtherAssessSetModel>.ToList(ds.Tables[0]); if (list.Count > 0) return list[0]; } return null; }
public List <RequireModel> GetModel(string TabName, string Comment, string ChinName) { DataSet ds = this.dal.GetData(TabName, Comment, ChinName); if (ds != null && ds.Tables[0].Rows.Count > 0) { List <RequireModel> list = ModelConvertHelper <RequireModel> .ToList(ds.Tables[0]); return(list); } return(null); }
public List <RecordsMedicationModel> GetModelList(string strWhere, string conn = "") { DataSet ds = this.dal.GetList(strWhere, conn); List <RecordsMedicationModel> list = new List <RecordsMedicationModel>(); if (ds.Tables[0].Rows.Count > 0) { // 将DataTable转为List list = ModelConvertHelper <RecordsMedicationModel> .ToList(ds.Tables[0]); } return(list); }
public List <OlderSelfCareabilityModel> GetModelList(string strWhere) { DataSet ds = this.dal.GetList(strWhere); List <OlderSelfCareabilityModel> list = new List <OlderSelfCareabilityModel>(); int count = ds.Tables[0].Rows.Count; if (count > 0) { // 将DataTable转为List list = ModelConvertHelper <OlderSelfCareabilityModel> .ToList(ds.Tables[0]); } return(list); }
public RecordsSelfcareabilityModel GetModelID(int ID) { DataSet ds = this.dal.GetModelID(ID); if (ds != null && ds.Tables.Count > 0) { List <RecordsSelfcareabilityModel> list = ModelConvertHelper <RecordsSelfcareabilityModel> .ToList(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
/// <summary> /// 心电 /// </summary> /// <param name="strWhere"></param> /// <param name="conn"></param> /// <returns></returns> public List <EcgDataModel> GetECGList(string strWhere, string conn = "") { DataSet ds = this.dal.GetECGList(strWhere, conn); List <EcgDataModel> list = new List <EcgDataModel>(); int count = ds.Tables[0].Rows.Count; if (count > 0) { // 将DataTable转为List list = ModelConvertHelper <EcgDataModel> .ToList(ds.Tables[0]); } return(list); }
/// <summary> /// 获取所有附件ID /// </summary> /// <param name="ids"></param> /// <returns></returns> public List <TbAttachment> GetUploadList(string ids) { string FileIDNew = ""; if (!string.IsNullOrEmpty(ids)) { string str = ids; string[] strs = str.Split(','); for (int i = 0; i < strs.Length; i++) { if (FileIDNew == "") { FileIDNew += "'" + strs[i] + "'"; } else { FileIDNew += ",'" + strs[i] + "'"; } } } try { string sql; if (!string.IsNullOrEmpty(FileIDNew)) { sql = @"select TbAttachment.*,TbUser.UserName from TbAttachment left join TbUser on TbAttachment.UserCode=TbUser.UserCode where FileID in (" + FileIDNew + ")"; } else { sql = @"select TbAttachment.*,TbUser.UserName from TbAttachment left join TbUser on TbAttachment.UserCode=TbUser.UserCode where FileID='" + ids + "'"; } var model = Db.Context.FromSql(sql).ToDataTable(); var list = ModelConvertHelper <TbAttachment> .ToList(model); return(list); } catch (Exception) { throw; } //var ret = Db.Context.From<TbAttachment>() //.Select(TbAttachment._.All).Where(p => p.FileID == ids).ToList(); //return ret; }
/// <summary> /// 查询 /// </summary> /// <param name="where"></param> /// <returns></returns> public BiochemicalAssessSetModel GetModel(string where = "") { DataSet ds = dal.GetList(where); if (ds != null && ds.Tables.Count > 0) { List <BiochemicalAssessSetModel> list = ModelConvertHelper <BiochemicalAssessSetModel> .ToList(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
/// <summary> /// 取最后一次随访 /// </summary> /// <param name="IDCardNo"></param> /// <param name="VersionNo"></param> /// <returns></returns> public ChronicHypertensionVisitModel GetMaxModel(string IDCardNo, string Version = "V2.0") { DataSet ds = dal.GetMaxModel(IDCardNo, Version); if (ds != null && ds.Tables.Count > 0) { List <ChronicHypertensionVisitModel> list = ModelConvertHelper <ChronicHypertensionVisitModel> .ToList(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(null); }
public List <DeviceInfoModel> GetModelList(string strWhere) { DataSet ds = this.dal.GetList(strWhere); if (ds != null && ds.Tables.Count > 0) { List <DeviceInfoModel> list = ModelConvertHelper <DeviceInfoModel> .ToList(ds.Tables[0]); if (list.Count > 0) { return(list); } } return(null); }
public List <HealthGuidanceModel> GetModelList(string where) { DataSet ds = dal.GetModelList(where); if (ds != null && ds.Tables.Count > 0) { List <HealthGuidanceModel> list = ModelConvertHelper <HealthGuidanceModel> .ToList(ds.Tables[0]); if (list.Count > 0) { return(list); } } return(null); }
public RecordsAssistCheckModel GetModelByOutKey(int OutKey) { DataSet ds = this.dal.GetModelByOutKey(OutKey); if (ds != null && ds.Tables.Count > 0) { List <RecordsAssistCheckModel> list = ModelConvertHelper <RecordsAssistCheckModel> .ToList(ds.Tables[0]); if (list.Count > 0) { return(list[0]); } } return(new RecordsAssistCheckModel()); }