/// <summary>
/// 右侧角色对应用户的数据绑定
/// 创建 毛枫 2015-4-17
/// </summary>
private void BindGrid2()
{
string R_CODE = FineUITable.GetSelectedDataKeyCode(Grid1);
if (R_CODE == "")
{
Grid2.RecordCount = 0;
Grid2.DataSource = null;
Grid2.DataBind();
}
else
{
// 过滤选中角色下的所有用户
long allcount = 0;
var query = new DapperExQuery <T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, R_CODE);
int PageIndex = Grid2.PageIndex + 1;
int PageSize = Grid2.PageSize;
List <T_ADMIN_ROLES> qs = T_ADMIN_ROLES_BLL.GetListByPage(query, "", PageIndex, PageSize, out allcount);
List <T_ADMIN> q = new List <T_ADMIN>();
foreach (T_ADMIN_ROLES t in qs)
{
var query1 = new DapperExQuery <T_ADMIN>().AndWhere(n => n.A_CODE, OperationMethod.Equal, t.A_CODE);
T_ADMIN T_ADMIN = new T_ADMIN();
T_ADMIN = T_ADMIN_BLL.GetEntity(query1);
q.Add(T_ADMIN);
}
//获取总记录数
Grid2.RecordCount = Int32.Parse(allcount.ToString());
Grid2.DataSource = q;
Grid2.DataBind();
}
}
//============操作方法===========
#region 数据保存按钮事件
/// <summary>
/// 保存
/// 创建人：林以恒
/// 2015年7月6日14:24:11
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSaveClose_Click(object sender, EventArgs e)
{
//设置页面权限
power.SetViewPower("mod_admin");
//验证权限
if (power.VerifyPower() == false)
{
return;
}
string str;
if (Request.QueryString["id"].IsNum())
{
string id = Request.QueryString["id"];
//修改
var query = new DapperExQuery <T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, int.Parse(id));
var adminUser = _adminUserBll.GetEntity(query);
if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text == tbxCfm_Password.Text)
{
adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16);
}
else if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text != tbxCfm_Password.Text)
{
Alert.Show("确认密码与填写密码不匹配");
}
adminUser = Save(adminUser);
str = _adminUserBll.Update(adminUser) ? "修改成功！" : "修改失败！";
}
else
{
T_ADMIN adminUser = new T_ADMIN();
//添加
adminUser = Save(adminUser);
if (tbxPassword.Text != tbxCfm_Password.Text)
{
Alert.Show("确认密码与填写密码不匹配");
}
else
{
adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16);
}
str = _adminUserBll.Add(adminUser) ? "添加成功！" : "添加失败！";
}
// 2. 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
Alert.ShowInTop(str);
}
/// <summary>
/// 更新用户实体
/// 创建人：林以恒
/// 2015年7月25日10:22:06
/// 修改：密码MD5
/// </summary>
/// <param name="adminUser">用户实体</param>
/// <returns></returns>
private T_ADMIN Save(T_ADMIN adminUser)
{
adminUser.A_NAME = tbxA_NAME.Text.Trim();
adminUser.A_TRUE_NAME = tbxA_CHINESE_NAME.Text.Trim();
adminUser.A_PHONE = tbxPhone.Text.Trim();
adminUser.A_GENDER = rbtnFirst.Checked ? 1 : 0;
if (adminUser.ID != 0)
{
return(adminUser);
}
//添加随机验证码
adminUser.A_CODE = StringRandomUtil.GuidTo16String();
//获取登入用户信息
var adminUserModel = AdminwebUserManager.GetCurrentAdminUser();
if (adminUserModel != null)
{
adminUser.CREATE_USER = adminUserModel.A_NAME;
adminUser.CREATE_USER_NAME = adminUserModel.A_CHINESE_NAME;
}
adminUser.CREATE_TIME = DateTime.Now;
return(adminUser);
}
/// <summary>
/// 更新用户实体
/// 创建人：林以恒
/// 2015年7月25日10:22:06
/// 修改：密码MD5
/// </summary>
/// <param name="adminUser">用户实体</param>
/// <returns></returns>
private T_ADMIN Save(T_ADMIN adminUser)
{
adminUser.A_NAME = tbxA_NAME.Text.Trim();
adminUser.A_TRUE_NAME = tbxA_CHINESE_NAME.Text.Trim();
adminUser.A_PHONE = tbxPhone.Text.Trim();
adminUser.A_GENDER = rbtnFirst.Checked ? 1 : 0;
if (adminUser.ID != 0) return adminUser;
//添加随机验证码
adminUser.A_CODE = StringRandomUtil.GuidTo16String();
//获取登入用户信息
var adminUserModel = AdminwebUserManager.GetCurrentAdminUser();
if (adminUserModel != null)
{
adminUser.CREATE_USER = adminUserModel.A_NAME;
adminUser.CREATE_USER_NAME = adminUserModel.A_CHINESE_NAME;
}
adminUser.CREATE_TIME = DateTime.Now;
return adminUser;
}
//============操作方法===========
#region 数据保存按钮事件
/// <summary>
/// 保存
/// 创建人：林以恒
/// 2015年7月6日14:24:11
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSaveClose_Click(object sender, EventArgs e)
{
//设置页面权限
power.SetViewPower("mod_admin");
//验证权限
if (power.VerifyPower() == false)
{
return;
}
string str;
if (Request.QueryString["id"].IsNum())
{
string id = Request.QueryString["id"];
//修改
var query = new DapperExQuery<T_ADMIN>().AndWhere(n => n.ID, OperationMethod.Equal, int.Parse(id));
var adminUser = _adminUserBll.GetEntity(query);
if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text == tbxCfm_Password.Text)
{
adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16);
}
else if (tbxPassword.Text != adminUser.PASSWORD && tbxPassword.Text != tbxCfm_Password.Text)
{
Alert.Show("确认密码与填写密码不匹配");
}
adminUser = Save(adminUser);
str = _adminUserBll.Update(adminUser) ? "修改成功！" : "修改失败！";
}
else
{
T_ADMIN adminUser = new T_ADMIN();
//添加
adminUser = Save(adminUser);
if (tbxPassword.Text != tbxCfm_Password.Text)
{
Alert.Show("确认密码与填写密码不匹配");
}
else
{
adminUser.PASSWORD = EncryptUtil.Md5Encode(tbxPassword.Text.Trim(), 16);
}
str = _adminUserBll.Add(adminUser) ? "添加成功！" : "添加失败！";
}
// 2. 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
Alert.ShowInTop(str);
}
/// <summary>
/// 管理员登录
/// 创建 毛枫 2015-4-21
/// 修改 毛枫 2015-7-31
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool AdminLoginIn(string username, string password)
{
bool result = false;
try
{
T_ADMIN admin = new T_ADMIN();
admin = IsLoginFromSql(username, password);
if (admin != null)
{
#region Cookie和Session的设置
//System.Web.HttpContext.Current.Session["A_ID"] = admin.ID;
//System.Web.HttpContext.Current.Session["A_Code"] = admin.A_CODE;
//System.Web.HttpContext.Current.Session["A_TrueName"] = admin.A_TRUE_NAME;
//System.Web.HttpContext.Current.Session["A_AdminName"] = admin.A_NAME;
//System.Web.HttpContext.Current.Session.Timeout = 10800;
WebHelperUtil.SessionAdd("A_ID", admin.ID.ToString(), 60);
WebHelperUtil.SessionAdd("A_Code", admin.A_CODE, 60);
WebHelperUtil.SessionAdd("A_TrueName", admin.A_TRUE_NAME, 60);
WebHelperUtil.SessionAdd("A_AdminName", admin.A_NAME, 60);
////生成用户模型
//System.Web.HttpContext.Current.Session["A_AdminUser"] = new AdminUserModel()
//{
// A_ID = admin.ID,
// A_CODE = admin.A_CODE,
// A_NAME = admin.A_NAME,
// A_CHINESE_NAME = admin.A_TRUE_NAME,
//};
string userModle = new AdminUserModel()
{
A_ID = admin.ID,
A_CODE = admin.A_CODE,
A_NAME = admin.A_NAME,
A_CHINESE_NAME = admin.A_TRUE_NAME,
}.toJson();
//加密处理
userModle = EncryptUtil.Base64Encode(userModle);
WebHelperUtil.SetCookie("A_AdminUser", userModle, ExpiresDayCookiesSession);
//生成验证字符串cookie
string authStr = admin.ID + "^" + username.ToLower() + "^" + DateTime.Now.AddHours(2);
authStr = EncryptUtil.DESEncryptString(authStr);
//添加Cookie
WebHelperUtil.SetCookie("AdminToken", EncryptUtil.MD5(admin.ID.ToString(), 16), ExpiresDayCookiesSession);
WebHelperUtil.SetCookie("AdminAuth", authStr, ExpiresDayCookiesSession);
WebHelperUtil.SetCookie("AdminLastLogTime", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), ExpiresDayCookiesSession);
WebHelperUtil.SetCookie("AdminUserLogin", "login", ExpiresDayCookiesSession);
#endregion
LoginCommon.InsertAdminLoginLog(admin);
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
result = false;
}
return(result);
}
/// <summary>
/// 右侧角色对应用户的数据绑定
/// 创建 毛枫 2015-4-17
/// </summary>
private void BindGrid2()
{
string R_CODE = FineUITable.GetSelectedDataKeyCode(Grid1);
if (R_CODE =="")
{
Grid2.RecordCount = 0;
Grid2.DataSource = null;
Grid2.DataBind();
}
else
{
// 过滤选中角色下的所有用户
long allcount = 0;
var query = new DapperExQuery<T_ADMIN_ROLES>().AndWhere(n => n.R_CODE, OperationMethod.Equal, R_CODE);
int PageIndex = Grid2.PageIndex + 1;
int PageSize = Grid2.PageSize;
List<T_ADMIN_ROLES> qs = T_ADMIN_ROLES_BLL.GetListByPage(query, "", PageIndex, PageSize, out allcount);
List<T_ADMIN> q = new List<T_ADMIN>();
foreach (T_ADMIN_ROLES t in qs)
{
var query1 = new DapperExQuery<T_ADMIN>().AndWhere(n => n.A_CODE, OperationMethod.Equal, t.A_CODE);
T_ADMIN T_ADMIN = new T_ADMIN();
T_ADMIN = T_ADMIN_BLL.GetEntity(query1);
q.Add(T_ADMIN);
}
//获取总记录数
Grid2.RecordCount = Int32.Parse(allcount.ToString());
Grid2.DataSource = q;
Grid2.DataBind();
}
}
/// <summary>
/// 管理员登录
/// 创建 毛枫 2015-4-21
/// 修改 毛枫 2015-7-31
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool AdminLoginIn(string username, string password)
{
bool result = false;
try
{
T_ADMIN admin = new T_ADMIN();
admin = IsLoginFromSql(username, password);
if (admin != null)
{
#region Cookie和Session的设置
//System.Web.HttpContext.Current.Session["A_ID"] = admin.ID;
//System.Web.HttpContext.Current.Session["A_Code"] = admin.A_CODE;
//System.Web.HttpContext.Current.Session["A_TrueName"] = admin.A_TRUE_NAME;
//System.Web.HttpContext.Current.Session["A_AdminName"] = admin.A_NAME;
//System.Web.HttpContext.Current.Session.Timeout = 10800;
WebHelperUtil.SessionAdd("A_ID", admin.ID.ToString(), 60);
WebHelperUtil.SessionAdd("A_Code", admin.A_CODE, 60);
WebHelperUtil.SessionAdd("A_TrueName", admin.A_TRUE_NAME, 60);
WebHelperUtil.SessionAdd("A_AdminName", admin.A_NAME, 60);
////生成用户模型
//System.Web.HttpContext.Current.Session["A_AdminUser"] = new AdminUserModel()
//{
// A_ID = admin.ID,
// A_CODE = admin.A_CODE,
// A_NAME = admin.A_NAME,
// A_CHINESE_NAME = admin.A_TRUE_NAME,
//};
string userModle = new AdminUserModel()
{
A_ID = admin.ID,
A_CODE = admin.A_CODE,
A_NAME = admin.A_NAME,
A_CHINESE_NAME = admin.A_TRUE_NAME,
}.toJson();
//加密处理
userModle = EncryptUtil.Base64Encode(userModle);
WebHelperUtil.SetCookie("A_AdminUser", userModle, ExpiresDayCookiesSession);
//生成验证字符串cookie
string authStr = admin.ID + "^" + username.ToLower() + "^" + DateTime.Now.AddHours(2);
authStr = EncryptUtil.DESEncryptString(authStr);
//添加Cookie
WebHelperUtil.SetCookie("AdminToken", EncryptUtil.MD5(admin.ID.ToString(), 16), ExpiresDayCookiesSession);
WebHelperUtil.SetCookie("AdminAuth", authStr, ExpiresDayCookiesSession);
WebHelperUtil.SetCookie("AdminLastLogTime", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), ExpiresDayCookiesSession);
WebHelperUtil.SetCookie("AdminUserLogin", "login", ExpiresDayCookiesSession);
#endregion
LoginCommon.InsertAdminLoginLog(admin);
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
result = false;
}
return result;
}
/// <summary>
/// 登录功能
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void IbtDL_Click(object sender, ImageClickEventArgs e)
{
LoginUser dlUser = new LoginUser();
//校验
if (this.txtUser.Text == "")
{
Alert("账户不能为空!");
return;
}
if (this.txtPwd.Text == "")
{
Alert("密码不能为空！");
return;
}
if (this.dlType.SelectedValue.Trim() == "管理")
{
T_ADMIN model = new T_ADMIN();
model = model.GetModelByName(this.txtUser.Text);
if (model == null)
{
ResponseMessage(this, "账户不存在！");
return;
}
if (model.ADMINMM != txtPwd.Text)
{
ResponseMessage(this, "密码错误，请查证后重新输入！");
return;
}
dlUser.JSID = 1;
dlUser.JSNAME = "超级管理员";
dlUser.Password = txtPwd.Text;
dlUser.ZH = txtUser.Text;
dlUser.ID = model.ADMINID;
dlUser.RealName = "超级管理员";
}
else if (dlType.SelectedValue.Trim() == "用户")
{
T_YH model = new T_YH();
model = model.GetModelByName(txtUser.Text);
if (model == null)
{
ResponseMessage(this, "账户不存在！");
return;
}
if (model.DLMM != txtPwd.Text)
{
ResponseMessage(this, "密码错误，请查证后重新输入！");
return;
}
dlUser.JSID = 2;
dlUser.JSNAME = "用户";
dlUser.Password = txtPwd.Text;
dlUser.ZH = txtUser.Text;
dlUser.ID = model.YHID;
dlUser.RealName = model.YHMC;
}
else
{
ResponseMessage(this, "登录类型错误！");
return;
}
Session["LoginUser"] = dlUser;
Response.Redirect("index.aspx");
}
