/// <summary> /// 추가 조회 버튼 클릭시 처리 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSearchNext_Click(object sender, EventArgs e) { if (workTable == null) { MessageBox.Show("조회 후 추가 조회하세요."); return; } // 자료일자 string dateFrom = this.dateTimeFrom.Value.ToString("yyyyMMdd"); string dateTo = this.dateTimeTo.Value.ToString("yyyyMMdd"); string dataDate = dateFrom; if (!dateFrom.Equals(dateTo)) { dataDate += "-" + dateTo; } // 자료 조회 // 조회URL: manager/log/<자료일자>?옵션 HttpRestClient client = new HttpRestClient("manager/log/" + dataDate); // 조회조건 if (comboAPIKEY.Text.Length > 0) { client.QueryString.Add("apikey", comboAPIKEY.Text); } if (comboMethod.Text.Length > 0) { client.QueryString.Add("type", comboMethod.Text); } if (txtRequestId.Text.Length > 0) { client.QueryString.Add("requestid", txtRequestId.Text); } // 페이징처리... if (lastNo != null && lastNo.Length > 0) { client.QueryString.Add("startno", lastNo); } if (!client.doWorkDialog()) { client.showErrorDialog(); return; } // 응답 데이터 처리 dynamic json = client.getJsonObject(); foreach (dynamic item in json.dataList) { DataRow workRow = workTable.NewRow(); workRow["No"] = item["no"]; string date = (string)item["date"]; date = date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2); workRow["Date"] = date; string time = (string)item["time"]; time = time.Substring(0, 2) + ":" + time.Substring(2, 2) + ":" + time.Substring(4, 2); workRow["Time"] = time; workRow["API Key"] = item["apiKey"]; workRow["Ticket ID"] = item["reuqestId"]; workRow["Method"] = item["method"]; workRow["Resource"] = item["resource"]; workRow["Metadata"] = item["metadata"]; workTable.Rows.Add(workRow); lastNo = (string)item["no"]; } dataGridView1.AutoResizeColumns(); }
private void btnSearch_Click(object sender, EventArgs e) { //조회 MasterList master = null; if (radioBtn기관.Checked) { master = DataMasterCache.getDataMasterByName("기관잠정치매매"); } else if (radioBtn외인.Checked) { master = DataMasterCache.getDataMasterByName("외인잠정치매매"); } else if (radioBtn외인기관.Checked) { master = DataMasterCache.getDataMasterByName("외인기관쌍끌이잠정치매매"); } if (master == null) { MessageBox.Show("자료 종류 중 하나를 선택하세요.", "Error"); return; } // 자료일자 DateTime d = this.datePicker.Value; string dataDate = d.ToString("yyyyMMdd"); Console.WriteLine("자료종류: " + master.id + ":" + master.name); Console.WriteLine("자료일자: " + dataDate); // 자료 조회 // 조회URL: data/<자료종류>/<자료일자>?stockcode=종목코드 string resource_value = master.id + "/" + dataDate; HttpRestClient client = new HttpRestClient("report/listview/" + resource_value); // 조회조건 if (txtStockCodes.Text.Length > 0) { client.QueryString.Add("stockcode", txtStockCodes.Text); } if (!client.doWorkDialog()) { client.showErrorDialog(); return; } // 응답 데이터 처리 dynamic json = client.getJsonObject(); DataTable workTable = new DataTable("Report"); workTable.Columns.Add("종목코드", typeof(String)); workTable.Columns.Add("종목명", typeof(String)); workTable.Columns.Add("외0920-계", typeof(int)); // field workTable.Columns.Add("외0950-증감", typeof(int)); workTable.Columns.Add("외0950-계", typeof(int)); // field //workTable.Columns.Add("기0950-증감", typeof(int)); workTable.Columns.Add("기0950-계", typeof(int)); // field workTable.Columns.Add("0950-소계", typeof(int)); workTable.Columns["외0950-증감"].Expression = "[외0950-계] - [외0920-계]"; workTable.Columns["0950-소계"].Expression = "[외0950-계] + [기0950-계]"; workTable.Columns.Add("외1100-증감", typeof(int)); workTable.Columns.Add("외1100-계", typeof(int)); // field workTable.Columns.Add("기1100-증감", typeof(int)); workTable.Columns.Add("기1100-계", typeof(int)); // field workTable.Columns.Add("1100-소계", typeof(int)); workTable.Columns["외1100-증감"].Expression = "[외0950-계] - [외1100-계]"; workTable.Columns["기1100-증감"].Expression = "[기0950-계] - [기1100-계]"; workTable.Columns["1100-소계"].Expression = "[외1100-계] + [기1100-계]"; workTable.Columns.Add("외1320-증감", typeof(int)); workTable.Columns.Add("외1320-계", typeof(int)); // field workTable.Columns.Add("기1320-증감", typeof(int)); workTable.Columns.Add("기1320-계", typeof(int)); // field workTable.Columns.Add("1320-소계", typeof(int)); workTable.Columns["외1320-증감"].Expression = "[외1100-계] - [외1320-계]"; workTable.Columns["기1320-증감"].Expression = "[기1100-계] - [기1320-계]"; workTable.Columns["1320-소계"].Expression = "[외1320-계] + [기1320-계]"; workTable.Columns.Add("외1505-증감", typeof(int)); workTable.Columns.Add("외1505-계", typeof(int)); // field workTable.Columns.Add("기1505-증감", typeof(int)); workTable.Columns.Add("기1505-계", typeof(int)); // field workTable.Columns.Add("1505-소계", typeof(int)); workTable.Columns["외1505-증감"].Expression = "[외1320-계] - [외1505-계]"; workTable.Columns["기1505-증감"].Expression = "[기1320-계] - [기1505-계]"; workTable.Columns["1505-소계"].Expression = "[외1505-계] + [기1505-계]"; foreach (dynamic item in json.dataList) { //DataRow[] foundRows = workTable.Select("종목코드 = '" + item["stockCode"] + "'"); //if (foundRows == null || foundRows.Length == 0) //{ DataRow workRow = workTable.NewRow(); workRow["종목코드"] = item["stockCode"]; workRow["종목명"] = item["stockName"]; workRow["외0920-계"] = strToInt((string)item["fgn_0920"]); workRow["외0950-계"] = strToInt((string)item["fgn_0950"]); workRow["기0950-계"] = strToInt((string)item["inv_0950"]); workRow["외1100-계"] = strToInt((string)item["fgn_1100"]); workRow["기1100-계"] = strToInt((string)item["inv_1100"]); workRow["외1320-계"] = strToInt((string)item["fgn_1320"]); workRow["기1320-계"] = strToInt((string)item["inv_1320"]); workRow["외1505-계"] = strToInt((string)item["fgn_1505"]); workRow["기1505-계"] = strToInt((string)item["inv_1505"]); workTable.Rows.Add(workRow); //} } dataGridView1.DataSource = workTable; dataGridView1.AutoResizeColumns(); dataGridView1.Columns["외0920-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외0950-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외0950-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기0950-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["0950-소계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1100-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1100-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1100-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1100-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["1100-소계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1320-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1320-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1320-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1320-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["1320-소계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1505-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1505-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1505-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1505-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["1505-소계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외0920-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외0950-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외0950-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기0950-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["0950-소계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1100-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1100-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1100-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1100-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["1100-소계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1320-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1320-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1320-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1320-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["1320-소계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1505-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1505-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1505-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1505-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["1505-소계"].DefaultCellStyle.Format = "N0"; }
/// <summary> /// 다음 조회 버튼 클릭시 처리 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSearchNext_Click(object sender, EventArgs e) { if (workTable == null) { MessageBox.Show("조회 후 추가 조회하세요."); return; } // 자료일자 string dateFrom = this.dateTimeFrom.Value.ToString("yyyyMMdd"); string dateTo = this.dateTimeTo.Value.ToString("yyyyMMdd"); string dataDate = dateFrom; if (!dateFrom.Equals(dateTo)) dataDate += "-" + dateTo; // 자료 조회 // 조회URL: manager/log/<자료일자>?옵션 HttpRestClient client = new HttpRestClient("manager/error/" + dataDate); // 조회조건 if (comboAPIKEY.Text.Length > 0) client.QueryString.Add("apikey", comboAPIKEY.Text); if (txtRequestId.Text.Length > 0) client.QueryString.Add("requestid", txtRequestId.Text); // 페이징처리... if (lastNo != null && lastNo.Length > 0) client.QueryString.Add("startno", lastNo); if (!client.doWorkDialog()) { client.showErrorDialog(); return; } // 응답 데이터 처리 dynamic json = client.getJsonObject(); foreach (dynamic item in json.dataList) { DataRow workRow = workTable.NewRow(); workRow["No"] = item["no"]; string date = (string)item["date"]; date = date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2); workRow["Date"] = date; string time = (string)item["time"]; time = time.Substring(0, 2) + ":" + time.Substring(2, 2) + ":" + time.Substring(4, 2); workRow["Time"] = time; workRow["API Key"] = item["apiKey"]; workRow["Ticket ID"] = item["reuqestId"]; workRow["Message"] = item["message"]; workRow["Trace"] = item["trace"]; workTable.Rows.Add(workRow); lastNo = (string)item["no"]; } dataGridView1.AutoResizeColumns(); }
/// <summary> /// 새 버전 체크 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void checkNewVersion_ToolStripMenuItem_Click(object sender, EventArgs e) { HttpRestClient client = new HttpRestClient("clientversion"); if (!client.doWorkDialog()) { client.showErrorDialog(); return; } dynamic json = client.getJsonObject(); if (json == null) { MessageBox.Show("전송 오류가 발생했습니다. (JSON 포맷오류)", "Format error!"); return; } Console.WriteLine("statusCode: " + json["_metadata"]["statusCode"]); Console.WriteLine("version [" + json["clientversion"] + "]"); Console.WriteLine("setup [" + json["clientsetup"] + "]"); Console.WriteLine("md5 [" + json["clientmd5"] + "]"); Version current = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version; Version future = new Version((string)json["clientversion"]); if (current >= future) { if (!hiddenUpdateMessage) { MessageBox.Show("최신 버전을 사용하고 있습니다.", "버전 확인"); } hiddenUpdateMessage = false; return; } else { MessageBox.Show("새 버전이 있습니다. [" + future.ToString() + "]", "버전 확인"); // 새 버전 자동 다운로드 client = new HttpRestClient(); client.RequestUri = (string)json["clientsetup"]; if (!client.doWorkDialog()) { MessageBox.Show("다운로드 오류: " + client.ResponseMessage, "Request error!"); return; } string md5value = ""; using (MD5 md5sum = MD5.Create()) { byte[] hashValue = md5sum.ComputeHash(client.ResponseContent); for (int i = 0; i < hashValue.Length; i++) { md5value += hashValue[i].ToString("x2"); } } if (!md5value.Equals((string)json["clientmd5"])) { MessageBox.Show("다운로드 파일 오류입니다. (md5 불일치)", "버전 확인"); return; } // 다운로드한 파일을 저장 string localFileName = AppDomain.CurrentDomain.BaseDirectory + System.IO.Path.DirectorySeparatorChar + "Setup.exe"; using (FileStream fs = File.Create(localFileName)) { fs.Write(client.ResponseContent, 0, client.ResponseContent.Length); } // 저장한 파일을 실행 System.Diagnostics.Process.Start(localFileName); // 현재 프로그램을 종료 exit_ToolStripMenuItem_Click(sender, e); } }
private void btnSearch_Click(object sender, EventArgs e) { //조회 MasterList master = null; if (radioBtn기관.Checked) master = DataMasterCache.getDataMasterByName("기관잠정치매매"); else if (radioBtn외인.Checked) master = DataMasterCache.getDataMasterByName("외인잠정치매매"); else if (radioBtn외인기관.Checked) master = DataMasterCache.getDataMasterByName("외인기관쌍끌이잠정치매매"); if (master == null) { MessageBox.Show("자료 종류 중 하나를 선택하세요.", "Error"); return; } // 자료일자 DateTime d = this.datePicker.Value; string dataDate = d.ToString("yyyyMMdd"); Console.WriteLine("자료종류: " + master.id + ":" + master.name); Console.WriteLine("자료일자: " + dataDate); // 자료 조회 // 조회URL: data/<자료종류>/<자료일자>?stockcode=종목코드 string resource_value = master.id + "/" + dataDate; HttpRestClient client = new HttpRestClient("report/listview/" + resource_value); // 조회조건 if (txtStockCodes.Text.Length > 0) client.QueryString.Add("stockcode", txtStockCodes.Text); if (!client.doWorkDialog()) { client.showErrorDialog(); return; } // 응답 데이터 처리 dynamic json = client.getJsonObject(); DataTable workTable = new DataTable("Report"); workTable.Columns.Add("종목코드", typeof(String)); workTable.Columns.Add("종목명", typeof(String)); workTable.Columns.Add("외0920-계", typeof(int)); // field workTable.Columns.Add("외0950-증감", typeof(int)); workTable.Columns.Add("외0950-계", typeof(int)); // field //workTable.Columns.Add("기0950-증감", typeof(int)); workTable.Columns.Add("기0950-계", typeof(int)); // field workTable.Columns.Add("0950-소계", typeof(int)); workTable.Columns["외0950-증감"].Expression = "[외0950-계] - [외0920-계]"; workTable.Columns["0950-소계"].Expression = "[외0950-계] + [기0950-계]"; workTable.Columns.Add("외1100-증감", typeof(int)); workTable.Columns.Add("외1100-계", typeof(int)); // field workTable.Columns.Add("기1100-증감", typeof(int)); workTable.Columns.Add("기1100-계", typeof(int)); // field workTable.Columns.Add("1100-소계", typeof(int)); workTable.Columns["외1100-증감"].Expression = "[외0950-계] - [외1100-계]"; workTable.Columns["기1100-증감"].Expression = "[기0950-계] - [기1100-계]"; workTable.Columns["1100-소계"].Expression = "[외1100-계] + [기1100-계]"; workTable.Columns.Add("외1320-증감", typeof(int)); workTable.Columns.Add("외1320-계", typeof(int)); // field workTable.Columns.Add("기1320-증감", typeof(int)); workTable.Columns.Add("기1320-계", typeof(int)); // field workTable.Columns.Add("1320-소계", typeof(int)); workTable.Columns["외1320-증감"].Expression = "[외1100-계] - [외1320-계]"; workTable.Columns["기1320-증감"].Expression = "[기1100-계] - [기1320-계]"; workTable.Columns["1320-소계"].Expression = "[외1320-계] + [기1320-계]"; workTable.Columns.Add("외1505-증감", typeof(int)); workTable.Columns.Add("외1505-계", typeof(int)); // field workTable.Columns.Add("기1505-증감", typeof(int)); workTable.Columns.Add("기1505-계", typeof(int)); // field workTable.Columns.Add("1505-소계", typeof(int)); workTable.Columns["외1505-증감"].Expression = "[외1320-계] - [외1505-계]"; workTable.Columns["기1505-증감"].Expression = "[기1320-계] - [기1505-계]"; workTable.Columns["1505-소계"].Expression = "[외1505-계] + [기1505-계]"; foreach (dynamic item in json.dataList) { //DataRow[] foundRows = workTable.Select("종목코드 = '" + item["stockCode"] + "'"); //if (foundRows == null || foundRows.Length == 0) //{ DataRow workRow = workTable.NewRow(); workRow["종목코드"] = item["stockCode"]; workRow["종목명"] = item["stockName"]; workRow["외0920-계"] = strToInt((string)item["fgn_0920"]); workRow["외0950-계"] = strToInt((string)item["fgn_0950"]); workRow["기0950-계"] = strToInt((string)item["inv_0950"]); workRow["외1100-계"] = strToInt((string)item["fgn_1100"]); workRow["기1100-계"] = strToInt((string)item["inv_1100"]); workRow["외1320-계"] = strToInt((string)item["fgn_1320"]); workRow["기1320-계"] = strToInt((string)item["inv_1320"]); workRow["외1505-계"] = strToInt((string)item["fgn_1505"]); workRow["기1505-계"] = strToInt((string)item["inv_1505"]); workTable.Rows.Add(workRow); //} } dataGridView1.DataSource = workTable; dataGridView1.AutoResizeColumns(); dataGridView1.Columns["외0920-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외0950-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외0950-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기0950-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["0950-소계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1100-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1100-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1100-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1100-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["1100-소계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1320-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1320-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1320-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1320-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["1320-소계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1505-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외1505-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1505-증감"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["기1505-계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["1505-소계"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dataGridView1.Columns["외0920-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외0950-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외0950-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기0950-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["0950-소계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1100-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1100-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1100-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1100-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["1100-소계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1320-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1320-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1320-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1320-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["1320-소계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1505-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["외1505-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1505-증감"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["기1505-계"].DefaultCellStyle.Format = "N0"; dataGridView1.Columns["1505-소계"].DefaultCellStyle.Format = "N0"; }
private void btnRegister_Click(object sender, EventArgs e) { if (isRegistered) { MessageBox.Show("이미 등록했습니다.", "Error"); return; } if (!isParsed) { MessageBox.Show("미분석 파일입니다.", "Error"); return; } if (this.listDataTypes.SelectedIndex < 0) { MessageBox.Show("자료 종류를 선택하지 않았습니다.", "Error"); return; } if (this.listDataTimes.SelectedIndex < 0) { MessageBox.Show("시간을 선택하지 않았습니다.", "Error"); return; } // 자료 종류 MasterList selectedMaster = (MasterList)this.listDataTypes.SelectedItem; string dataTypeName = selectedMaster.name; int dataTypeId = selectedMaster.id; // 자료 시간 string dataTime = (string)this.listDataTimes.SelectedValue; // 자료일자 DateTime d = this.datePicker.Value; string dataDate = d.ToString("yyyyMMdd"); Console.WriteLine("자료종류: " + dataTypeId + ":" + dataTypeName); Console.WriteLine("자료일자: " + dataDate); Console.WriteLine("자료시간: " + dataTime); // 자료 등록 처리 // 등록URL: data/<자료종류>/<자료일자>/<자료시간> string resource_value = dataTypeId + "/" + dataDate + "/" + dataTime; HttpRestClient client = new HttpRestClient(HttpRestClient.REST_METHOD_CREATE, "data/" + resource_value); client.RequestDataFormat = HttpRestClient.DATA_FORMAT_JSON; string jsonStr = JsonConvert.SerializeObject(samFileParser.DataItems); client.RequestContent = Encoding.UTF8.GetBytes(jsonStr); // ------------------------------------------- //Console.WriteLine(jsonStr); //File.WriteAllText("json.txt", jsonStr); if (!client.doWorkDialog()) { client.showErrorDialog(); return; } dynamic json = client.getJsonObject(); if (json == null) { MessageBox.Show("전송 오류가 발생했습니다. (Can't convert json)", "Format error!"); return; } Console.WriteLine("statusCode: " + json["_metadata"]["statusCode"]); if (json["FieldNotFound"] != null && ((string)json["FieldNotFound"]).Length > 0) { MessageBox.Show("다음 항목은 미등록 항목으로 저장하지 않았습니다.\n" + ((string)json["FieldNotFound"]), "주의"); } //json["ErrorData"]; if ((int)json["Rows"] == 0) MessageBox.Show("등록 건수가 없습니다. 중복여부를 확인하세요.", "등록오류"); else MessageBox.Show(((string)json["Rows"]) + "건 등록이 완료되었습니다.", "등록완료"); isRegistered = true; }
private void btnSearch_Click(object sender, EventArgs e) { //조회 MasterList master = null; if (radioBtn강력.Checked) master = DataMasterCache.getDataMasterByName("강력출동"); else if (radioBtn거래이평.Checked) master = DataMasterCache.getDataMasterByName("거래20이평"); if (master == null) { MessageBox.Show("자료 종류 중 하나를 선택하세요.", "Error"); return; } // 자료일자 DateTime d1 = this.datePicker1.Value; string dataDate1 = d1.ToString("yyyyMMdd"); DateTime d2 = this.datePicker2.Value; string dataDate2 = d2.ToString("yyyyMMdd"); Console.WriteLine("자료종류: " + master.id + ":" + master.name); Console.WriteLine("자료일자: " + dataDate1 + " ~ " + dataDate2); string dataDate = dataDate1; if (!dataDate1.Equals(dataDate2)) dataDate += "-" + dataDate2; // 자료 조회 // 조회URL: data/<자료종류>/<자료일자>?stockcode=종목코드 string resource_value = master.id + "/" + dataDate; HttpRestClient client = new HttpRestClient("report/diffview/" + resource_value); // 조회조건 if (txtStockCodes.Text.Length > 0) client.QueryString.Add("stockcode", txtStockCodes.Text); if (!client.doWorkDialog()) { client.showErrorDialog(); return; } // 응답 데이터 처리 dynamic json = client.getJsonObject(); DataTable workTable = new DataTable("Report"); workTable.Columns.Add("자료일자", typeof(String)); workTable.Columns.Add("09:30", typeof(String)); workTable.Columns.Add("10:00", typeof(String)); workTable.Columns.Add("11:00", typeof(String)); workTable.Columns.Add("12:00", typeof(String)); workTable.Columns.Add("13:00", typeof(String)); workTable.Columns.Add("14:00", typeof(String)); workTable.Columns.Add("15:30", typeof(String)); workTable.Columns.Add("종목코드", typeof(String)); foreach (dynamic item in json.dataList) { DataRow workRow = workTable.NewRow(); string gsdate = (string)item["gsDate"]; gsdate = gsdate.Substring(0, 4) + "-" + gsdate.Substring(4, 2) + "-" + gsdate.Substring(6, 2); workRow["자료일자"] = gsdate; string stCode = (string)item["stockCode"]; string stName = (string)item["stockName"]; workRow["종목코드"] = stCode; workRow["09:30"] = codeToName((string)item["ST0930"], stCode, stName); workRow["10:00"] = codeToName((string)item["ST1000"], stCode, stName); workRow["11:00"] = codeToName((string)item["ST1100"], stCode, stName); workRow["12:00"] = codeToName((string)item["ST1200"], stCode, stName); workRow["13:00"] = codeToName((string)item["ST1300"], stCode, stName); workRow["14:00"] = codeToName((string)item["ST1400"], stCode, stName); workRow["15:30"] = codeToName((string)item["ST1530"], stCode, stName); workTable.Rows.Add(workRow); } dataGridView1.DataSource = workTable; dataGridView1.AutoResizeColumns(); }
/// <summary> /// 새 버전 체크 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void checkNewVersion_ToolStripMenuItem_Click(object sender, EventArgs e) { HttpRestClient client = new HttpRestClient("clientversion"); if (!client.doWorkDialog()) { client.showErrorDialog(); return; } dynamic json = client.getJsonObject(); if (json == null) { MessageBox.Show("전송 오류가 발생했습니다. (JSON 포맷오류)", "Format error!"); return; } Console.WriteLine("statusCode: " + json["_metadata"]["statusCode"]); Console.WriteLine("version [" + json["clientversion"] + "]"); Console.WriteLine("setup [" + json["clientsetup"] + "]"); Console.WriteLine("md5 [" + json["clientmd5"] + "]"); Version current = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version; Version future = new Version((string)json["clientversion"]); if (current >= future) { if (!hiddenUpdateMessage) MessageBox.Show("최신 버전을 사용하고 있습니다.", "버전 확인"); hiddenUpdateMessage = false; return; } else { MessageBox.Show("새 버전이 있습니다. [" + future.ToString() + "]", "버전 확인"); // 새 버전 자동 다운로드 client = new HttpRestClient(); client.RequestUri = (string)json["clientsetup"]; if (!client.doWorkDialog()) { MessageBox.Show("다운로드 오류: " + client.ResponseMessage, "Request error!"); return; } string md5value = ""; using (MD5 md5sum = MD5.Create()) { byte[] hashValue = md5sum.ComputeHash(client.ResponseContent); for (int i = 0; i < hashValue.Length; i++) { md5value += hashValue[i].ToString("x2"); } } if (!md5value.Equals((string)json["clientmd5"])) { MessageBox.Show("다운로드 파일 오류입니다. (md5 불일치)", "버전 확인"); return; } // 다운로드한 파일을 저장 string localFileName = AppDomain.CurrentDomain.BaseDirectory + System.IO.Path.DirectorySeparatorChar + "Setup.exe"; using (FileStream fs = File.Create(localFileName)) { fs.Write(client.ResponseContent, 0, client.ResponseContent.Length); } // 저장한 파일을 실행 System.Diagnostics.Process.Start(localFileName); // 현재 프로그램을 종료 exit_ToolStripMenuItem_Click(sender, e); } }
private void btnSearch_Click(object sender, EventArgs e) { //조회 MasterList master = null; if (radioBtn강력.Checked) { master = DataMasterCache.getDataMasterByName("강력출동"); } else if (radioBtn거래이평.Checked) { master = DataMasterCache.getDataMasterByName("거래20이평"); } if (master == null) { MessageBox.Show("자료 종류 중 하나를 선택하세요.", "Error"); return; } // 자료일자 DateTime d1 = this.datePicker1.Value; string dataDate1 = d1.ToString("yyyyMMdd"); DateTime d2 = this.datePicker2.Value; string dataDate2 = d2.ToString("yyyyMMdd"); Console.WriteLine("자료종류: " + master.id + ":" + master.name); Console.WriteLine("자료일자: " + dataDate1 + " ~ " + dataDate2); string dataDate = dataDate1; if (!dataDate1.Equals(dataDate2)) { dataDate += "-" + dataDate2; } // 자료 조회 // 조회URL: data/<자료종류>/<자료일자>?stockcode=종목코드 string resource_value = master.id + "/" + dataDate; HttpRestClient client = new HttpRestClient("report/diffview/" + resource_value); // 조회조건 if (txtStockCodes.Text.Length > 0) { client.QueryString.Add("stockcode", txtStockCodes.Text); } if (!client.doWorkDialog()) { client.showErrorDialog(); return; } // 응답 데이터 처리 dynamic json = client.getJsonObject(); DataTable workTable = new DataTable("Report"); workTable.Columns.Add("자료일자", typeof(String)); workTable.Columns.Add("09:30", typeof(String)); workTable.Columns.Add("10:00", typeof(String)); workTable.Columns.Add("11:00", typeof(String)); workTable.Columns.Add("12:00", typeof(String)); workTable.Columns.Add("13:00", typeof(String)); workTable.Columns.Add("14:00", typeof(String)); workTable.Columns.Add("15:30", typeof(String)); workTable.Columns.Add("종목코드", typeof(String)); foreach (dynamic item in json.dataList) { DataRow workRow = workTable.NewRow(); string gsdate = (string)item["gsDate"]; gsdate = gsdate.Substring(0, 4) + "-" + gsdate.Substring(4, 2) + "-" + gsdate.Substring(6, 2); workRow["자료일자"] = gsdate; string stCode = (string)item["stockCode"]; string stName = (string)item["stockName"]; workRow["종목코드"] = stCode; workRow["09:30"] = codeToName((string)item["ST0930"], stCode, stName); workRow["10:00"] = codeToName((string)item["ST1000"], stCode, stName); workRow["11:00"] = codeToName((string)item["ST1100"], stCode, stName); workRow["12:00"] = codeToName((string)item["ST1200"], stCode, stName); workRow["13:00"] = codeToName((string)item["ST1300"], stCode, stName); workRow["14:00"] = codeToName((string)item["ST1400"], stCode, stName); workRow["15:30"] = codeToName((string)item["ST1530"], stCode, stName); workTable.Rows.Add(workRow); } dataGridView1.DataSource = workTable; dataGridView1.AutoResizeColumns(); }
private void btnRegister_Click(object sender, EventArgs e) { if (isRegistered) { MessageBox.Show("이미 등록했습니다.", "Error"); return; } if (!isParsed) { MessageBox.Show("미분석 파일입니다.", "Error"); return; } if (this.listDataTypes.SelectedIndex < 0) { MessageBox.Show("자료 종류를 선택하지 않았습니다.", "Error"); return; } if (this.listDataTimes.SelectedIndex < 0) { MessageBox.Show("시간을 선택하지 않았습니다.", "Error"); return; } // 자료 종류 MasterList selectedMaster = (MasterList)this.listDataTypes.SelectedItem; string dataTypeName = selectedMaster.name; int dataTypeId = selectedMaster.id; // 자료 시간 string dataTime = (string)this.listDataTimes.SelectedValue; // 자료일자 DateTime d = this.datePicker.Value; string dataDate = d.ToString("yyyyMMdd"); Console.WriteLine("자료종류: " + dataTypeId + ":" + dataTypeName); Console.WriteLine("자료일자: " + dataDate); Console.WriteLine("자료시간: " + dataTime); // 자료 등록 처리 // 등록URL: data/<자료종류>/<자료일자>/<자료시간> string resource_value = dataTypeId + "/" + dataDate + "/" + dataTime; HttpRestClient client = new HttpRestClient(HttpRestClient.REST_METHOD_CREATE, "data/" + resource_value); client.RequestDataFormat = HttpRestClient.DATA_FORMAT_JSON; string jsonStr = JsonConvert.SerializeObject(samFileParser.DataItems); client.RequestContent = Encoding.UTF8.GetBytes(jsonStr); // ------------------------------------------- //Console.WriteLine(jsonStr); //File.WriteAllText("json.txt", jsonStr); if (!client.doWorkDialog()) { client.showErrorDialog(); return; } dynamic json = client.getJsonObject(); if (json == null) { MessageBox.Show("전송 오류가 발생했습니다. (Can't convert json)", "Format error!"); return; } Console.WriteLine("statusCode: " + json["_metadata"]["statusCode"]); if (json["FieldNotFound"] != null && ((string)json["FieldNotFound"]).Length > 0) { MessageBox.Show("다음 항목은 미등록 항목으로 저장하지 않았습니다.\n" + ((string)json["FieldNotFound"]), "주의"); } //json["ErrorData"]; if ((int)json["Rows"] == 0) { MessageBox.Show("등록 건수가 없습니다. 중복여부를 확인하세요.", "등록오류"); } else { MessageBox.Show(((string)json["Rows"]) + "건 등록이 완료되었습니다.", "등록완료"); } isRegistered = true; }