protected void btn_submit_Click(object sender, EventArgs e) { string name = SystemTool.NoHtml(txt_name.Text); string pass = SystemTool.NoHtml(txt_psw.Text); if (name == "" || pass == "") { SystemTool.AlertShow(this, "账户和密码不能为空"); return; } if (vCode.Value == "") { SystemTool.AlertShow(this, "验证码不能为空"); return; } if (Session["Code"] == null) { SystemTool.AlertShow(this, "验证码已过期"); return; } if (Session["Code"].ToString() != vCode.Value) { SystemTool.AlertShow(this, "验证码不正确"); return; } //string sql = "select man_id from manager_info where man_name='" + name + "' and man_psw='" + SystemTool.jimi(pass) + "'"; string sql = "select man_id,manager_info.state mstate,role_info.state rstate from manager_info,role_info where roleId=id and man_name='" + name + "' and man_psw='" + SystemTool.jimi(pass) + "'"; DataSet ds = DB.ExecuteSqlDataSet(sql, null); if (ds.Tables[0].Rows.Count == 0) { SystemTool.AlertShow(this, "账号或密码错误"); return; } if (ds.Tables[0].Rows[0]["mstate"].ToString() == "禁止") { SystemTool.AlertShow(this, "该用户被禁用"); return; } if (ds.Tables[0].Rows[0]["rstate"].ToString() == "禁止") { SystemTool.AlertShow(this, "该用户所在的组被禁用"); return; } //登录记录 //string area = SystemTool.GetAddressByIp(SystemTool.GetIP()); string ip = SystemTool.GetIP(); string dz = ""; //if (SystemTool.IsIP(ip)) { // dz = GetAddressByIp(ip); //} string managerid = ds.Tables[0].Rows[0]["man_id"].ToString(); string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //string sqlin = "insert into denglujilu(man_id,addtime,dengluip,dengludizhi) values(" + managerid + ",'" + time + "','" + ip + "','"+dz+"')"; //int result=DB.ExecuteSql(sqlin, null); //if (result <= 0) { // SystemTool.AlertShow(this, "网路连接错误,请重新登录"); // return; //} HttpCookie cookid = new HttpCookie(Cookie.ComplanyId, ds.Tables[0].Rows[0]["man_id"].ToString()); cookid.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(cookid); Response.Redirect("index.aspx"); // SystemTool.AlertShow_Refresh(this, "登录成功", "index.aspx"); }