private void LoadDateShortStatistic() { DAReport daReport = new DAReport(); daReport.USP_Report_DashBoard(); if (daReport.mDataReader.Read()) { fCustomerNumber.InnerText = daReport.mDataReader["CustomerNumber"].ToString(); fOrderNumber.InnerText = daReport.mDataReader["OrderNumber"].ToString(); fProductNumber.InnerText = daReport.mDataReader["ProductNumber"].ToString(); fNewsNumber.InnerText = daReport.mDataReader["NewsNumber"].ToString(); daReport.mDataReader.Close(); } else { daReport.mDataReader.Close(); } }
/// <summary> /// 添加报告记录更改状态 /// </summary> /// <param name="SID"></param> /// <param name="msglist"></param> /// <param name="requestcode"></param> /// <param name="config"></param> /// <param name="itemtype"></param> /// <returns></returns> private int InsertReportAddStatus(string SID, List <string> msglist, string requestcode, string model, int itemtype) { //报告 DataTable dtReports = GetReport(SID, msglist, requestcode); //获取报告失败 直接返回 if (dtReports.Rows.Count == 0) { return(0); } //执行的SQL集合 SortedList SQLlist = new SortedList(new MySort()); string errormsg = string.Empty; int status = 3; try { bool breport = true; #region >>>> zhouy 添加报告 for (int i = 0; i < dtReports.Rows.Count; i++) { DataRow drreport = dtReports.Rows[i]; DAReport _report = new DAReport(); _report.Reportid = Convert.ToDecimal(drreport["Reportid"]); _report.Requestcode = drreport["RequestCode"].ToString(); if (dtReports.Columns.Contains("HospSampleID") && drreport["HospSampleID"] != DBNull.Value) { _report.Hospsampleid = drreport["HospSampleID"].ToString(); } if (dtReports.Columns.Contains("HospSampleNumber") && drreport["HospSampleNumber"] != DBNull.Value) { _report.Hospsamplenumber = drreport["HospSampleNumber"].ToString(); } if (dtReports.Columns.Contains("ReportData") && drreport["ReportData"] != DBNull.Value && drreport["ReportData"].ToString() != string.Empty) { _report.Reportdata = Convert.FromBase64String(drreport["ReportData"].ToString()); } if (_report.Reportdata.Length == 0) { breport = false; } if (dtReports.Columns.Contains("printcount") && drreport["printcount"] != DBNull.Value) { _report.Printcount = Convert.ToDecimal(drreport["printcount"]); } if (dtReports.Columns.Contains("printdate") && drreport["printdate"] != DBNull.Value) { _report.Printtime = Convert.ToDateTime(drreport["printdate"]); } if (dtReports.Columns.Contains("ReportType") && drreport["ReportType"] != DBNull.Value) { _report.Reporttype = drreport["ReportType"].ToString(); } if (dtReports.Columns.Contains("status") && drreport["status"] != DBNull.Value) { _report.Status = drreport["status"].ToString(); } if (dtReports.Columns.Contains("Papersize") && drreport["Papersize"] != DBNull.Value) { _report.Papersize = drreport["Papersize"].ToString(); } SQLlist.Add(new Hashtable() { { "INSERT", "InsertDAReport" } }, _report); } #endregion Hashtable ht = new Hashtable(); ht.Add("RequestCode", requestcode); //组合对应模式 if (model == "1") { bool isfull = new DAOutSpecimentestBLL().SelectIsFullByRequestCode(requestcode); status = isfull ? 4 : 3; } //组合单项全对应模式 else { if (breport) { //ItemType 0.普通项目,1.病理 if (itemtype == 0) { bool isfull = resultbll.SelectIsFullResultByRequestCode(requestcode); status = isfull ? 4 : 3; } else { bool isfull = pathologyresultbll.SelectIsFullPathologyResultByRequestCode(requestcode); status = isfull ? 4 : 3; } } } ht.Add("Status", status); SQLlist.Add(new Hashtable() { { "UPDATE", "UpdateDAOutspecimenByRequestCode" } }, ht); bool b = service.ExecuteSqlTran(SQLlist, ref errormsg); if (!b) { status = 0; } } catch (Exception ex) { status = 0; errormsg = ex.Message; } //错误信息添加到集合 if (status == 0) { msglist.Add("插入报告更改失败:" + errormsg); } return(status); }
/// <summary> /// 修改报告记录 /// </summary> /// <param name="user"></param> /// <returns></returns> public int UpdateDAReportInfo(DAReport report) { return(service.update("UpdateDAReport", report)); }
/// <summary> /// 添加报告记录 /// </summary> /// <param name="user"></param> /// <returns></returns> public object InsertDAReportInfo(DAReport report) { return(service.insert("InsertDAReport", report)); }