public DataTable GetOrderDelete(Hashtable ht)
{
DataTable dt = selectDS("Order.SelectOrderDelete", ht).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["AGE"] = WebUI.GetAge(dt.Rows[i]["AGE"]);
}
return(dt);
}
/// <summary>
/// 查询修改单位名称的相关数据
/// </summary>
public DataTable GetManagementOrdersByDictmemberid(Hashtable ht)
{
DataTable dt = this.selectDS("Order.GetManagementOrdersByDictmemberid", ht).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["AGE"] = WebUI.GetAge(dt.Rows[i]["AGE"]);
}
return(dt);
}
/// <summary>
/// 查询统计HPV、TM检查人员信息
/// </summary>
/// <param name="ht"></param>
/// <returns></returns>
public DataTable GetHPVTMAccondingInfos(Hashtable ht)
{
DataTable dt = selectDS("Order.GetHPVTMAccondingInfos", ht).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["AGE"] = WebUI.GetAge(dt.Rows[i]["AGE"]);
}
return(dt);
}
/// <summary>
/// 根据姓名+性别查询体检记录
/// </summary>
/// <param name="ht"></param>
/// <returns></returns>
public DataTable GetMemeberPastOrders(Hashtable ht)
{
DataTable dt = selectDS("Order.GetMemberPastOrders", ht).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["AGE"] = WebUI.GetAge(dt.Rows[i]["AGE"]);
}
return(dt);
}
public DataTable GetReportDataForWinform(Hashtable ht)
{
DataTable dt = selectDS("Order.DataForReport", ht).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["AGE"] = WebUI.GetAge(dt.Rows[i]["AGE"]);
}
return(dt);
}
/// <summary>
/// 报告打印审核导出数据
/// </summary>
/// <param name="ht"></param>
/// <returns></returns>
public DataTable DataForFinanceAuditExport(Hashtable ht)
{
DataTable dt = selectDS("Order.DataForFinanceAuditExport", ht).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["年龄"] = WebUI.GetAge(dt.Rows[i]["年龄"]);
}
return(dt);
}
/// <summary>
///体检报告单查询打印,分页查询
/// </summary>
/// <param name="ht"></param>
/// <returns></returns>
public DataTable DataForFocusPrintPageLst(Hashtable htPara)
{
DataTable dt = selectDS("Order.DataForFocusPrintPageLst", htPara).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["AGE"] = WebUI.GetAge(dt.Rows[i]["AGE"]);
}
return(dt);
}
/// <summary>
/// 总检医生查询订单
/// </summary>
/// <param name="ht">查询参数</param>
/// <returns></returns>
public DataTable GetFinishOrdersList(Hashtable ht, string t)
{
string statementName = t == "1" ? "Order.GetAuthorizedOrdersList" : "Order.GetFinishOrdersList";
DataTable dt = selectDS(statementName, ht).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["AGE"] = WebUI.GetAge(dt.Rows[i]["AGE"]);
}
return(dt);
}
//打印条码
protected void btnPrintBarcode_Click(object sender, EventArgs e)
{
foreach (int rowIndex in GridOrders.SelectedRowIndexArray)
{
GridRow row = GridOrders.Rows[rowIndex];
if (!(row.Values[5].Contains("已登记") || row.Values[5].Contains("条码已打印")))
{
MessageBoxShow(string.Format("条码号:{0} 姓名:{1} 已打印过条码，条码补打模块可补打条码", row.Values[0], row.Values[1]));
return;
}
}
SetInitlocalsetting(hdMac.Text);//设置打印所需的客户端配置信息
string ordernums = GetSelectOrderNums(false);
if (ordernums == string.Empty)
{
return;
}
DataTable dtSource = new OrderbarcodeService().GetPrintBarcodeData(new Hashtable()
{
{ "ordernum", ordernums }, { "orderbarcode", null }
});
for (int i = 0; i < dtSource.Rows.Count; i++)
{
string testnames = dtSource.Rows[i]["TESTNAMES"].ToString();
dtSource.Rows[i]["AGE"] = WebUI.GetAge(dtSource.Rows[i]["AGE"]);//处理年龄
dtSource.Rows[i]["COLLECTDATE"] = dtSource.Rows[i]["COLLECTDATE"].ToString();
dtSource.Rows[i]["TESTNAMES"] = testnames.TrimEnd(',');
dtSource.Rows[i]["COUNT"] = String.Format("共{0}项", testnames.TrimEnd(',').Split(',').Length);
}
//修改订单状态为[条码已打印]（已登记的才改）
new OrdersService().EditStatusByOldStatus(new Hashtable()
{
{ "ordernum", ordernums }, { "status", (int)ParamStatus.OrdersStatus.BarCodePrint }, { "oldstatus", (int)ParamStatus.OrdersStatus.Register },
});
//后续调用柯木朗方法打印
//..........................
commonReport.PrintBarCode(dtSource, Userinfo);
ExtAspNet.PageContext.RegisterStartupScript(string.Format(" PrintBarCode(\'{0}\',\'{1}\');", CommonReport.printer, CommonReport.json));
//记录日志
JournalLog(ordernums, "打印条码");
}
//打印指引单
protected void btnPrintSingle_Click(object sender, EventArgs e)
{
SetInitlocalsetting(hdMac.Text);//设置打印所需的客户端配置信息
string ordernums = GetSelectOrderNums(false);
if (ordernums == string.Empty)
{
return;
}
DataTable dtSource = mamagement.GetPrintDirectData(ordernums);
string[] arrordernum = ordernums.Split(',');
Report report = new Report();
for (int i = 0; i < arrordernum.Length; i++)
{
DataSet ds = new DataSet();
DataTable dt = dtSource.Select("ordernum=" + arrordernum[i]).CopyToDataTable();
DataTable dthead = dt.Clone();//复制表结构
dt.TableName = "dtHealthGuideResult";
dthead.TableName = "dtHealthGuideTitle";
DataRow dr = dt.Rows[0];
dr["AGE"] = WebUI.GetAge(dr["AGE"]); //处理年龄
dr["PHONE"] = dr["PHONE"].ToString().TrimEnd('/').TrimStart('/'); //处理电话格式
dthead.ImportRow(dr); //复制一行
//title
DataTable dttitle = new DataTable();
dttitle.TableName = "dtTitle";
dttitle.Columns.Add("titleName", typeof(string));//报告标题
DataRow dttitledr = dttitle.NewRow();
dttitledr[0] = dt.Rows[0]["titleName"];
dttitle.Rows.Add(dttitledr);
//title end
ds.Tables.Add(dthead);
ds.Tables.Add(dt);
ds.Tables.Add(dttitle);
//后续调用柯木朗方法打印
//..........................
report = commonReport.GetReportByDataset("25", ds, 1);
commonReport.PrintReport2(report.SaveToString(), commonReport.dsGetReportData.Copy(), Userinfo);
ExtAspNet.PageContext.RegisterStartupScript(string.Format(" PrintReport(\'{0}\',\'{1}\',\'{2}\');", CommonReport.printer, CommonReport.json, CommonReport.dsjson));
}
//记录日志
JournalLog(ordernums, "打印指引单");
}
/// <summary>
/// 根据选择，加载体检者基本信息
/// </summary>
void InitOrderText(int rowindex)
{
if (gdOrders.SelectedRowIndexArray.Length == 0)//判断是否选中一个体检者
{
return;
}
//初始化客户信息
labInfo.Text = string.Format("[姓名:{0}] [性别:{1}] [年龄:{2}] [婚姻:{3}] [联系方式:{4}] [单位:{5}]",
gdOrders.DataKeys[rowindex][4],
gdOrders.DataKeys[rowindex][5],
WebUI.GetAge(gdOrders.DataKeys[rowindex][6].ToString()),
gdOrders.DataKeys[rowindex][7].ToString() == "1" ? "已婚" : (gdOrders.DataKeys[rowindex][7].ToString() == "0" ? "未婚" : "未知"),
gdOrders.DataKeys[rowindex][8] == null ? "无" : gdOrders.DataKeys[rowindex][8].ToString(),
gdOrders.DataKeys[rowindex][9] == null ? "无" : gdOrders.DataKeys[rowindex][9].ToString()
);
}
//打印条码
protected void btnPrint_Click(object sender, EventArgs e)
{
SetInitlocalsetting(hdMac.Text);//设置打印所需的客户端配置信息
string ordernum = "";
string orderbarcodes = GetSelectBarcode(ref ordernum);
if (orderbarcodes == string.Empty)
{
return;
}
DataTable dtSource = barcodeservice.GetPrintBarcodeData(new Hashtable()
{
{ "ordernum", null }, { "orderbarcode", orderbarcodes }
});
for (int i = 0; i < dtSource.Rows.Count; i++)
{
string testnames = dtSource.Rows[i]["TESTNAMES"].ToString();
dtSource.Rows[i]["AGE"] = WebUI.GetAge(dtSource.Rows[i]["AGE"]);//处理年龄
dtSource.Rows[i]["COLLECTDATE"] = dtSource.Rows[i]["COLLECTDATE"].ToString();
dtSource.Rows[i]["TESTNAMES"] = testnames.TrimEnd(',');
dtSource.Rows[i]["COUNT"] = "共" + testnames.TrimEnd(',').Split(',').Length + "项";
}
//修改订单状态为[条码已打印]（已登记的才改）
new OrdersService().EditStatusByOldStatus(new Hashtable()
{
{ "ordernum", ordernum }, { "status", (int)ParamStatus.OrdersStatus.BarCodePrint }, { "oldstatus", (int)ParamStatus.OrdersStatus.Register },
});
//后续调用柯木朗方法打印
//..........................
commonReport.PrintBarCode(dtSource, Userinfo);
ExtAspNet.PageContext.RegisterStartupScript(string.Format(" PrintBarCode(\'{0}\',\'{1}\');", CommonReport.printer, CommonReport.json));
//记录日志
JournalLog(ordernum, orderbarcodes, "条码补打");
}
protected void gvOrderUser_RowClick(object sender, GridRowClickEventArgs e)
{
highlightRows.Text = "";
txtSearch.Text = orderUserInfo[0].ToString();
//未选择客户提示
if (orderUserInfo == null)
{
MessageBoxShow("请至少选择一位客户！", MessageBoxIcon.Warning);
gvOrderUser.SelectedRowIndexArray = new int[] { e.RowIndex };
return;
}
//初始化客户信息
labInfo.Text = string.Format("[姓名:{0}][性别:{1}][年龄:{2}][身份证号:{3}][单位:{4}]", orderUserInfo[1], orderUserInfo[2], WebUI.GetAge(orderUserInfo[3]), orderUserInfo[4], orderUserInfo[5]);
//科室检查结果列表
List <Ordertest> tempOrderTestLst = OrderTestData(orderUserInfo[0].ToString()).ToList <Ordertest>();
gvOrderTest.DataSource = tempOrderTestLst;
gvOrderTest.DataBind();
//判断是否已审核，如果审核，检查结果、科室小结、诊断建议不能修改
if (orderUserInfo[7].ToString() == ((int)ParamStatus.Orderlabdepstatus.Audited).ToString())
{
//检查结果
txtTestResult.Enabled = false;
chkIsexception.Enabled = false;
btnTestResult.Hidden = true;
btnResultSelect.Hidden = true;
//科室小结
txtOrderLabdeptResult.Enabled = false;
btnSaveOrderLabdeptResult.Hidden = true;
//诊断建议
txtEditSuggestion.Enabled = false;
btnOrderdiagnosisModel.Hidden = true;
btnSaveOrderdiagnosis.Hidden = true;
}
else
{
txtTestResult.Enabled = true;
chkIsexception.Enabled = true;
btnTestResult.Hidden = false;
btnResultSelect.Hidden = false;
txtOrderLabdeptResult.Enabled = true;
btnSaveOrderLabdeptResult.Hidden = false;
txtEditSuggestion.Enabled = true;
btnOrderdiagnosisModel.Hidden = false;
btnSaveOrderdiagnosis.Hidden = false;
}
//绑定科室小结列表
gvOrderLabdeptResult.DataSource = OrderlabdeptresultData(orderUserInfo[0].ToString());
gvOrderLabdeptResult.DataBind();
//绑定诊断建议列表
gvSuggestion.DataSource = OrderdiagnosisData(orderUserInfo[0].ToString());
gvSuggestion.DataBind();
//清空编辑区先前选择的结果、科室小结、诊断建议
txtEditSuggestion.Text = "";
txtOrderLabdeptResult.Text = "";
txtTestResult.Text = "";
chkIsexception.Checked = false;
}