private DataTable ExportDataTable(string largeItemRdn, DateTime beginDate, DateTime endDate, string sqlWhere)
{
string sql = "select genTable.sortID,t2.* from " +
"(select t1.smallItemName,SUM(case0)*1.0 'case0',SUM(case1)*1.0 'case1',SUM(case2)*1.0 'case2',SUM(case3)*1.0 'case3',SUM(case4)*1.0 'case4' from " +
"(select smallItemName, " +
"case when result='-1' then count(*) else 0 end 'case0', " +
"case when result='10' then count(*) else 0 end 'case1', " +
"case when result='7' then count(*) else 0 end 'case2', " +
"case when result='5' then count(*) else 0 end 'case3', " +
"case when result='0' then count(*) else 0 end 'case4', " +
"result " +
"from dbo.JCI_detailInfo detailInfo,dbo.JCI_patient_brifeInfo brifeInfo " +
"where typefrom='patient' and largeItemRdn='" + largeItemRdn + "' and brifeInfo.rdn = detailInfo.applyRdn ";
if (sqlWhere != null && sqlWhere != "")
{
sql = sql + sqlWhere + " ";
}
sql = sql +
"and brifeInfo.regDept>'" + beginDate.ToString("yyyy-MM-dd") + "' and brifeInfo.regDept<'" + endDate.ToString("yyyy-MM-dd") + "' " +
"group by smallItemName,result) t1 " +
"group by smallItemName ) t2 " +
"left join dbo.JCI_generateTable genTable on genTable.smallItemName=t2.smallItemName " +
"order by genTable.sortID ASC ";
SqlConnect conn = new SqlConnect();
DataTable dt = conn.ExcuteSelect(sql);
return(dt);
//return null;
}
public void getBrifeInfo(string dept, string date1, string date2, GridView gv)
{
date1 = "2010-04-01"; date2 = "2010-04-30";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select * from JCI_brifeInfo where docdept='" + dept + "'");
sb.Append(" and convert(nvarchar(10),fillindate,120)>='" + date1 + "' and convert(nvarchar(10),fillindate,120)<='" + date2 + "'");
SqlConnect conn = new SqlConnect();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
dt2.Columns.Add("编号");
dt2.Columns.Add("attending/fellow");
dt2.Columns.Add("病历号/姓名");
dt2.Columns.Add("分数");
dt1 = conn.ExcuteSelect(sb.ToString());
for (int i = 0; i < dt1.Rows.Count; i++)
{
string[] o = new string[4];
o[0] = (i + 1).ToString();
for (int j = 4; j < 9; j++)
{
if (dt1.Rows[i][j].ToString() != "")
{
o[1] += dt1.Rows[i][j].ToString() + ",";
}
}
o[1] = o[1].Substring(0, o[1].Length - 1);
o[1] += "/" + dt1.Rows[i]["fellows"].ToString();//加上fellow
o[2] = dt1.Rows[i]["mrn"].ToString() + "/" + dt1.Rows[i]["pName"].ToString();
o[3] = dt1.Rows[i]["tableScore"].ToString();
dt2.Rows.Add(o);
}
gv.DataSource = dt2;
gv.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
//if (Request.QueryString["id"] == null) Response.Redirect("../Err/nonePage.aspx");
//if (Session["power"] == null) Response.Redirect("../Default.aspx");
//if (!srrshPage.Level2(Session["power"].ToString())) Response.Redirect("../Err/powerNeed.aspx");//没权限
//setAutoComplete();
//commonHis ch = new commonHis();
//ddldept.DataSource = ch.getDeptList("*");
//ddldept.DataTextField="deptName";
//ddldept.DataValueField = "deptName";
//ddldept.DataBind();
string sql = "select largeItemRdn,largeItemName,smallItemRdn,smallItemName,sItemValue,sItemType from JCI_generateTable where tableRdn=" + Request.QueryString["id"].Split(',')[0].ToString();
DataTable dt = conn.ExcuteSelect(sql);
MediTable mt = new MediTable();
_ddt = dt;
mt.generator(dt, GridView1);
IsDynamicLoadControl = true;
}
public DataTable sDeptView(string deptName, string type)
{
//1：审核 0：未审核 2：全部
string sql = "";
if ("1".Equals(type))
{
sql = "select * from dbo.JCI_acc_brifeInfo where (deleteFlag <>'1' or deleteFlag is null) and isPassed='1' and reportDept='" + deptName + "'";
}
else if ("0".Equals(type))
{
sql = "select * from dbo.JCI_acc_brifeInfo where (deleteFlag <>'1' or deleteFlag is null) and (isPassed='0' or isPassed is null) and reportDept='" + deptName + "'";
}
else if ("2".Equals(type))
{
sql = "select * from dbo.JCI_acc_brifeInfo where (deleteFlag <>'1' or deleteFlag is null) and reportDept='" + deptName + "'";
}
try
{
SqlConnect conn = new SqlConnect();
return(conn.ExcuteSelect(sql));
}
catch (Exception ex)
{
throw;
}
}
private void u_init_grid(string rdn)
{
string sql = "select * from dbo.JCI_detailInfo where applyRdn = " + rdn + " and typefrom='Patient'";
SqlConnect conn = new SqlConnect();
DataTable dt = conn.ExcuteSelect(sql);
GridView1.DataSource = dt;
GridView1.DataBind();
}
public DataSet sDetailView(string id)
{
string sql = "select * from dbo.JCI_acc_brifeInfo where reportId=" + id;
string sql1 = "select * from dbo.JCI_acc_detailInfo where tablerdn=" + id;
try
{
DataSet ds = new DataSet();
SqlConnect conn = new SqlConnect();
ds.Tables.Add(conn.ExcuteSelect(sql));
ds.Tables.Add(conn.ExcuteSelect(sql1));
return(ds);
}
catch (Exception ex)
{
throw;
}
}
public DataTable getShowData(string rdn)
{
try
{
string sql = "select * from dbo.JCI_brifeInfo where rdn=" + rdn;
SqlConnect conn = new SqlConnect();
return(conn.ExcuteSelect(sql));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable sDeptView(string deptName)
{
string sql = "select * from dbo.JCI_acc_brifeInfo where reportDept='" + deptName + "'";
try
{
SqlConnect conn = new SqlConnect();
return(conn.ExcuteSelect(sql));
}
catch (Exception ex)
{
throw;
}
}
public UserPower Login(UserPower u)
{
SqlConnect conn = new SqlConnect();
string sql = "select * from dbo.JCI_newEmp emp where 1=1 and emp.empId='" + u.UserId + "' and emp.deptNum='" + u.UserDept + "' and emp.psw='" + u.Psw + "'";
DataTable dt = conn.ExcuteSelect(sql);
if (dt.Rows.Count > 0)
{
u.Power = GetPower(dt.Rows[0]["power"].ToString());
u.UserDeptName = dt.Rows[0]["deptName"].ToString();
u.UserDept = dt.Rows[0]["deptNum"].ToString();
return(u);
}
return(null);
}
private void u_init_brifeInfo(string rdn)
{
SqlConnect conn = new SqlConnect();
string sql = "select * from dbo.JCI_patient_brifeInfo where rdn=" + rdn;
//if()
UserPower user = Session["user"] as UserPower;
if (user == null)
{
PowerManage();
}
else
{
if (user.IsUser())
{
sql += " and dept='" + user.UserDeptName + "'";
}
}
DataTable dt = conn.ExcuteSelect(sql);
DataRow dr = dt.Rows[0];
tbox_reportDate.Text = dr["regDept"].ToString();
tbox_fillPerson.Text = dr["fillPerson"].ToString();
tbox_once.Text = dr["isFirst"].ToString();
tbox_other1.Text = dr["other1"].ToString();
tbox_personSex.Text = dr["personSex"].ToString();
tbox_regDate.Text = Convert.ToDateTime(dr["regDate"]).ToString("yyy-MM-dd");
tbox_ddl_dept.Text = dr["dept"].ToString();
tbox_ddl_floor.Text = dr["floorName"].ToString();
tbox_job.Text = dr["job"].ToString();
tbox_pay.Text = dr["payType"].ToString();
string promote = dr["promote"].ToString();
string needImprove = dr["needImprove"].ToString();
string[] promotes = promote.Split(';');
string[] needImproves = needImprove.Split(';');
tbox_promote_yl.Text = promotes[0].Split(':')[1];
tbox_promote_hl.Text = promotes[1].Split(':')[1];
tbox_promote_yj.Text = promotes[2].Split(':')[1];
tbox_promote_hq.Text = promotes[3].Split(':')[1];
tbox_promote_zy.Text = promotes[4].Split(':')[1];
tbox_needImprove_yl.Text = needImproves[0].Split(':')[1];
tbox_needImprove_hl.Text = needImproves[1].Split(':')[1];
tbox_needImprove_yj.Text = needImproves[2].Split(':')[1];
tbox_needImprove_hq.Text = needImproves[3].Split(':')[1];
tbox_needImprove_zy.Text = needImproves[4].Split(':')[1];
}
public int getIsPassedCount(string type, string dept, string power)
{
//0：未审核 1：审核
int result = 0;
string sql = "";
switch (type)
{
case "0":
if ("管理员".Equals(power))
{
sql = "select count(*) from dbo.JCI_acc_brifeInfo where (deleteFlag <>'1' or deleteFlag is null) and (ispassed='0' or ispassed is null)";
}
else
{
sql = "select count(*) from dbo.JCI_acc_brifeInfo where (deleteFlag <>'1' or deleteFlag is null) and (ispassed='0' or ispassed is null) and reportDept='" + dept + "'";
}
break;
case "1":
if ("管理员".Equals(power))
{
sql = "select count(*) from dbo.JCI_acc_brifeInfo where (deleteFlag <>'1' or deleteFlag is null) and ispassed='1'";
}
else
{
sql = "select count(*) from dbo.JCI_acc_brifeInfo where (deleteFlag <>'1' or deleteFlag is null) and ispassed='1' and reportDept='" + dept + "'";
}
break;
default:
break;
}
try
{
SqlConnect conn = new SqlConnect();
DataTable dt = conn.ExcuteSelect(sql);
result = Convert.ToInt16(dt.Rows[0][0]);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
//输入提示
public string[] getDicContent(string keys)
{
string sql = "select top 20 dicItemContent from JCI_Dic where dicItemContent like '%" + keys + "%' or dicItemNickName like '%" + keys + "%'";
SqlConnect conn = new SqlConnect();
DataTable dt = conn.ExcuteSelect(sql);
if (dt.Rows.Count == 0)
{
return(null);
}
string[] content = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
content[i] = dt.Rows[i][0].ToString();
}
return(content);
}
public void getDetailInfo(string dept, string date1, string date2, GridView gv)
{
DataTable returndt, sourcedt;
returndt = new DataTable();
sourcedt = new DataTable();
SqlConnect conn = new SqlConnect();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("select JCI_detailInfo.*,dbo.JCI_brifeInfo.mrn,dbo.JCI_brifeInfo.pName from JCI_detailInfo,JCI_brifeInfo where applyRdn in( ");
sb.Append("select rdn from JCI_brifeInfo where docdept='" + dept + "' and convert(nvarchar(10),fillindate,120)>='" + date1 + "' and convert(nvarchar(10),fillindate,120)<='" + date2 + "'");
sb.Append(") and applyRdn=JCI_brifeInfo.Rdn and result<>'0' order by smallitemrdn asc");
sourcedt = conn.ExcuteSelect(sb.ToString());
int j = 0;
returndt.Columns.Add("类别");
returndt.Columns.Add("项目");
returndt.Columns.Add("病历号");
for (int i = 0; i < sourcedt.Rows.Count; i++)
{
DataRow drNow = sourcedt.Rows[i];
if (i != 0)
{
DataRow drBefore = sourcedt.Rows[i - 1];
if (drNow["smallItemRdn"].ToString() != drBefore["smallItemRdn"].ToString())//新行
{
returndt.Rows.Add(drNow["largeItemName"], drNow["smallItemName"], drNow["mrn"]);
j++;
}
else
{
returndt.Rows[j - 1][2] += "，" + drNow["mrn"].ToString();
}
}
else//第一行
{
returndt.Rows.Add(drNow["largeItemName"], drNow["smallItemName"], drNow["mrn"]);
j++;
}
}
gv.DataSource = returndt;
gv.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
SqlConnect conn = new SqlConnect();
DataTable dt = new DataTable();
accTable at = new accTable();
string tablerdn = "1";
Inital(ref tablerdn);
dt = conn.ExcuteSelect("select * from dbo.JCI_report_mainTable where tableRdn=" + tablerdn);
_dt = dt;
at.generator(dt, GridView1);
IsDynamicLoadControl = true;
}
private void getDocName(string py)
{
SqlConnect conn = new SqlConnect();
string sql = "select top 8 empName from JCI_empTable where empName like '%" + py + "%'";
DataTable dt = conn.ExcuteSelect(sql);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.AppendLine(@"<?xml version='1.0' encoding='UTF-8' ?>");
sb.AppendLine(@"<names>");
foreach (DataRow dr in dt.Rows)
{
if (!"".Equals(dr["empName"]))
{
sb.AppendLine(@"<name>" + dr["empName"].ToString() + "</name>");
}
}
sb.AppendLine(@"</names>");
Response.Charset = "utf-8";
Response.ContentType = "text/xml";
Response.Write(sb.ToString());
}
private void u_init(string sqlWhere)
{
string sql = "select top 1000 * from dbo.JCI_patient_brifeInfo where 1=1 " + sqlWhere + " order by rdn DESC";
SqlConnect conn = new SqlConnect();
DataTable dt = conn.ExcuteSelect(sql);
rpt_patient.DataSource = dt;
rpt_patient.DataBind();
sql = "select code,name from JCI_patient_dic where dicType='科室' order by orderNum ASC ";
conn.DropDownListBind(sql, ddl_dept);
sql = "select code,name from JCI_patient_dic where dicType='楼层' order by orderNum ASC ";
conn.DropDownListBind(sql, ddl_floor);
DataTable dt1 = new DataTable();
dt1.Columns.Add("code");
dt1.Columns.Add("name");
dt1.Rows.Add("医疗", "医疗");
dt1.Rows.Add("护理", "护理");
dt1.Rows.Add("医技", "医技");
dt1.Rows.Add("后勤", "后勤");
dt1.Rows.Add("行政-收费", "行政-收费");
ddl_category1.DataSource = dt1;
ddl_category1.DataValueField = "code";
ddl_category1.DataTextField = "name";
ddl_category1.DataBind();
ddl_category2.DataSource = dt1;
ddl_category2.DataValueField = "code";
ddl_category2.DataTextField = "name";
ddl_category2.DataBind();
//added by Chunhui Chen 2014-05-18
DateTime now = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
tbox_beginDate.Text = now.ToString("yyyy-MM-dd");
tbox_endDate.Text = now.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd");
}
protected void Page_Load(object sender, EventArgs e)
{
//if (Request.QueryString["dept"] == null) return;
//if (Request.QueryString["date"] == null) return;
//if (Session["power"] == null) Response.Redirect("../Default.aspx");
//if (!srrshPage.Level2(Session["power"].ToString())) Response.Redirect("../Err/powerNeed.aspx");//没权限
//string dept = Request.QueryString["dept"].ToString();
//string date = Request.QueryString["date"].ToString();
string dept = "1";
string date = "2010-06-14";
int year, month, days;
year = Convert.ToInt16(date.Split('-')[0]);
month = Convert.ToInt16(date.Split('-')[1]);
days = Convert.ToInt16(date.Split('-')[2]);
DateTime date1 = new DateTime(year, month, 1);
DateTime date2 = new DateTime(year, month, 30);
date1.ToString("yyyy-MM-dd");
SqlConnect conn = new SqlConnect();
//string sql = "select doc1,doc2,doc3,doc4,doc5,fellows,tableScore from brifeInfo where docDept='" + dept + "'";
string sql = "select doc1,doc2,doc3,doc4,doc5,fellows,tableScore from JCI_brifeInfo where docDept='" + dept + "' and convert(varchar(10),fillindate,120)>='" + date1.ToString("yyyy-MM-dd") + "' and convert(nvarchar(10),fillindate,120)<='" + date2.ToString("yyyy-MM-dd") + "'";
DataTable dt = conn.ExcuteSelect(sql);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
System.Text.StringBuilder docs = new System.Text.StringBuilder();
System.Text.StringBuilder score = new System.Text.StringBuilder();
docs.Append("<docs>");
score.Append("<scores>");
sb.Append(@"<?xml version='1.0' encoding='utf-8' ?>");
sb.Append("<datas>");
foreach (DataRow dr in dt.Rows)
{
if (dr[0].ToString() != "")
{
docs.Append(dr[0].ToString());
}
if (dr[1].ToString() != "")
{
docs.Append("," + dr[1].ToString());
}
if (dr[2].ToString() != "")
{
docs.Append("," + dr[2].ToString());
}
if (dr[3].ToString() != "")
{
docs.Append("," + dr[3].ToString());
}
if (dr[4].ToString() != "")
{
docs.Append("," + dr[4].ToString());
}
if (dr[5].ToString() != "")
{
docs.Append("/" + dr[5].ToString());
}
docs.Append(";");
if (dr[6].ToString() != "")
{
score.Append(dr[6].ToString());
}
score.Append(";");
}
string getdoc = docs.ToString().Substring(0, docs.Length - 1) + "</docs>";
string getscore = score.ToString().Substring(0, score.Length - 1) + "</scores>";
sb.Append(getdoc + getscore);
sb.Append("</datas>");
Response.Charset = "utf-8";
Response.ContentType = "text/xml";
Response.Write(sb.ToString());
}
private string ReportHandler(string largeItemRdn, DateTime beginDate, DateTime endDate, ref DataTable dt1, string sqlWhere)
{
string sql = "select Count(*) from dbo.JCI_patient_brifeInfo brifeInfo " +
"where brifeInfo.regDept>'" + beginDate.ToString("yyyy-MM-dd") + "' and brifeInfo.regDept<'" + endDate.ToString("yyyy-MM-dd") + "' ";
if (sqlWhere != null && "" != sqlWhere)
{
sql = sql + sqlWhere;
}
SqlConnect conn = new SqlConnect();
DataTable dt = conn.ExcuteSelect(sql);
int iCount = 0;
if (dt.Rows.Count == 0)
{
return("there is no record to report. - 1");
}
iCount = Convert.ToInt32(dt.Rows[0][0]);
if (iCount == 0)
{
return("there is no record to report. - 2");
}
dt = ExportDataTable(largeItemRdn, beginDate, endDate, sqlWhere);
if (dt.Rows.Count == 0)
{
return("there is no record to report. - 3");
}
dt.Columns.Add("rate", typeof(double));
int case0Sum = 0, case1Sum = 0, case2Sum = 0, case3Sum = 0, case4Sum = 0;
foreach (DataRow dr in dt.Rows)
{
//case0Sum = case1Sum = case2Sum = case3Sum = case4Sum = 0;
double sum = CalculateSatisfyRate(dr);
case0Sum = case0Sum + Convert.ToInt32(dr["case0"]);
case1Sum = case1Sum + Convert.ToInt32(dr["case1"]);
case2Sum = case2Sum + Convert.ToInt32(dr["case2"]);
case3Sum = case3Sum + Convert.ToInt32(dr["case3"]);
case4Sum = case4Sum + Convert.ToInt32(dr["case4"]);
double rate = sum / (Convert.ToInt32(dr["case1"]) + Convert.ToInt32(dr["case2"]) + Convert.ToInt32(dr["case3"]) + Convert.ToInt32(dr["case4"])) / 10;
dr["rate"] = rate;
}
double rateSum = 0d;
if (!(case3Sum == 0 && case2Sum == 0 && case3Sum == 0))
{
rateSum = (case1Sum * 10 + case2Sum * 7 + case3Sum * 5) * 1.0 / (case1Sum * 10 + case2Sum * 10 + case3Sum * 10 + case4Sum * 10);
}
//人次合计
dt.Rows.Add(1001, "人次合计", case0Sum, case1Sum, case2Sum, case3Sum, case4Sum, rateSum);
int iPeopleSum = case0Sum + case1Sum + case2Sum + case3Sum + case4Sum;
if (iPeopleSum == 0)
{
dt.Rows.Add(1002, "平均人次率", 0, 0, 0, 0, 0, 0);
}
else
{ //平均人次率
//double test = case2Sum * 1.0 / iPeopleSum;
dt.Rows.Add(1002, "平均人次率", case0Sum * 1.0 / iPeopleSum, case1Sum * 1.0 / iPeopleSum, case2Sum * 1.0 / iPeopleSum, case3Sum * 1.0 / iPeopleSum, case4Sum * 1.0 / iPeopleSum, 1);
//dt.Rows.Add(1002, "平均人次率", 0.1, 0.1, 0.1, 0.1, 0.1, 1);
}
dt1 = dt;
return("ok");
}
private void ExportAllData(HSSFWorkbook hssfworkbook, DateTime beginDate, DateTime endDate)
{
SqlConnect conn = new SqlConnect();
string sql = "select * from dbo.JCI_patient_brifeInfo brifeInfo " +
"where brifeInfo.regDept>'" + beginDate.ToString("yyyy-MM-dd") + "' and brifeInfo.regDept<'" + endDate.ToString("yyyy-MM-dd") + "' " +
"order by rdn asc";
DataTable dt = conn.ExcuteSelect(sql);
ISheet sheet = hssfworkbook.GetSheetAt(0);
IRow row;
ICell cell;
int iRow = 2;
int iCell = 0;
foreach (DataRow dr in dt.Rows)
{
iCell = 0;
#region normal information
row = sheet.CreateRow(iRow++);
cell = row.CreateCell(iCell++);
cell.SetCellValue(dr["rdn"].ToString());
cell = row.CreateCell(iCell++);
cell.SetCellValue(Convert.ToDateTime(dr["other2"]).ToString("yyyyMMdd"));
cell = row.CreateCell(iCell++);
cell.SetCellValue(dr["fillPerson"].ToString());
cell = row.CreateCell(iCell++);
cell.SetCellValue(dr["isFirst"].ToString());
cell = row.CreateCell(iCell++);
cell.SetCellValue(dr["other1"].ToString());
cell = row.CreateCell(iCell++);
cell.SetCellValue(dr["personSex"].ToString());
cell = row.CreateCell(iCell++);
cell.SetCellValue(dr["regDate"].ToString());
cell = row.CreateCell(iCell++);
cell.SetCellValue(dr["job"].ToString());
cell = row.CreateCell(iCell++);
cell.SetCellValue(dr["payType"].ToString());
#endregion
#region detail information
sql = "select * from dbo.JCI_detailInfo where typefrom='Patient' and applyRdn=" + dr["rdn"].ToString();
DataTable dt1 = conn.ExcuteSelect(sql);
foreach (DataRow dr1 in dt1.Rows)
{
cell = row.CreateCell(iCell++);
string result = dr1["result"].ToString();
string cellValue = "";
switch (result)
{
case "-1":
cellValue = "无此需求";
break;
case "-2":
cellValue = "缺项";
break;
case "10":
cellValue = "满意";
break;
case "7":
cellValue = "比较满意";
break;
case "5":
cellValue = "一般";
break;
case "0":
cellValue = "不满意";
break;
default:
cellValue = "缺项";
break;
}
cell.SetCellValue(cellValue);
//cell.SetCellValue(dr["payType"].ToString());
}
#endregion
#region promote & improve
string promote = dr["promote"].ToString();
string needImprove = dr["needImprove"].ToString();
string[] promotes = promote.Split(';');
string[] needImproves = needImprove.Split(';');
cell = row.CreateCell(iCell++);
cell.SetCellValue(promotes[0].Split(':')[1]);
cell = row.CreateCell(iCell++);
cell.SetCellValue(needImproves[0].Split(':')[1]);
cell = row.CreateCell(iCell++);
cell.SetCellValue(promotes[1].Split(':')[1]);
cell = row.CreateCell(iCell++);
cell.SetCellValue(needImproves[1].Split(':')[1]);
cell = row.CreateCell(iCell++);
cell.SetCellValue(promotes[2].Split(':')[1]);
cell = row.CreateCell(iCell++);
cell.SetCellValue(needImproves[2].Split(':')[1]);
cell = row.CreateCell(iCell++);
cell.SetCellValue(promotes[3].Split(':')[1]);
cell = row.CreateCell(iCell++);
cell.SetCellValue(needImproves[3].Split(':')[1]);
#endregion
}
}
private void ExportAllHead(HSSFWorkbook hssfworkbook)
{
ISheet sheet = hssfworkbook.GetSheetAt(0);
IRow row;
ICell cell;
row = sheet.CreateRow(0);
int iCell = 0;
#region
//cell = row.CreateCell(iCell++, CellType.String);
//cell.SetCellValue("一般信息");
CellRangeAddress cellrange = new CellRangeAddress(0, 0, 0, 8);
MergeAreaBorder(hssfworkbook, sheet, cellrange, "一般信息");
sheet.AddMergedRegion(cellrange);
//cell = row.CreateCell(iCell++, CellType.String);
//cell.SetCellValue("医疗工作");
cellrange = new CellRangeAddress(0, 0, 9, 18);
MergeAreaBorder(hssfworkbook, sheet, cellrange, "医疗工作");
sheet.AddMergedRegion(cellrange);
//cell = row.CreateCell(iCell++, CellType.String);
//cell.SetCellValue("护理工作");
//cellrange = new CellRangeAddress(0, 0, 19, 31);
//sheet.AddMergedRegion(cellrange);
cellrange = new CellRangeAddress(0, 0, 19, 31);
MergeAreaBorder(hssfworkbook, sheet, cellrange, "护理工作");
sheet.AddMergedRegion(cellrange);
//cell = row.CreateCell(iCell++, CellType.String);
//cell.SetCellValue("医技工作");
//cellrange = new CellRangeAddress(0, 0, 32, 37);
//sheet.AddMergedRegion(cellrange);
cellrange = new CellRangeAddress(0, 0, 32, 37);
MergeAreaBorder(hssfworkbook, sheet, cellrange, "医技工作");
sheet.AddMergedRegion(cellrange);
//cell = row.CreateCell(iCell++, CellType.String);
//cell.SetCellValue("后勤工作");
//cellrange = new CellRangeAddress(0, 0, 38, 44);
//sheet.AddMergedRegion(cellrange);
cellrange = new CellRangeAddress(0, 0, 38, 44);
MergeAreaBorder(hssfworkbook, sheet, cellrange, "后勤工作");
sheet.AddMergedRegion(cellrange);
//cell = row.CreateCell(iCell++, CellType.String);
//cell.SetCellValue("住院费用相关内容");
//cellrange = new CellRangeAddress(0, 0, 45, 46);
//sheet.AddMergedRegion(cellrange);
cellrange = new CellRangeAddress(0, 0, 45, 46);
MergeAreaBorder(hssfworkbook, sheet, cellrange, "住院费用相关内容");
sheet.AddMergedRegion(cellrange);
//cell = row.CreateCell(iCell++, CellType.String);
//cell.SetCellValue("满意以及意见或建议");
//cellrange = new CellRangeAddress(0, 0, 47, 55);
//sheet.AddMergedRegion(cellrange);
cellrange = new CellRangeAddress(0, 0, 47, 55);
MergeAreaBorder(hssfworkbook, sheet, cellrange, "满意以及意见或建议");
sheet.AddMergedRegion(cellrange);
#endregion
#region normal head
row = sheet.CreateRow(1);
iCell = 0;
cell = row.CreateCell(iCell++);
cell.SetCellValue("编号");
cell = row.CreateCell(iCell++);
cell.SetCellValue("录入时间");
cell = row.CreateCell(iCell++);
cell.SetCellValue("填表人");
cell = row.CreateCell(iCell++);
cell.SetCellValue("是否第一次住院");
cell = row.CreateCell(iCell++);
cell.SetCellValue("住院情况");
cell = row.CreateCell(iCell++);
cell.SetCellValue("性别");
cell = row.CreateCell(iCell++);
cell.SetCellValue("入院时间");
cell = row.CreateCell(iCell++);
cell.SetCellValue("职业");
cell = row.CreateCell(iCell++);
cell.SetCellValue("付费方式");
#endregion
#region DataBase Head
SqlConnect conn = new SqlConnect();
string sql = "select smallItemName from dbo.JCI_generateTable where tablerdn=12 order by largeItemRdn ASC, sortID ASC ";
DataTable dt = conn.ExcuteSelect(sql);
foreach (DataRow dr in dt.Rows)
{
cell = row.CreateCell(iCell++, CellType.String);
cell.SetCellValue(dr["smallItemName"].ToString());
}
#endregion
#region promote & needImprove
cell = row.CreateCell(iCell++);
cell.SetCellValue("住院期间您最满意的人和事（医疗工作）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("本院需要改进的方面（医疗工作）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("住院期间您最满意的人和事（护理工作）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("本院需要改进的方面（护理工作）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("住院期间您最满意的人和事（医技工作）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("本院需要改进的方面（医技工作）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("住院期间您最满意的人和事（后勤工作）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("本院需要改进的方面（后勤工作）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("住院期间您最满意的人和事（住院费用相关）");
cell = row.CreateCell(iCell++);
cell.SetCellValue("本院需要改进的方面（住院费用相关）");
#endregion
}
private DataTable ExportAdviceTable(PatientAdviceDept adviceDept, DateTime beginDate, DateTime endDate, string sqlWhere)
{
string sql = "select rdn,dept,floorName,promote,needImprove from dbo.JCI_patient_brifeInfo brifeInfo " +
"where brifeInfo.regDept>'" + beginDate.ToString("yyyy-MM-dd") + "' and brifeInfo.regDept<'" + endDate.ToString("yyyy-MM-dd") + "' ";
if (sqlWhere != null && "" != sqlWhere)
{
sql = sql + sqlWhere;
}
SqlConnect conn = new SqlConnect();
DataTable dt = conn.ExcuteSelect(sql);
DataTable dt1 = new DataTable();
dt1.Columns.Add("rdn", typeof(int));
dt1.Columns.Add("dept", typeof(string));
dt1.Columns.Add("floorName", typeof(string));
dt1.Columns.Add("adviceDept", typeof(string));
dt1.Columns.Add("adviceType", typeof(string));
dt1.Columns.Add("adviceContent", typeof(string));
foreach (DataRow dr in dt.Rows)
{
string advicePromote = dr["promote"].ToString();
string adviceNeedImprove = dr["needImprove"].ToString();
string[] advicePromotes = advicePromote.Split(';');
string[] adviceNeedImproves = adviceNeedImprove.Split(';');
if (advicePromotes.Length <= 0 || adviceNeedImproves.Length <= 0)
{
continue;
}
string tmpPromote = "";
string tmpNeedImprove = "";
#region handler
switch (adviceDept)
{
case PatientAdviceDept.YL:
tmpPromote = advicePromotes[0].Split(':')[1];
tmpNeedImprove = adviceNeedImproves[0].Split(':')[1];
break;
case PatientAdviceDept.HL:
tmpPromote = advicePromotes[1].Split(':')[1];
tmpNeedImprove = adviceNeedImproves[1].Split(':')[1];
break;
case PatientAdviceDept.YJ:
tmpPromote = advicePromotes[2].Split(':')[1];
tmpNeedImprove = adviceNeedImproves[2].Split(':')[1];
break;
case PatientAdviceDept.HQ:
tmpPromote = advicePromotes[3].Split(':')[1];
tmpNeedImprove = adviceNeedImproves[3].Split(':')[1];
break;
case PatientAdviceDept.ZY:
tmpPromote = advicePromotes[4].Split(':')[1];
tmpNeedImprove = adviceNeedImproves[4].Split(':')[1];
break;
default:
break;
}
if (!tmpPromote.Equals(""))
{
dt1.Rows.Add(dr["rdn"], dr["dept"], dr["floorName"], adviceDept, "promote", tmpPromote);
}
if (!tmpNeedImprove.Equals(""))
{
dt1.Rows.Add(dr["rdn"], dr["dept"], dr["floorName"], adviceDept, "needImprove", tmpNeedImprove);
}
#endregion
}
return(dt1);
}
