public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType     = "text/plain";
            context.Response.Buffer          = true;
            context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1.0);
            context.Response.AddHeader("pragma", "no-cache");
            context.Response.AddHeader("cache-control", "");
            context.Response.CacheControl = "no-cache";
            string           Action    = context.Request["action"];
            string           username  = context.Request["username"];
            string           password  = context.Request["password"];
            string           code      = context.Request["code"];
            RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal();
            string           text      = Action;

            if (text != null)
            {
                if (text == "login")
                {
                    DataTable dtlogin = user_idao.UserLogin(username.Trim(), password.Trim());
                    if (dtlogin != null)
                    {
                        if (dtlogin.Rows.Count != 0)
                        {
                            if (this.Islogin(context, username))
                            {
                                RequestSession.AddSessionUser(new SessionUser
                                {
                                    UserId         = dtlogin.Rows[0]["loginId"].ToString(),
                                    UserAccount    = dtlogin.Rows[0]["loginName"].ToString(),
                                    UserName       = dtlogin.Rows[0]["userName"].ToString() + "(" + dtlogin.Rows[0]["loginName"].ToString() + ")",
                                    UserPwd        = dtlogin.Rows[0]["loginPassword"].ToString(),
                                    AreaID         = "",
                                    OrganizationID = dtlogin.Rows[0]["departmentID"].ToString(),
                                });
                                context.Response.Write("3");
                                context.Response.End();
                            }
                            else
                            {
                                context.Response.Write("6");
                                context.Response.End();
                            }
                        }
                        else
                        {
                            context.Response.Write("4");
                            context.Response.End();
                        }
                    }
                    else
                    {
                        context.Response.Write("5");
                        context.Response.End();
                    }
                }
            }
        }
示例#2
0
        private void LoginInfo(HttpContext context, DataTable dtlogin, string OWNER_address)
        {
            RM_UserInfo_IDAO user_idao    = new RM_UserInfo_Dal();
            string           AdminHotelid = dtlogin.Rows[0]["AdminHotelid"].ToString();

            string user_Account = dtlogin.Rows[0]["User_Account"].ToString();          //账户

            user_idao.SysLoginLog(1, 1, user_Account, "1", OWNER_address, dtlogin.Rows[0]["User_ID"].ToString(), AdminHotelid);

            SessionUser user = new SessionUser();

            user.UserId       = dtlogin.Rows[0]["User_ID"].ToString();
            user.UserAccount  = dtlogin.Rows[0]["User_Account"].ToString();
            user.UserName     = dtlogin.Rows[0]["User_Name"].ToString();
            user.UserPwd      = dtlogin.Rows[0]["User_Pwd"].ToString();
            user.AdminHotelid = dtlogin.Rows[0]["AdminHotelid"].ToString();
            user.Hotelid      = dtlogin.Rows[0]["Hotelid"].ToString();
            user.HotelListId  = dtlogin.Rows[0]["HotelListId"].ToString();
            string IsAdmin = dtlogin.Rows[0]["IsAdmin"].ToString();

            user.IsAdmin = IsAdmin;
            string roleName = "";

            if (IsAdmin == "0")
            {
                roleName = "管理员";
            }
            else if (IsAdmin == "1")
            {
                roleName = "管理员";
            }
            else
            {
                roleName = dtlogin.Rows[0]["Roles_Name"].ToString();
            }
            user.RoleName = roleName;

            RequestSession.ClearAllSession();
            RequestSession.AddSessionUser(user);

            HttpCookie cookies = new HttpCookie("LoginUser_CK");

            cookies.Values.Clear();
            cookies.Expires = DateTime.Now.AddDays(1);
            cookies.Values.Add("User_ID", user.UserId.ToString());
            cookies.Values.Add("User_Account", user.UserAccount.ToString());
            cookies.Values.Add("AdminHotelid", user.AdminHotelid.ToString());
            cookies.Values.Add("Hotelid", user.Hotelid.ToString());
            cookies.Values.Add("User_Name", user.UserName.ToString());
            cookies.Values.Add("UserPwd", user.UserPwd.ToString());
            cookies.Values.Add("HotelListId", user.HotelListId.ToString());
            cookies.Values.Add("IsAdmin", user.IsAdmin.ToString());
            cookies.Values.Add("RoleName", user.RoleName.ToString());
            context.Response.AppendCookie(cookies);
        }
