/// <summary> /// 报告审核 /// </summary> /// <param name="report_id"></param> /// <param name="jsonData"></param> /// <returns></returns> public override bool SubmiteInfo(decimal report_id, string jsonData) { JavaScriptSerializer js = new JavaScriptSerializer(); MyReports rt = js.Deserialize <MyReports>(jsonData); List <SqlParameter> list = new List <SqlParameter>(); Content = rt.Content; Comment = rt.Comment; ///TODO Overview是否有用? Overview = rt.Overview; AuditTime = DateTime.Now.ToLocalTime().ToString(); SqlParameter[] ps = { new SqlParameter("@Content", Content), new SqlParameter("@Comment", Comment), new SqlParameter("@AuditTime", AuditTime), new SqlParameter("@StudyDescription", rt.StudyDescription), new SqlParameter("@AuditUserID", rt.AuditUserID), new SqlParameter("@AuditUserName", rt.AuditUserName) }; list.AddRange(ps); string sql = "update Reports set Content=@Content,Comment=@Comment,StudyDescription=@StudyDescription,AuditUserID = @AuditUserID,AuditUserName = @AuditUserName, AuditTime=@AuditTime, IsAudited = 1 where Report_ID=" + report_id; return(SqlHelper.ExecuteNonQuery(sql, list.ToArray()) > 0 ? true : false); }
public override bool DicomUpload(string jsonData) { JavaScriptSerializer js = new JavaScriptSerializer(); MyReports rt = js.Deserialize <MyReports>(jsonData); User_ID = rt.User_ID; PatientName = rt.PatientName; PatientSex = rt.PatientSex; PatientAge = rt.PatientAge; PatientID = rt.PatientID; StudyDescription = rt.StudyDescription; StudyLocalDirectory = rt.StudyLocalDirectory; StudyLocalDirectorySeg = rt.StudyLocalDirectorySeg; ImageFilePath = rt.ImageFilePath; MaskFilePath = rt.MaskFilePath; SqlParameter[] ps = { new SqlParameter("@User_ID", User_ID), new SqlParameter("@PatientName", PatientName), new SqlParameter("@PatientSex", PatientSex), new SqlParameter("@PatientAge", PatientAge), new SqlParameter("@PatientID", PatientID), new SqlParameter("@StudyDescription", StudyDescription), new SqlParameter("@StudyLocalDirectory", StudyLocalDirectory), new SqlParameter("@StudyLocalDirectorySeg", StudyLocalDirectorySeg), new SqlParameter("@ImageFilePath", ImageFilePath), new SqlParameter("@MaskFilePath", MaskFilePath), }; string sql1 = "insert into Reports (User_ID, PatientName,PatientSex,PatientAge,PatientID,StudyDescription,StudyLocalDirectory,StudyLocalDirectorySeg,ImageFilePath,MaskFilePath) values(@User_ID, @PatientName,@PatientSex,@PatientAge,@PatientID,@StudyDescription,@StudyLocalDirectory,@StudyLocalDirectorySeg,@ImageFilePath,@MaskFilePath);select @@IDENTITY"; //int id = Convert.ToInt32(SqlHelper.ExecuteScalar(sql1, list.ToArray())); //Report_ID = 30; // bool a = SqlHelper.ExecuteNonQuery(sql1, list.ToArray()) > 0 ? true : false; int reportID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql1, ps)); GliomaGradingHandler gliomaGradingHandler = new GliomaGradingHandler(GradingGlioma); gliomaGradingHandler(reportID, ImageFilePath, MaskFilePath); //调用甘富文的接口 //GradingGliomaAsync(reportID, ImageFilePath, MaskFilePath); if (reportID > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据report_id获取报表信息 /// </summary> /// <param name="report_id"></param> /// <returns></returns> public override string GetReportInfo(decimal report_id) { MyReports rt = new MyReports(); string sql = "select * from Reports where Report_ID=@Report_ID"; using (SqlDataReader sdr = SqlHelper.ExecuteReader(sql, new SqlParameter("@Report_ID", report_id))) { if (sdr.HasRows) { while (sdr.Read()) { rt.IsAudited = Convert.ToBoolean(sdr["IsAudited"]); //if (sdr["AuditUserName"].ToString() != null) // rt.AuditUserName = sdr["AuditUserName"].ToString(); if (sdr["AuditUserID"].ToString() != null) { rt.AuditUserID = sdr["AuditUserID"].ToString(); } if (Convert.ToInt32(sdr["Report_ID"]) != 0) { rt.Report_ID = Convert.ToInt32(sdr["Report_ID"]); } if (sdr["Overview"].ToString() != null) { rt.Overview = sdr["Overview"].ToString(); } if (sdr["Content"].ToString() != null) { rt.Content = sdr["Content"].ToString(); } if (sdr["Comment"].ToString() != null) { rt.Comment = sdr["Comment"].ToString(); } if (sdr["AuditTime"].ToString() != null) { rt.AuditTime = sdr["AuditTime"].ToString(); } if (sdr["PatientName"].ToString() != null) { rt.PatientName = sdr["PatientName"].ToString(); } if (sdr["PatientID"].ToString() != null) { rt.PatientID = sdr["PatientID"].ToString(); } if (Convert.ToInt32(sdr["PatientAge"]) != 0) { rt.PatientAge = Convert.ToInt32(sdr["PatientAge"]); } if (sdr["PatientSex"].ToString() != null) { rt.PatientSex = sdr["PatientSex"].ToString(); } if (sdr["StudyTime"].ToString() != null) { rt.StudyTime = sdr["StudyTime"].ToString(); } if (sdr["BodyPart"].ToString() != null) { rt.BodyPart = sdr["BodyPart"].ToString(); } if (sdr["StudyDescription"].ToString() != null) { rt.StudyDescription = sdr["StudyDescription"].ToString(); } if (sdr["InstitutionName"].ToString() != null) { rt.InstitutionName = sdr["InstitutionName"].ToString(); } if (sdr["RequestTime"].ToString() != null) { rt.RequestTime = sdr["RequestTime"].ToString(); } if (sdr["Modality"].ToString() != null) { rt.Modality = sdr["Modality"].ToString(); } if (sdr["StudyLocalDirectory"].ToString() != null) { rt.StudyLocalDirectory = sdr["StudyLocalDirectory"].ToString(); } if (sdr["StudyLocalDirectorySeg"].ToString() != null) { rt.StudyLocalDirectorySeg = sdr["StudyLocalDirectorySeg"].ToString(); } if (sdr["ImageFilePath"].ToString() != null) { rt.ImageFilePath = sdr["ImageFilePath"].ToString(); } if (sdr["MaskFilePath"].ToString() != null) { rt.MaskFilePath = sdr["MaskFilePath"].ToString(); } if (sdr["AuditUserName"].ToString() != null) { rt.AuditUserName = sdr["AuditUserName"].ToString(); } } } } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(rt)); }
/// <summary> /// 根据病人姓名查询 /// </summary> /// <param name="retrievalMassage"></param> /// <returns></returns> public override string GetReportInfoByRetrieval(string retrievalMassage) { List <MyReports> list = new List <MyReports>(); string sql = "select * from Reports where PatientName like '%" + retrievalMassage + "%'"; using (SqlDataReader sdr = SqlHelper.ExecuteReader(sql, new SqlParameter("PatientName", retrievalMassage))) { if (sdr.HasRows) { while (sdr.Read()) { MyReports rt = new MyReports(); rt.IsAudited = Convert.ToBoolean(sdr["IsAudited"]); if (sdr["AuditUserName"].ToString() != null) { rt.AuditUserName = sdr["AuditUserName"].ToString(); } if (sdr["AuditUserID"].ToString() != null) { rt.AuditUserID = sdr["AuditUserID"].ToString(); } if (Convert.ToInt32(sdr["Report_ID"]) != 0) { rt.Report_ID = Convert.ToInt32(sdr["Report_ID"]); } if (sdr["Overview"].ToString() != null) { rt.Overview = sdr["Overview"].ToString(); } if (sdr["Content"].ToString() != null) { rt.Content = sdr["Content"].ToString(); } if (sdr["Comment"].ToString() != null) { rt.Comment = sdr["Comment"].ToString(); } if (sdr["AuditTime"].ToString() != null) { rt.AuditTime = sdr["AuditTime"].ToString(); } if (sdr["PatientName"].ToString() != null) { rt.PatientName = sdr["PatientName"].ToString(); } if (sdr["PatientID"].ToString() != null) { rt.PatientID = sdr["PatientID"].ToString(); } if (Convert.ToInt32(sdr["PatientAge"]) != 0) { rt.PatientAge = Convert.ToInt32(sdr["PatientAge"]); } if (sdr["PatientSex"].ToString() != null) { rt.PatientSex = sdr["PatientSex"].ToString(); } if (sdr["StudyTime"].ToString() != null) { rt.StudyTime = sdr["StudyTime"].ToString(); } if (sdr["BodyPart"].ToString() != null) { rt.BodyPart = sdr["BodyPart"].ToString(); } if (sdr["StudyDescription"].ToString() != null) { rt.StudyDescription = sdr["StudyDescription"].ToString(); } if (sdr["InstitutionName"].ToString() != null) { rt.InstitutionName = sdr["InstitutionName"].ToString(); } if (sdr["RequestTime"].ToString() != null) { rt.RequestTime = sdr["RequestTime"].ToString(); } if (sdr["Modality"].ToString() != null) { rt.Modality = sdr["Modality"].ToString(); } if (sdr["StudyLocalDirectory"].ToString() != null) { rt.StudyLocalDirectory = sdr["StudyLocalDirectory"].ToString(); } if (sdr["StudyLocalDirectorySeg"].ToString() != null) { rt.StudyLocalDirectorySeg = sdr["StudyLocalDirectorySeg"].ToString(); } if (sdr["ImageFilePath"].ToString() != null) { rt.ImageFilePath = sdr["ImageFilePath"].ToString(); } if (sdr["MaskFilePath"].ToString() != null) { rt.MaskFilePath = sdr["MaskFilePath"].ToString(); } list.Add(rt); } } } string jsonData = JsonConvert.SerializeObject(list); return(jsonData); }