Example #1
0
        public static Dictionary <string, int> VerifyExceed90Day(List <String> ShareClassIdList)
        {
            Dictionary <string, int> toCheckDic = new Dictionary <string, int>();

            try
            {
                string ShareClassIdString = "";
                string sql = "select ShareClassId,ISNULL(LastTradeDate,TradingDate) LastTradeDate from ( select  row_number() over(partition by ShareClassId order by TradingDate desc) as rownum,ShareClassId ,LastTradeDate,TradingDate from CentralRawData..HistoricalRawPrice where ShareClassId in (" + ShareClassIdString + ")) AA where AA.rownum=1 ";

                AccessOutputDB accessOutputDB = new AccessOutputDB();  //LastTradingDate
                DataSet        ds             = accessOutputDB.getEquityXOICurrentShareClassInfo("0P000002RH");

                foreach (var ShareClassId in ShareClassIdList)
                {
                    toCheckDic.Add(ShareClassId, 0);
                }


                foreach (DataRow raw in ds.Tables[0].Rows)
                {
                    toCheckDic[raw["ShareClassId"].ToString()] = Int32.Parse(raw["LastTradingDate"].ToString());
                }

                foreach (KeyValuePair <string, int> pair in toCheckDic)
                {
                    if (pair.Value >= 90)
                    {
                        Tool.LogFile("Info:[" + pair.Key + "]超过90天");
                    }
                    else
                    {
                        Tool.LogFile("Info:[" + pair.Key + "]没有超过90天");
                    }
                }
                return(toCheckDic);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error:" + ex.ToString());
                return(toCheckDic);
            }
            //WebServiceCheck.LoginGID();
            //WebServiceCheck.test();
        }
Example #2
0
        public static bool VerifyExceed90Day(string ShareClassIdList)
        {
            bool isExceed = false;

            try
            {
                AccessOutputDB accessOutputDB  = new AccessOutputDB();
                DataSet        ds              = accessOutputDB.getEquityXOICurrentShareClassInfo(ShareClassIdList);
                DateTime       nowDate         = DateTime.Now;
                DateTime       lastTradingDate = DateTime.Parse(ds.Tables[0].Rows[0]["LastTradingDate"].ToString());
                return(Int32.Parse((nowDate - lastTradingDate).TotalDays.ToString()) > 90?true:false);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error:[" + ShareClassIdList + "查询验证是否超过90天]" + ex.ToString());
                Tool.LogFile("Error:[" + ShareClassIdList + "查询验证是否超过90天]");
                return(isExceed);
            }
        }