protected void Page_Load(object sender, EventArgs e) { this.CurUser = WX.Main.CurUser; if (!IsPostBack) { PageInit(); } }
protected void Page_Load(object sender, EventArgs e) { if (!this.Master.A_Edit) { Response.Write("你没有权限访问此功能!"); Response.End(); return; } if (!IsPostBack) { string userId = WX.Request.rUserId; if (!ULCode.Validation.IsGuid(userId)) { ULCode.Debug.we("你无权访问此页面!"); return; } WX.WXUser cu = WX.Request.rCurUser; cu.LoadUserModel(false); this.lblUserId.Text = cu.UserID; this.liUserName.Text = String.Format("员工:{0} 用户名:{1}", cu.UserModel.RealName, cu.UserName); this.lblUserName.Text = cu.UserName; this.lblEmail.Text = cu.AspNetUser.Email; this.lblCreateDate.Text = String.Format("{0:yyyy-MM-dd HH:mm:ss}", cu.AspNetUser.CreationDate); this.lblLoginDate.Text = String.Format("{0:yyyy-MM-dd HH:mm:ss}", cu.AspNetUser.LastLoginDate); this.lblLastUpdatePwd.Text = String.Format("{0:yyyy-MM-dd HH:mm:ss}", cu.AspNetUser.LastPasswordChangedDate); this.lblLastLock.Text = String.Format("{0:yyyy-MM-dd HH:mm:ss}", cu.AspNetUser.LastLockoutDate); string sSql = String.Format("Select * from TU_OnlineUsers where UserId='{0}'", userId); bool online = ULCode.QDA.XSql.IsHasRow(sSql); if (online) { this.lblOnlineState.ForeColor = System.Drawing.Color.Gold; this.lblOnlineState.Text = "在线"; } else { this.lblOnlineState.ForeColor = System.Drawing.Color.Gray; this.lblOnlineState.Text = "离线"; } if (cu.AspNetUser.IsLockedOut) { this.lblState.Text = "锁定"; this.lblState.ForeColor = System.Drawing.Color.Red; this.btnLock.Enabled = false; this.btnUnlock.Enabled = true; } else { this.lblState.Text = "正常使用"; this.lblState.ForeColor = System.Drawing.Color.Green; this.btnLock.Enabled = true; this.btnUnlock.Enabled = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (WX.Main.CurUser.IsEmployeeUser) { this.spanEmployee.Visible = true; //Load UserName this.lblUserName.InnerText = WX.Authentication.GetUserName(); //Load Msg this.LoadPrivateMsg(true); //Load Private State WX.WXUser user = WX.Main.CurUser; WX.Model.Employee.MODEL employee = WX.Model.Employee.GetModelToID(user.UserID); user.LoadUserModel(true); if (employee.IDCard.ToString() == "" || employee.Email.ToString() == "") { Response.Redirect("Private/Priv_EditUser.aspx"); } user.LoadMyDepartment(true); user.LoadDutyDetailUser(true); user.LoadDutyUser(true); user.LoadMyGrade(false); //判断防止第一次进入错误 int grade = 0; if (user.MyGrade != null) { grade = user.DutyDetailUser.GradeID.ToInt32(); //grade = user.MyGrade.Sort.ToInt32(); } grade = user.UserModel.Grade.ToInt32(); string deptName = null; if (user.MyDepartMent != null) { deptName = user.MyDepartMent.Name.ToString(); } string dutyName = null; if (user.DutyUser != null) { dutyName = user.DutyUser.Name.ToString(); } this.lblPrivateState.Text = String.Format("{0},{1},{2}" , deptName, dutyName, WX.Model.Grade.GetModel(grade).Name.ToString() + "(" + grade + ")"); } else { this.lblUserName.InnerText = WX.Authentication.GetUserName(); this.spanEmployee.Visible = false; } } }
protected void btnTestConnection_Click(object sender, EventArgs e) { int port = 993; WX.WXUser user = WX.Main.CurUser; string host = this.txtHostAddress.Text.Trim(); string userName = this.txtUserName.Text.Trim(); string password = this.txtPassword.Text.Trim(); bool b = int.TryParse(this.txtPort.Text, out port); bool ssl = this.chkSSL.Checked; using (POP3_Client client = new POP3_Client()) { try { client.Connect(host, port, ssl); client.Authenticate(userName, password, false); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string insertText = "INSERT INTO [TU_EmailPOP] ([UserID],[Host],[UserName],[Password],[Port],[SSL]) VALUES (@UserID,@Host,@UserName,@Password,@Port,@SSL)"; string updateText = "UPDATE [TU_EmailPOP] SET [UserID]=@UserID,[Host]=@Host,[UserName]=@UserName,[Password]=@Password,[Port]=@Port,[SSL]=@SSL"; SqlCommand command; command = new SqlCommand("SELECT COUNT(ID) FROM [TU_EmailPOP] WHERE UserID='" + user.UserID + "'", connection); int row = (int)command.ExecuteScalar(); if (row > 0) { command = new SqlCommand(updateText, connection); } else { command = new SqlCommand(insertText, connection); } command.Parameters.AddWithValue("@UserID", user.UserID); command.Parameters.AddWithValue("@Host", host); command.Parameters.AddWithValue("@UserName", userName); command.Parameters.AddWithValue("@Password", password); command.Parameters.AddWithValue("@Port", port); command.Parameters.AddWithValue("@SSL", true); command.ExecuteNonQuery(); MessageBox.ShowAndRedirect(this, "邮箱配置成功", Request.RawUrl); } } catch (Exception ex) { MessageBox.ShowAndRedirect(this, "邮箱配置失败:" + ex.Message, Request.RawUrl); } } }
private void LoadName() { WX.WXUser user = WX.Main.CurUser; user.LoadUserModel(false); user.LoadEmployeeUser(false); if (user.EmployeeUser.Sex.ToBoolean()) { this.imgFace.ImageUrl = "/Images/User/man_icon.gif"; } else { this.imgFace.ImageUrl = "/Images/User/woman_icon.gif"; } this.lblName.Text = user.UserModel.RealName.ToString(); }
private string GetSysVariable(string Vname) { string returnstr = ""; WX.WXUser cu = WX.Main.CurUser; WX.Flow.Model.Process.MODEL pmodel = WX.Flow.Model.Process.GetModel("select top 1 * from TE_VarDefine where Title='" + Vname + "'"); string name = ""; if (pmodel != null && pmodel.Name.value != null) { name = pmodel.Name.value.ToString(); } switch (name) { case "PRCS_Z_UserName": cu.LoadUserModel(false); returnstr = cu.UserModel.RealName.value.ToString(); break; case "PRCS_Z_UserDuty": cu.LoadDutyUser(); returnstr = cu.DutyUser.Name.value.ToString(); break; case "PRCS_Z_UserDept": cu.LoadUserModel(false); WX.Model.Department.MODEL dept = WX.Model.Department.GetCache(cu.UserModel.DepartmentID.ToInt32()); //WX.Model.Department.GetModel("select * from TE_Departments where ID=" + cu.EmployeeUser.DepartmentID.value.ToString()); returnstr = dept.Name.value.ToString(); break; case "PRCS_Z_UserSupDept": cu.LoadUserModel(false); WX.Model.Department.MODEL dept2 = WX.Model.Department.GetCache(cu.UserModel.DepartmentID.ToInt32()); //WX.Model.Department.GetModel("select * from TE_Departments where ID=" + cu.EmployeeUser.DepartmentID.value.ToString()); dept2 = WX.Model.Department.GetCache(dept2.ParentID.ToInt32()); //WX.Model.Department.GetModel("select * from TE_Departments where ID=" + dept2.ParentID.value.ToString()); returnstr = dept2.Name.value.ToString(); break; case "PRCS_ID": returnstr = Request["id"]; break; case "Datetime_Now": returnstr = DateTime.Now.ToString("yyyy-MM-dd"); break; default: break; } return(returnstr); }
public static string SearchSingleEmail(string subject,string date) { string userId = new WX.WXUser().UserID; DataTable table; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM [TU_EmailPOP] WHERE UserID='" + userId + "'", connection); table = new DataTable(); sda.Fill(table); } string host = string.Empty; string userName = string.Empty; string password = string.Empty; int port = 995; bool ssl = true; foreach (DataRow row in table.Rows) { host = row["Host"].ToString(); userName = row["UserName"].ToString(); password = row["Password"].ToString(); port = int.Parse(row["Port"].ToString()); } string json = string.Empty; using (POP3_Client client = new POP3_Client()) { client.Connect(host, port, ssl); client.Authenticate(userName, password, false); var messages = client.Messages; foreach (POP3_ClientMessage message in messages) { Mail_Message email = Mail_Message.ParseFromByte(message.MessageToByte()); if (email.Subject.Equals(subject) && email.Date == Convert.ToDateTime(date)) { TestItem item = new TestItem { Subject = email.Subject, Body = email.BodyHtmlText }; json = JsonConvert.SerializeObject(item); } } } return json; }
/// <summary> /// 简捷使用 /// </summary> /// <param name="functionId">使用功能ID</param> /// <returns></returns> //public static bool ExecPermission(int functionId) //{ // if (!GetPermission(functionId)) // { // HttpContext.Current.Response.Write("你没有权限访问此功能!"); // HttpContext.Current.Response.End(); // return false; // } // else // return true; //} #endregion #region //根据职务和功能动态生成左侧菜单 CreateMenu(int DutyID) public static string GetMenu() { WX.WXUser user = WX.Main.CurUser; DataTable dt = ULCode.QDA.XSql.GetDataTable("exec Get_MaxRole '" + user.UserID + "'"); Duty.MODEL duty = Duty.GetCache(0); if (user.IsEmployeeUser) { user.LoadDutyUser(); duty = user.DutyUser; } if (dt != null && dt.Rows.Count > 0 && Convert.ToInt32(dt.Rows[0][0]) > duty.GradeID.ToInt32()) { return(dt.Rows[0][1].ToString()); } return(duty.Menus.ToString()); }
private void LoadDuty() { WX.WXUser user = WX.Main.CurUser; user.LoadUserModel(false); user.LoadMyDepartment(true); user.LoadDutyDetailUser(true); user.LoadDutyUser(true); user.LoadMyGrade(true); int grade = 0; if (user.MyGrade != null) { grade = user.DutyDetailUser.GradeID.ToInt32(); //grade = user.MyGrade.Sort.ToInt32(); } this.lblDutyState.Text = String.Format("等级:{2}级<br />职务:{1}<br />部门:{0}<br /><span><a>[查看][日志]</a></span>" , user.MyDepartMent.Name, user.DutyUser.Name, grade); }
/// <summary> /// 获取单个服务器变量 /// </summary> /// <param name="Vname"></param> /// <returns></returns> private string GetConditionSql_GetSysVariable(string name) { string returnstr = ""; WX.WXUser cu = WX.Public.CurUser; //WX.Flow.Model.Process.MODEL pmodel = WX.Flow.Model.Process.GetModel("select top 1 * from TE_VarDefine where Title='" + Vname + "'"); //string name = ""; //if (pmodel != null && pmodel.Name.value != null) //{ // name = pmodel.Name.value.ToString(); //} switch (name) { case "PRCS_Z_UserName": cu.LoadUserModel(false); returnstr = cu.UserModel.RealName.value.ToString(); break; case "PRCS_Z_UserDuty": cu.LoadDutyUser(); returnstr = cu.DutyUser.Name.value.ToString(); break; case "PRCS_Z_UserDept": cu.LoadEmployeeUser(); cu.LoadMyDepartment(); returnstr = cu.MyDepartMent.Name.ToString(); break; case "PRCS_Z_UserSupDept": cu.LoadEmployeeUser(); cu.LoadMyDepartment(); WX.Model.Department.MODEL dept2 = WX.Model.Department.GetCache(cu.MyDepartMent.ParentID.ToInt32()); //WX.Model.Department.GetModel("select * from TE_Departments where ID=" + cu.MyDepartMent.ParentID.ToString()); returnstr = dept2.Name.value.ToString(); break; case "PRCS_ID": returnstr = Convert.ToInt32(HttpContext.Current.Request.QueryString["Step_Id"]).ToString(); break; case "Datetime_Now": returnstr = DateTime.Now.ToString("yyyy-MM-dd"); break; default: break; } return(returnstr); }
protected void Page_Load(object sender, EventArgs e) { WX.WXUser user = WX.Main.CurUser; if (!this.IsPostBack) { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); string cmdText = String.Format("SELECT * FROM [TU_EmailPOP] WHERE UserID='{0}'", user.UserID); SqlCommand command = new SqlCommand(cmdText, connection); SqlDataAdapter sda = new SqlDataAdapter(command); DataTable table1 = new DataTable(); sda.Fill(table1); foreach (DataRow row in table1.Rows) { this.txtHostAddress.Text = row["Host"].ToString(); this.txtUserName.Text = row["UserName"].ToString(); this.txtPassword.Attributes.Add("value", row["Password"].ToString()); this.txtPort.Text = row["Port"].ToString(); } } } }
//此函数暂未用到(可删除) public static int GetPermission(int funcID) { int flag = 0; WX.WXUser user = WX.Main.NewCurUser(); user.LoadDutyUser(false); WX.Model.Function.MODEL funcM = WX.Model.Function.GetCache(funcID); if (funcM != null) { if (GetFuncState(funcM) > 0) { flag = GetPermission(user.DutyUser, funcM); } else { flag = 0; } } else { flag = 3; } return(flag); }
public static void ClearCurUser() { WX.WXUser cu = PageUser; cu = null; HttpContext.Current.Session["Main_CurUser"] = null; }
protected void Button2_Click(object sender, EventArgs e) { WX.WXUser cuser = WX.Request.rCurUser; this.lblNewPwd.Text = cuser.AspNetUser.ResetPassword(); cuser = null; }