private XmlDocument getXmlDocument() { BLL.tb_SYS_Account bllAccount = new BLL.tb_SYS_Account(); DataTable dtAccount = bllAccount.GetList("ID='" + Session["AccountID"] + "'").Tables[0]; BLL.tb_SYS_RoleXML bllRoleXML = new BLL.tb_SYS_RoleXML(); DataTable dtRoleXML = bllRoleXML.GetList("RoleID='" + dtAccount.Rows[0]["RoleID"].ToString() + "'").Tables[0]; XmlDocument xmlDocument = new XmlDocument(); xmlDocument.LoadXml(dtRoleXML.Rows[0]["XML"].ToString()); return(xmlDocument); }
//删除选中记录集 protected void btnDelete_Click(object sender, EventArgs e) { string id = gridAccount.DataKeys[gridAccount.SelectedRowIndex][0].ToString(); BLL.tb_SYS_Account bllAccount = new BLL.tb_SYS_Account(); bool result = bllAccount.Delete(id); if (result) { Alert.ShowInTop("删除成功", "提示信息", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop("删除失败", "提示信息", MessageBoxIcon.Error); } }
//登录事件 protected void btnLogin_Click(object sender, EventArgs e) { //检测账户信息是否正确 BLL.vw_SYS_Account bllAccount_vw = new BLL.vw_SYS_Account(); string strWhere = "AccountName='" + txbUserName.Text + "' and Password='******'"; DataSet dsAccount = bllAccount_vw.GetList(strWhere); if (dsAccount.Tables[0].Rows.Count > 0) { Session["AccountName"] = txbUserName.Text; Session["AccountID"] = dsAccount.Tables[0].Rows[0]["ID"].ToString(); Session["RoleName"] = dsAccount.Tables[0].Rows[0]["RoleName"].ToString(); Alert.ShowInTop("登陆成功!", "提示信息", MessageBoxIcon.Information, "location.href='Default.aspx';"); return; } else { Alert.ShowInTop("用户名不存在 或 密码错误!", "提示信息", MessageBoxIcon.Warning); } #region 是否为系统初始账户 if (txbUserName.Text == "YJQ" && txbPassword.Text == "1111") { Model.tb_SYS_Account modelAccount = new Model.tb_SYS_Account(); modelAccount.ID = Guid.NewGuid().ToString(); modelAccount.AccountName = txbUserName.Text; modelAccount.Password = txbPassword.Text; modelAccount.AccountType = "0"; modelAccount.CreateID = modelAccount.ID; modelAccount.CreateTime = DateTime.Now; modelAccount.State = "1"; BLL.tb_SYS_Account bllAccount = new BLL.tb_SYS_Account(); bool result = bllAccount.Add(modelAccount); if (!result) { Alert.ShowInTop("初始账户添加失败!", "提示信息", MessageBoxIcon.Error); } else { Alert.ShowInTop("成功添加初始账户!", "提示信息", MessageBoxIcon.Information, "location.href='Default.aspx';"); } } #endregion }
//Grid绑定数据源 private void BindGrid() { string sortField = gridAccount.SortField; string sortDirection = gridAccount.SortDirection; BLL.tb_SYS_Account bllAccount = new BLL.tb_SYS_Account(); DataSet dsAccount = bllAccount.GetList(condition.ToString()); DataView dvAccount = dsAccount.Tables[0].DefaultView; dvAccount.Sort = String.Format("{0} {1}", sortField, sortDirection); DataTable dtSource = dvAccount.ToTable(); gridAccount.RecordCount = dtSource.Rows.Count; DataTable dtCurrent = PublicMethod.getPageTable(dtSource, gridAccount.PageIndex, gridAccount.PageSize); gridAccount.DataSource = dtCurrent; gridAccount.DataBind(); }
//保存修改 protected void btnSave_Click(object sender, EventArgs e) { Model.tb_SYS_Account modelAccount = new Model.tb_SYS_Account(); modelAccount.ID = Request.QueryString["ID"].ToString(); modelAccount.AccountName = txbAccountName.Text; modelAccount.Password = txbPassword.Text; modelAccount.RoleID = hdfRoleID.Text; modelAccount.UpdateID = Session["AccountID"].ToString(); modelAccount.UpdateTime = DateTime.Now; BLL.tb_SYS_Account bllAccount = new BLL.tb_SYS_Account(); bool result = bllAccount.Update(modelAccount); if (!result) { Alert.ShowInTop("更新失败", "提示信息", MessageBoxIcon.Error, ActiveWindow.GetHideRefreshReference()); } else { Alert.ShowInTop("更新成功", "提示信息", MessageBoxIcon.Information, ActiveWindow.GetHideRefreshReference()); } }