Exemplo n.º 1
0
            public void History_write(string user_id, string _page, string _state)
            {
                db_e db = new db_e();

                string user_name       = UserData.user_get(user_id, "user_name");
                string department_id   = UserData.user_get(user_id, "department_id");
                string department_name = UserData.user_get(user_id, "department_name");
                string company_id      = UserData.user_get(user_id, "company_id");
                string company_name    = UserData.user_get(user_id, "company_name");
                string auth            = UserData.user_get(user_id, "auth");

                var _insert = new history
                {
                    user_id       = user_id,
                    company_id    = company_id,
                    department_id = department_id,
                    user_ip       = "",
                    pre_page      = "",
                    connect_agent = company_name,
                    connect_host  = auth,
                    connect_path  = user_name,
                    memo          = department_name,
                    connect_date  = DateTime.Now,
                    state         = _state,
                    page          = _page
                };

                db.history.Add(_insert);
                db.SaveChanges(); // 실제로 저장
            }
Exemplo n.º 2
0
        // string language = Request.Cookies["language"].Value ?? "korea";
        public static string language_code(string language_code, string code)
        {
            db_e db = new db_e();

            code = code.Trim();

            string _language_code = "korea";

            if (language_code == "korea")
            {
                _language_code = (from a in db.language
                                  where a.code_name.Equals(code)
                                  select a.korea).FirstOrDefault();
            }

            else if (language_code == "english")
            {
                _language_code = (from a in db.language
                                  where a.code_name.Equals(code)
                                  select a.english).FirstOrDefault();
            }

            return(_language_code);
        }
Exemplo n.º 3
0
            public static string user_get(string user_id, string what)
            {
                db_e db = new db_e();

                string company_id      = "BlueEye";
                string company_name    = "BlueEye";
                string user_name       = "";
                int    department_idx  = 0;
                int    company_idx     = 0;
                string department_name = "";
                int    auth            = 0; //초기 :0
                string user_auth       = "";
                var    _list           = (from a in db.user.Include(p => p.company_idxNavigation).Include(p => p.department_idxNavigation) where a.user_id == user_id select a).Single();



                if (_list != null)
                {
                    company_id      = _list.company_idxNavigation.company_id;
                    company_name    = _list.company_idxNavigation.company_name;
                    company_idx     = _list.company_idxNavigation.idx;
                    department_name = _list.department_idxNavigation.department_name;
                    user_name       = _list.user_name;
                    department_idx  = _list.department_idx;
                    auth            = _list.check_auth; //최고 권한 관리자 :9 , 회사별 권한 관리자 : 8 , 부서장 : 7
                    user_auth       = _list.user_auth;  //페이지 권한
                }

                string str = "";


                if (what == "user_id")
                {
                    str = user_id;
                }
                else if (what == "user_name")
                {
                    str = user_name;
                }
                else if (what == "company_id")
                {
                    str = company_id;
                }
                else if (what == "company_idx")
                {
                    str = company_idx.ToString();
                }
                else if (what == "company_name")
                {
                    str = company_name;
                }
                else if (what == "department_idx")
                {
                    str = department_idx.ToString();
                }
                else if (what == "department_name")
                {
                    str = department_name;
                }
                else if (what == "auth")
                {
                    str = auth.ToString();
                }
                else if (what == "user_auth")
                {
                    str = user_auth.ToString();
                }

                return(str);
            }