public static void LoadData(baseDS.priceDataDataTable tbl, string timeScale, DateTime frDate, string stockCode) { WriteLog(common.SysSeverityLevel.Informational, "", timeScale + " " + frDate.ToString() + " " + stockCode); string eCode = "DB000"; try { if (tbl.Count > 0) { common.SysLog.WriteLog(DateTime.Now.ToString() + common.Consts.constTab + "test 00: LoadData ", Settings.sysFileUserLog); } priceDataTA.ClearBeforeFill = false; if (timeScale == AppTypes.MainDataTimeScale.Code) { eCode = "DB001"; priceDataTA.FillByCodeFromDate(tbl, stockCode, frDate); } else { eCode = "DB002 " + priceDataTA.Connection.State.ToString(); priceDataTA.FillByTypeCodeFromDate(tbl, timeScale, stockCode, frDate); } } catch (Exception er) { WriteLog(common.SysSeverityLevel.Error, eCode, er); } }
//public static void LoadAbnormalData(baseDS.priceDataDataTable tbl, string code, DateTime frDate, DateTime toDate, string timeScale) //{ // priceDataTA.ClearBeforeFill = false; // if (timeScale == AppTypes.MainDataTimeScale.Code) // { // priceDataTA.FillAbnormal(tbl, code, frDate, toDate); // } // else // { // priceDataTA.FillAbnomalSumData(tbl, code, timeScale, frDate, toDate); // } //} public static void LoadData(baseDS.priceDataDataTable tbl, string timeScale, DateTime frDate, DateTime toDate, string stockCode) { priceDataTA.ClearBeforeFill = false; if (timeScale == AppTypes.MainDataTimeScale.Code) { if (frDate == DateTime.MinValue && toDate == DateTime.MaxValue) { priceDataTA.FillByCode(tbl, stockCode); } else { priceDataTA.FillByDateCode(tbl, frDate, toDate, stockCode); } } else { if (frDate == DateTime.MinValue && toDate == DateTime.MaxValue) { priceDataTA.FillByTypeCode(tbl, timeScale, stockCode); } else { priceDataTA.FillByTypeDateCode(tbl, timeScale, frDate, toDate, stockCode); } } }
public static baseDS.priceDataRow GetLastPriceData(string stockCode) { baseDS.priceDataDataTable priceTbl = priceDataTA.GetLastPrice(stockCode); if (priceTbl.Count == 0) { return(null); } return(priceTbl[0]); }
public static void UpdateData(baseDS.priceDataDataTable tbl) { try { priceDataTA.Update(tbl); tbl.AcceptChanges(); } catch (Exception e) { foreach (baseDS.priceDataRow row in tbl.Rows) { if (row.HasErrors) { WriteSyslog(e, row.stockCode + " Date: " + row.onDate); } } } }
public static void LoadData(baseDS.priceDataDataTable tbl, string timeScale, string stockCode, int maxCount) { string dataTbl = ""; string cond = "stockCode=N'" + stockCode.Trim() + "'"; if (timeScale == AppTypes.MainDataTimeScale.Code) { dataTbl = "priceData"; } else { dataTbl = "priceDataSum"; cond += (cond == ""?"" : " AND ") + "type=N'" + timeScale + "'"; } string sqlCmd = "SELECT * FROM " + "(SELECT TOP " + maxCount.ToString() + " onDate,stockCode,openPrice,closePrice,lowPrice,highPrice,volume FROM " + dataTbl + common.Consts.constCRLF + "WHERE " + cond + " ORDER BY onDate DESC)a" + common.Consts.constCRLF + "ORDER BY onDate"; LoadFromSQL(tbl, sqlCmd); }
//public static void LoadAbnormalData(baseDS.priceDataDataTable tbl, string code, DateTime frDate, DateTime toDate, string timeScale) //{ // priceDataTA.ClearBeforeFill = false; // if (timeScale == AppTypes.MainDataTimeScale.Code) // { // priceDataTA.FillAbnormal(tbl, code, frDate, toDate); // } // else // { // priceDataTA.FillAbnomalSumData(tbl, code, timeScale, frDate, toDate); // } //} public static void LoadData(baseDS.priceDataDataTable tbl, string timeScale, DateTime frDate, DateTime toDate, string stockCode) { try { common.SysLog.WriteLog("AAA0: ", Settings.sysFileUserLog); //priceDataTA.Connection.ConnectionString = @"Data Source=HAIQUAN\MSSQLSERVER2008;Initial Catalog=stock;User ID=sa;Password=123"; common.SysLog.WriteLog("AAA: " + priceDataTA.Connection.ConnectionString, Settings.sysFileUserLog); priceDataTA.ClearBeforeFill = false; if (timeScale == AppTypes.MainDataTimeScale.Code) { if (frDate == DateTime.MinValue && toDate == DateTime.MaxValue) { priceDataTA.FillByCode(tbl, stockCode); } else { priceDataTA.FillByDateCode(tbl, frDate, toDate, stockCode); } } else { if (frDate == DateTime.MinValue && toDate == DateTime.MaxValue) { priceDataTA.FillByTypeCode(tbl, timeScale, stockCode); } else { priceDataTA.FillByTypeDateCode(tbl, timeScale, frDate, toDate, stockCode); } } } catch (Exception er) { WriteLog(common.SysSeverityLevel.Alert, "ABC", er); } }
public static void LoadDataOneRow(baseDS.priceDataDataTable tbl, DateTime frDate, DateTime toDate, string stockCode) { priceDataTA.ClearBeforeFill = false; priceDataTA.FillOneByDateStockCode(tbl, frDate, toDate, stockCode); }
public static void UpdateData(baseDS.priceDataDataTable tbl) { priceDataTA.Update(tbl); tbl.AcceptChanges(); }
private void InitAndDrawIndexes() { baseDS.priceDataDataTable tbl1 = Gateway.PriceData.GetPriceData("VN-IDX", "D1", DateTime.Now.AddDays(-20), DateTime.Now); baseDS.priceDataDataTable tbl2 = Gateway.PriceData.GetPriceData("HNX-IDX", "D1", DateTime.Now.AddDays(-20), DateTime.Now); #region VNINDEX decimal[] yValues = new decimal[tbl1.Count]; string[] xValues = new string[tbl1.Count]; for (int idx = 0; idx < tbl1.Count; idx++) { yValues[idx] = tbl1[idx].closePrice; xValues[idx] = tbl1[idx].onDate.ToShortDateString(); } Chart lineChart = lineCurvesChartType1.getChart(); lineChart.Series["Series1"].LegendText = "VN-Index"; lineChart.Series["Series1"].XValueType = ChartValueType.Date; lineChart.Series["Series1"].YValueType = ChartValueType.Int32; //lineChart.Legends["Series1"].Title = "VN-Index"; //lineChart.Legends["Series1"].DockedToChartArea = "Default"; lineChart.Series["Series1"].MarkerStyle = MarkerStyle.None; lineChart.Series["Series1"].Points.DataBindXY(xValues, yValues); lineChart.Series["Series1"].Color = System.Drawing.Color.Red; lineChart.Series["Series1"].IsValueShownAsLabel = true; // Set Doughnut chart type lineChart.Series["Series1"].ChartType = SeriesChartType.Line; // Set labels style lineChart.Series["Series1"]["PieLabelStyle"] = "Inside"; // Set Doughnut radius percentage lineChart.Series["Series1"]["DoughnutRadius"] = "99"; // Explode data point with label "Italy" lineChart.Series["Series1"].Points[yValues.Length - 1]["Exploded"] = "true"; // Enable 3D lineChart.ChartAreas["Default"].Area3DStyle.Enable3D = false; lineChart.ChartAreas["Default"].AxisX.IsMarginVisible = true; // Set drawing style lineChart.Series["Series1"]["PieDrawingStyle"] = "SoftEdge"; #endregion VNINDEX //HNX series #region HNX //decimal[] yValues2 = new decimal[tbl2.Count]; //string[] xValues2 = new string[tbl2.Count]; //for (int idx = 0; idx < tbl2.Count; idx++) //{ // yValues2[idx] = tbl2[idx].closePrice; // xValues2[idx] = tbl2[idx].onDate.ToShortDateString(); //} //lineChart.Series["Series2"].XValueType = ChartValueType.Date; //lineChart.Series["Series2"].YValueType = ChartValueType.Int32; //lineChart.Series["Series2"].Points.DataBindXY(xValues2, yValues2); //lineChart.Series["Series2"].Color = Color.Green; //lineChart.Series["Series2"].IsValueShownAsLabel = true; //lineChart.Series["Series2"].LegendText = "HNX-Index"; ////lineChart.Series["Series2"].Label = //// Set Doughnut chart type //lineChart.Series["Series2"].ChartType = SeriesChartType.Line; //// Set labels style //lineChart.Series["Series2"]["PieLabelStyle"] = "Inside"; //// Explode data point with label "Italy" //lineChart.Series["Series2"].Points[yValues2.Length - 1]["Exploded"] = "true"; #endregion HNX //END HNX series Title title4 = new Title(); title4.Font = new System.Drawing.Font("Trebuchet MS", 14.25F, System.Drawing.FontStyle.Bold); title4.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(26)))), ((int)(((byte)(59)))), ((int)(((byte)(105))))); title4.Name = "Title1"; title4.ShadowColor = System.Drawing.Color.FromArgb(((int)(((byte)(32)))), ((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(0))))); title4.ShadowOffset = 1; title4.Text = "BIỂU ĐỒ CHỈ SỐ VN-INDEX TUẦN QUA"; lineChart.Titles.Clear(); lineChart.Titles.Add(title4); }