示例#3
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType     = "text/plain";
            context.Response.Buffer          = true;
            context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1);
            context.Response.AddHeader("pragma", "no-cache");
            context.Response.AddHeader("cache-control", "");
            context.Response.CacheControl = "no-cache";
            string           Action       = context.Request["action"].Trim(); //提交动作
            string           txt_Search   = context.Request["txt_Search"];
            string           Searchwhere  = context.Request["Searchwhere"];
            string           UserGroup_ID = context.Request["UserGroup_ID"]; //用户组主键
            string           User_ID      = context.Request["User_ID"];      //用户主键
            RM_UserInfo_IDAO user_idao    = new RM_UserInfo_Dal();

            switch (Action)
            {
            case "UserList":    //用户信息数据源 返回JSON
                StringBuilder    SqlWhere    = new StringBuilder();
                IList <SqlParam> IList_param = new List <SqlParam>();
                if (!string.IsNullOrEmpty(txt_Search))
                {
                    SqlWhere.Append(" AND " + Searchwhere.Trim() + " like @obj ");
                    IList_param.Add(new SqlParam("@obj", '%' + txt_Search.Trim() + '%'));
                }
                SqlWhere.Append(" AND USER_ID NOT IN(SELECT USER_ID FROM Base_UserInfoUserGroup WHERE UserGroup_ID = @UserGroup_ID)");
                IList_param.Add(new SqlParam("@UserGroup_ID", UserGroup_ID));
                context.Response.Write(JsonHelper.DataTableToJson(user_idao.GetUserInfoInfo(SqlWhere, IList_param), "UserGroupList"));
                context.Response.End();
                break;

            case "UserGroupInfo":    //用户组  返回HTML
                context.Response.Write(InitUserGroupInfo(user_idao.Load_UserInfoUserGroupList(UserGroup_ID)));
                context.Response.End();
                break;

            case "UserGroupaddMember":    //用户组新增成员
                bool IsOk = user_idao.AddUserGroupMenber(User_ID.Split(','), UserGroup_ID);
                if (IsOk)
                {
                    context.Response.Write(1);
                    context.Response.End();
                }
                else
                {
                    context.Response.Write(-1);
                    context.Response.End();
                }
                break;

            default:
                break;
            }
        }
示例#4
0
        //获取上级信息
        private void GetParentIds(HttpContext context)
        {
            string           orgid     = context.Request["orgid"];//
            RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal();
            DataTable        dtOrg     = user_idao.GetOrganizeInfo(orgid);
            string           pids      = "";

            if (dtOrg != null && dtOrg.Rows.Count > 0)
            {
                pids = dtOrg.Rows[0]["ParentIds"].ToString();
            }
            context.Response.Write(pids);
        }
示例#5
0
        /// <summary>
        /// 初始值绑定
        /// </summary>
        private void InitData()
        {
            #region ** 部门下拉框 **

            RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal();
            DataTable        dtOrg     = user_idao.GetOrganizeList(AdminHotelid.Value, HotelId.Value, "0");
            if (dtOrg != null && dtOrg.Rows.Count > 0)
            {
                dOrg.Visible          = true;
                ddlOrg.DataSource     = dtOrg;
                ddlOrg.DataTextField  = "Organization_Name";
                ddlOrg.DataValueField = "Organization_ID";
                ddlOrg.DataBind();
                ddlOrg.Items.Insert(0, new ListItem("==请选择==", ""));
            }
            else
            {
                dOrg.Visible = false;
            }
            #endregion

            CommonMethod.BindCredentials(Credentials_Type);
            #region  ****** 角色下拉框 ******

            DataTable  dt       = new DataTable();
            string     sql_role = "SELECT Roles_ID,Roles_Name FROM Base_Roles WHERE Hotel_Id = @Hotel_Id";
            SqlParam[] param    = new SqlParam[] { new SqlParam("Hotel_Id", HotelId.Value) };

            dt = DataFactory.SqlDataBase().GetDataTableBySQL(new StringBuilder(sql_role), param);
            ddlUser_Role.DataTextField  = "Roles_Name";
            ddlUser_Role.DataValueField = "Roles_ID";
            ddlUser_Role.DataSource     = dt;
            ddlUser_Role.DataBind();


            #endregion
            return;
            //#region ****** 菜单 权限 ******
            //string sql = "SELECT * FROM Base_MenuGroup ORDER BY SortCode";
            //menugroup_dt = DataFactory.SqlDataBase().GetDataTableBySQL(new StringBuilder(sql));

            //DataTable mg_data = menugroup_dt.Clone();//拷贝框架
            //DataRow[] dr = menugroup_dt.Select("ParentId = '0'");
            //for (int i = 0; i < dr.Count(); i++)
            //{
            //    mg_data.ImportRow((DataRow)dr[i]);
            //}
            //rptMenuGroup.DataSource = mg_data;
            //rptMenuGroup.DataBind();
            //#endregion
        }
