private void GetDartCodeInStockName()
{
ClsGetKoaStudioMethod clsGetKoaStudioMethod = new ClsGetKoaStudioMethod();
_dt = clsGetKoaStudioMethod.GetCodeListByMarketCallBackDataTable("999").Copy();
var Rows = from t1 in _dt.AsEnumerable()
join t2 in _ds.Tables[0].AsEnumerable()
on t1.Field <string>("STOCK_NAME") equals t2.Field <string>("corp_name")
select new {
STOCK_CODE = t1.Field <string>("STOCK_CODE").ToString().Trim(),
STOCK_NAME = t1.Field <string>("STOCK_NAME").ToString().Trim(),
corp_code = t2.Field <string>("corp_code").ToString().Trim(),
corp_name = t2.Field <string>("corp_name").ToString().Trim()
};
ClsDataGridViewUtil clsDataGridViewUtil = new ClsDataGridViewUtil();
int row = 0;
clsDataGridViewUtil.RemoveGridViewRow(dgvList);
foreach (var dr in Rows)
{
dgvList.Rows.Add();
dgvList.Rows[row].Cells["corp_code"].Value = dr.corp_code;
dgvList.Rows[row].Cells["STOCK_CODE"].Value = dr.STOCK_CODE;
dgvList.Rows[row].Cells["STOCK_NAME"].Value = dr.STOCK_NAME;
row = row + 1;
}
}
private void SetDgv()
{
DataGridViewButtonColumn dataGridViewButtonColumn = new DataGridViewButtonColumn();
dataGridViewButtonColumn.Name = "WEB_VIEW";
dataGridViewButtonColumn.HeaderText = "View";
dataGridViewButtonColumn.ReadOnly = false;
dgvStockInfo.Columns.Add(dataGridViewButtonColumn);
dgvStockInfo.Columns.Add(columnName: "STOCK_CODE", headerText: "종목코드");
dgvStockInfo.Columns.Add(columnName: "종목명", headerText: "종목명");
dgvStockInfo.Columns.Add(columnName: "현재가", headerText: "현재가");
dgvStockInfo.Columns.Add(columnName: "거래량", headerText: "거래량");
dgvStockInfo.Columns.Add(columnName: "거래대금", headerText: "거래대금");
dgvStockInfo.Columns.Add(columnName: "시가", headerText: "시가");
dgvStockInfo.Columns.Add(columnName: "고가", headerText: "고가");
dgvStockInfo.Columns.Add(columnName: "저가", headerText: "저가");
dgvStockInfo.Columns.Add(columnName: "기준일", headerText: "기준일");
dgvStockInfo.Columns.Add(columnName: "결산월", headerText: "결산월");
dgvStockInfo.Columns.Add(columnName: "액면가", headerText: "액면가");
dgvStockInfo.Columns.Add(columnName: "자본금", headerText: "자본금");
dgvStockInfo.Columns.Add(columnName: "상장주식", headerText: "상장주식");
dgvStockInfo.Columns.Add(columnName: "신용비율", headerText: "신용비율");
dgvStockInfo.Columns.Add(columnName: "연중최고", headerText: "연중최고");
dgvStockInfo.Columns.Add(columnName: "연중최저", headerText: "연중최저");
dgvStockInfo.Columns.Add(columnName: "시가총액", headerText: "시가총액");
dgvStockInfo.Columns.Add(columnName: "시가총액비중", headerText: "시가총액비중");
dgvStockInfo.Columns.Add(columnName: "외인소진률", headerText: "외인소진률");
dgvStockInfo.Columns.Add(columnName: "대용가", headerText: "대용가");
dgvStockInfo.Columns.Add(columnName: "PER", headerText: "PER");
dgvStockInfo.Columns.Add(columnName: "EPS", headerText: "EPS");
dgvStockInfo.Columns.Add(columnName: "ROE", headerText: "ROE");
dgvStockInfo.Columns.Add(columnName: "PBR", headerText: "PBR");
dgvStockInfo.Columns.Add(columnName: "EV", headerText: "EV");
dgvStockInfo.Columns.Add(columnName: "BPS", headerText: "BPS");
dgvStockInfo.Columns.Add(columnName: "매출액", headerText: "매출액");
dgvStockInfo.Columns.Add(columnName: "영업이익", headerText: "영업이익");
dgvStockInfo.Columns.Add(columnName: "당기순이익", headerText: "당기순이익");
dgvStockInfo.Columns.Add(columnName: "최고250", headerText: "최고250");
dgvStockInfo.Columns.Add(columnName: "최저250", headerText: "최저250");
dgvStockInfo.Columns.Add(columnName: "최고가일250", headerText: "최고가일250");
dgvStockInfo.Columns.Add(columnName: "최고가대비율250", headerText: "최고가대비율250");
dgvStockInfo.Columns.Add(columnName: "최저가일250", headerText: "최저가일250");
dgvStockInfo.Columns.Add(columnName: "최저가대비율250", headerText: "최저가대비율250");
dgvStockInfo.Columns.Add(columnName: "유통주식", headerText: "유통주식");
dgvStockInfo.Columns.Add(columnName: "유통비율", headerText: "유통비율");
dgvStockInfo.Columns.Add(columnName: "종가", headerText: "종가");
dgvStockInfo.Columns.Add(columnName: "전일대비기호", headerText: "전일대비기호");
dgvStockInfo.Columns.Add(columnName: "전일대비", headerText: "전일대비");
dgvStockInfo.Columns.Add(columnName: "등락율", headerText: "등락율");
dgvStockInfo.Columns.Add(columnName: "거래량", headerText: "거래량");
dgvStockInfo.Columns.Add(columnName: "거래대금", headerText: " 거래대금");
ClsDataGridViewUtil clsDataGridViewUtil = new ClsDataGridViewUtil();
clsDataGridViewUtil.RemoveGridViewRow(dgvStockInfo);
_row = 0;
}
public FrmThemaManage()
{
InitializeComponent();
_clsDataGridViewUtil = new ClsDataGridViewUtil();
ucStockList1.OnSelectedStockCode += new Uc.UcStockList.OnSelectedStockCodeEventHandler(OnSelectedStockCode);
GetThemaGroupData();
}
public void GetDartInfo(string stockCode)
{
if (stockCode == null)
{
return;
}
DataTable dt = new DataTable();
ClsDartApi clsDartApi = new ClsDartApi();
dt = clsDartApi.GetDartSearchByDate(stockCode: stockCode, crtfc_key: "", corp_code: "", bgn_de: DateTime.Now.Date.AddMonths(-6).ToString("yyyyMMdd"), end_de: DateTime.Now.Date.ToString("yyyyMMdd"),
last_report_at: "N", pbIntf_ty: "", pblntf_detail_ty: "A", corp_cls: "", sort: "date", sort_mth: "desc", page_no: "1", page_count: "10").Tables[0].Copy();
ClsDataGridViewUtil clsDataGridViewUtil = new ClsDataGridViewUtil();
if (chkAddSearch.Checked == true)
{
// clsDataGridViewUtil.RemoveGridViewRow(dgvNaverSearch);
}
else
{
clsDataGridViewUtil.RemoveGridViewRow(dgvDartView);
_row = 0;
}
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
dgvDartView.Rows.Add();
dgvDartView.Rows[_row].Cells["rcept_no"].Value = dr["rcept_no"].ToString().Trim();
dgvDartView.Rows[_row].Cells["rcept_dt"].Value = dr["rcept_dt"].ToString().Trim();
dgvDartView.Rows[_row].Cells["corp_code"].Value = dr["corp_code"].ToString().Trim();
dgvDartView.Rows[_row].Cells["stock_code"].Value = dr["stock_code"].ToString().Trim();
dgvDartView.Rows[_row].Cells["report_nm"].Value = dr["report_nm"].ToString().Trim();
dgvDartView.Rows[_row].Cells["stock_name"].Value = dr["corp_name"].ToString().Trim();
if (Convert.ToInt32(DateTime.Now.AddDays(-7).ToString("yyyyMMdd")) < Convert.ToInt32(dr["rcept_dt"].ToString()))
{
dgvDartView.Rows[_row].DefaultCellStyle.ForeColor = Color.Red;
}
_row = _row + 1;
}
}
dt = null;
}
private void SearchNews()
{
try
{
if (chkStockName.Checked == true)
{
textBoxKeyword.Text = ClsAxKH.GetMasterCodeName(_stockCode);
}
else
{
textBoxKeyword.Text = _stockCode;
}
ClsDataGridViewUtil clsDataGridViewUtil = new ClsDataGridViewUtil();
if (chkAddSearch.Checked == true)
{
// clsDataGridViewUtil.RemoveGridViewRow(dgvNaverSearch);
}
else
{
clsDataGridViewUtil.RemoveGridViewRow(dgvNaverSearch);
_row = 0;
}
string results = getResults();
results = results.Replace("<b>", "");
results = results.Replace("</b>", "");
results = results.Replace("<", "<");
results = results.Replace(">", ">");
var parseJson = JObject.Parse(results);
var countsOfDisplay = Convert.ToInt32(parseJson["display"]);
var countsOfResults = Convert.ToInt32(parseJson["total"]);
for (int i = 0; i < countsOfDisplay; i++)
{
var title = parseJson["items"][i]["title"].ToString();
title = title.Replace(""", "\"");
var description = parseJson["items"][i]["description"].ToString();
description = description.Replace(""", "\"");
var link = parseJson["items"][i]["link"].ToString();
if (_row > 0 && dgvNaverSearch.Rows[0].Cells["No"].Value.ToString() != "")
{
DataGridViewRow dataGridViewRow = (DataGridViewRow)dgvNaverSearch.Rows[0].Clone();
dataGridViewRow.Cells[0].Value = (_row = +1).ToString();
dataGridViewRow.Cells[1].Value = textBoxKeyword.Text;
dataGridViewRow.Cells[2].Value = title;
dataGridViewRow.Cells[3].Value = description;
dataGridViewRow.Cells[4].Value = link;
dgvNaverSearch.Rows.Insert(0, dataGridViewRow);
}
else
{
dgvNaverSearch.Rows.Add();
dgvNaverSearch.Rows[_row].Cells["No"].Value = (_row + 1).ToString();
dgvNaverSearch.Rows[_row].Cells["검색명"].Value = textBoxKeyword.Text;
dgvNaverSearch.Rows[_row].Cells["제목"].Value = title;
dgvNaverSearch.Rows[_row].Cells["본문"].Value = description;
dgvNaverSearch.Rows[_row].Cells["링크"].Value = link;
}
_row = _row + 1;
}
}
catch (Exception exc)
{
Debug.WriteLine(exc.Message);
}
}
