/// <summary> /// 点击提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { if (ActionValidator("SystemSettingModify")) { if (!Page.IsValid) { return; } _systemsettingmodel = _systemsettingbll.GetModel(1); //添加时间 //_systemsettingmodel.AddTime = DateTime.Now; //系统名称 _systemsettingmodel.SystemName = txtSystemName.Text; _systemsettingmodel.Email = TextBox1.Text; _systemsettingmodel.smtpSeverName = TextBox2.Text; _systemsettingmodel.EmailName = TextBox3.Text; _systemsettingmodel.Emailpwd = TextBox4.Text; //图片 _systemsettingmodel.SystemPicture = HiddenFieldName1.Value; //更新一条数据 if (_systemsettingbll.Update(_systemsettingmodel)) { AlertAndParentSkip("更新成功!", "SystemSetting.aspx"); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Haikan.SchoolProjectsCore.MDB.Model.SystemSetting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SystemSetting set "); strSql.Append("SystemName=@SystemName,"); strSql.Append("SystemPicture=@SystemPicture,"); strSql.Append("Email=@Email,"); strSql.Append("smtpSeverName=@smtpSeverName,"); strSql.Append("EmailName=@EmailName,"); strSql.Append("Emailpwd=@Emailpwd,"); strSql.Append("FileType=@FileType,"); strSql.Append("IsIdentifyingCode=@IsIdentifyingCode"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@SystemName", SqlDbType.VarChar, 255), new SqlParameter("@SystemPicture", SqlDbType.VarChar, 255), new SqlParameter("@Email", SqlDbType.VarChar, 255), new SqlParameter("@smtpSeverName", SqlDbType.VarChar, 255), new SqlParameter("@EmailName", SqlDbType.VarChar, 255), new SqlParameter("@Emailpwd", SqlDbType.VarChar, 255), new SqlParameter("@FileType", SqlDbType.VarChar, 255), new SqlParameter("@IsIdentifyingCode", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.SystemName; parameters[1].Value = model.SystemPicture; parameters[2].Value = model.Email; parameters[3].Value = model.smtpSeverName; parameters[4].Value = model.EmailName; parameters[5].Value = model.Emailpwd; parameters[6].Value = model.FileType; parameters[7].Value = model.IsIdentifyingCode; parameters[8].Value = model.ID; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Haikan.SchoolProjectsCore.MDB.Model.SystemSetting DataRowToModel(DataRow row) { Haikan.SchoolProjectsCore.MDB.Model.SystemSetting model = new Haikan.SchoolProjectsCore.MDB.Model.SystemSetting(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["SystemName"] != null) { model.SystemName = row["SystemName"].ToString(); } if (row["SystemPicture"] != null) { model.SystemPicture = row["SystemPicture"].ToString(); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["smtpSeverName"] != null) { model.smtpSeverName = row["smtpSeverName"].ToString(); } if (row["EmailName"] != null) { model.EmailName = row["EmailName"].ToString(); } if (row["Emailpwd"] != null) { model.Emailpwd = row["Emailpwd"].ToString(); } if (row["FileType"] != null) { model.FileType = row["FileType"].ToString(); } if (row["IsIdentifyingCode"] != null && row["IsIdentifyingCode"].ToString() != "") { model.IsIdentifyingCode = int.Parse(row["IsIdentifyingCode"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Haikan.SchoolProjectsCore.MDB.Model.SystemSetting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SystemSetting("); strSql.Append("SystemName,SystemPicture,Email,smtpSeverName,EmailName,Emailpwd,FileType,IsIdentifyingCode)"); strSql.Append(" values ("); strSql.Append("@SystemName,@SystemPicture,@Email,@smtpSeverName,@EmailName,@Emailpwd,@FileType,@IsIdentifyingCode)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SystemName", SqlDbType.VarChar, 255), new SqlParameter("@SystemPicture", SqlDbType.VarChar, 255), new SqlParameter("@Email", SqlDbType.VarChar, 255), new SqlParameter("@smtpSeverName", SqlDbType.VarChar, 255), new SqlParameter("@EmailName", SqlDbType.VarChar, 255), new SqlParameter("@Emailpwd", SqlDbType.VarChar, 255), new SqlParameter("@FileType", SqlDbType.VarChar, 255), new SqlParameter("@IsIdentifyingCode", SqlDbType.Int, 4) }; parameters[0].Value = model.SystemName; parameters[1].Value = model.SystemPicture; parameters[2].Value = model.Email; parameters[3].Value = model.smtpSeverName; parameters[4].Value = model.EmailName; parameters[5].Value = model.Emailpwd; parameters[6].Value = model.FileType; parameters[7].Value = model.IsIdentifyingCode; object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 页面加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { // 读取系统名称 _systemSetModel = _systemSetBll.GetModel(2); LbSystemName.Text = _systemSetModel.SystemName; LbUserName.Text = Session["TrueName"] + ",欢迎您"; // 绑定用户名 Label1.Text = Session["username"].ToString(); // 菜单缓存 var cookie = DataCache.GetCache("HaikanSchoolProjects-" + Session["userid"]); if (cookie != null) { MenuStr += cookie; } else { Response.Redirect("Login.aspx?info=菜单缓存清空"); } // 绑定搜索框的自动完成 PageUrl = _systemPage.GetPageUrlByAuto(); // 绑定用户头像 if (!string.IsNullOrEmpty(Session["HeadPort"] as string)) { Image = "/UploadFiles/SystemManage/" + Session["HeadPort"]; } else { Image = "/libs/haikan/img/avatars/user.png"; } // Logo LeftImage = "/libs/haikan/img/avatars/logo_white.png"; }
/// <summary> /// 页面加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } //按钮权限 btnSubmit.Visible = ActionValidator("SystemSettingAdd"); // 对所有控件进行赋值 _systemsettingmodel = _systemsettingbll.GetModel(2); //系统名称 txtSystemName.Text = _systemsettingmodel.SystemName; TextBox1.Text = _systemsettingmodel.Email; TextBox2.Text = _systemsettingmodel.smtpSeverName; TextBox3.Text = _systemsettingmodel.EmailName; TextBox4.Text = _systemsettingmodel.Emailpwd; HiddenFieldName1.Value = _systemsettingmodel.SystemPicture; UploadFilseNameinfo = HiddenFieldName1.Value; }
/// <summary> /// 得到一个对象实体 /// </summary> public Haikan.SchoolProjectsCore.MDB.Model.SystemSetting GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,SystemName,SystemPicture,Email,smtpSeverName,EmailName,Emailpwd,FileType,IsIdentifyingCode from SystemSetting "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Haikan.SchoolProjectsCore.MDB.Model.SystemSetting model = new Haikan.SchoolProjectsCore.MDB.Model.SystemSetting(); DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 页面加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { // 获取全局配置中的系统名称 _systemSetModel = _systemSetBll.GetModel(_systemSetBll.GetMaxId()); lblSystemTitle.Text = SystemTitle = _systemSetModel.SystemName; //对接统一身份认证 //if (ConfigurationManager.AppSettings["HaikanPassport_IfUse"].ToLower() == "true") //{ // if (Session["HaikanSchoolProjects.Cert"] != null) // { // //分站凭证存在 // //Response.Write("恭喜,分站凭证存在,您被授权访问该页面!"); // } // else // { // //令牌验证结果返回 // if (Request.QueryString["token"] != null) // { // //持有令牌 // if (Request.QueryString["token"] != "$token$") // { // var tokenValue = Request.QueryString["token"]; // //调用WebService获取主站凭证 // //防止令牌伪造 // //此处还可使用公钥私钥的非对称加密策略 // passportservice.PassportService passportService = new passportservice.PassportService(); // object cert = passportService.TokenGetCert(tokenValue); // if (cert != null) // { // // 将token写入Session // Session["HaikanSchoolProjects.Token"] = tokenValue; // //令牌正确,产生分站凭证 // Session["HaikanSchoolProjects.Cert"] = cert; // //Response.Write("恭喜,令牌存在,您被授权访问该页面!"); // } // else // { // //令牌错误,去Passport登录 // Response.Redirect(HaikanPassportHelper.TokenReplace()); // } // } // //未持有令牌,去Passport登录 // else // { // Response.Redirect(HaikanPassportHelper.TokenReplace()); // } // } // //未进行令牌验证,去Passport验证 // else // { // //当前url附加上token参数 // Response.Redirect(HaikanPassportHelper.TokenUrl()); // } // } // // 进入用户认证的阶段 // if (!IsPostBack) // { // var userinfo = Session["HaikanSchoolProjects.Cert"]; // var blowFish = new BlowFish(); // var deText = blowFish.Decrypt(ConfigurationManager.AppSettings["HaikanPassport_ApiKey"], userinfo.ToString()); // string[] arr = deText.Split('&'); // if (arr.Length < 2) // { // Alert("API密钥不正确!"); // return; // } // // 获取该用户的相关信息 // var ds = _systemUserBll.GetModelList("UserName='******' and (UserPWD = '" + // DesEncrypt.GetMd5String(arr[1]) + "' or UserPWD = '" + arr[1] + // "')"); // if (ds.Count <= 0) // { // Session.Abandon(); // Alert("对不起,没有找到对应的用户!"); // Response.Redirect(HaikanPassportHelper.TokenReplace()); // return; // } // _systemUserModel = ds[0]; // if (_systemUserModel.IsEnter == 1) // { // Alert("对不起,您已被禁止登录!"); // return; // } // // 获取角色和权限 // var roleId = Convert.ToInt32(_systemUserModel.RoleID); // _systemRolesModel = _systemRolesBll.GetModel(roleId); // if (_systemRolesModel != null) // { // Session["roleId"] = _systemUserModel.RoleID; // Session["RoleName"] = _systemRolesModel.RoleName; // Session["ActionStr"] = _systemRolesModel.Actionstr; // } // else // { // Session["roleId"] = ""; // Session["RoleName"] = ""; // Session["ActionStr"] = ""; // } // // 个人信息 // Session["userid"] = _systemUserModel.ID; // Session["TrueName"] = _systemUserModel.TrueName; // Session["username"] = _systemUserModel.UserName; // Session["Department"] = _systemUserModel.DepartmentID; // Session["BirthDay"] = _systemUserModel.BirthDay; // Session["IdentityCard"] = _systemUserModel.SFZSerils; //身份证号码 // Session["Sex"] = _systemUserModel.Sex; // Session["JiaRuBenDanWeiTime"] = _systemUserModel.JiaRuBenDanWeiTime; // 入职时间 // Session["TelephoneNumber"] = _systemUserModel.TelphoneNumber; // 联系电话 // // 左侧菜单,保存到cookies中 // var menuStr = BindStr(); // if (menuStr != "") // { // DataCache.SetCache("HaikanSchoolProjects-" + Session["userid"], menuStr); // } // // 跳转到主界面 // Response.Redirect("/General/Main.aspx"); // } //} if (IsPostBack) { return; } // 清除浏览器缓存 _systemPage.ClearClientPageCache(); //是否显示验证码,如果不为0就隐藏 if (_systemSetModel.IsIdentifyingCode.ToString() != "0") { Panelyzm.Visible = false; } //判断是否有cookie值,如果有就读取出来 var cookies = Request.Cookies["RememberPWD"]; if (cookies == null || !cookies.HasKeys) { return; } TxtUserName.Text = cookies["Name"]; TxtUserPwd.Attributes.Add("value", cookies["UserPwd"]); chkRemembered.Checked = true; }
/// <summary> /// 点击登陆 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnLogin_Click(object sender, EventArgs e) { // 先判断验证码 _systemSetModel = _systemSetBll.GetModel(_systemSetBll.GetMaxId()); // 判断是否需要验证码 if (_systemSetModel.IsIdentifyingCode.ToString() == "0") { if (Session["yzm"] != null && !string.Equals(Session["yzm"].ToString(), TxtYZM.Text, StringComparison.CurrentCultureIgnoreCase)) { Alert("验证码错误"); return; } } // sql注入风险检查 if (SystemPage.SqlFilter(TxtUserName.Text.Trim()) || SystemPage.SqlFilter(TxtUserPwd.Text.Trim())) { Alert("帐号错误,请注意非法字符!"); return; } // 密码可能是原文或者md5加密后的 var strWhere = "UserName = '******' and (UserPWD = '" + DesEncrypt.GetMd5String(TxtUserPwd.Text.Trim()) + "' or UserPWD = '" + TxtUserPwd.Text.Trim() + "')"; var d = _systemUserBll.GetList(" UserName='******'"); if (d.Tables[0].Rows.Count > 0) { // 检测是否非法登录3次 var verify = _illegalityLogin.PwdIsCorrect(TxtUserName.Text.Trim(), 3, TxtUserPwd.Text.Trim()); if (verify == "成功") { // 获取该用户的相关信息 var ds = _systemUserBll.GetModelList(strWhere); if (ds.Count <= 0) { Alert("对不起,没有找到对应的用户!"); return; } _systemUserModel = ds[0]; if (_systemUserModel == null) { Alert("对不起,没有找到对应的用户!"); return; } if (_systemUserModel.IsEnter == 1) { Alert("对不起,您已被禁止登录!"); return; } // 获取角色和权限 var roleId = Convert.ToInt32(_systemUserModel.RoleID); _systemRolesModel = _systemRolesBll.GetModel(roleId); if (_systemRolesModel != null) { Session["roleId"] = _systemUserModel.RoleID; Session["RoleName"] = _systemRolesModel.RoleName; Session["ActionStr"] = _systemRolesModel.Actionstr; } // 个人信息 Session["userid"] = _systemUserModel.ID; Session["TrueName"] = _systemUserModel.TrueName; Session["username"] = TxtUserName.Text.Trim(); Session["Department"] = _systemUserModel.DepartmentID; Session["BirthDay"] = _systemUserModel.BirthDay; Session["IdentityCard"] = _systemUserModel.SFZSerils; //身份证号码 Session["Sex"] = _systemUserModel.Sex; Session["JiaRuBenDanWeiTime"] = _systemUserModel.JiaRuBenDanWeiTime; // 入职时间 Session["TelephoneNumber"] = _systemUserModel.TelphoneNumber; // 联系电话 // 判断是否选择了记住密码 if (chkRemembered.Checked) { var cookie = new HttpCookie("RememberPWD"); cookie.Values.Add("Name", TxtUserName.Text.Trim()); // 如果长度大于20,可以判定为md5加密后的密码,直接保存即可,否则需要加密后保存 cookie.Values.Add("UserPwd", TxtUserPwd.Text.Trim().Length > 20 ? TxtUserPwd.Text.Trim() : DesEncrypt.GetMd5String(TxtUserPwd.Text.Trim())); cookie.Expires = DateTime.Now.AddDays(60.0);// 有效期2个月 HttpContext.Current.Response.Cookies.Add(cookie); } // 左侧菜单,保存到cookies中 var menuStr = BindStr(); if (menuStr != "") { DataCache.SetCache("HaikanSchoolProjects-" + Session["userid"], menuStr); } // 跳转到主界面 Response.Redirect("/General/Main.aspx"); } else { Alert(verify); } } else { Alert("不存在该用户"); } }