示例#6
0
        //验证是否有部门
        private void CheckOrg(HttpContext context)
        {
            string           AdminHotelId = context.Request["AdminHotelId"]; //集团id
            string           HotelId      = context.Request["HotelId"];      //酒店id
            RM_UserInfo_IDAO user_idao    = new RM_UserInfo_Dal();
            DataTable        dtOrg        = user_idao.GetOrganizeList(AdminHotelId, HotelId, "0");
            string           pids         = "0";

            if (dtOrg != null && dtOrg.Rows.Count > 0)
            {
                pids = "1";
            }
            context.Response.Write(pids);
        }
示例#7
0
        /// <summary>
        /// 手机 验证码登录
        /// </summary>
        /// <param name="context"></param>
        private void CodeLogin(HttpContext context)
        {
            RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal();
            RM_System_IDAO   sys_idao  = new RM_System_Dal();
            IPScanerHelper   objScan   = new IPScanerHelper();
            string           phone     = context.Request["phone"]; //账户
            string           code      = context.Request["code"];  //验证码

            StringBuilder sql_code = new StringBuilder();

            sql_code.Append("SELECT TOP 1 Code FROM SendRecord WHERE PhoneSubmit = @Phone AND Code = @Code AND CreateTime > DATEADD(mi,-5,GETDATE())");
            SqlParam[] param_code = new SqlParam[] {
                new SqlParam("@Phone", phone),
                new SqlParam("@Code", code)
            };
            DataTable dt_code = DataFactory.SqlDataBase().GetDataTableBySQL(sql_code, param_code);

            if (dt_code != null && dt_code.Rows.Count > 0)
            {
                DataTable dtlogin = user_idao.PhoneLogin(phone.Trim());
                if (dtlogin != null && dtlogin.Rows.Count > 0)
                {
                    objScan.DataPath = context.Server.MapPath("/Themes/IPScaner/QQWry.Dat");
                    objScan.IP       = RequestHelper.GetIP();
                    string OWNER_address = objScan.IPLocation();
                    LoginInfo(context, dtlogin, OWNER_address);
                    context.Response.Write("1");//验证成功
                    return;
                }
                else
                {
                    context.Response.Write("10012");//手机号不存在!
                }
            }
            else
            {
                context.Response.Write("10011");//验证码错误或超时!
            }
        }
示例#8
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType     = "text/plain";
            context.Response.Buffer          = true;
            context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1.0);
            context.Response.AddHeader("pragma", "no-cache");
            context.Response.AddHeader("cache-control", "");
            context.Response.CacheControl = "no-cache";
            string           DepID     = context.Request["Sector"];
            string           username  = context.Request["username"];
            string           StartTime = context.Request["onLine"];
            RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal();


            if (DepID == null)
            {
                DataTable dtGPS = user_idao.GetUserGPS();
                if (dtGPS != null)
                {
                    if (dtGPS.Rows.Count != 0)
                    {
                        string Con = JsonHelper.DataTableToJson(dtGPS);
                        context.Response.Write(Con);
                        context.Response.End();
                    }
                    else
                    {
                        context.Response.Write("");
                        context.Response.End();
                    }
                }
                else
                {
                    context.Response.Write("");
                    context.Response.End();
                }
            }
        }
