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