protected void btnFilter_Click(object sender, EventArgs e)
{
DateTime dfrom = DateTime.Parse(tbDateFrom.Text);
DateTime dto = DateTime.Parse(tbDateTo.Text).AddDays(1);
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var list = from u in ctx.R_HelloEvoque
where u.HDate >= dfrom && u.HDate < dto
select new
{
ID = u.ID,
Name = u.HName,
Email = u.HEmail,
Phone = u.HPhone,
Sub = u.HSubscription,
Time = u.HDate,
Source = u.HSource,
Province = u.HProvince,
City = u.HCity,
Way = u.HWay,
Title = u.HTitle
};
dataList.DataSource = list.ToList();
dataList.DataBind();
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
DateTime dfrom = DateTime.Parse(tbDateFrom.Text);
DateTime dto = DateTime.Parse(tbDateTo.Text).AddDays(1);
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var list = from u in ctx.NSD_User
where u.AddTime >= dfrom && u.AddTime < dto
select new Discover24HoursEntity
{
Name = u.UName,
Title = u.UTitle,
Email = u.UEmail,
Province = u.UProvince,
City = u.UCity,
Mobile = u.UMobile,
HighScore = u.UScore,
Weibo = u.Weibo,
Place = u.Choose,
Time = u.AddTime
};
dataList.DataSource = list.ToList();
dataList.DataBind();
/*if (list.Count() > 0)
btnDown.Enabled = true;
else
btnDown.Enabled = false;*/
}
}
protected void newSubmit_Click(object sender, EventArgs e)
{
if (IsValid)
{
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var admin = from u in ctx.L_Administrators
where u.Username == newUser.Text.Trim()
select u.ID;
if (admin.Count() > 0)
{
Alert.ShowAlert(Page, "该登录名已存在，请重新输入!", Alert.AlertState.Nothing, string.Empty);
return;
}
L_Administrators ent = new L_Administrators();
ent.AddTime = DateTime.Now;
ent.DealerID = 0;
ent.DisplayName = newName.Text.Trim();
ent.Email = newEmail.Text.Trim();
ent.LastIP = Request.UserHostAddress;
ent.LastLogin = DateTime.Now;
ent.Username = newUser.Text.Trim();
ent.Password = Helper.GetPasswordString(ent.Username, newPass1.Text.Trim());
ent.RoleID = int.Parse(newRole.SelectedValue);
ent.Status = 1;
ctx.L_Administrators.InsertOnSubmit(ent);
ctx.SubmitChanges();
}
Alert.ShowAlert(HttpContext.Current, "添加成功!", Alert.AlertState.OpenInThisWindow, Request.Url.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string cmd = Request.QueryString["m"];
switch (cmd)
{
case "detail":
jsBlock.Text = "<script type=\"text/javascript\">$($('.content-tab li')[1]).addClass(\"cur\");</script>";
CommandView.ActiveViewIndex = 1;
break;
case "add":
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var role = from r in ctx.L_Roles
where r.Status == 1
select new
{
ID = r.ID,
Name = r.RoleName
};
newRole.DataSource = role.ToList();
newRole.DataTextField = "Name";
newRole.DataValueField = "ID";
}
CreateView.DataBind();
jsBlock.Text = "<script type=\"text/javascript\">$($('.content-tab li')[2]).addClass(\"cur\");</script>";
CommandView.ActiveViewIndex = 2;
break;
default:
tabBack.Visible = false;
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var admin = from a in ctx.L_Administrators
join r in ctx.L_Roles on a.RoleID equals r.ID
where a.Status == 1
select new
{
ID = a.ID,
Name = a.Username,
Display = a.DisplayName,
Email = a.Email,
Role = r.RoleName,
AddTime = a.AddTime,
LastLogin = a.LastLogin,
LastIP = a.LastIP,
Status = (UserStatus)a.Status
};
dataList.DataSource = admin.ToList();
dataList.DataBind();
}
jsBlock.Text = "<script type=\"text/javascript\">$('.content-tab li:first').addClass(\"cur\");</script>";
CommandView.ActiveViewIndex = 0;
break;
}
}
}
protected void edtSubmit_Click(object sender, EventArgs e)
{
if (IsValid)
{
int uid;
if (!int.TryParse(Request.QueryString["id"], out uid))
{
if (Request.QueryString["m"] == "profile")
{
uid = (int)Session["lr_admin_id"];
}
else
{
Alert.ShowAlert(Page, "参数非法！", Alert.AlertState.OpenInThisWindow, "AdminMgmt.aspx");
return;
}
}
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
L_Administrators admin;
if (lineAuth.Visible)
{
string oldpass = Helper.GetPasswordString((string)Session["lr_admin_user"], edtPass.Text.Trim());
admin = (from a in ctx.L_Administrators
where a.ID == uid && a.Password == oldpass
select a).SingleOrDefault();
if (admin == null)
{
Alert.ShowAlert(Page, "密码错误，请重试！", Alert.AlertState.Nothing, string.Empty);
return;
}
}
else
{
admin = (from u in ctx.L_Administrators
where u.ID == uid
select u).Single();
}
admin.DisplayName = edtName.Text.Trim();
if ((int)Session["lr_admin_id"] == uid && !string.IsNullOrEmpty(edtPass1.Text))
{
admin.Password = Helper.GetPasswordString(admin.Username, edtPass1.Text.Trim());
}
admin.Email = edtEmail.Text.Trim();
admin.RoleID = int.Parse(edtRole.SelectedValue);
ctx.SubmitChanges();
}
Alert.ShowAlert(HttpContext.Current, "修改成功!", Alert.AlertState.OpenInThisWindow, Request.Url.ToString());
}
}
public void OnAcquireRequestState(Object obj, EventArgs e)
{
HttpApplication app = obj as HttpApplication;
HttpContext cnt = app.Context;
FileInfo info = new FileInfo(cnt.Request.Path);
if (info.Extension != ".aspx")
{
return;
}
if (info.Name.ToLower() == "default.aspx" || info.Name.ToLower() == "captcha.aspx")
{
return;
}
if (CurrentCache["lr_roleData"] == null)
{
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var role = from r in ctx.L_Roles
where r.Status == 1
select r;
CurrentCache.Insert("lr_roleData", role.ToList(), null, DateTime.Now.AddDays(15), Cache.NoSlidingExpiration);
}
}
List<L_Roles> list = (List<L_Roles>)CurrentCache["lr_roleData"];
if (cnt.Session["lr_admin_id"] != null && cnt.Session["lr_admin_role"] != null)
{
int rid = (int)cnt.Session["lr_admin_role"];
var robj = list.Where(r => r.ID == rid).SingleOrDefault();
if (robj == null)
{
cnt.Session.Remove("lr_admin_rolename");
cnt.Response.Write("invalid role id");
}
else
{
cnt.Session["lr_admin_rolename"] = robj.RoleName;
}
}
else
{
cnt.Response.Redirect(string.Format("Default.aspx?rt={0}", HttpUtility.UrlEncode(cnt.Request.Url.ToString())));
}
if (_eventHandler != null)
_eventHandler(this, null);
}
protected void btnDown_Click(object sender, EventArgs e)
{
DateTime dfrom = DateTime.Parse(tbDateFrom.Text);
DateTime dto = DateTime.Parse(tbDateTo.Text).AddDays(1);
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var list = from u in ctx.NSD_User
where u.AddTime >= dfrom && u.AddTime < dto
select new Discover24HoursEntity
{
ID = u.ID,
Name = u.UName,
Title = u.UTitle,
Email = u.UEmail,
Province = u.UProvince,
City = u.UCity,
Mobile = u.UMobile,
HighScore = u.UScore,
Weibo = u.Weibo,
Place = u.Choose,
Time = u.AddTime
};
List<Discover24HoursEntity> data = list.ToList();
if (data.Count == 0)
return;
StringBuilder sb = new StringBuilder("ID,姓名,称呼,电子邮件,省份,城市,手机号,最高分,微博帐号,活动站点,注册时间");
foreach (Discover24HoursEntity obj in data)
{
sb.AppendLine();
sb.AppendFormat("{0},", obj.ID);
sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.Name));
sb.AppendFormat("{0},", obj.Title);
sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.Email));
sb.AppendFormat("{0},", obj.Province);
sb.AppendFormat("{0},", obj.City);
sb.AppendFormat("{0},", obj.Mobile);
sb.AppendFormat("{0},", obj.HighScore);
sb.AppendFormat("{0},", obj.Weibo);
sb.AppendFormat("{0},", obj.Place);
sb.AppendFormat("{0}", obj.Time);
}
string path = Helper.ExportAsCsvFile(sb);
Response.Redirect(path);
}
}
protected void btnDown_Click(object sender, EventArgs e)
{
DateTime dfrom = DateTime.Parse(tbDateFrom.Text);
DateTime dto = DateTime.Parse(tbDateTo.Text).AddDays(1);
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var list = from u in ctx.R_HelloEvoque
where u.HDate >= dfrom && u.HDate < dto
select u;
var data = list.ToList();
if (data.Count == 0)
return;
StringBuilder sb = new StringBuilder("ID,HName,HTitle,HPhone,HEmail,HProvince,HCity,HWay,HSubscription,HIp,HDate,HSource");
foreach (var obj in data)
{
sb.AppendLine();
sb.AppendFormat("{0},", obj.ID);
sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.HName));
sb.AppendFormat("{0},", obj.HTitle);
sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.HPhone));
sb.AppendFormat("\"{0}\",", Helper.FormatForCSV(obj.HEmail));
sb.AppendFormat("{0},", obj.HProvince);
sb.AppendFormat("{0},", obj.HCity);
sb.AppendFormat("{0},", obj.HWay);
sb.AppendFormat("{0},", obj.HSubscription);
sb.AppendFormat("{0},", obj.HIp);
sb.AppendFormat("{0},", obj.HDate);
sb.AppendFormat("{0},", obj.HSource);
}
string path = Helper.ExportAsCsvFile(sb);
Response.Redirect(path);
}
}
private UserStatus ShowDetailByUserID(int uid)
{
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var user = (from a in ctx.L_Administrators
where a.ID == uid
select a).SingleOrDefault();
var role = from r in ctx.L_Roles
where r.Status == 1
select new
{
ID = r.ID,
Name = r.RoleName
};
if (user != null)
{
edtRole.DataSource = role.ToList();
edtRole.DataTextField = "Name";
edtRole.DataValueField = "ID";
edtEmail.Text = user.Email;
edtName.Text = user.DisplayName;
edtRole.SelectedValue = user.RoleID.ToString();
edtUser.Text = user.Username;
edtStatus.Text = ((UserStatus)user.Status).ToString();
if ((UserStatus)user.Status == UserStatus.Banned)
{
edtBan.Text = "启用帐号";
}
else
{
edtBan.Text = "禁用帐号";
}
return (UserStatus)user.Status;
}
else
{
Alert.ShowAlert(Page, "指定的用户不存在。", Alert.AlertState.OpenInThisWindow, "AdminMgmt.aspx");
return UserStatus.Deleted;
}
}
}
private void ResetPasswordAction()
{
int uid;
if (!int.TryParse(Request.QueryString["id"], out uid))
{
Alert.ShowAlert(Page, "参数非法！", Alert.AlertState.OpenInThisWindow, "AdminMgmt.aspx");
return;
}
string newpass = Helper.GetRandString(8);
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var admin = (from u in ctx.L_Administrators
where u.ID == uid
select u).Single();
Session["lr_admin_reset"] = new string[] { admin.Username, newpass };
admin.Password = Helper.GetPasswordString(admin.Username, newpass);
ctx.SubmitChanges();
}
Response.Redirect(string.Format("~/AdminMgmt.aspx?m=reset&id={0}", uid));
}
protected void toggleUserStatus(object sender, EventArgs e)
{
int uid;
if (!int.TryParse(Request.QueryString["id"], out uid))
{
Alert.ShowAlert(Page, "参数非法！", Alert.AlertState.OpenInThisWindow, "AdminMgmt.aspx");
return;
}
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var user = (from a in ctx.L_Administrators
where a.ID == uid && a.Status != (byte)UserStatus.Deleted
select a).Single();
if (user.Status == 1)
user.Status = 2;
else if (user.Status == 2)
user.Status = 1;
ctx.SubmitChanges();
}
Alert.ShowAlert(Page, "操作成功！", Alert.AlertState.OpenInThisWindow, Request.Url.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string cmd = Request.QueryString["m"];
switch (cmd)
{
case "detail":
int uid;
if (!int.TryParse(Request.QueryString["id"], out uid))
{
Alert.ShowAlert(Page, "参数非法！", Alert.AlertState.OpenInThisWindow, "AdminMgmt.aspx");
return;
}
if ((int)Session["lr_admin_id"] == uid)
{
lineQuick.Visible = false;
}
else
{
linePass.Visible = false;
}
UserStatus stat = ShowDetailByUserID(uid);
if (stat == UserStatus.Banned)
{
lineEmail.Visible = false;
lineName.Visible = false;
lineRole.Visible = false;
btn_resetpass.Visible = false;
edtSubmit.Visible = false;
}
//jsBlock.Text = "<script type=\"text/javascript\">$($('.content-tab li')[1]).addClass(\"cur\");</script>";
DetailView.DataBind();
CommandView.ActiveViewIndex = 1;
break;
case "profile":
int sid = (int)Session["lr_admin_id"];
lineQuick.Visible = false;
lineAuth.Visible = true;
tabBack.Visible = false;
Label12.Text = "新密码<span class=\"desc\">(留空则不修改)</span>";
lbDetail.Text = "修改个人资料";
ShowDetailByUserID(sid);
DetailView.DataBind();
CommandView.ActiveViewIndex = 1;
break;
case "add":
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var role = from r in ctx.L_Roles
where r.Status == 1
select new
{
ID = r.ID,
Name = r.RoleName
};
newRole.DataSource = role.ToList();
newRole.DataTextField = "Name";
newRole.DataValueField = "ID";
}
newRole.SelectedValue = "2";
CreateView.DataBind();
jsBlock.Text = "<script type=\"text/javascript\">$($('.content-tab li')[2]).addClass(\"cur\");</script>";
CommandView.ActiveViewIndex = 2;
break;
case "reset":
if (Session["lr_admin_reset"] == null)
{
Response.Redirect("~/AdminMgmt.aspx");
return;
}
string[] args = (string[])Session["lr_admin_reset"];
rstUser.Text = args[0];
rstCode.Text = args[1];
Session.Remove("lr_admin_reset");
CommandView.ActiveViewIndex = 3;
break;
default:
tabBack.Visible = false;
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var admin = from a in ctx.L_Administrators
join r in ctx.L_Roles on a.RoleID equals r.ID
where a.Status != 3
select new
{
ID = a.ID,
Name = a.Username,
Display = a.DisplayName,
Email = a.Email,
Role = r.RoleName,
AddTime = a.AddTime,
LastLogin = a.LastLogin,
LastIP = a.LastIP,
Status = (UserStatus)a.Status
};
dataList.DataSource = admin.ToList();
dataList.DataBind();
}
jsBlock.Text = "<script type=\"text/javascript\">$('.content-tab li:first').addClass(\"cur\");</script>";
CommandView.ActiveViewIndex = 0;
break;
}
}
else
{
switch (postbackArgs.Value)
{
case "reset":
ResetPasswordAction();
break;
default:
return;
}
postbackArgs.Value = string.Empty;
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
if (IsValid)
{
if (tbCode.Text.Trim().ToUpper() != (string)Session[Helper.CaptchaKey])
{
//Alert.ShowAlert(Page, "验证码错误。", Alert.AlertState.Nothing, string.Empty);
msgError.Text = "验证码错误。";
return;
}
string passStr = Helper.GetPasswordString(tbName.Text, tbPass.Text);
using (LandRoverDBDataContext ctx = new LandRoverDBDataContext())
{
var admin = (from a in ctx.L_Administrators
where a.Username == tbName.Text && a.Password == passStr
select a).SingleOrDefault();
if (admin != null)
{
switch (admin.Status)
{
case 1:
admin.LastIP = Request.UserHostAddress;
admin.LastLogin = DateTime.Now;
ctx.SubmitChanges();
Session[Helper.UserKey] = admin.Username;
Session["lr_admin_id"] = admin.ID;
Session["lr_admin_user"] = admin.Username;
Session["lr_admin_name"] = admin.DisplayName;
Session["lr_admin_role"] = admin.RoleID;
string redirect = Request.QueryString["rt"];
if (string.IsNullOrEmpty(redirect))
{
Response.Redirect("~/KeepMeInformed.aspx");
}
else
{
Response.Redirect(redirect);
}
break;
case 2:
//Alert.ShowAlert(Page, "帐号被禁用，请联系管理员。", Alert.AlertState.Nothing, string.Empty);
msgError.Text = "帐号被禁用，请联系管理员。";
break;
default:
break;
}
}
else
{
//Alert.ShowAlert(Page, "用户名或密码错误。", Alert.AlertState.Nothing, string.Empty);
msgError.Text = "用户名或密码错误。";
return;
}
}
}
}