示例#9
0
        //获取部门信息
        private void GetOrgSelect(HttpContext context)
        {
            string           AdminHotelId = context.Request["AdminHotelId"]; //集团id
            string           HotelId      = context.Request["HotelId"];      //酒店id
            string           orgid        = context.Request["orgid"];        //
            RM_UserInfo_IDAO user_idao    = new RM_UserInfo_Dal();
            DataTable        dtOrg        = user_idao.GetOrganizeList(AdminHotelId, HotelId, orgid);
            string           json         = "";

            if (dtOrg != null && dtOrg.Rows.Count > 0)
            {
                JsonData jsondata = new JsonData();
                jsondata["list"] = new JsonData();
                for (int i = 0; i < dtOrg.Rows.Count; i++)
                {
                    JsonData jd = new JsonData();
                    jd["Organization_ID"]   = dtOrg.Rows[i]["Organization_ID"].ToString();
                    jd["Organization_Name"] = dtOrg.Rows[i]["Organization_Name"].ToString();
                    jsondata["list"].Add(jd);
                }
                json = jsondata.ToJson();
            }
            context.Response.Write(json);
        }
示例#10
0
        /// <summary>
        /// 获取用户权限
        /// </summary>
        private void GetUserMenus()
        {
            RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal();

            hdMenus.Value = user_idao.InitUserRight(RequestSession.GetSessionUser().UserId.ToString(), "用户管理系统");//获取用户对应菜单的权限
        }
示例#11
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType     = "text/plain";
            context.Response.Buffer          = true;
            context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1.0);
            context.Response.AddHeader("pragma", "no-cache");
            context.Response.AddHeader("cache-control", "");
            context.Response.CacheControl = "no-cache";
            string           Action       = context.Request["action"];
            string           user_Account = context.Request["user_Account"];
            string           userPwd      = context.Request["userPwd"];
            string           code         = context.Request["code"];
            RM_UserInfo_IDAO user_idao    = new RM_UserInfo_Dal();
            RM_System_IDAO   sys_idao     = new RM_System_Dal();
            IPScanerHelper   objScan      = new IPScanerHelper();
            string           text         = Action;


            if (text != null)
            {
                if (text == "Menu")
                {
                    string UserId   = RequestSession.GetSessionUser().UserId.ToString();
                    string strMenus = JsonHelper.DataTableToJson(sys_idao.GetMenuHtml(UserId), "MENU");
                    context.Response.Write(strMenus);
                    context.Response.End();
                }
                else if (text == "login")
                {
                    if (code.ToLower() != context.Session["dt_session_code"].ToString().ToLower())
                    {
                        context.Response.Write("1");
                        context.Response.End();
                    }


                    DataTable dtlogin = user_idao.UserLogin(user_Account.Trim(), userPwd.Trim());

                    if (dtlogin != null)
                    {
                        objScan.DataPath = context.Server.MapPath("/Themes/IPScaner/QQWry.Dat");
                        //objScan.IP = RequestHelper.GetIP();
                        //string OWNER_address = objScan.IPLocation();

                        objScan.IP = "127.0.0.1";
                        string OWNER_address = "内网IP";

                        if (dtlogin.Rows.Count != 0)
                        {
                            user_idao.SysLoginLog(user_Account, "1", OWNER_address);
                            if (dtlogin.Rows[0]["DeleteMark"].ToString() == "1")
                            {
                                if (this.Islogin(context, user_Account))
                                {
                                    RequestSession.AddSessionUser(new SessionUser
                                    {
                                        UserId      = dtlogin.Rows[0]["User_ID"].ToString(),
                                        UserAccount = dtlogin.Rows[0]["User_Account"].ToString(),
                                        UserName    = dtlogin.Rows[0]["User_Name"].ToString() + "(" + dtlogin.Rows[0]["User_Account"].ToString() + ")",
                                        UserPwd     = dtlogin.Rows[0]["User_Pwd"].ToString()
                                    });
                                    context.Response.Write("3");
                                    context.Response.End();
                                }
                                else
                                {
                                    context.Response.Write("6");
                                    context.Response.End();
                                }
                            }
                            else
                            {
                                user_idao.SysLoginLog(user_Account, "2", OWNER_address);
                                context.Response.Write("2");
                                context.Response.End();
                            }
                        }
                        else
                        {
                            user_idao.SysLoginLog(user_Account, "0", OWNER_address);
                            context.Response.Write("4");
                            context.Response.End();
                        }
                    }
                    else
                    {
                        context.Response.Write("5");
                        context.Response.End();
                    }
                }
            }
        }
