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