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