示例#12
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType     = "text/plain";
            context.Response.Buffer          = true;
            context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1.0);
            context.Response.AddHeader("pragma", "no-cache");
            context.Response.AddHeader("cache-control", "");
            context.Response.CacheControl = "no-cache";
            string           Action       = context.Request["action"].Trim();
            string           txt_Search   = context.Request["txt_Search"];
            string           Searchwhere  = context.Request["Searchwhere"];
            string           UserGroup_ID = context.Request["UserGroup_ID"];
            string           User_ID      = context.Request["User_ID"];
            RM_UserInfo_IDAO user_idao    = new RM_UserInfo_Dal();
            string           text         = Action;

            if (text != null)
            {
                if (!(text == "UserList"))
                {
                    if (!(text == "UserGroupInfo"))
                    {
                        if (text == "UserGroupaddMember")
                        {
                            bool IsOk = user_idao.AddUserGroupMenber(User_ID.Split(new char[]
                            {
                                ','
                            }), UserGroup_ID);
                            if (IsOk)
                            {
                                context.Response.Write(1);
                                context.Response.End();
                            }
                            else
                            {
                                context.Response.Write(-1);
                                context.Response.End();
                            }
                        }
                    }
                    else
                    {
                        context.Response.Write(this.InitUserGroupInfo(user_idao.Load_UserInfoUserGroupList(UserGroup_ID)));
                        context.Response.End();
                    }
                }
                else
                {
                    StringBuilder    SqlWhere    = new StringBuilder();
                    IList <SqlParam> IList_param = new List <SqlParam>();
                    if (!string.IsNullOrEmpty(txt_Search))
                    {
                        SqlWhere.Append(" AND " + Searchwhere.Trim() + " like @obj ");
                        IList_param.Add(new SqlParam("@obj", '%' + txt_Search.Trim() + '%'));
                    }
                    SqlWhere.Append(" AND USER_ID NOT IN(SELECT USER_ID FROM Base_UserInfoUserGroup WHERE UserGroup_ID = @UserGroup_ID)");
                    IList_param.Add(new SqlParam("@UserGroup_ID", UserGroup_ID));
                    context.Response.Write(JsonHelper.DataTableToJson(user_idao.GetUserInfoInfo(SqlWhere, IList_param), "UserGroupList"));
                    context.Response.End();
                }
            }
        }
