/// <summary> /// 得到一个对象实体 /// </summary> public Entity.manager_log GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,user_id,user_name,action_type,note,login_ip,login_time from dt_manager_log "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer,4)}; parameters[0].Value = id; Entity.manager_log model = new Entity.manager_log(); DataSet ds = DB.DB.Db().Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["user_id"].ToString() != "") { model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString()); } model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); model.action_type = ds.Tables[0].Rows[0]["action_type"].ToString(); model.note = ds.Tables[0].Rows[0]["note"].ToString(); model.login_ip = ds.Tables[0].Rows[0]["login_ip"].ToString(); if (ds.Tables[0].Rows[0]["login_time"].ToString() != "") { model.login_time = DateTime.Parse(ds.Tables[0].Rows[0]["login_time"].ToString()); } return model; } else { return null; } }
protected void btnSubmit_Click(object sender, EventArgs e) { string userName = txtUserName.Text.Trim(); string userPwd = txtUserPwd.Text.Trim(); string code = txtCode.Text.Trim(); if (userName.Equals("") || userPwd.Equals("")) { lblTip.Visible = true; lblTip.Text = "请输入用户名或密码"; return; } if (code.Equals("")) { lblTip.Visible = true; lblTip.Text = "请输入验证码"; return; } if (Session[SysKeys.SESSION_CODE] == null) { lblTip.Visible = true; lblTip.Text = "系统找不到验证码"; return; } if (code.ToLower() != Session[SysKeys.SESSION_CODE].ToString().ToLower()) { lblTip.Visible = true; lblTip.Text = "验证码输入不正确"; return; } BLL.ManagerBll bll = new BLL.ManagerBll(); Entity.Manager model = bll.GetEntityByNameAndPwd(userName, DESEncrypt.Encrypt(userPwd)); if (model == null) { lblTip.Visible = true; lblTip.Text = "用户名或密码有误"; return; } Session[SysKeys.SESSION_ADMIN_INFO] = model; Session.Timeout = 45; //写入登录日志 Entity.siteconfig siteConfig = new BLL.siteconfigBll().loadConfig(Utils.GetXmlMapPath(SysKeys.FILE_SITE_XML_CONFING)); if (siteConfig.logstatus > 0) { Entity.manager_log modelLog = new Entity.manager_log(); modelLog.user_id = model.ID; modelLog.user_name = model.UserName; modelLog.action_type = "login"; modelLog.note = "用户登录"; modelLog.login_ip = SysRequest.GetIP(); modelLog.login_time = DateTime.Now; new BLL.manager_log().Add(modelLog); } //写入Cookies if (cbRememberId.Checked) { Utils.WriteCookie("DTRememberName", model.UserName, 14400); } else { Utils.WriteCookie("DTRememberName", model.UserName, -14400); } Utils.WriteCookie("AdminName", "DTcms", model.UserName); Utils.WriteCookie("AdminPwd", "DTcms", model.UserPassword); Response.Redirect("index.aspx"); return; }