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