示例#13
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType     = "text/plain";
            context.Response.Buffer          = true;
            context.Response.ExpiresAbsolute = DateTime.Now.AddDays(-1);
            context.Response.AddHeader("pragma", "no-cache");
            context.Response.AddHeader("cache-control", "");
            context.Response.CacheControl = "no-cache";
            string           Action       = context.Request["action"];       //提交动作
            string           user_Account = context.Request["user_Account"]; //账户
            string           userPwd      = context.Request["userPwd"];      //密码
            string           code         = context.Request["code"];         //验证码
            RM_UserInfo_IDAO user_idao    = new RM_UserInfo_Dal();
            RM_System_IDAO   sys_idao     = new RM_System_Dal();
            IPScanerHelper   objScan      = new IPScanerHelper();

            switch (Action)
            {
            case "login":
                if (code.ToLower() != context.Session["dt_session_code"].ToString().ToLower())
                {
                    context.Response.Write("1");    //验证码输入不正确!
                    context.Response.End();
                }
                DataTable dtlogin = user_idao.UserLogin(user_Account.Trim(), userPwd.Trim());
                if (dtlogin != null)
                {
                    objScan.DataPath = context.Server.MapPath("/Themes/IPScaner/QQWry.Dat");
                    objScan.IP       = RequestHelper.GetIP();
                    string OWNER_address = objScan.IPLocation();
                    if (dtlogin.Rows.Count != 0)
                    {
                        user_idao.SysLoginLog(user_Account, "1", OWNER_address);
                        if (dtlogin.Rows[0]["DeleteMark"].ToString() == "1" && dtlogin.Rows[0]["work_flag"].ToString() == "1")
                        {
                            if (Islogin(context, user_Account))
                            {
                                SessionUser user = new SessionUser();
                                user.UserId      = dtlogin.Rows[0]["User_ID"].ToString();
                                user.UserAccount = dtlogin.Rows[0]["User_Account"].ToString();
                                user.UserName    = dtlogin.Rows[0]["User_Name"].ToString() + "(" + dtlogin.Rows[0]["User_Account"].ToString() + ")";
                                user.UserPwd     = dtlogin.Rows[0]["User_Pwd"].ToString();
                                RequestSession.AddSessionUser(user);
                                context.Response.Write("3");    //验证成功
                                context.Response.End();
                            }
                            else
                            {
                                context.Response.Write("6");    //该用户已经登录,不允许重复登录
                                context.Response.End();
                            }
                        }
                        else
                        {
                            user_idao.SysLoginLog(user_Account, "2", OWNER_address);    //账户被锁,联系管理员!
                            context.Response.Write("2");
                            context.Response.End();
                        }
                    }
                    else
                    {
                        user_idao.SysLoginLog(user_Account, "0", OWNER_address);
                        context.Response.Write("4");    //账户或者密码有错误!
                        context.Response.End();
                    }
                }
                else
                {
                    context.Response.Write("5");    //服务连接不上!
                    context.Response.End();
                }
                break;

            case "Menu":
                string UserId   = RequestSession.GetSessionUser().UserId.ToString();  //用户ID
                string strMenus = JsonHelper.DataTableToJson(sys_idao.GetMenuHtml(UserId), "MENU");
                context.Response.Write(strMenus);
                context.Response.End();
                break;

            default:
                break;
            }
        }
示例#14
0
        /// <summary>
        /// 公共一般处理程序
        /// </summary>
        /// <param name="context"></param>
        public void ProcessRequest(HttpContext context)
        {
            string         Action     = context.Request["action"];    //提交动作
            string         module     = context.Request["module"];    //业务模块
            string         tableName  = context.Request["tableName"]; //数据库表
            string         pkName     = context.Request["pkName"];    //字段主键
            string         pkVal      = context.Request["pkVal"];     //字段值
            int            Return     = -1;
            RM_System_IDAO systemidao = new RM_System_Dal();

            switch (Action)
            {
            case "DeleteP":                      //删除多条记录 1,2,3,4,5,6
                Return = DataFactory.SqlDataBase().BatchDeleteData(tableName.Trim(), pkName.Trim(), pkVal.Split(','));
                if (Return > 0)
                {
                    CommonMethod.Base_Log("删除", tableName.Trim(), pkName.Trim() + ":" + pkVal, module.Trim(), "删除id:" + pkVal);    //操作记录
                }
                context.Response.Write(Return.ToString());
                break;

            case "AdminDelete":                      //删除多条记录 1,2,3,4,5,6
                Return = DataFactory.SqlDataBase().BatchDeleteData(tableName.Trim(), pkName.Trim(), pkVal.Split(','));
                if (Return > 0)
                {
                    //CommonMethod.Base_Log("删除", tableName.Trim(), pkName.Trim() + ":" + pkVal, module.Trim(), "删除id:" + pkVal);//操作记录
                }
                context.Response.Write(Return.ToString());
                break;

            case "ISDelete":                      //逻辑删除数据

                string[] s = pkVal.Split(',');

                for (int i = 0; i < s.Length; i++)
                {
                    Hashtable ht = new Hashtable();
                    ht["DeleteMark"] = 0;
                    Return           = DataFactory.SqlDataBase().UpdateByHashtable(tableName.Trim(), pkName.Trim(), s[i], ht);
                }
                if (Return > 0)
                {
                    CommonMethod.Base_Log("删除", tableName.Trim(), pkName.Trim() + ":" + pkVal, module.Trim(), "删除id:" + pkVal);    //操作记录
                }

                context.Response.Write(Return.ToString());
                break;

            case "GetMenus":
                string ru = "0";
                if (RequestSession.GetSessionUser() == null)
                {
                    context.Response.Write(0);
                }
                else
                {
                    RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal();
                    ru = user_idao.InitUserRight(RequestSession.GetSessionUser().UserId.ToString(), pkName);    //获取用户对应菜单的权限
                }
                context.Response.Write(ru);
                break;

            default:
                break;
            }
        }
