/// <summary>
/// 加载所有手术状态为“术前、术中、”的申请信息
/// </summary>
/// <param name="m"></param>
/// <param name="n"></param>
private void LoadWaitNurseOpe(int curPage)
{
//每次去查询时，要更新一下记录总数，RecondSum,每一页显示的记录数为，PageSum ,
body = "";
///创建表
//CreateTable();
//创建表头
//insertTitle();
///创建列名
curPage -= 1;
startRecond = curPage * PageSum;
endRecond = startRecond + PageSum;
try
{
//状态vchrOpeStatus 手术间vchrOperatingRoomName 时间BeginTime 姓名vchrPatientName
//手术名称vchrOperationName术者 麻醉者 器械 巡回
string tdRows = "";
for (int i = startRecond; i < endRecond; i++)
{
string tdRow = "<tr>";
#region 内容的着色设置
if (i >= dSum)
{
tdRow += "<td colspan='9'> </td>";
}
else
{
string intApplyID = dts.Rows[i]["OperationApplyId"].ToString();
string OperationRoom = dts.Rows[i]["SqOperationRoom"].ToString();// dts.Rows[i]["SZOperationRoom"].ToString() == "" ? dts.Rows[i]["SqOperationRoom"].ToString() : dts.Rows[i]["SZOperationRoom"].ToString();
string vchrOpeStatus = PublicMethod.GetOpeStatus(dts.Rows[i]);
if (vchrOpeStatus == "")
{
continue;
}
string rowStyle = "";
if (i % 2 == 0)
{
rowStyle = "bgcolor='" + rowEvenBgColor + "' align=left valie=middle style='border-bottom:1px solid #629069;height:50px;font-size:" +
fontSize + ";font-weight:bold; vertical-align: middle;font-family:\"" + fontFamily + "\"; ";
}
else
{
rowStyle = "bgcolor='" + rowOddBgColor + "' align=left valie=middle style='border-bottom:1px solid #629069;height:50px;font-size:" +
fontSize + ";font-weight:bold; vertical-align: middle;font-family:\"" + fontFamily + "\"; ";
}
switch (vchrOpeStatus)
{
case "等待手术":
rowStyle += " color:" + defaultColor + ";'";
break;
case "手术准备":
rowStyle += " color:" + opeBeforColor + ";'"; //2
break;
case "手术进行中":
rowStyle += " color:" + opeInColor + ";'"; //3
break;
case "术后恢复":
rowStyle += " color:" + opeAfterColor + ";'"; //4
break;
case "手术结束转恢复室":
OperationRoom = dts.Rows[i]["PACUBed"].ToString();
rowStyle += " color:" + opeInColor1 + ";'"; //6
break;
case "手术结束安返病房":
rowStyle += " color:" + opeAfterColor1 + ";'"; //57
break;
case "离开恢复室":
OperationRoom = dts.Rows[i]["PACUBed"].ToString();
rowStyle += " color:" + opeAfterColor1 + ";'"; //57
break;
case "手术结束":
rowStyle += " color:" + opeAfterColor1 + ";'"; //57
break;
default:
break;
}
#endregion
//注释时间列改为从床号 LM
//vchrFactBeginTime = dts.Rows[i]["OperationBeginTime"].ToString();// == "" ? dts.Rows[i]["OrderOperationTime"].ToString() : dts.Rows[i]["InRoomTime"].ToString();
//if (vchrFactBeginTime.Trim().ToString() != "")
//{
// vchrFactBeginTime = Convert.ToDateTime(vchrFactBeginTime).ToString("HH:mm");
//}
//else vchrFactBeginTime = "- -";
tdRow += "<td align='center' " + rowStyle + "></td>";
tdRow += "<td align='center' " + rowStyle + ">" + dts.Rows[i]["DepartmentName"] + "</td>";
tdRow += "<td align='center' " + rowStyle + ">" + dts.Rows[i]["Bed"] + "</td>";
string PatientName = "";
if (PatientNames == "")
{
PatientName = dts.Rows[i]["PatientName"].ToString();
}
else
{
string name = dts.Rows[i]["PatientName"].ToString().Length < 2 ? "" : dts.Rows[i]["PatientName"].ToString().Substring(2);
PatientName = dts.Rows[i]["PatientName"].ToString().Substring(0, 1) + PatientNames + name;
}
tdRow += "<td align='center' " + rowStyle + "> " + PatientName + "</td>";
//tdRow += "<td align='center' " + rowStyle + "> " + OperationRoom + "</td>";
//tdRow += "<td align='center' " + rowStyle + "> " + vchrFactBeginTime + " </td>";
tdRow += "<td align='center' " + rowStyle + ">" + vchrOpeStatus + "</td>";
}
tdRow += "</tr>";
tdRows += tdRow;
}
//显示备注等
viewRemark();
body += tdRows;
//插入底部
insertBottom();
}
catch (Exception exp)
{
throw;
}
}
private string LoadWaitNurseOpe(int curPage)
{
htmlbody = "";
//每次去查询时，要更新一下记录总数，RecondSum,每一页显示的记录数为，PageSum ,
body = "";
///创建表
//CreateTable();
//插入表头
//InsertTitle();
///创建列名{ "状态", "手术间","科室", "时间", "姓名", "手术名称", "手术医生", "麻醉医生", "洗手护士", "巡回护士" };
//string[] colsName = { "", "术间", "科室", "姓名", "手术名称", "手术医生", "麻醉医生", "护士", "时间", "状态" };
//string[] colsWidth = { "1%", "5%", "13%", "8%", "19%", "9%", "14%", "14%", "8%", "9%" };
//InsertCols(colsName, colsWidth);
curPage -= 1;
startRecond = curPage * PageSum;
endRecond = startRecond + PageSum;
try
{
//状态vchrOpeStatus 手术间vchrOperatingRoomName 时间BeginTime 姓名vchrPatientName
//手术名称vchrOperationName术者 麻醉者 器械 巡回
string tdRows = "";
for (int i = startRecond; i < endRecond; i++)
{
string tdRow = "<tr>";
if (i >= dSum)
{
tdRow += "<td colspan='9'> </td>";
}
else
{
#region 内容的着色设置
string rowStyle = "";
if (i % 2 == 0)
{
rowStyle = "bgcolor='" + rowEvenBgColor +
"' align=center valie=middle style='border-bottom:1px solid #629069; height:50px; font-size:" +
fontSize + ";font-weight:bold; vertical-align: middle; font-family:\"" + fontFamily + "\"; ";
}
else
{
rowStyle = "bgcolor='" + rowOddBgColor +
"' align=center valie=middle style='border-bottom:1px solid #629069; height:50px; font-size:" +
fontSize + ";font-weight:bold; vertical-align: middle; font-family:\"" + fontFamily + "\"; ";
}
string intApplyID = dts.Rows[i]["OperationApplyId"].ToString();
string vchrOpeStatus = PublicMethod.GetOpeStatus(dts.Rows[i]);
//临时手术状态
if (vchrOpeStatus == "")
{
continue;
}
string opeStatu = "";
string vchrFactBeginTime = "";
vchrFactBeginTime = dts.Rows[i]["OperationBeginTime"].ToString();// == "" ? dts.Rows[i]["OrderOperationTime"].ToString() : dts.Rows[i]["InRoomTime"].ToString();
if (vchrFactBeginTime.Trim().ToString() != "")
{
vchrFactBeginTime = Convert.ToDateTime(vchrFactBeginTime).ToString("HH:mm");
}
else
{
vchrFactBeginTime = "- -";
}
string OperationRoom = dts.Rows[i]["SqOperationRoom"].ToString();// dts.Rows[i]["SZOperationRoom"].ToString() == "" ? dts.Rows[i]["SqOperationRoom"].ToString() : dts.Rows[i]["SZOperationRoom"].ToString();
switch (vchrOpeStatus)
{
case "等待手术":
opeStatu = "等待手术";
rowStyle += " color:" + defaultColor + ";'";
OperationRoom = dts.Rows[i]["SqOperationRoom"].ToString();
break;
case "术前准备":
opeStatu = "术前准备";
rowStyle += " color:" + opeBeforColor + ";'"; //2
OperationRoom = dts.Rows[i]["SqOperationRoom"].ToString();
break;
case "手术进行中":
opeStatu = "手术中";
rowStyle += " color:" + opeInColor + ";'";
OperationRoom = dts.Rows[i]["SZOperationRoom"].ToString();
break;
case "术后恢复":
break;
case "转入复苏室":
opeStatu = "转入复苏室";
OperationRoom = dts.Rows[i]["PACUBed"].ToString();
rowStyle += " color:" + opeInColor1 + ";'"; //6
//OperationRoom = dts.Rows[i]["PACUBed"].ToString();
break;
case "离开手术室":
opeStatu = "手术结束";
rowStyle += " color:" + opeAfterColor + ";'";
OperationRoom = dts.Rows[i]["SZOperationRoom"].ToString();
//OperationRoom = dts.Rows[i]["PACUBed"].ToString();
break;
case "手术拒绝":
opeStatu = "手术拒绝";
rowStyle += " color:#B559F5;'";
break;
default:
break;
}
#endregion
tdRow += "<td align='center' " + rowStyle + "></td>";
tdRow += "<td align='center' " + rowStyle + ">" + OperationRoom + "</td>";
#region 科室和申请科室
string Depatrtment = dts.Rows[i]["DepartmentName"].ToString() == "" ? dts.Rows[i]["ApplyDepartmentName"].ToString() : dts.Rows[i]["DepartmentName"].ToString();
tdRow += "<td align='center'" + rowStyle + ">" + Depatrtment + "</td>";
#endregion
tdRow += "<td align='center' " + rowStyle + ">" + dts.Rows[i]["PatientName"] + "</td>";
string SZOperation = dts.Rows[i]["SZOperation"].ToString() == "" ? dts.Rows[i]["SQOperation"].ToString() : dts.Rows[i]["SZOperation"].ToString();
tdRow += "<td align='center' " + rowStyle + ">" + SZOperation + "</td>";
#region 读取医生的条件
string SZOperationDoctor = dts.Rows[i]["SZOperationDoctor"].ToString() == "" ? dts.Rows[i]["SQOperationDoctor"].ToString() : dts.Rows[i]["SZOperationDoctor"].ToString();
tdRow += "<td align='center' " + rowStyle + ">" + SZOperationDoctor + "</td>";
#endregion
#region 读取麻醉医生2
string SZAnesthesiaDoctor = dts.Rows[i]["SZAnesthesiaDoctor"].ToString() == "" ? dts.Rows[i]["SqAnesthesiaDoctor"].ToString() : dts.Rows[i]["SZAnesthesiaDoctor"].ToString();
SZAnesthesiaDoctor = SZAnesthesiaDoctor == "" ? "- -" : SZAnesthesiaDoctor;
tdRow += "<td align='center' " + rowStyle + ">" + SZAnesthesiaDoctor + "</td>";
#endregion
#region 读取器械护士巡回护士
string SZTourNurse = dts.Rows[i]["SZTourNurse"].ToString() == "" ? dts.Rows[i]["SQTourNurse"].ToString() : dts.Rows[i]["SZTourNurse"].ToString();
string SZInstrumentNurse = dts.Rows[i]["SZInstrumentNurse"].ToString() == "" ? dts.Rows[i]["SQInstrumentNurse"].ToString() : dts.Rows[i]["SZInstrumentNurse"].ToString();
if (SZInstrumentNurse == "")
{
SZInstrumentNurse = "- -";
}
if (SZTourNurse == "")
{
SZTourNurse = "- -";
}
tdRow += "<td align='center' " + rowStyle + ">" + SZInstrumentNurse + "/" + SZTourNurse + "</td>";
#endregion
tdRow += "<td align='center' " + rowStyle + ">" + vchrFactBeginTime + "</td>";
tdRow += "<td align='center' " + rowStyle + ">" + opeStatu + "</td>";
}
tdRow += "</tr>";
tdRows += tdRow;
}
//htmlbody = tdRows == "" ? htmlbody : body.Replace("{rows}", tdRows);
return(tdRows);
}
catch (Exception exp)
{
return("");
throw;
}
}
