//protected void btnLogin_Click(object sender, DirectEventArgs e) //{ // string usname = TextBox1.Text; // string pwd = TextBox1.Text; // BG_User user = BG_UserLogic.UserLogin(usname, pwd); // if (user != null) // { // Session[Constant.UserID] = user.UserID; //用户ID // Session[Constant.UserName] = user.UserName; //用户名称 // Session[Constant.UserNum] = user.UserNum; //用户工号 // Session[Constant.UserLim] = user.UserLim; //用户权限 // Session[Constant.DepID] = user.DepID; //用户所属部门ID // BG_Department department = BG_DepartmentManager.GetBG_DepartmentByDepID(user.DepID); // Session[Constant.DepName] = department.DepName; //用户所属部门名称 // Response.Redirect("default.aspx", true); // } // else // { // X.Msg.Alert("Error", "密码或帐户名错误!").Show(); // } //} protected void ibtnLogin_Click(object sender, ImageClickEventArgs e) { string usname = txtUer.Text; string pwd = txtPwd.Text; BG_User user = BG_UserLogic.UserLogin(usname, pwd); if (user != null) { Session[Constant.UserID] = user.UserID; //用户ID Session[Constant.UserName] = user.UserName; //用户名称 Session[Constant.UserNum] = user.UserNum; //用户工号 Session[Constant.UserLim] = user.UserLim; //用户权限 Session[Constant.DepID] = user.DepID; //用户所属部门ID BG_Department department = BG_DepartmentManager.GetBG_DepartmentByDepID(user.DepID); Session[Constant.DepName] = department.DepName; //用户所属部门名称 Session["CurrentYear"] = BG_SysSettingLogic.GetLastYear(); Session["IsLogin"] = 1; BG_User userd = new BG_User(); user.IsLogin = 1; BG_UserManager.ModifyBG_User(userd); Session[Constant.listallocationstr] = GetXML().Trim(); Response.Redirect("default.aspx", true); } else { X.Msg.Alert("Error", "密码或帐户名错误!").Show(); } }
/// <summary> /// 用户Login /// </summary> /// <param name="uid">帐号</param> /// <param name="pwd">密码</param> /// <returns>BGUser</returns> public static BG_User UserLogin(string uid, string pwd) { BG_User user = null; string sqlStr = "select * from BG_User where UserNum = '{0}' and UserPwd= '{1}'"; sqlStr = string.Format(sqlStr, uid, pwd); DataTable dt = DBUnity.AdapterToTab(sqlStr); if (dt.Rows.Count > 0) { user = new BG_User(); user.UserID = (int)dt.Rows[0]["UserID"]; user.UserName = dt.Rows[0]["UserName"].ToString(); user.UserIDNum = dt.Rows[0]["UserIDNum"].ToString(); user.UserNum = dt.Rows[0]["UserNum"].ToString(); user.UserPwd = dt.Rows[0]["UserPwd"].ToString(); user.UserLim = dt.Rows[0]["UserLim"].ToString(); user.UserSta = (int)dt.Rows[0]["UserSta"]; user.DepID = (int)dt.Rows[0]["DepID"]; user.UserRem = dt.Rows[0]["UserRem"].ToString(); } return(user); }
protected void btnsure_OnDirectClick(object sender, DirectEventArgs e) { if (!string.IsNullOrEmpty(PasswordField.Text.Trim())) { string pwd = ""; BG_User bgUser = BG_UserManager.GetBG_UserByUserID(UserID); pwd = bgUser.UserPwd; if (bgUser.UserPwd == PasswordField.Text.Trim()) { X.Msg.Alert("系统提示", "密码不能与原密码相同").Show(); return; } bgUser.UserPwd = PasswordField.Text.Trim(); if (BG_UserManager.ModifyBG_User(bgUser)) { X.Msg.Alert("系统提示", "密码修改成功").Show(); Window1.Close(); } BG_ChangePwd bgChangePwd = new BG_ChangePwd(); bgChangePwd.UserName = UserName; bgChangePwd.CrTime = DateTime.Now; bgChangePwd.DepName = DepName; bgChangePwd.NewPwd = bgUser.UserPwd; bgChangePwd.UserID = bgUser.UserID; bgChangePwd.OldPwd = pwd; BG_ChangePwdManager.AddBG_ChangePwd(bgChangePwd); } }
protected void ibtnLogin_Click(object sender, ImageClickEventArgs e) { string usname = txtUer.Text; string pwd = txtPwd.Text; BG_User user = BG_UserLogic.UserLogin(usname, pwd); if (user != null) { Session[Constant.UserID] = user.UserID; //用户ID Session[Constant.UserName] = user.UserName; //用户名称 Session[Constant.UserNum] = user.UserNum; //用户工号 Session[Constant.UserLim] = user.UserLim; //用户权限 Session[Constant.DepID] = user.DepID; //用户所属部门ID BG_Department department = BG_DepartmentManager.GetBG_DepartmentByDepID(user.DepID); Session[Constant.DepName] = department.DepName; //用户所属部门名称 Response.Redirect("default.aspx", true); } else { X.Msg.Alert("Error", "密码或帐户名错误!").Show(); } }
protected override void OnLoad(EventArgs e) { if (Session[Constant.UserName] != null && Session[Constant.UserLim] != null) { InComeSouce = new string[] { "财政拨款", "地方财政", "其他" }; userLim = Session[Constant.UserLim].ToString(); userName = Session[Constant.UserName].ToString(); userNum = Session[Constant.UserNum].ToString(); depID = Convert.ToInt32(Session[Constant.DepID]); depName = Session[Constant.DepName].ToString(); UserID = Convert.ToInt32(Session[Constant.UserID]); areaDepID = Convert.ToInt32(ConfigurationManager.AppSettings["AreaDepID"]); currentYear = DateTime.Now.Year.ToString(); //Session["CurrentYear"].ToString(); try { userLimStr = GetUserLimStr(userLim); } catch { } isLogin = (int)Session["IsLogin"]; listallocationstr = Session[Constant.listallocationstr].ToString(); } else { Session["IsLogin"] = 0; BG_User user = new BG_User(); user.IsLogin = 0; BG_UserManager.ModifyBG_User(user); ScriptManager.RegisterStartupScript(this, GetType(), "lgout", "window.top.location.href='" + ResolveClientUrl("~/login.aspx") + "'", true); } base.OnLoad(e); }
public static bool ModifyBG_User(BG_User bG_User) { string sql = "UPDATE BG_User " + "SET " + "UserName = @UserName, " + "UserNum = @UserNum, " + "UserIDNum = @UserIDNum, " + "UserPwd = @UserPwd, " + "UserLim = @UserLim, " + "UserSta = @UserSta, " + "DepID = @DepID, " + "UserRem = @UserRem, " + "IsVIP = @IsVIP, " + "UserDescription = @UserDescription, " + "IsLogin = @IsLogin, " + "ApplyRem = @ApplyRem " + "WHERE UserID = @UserID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@UserID", bG_User.UserID), new SqlParameter("@UserName", bG_User.UserName), new SqlParameter("@UserNum", bG_User.UserNum), new SqlParameter("@UserIDNum", bG_User.UserIDNum), new SqlParameter("@UserPwd", bG_User.UserPwd), new SqlParameter("@UserLim", bG_User.UserLim), new SqlParameter("@UserSta", bG_User.UserSta), new SqlParameter("@DepID", bG_User.DepID), new SqlParameter("@UserRem", bG_User.UserRem), new SqlParameter("@IsVIP", bG_User.IsVIP), new SqlParameter("@UserDescription", bG_User.UserDescription), new SqlParameter("@IsLogin", bG_User.IsLogin), new SqlParameter("@ApplyRem", bG_User.ApplyRem) }; int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para); if (t > 0) { return(true); } else { return(false); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
protected void btninit_OnDirectClick(object sender, DirectEventArgs e) { int uid = common.IntSafeConvert(UserID); BG_User bgUser = BG_UserManager.GetBG_UserByUserID(uid); bgUser.UserPwd = "12345"; if (BG_UserManager.ModifyBG_User(bgUser)) { X.Msg.Alert("系统提示", "用户密码已初始化").Show(); } }
public static BG_User GetBG_UserByUserID(int userID) { string sql = "SELECT * FROM BG_User WHERE UserID = @UserID"; try { SqlParameter para = new SqlParameter("@UserID", userID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_User bG_User = new BG_User(); bG_User.UserID = dt.Rows[0]["UserID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UserID"]; bG_User.UserName = dt.Rows[0]["UserName"] == DBNull.Value ? "" : (string)dt.Rows[0]["UserName"]; bG_User.UserNum = dt.Rows[0]["UserNum"] == DBNull.Value ? "" : (string)dt.Rows[0]["UserNum"]; bG_User.UserIDNum = dt.Rows[0]["UserIDNum"] == DBNull.Value ? "" : (string)dt.Rows[0]["UserIDNum"]; bG_User.UserPwd = dt.Rows[0]["UserPwd"] == DBNull.Value ? "" : (string)dt.Rows[0]["UserPwd"]; bG_User.UserLim = dt.Rows[0]["UserLim"] == DBNull.Value ? "" : (string)dt.Rows[0]["UserLim"]; bG_User.UserSta = dt.Rows[0]["UserSta"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UserSta"]; bG_User.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_User.UserRem = dt.Rows[0]["UserRem"] == DBNull.Value ? "" : (string)dt.Rows[0]["UserRem"]; bG_User.IsVIP = dt.Rows[0]["IsVIP"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IsVIP"]; bG_User.UserDescription = dt.Rows[0]["UserDescription"] == DBNull.Value ? "" : (string)dt.Rows[0]["UserDescription"]; bG_User.IsLogin = dt.Rows[0]["IsLogin"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IsLogin"]; bG_User.ApplyRem = dt.Rows[0]["ApplyRem"] == DBNull.Value ? "" : (string)dt.Rows[0]["ApplyRem"]; return(bG_User); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_User AddBG_User(BG_User bG_User) { string sql = "INSERT BG_User (UserName, UserNum, UserIDNum, UserPwd, UserLim, UserSta, DepID, UserRem, IsVIP, UserDescription, IsLogin, ApplyRem)" + "VALUES (@UserName, @UserNum, @UserIDNum, @UserPwd, @UserLim, @UserSta, @DepID, @UserRem, @IsVIP, @UserDescription, @IsLogin, @ApplyRem)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@UserName", bG_User.UserName), new SqlParameter("@UserNum", bG_User.UserNum), new SqlParameter("@UserIDNum", bG_User.UserIDNum), new SqlParameter("@UserPwd", bG_User.UserPwd), new SqlParameter("@UserLim", bG_User.UserLim), new SqlParameter("@UserSta", bG_User.UserSta), new SqlParameter("@DepID", bG_User.DepID), new SqlParameter("@UserRem", bG_User.UserRem), new SqlParameter("@IsVIP", bG_User.IsVIP), new SqlParameter("@UserDescription", bG_User.UserDescription), new SqlParameter("@IsLogin", bG_User.IsLogin), new SqlParameter("@ApplyRem", bG_User.ApplyRem) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_UserByUserID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_User(BG_User bG_User) { return(BG_UserService.ModifyBG_User(bG_User)); }
public static bool DeleteBG_User(BG_User bG_User) { return(BG_UserService.DeleteBG_User(bG_User)); }
public static BG_User AddBG_User(BG_User bG_User) { return(BG_UserService.AddBG_User(bG_User)); }
private void add() { UserID.Text = ""; BG_User user = new BG_User(); user.UserIDNum = TextField4.Text; user.UserName = TextField1.Text.Replace(",", string.Empty).Replace(",", string.Empty); if (user.UserName == "" || user.UserName == (string)Session["depname"]) { X.Msg.Alert("提示", "人名不能与部门名重名!").Show(); return; } if (BG_UserLogic.IsUser(user.UserName)) { X.Msg.Alert("提示", "已经存在该姓名,请使用其他姓名添加!").Show(); return; } user.UserNum = TextField3.Text; user.UserRem = txtRem.Text.Replace(",", string.Empty).Replace(",", string.Empty); string limit = string.Empty; int isvip = 0; if (Radio1.Checked == true) { limit = "100000"; user.UserDescription = "管理员"; } if (Radio2.Checked == true) { limit = "010000"; user.UserDescription = "局领导"; } if (Radio3.Checked == true) { limit = "001000"; user.UserDescription = "审核员"; } if (Radio4.Checked == true) { limit = "000100"; user.UserDescription = "录入人员"; } if (Radio5.Checked == true) { limit = "000010"; user.UserDescription = "查询人员"; } if (Radio6.Checked == true) { limit = "000001"; user.UserDescription = "出纳员"; } if (Radio7.Checked == true) { isvip = 1; } if (Radio8.Checked == true) { isvip = 0; } //if (Radio19.Checked == true) //{ // isvip = 2; //} string applyrem = ""; string applyrem1 = ""; string applyrem2 = ""; string applyrem3 = ""; applyrem1 = Radio9.Checked == true ? "1" : "0"; applyrem2 = Radio10.Checked == true ? "1" : "0"; applyrem3 = Radio11.Checked == true ? "1" : "0"; user.UserLim = limit; //user.UserSta = StrToInt(cbbSta.Text); //if (cbbSta.Text == "禁用") //{ // user.UserSta = 2; //} //if (cbbSta.Text == "禁用") //{ // user.UserSta = 1; //} user.UserSta = 1; user.UserPwd = "12345"; int depid = common.IntSafeConvert(BG_DepartmentLogic.GetBG_DepartmentByName((string)Session["depname"]).DepID); user.DepID = depid; user.IsVIP = isvip; user.ApplyRem = applyrem; if (BG_UserManager.AddBG_User(user).UserID > 0) { Node node = new Node(); node.Text = user.UserName; node.Icon = Icon.User; node.Leaf = true; STMem.GetNodeById(depid).AppendChild(node); //X.Msg.Show(new MessageBoxConfig //{ // Title = "提示", // Message = "添加成功", // Width = 300, // Buttons = MessageBox.Button.OK, //}); Session["depname"] = "政策法规科"; Response.Redirect("STMember.aspx?depid=" + depid, true); } //STMem.ExpandAll(); //int depid = AreaDepID; }
private void mod(int uid) { BG_User user = BG_UserManager.GetBG_UserByUserID(uid); user.UserName = TextField1.Text.Replace(",", string.Empty).Replace(",", string.Empty); user.UserNum = TextField3.Text.Replace(",", string.Empty).Replace(",", string.Empty); user.UserIDNum = TextField4.Text.Replace(",", string.Empty).Replace(",", string.Empty); user.UserRem = txtRem.Text.Replace(",", string.Empty).Replace(",", string.Empty); string limit = string.Empty; int isvip = 0; string applyrem = ""; if (Radio1.Checked == true) { limit = "100000"; user.UserDescription = "管理员"; } if (Radio2.Checked == true) { limit = "010000"; user.UserDescription = "局领导"; } if (Radio3.Checked == true) { limit = "001000"; user.UserDescription = "审核员"; } if (Radio4.Checked == true) { limit = "000100"; user.UserDescription = "录入人员"; } if (Radio5.Checked == true) { limit = "000010"; user.UserDescription = "查询人员"; } if (Radio6.Checked == true) { limit = "000001"; user.UserDescription = "出纳员"; } if (Radio7.Checked == true) { isvip = 1; } if (Radio8.Checked == true) { isvip = 0; } //if (Radio9.Checked == true) //{ // applyrem = "000"; //} string applyrem1 = ""; string applyrem2 = ""; string applyrem3 = ""; applyrem1 = Radio9.Checked == true ? "1" : "0"; applyrem2 = Radio10.Checked == true ? "1" : "0"; applyrem3 = Radio11.Checked == true ? "1" : "0"; applyrem = applyrem1 + applyrem2 + applyrem3; user.UserLim = limit; string depname = ComboBox1.Text; //ComboBox1.RawValue.ToString(); DataTable dt = BG_DepartmentLogic.GetDepidByName(depname); if (dt.Rows.Count > 0) { user.DepID = StrToInt(dt.Rows[0]["DepID"].ToString()); } user.IsVIP = isvip; user.ApplyRem = applyrem; // faUser.UserPurStr = "000000"; if (BG_UserManager.ModifyBG_User(user)) { X.Msg.Show(new MessageBoxConfig { Title = "提示", Message = "修改成功", Width = 300, Buttons = Ext.Net.MessageBox.Button.OK, }); int depid = common.IntSafeConvert(user.DepID); Response.Redirect("STMember.aspx?depid=" + depid, true); //Response.Redirect("STMember.aspx", true); } }
public void Memberselect(string uid) { uid = uid.Contains("用户")?uid.Replace("用户", ""):uid; //FieldSet2.Hidden = !Radio4.Checked; TextField1.ReadOnly = true; Session["TextField1"] = 0; if (uid.Length <= 0) { return; } hidUserID.Value = uid; chkClear(); int id = StrToInt(uid); BG_User user = BG_UserManager.GetBG_UserByUserID(id); //BG_User user = BG_UserManager.GetBG_UserByUsid(id); if (user != null) { TextField1.Text = user.UserName; int depid = user.DepID; TextField3.Text = user.UserNum; TextField4.Text = user.UserIDNum; txtRem.Text = user.UserRem; UserID.Text = user.UserID.ToString(); string limit = user.UserLim; if (common.IntSafeConvert(user.IsVIP.ToString().Substring(0, 1)) == 1) { Radio7.Checked = true; } else if (common.IntSafeConvert(user.IsVIP.ToString().Substring(0, 1)) == 0) { Radio8.Checked = true; } //else //{ // Radio19.Checked = true; //} if (user.ApplyRem.Length > 0 && user.ApplyRem.Substring(0, 1) == "1") { Radio9.Checked = true; } else { Radio9.Checked = false; } if (user.ApplyRem.Length > 0 && user.ApplyRem.Substring(1, 1) == "1") { Radio10.Checked = true; } else { Radio10.Checked = false; } if (user.ApplyRem.Length > 0 && user.ApplyRem.Substring(2, 1) == "1") { Radio11.Checked = true; } else { Radio11.Checked = false; } if (limit.Length >= 5) { if (limit.Substring(0, 1) == "1") { Radio1.Checked = true; } if (limit.Substring(1, 1) == "1") { Radio2.Checked = true; } if (limit.Substring(2, 1) == "1") { Radio3.Checked = true; } if (limit.Substring(3, 1) == "1") { Radio4.Checked = true; } if (limit.Substring(4, 1) == "1") { Radio5.Checked = true; } if (limit.Substring(5, 1) == "1") { Radio6.Checked = true; } } BG_Department dp = BG_DepartmentManager.GetBG_DepartmentByDepID(depid); if (dp != null) { //ComboBox1.RawValue = dp.DepName; ComboBox1.Text = dp.DepName; if (dp.DepName.Contains("局长基金")) { Radio11.Enable(true); } else { Radio11.Disable(true); } } } }
public static bool DeleteBG_User(BG_User bG_User) { return(DeleteBG_UserByUserID(bG_User.UserID)); }