示例#15
0
        private void SwitchLogin(string user_Account, string userPwd, string AdminHotelid)
        {
            RM_UserInfo_IDAO user_idao = new RM_UserInfo_Dal();



            StringBuilder strSql = new StringBuilder();

            strSql.Append(@"select top 1 * from V_Login where ");
            strSql.Append("User_Account=@User_Account ");
            strSql.Append("and User_Pwd=@User_Pwd ");
            strSql.Append("and AdminHotelid=@AdminHotelid ");
            SqlParam[] para =
            {
                new SqlParam("@AdminHotelid", AdminHotelid),
                new SqlParam("@User_Account", user_Account),
                new SqlParam("@User_Pwd",     userPwd)
            };
            DataTable dtlogin = DataFactory.SqlDataBase().GetDataTableBySQL(strSql, para);

            if (dtlogin != null)
            {
                IPScanerHelper objScan = new IPScanerHelper();
                objScan.DataPath = Server.MapPath("/Themes/IPScaner/QQWry.Dat");
                objScan.IP       = RequestHelper.GetIP();
                string OWNER_address = objScan.IPLocation();
                if (dtlogin.Rows.Count != 0)
                {
                    if (dtlogin.Rows[0]["DeleteMark"].ToString() == "1")
                    {
                        user_idao.SysLoginLog(1, 10, user_Account, "1", OWNER_address, dtlogin.Rows[0]["User_ID"].ToString(), AdminHotelid);
                        SessionUser user = new SessionUser();
                        user.UserId       = dtlogin.Rows[0]["User_ID"].ToString();
                        user.UserAccount  = dtlogin.Rows[0]["User_Account"].ToString();
                        user.UserName     = dtlogin.Rows[0]["User_Name"].ToString() + "(" + dtlogin.Rows[0]["User_Account"].ToString() + ")";
                        user.UserPwd      = dtlogin.Rows[0]["User_Pwd"].ToString();
                        user.AdminHotelid = dtlogin.Rows[0]["AdminHotelid"].ToString();
                        user.Hotelid      = dtlogin.Rows[0]["Hotelid"].ToString();
                        user.HotelListId  = dtlogin.Rows[0]["HotelListId"].ToString();
                        user.IsAdmin      = dtlogin.Rows[0]["IsAdmin"].ToString();
                        RequestSession.AddSessionUser(user);

                        HttpCookie cookies = new HttpCookie("LoginUser_CK");
                        cookies.Values.Clear();
                        cookies.Expires = DateTime.Now.AddDays(1);
                        cookies.Values.Add("User_ID", user.UserId.ToString());
                        cookies.Values.Add("User_Account", user.UserAccount.ToString());
                        cookies.Values.Add("AdminHotelid", user.AdminHotelid.ToString());
                        cookies.Values.Add("Hotelid", user.Hotelid.ToString());
                        cookies.Values.Add("User_Name", user.UserName.ToString());
                        cookies.Values.Add("UserPwd", user.UserPwd.ToString());
                        cookies.Values.Add("HotelListId", user.HotelListId.ToString());
                        cookies.Values.Add("IsAdmin", user.IsAdmin.ToString());
                        Response.AppendCookie(cookies);

                        this.Response.Write("<script lanuage=javascript>top.location='/Frame/MainDefault.aspx'</script>");
                    }
                    else
                    {
                        user_idao.SysLoginLog(1, 10, user_Account, "2", OWNER_address, "", dtlogin.Rows[0]["AdminHotelid"].ToString());//账户被锁,联系管理员!
                    }
                }
                else
                {
                    user_idao.SysLoginLog(1, 10, user_Account, "0", OWNER_address, "", "");
                }
            }
        }