protected void btndelinfo_Click(object sender, EventArgs e) { HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); String[] v_uids = this.txtuids.Value.Split(','); for(var i=0;i<v_uids.Length;i++) { if (v_uids[i] != "") { //this.Response.Write("<script>alert('aaa')</script>"); //判断是否有人员 DataTable dt_dept = Hyoa_dept.Getdept(v_uids[i]); DataTable dt_user = Hyoa_user.Getusersbydeptid(v_uids[i]); if (dt_user.Rows.Count > 0) { Response.Write("<script>alert('" + dt_dept.Rows[0]["hy_deptname"].ToString() + "下存在人员,不能进行删除!');</script>"); return; } //判断是否有子部门 DataTable dt_subdept = Hyoa_dept.GetSubDepts(v_uids[i]); if (dt_subdept.Rows.Count > 0) { Response.Write("<script>alert('" + dt_dept.Rows[0]["hy_deptname"].ToString() + "下存在子部门,不能进行删除!');</script>"); return; } //写删除部门系统日志start HyoaClass.Hyoa_log Hyoa_log = new HyoaClass.Hyoa_log(); Hyoa_log.ID = System.Guid.NewGuid().ToString(); Hyoa_log.hy_createtime = System.DateTime.Now.ToString(); string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } Hyoa_log.hy_oppip = userip; Hyoa_log.hy_opptype = "删除"; Hyoa_log.hy_oppcontent = "删除部门:" + dt_dept.Rows[0]["hy_deptname"].ToString(); Hyoa_log.hy_oppuserid = this.Session["hyuid"].ToString(); Hyoa_log.hy_oppusername = this.Session["hyuname"].ToString(); Hyoa_log.Insert(); Hyoa_dept.hy_deptid = v_uids[i]; Hyoa_dept.Delete(); } } this.txtuids.Value = ""; //DataPlay(1); DataPlay(System.Int32.Parse(this.curpage.Text)); }
//根据部门id得到所有的部门名称(包括上级的部门名称) public string GetAllDeptNameByDeptId(string pi_deptid) { string ls_deptname=""; HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); if (pi_deptid.Length > 3) { int m = pi_deptid.Length / 3; string ls_deptid=""; for (int i = 0; i < m; i++) { ls_deptid = pi_deptid.Substring(0, 3 + (i * 3)); DataTable dt = Hyoa_dept.Getdept(ls_deptid); if (dt.Rows.Count > 0) { if (ls_deptname == "") ls_deptname = dt.Rows[0]["hy_deptname"].ToString(); else ls_deptname += "[" + dt.Rows[0]["hy_deptname"].ToString()+"]"; } } } return ls_deptname; }
private void DataPlay() { if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 //判断当前用户是否有保存的权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9990", this.Session["hyuid"].ToString())) { this.btn_submit.Visible = true; //保存 } else { this.btn_submit.Visible = false; //保存 } //新文档 if (this.Request.QueryString["op"] == "add") { //对部门ID处理开始start HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); DataTable dt; string lsdeptid; lsdeptid = ""; //this.Response.Write("<script>alert('" + this.Request.QueryString["deptid"] + "')</script>"); if (this.Request.QueryString["deptid"] == "") { //部门ID为空,说明是第一级部门 dt = Hyoa_dept.GetFirstdeptsOrderByDeptid(); if (dt.Rows.Count > 0) { //判断当前部门是不是有数据的 lsdeptid = (System.Int32.Parse(dt.Rows[0]["hy_deptid"].ToString()) + 1).ToString(); if (lsdeptid.Length == 1) { this.hy_deptid.Text = "00" + lsdeptid; } else if (lsdeptid.Length == 2) { this.hy_deptid.Text = "0" + lsdeptid; } else { this.hy_deptid.Text = lsdeptid; } } else { this.hy_deptid.Text = "001"; } } else { //部门ID不为空,说明不是第一级部门 dt = Hyoa_dept.GetSubDeptsOrderByDeptid(this.Request.QueryString["deptid"].ToString()); if (dt.Rows.Count > 0) { //判断当前部门是不是有数据的 lsdeptid = (long.Parse(dt.Rows[0]["hy_deptid"].ToString()) + 1).ToString(); this.hy_deptid.Text = this.Request.QueryString["deptid"].ToString() + lsdeptid.Substring(lsdeptid.Length - 3, 3).ToString(); } else { this.hy_deptid.Text = this.Request.QueryString["deptid"].ToString() + "001"; } } //对部门ID处理结束end this.hy_isenabled.Items.Insert(0, "是"); this.hy_isenabled.Items.Insert(1, "否"); } //旧文档 if (this.Request.QueryString["op"] == "modify") { this.txtdocid.Value = this.Request.QueryString["docid"].ToString(); HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); DataTable dt = Hyoa_dept.Getdept(this.txtdocid.Value); if (dt.Rows.Count > 0) { this.hy_deptid.Text = dt.Rows[0]["hy_deptid"].ToString(); this.hy_deptname.Text = dt.Rows[0]["hy_deptname"].ToString(); this.hy_deptsort.Text = dt.Rows[0]["hy_deptsort"].ToString(); //this.Response.Write("<script>alert('" + dt.Rows[0]["hy_isenabled"].ToString() + "')</script>"); this.hy_isenabled.Items.Insert(0, "是"); this.hy_isenabled.Items.Insert(1, "否"); if (dt.Rows[0]["hy_isenabled"].ToString() == "是") this.hy_isenabled.SelectedIndex = 0; else this.hy_isenabled.SelectedIndex = 1; } dt.Clear(); } } }
private void DataPlay() { if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 //判断当前用户是否有保存的权限 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { this.btn_submit.Visible = true; //保存 } else { this.btn_submit.Visible = false; //保存 } //新文档 if (this.Request.QueryString["op"] == "add") { if (this.hy_deptid.Text != "") { //根据部门ID得到部门名称 HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); DataTable dtdept = Hyoa_dept.Getdept(this.hy_deptid.Text); if (dtdept.Rows.Count > 0) this.hy_deptname.Text = dtdept.Rows[0]["hy_deptname"].ToString(); this.ddlifleader.Items.Insert(0, "否"); this.ddlifleader.Items.Insert(1, "是"); this.ddlisenabled.Items.Insert(0, "是"); this.ddlisenabled.Items.Insert(1, "否"); this.ddlxb.Items.Insert(0, "--请选择--"); this.ddlxb.Items.Insert(1, "男"); this.ddlxb.Items.Insert(2, "女"); dtdept.Clear(); } } //旧文档 if (this.Request.QueryString["op"] == "modify") { if (this.Request.QueryString["userid"] != null) { this.ddlifleader.Items.Insert(0, "否"); this.ddlifleader.Items.Insert(1, "是"); this.ddlisenabled.Items.Insert(0, "是"); this.ddlisenabled.Items.Insert(1, "否"); this.ddlxb.Items.Insert(0, "--请选择--"); this.ddlxb.Items.Insert(1, "男"); this.ddlxb.Items.Insert(2, "女"); //根据用户ID得到信息 this.txtuserid.Text = this.Request.QueryString["userid"].ToString(); HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); HyoaClass.Hyoa_user_detail Hyoa_user_detail = new HyoaClass.Hyoa_user_detail(); DataTable dtuser = Hyoa_user.Getuserallinfo(this.txtuserid.Text); if (dtuser.Rows.Count > 0) { this.txtusername.Value = dtuser.Rows[0]["hy_username"].ToString(); this.hy_deptid.Text = dtuser.Rows[0]["hy_deptid"].ToString(); this.hy_deptname.Text = dtuser.Rows[0]["hy_deptname"].ToString(); this.txtposition.Value = dtuser.Rows[0]["hy_post"].ToString(); if (dtuser.Rows[0]["hy_ifleader"].ToString() == "是") this.ddlifleader.SelectedIndex = 1; else this.ddlifleader.SelectedIndex = 0; this.txtofficetel.Value = dtuser.Rows[0]["hy_officetel"].ToString(); this.txthometel.Value = dtuser.Rows[0]["hy_hometel"].ToString(); this.txtmobile.Value = dtuser.Rows[0]["hy_mobile"].ToString(); this.txtvirtualtel.Value = dtuser.Rows[0]["hy_virtualnumber"].ToString(); this.txtuserno.Value = dtuser.Rows[0]["hy_sort"].ToString(); if (dtuser.Rows[0]["hy_isenabled"].ToString() == "是") this.ddlisenabled.SelectedIndex = 0; else this.ddlisenabled.SelectedIndex = 1; DataTable dtdetail = Hyoa_user_detail.Getuserdetail(this.txtuserid.Text); if (dtdetail.Rows.Count > 0) { this.txtbirthday.Value = System.DateTime.Parse(dtdetail.Rows[0]["hy_birthday"].ToString()).ToString("yyyy-MM-dd"); this.txtfjh.Value = dtdetail.Rows[0]["hy_fjh"].ToString(); this.ddlxb.SelectedValue = dtdetail.Rows[0]["hy_xb"].ToString(); this.txtzzmm.Value = dtdetail.Rows[0]["hy_zzmm"].ToString(); this.txtxl.Value = dtdetail.Rows[0]["hy_xl"].ToString(); this.txtbyyx.Value = dtdetail.Rows[0]["hy_byyx"].ToString(); if (dtdetail.Rows[0]["hy_jdwsj"].ToString() != "" && dtdetail.Rows[0]["hy_jdwsj"].ToString() != null && dtdetail.Rows[0]["hy_jdwsj"].ToString() != "1900-01-01") this.txtjdwsj.Value = System.DateTime.Parse(dtdetail.Rows[0]["hy_jdwsj"].ToString()).ToShortDateString(); this.txtjtzz.Value = dtdetail.Rows[0]["hy_jtzz"].ToString(); this.txtsfzhm.Value = dtdetail.Rows[0]["hy_sfzhm"].ToString(); } if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString())) { } else { this.txtsfzhm.Value = "您无权查看,如有需要请联系管理员!"; } } dtuser.Clear(); this.txtuserid.Enabled = false; } } } }
private void DataPlay() { if (this.Request.QueryString["id"] != null) { this.txtid.Value = this.Request.QueryString["id"].ToString(); } HyoaClass.Hyoa_wjcd Hyoa_wjcd = new HyoaClass.Hyoa_wjcd(); DataTable dt = Hyoa_wjcd.Getdoc(this.txtid.Value); if (dt.Rows.Count > 0) { this.txtdocid.Value = dt.Rows[0]["DOCID"].ToString(); this.txtid.Value = dt.Rows[0]["ID"].ToString(); this.lblhy_fsrid.Text = dt.Rows[0]["hy_fsrid"].ToString(); this.lblhy_fsrname.Text = dt.Rows[0]["hy_fsrname"].ToString(); this.lblhy_datetime.Text = dt.Rows[0]["hy_datetime"].ToString(); this.txthy_jsrname.Text = dt.Rows[0]["hy_jsrname"].ToString(); this.txthy_jsrid.Text = dt.Rows[0]["hy_jsrid"].ToString(); this.txthy_title.Text = dt.Rows[0]["hy_title"].ToString(); this.ddlhy_foldername.Text = dt.Rows[0]["hy_foldername"].ToString(); if (dt.Rows[0]["hy_jzsj"] == System.DBNull.Value) { this.jzsj.Text = ""; } else { if (System.DateTime.Parse(dt.Rows[0]["hy_jzsj"].ToString()).ToShortDateString() == "1900-1-1") { this.jzsj.Text = ""; } else { this.jzsj.Text = System.DateTime.Parse(dt.Rows[0]["hy_jzsj"].ToString()).ToShortDateString(); } } if (dt.Rows[0]["hy_txfs"] == System.DBNull.Value) { this.txfs.Text = ""; } else { this.txfs.Text = dt.Rows[0]["hy_txfs"].ToString(); } //附件 HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt(); DataTable dt_fileatt = Hyoa_fileatt.GetfileattByFatherid(this.txtdocid.Value); if (dt_fileatt.Rows.Count > 0) { string ls_temp = ""; for (var i = 0; i < dt_fileatt.Rows.Count; i++) { string ls_path = dt_fileatt.Rows[i]["hy_filepath"].ToString(); ls_path = ls_path.Replace("+","%2B"); ls_temp += (i + 1).ToString() + "、<a href='/" + ls_path + "' target='_blank'>" + dt_fileatt.Rows[i]["hy_filename"].ToString() + "</a><br />"; } this.lblhy_field2.Text = ls_temp; } this.hy_content1.Text = dt.Rows[0]["hy_body"].ToString(); //显示回复列表 HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //string ls_hfsql = "select * from hyp_gzlxdhf where hy_fsrdocid='" + this.txtdocid.Value + "' "; string ls_jsrsql = "select * from hyp_wjcd where hy_type='收件' and DOCID='" + this.txtdocid.Value + "' order by hy_jsrid asc"; DataTable dt_jsr = Hyoa_global.GetDataTable(ls_jsrsql); if (dt_jsr.Rows.Count > 0) { //输出回复记录 this.lblhf.Text = ""; this.lblhf.Text = "<table width=\"95%\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" class=\"tb1-main\">"; this.lblhf.Text += "<tr><td colspan='7' class='Tdcellright'>回复情况:共" + dt_jsr.Rows.Count + "人</td></tr>"; this.lblhf.Text += "<tr>"; this.lblhf.Text += "<td width='10%' class='Tdcellleft' align='center'>序号</td>"; this.lblhf.Text += "<td width='15%' class='Tdcellleft' align='center'>部门名称</td>"; this.lblhf.Text += "<td width='10%' class='Tdcellleft' align='center'>回复人</td>"; this.lblhf.Text += "<td width='15%' class='Tdcellleft' align='center'>回复时间</td>"; this.lblhf.Text += "<td class='Tdcellleft' align='center'>回复内容</td>"; this.lblhf.Text += "<td width='15%' class='Tdcellleft' align='center'>附件</td>"; this.lblhf.Text += "<td width='10%' class='Tdcellleft' align='center'>上报情况</td>"; this.lblhf.Text += "</tr>"; for (var i = 0; i < dt_jsr.Rows.Count; i++) { string ls_bmmc = ""; string ls_hfr = ""; string ls_hfsj = ""; string ls_hfnr = ""; string ls_fj = ""; string ls_sbqk = ""; if (dt_jsr.Rows[i]["hy_ifyhf"].ToString() == "1") { string ls_hfsql = "select * from hyp_gzlxdhf where hy_fsrdocid='" + this.txtdocid.Value + "' and hy_jsrdocid='" + dt_jsr.Rows[i]["ID"].ToString() + "' "; DataTable dt_hf = Hyoa_global.GetDataTable(ls_hfsql); if (dt_hf.Rows.Count > 0) { ls_bmmc = dt_hf.Rows[0]["hy_deptname"].ToString(); ls_hfr = dt_hf.Rows[0]["hy_username"].ToString(); ls_hfsj = dt_hf.Rows[0]["hy_time"].ToString(); ls_hfnr = dt_hf.Rows[0]["hy_body"].ToString(); //附件 DataTable dt_fileatt2 = Hyoa_fileatt.GetfileattByFatherid(dt_hf.Rows[0]["hy_jsrdocid"].ToString()); if (dt_fileatt2.Rows.Count > 0) { for (var j = 0; j < dt_fileatt2.Rows.Count; j++) { if (ls_fj != "") { ls_fj += "<br />"; } ls_fj += (j + 1).ToString() + "、<a href='/" + dt_fileatt2.Rows[j]["hy_filepath"].ToString() + "' target='_blank'>" + dt_fileatt2.Rows[j]["hy_filename"].ToString() + "</a>"; } } //上报情况 System.TimeSpan ts = System.DateTime.Parse(dt_hf.Rows[0]["hy_time"].ToString()) - System.DateTime.Parse(dt_jsr.Rows[0]["hy_jzsj"].ToString()); int days = ts.Days; if (days > 0) { ls_sbqk = "逾期上报"; } else { ls_sbqk = "按期上报"; } } } else { HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user(); DataTable dt_user = Hyoa_user.Getuserallinfo(dt_jsr.Rows[i]["hy_jsrid"].ToString()); if (dt_user.Rows.Count > 0) { HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept(); DataTable dt_dept = Hyoa_dept.Getdept(dt_user.Rows[0]["hy_deptid"].ToString()); if (dt_dept.Rows.Count > 0) { ls_bmmc = dt_dept.Rows[0]["hy_deptname"].ToString(); } } ls_hfr = dt_jsr.Rows[i]["hy_jsrname"].ToString(); //附件 DataTable dt_fileatt2 = Hyoa_fileatt.GetfileattByFatherid(dt_jsr.Rows[i]["ID"].ToString()); if (dt_fileatt.Rows.Count > 0) { for (var j = 0; j < dt_fileatt2.Rows.Count; j++) { ls_fj += (j + 1).ToString() + "、<a href='/" + dt_fileatt2.Rows[j]["hy_filepath"].ToString() + "' target='_blank'>" + dt_fileatt2.Rows[j]["hy_filename"].ToString() + "</a><br />"; } } //上报情况 ls_sbqk = "未上报"; } this.lblhf.Text += "<tr>"; this.lblhf.Text += "<td width='10%' class='Tdcellright' align='center'>" + (i + 1).ToString() + "</td>"; this.lblhf.Text += "<td width='15%' class='Tdcellright' align='center'>" + ls_bmmc + "</td>"; this.lblhf.Text += "<td width='10%' class='Tdcellright' align='center'>" + ls_hfr + "</td>"; this.lblhf.Text += "<td width='15%' class='Tdcellright' align='center'>" + ls_hfsj + " </td>"; this.lblhf.Text += "<td class='Tdcellright' align='center'>" + ls_hfnr + " </td>"; this.lblhf.Text += "<td width='20%' class='Tdcellright' align='center'>" + ls_fj + " </td>"; this.lblhf.Text += "<td width='10%' class='Tdcellright' align='center'>" + ls_sbqk + "</td>"; this.lblhf.Text += "</tr>"; } this.lblhf.Text += "</table>"; } } }