Exemplo n.º 1
0
        /// <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;
            }
        }
Exemplo n.º 2
0
        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;
        }