//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功！";
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dtuser = Hyoa_user.Getuserallinfo(this.txtuserid.Text);
if (dtuser.Rows.Count > 0)
{
for (int i = 0; i < dtuser.Rows.Count; i++)
{
Hyoa_user.id = dtuser.Rows[i]["id"].ToString();
Hyoa_user.hy_loginuid = dtuser.Rows[i]["hy_loginuid"].ToString();
Hyoa_user.hy_userid = dtuser.Rows[i]["hy_userid"].ToString();
Hyoa_user.hy_deptid = dtuser.Rows[i]["hy_deptid"].ToString();
Hyoa_user.hy_username = this.txtusername.Text;
Hyoa_user.hy_post = dtuser.Rows[i]["hy_post"].ToString();
Hyoa_user.hy_ifleader = dtuser.Rows[i]["hy_ifleader"].ToString();
Hyoa_user.hy_officetel = this.txtofficetel.Value;
Hyoa_user.hy_hometel = this.txthometel.Value;
Hyoa_user.hy_mobile = this.txtmobile.Value;
Hyoa_user.hy_virtualnumber = this.txtvirtualtel.Value;
Hyoa_user.hy_sort = float.Parse(dtuser.Rows[i]["hy_sort"].ToString());
Hyoa_user.hy_isenabled = dtuser.Rows[i]["hy_isenabled"].ToString();
Hyoa_user.hy_edittime = System.DateTime.Now.ToString();
Hyoa_user.hy_birthday = dtuser.Rows[i]["hy_birthday"].ToString();
Hyoa_user.hy_ifsrtx = dtuser.Rows[i]["hy_ifsrtx"].ToString();
Hyoa_user.hy_fjh = dtuser.Rows[i]["hy_fjh"].ToString();
Hyoa_user.hy_xb = dtuser.Rows[i]["hy_xb"].ToString();
Hyoa_user.hy_zzmm = dtuser.Rows[i]["hy_zzmm"].ToString();
Hyoa_user.hy_xl = dtuser.Rows[i]["hy_xl"].ToString();
Hyoa_user.hy_byyx = dtuser.Rows[i]["hy_byyx"].ToString();
Hyoa_user.hy_jdwsj = dtuser.Rows[i]["hy_jdwsj"].ToString();
Hyoa_user.hy_jtzz = dtuser.Rows[i]["hy_jtzz"].ToString();
Hyoa_user.hy_sfzhm = dtuser.Rows[i]["hy_sfzhm"].ToString();
Hyoa_user.hy_bz = dtuser.Rows[i]["hy_bz"].ToString();
Hyoa_user.hy_jsids = dtuser.Rows[i]["hy_jsids"].ToString();
Hyoa_user.hy_jsnames = dtuser.Rows[i]["hy_jsnames"].ToString();
Hyoa_user.hy_field1 = dtuser.Rows[i]["hy_field1"].ToString();
Hyoa_user.hy_field2 = dtuser.Rows[i]["hy_field2"].ToString();
Hyoa_user.hy_field3 = dtuser.Rows[i]["hy_field3"].ToString();
Hyoa_user.hy_field4 = dtuser.Rows[i]["hy_field4"].ToString();
Hyoa_user.hy_field5 = dtuser.Rows[i]["hy_field5"].ToString();
Hyoa_user.Update();
}
}
//处理完成后的提示及跳转
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');self.close();</script>");
}
}
private void DataPlay()
{
if (this.Session["hyuid"].ToString() != "")
{
//根据用户ID得到信息
this.txtuserid.Text = this.Session["hyuid"].ToString();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dtuser = Hyoa_user.Getuserallinfo(this.txtuserid.Text);
if (dtuser.Rows.Count > 0)
{
this.txtusername.Text = dtuser.Rows[0]["hy_username"].ToString();
}
dtuser.Clear();
this.txtuserid.Enabled = false;
this.txtusername.Enabled = false;
//读取选择风格数据
HyoaClass.Hyoa_mystyle Hyoa_mystyle = new HyoaClass.Hyoa_mystyle();
DataTable dt = Hyoa_mystyle.Getstylebyuserid(this.txtuserid.Text);
if (dt.Rows.Count > 0)
{
ddlhy_style.SelectedValue = dt.Rows[0]["hy_style"].ToString();
this.txtdocid.Value = dt.Rows[0]["ID"].ToString();
}
}
}
protected void WebPageOpen()
{
string ls_uid = "";
string ls_uname = "";
string ls_deptid = "";
string ls_deptname = "";
string ls_key = "";
string ls_url = "";
string ls_docid = "";
if (this.Request.QueryString["uid"] != null)
ls_uid = this.Request.QueryString["uid"].ToString();
if (this.Request.QueryString["key"] != null)
ls_key = this.Request.QueryString["key"].ToString();
if (this.Request.QueryString["docid"] != null)
ls_docid = this.Request.QueryString["docid"].ToString();
int pos = Request.RawUrl.IndexOf("&redirectto=");
if (pos > 0)
ls_url = this.Request.RawUrl.Substring(pos + 12);
if (ls_key != "cd04fa144ec48507")
Response.Write("<script language=javascript>alert('非常抱歉，您的访问地址有误，请联系管理员！');self.close();</script>");
//判断该用户是否存在
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt_user = Hyoa_user.Getuserallinfo(ls_uid);
if (dt_user.Rows.Count > 0)
{
ls_uname = dt_user.Rows[0]["hy_username"].ToString();
ls_deptid = dt_user.Rows[0]["hy_deptid"].ToString();
ls_deptname = dt_user.Rows[0]["hy_deptname"].ToString();
}
else
{
Response.Write("<script>alert('未找到该用户信息，请联系管理员！');self.close();</script>");
}
Session["hyuid"] = ls_uid;
Session["hyuname"] = ls_uname;
Session["hydeptid"] = ls_deptid;
Session["hydeptname"] = ls_deptname;
//根据文档ID来判断该文件是否存在，如果存在则跳转到该URL
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt = Hyoa_flowmain.Getflowmain(ls_docid);
if (dt.Rows.Count > 0)
{
this.Response.Redirect(ls_url);
}
else
{
Response.Write("<script>alert('未找到对应的文档，可能文档已被删除，请联系管理员！');window.location='/'</script>");
}
}
public string getusernamebyuserid(string pis_userid)
{
string ls_return = "";
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt = Hyoa_user.Getuserallinfo(pis_userid);
if (dt.Rows.Count > 0)
ls_return = dt.Rows[0]["hy_username"].ToString();
return ls_return;
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (this.txt_username.Value == "")
{
this.RegisterClientScriptBlock("scripterror", "<script language=javascript>alert('请输入用户名！')</script>");
return;
}
if (this.txt_password.Value == "")
{
this.RegisterClientScriptBlock("scripterror", "<script language=javascript>alert('请输入密码！')</script>");
return;
}
String password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(this.txt_password.Value, "MD5");
HyoaClass.Hyoa_user Users = new HyoaClass.Hyoa_user();
if (Users.Login(this.txt_username.Value, password))
{
DataTable dt = Users.Getuserallinfo(this.txt_username.Value);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["hy_isenabled"].ToString() == "否")
{
//账号被禁用了
this.RegisterClientScriptBlock("scripterror", "<script language=javascript>alert('该账号已被禁用，请联系管理员！')</script>");
return;
}
else
{
Session["hyuid"] = this.txt_username.Value;
Session["hyuname"] = dt.Rows[0]["hy_username"].ToString();
Session["hydeptid"] = dt.Rows[0]["hy_deptid"].ToString();
Session["hydeptname"] = dt.Rows[0]["hy_deptname"].ToString();
Session["hypost"] = dt.Rows[0]["hy_post"].ToString(); ;
//得到风格
HyoaClass.Hyoa_mystyle Hyoa_mystyle = new HyoaClass.Hyoa_mystyle();
DataTable dt_mystyle = Hyoa_mystyle.Getstylebyuserid(this.txt_username.Value);
if (dt_mystyle.Rows.Count > 0 && dt_mystyle.Rows[0]["hy_style"].ToString() != "")
Session["mystyle"] = dt_mystyle.Rows[0]["hy_style"].ToString();
else
Session["mystyle"] = "/hyhtml/images/";
this.Response.Redirect(this.lblurl.Text);
}
}
dt.Clear();
}
else
{
this.RegisterClientScriptBlock("scripterror", "<script language=javascript>alert('输入的用户名或者密码不正确！')</script>");
return;
}
}
protected void WebPageOpen()
{
string ls_uid = "";
string ls_pwd = "";
string ls_key = "";
string ls_url = "";
if (this.Request.QueryString["uid"] != null)
ls_uid = this.Request.QueryString["uid"].ToString();
if (this.Request.QueryString["pwd"] != null)
ls_pwd = this.Request.QueryString["pwd"].ToString();
if (this.Request.QueryString["key"] != null)
ls_key = this.Request.QueryString["key"].ToString();
int pos = Request.RawUrl.IndexOf("&redirectto=");
if (pos > 0)
ls_url = this.Request.RawUrl.Substring(pos + 12);
if (ls_key != "cd04fa144ec48507")
Response.Write("<script language=javascript>alert('非常抱歉，您的访问地址有误，请联系管理员！');self.close();</script>");
String password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(ls_pwd, "MD5");
HyoaClass.Hyoa_user Users = new HyoaClass.Hyoa_user();
if (Users.Login(ls_uid, password))
{
DataTable dt = Users.Getuserallinfo(ls_uid);
if (dt.Rows.Count > 0)
{
Session["hyuid"] = ls_uid;
Session["hyuname"] = dt.Rows[0]["hy_username"].ToString();
Session["hydeptid"] = dt.Rows[0]["hy_deptid"].ToString();
Session["hydeptname"] = dt.Rows[0]["hy_deptname"].ToString();
this.Response.Redirect(ls_url);
}
dt.Clear();
}
else
{
this.Response.Redirect("/");
return;
}
}
//protected string IPlimted()
//{
//IP限制
//string lscurip, configip, lsflag;
//lsflag = "0";
//lscurip = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
////return;
//MagicPortalClass.DAO dbconfigip = new MagicPortalClass.DAO();
//DataTable dtconfigip = dbconfigip.GetDataTable("select * from JpConfig where fdtype='ip'");
//configip = dtconfigip.Rows[0]["fdname"].ToString();
//dtconfigip.Clear();
//dbconfigip.Close();
//string[] lvconfigip = configip.Split(',');
//for (var i = 0; i < lvconfigip.Length; i++)
//{
// if (lvconfigip[i].Contains("-") == true)
// {
// string[] lvconfigipsub = lvconfigip[i].Split('-');
// string[] lvconfigipsub1 = lvconfigipsub[0].Split('.');
// string[] lvconfigipsub2 = lvconfigipsub[1].Split('.');
// string[] lvcurip = lscurip.Split('.');
// if (lvcurip[0] == lvconfigipsub1[0] & lvcurip[1] == lvconfigipsub1[1] & lvcurip[2] == lvconfigipsub1[2] & lvcurip[0] == lvconfigipsub2[0] & lvcurip[1] == lvconfigipsub2[1] & lvcurip[2] == lvconfigipsub2[2])
// {
// if ((int.Parse(lvcurip[3]) >= int.Parse(lvconfigipsub1[3]) & int.Parse(lvcurip[3]) <= int.Parse(lvconfigipsub2[3])))
// {
// lsflag = "1";
// break;
// }
// else
// {
// continue;
// }
// }
// else
// {
// continue;
// }
// }
// else
// {
// if (lvconfigip[i] == lscurip)
// {
// lsflag = "1";
// break;
// }
// }
//}
//return lsflag;
////this.aaaa.Value = lscurip;
///////////IP限制结束
//}
protected void btnLogin_Click(object sender, EventArgs e)
{
//if (Session["checkcode"].ToString().Equals(this.txt_checkcode.Value))
//{
String password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(this.txt_password.Value, "MD5");
HyoaClass.Hyoa_user Users = new HyoaClass.Hyoa_user();
//Response.Write("<script>alert('aaaa');</script>");
if (Users.Login(this.txt_username.Value, password))
{
// Response.Write("<script>alert('bbb');</script>");
DataTable dt = Users.Getuserallinfo(this.txt_username.Value);
if (dt.Rows.Count > 0)
{
Session["hyuid"] = this.txt_username.Value;
Session["hyuname"] = dt.Rows[0]["hy_username"].ToString();
Session["hydeptid"] = dt.Rows[0]["hy_deptid"].ToString();
Session["hydeptname"] = dt.Rows[0]["hy_deptname"].ToString();
//登录日志 start
string ls_oppcontent = this.Session["hyuname"].ToString() + "登录";
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 = ls_oppcontent;
Hyoa_log.hy_oppuserid = this.Session["hyuid"].ToString();
Hyoa_log.hy_oppusername = this.Session["hyuname"].ToString();
Hyoa_log.Insert();
//登录日志 end
HyoaClass.Hyoa_license Hyoa_license = new HyoaClass.Hyoa_license();
DataTable dtlicense = Hyoa_license.Getlicensesbybsquseridanddate(this.Session["hyuid"].ToString());
if (dtlicense.Rows.Count > 0)
{
this.rdsqyh.DataSource = dtlicense;
this.rdsqyh.DataTextField = "hy_sqrname";
this.rdsqyh.DataValueField = "hy_sqrid";
this.rdsqyh.DataBind();
this.rdsqyh.Items.Insert(0, new ListItem(this.Session["hyuname"].ToString(), this.Session["hyuid"].ToString()));
this.rdsqyh.SelectedIndex = 0;
this.table3.Visible = true;
}
else
{
this.Response.Redirect(this.lblurl.Text);
}
}
dt.Clear();
}
else
{
this.RegisterClientScriptBlock("scripterror", "<script language=javascript>alert('输入的用户名或者密码不正确！')</script>");
return;
}
}
protected void btnsqlogin_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_user Users = new HyoaClass.Hyoa_user();
DataTable dt = Users.Getuserallinfo(this.rdsqyh.SelectedValue);
if (dt.Rows.Count > 0)
{
Session["hyuid"] = this.rdsqyh.SelectedValue;
Session["hyuname"] = dt.Rows[0]["hy_username"].ToString();
Session["hydeptid"] = dt.Rows[0]["hy_deptid"].ToString();
Session["hydeptname"] = dt.Rows[0]["hy_deptname"].ToString();
this.Response.Redirect(this.lblurl.Text);
}
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 Hy_showgroup(string ls_users)
{
//得到群组名称
HyoaClass.Hyoa_group Hyoa_group = new HyoaClass.Hyoa_group();
HyoaClass.Hyoa_groupuser Hyoa_groupuser = new HyoaClass.Hyoa_groupuser();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt = Hyoa_group.Getgroups();
if (dt.Rows.Count > 0)
{
for (var i = 0; i < dt.Rows.Count; i++)
{
//输出群组名称
Response.Write("<dd class=\"folderClose\">");
Response.Write("<input type=\"checkbox\" name=\"Group" + dt.Rows[i]["hy_groupid"].ToString() + "\" value=\"" + dt.Rows[i]["hy_groupid"].ToString() + "\">");
Response.Write(dt.Rows[i]["hy_groupname"].ToString());
Response.Write("<dl>");
//输出人员
DataTable dtuser = Hyoa_groupuser.Getgroupusersbygroupid(dt.Rows[i]["hy_groupid"].ToString());
if (dtuser.Rows.Count > 0)
{
for (var j = 0; j < dtuser.Rows.Count; j++)
{
DataTable dt_username = Hyoa_user.Getuserallinfo(dtuser.Rows[j]["hy_userid"].ToString());
Response.Write("<dt>");
//判断已选中
if (ls_users.Contains("," + dtuser.Rows[j]["hy_userid"].ToString() + ","))
{
Response.Write("<input type=\"checkbox\" checked=\"checked\" name=\"GroupUser" + dtuser.Rows[j]["hy_userid"].ToString() + "_subuser\" value=\"");
Response.Write(dtuser.Rows[j]["hy_userid"].ToString() + "|" + dt_username.Rows[0]["hy_username"].ToString() + "\" text=\"" + dt_username.Rows[0]["hy_username"].ToString() + "\">");
Response.Write(dt_username.Rows[0]["hy_username"].ToString());
Response.Write("</dt>");
}
else
{
Response.Write("<input type=\"checkbox\" name=\"GroupUser" + dtuser.Rows[j]["hy_userid"].ToString() + "_subuser\" value=\"");
Response.Write(dtuser.Rows[j]["hy_userid"].ToString() + "|" + dt_username.Rows[0]["hy_username"].ToString() + "\" text=\"" + dt_username.Rows[0]["hy_username"].ToString() + "\">");
Response.Write(dt_username.Rows[0]["hy_username"].ToString());
Response.Write("</dt>");
}
}
}
//输出一级部门尾部
Response.Write("</dl>");
Response.Write("</dd>");
}
}
}
private void DataPlay()
{
this.btn_submit.Visible = true; //保存
if (this.Session["hyuid"].ToString() != "")
{
this.ddlifleader.Items.Insert(0, "否");
this.ddlifleader.Items.Insert(1, "是");
this.ddlisenabled.Items.Insert(0, "是");
this.ddlisenabled.Items.Insert(1, "否");
//根据用户ID得到信息
this.txtuserid.Text = this.Session["hyuid"].ToString();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dtuser = Hyoa_user.Getuserallinfo(this.txtuserid.Text);
if (dtuser.Rows.Count > 0)
{
this.txtusername.Text = 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;
}
dtuser.Clear();
this.txtuserid.Enabled = false;
this.hy_deptname.Enabled = false;
this.txtusername.Enabled = false;
}
}
protected void WebPageOpen()
{
string ls_uid = "";
string ls_uname = "";
string ls_deptid = "";
string ls_deptname = "";
string ls_key = "";
string ls_url = "";
string ls_docid = "";
string ls_post = "";
if (this.Request.QueryString["uid"] != null)
ls_uid = this.Request.QueryString["uid"].ToString();
if (this.Request.QueryString["key"] != null)
ls_key = this.Request.QueryString["key"].ToString();
if (this.Request.QueryString["docid"] != null)
ls_docid = this.Request.QueryString["docid"].ToString();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
int pos = Request.RawUrl.IndexOf("&redirectto=");
if (pos > 0)
ls_url = this.Request.RawUrl.Substring(pos + 12) + "&rnd=" + Hyoa_global.GetRandom();
if (ls_key != "cd04fa144ec48507")
Response.Write("<script language=javascript>alert('非常抱歉，您的访问地址有误，请联系管理员！');self.close();</script>");
//判断该用户是否存在
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt_user = Hyoa_user.Getuserallinfo(ls_uid);
if (dt_user.Rows.Count > 0)
{
ls_uname = dt_user.Rows[0]["hy_username"].ToString();
ls_deptid = dt_user.Rows[0]["hy_deptid"].ToString();
ls_deptname = dt_user.Rows[0]["hy_deptname"].ToString();
ls_post = dt_user.Rows[0]["hy_post"].ToString();
}
else
{
Response.Write("<script>alert('未找到该用户信息，请联系管理员！');self.close();</script>");
}
Session["hyuid"] = ls_uid;
Session["hyuname"] = ls_uname;
Session["hydeptid"] = ls_deptid;
Session["hydeptname"] = ls_deptname;
Session["hypost"] = ls_post;
//得到风格
//HyoaClass.Hyoa_mystyle Hyoa_mystyle = new HyoaClass.Hyoa_mystyle();
//DataTable dt_mystyle = Hyoa_mystyle.Getstylebyuserid(ls_uid);
//if (dt_mystyle.Rows.Count > 0 && dt_mystyle.Rows[0]["hy_style"].ToString() != "")
// Session["mystyle"] = dt_mystyle.Rows[0]["hy_style"].ToString();
//else
Session["mystyle"] = "/hyhtml/images/";
////根据文档ID来判断该文件是否存在，如果存在则跳转到该URL
//HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
//DataTable dt = Hyoa_flowmain.Getflowmain(ls_docid);
//if (dt.Rows.Count > 0)
//{
this.Response.Redirect(ls_url);
//}
//else
//{
// Response.Write("<script>alert('未找到对应的文档，可能文档已被删除，请联系管理员！');window.location='/'</script>");
//}
}
private void DataPlay()
{
this.btn_submit.Visible = true; //保存
if (this.Session["hyuid"].ToString() != "")
{
//根据用户ID得到信息
this.txtuserid.Text = this.Session["hyuid"].ToString();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dtuser = Hyoa_user.Getuserallinfo(this.txtuserid.Text);
if (dtuser.Rows.Count > 0)
{
this.txtusername.Text = dtuser.Rows[0]["hy_username"].ToString();
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();
}
dtuser.Clear();
this.txtuserid.Enabled = false;
this.txtusername.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>";
}
}
}
protected void btnsqlogin_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_user Users = new HyoaClass.Hyoa_user();
DataTable dt = Users.Getuserallinfo(this.txtloginuid_sqyh.Text);
if (dt.Rows.Count > 0)
{
Session["hyuid"] = this.txtloginuid_sqyh.Text;
Session["hyuname"] = dt.Rows[0]["hy_username"].ToString();
Session["hydeptid"] = dt.Rows[0]["hy_deptid"].ToString();
Session["hydeptname"] = dt.Rows[0]["hy_deptname"].ToString();
Session["hypost"] = dt.Rows[0]["hy_post"].ToString();
//得到兼职
DataTable dt_jz = Users.Getjzinfobyuserid(this.txtloginuid_sqyh.Text);
if (dt_jz.Rows.Count > 0)
{
Session["hydeptids_jz"] = "";
Session["hydeptnames_jz"] = "";
for (int i = 0; i < dt_jz.Rows.Count; i++)
{
if (Session["hydeptids_jz"] == "")
{
Session["hydeptids_jz"] = dt_jz.Rows[i]["hy_deptid"].ToString();
Session["hydeptnames_jz"] = dt_jz.Rows[i]["hy_deptname"].ToString();
}
else
{
Session["hydeptids_jz"] += "," + dt_jz.Rows[i]["hy_deptid"].ToString();
Session["hydeptnames_jz"] += "," + dt_jz.Rows[i]["hy_deptname"].ToString();
}
}
}
//得到风格
HyoaClass.Hyoa_mystyle Hyoa_mystyle = new HyoaClass.Hyoa_mystyle();
DataTable dt_mystyle = Hyoa_mystyle.Getstylebyuserid(this.txtloginuid_sqyh.Text);
if (dt_mystyle.Rows.Count > 0 && dt_mystyle.Rows[0]["hy_style"].ToString() != "")
Session["mystyle"] = dt_mystyle.Rows[0]["hy_style"].ToString();
else
Session["mystyle"] = "/hyhtml/images/";
//////为用户创建一个票证，并将其放入cookie或者url中（具体看你怎么设置票证的保存方式）
////FormsAuthentication.SetAuthCookie(this.txt_username.Value, true);
this.Response.Redirect(this.lblurl.Text);
}
dt.Clear();
}
private void DataPlay()
{
HyoaClass.Hyoa_mail_config Hyoa_mail_config = new HyoaClass.Hyoa_mail_config ();
DataTable dtmailcon = Hyoa_mail_config.Getmailconfigbyuserid(Session["hyuid"].ToString());
for(int ii=0;ii<dtmailcon.Rows.Count;ii++)
{
this.ddlmailset.Items.Insert(ii,dtmailcon.Rows[ii]["hy_mailid"].ToString());
}
//新文档
if (this.txtop.Value == "add")
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
this.txtdocid.Value = Hyoa_global.GetRandom();
this.lblhy_fsrid.Text = Session["hyuid"].ToString();
this.lblhy_fsrname.Text = Session["hyuname"].ToString();
this.lblhy_datetime.Text = System.DateTime.Now.ToString();
//如果是回复
if (this.Request.QueryString["fhid"] != null)
{
HyoaClass.Hyoa_mail Hyoa_mail = new HyoaClass.Hyoa_mail();
DataTable dt = Hyoa_mail.Getmail(this.Request.QueryString["fhid"].ToString());
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["hy_wbjsrid"].ToString() != "")
{
//this.txthy_jsrid.Text = dt.Rows[0]["hy_fsrid"].ToString();
this.txthy_wbjsrid.Text = dt.Rows[0]["hy_fsrid"].ToString();
//this.txthy_jsrid.Text = dt.Rows[0]["txthy_wbjsrid"].ToString();
//this.txthy_jsrname.Value = dt.Rows[0]["hy_fsrname"].ToString();
this.txthy_title.Text = "回复：" + dt.Rows[0]["hy_title"].ToString();
}
else
{
this.txthy_jsrid.Text = dt.Rows[0]["hy_fsrid"].ToString();
//this.txthy_wbjsrid.Text = dt.Rows[0]["hy_fsrid"].ToString();
this.txthy_jsrname.Value = dt.Rows[0]["hy_fsrname"].ToString();
this.txthy_title.Text = "回复：" + dt.Rows[0]["hy_title"].ToString();
}
}
}
//如果是从在线人员中过来的
if (this.Request.QueryString["recuserid"] != null)
{
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dtuser = Hyoa_user.Getuserallinfo(this.Request.QueryString["recuserid"].ToString());
if (dtuser.Rows.Count > 0)
{
this.txthy_jsrid.Text = this.Request.QueryString["recuserid"].ToString();
this.txthy_jsrname.Value = dtuser.Rows[0]["hy_username"].ToString();
}
}
//如果是转发
if (this.Request.QueryString["zfid"] != null)
{
HyoaClass.Hyoa_mail Hyoa_mail = new HyoaClass.Hyoa_mail();
DataTable dt = Hyoa_mail.Getmail(this.Request.QueryString["zfid"].ToString());
if (dt.Rows.Count > 0)
{
this.txthy_title.Text = "转发：" + dt.Rows[0]["hy_title"].ToString();
this.hy_content1.Value = dt.Rows[0]["hy_body"].ToString();
this.txtdocid.Value = dt.Rows[0]["docid"].ToString();
//附件
HyoaClass.Hyoa_fileatt Hyoa_fileatt = new HyoaClass.Hyoa_fileatt();
DataTable dt_fileatt = Hyoa_fileatt.GetfileattByFatherid(dt.Rows[0]["DOCID"].ToString());
if (dt_fileatt.Rows.Count > 0)
{
string ls_temp = "";
for (var i = 0; i < dt_fileatt.Rows.Count; i++)
{
ls_temp += (i + 1).ToString() + "、<a href='/" + dt_fileatt.Rows[i]["hy_filepath"].ToString() + "' target='_blank'>" + dt_fileatt.Rows[i]["hy_filename"].ToString() + "</a><br />";
}
this.lblhy_field2.Text = ls_temp;
}
}
this.uploadhy_field2.Visible = false;
}
}
else
{
if (this.Request.QueryString["id"] != null)
{
this.txtid.Value = this.Request.QueryString["id"].ToString();
}
HyoaClass.Hyoa_mail Hyoa_mail = new HyoaClass.Hyoa_mail();
DataTable dt = Hyoa_mail.Getmail(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.Value = dt.Rows[0]["hy_jsrname"].ToString();
this.txthy_jsrid.Text = dt.Rows[0]["hy_jsrid"].ToString();
this.txthy_wbjsrid.Text = dt.Rows[0]["hy_wbjsrid"].ToString();
this.txthy_title.Text = dt.Rows[0]["hy_title"].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++)
{
ls_temp += (i + 1).ToString() + "、<a href='/" + dt_fileatt.Rows[i]["hy_filepath"].ToString() + "' target='_blank'>" + dt_fileatt.Rows[i]["hy_filename"].ToString() + "</a><br />";
}
this.lblhy_field2.Text = ls_temp;
}
this.hy_content1.Value = dt.Rows[0]["hy_body"].ToString();
this.ddlifsavetofjx.SelectedValue = dt.Rows[0]["hy_ifsavetofjx"].ToString();
}
//20120210 start
if (dt.Rows[0]["hy_type"].ToString() == "发件" & dt.Rows[0]["hy_foldername"].ToString() == "发件箱")
{
string text = "<TR height='30'><TD width='20%' align='center' class='Tdcellleft'>序号</TD><TD width='40%' align='center' class='Tdcellleft'>姓名</TD><TD width='40%' align='center' class='Tdcellleft'>回执时间</TD></TR>";
HyoaClass.DAO db = new HyoaClass.DAO();
string sql = "";
sql = "select * from hyt_mail where DOCID='" + this.txtdocid.Value + "' and hy_type ='收件' and hy_sccksj <> '' order by hy_sccksj asc";
DataTable dt2 = db.GetDataTable(sql);
if (dt2.Rows.Count > 0)
{
for (var i = 0; i < dt2.Rows.Count; i++)
{
text = text + "<TR height='30'><TD width='20%' align='center' class='Tdcellright'>" + (i+1).ToString() + "</TD>";
text = text + "<TD width='40%' align='center' class='Tdcellright'>" + dt2.Rows[i]["hy_jsrname"].ToString() + "</TD>";
text = text + "<TD width='40%' align='center' class='Tdcellright'>" + dt2.Rows[i]["hy_sccksj"].ToString() + "</TD></TR>";
}
}
this.hzlb.Text = text;
}
//20120210 end
}
}
