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();
}
