protected void deleteBtn(object sender, CommandEventArgs e) { try { accTable acc = new accTable(); string person = Session["power"].ToString().Split(',')[2]; acc.AccDelete(e.CommandArgument.ToString(), person); string type = "2"; if (null == Request.QueryString["type"]) { type = "2"; } else { type = Request.QueryString["type"].ToString(); } string[] power = Session["power"].ToString().Split(','); string dept = power[1]; accTable ac = new accTable(); DataTable dt = ac.sDeptView(dept, type, "", Session["power"].ToString().Split(',')[3].Split('.')[1]); dt = alertTable(dt); GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected override void LoadViewState(object savedState) { base.LoadViewState(savedState); if (IsDynamicLoadControl) { accTable ac = new accTable(); ac.generator(_dt, GridView1); } }
protected void btsubmit_Click(object sender, EventArgs e) { string stablerdn = "1"; string stablename = "1"; string sreportdept = "1"; string sreportperson = "1"; string spersonphone = "1"; string sreportdate = "2010-1-1"; string soccurtime = "1"; string soweekday = "1"; string spname = "1"; string spage = "1"; string spmrn = "1"; string spssex = "1"; string spoper = "1"; string sptype = "1"; //住院1 门诊2 string sgothrough = "1"; //经过 string smeasure = "1"; //措施 string saddcontent = "1"; string[] info = Request.QueryString["id"].ToString().Split(','); stablerdn = info[0]; stablename = info[1]; sreportdept = hDept.Text; sreportperson = hEmp.Text; spersonphone = hPhone.Text; sreportdate = hoccurDate.Text; soccurtime = hoccurTime.Text; spname = pName.Text; spage = ppage.Text; spmrn = pID.Text; spssex = cbSex1.Checked ? "男" : "女"; spoper = pOper.Text; sptype = hcb1.Checked ? "住院病人" : "门诊病人"; sgothrough = hDescribe.Text; smeasure = hMeasure.Text; saddcontent = addContent.Text; DateTime date = Convert.ToDateTime(sreportdate); accTable ac = new accTable(); soweekday = ac.setWeekday(date);//星期 if ("ok" == ac.saveBrifeInfo(stablerdn, stablename, sreportdept, sreportperson, spersonphone, sreportdate, soccurtime, soweekday, spname, spage, spmrn, spssex, spoper, sptype, sgothrough, smeasure, saddcontent, GridView1)) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('上报成功!');window.location='../tableList.aspx';</script>"); } }
protected void btsubmit_Click(object sender, EventArgs e) { if (Request.QueryString["id"] == null || null == Session["power"]) { Response.Write("你还没有登录!"); } string[] power = Session["power"].ToString().Split(','); accTable ac = new accTable(); string person = power[2]; string acDate = DateTime.Now.ToShortDateString(); string reportId = Request.QueryString["id"].ToString(); if (ac.accept(reportId, person, acDate)) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "javascript", "<script>alert('审核成功!');window.location='http://localhost/jci/tableList.aspx';</script>"); } }
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; }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (Request.QueryString["id"] == null) { Response.Redirect("../../Err/nonePage.aspx"); } string tid = Request.QueryString["id"].ToString(); accTable ac = new accTable(); DataSet ds = ac.sDetailView(tid); init(ds.Tables[0]); ac.reGenerator(ds.Tables[1], GridView1); }
private void u_init() { string[] power = Session["power"].ToString().Split(','); string dept = power[1]; string pow = power[3].Split('.')[1]; try { accTable acc = new accTable(); //0:未审核 1:已审核 int notPass = acc.getIsPassedCount("0", dept, pow); int isPass = acc.getIsPassedCount("1", dept, pow); LblisPass.Text = "(" + isPass.ToString() + ")"; LblnotPass.Text = "(" + notPass.ToString() + ")"; } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (null == Session["power"]) { Response.Redirect("../../Err/Err.aspx"); } if (!srrshPage.Level2(Session["power"].ToString())) { Response.Redirect("../../Err/powerNeed.aspx"); } //0:未审核 1:审核 2:全部 type属性说明 string type = "2"; if (null == Request.QueryString["type"]) { type = "2"; } else { type = Request.QueryString["type"].ToString(); } string[] power = Session["power"].ToString().Split(','); string dept = power[1]; accTable ac = new accTable(); DataTable dt = ac.sDeptView(dept, type, "", Session["power"].ToString().Split(',')[3].Split('.')[1]); dt = alertTable(dt); GridView1.DataSource = dt; GridView1.DataBind(); u_init(); }
protected void Button1_Click(object sender, EventArgs e) { try { string type = "2"; string strWhere = ""; if (null == Request.QueryString["type"]) { type = "2"; } else { type = Request.QueryString["type"].ToString(); } string[] power = Session["power"].ToString().Split(','); string dept = power[1]; string pow = Session["power"].ToString().Split(',')[3].Split('.')[1]; if (!("".Equals(tbDate1.Text.Trim()) || "".Equals(tbDate2.Text.Trim()))) { strWhere = " and reportdate>='" + tbDate1.Text + "' and reportdate<='" + tbDate2.Text + "' "; } if (!typeList.SelectedValue.Equals("-99")) { strWhere += " and tableRdn=" + typeList.SelectedValue; } accTable ac = new accTable(); DataTable dt = ac.sDeptView(dept, type, strWhere, pow); dt = alertTable(dt); GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception ex) { Response.Write(ex.ToString()); } }