private void BindData() { dt_Alert = new DataTable(); DB.Cloud cloud = new DB.Cloud(); //int nReturn = cloud.W_AlertCountList_Server(ServerNum, Convert.ToInt32(ConfigurationManager.AppSettings["ChartDataDuration"])); int nReturn = cloud.get_AlertMessage(ServerNum.ToString(), Convert.ToInt32(ConfigurationManager.AppSettings["ChartDataDuration"])); //신규추가 2017 - 09 - 23 if (cloud.dsReturn.Tables[0].Rows.Count > 0) { //데이터 테이블 구조생성용으로 첫번째 json데이터를 불러와서 컬럼명을 자동셋팅하도록 DataTable tester = (DataTable)JsonConvert.DeserializeObject(((string)cloud.dsReturn.Tables[0].Rows[0]["Data_Json"]), (typeof(DataTable))); //tester 에는 실제로 데이터가 들어가잇고 clone 을 이용해 dt_Struct 에 데이터테이블 구조만 복사 DataTable dt_struct = new DataTable(); dt_Alert = tester.Clone(); dt_Alert.Columns.Add("RepeatCnt"); dt_Alert.AcceptChanges(); //이후 dt_struct 에 계속 merge(union) 하여 하나로 합체 테스트로 돌려보니 rowcount 8만 정도 나왓네요 foreach (DataRow dr in cloud.dsReturn.Tables[0].Rows) { DataTable dt_tmp = (DataTable)JsonConvert.DeserializeObject(((string)dr["Data_Json"]), (typeof(DataTable))); //신규추가 2017 - 09 - 23 데이터 머지 = mssql union //신규추가 2017 - 09 - 23 참조 https://msdn.microsoft.com/ko-kr/library/fk68ew7b(v=vs.110).aspx dt_Alert.Merge(dt_tmp); } } }
protected void Page_Load(object sender, EventArgs e) { cloud = new DB.Cloud(); InitControl(); BindData(); BindControl(); }
private void DelServer() { DB.Cloud cloud = new DB.Cloud(); int nResult = cloud.m_tbServers_Del(MemberNum, CompanyNum, ServerNum); Response.Write(callback + "({\"error\":1, \"desc\":\"삭제 성공\"})"); }
private void BindData() { DB.Cloud cloud = new DB.Cloud(); int nReturn = cloud.m_tbServers_List(CompanyNum); gv_List.DataSource = cloud.dsReturn.Tables[0]; gv_List.DataBind(); if (!string.IsNullOrEmpty(txt_InstanceName.Text)) { nReturn = cloud.m_tbPInstance_Server_Add(Util.TConverter <int>(hdn_ServerNum.Value), "P006", txt_InstanceName.Text, true); nReturn = cloud.m_tbPInstance_Server_Add(Util.TConverter <int>(hdn_ServerNum.Value), "P014", txt_InstanceName.Text, true); nReturn = cloud.m_tbPInstance_Server_Add(Util.TConverter <int>(hdn_ServerNum.Value), "P013", txt_InstanceName.Text, true); txt_InstanceName.Text = ""; } if (numServer != 0) { pnl_Proess.Visible = true; pnl_Instance.Visible = true; nReturn = cloud.m_tbPCID_Server_PCounterName_List(numServer, "process"); gv_List_Process.DataSource = cloud.dsReturn.Tables[0]; gv_List_Process.DataBind(); DataTable dt = new DataTable(); foreach (DataRow dr in cloud.dsReturn.Tables[0].Rows) { nReturn = cloud.m_tbPInstance_Server_PInstance_List(numServer, dr["PCID"].ToString()); DataTable dt_tmp = cloud.dsReturn.Tables[0]; dt.Merge(dt_tmp); } gv_List_Instance.DataSource = dt; gv_List_Instance.DataBind(); } }
public void BindData() { DB.Cloud cloud = new DB.Cloud(); int nReturn = cloud.ServicePointLogin(strEmail, Lib.Util.EncryptText(strPass)); //if (nReturn == 1) if (cloud.dsReturn.Tables[0].Rows.Count > 0) { DataRow dr_UserInfo = Lib.ConvertingProc.dataTableNull(cloud.dsReturn.Tables[0]).Rows[0]; Lib.Util.RemoveCookie(Response, "Email"); Lib.Util.RemoveCookie(Response, "MemberNum"); Lib.Util.RemoveCookie(Response, "MemberName"); Lib.Util.RemoveCookie(Response, "CompanyNum"); Lib.Util.RemoveCookie(Response, "CompanyName"); Lib.Util.RemoveCookie(Response, "Grade"); Lib.Util.RemoveCookie(Response, "Authorize"); Lib.Util.RemoveCookie(Response, "ReDirectExpire"); Lib.Util.SetCookieValue(Response, "Email", strEmail); Lib.Util.SetCookieValue(Response, "MemberNum", dr_UserInfo["MemberNum"].ToString()); Lib.Util.SetCookieValue(Response, "MemberName", dr_UserInfo["MemberName"].ToString()); Lib.Util.SetCookieValue(Response, "CompanyNum", dr_UserInfo["CompanyNum"].ToString()); Lib.Util.SetCookieValue(Response, "CompanyName", dr_UserInfo["CompanyName"].ToString()); Lib.Util.SetCookieValue(Response, "Grade", dr_UserInfo["Grade"].ToString()); Lib.Util.SetCookieValue(Response, "Authorize", dr_UserInfo["Grade"].ToString()); Lib.Util.SetCookieValue(Response, "ReDirectExpire", "true", DateTime.Now.AddMinutes(1)); Response.Redirect(Server.UrlDecode(strReturnUrl)); } else { lblError.Text = "이메일과 비밀번호를 확인해주세요!"; } }
protected void Page_Load(object sender, EventArgs e) { cloud = new DB.Cloud(); strTel = ""; strPass = ""; lbl_Text.Text = ""; }
private void AddMember() { DataTable dt = new DataTable(); DB.Cloud cloud = new DB.Cloud(); int nReturn = 1; //웹서비스에 멤버 insert 요청 true 시 cloud에 insert nReturn = cloud.m_tbCompany_Member_Add(CompanyNum, strEmail, Util.EncryptText(strPass), strMemberName, strCompanyName, numGrade); //bytearray를 datatable로 변환 //cloud 디비 insert 실패 Master db도 삭제 if (nReturn == 1) { strDescript = "Complete"; } else { numError = 2; strDescript = "Fail"; } Response.Write(callback + "({\"error\":" + numError.ToString() + ", \"desc\":\"" + strDescript + "\"})"); }
protected void btn_Join_Click(object sender, EventArgs e) { DB.Cloud cloud = new DB.Cloud(); DataTable dt = new DataTable(); int nReturn = cloud.m_tbMember_Add(txt_Email.Text, Util.EncryptText(txt_Pass.Text), txt_Name.Text, txt_Company.Text, 9); Response.Redirect("/Login/login.aspx"); }
private void BindData() { DB.Cloud cloud = new DB.Cloud(); int nReturn = cloud.m_tbServers_List(CompanyNum); gv_List.DataSource = cloud.dsReturn.Tables[0]; gv_List.DataBind(); }
private void BindData() { int nReturn; DB.Cloud cloud = new DB.Cloud(); nReturn = cloud.m_tbCompany_Member_List(CompanyNum); gv_List.DataSource = cloud.dsReturn.Tables[0]; gv_List.DataBind(); }
override protected void Page_Load(object sender, EventArgs e) { cloud = new DB.Cloud(); base.Page_Load(sender, e); if (!IsPostBack) { CheckDemo(); BindData(); BindControl(); } }
// 자바스크립트에 배열로 데이터를 만들어줘야하기때문에 // 챠트의 데이터를 각각의 템플릿필드 헤더값으로 패핑해서 뿌려주게 만듬 dictionary<헤더값,챠트데이터배열> override protected void Page_Load(object sender, EventArgs e) { cloud = new DB.Cloud(); litScript.Text = ""; base.Page_Load(sender, e); InitControl(); BindData(); base.ReDirect(); //AlertList.Company = CompanyNum; //AlertList.Member = MemberNum; //AlertList.dt_AlertList = dt_Alert; }
override protected void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); cloud = new DB.Cloud(); if (IsPostBack) { RequestForm(); } else { RequestQueryString(); } BindData(); }
private void UpdateMember() { DB.Cloud cloud = new DB.Cloud(); int nReturn = cloud.m_tbCompany_Member_Update(MemberNum, CompanyNum, MemberNum_Target, numGrade); if (nReturn == 1) { Response.Write(callback + "({\"error\":" + nReturn.ToString() + ", \"desc\":\"수정하였습니다.\"})"); } else { Response.Write(callback + "({\"error\":" + nReturn.ToString() + ", \"desc\":\"수정 실패!!\"})"); } }
private void DelServerMember() { DB.Cloud cloud = new DB.Cloud(); int nResult = cloud.m_tbServers_Member_Del(CompanyNum, ServerNum, MemberNum_Target); if (nResult == 1) { Response.Write(callback + "({\"error\":1, \"desc\":\"서버 사용자 삭제 성공\"})"); } else { Response.Write(callback + "({\"error\":2, \"desc\":\"서버 사용자 삭제 실패\"})"); } }
private void AddServerInstance() { DB.Cloud cloud = new DB.Cloud(); int nResult = cloud.m_tbPInstance_Server_Add(ServerNum, strPCID, strInstanceName, bolIfContains); if (nResult == 1) { Response.Write(callback + "({\"error\":1, \"desc\":\"추가 완료\"})"); } else { Response.Write(callback + "({\"error\":2, \"desc\":\"추가 실패\"})"); } }
private void UpdateServer() { DB.Cloud cloud = new DB.Cloud(); int nResult = cloud.m_tbServers_Update(MemberNum, CompanyNum, strDisplayName, strDisplayGroup, ServerNum, strLanguage); if (nResult == 1) { Response.Write(callback + "({\"error\":1, \"desc\":\"서버 정보 수정 성공\"})"); } else { Response.Write(callback + "({\"error\":2, \"desc\":\"서버 정보 수정 성공\"})"); } }
private void UpdateAlertoptions() { DB.Cloud cloud = new DB.Cloud(); int nResult = cloud.m_tbAlertOptions_Update(CompanyNum, numPushInterval, numPushMaxOccurs, numPushResetInterval, bolUsePushAlert); if (nResult == 1) { Response.Write(callback + "({\"error\":1, \"desc\":\"수정 완료\"})"); } else { Response.Write(callback + "({\"error\":2, \"desc\":\"수정 실패\"})"); } }
private void UpdateAlertRules() { DB.Cloud cloud = new DB.Cloud(); int nResult = cloud.m_tbAlertRules_Server_Update(ServerNum, strReasonCode, numThreshold, strInstance, numDuration, bolEnabled, strLevel, bolRecordApps, strDescription, strMobileAlert); if (nResult == 1) { Response.Write(callback + "({\"error\":1, \"desc\":\"수정 완료\"})"); } else { Response.Write(callback + "({\"error\":2, \"desc\":\"수정 실패\"})"); } }
private void DelServerInstance() { DB.Cloud cloud = new DB.Cloud(); int nResult = cloud.m_tbPInstance_Server_Del(ServerNum, strPCID, strInstanceName); if (nResult == 1) { Response.Write(callback + "({\"error\":1, \"desc\":\"삭제 완료\"})"); } else { Response.Write(callback + "({\"error\":2, \"desc\":\"삭제 실패\"})"); } }
private void CheckEmail() { DB.Cloud cloud = new DB.Cloud(); int MailCnt = cloud.m_CheckUserEmail(strEmail); if (cloud.dsReturn.Tables[0].Rows.Count == 0) { Response.Write(callback + "({\"error\":1, \"desc\":\"사용가능한 Email 입니다\"})"); } else { Response.Write(callback + "({\"error\":2, \"desc\":\"cloud 이미 사용중인 Email입니다\"})"); } }
private void BindData() { DB.Cloud cloud = new DB.Cloud(); int nReturn = cloud.W_dashboard(MemberNum, CompanyNum, "ALL"); DataTable dt_w_Dashboard = Lib.ConvertingProc.w_Dashboard(cloud.dsReturn.Tables[0]); nReturn = cloud.w_Dashboard_Chart(MemberNum, CompanyNum, 15, "Windows"); DataTable dt_w_Dashboard_chart = Lib.ConvertingProc.ChangeDashboardColumnName(cloud.dsReturn.Tables[0]); nReturn = cloud.w_Dashboard_DiskFreeSpace_Company(MemberNum, CompanyNum); DataTable dt_FreeDisk = Lib.ConvertingProc.SetDiskProc_All(cloud.dsReturn.Tables[0]); Lib.Util.SetCache(strW_Dashboard_Cache, dt_w_Dashboard, 15); Lib.Util.SetCache(strW_Dashboard_Chart_Cache, dt_w_Dashboard_chart, 15); Lib.Util.SetCache(strw_Dashboard_DiskFreeSpace_Company_Cache, dt_FreeDisk, 15); }
override protected void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); cloud = new DB.Cloud(); RequestQueryString(); if (strServerType.ToLower() == "sql") { BindSql(); } else { BindWindow(); } }
// 자바스크립트에 배열로 데이터를 만들어줘야하기때문에 // 챠트의 데이터를 각각의 템플릿필드 헤더값으로 패핑해서 뿌려주게 만듬 dictionary<헤더값,챠트데이터배열> override protected void Page_Load(object sender, EventArgs e) { //strGroupName = HttpUtility.HtmlDecode(Request["grname"].ToString()); cloud = new DB.Cloud(); litScript.Text = ""; base.Page_Load(sender, e); base.ReDirect(); BindData(); if (!IsPostBack) { AlertList.InitControl(); } AlertList.Company = CompanyNum; AlertList.Member = MemberNum; AlertList.dt_AlertList = dt_Alert; }
override protected void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); cloud = new DB.Cloud(); litScript.Text = ""; if (!IsPostBack) { InitControl(); BindControl(); RequestQueryString(); } else { RequestForm(); BindData(); } }
private void BindData() { DB.Cloud cloud = new DB.Cloud(); int nReturn = cloud.m_tbServers_List(CompanyNum); gv_List.DataSource = cloud.dsReturn.Tables[0]; gv_List.DataBind(); if (numServer != 0) { pnl_View.Visible = true; nReturn = cloud.m_tbServers_Member_List(CompanyNum, numServer); gv_List_Selected.DataSource = cloud.dsReturn.Tables[0]; gv_List_Selected.DataBind(); nReturn = cloud.m_tbServers_Member_List_NotExist(CompanyNum, numServer); gv_List_UnSelected.DataSource = cloud.dsReturn.Tables[0]; gv_List_UnSelected.DataBind(); } }
private void BindData() { DB.Cloud cloud = new DB.Cloud(); int nReturn = cloud.m_tbServers_List(CompanyNum); dt_ServerList = cloud.dsReturn.Tables[0]; nReturn = cloud.m_tbAlertOptions_List(CompanyNum); dt_AlertOption = cloud.dsReturn.Tables[0]; ods_List.TypeName = cloud.GetType().AssemblyQualifiedName; ods_List.SelectMethod = "m_tbAlertRules_Server_List_AlertLevel_ods"; ods_List.SelectParameters.Clear(); ods_List.SelectParameters.Add("numServer", numServer.ToString()); gv_List.DataSourceID = "ods_List"; //nReturn = cloud.m_tbAlertRules_Server_List_AlertLevel(numServer); //gv_List.DataSource = cloud.dsReturn.Tables[0]; //gv_List.DataBind(); }
public void InitControl() { Dictionary <string, string> list = new Dictionary <string, string>(); list.Add("ALL", "ALL"); list.Add("Windows", "Windows"); list.Add("Web", "Web"); list.Add("SQL", "SQL"); string MyServerList = ""; DB.Cloud cloud = new DB.Cloud(); cloud.SetCmd("Cloud"); cloud.get_ServerList(numMember); foreach (DataRow dr in cloud.dsReturn.Tables[0].Rows) { list.Add(dr["ServerNum"].ToString(), dr["DIsPlayName"].ToString()); } ddl_Server.DataSource = list; ddl_Server.DataValueField = "Key"; ddl_Server.DataTextField = "Value"; ddl_Server.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { cloud = new DB.Cloud(); RequestQueryString(); BindData(); }
public void BindData() { DB.Cloud cloud = new DB.Cloud(); //DataTable dt_ServerAlertList = new DataTable(); //서버리스트 읽어오기 string MyServerList = ""; cloud.SetCmd("Cloud"); cloud.get_MyServerList(MemberNum); if (cloud.dsReturn.Tables[0].Rows.Count == 0) { return; } foreach (DataRow dr in cloud.dsReturn.Tables[0].Rows) { MyServerList += dr["ServerNum"].ToString() + ","; } if (MyServerList.Length > 0) { MyServerList = MyServerList.Substring(0, MyServerList.Length - 1); } cloud.SetCmd("Cloud"); int nReturn = cloud.get_ServerStatus(MyServerList); DataSet ds = cloud.dsReturn; List <string> dt_Group = new List <string>(); if (ds != null) { dt_ServerList = Lib.ConvertingProc.w_Dashboard(ds.Tables[0]); var tmp_Group = from tbl in ds.Tables[0].AsEnumerable() orderby tbl["DisplayGroup"] ascending group tbl by tbl["DisplayGroup"] into tmp select tmp; foreach (var i in tmp_Group) { dt_Group.Add(i.Key.ToString()); } tmp_Group = null; } else { return; } ds.Clear(); ds.Dispose(); rpt_ServerStatus.DataSource = dt_Group; rpt_ServerStatus.DataBind(); dt_Group.Clear(); //nReturn = cloud.W_AlertCountList(MemberNum, CompanyNum, numAlertDataDuration); //if (cloud.dsReturn != null) //{ // dt_ServerAlertList = cloud.dsReturn.Tables[0]; // var tmp_Group = from tbl in dt_ServerAlertList.AsEnumerable() // orderby tbl["DisplayGroup"] ascending // group tbl by tbl["DisplayGroup"] into tmp // select tmp; // foreach (var i in tmp_Group) // { // SetAlertDic(dt_ServerAlertList, i.Key.ToString()); // dt_Group.Add(i.Key.ToString()); // } // cloud.dsReturn.Clear(); // cloud.dsReturn.Dispose(); // tmp_Group = null; //} //else //{ // return; //} ////rpt_Alert.DataSource = dt_Group; ////rpt_Alert.DataBind(); dt_Group.Clear(); cloud.CloseCon(); }