private void SetResultGrid() { string sDeptID = string.Empty; string sUserNM = string.Empty; string sSDT = string.Empty; string sEDT = string.Empty; sDeptID = txtDeptID.Text + "%"; sUserNM = txtUserNM.Text + "%"; if (wdcSDate.Value != null) { sSDT = wdcSDate.Text.ToString().Replace("-", ""); sEDT = Convert.ToDateTime(wdcEDate.Text).AddDays(1).ToShortDateString().Replace("-", ""); } else { sSDT = "20000101"; sEDT = "99990101"; //sSDT = DateTime.Now.ToShortDateString().Replace("-", ""); //sEDT = DateTime.Now.AddDays(1).ToShortDateString().Replace("-", ""); } MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common Biz = new MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common(); int iTotalRows = Biz.GetConnectLogCount(sDeptID, sUserNM, sSDT, sEDT); int iLastPage = (int)Math.Ceiling((Double)iTotalRows / ugrdResultStatus.DisplayLayout.Pager.PageSize); int iFirstRow = (ugrdResultStatus.DisplayLayout.Pager.CurrentPageIndex - 1) * ugrdResultStatus.DisplayLayout.Pager.PageSize; int iLastRow = ugrdResultStatus.DisplayLayout.Pager.CurrentPageIndex * ugrdResultStatus.DisplayLayout.Pager.PageSize; ViewState.Add("CurrentPageIndex", ugrdResultStatus.DisplayLayout.Pager.CurrentPageIndex); ViewState.Add("PageCount", iLastPage); DataTable dt = Biz.GetConnectLog(sDeptID, sUserNM, sSDT, sEDT, iFirstRow + 1, iLastRow); ugrdResultStatus.Clear(); ugrdResultStatus.DataSource = dt; ugrdResultStatus.DataBind(); //DataRow[] row = dt.Select(" SEQ < 3 AND "); //DataTypeUtility.FilterSortDataTable(dt,""); //DataTypeUtility.GetBoolean (""); lblRowCount.Text = iTotalRows.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Context.User.Identity.IsAuthenticated) { SiteIdentity gUserInfo = (SiteIdentity)Context.User.Identity; MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common Biz = new MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common(); Biz.ModifyConnectLog(Session.SessionID, gUserInfo.LoginID); } FormsAuthentication.SignOut(); string login_page_url = WebUtility.GetConfig("Login_Page_Url", "~/base/Login.aspx"); Response.Redirect(login_page_url); }
protected void Page_Load(object sender, EventArgs e) { MicroBSC.RolesBasedAthentication.SitePrincipal newUser = null; int login_status = LOGIN_STATUS; string user_id = USER_ID; string login_page_url = WebUtility.GetConfig("Login_Page_Url", "~/base/Login.aspx"); //int login_status = 3; //string user_id = "admin"; if (login_status > 0 && !user_id.Equals("-1")) { LOGIN_STATUS = -4; USER_ID = string.Empty; MicroBSC.Biz.Common.EmpInfos emp = new MicroBSC.Biz.Common.EmpInfos(); int emp_ref_id = emp.ValidateLogin(user_id); if (emp_ref_id.Equals(0)) { FormsAuthentication.SignOut(); Response.Redirect(login_page_url); return; } newUser = new MicroBSC.RolesBasedAthentication.SitePrincipal(user_id); Context.User = newUser; MicroBSC.RolesBasedAthentication.SiteIdentity gUserInfo = (MicroBSC.RolesBasedAthentication.SiteIdentity)Context.User.Identity; MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common objCtlCommon = new MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common(); objCtlCommon.AddConnectLog(Session.SessionID, gUserInfo.Emp_Ref_ID, gUserInfo.LoginID, gUserInfo.Emp_Name, Request.UserHostAddress, "BSC"); FormsAuthentication.RedirectFromLoginPage(user_id, false); Response.Redirect("~/base/Main.aspx"); } else { FormsAuthentication.SignOut(); Response.Redirect(login_page_url); } }
private void DoAction(int LOGIN_STATUS, string USER_ID) { //페이지 열릴대마다 로그 기록 writeLog(string.Format("{0} : DoAction() START", Request.PhysicalPath)); MicroBSC.RolesBasedAthentication.SitePrincipal newUser = null; int login_status = LOGIN_STATUS; string user_id = USER_ID; string login_page_url = WebUtility.GetConfig("Login_Page_Url", "~/base/Login.aspx"); if (WebUtility.GetConfig("SSL", "N").Equals("Y")) { if (WebUtility.GetConfig("SSLLIVE", "N").Equals("Y")) { login_page_url = WebUtility.GetConfig("SSL.LoginPageLive", "~/base/Login.aspx"); } else { login_page_url = WebUtility.GetConfig("SSL.LoginPage", "~/base/Login.aspx"); } } //int login_status = 3; //string user_id = "admin"; if (login_status > 0 && !user_id.Equals("-1")) { LOGIN_STATUS = -4; USER_ID = string.Empty; MicroBSC.Biz.Common.EmpInfos emp = new MicroBSC.Biz.Common.EmpInfos(); int emp_ref_id = emp.ValidateLogin(user_id); if (emp_ref_id.Equals(0)) { FormsAuthentication.SignOut(); Response.Redirect(login_page_url); return; } newUser = new MicroBSC.RolesBasedAthentication.SitePrincipal(user_id); Context.User = newUser; MicroBSC.RolesBasedAthentication.SiteIdentity gUserInfo = (MicroBSC.RolesBasedAthentication.SiteIdentity)Context.User.Identity; if (WebUtility.GetConfig("LOG_SIGNON", "N").Equals("Y")) { MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common objCtlCommon = new MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common(); objCtlCommon.AddConnectLog(Session.SessionID, gUserInfo.Emp_Ref_ID, gUserInfo.LoginID, gUserInfo.Emp_Name, Request.UserHostAddress, "BSC"); } //페이지 열릴대마다 로그 기록 writeLog(string.Format("{0} : DoAction() END", Request.PhysicalPath)); FormsAuthentication.RedirectFromLoginPage(user_id, false); Response.Redirect("~/base/Main.aspx"); } else { //페이지 열릴대마다 로그 기록 writeLog(string.Format("{0} : DoAction() END", Request.PhysicalPath)); FormsAuthentication.SignOut(); Response.Redirect(login_page_url); } }
protected void loginbtn_Click(object sender, ImageClickEventArgs e) { string bscAuth = ConfigurationManager.AppSettings["BSC.Authentication"].ToString(); string domainName = ConfigurationManager.AppSettings["Domain.Name"].ToString(); SitePrincipal newUser = null; string en_use_yn = WebUtility.GetConfig("ENCRYPTION_USE_YN").ToUpper(); string encryption_oneway_mode = WebUtility.GetConfig("ENCRYPTION_ONEWAY_MODE").ToUpper(); string encPasswd; if (en_use_yn.Equals("Y")) { encPasswd = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPasswd.Text, encryption_oneway_mode); } else { encPasswd = txtPasswd.Text; } if (bscAuth.Equals("Forms")) // 폼 인증 { newUser = SitePrincipal.ValidateLogin(txtLoginID.Text, encPasswd); } else if (bscAuth.Equals("Windows")) // 윈도우 인증 & 폼인증 { if (WindowAuthentication.ValidateLogin(txtLoginID.Text, encPasswd, domainName, Context)) { newUser = new SitePrincipal(txtLoginID.Text); } } if (newUser == null) { MicroBSC.Integration.COM.Biz.Biz_Com_Emp_Info bizEmpInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Emp_Info(); string emp_ref_id = bizEmpInfo.Get_Emp_Ref_Id(txtLoginID.Text); if (emp_ref_id.Length == 0) { //ID가 없음 this.ltrScript.Text = JSHelper.GetAlertScript("ID가 존재하지 않습니다."); txtLoginID.Focus(); } else { //비번이 틀림 this.ltrScript.Text = JSHelper.GetAlertScript("비밀번호가 틀렸습니다."); txtPasswd.Focus(); } } else { Context.User = newUser; SaveUserID(txtLoginID.Text, true); // 쿠키 저장 여부 //login.SetUserLogs(txtUserID.Text, Request.ServerVariables["REMOTE_ADDR"].ToString(), Request.ServerVariables["HTTP_USER_AGENT"].ToString(), Session.SessionID); SiteIdentity gUserInfo = (SiteIdentity)Context.User.Identity; //MicroBSC.Integration.CTL.Dac.Dac_Ctl_Common log = new MicroBSC.Integration.CTL.Dac.Dac_Ctl_Common(); //log.InsertConnectLog(Session.SessionID, gUserInfo.Emp_Ref_ID, gUserInfo.LoginID, gUserInfo.Emp_Name, Request.UserHostAddress, "BSC"); MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common objCtlCommon = new MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common(); objCtlCommon.AddConnectLog(Session.SessionID, gUserInfo.Emp_Ref_ID, gUserInfo.LoginID, gUserInfo.Emp_Name, Request.UserHostAddress, "BSC"); FormsAuthentication.RedirectFromLoginPage(txtLoginID.Text, false); Response.Redirect("Main.aspx"); //if (Request["ReturnUrl"] != null) //{ // //Response.Cookies["GSBNPortalWeb"].Expires = DateTime.Today.AddDays(-1); // //Response.Cookies["GSBNPortalWeb"].Value = null; // FormsAuthentication.RedirectFromLoginPage(txtLoginID.Text, false); // Response.Redirect("../index.aspx?" + "ReturnUrl=" + Request["ReturnUrl"]); //} //else //{ // FormsAuthentication.RedirectFromLoginPage(txtLoginID.Text, false); //} } }
protected void loginbtn_Click(object sender, ImageClickEventArgs e) { //세션ID 업데이트 Session.Abandon(); Response.Cookies.Add(new HttpCookie("ASP.NET_SessionId", "")); string bscAuth = ConfigurationManager.AppSettings["BSC.Authentication"].ToString(); string domainName = ConfigurationManager.AppSettings["Domain.Name"].ToString(); SitePrincipal newUser = null; string en_use_yn = WebUtility.GetConfig("ENCRYPTION_USE_YN").ToUpper(); string encryption_oneway_mode = WebUtility.GetConfig("ENCRYPTION_ONEWAY_MODE").ToUpper(); string encPasswd; if (en_use_yn.Equals("Y")) { encPasswd = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPasswd.Text, encryption_oneway_mode); } else { encPasswd = txtPasswd.Text; } int loginResult = 0; int max_login_failcnt = DataTypeUtility.GetToInt32(WebUtility.GetConfig("MAX_LOGIN_FAILCNT", "5")); if (bscAuth.Equals("Forms")) // 폼 인증 { //newUser = SitePrincipal.ValidateLogin(txtLoginID.Text, encPasswd); loginResult = SitePrincipal.ValidateLogin(txtLoginID.Text, encPasswd, max_login_failcnt, out newUser); //로그인 시도 허용횟수 검사 } else if (bscAuth.Equals("Windows")) // 윈도우 인증 & 폼인증 { if (WindowAuthentication.ValidateLogin(txtLoginID.Text, encPasswd, domainName, Context)) { newUser = new SitePrincipal(txtLoginID.Text); } } if (newUser == null) { //MicroBSC.Integration.COM.Biz.Biz_Com_Emp_Info bizEmpInfo = new MicroBSC.Integration.COM.Biz.Biz_Com_Emp_Info(); //string emp_ref_id = bizEmpInfo.Get_Emp_Ref_Id(txtLoginID.Text); //if (emp_ref_id.Length == 0) //{ // //ID가 없음 // this.ltrScript.Text = JSHelper.GetAlertScript("ID가 존재하지 않습니다."); // txtLoginID.Focus(); //} //else //{ // //비번이 틀림 // this.ltrScript.Text = JSHelper.GetAlertScript("비밀번호가 틀렸습니다."); // txtPasswd.Focus(); //} if (loginResult == 0) { this.ltrScript.Text = JSHelper.GetAlertScript("ID 또는 비밀번호가 틀렸습니다."); txtPasswd.Focus(); } else if (loginResult == -1) { this.ltrScript.Text = JSHelper.GetAlertScript("로그인 시도 횟수가 초과되었습니다. 관리자에게 문의하세요."); txtPasswd.Focus(); } else { this.ltrScript.Text = JSHelper.GetAlertScript("관리자에게 문의하세요."); txtPasswd.Focus(); } } else { Context.User = newUser; SaveUserID(txtLoginID.Text, true); // 쿠키 저장 여부 //login.SetUserLogs(txtUserID.Text, Request.ServerVariables["REMOTE_ADDR"].ToString(), Request.ServerVariables["HTTP_USER_AGENT"].ToString(), Session.SessionID); SiteIdentity gUserInfo = (SiteIdentity)Context.User.Identity; //MicroBSC.Integration.CTL.Dac.Dac_Ctl_Common log = new MicroBSC.Integration.CTL.Dac.Dac_Ctl_Common(); //log.InsertConnectLog(Session.SessionID, gUserInfo.Emp_Ref_ID, gUserInfo.LoginID, gUserInfo.Emp_Name, Request.UserHostAddress, "BSC"); if (WebUtility.GetConfig("LOG_SIGNON", "N").Equals("Y")) { MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common objCtlCommon = new MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common(); objCtlCommon.AddConnectLog(Session.SessionID, gUserInfo.Emp_Ref_ID, gUserInfo.LoginID, gUserInfo.Emp_Name, Request.UserHostAddress, "BSC"); } if (WebUtility.GetConfig("SSL", "N").Equals("N")) { FormsAuthentication.RedirectFromLoginPage(txtLoginID.Text, false); Response.Redirect("Main.aspx"); } else { if (WebUtility.GetConfig("SSLLIVE", "N").Equals("Y")) { FormsAuthentication.RedirectFromLoginPage(txtLoginID.Text, false); Response.Redirect(WebUtility.GetConfig("SSL.MainPageLive", "Main.aspx")); } else { FormsAuthentication.RedirectFromLoginPage(txtLoginID.Text, false); Response.Redirect(WebUtility.GetConfig("SSL.MainPage", "Main.aspx")); } } //if (Request["ReturnUrl"] != null) //{ // //Response.Cookies["GSBNPortalWeb"].Expires = DateTime.Today.AddDays(-1); // //Response.Cookies["GSBNPortalWeb"].Value = null; // FormsAuthentication.RedirectFromLoginPage(txtLoginID.Text, false); // Response.Redirect("../index.aspx?" + "ReturnUrl=" + Request["ReturnUrl"]); //} //else //{ // FormsAuthentication.RedirectFromLoginPage(txtLoginID.Text, false); //} } }
protected void iBtnAdd_Click(object sender, ImageClickEventArgs e) { Biz_MenuInfo objMenuInfo = new Biz_MenuInfo(); DataTable dataTable = objMenuInfo.GetDataTableSchema(); dataTable = UltraGridUtility.GetDataTableByCheckValue(this.UltraWebGrid1 , "cBox" , "selchk" , new string[] { "MENU_REF_ID", "UP_MENU_ID", "MENU_NAME", "MENU_DIR", "MENU_PAGE_NAME", "MENU_PARAM", "MENU_FULL_PATH" , "MENU_DESC", "MENU_PRIORITY", "MENU_AUTH_TYPE", "MENU_TYPE", "MENU_NAME_IMAGE_PATH", "MENU_NAME_IMAGE_PATH_U" , "MENU_PREV_ICON_PATH", "MENU_CREATE_DATE", "SHOW_LEFT_MENU" } , dataTable); MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common bizCustom = new MicroBSC.Integration.CTL.Biz.Biz_Ctl_Common(); int okCnt = bizCustom.AddMenuRole(dataTable, ddlRoles.SelectedValue); //RoleInfos role = new RoleInfos(); //role.RemoveRoleMenu(); //role.AddRoleMenu(int.Parse(ddlRoles.SelectedValue), int.Parse(hdfMenu_Ref_ID.Value)); //WebCommon.SetRoleDropDownList(ddlRoles, int.Parse(hdfMenu_Ref_ID.Value)); //DataBindingMenuRole(int.Parse(hdfMenu_Ref_ID.Value)); CheckMenuRoleCount(); GridBindginMenu(); //Biz_MenuInfo objMenuInfo = new Biz_MenuInfo(); //DataTable blankDataTable = new DataTable(); //blankDataTable.Columns.Add("ROLE_REF_ID", typeof(string)); //blankDataTable.Columns.Add("MENU_REF_ID", typeof(string)); ////dataTable = UltraGridUtility.GetDataTableByCheckValue(this.UltraWebGrid1 //// , "cBox" //// , "selchk" //// , new string[] { "MENU_REF_ID", "UP_MENU_ID", "MENU_NAME", "MENU_DIR", "MENU_PAGE_NAME", "MENU_PARAM", "MENU_FULL_PATH" //// , "MENU_DESC", "MENU_PRIORITY", "MENU_AUTH_TYPE", "MENU_TYPE", "MENU_NAME_IMAGE_PATH", "MENU_NAME_IMAGE_PATH_U" //// , "MENU_PREV_ICON_PATH", "MENU_CREATE_DATE", "SHOW_LEFT_MENU","MENU_ROLE" } //// , dataTable); //foreach (UltraGridRow ugRow in UltraWebGrid1.Rows) //{ // TemplatedColumn col_cBox = (TemplatedColumn)ugRow.Band.Columns.FromKey("selchk"); // CheckBox cBox = (CheckBox)((CellItem)col_cBox.CellItems[ugRow.BandIndex]).FindControl("cBox"); // if (cBox.Checked) // { // DataRow dataRow = blankDataTable.NewRow(); // TemplatedColumn col_ddl = (TemplatedColumn)ugRow.Band.Columns.FromKey("MENU_ROLE"); // DropDownList colDDL = (DropDownList)((CellItem)col_ddl.CellItems[ugRow.BandIndex]).FindControl("ddlMenuRole"); // dataRow["ROLE_REF_ID"] = colDDL.SelectedValue; // dataRow["MENU_REF_ID"] = ugRow.Cells.FromKey("MENU_REF_ID").Value; // blankDataTable.Rows.Add(dataRow); // } //} //object a = this.UltraWebGrid1.Rows[1].Cells.FromKey("MENU_ROLE").Value; //Biz_DongbuMetal_Custom bizCustom = new Biz_DongbuMetal_Custom(); //int okCnt = bizCustom.AddMenuRole(blankDataTable, ddlRoles.SelectedValue); ////RoleInfos role = new RoleInfos(); ////role.RemoveRoleMenu(); ////role.AddRoleMenu(int.Parse(ddlRoles.SelectedValue), int.Parse(hdfMenu_Ref_ID.Value)); ////WebCommon.SetRoleDropDownList(ddlRoles, int.Parse(hdfMenu_Ref_ID.Value)); ////DataBindingMenuRole(int.Parse(hdfMenu_Ref_ID.Value)); //CheckMenuRoleCount(); }