Exemplo n.º 1
0
        static void getZTB()
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {

                connection.Open();
                SqlCommand command = connection.CreateCommand();

                command.Connection = connection;

                string cmd = "SELECT * from [ZTB]";
                command.CommandText = cmd;

                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Stock stock = new Stock();
                    stock.ID = reader["ID"].ToString().Trim();
                    stock.Name = reader["Name"].ToString().Trim();
                    stock.Price = reader["Price"].ToString().Trim();
                    stock.SPJ = reader["spj"].ToString().Trim();
                    stock.CJL = reader["cjl"].ToString().Trim();
                    stock.Buy1 = reader["buy1"].ToString().Trim();
                    stock.Sale1 = reader["sale1"].ToString().Trim();
                    stock.Time = reader["time"].ToString().Trim();
                    stock.ZF = 10;
                    ztbList.Add(stock);
                }
            }
        }
Exemplo n.º 2
0
        static void getBuy()
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {

                connection.Open();
                SqlCommand command = connection.CreateCommand();

                command.Connection = connection;

                string cmd = "SELECT * from [Trade]";
                command.CommandText = cmd;

                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Stock stock = new Stock();
                    stock.ID = reader["ID"].ToString().Trim();
                    stock.Name = reader["Name"].ToString().Trim();
                    stock.Price = reader["Price"].ToString().Trim();
                    stock.Time = reader["time"].ToString().Trim();
                    prebuyList.Add(stock);
                }
            }
        }
Exemplo n.º 3
0
        static void getCurrentVal()
        {
            WebRequest myReq;
            WebResponse myRes;
            string result;

            //sh
            for (int i = 0; i < shIDList.Count; i += 10)
            {
                string url = "http://hq.sinajs.cn/list=";
                for (int j = 0; j < 9; j++)
                {
                    if (j + i >= shIDList.Count) break;
                    url = url + "sh" + shIDList[j + i] + ",";
                }
                myReq = WebRequest.Create(url);
                myRes = myReq.GetResponse();
                Stream resStream = myRes.GetResponseStream();
                StreamReader sr = new StreamReader(resStream, Encoding.Default);

                int index = i;
                while ((result = sr.ReadLine()) != null)
                {
                    int start = result.IndexOf("\"");
                    int end = result.LastIndexOf("\"");
                    string[] val = result.Substring(start + 1, end - start - 1).Split(',');

                    if (val.Length < 5)
                    {
                        continue;  //tuishi
                    }
                    Console.WriteLine(val[0]);
                    Stock stock = new Stock();
                    stock.ID = shIDList[index];
                    stock.Name = val[0];
                    stock.Price = val[3];
                    stock.SPJ = val[2];
                    stock.CJL = Math.Ceiling((double.Parse(val[9]) / 10000)).ToString();
                    stock.Buy1 = val[10];
                    stock.Sale1 = val[20];
                    stock.Time = val[31];
                    stock.ZF = (double.Parse(stock.Price) - double.Parse(stock.SPJ)) * 100 / double.Parse(stock.SPJ);
                    stockList.Add(stock);
                    index += 1;

                }

            }

            //SZ
            for (int i = 0; i < szIDList.Count; i += 10)
            {
                string url = "http://hq.sinajs.cn/list=";
                for (int j = 0; j < 9; j++)
                {
                    if (j + i >= szIDList.Count) break;
                    url = url + "sz" + szIDList[j + i] + ",";
                }
                myReq = WebRequest.Create(url);
                myRes = myReq.GetResponse();
                Stream resStream = myRes.GetResponseStream();
                StreamReader sr = new StreamReader(resStream, Encoding.Default);

                int index = i;
                while ((result = sr.ReadLine()) != null)
                {
                    int start = result.IndexOf("\"");
                    int end = result.LastIndexOf("\"");
                    string[] val = result.Substring(start + 1, end - start - 1).Split(',');

                    if (val.Length < 5)
                    {
                        continue;  //tuishi
                    }
                    Console.WriteLine(val[0]);
                    Stock stock = new Stock();
                    stock.ID = szIDList[index];
                    stock.Name = val[0];
                    stock.Price = val[3];
                    stock.SPJ = val[2];
                    stock.CJL = Math.Ceiling((double.Parse(val[9]) / 10000)).ToString();
                    stock.Buy1 = val[10];
                    stock.Sale1 = val[20];
                    stock.Time = val[31];

                    stock.ZF = (double.Parse(stock.Price) - double.Parse(stock.SPJ)) * 100 / double.Parse(stock.SPJ);
                    stockList.Add(stock);

                    index += 1;

                }

            }

            Console.WriteLine("Get d-val finish");
        }