Exemple #1
0
        private void dataImptBtnStkHeadImport_Click(object sender, EventArgs e)
        {
            BLLDataImport bllDaImpt = new BLLDataImport(CommProp.ConnectionString);

            UIInProcess(true);

            try
            {
                bllDaImpt.OpenConnection();

                bllDaImpt.ImportStockHead();

                Console.WriteLine("执行完成!");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                bllDaImpt.CloseConnection();
            }

            UIInProcess(false);
        }
Exemple #2
0
        private string LoadFileList_TDXDayFile(bool isComposite)
        {
            StringBuilder sb        = new StringBuilder();
            BLLDataImport bllDaImpt = new BLLDataImport(CommProp.ConnectionString);

            try
            {
                bllDaImpt.OpenConnection();

                AllFile.Clear();
                List <string> lstFullName = bllDaImpt.GetMatchedTDXDayFileFullNameList(isComposite);
                foreach (string fullName in lstFullName)
                {
                    AllFile.Add(new FileInfo(fullName));
                    sb.AppendLine(fullName);
                }
            }
            finally
            {
                bllDaImpt.CloseConnection();
            }

            //一行一行显示文件名
            return(sb.ToString().TrimEnd(Environment.NewLine.ToCharArray()));;
        }
Exemple #3
0
        private void bkgDataImport_DoWork(object sender, DoWorkEventArgs e)
        {
            // < 覆盖,指数,TDX文件,K线级别 >
            TupleValue <bool, bool, bool, KLineType> arg = (TupleValue <bool, bool, bool, KLineType>)e.Argument;
            BLLDataImport bllDaImpt   = new BLLDataImport(CommProp.ConnectionString);
            bool          isConvert   = arg.Value1;
            bool          isComposite = arg.Value2;
            bool          useTDXFile  = arg.Value3;
            KLineType     kLineType   = arg.Value4;

            UIInProcess(true);
            _processCancel = false;

            if (useTDXFile)
            {
                this.LoadFileList_TDXDayFile(isComposite);
            }
            else
            {
                this.LoadFileList_exportFile();
            }

            // List<TupleValue<完整文件名, StockHead>>
            List <TupleValue <string, StockHead> > lstStockData = bllDaImpt.LoadMrkTypeAndCodeFromDataFile(AllFile, isComposite, useTDXFile);

            if (lstStockData.Count > 0)
            {
                Stopwatch stopWatch = Stopwatch.StartNew();

                try
                {
                    bllDaImpt.OpenConnection();
                    int    count        = lstStockData.Count;
                    int    insLineCount = 0;
                    string msgString    = string.Empty;

                    // 显示百分比提示信息
                    Action <int, int, int> showMsg = ((per, all, lineCnt) =>
                    {
                        SysFunction.BackspaceInConsole(msgString, txtConsole);
                        msgString = string.Format("{0} / {1},已导入:{2} 行)", per, all, lineCnt.ToString("N0"));
                        Console.Write(msgString);
                    });

                    Console.Write("正在导入...(");
                    // 是否需要删表动作,如果表中无记录,则省去 Delete 动作
                    bool haveRecord = bllDaImpt.GetTableRecordCount(BLL.GetKLineDBTableName(kLineType, isComposite)) > 0;
                    for (int i = 0; i < count; i++)
                    {
                        showMsg(i + 1, count, insLineCount);

                        // TupleValue<完整文件名, StockHead>
                        TupleValue <string, StockHead> stkData = lstStockData[i];

                        insLineCount += bllDaImpt.InsertStkKLine(stkData, isConvert, isComposite, useTDXFile, kLineType, haveRecord);

                        // 最后一批完成后,再刷一下
                        if (i == count - 1)
                        {
                            showMsg(i + 1, count, insLineCount);
                        }

                        if (_processCancel)
                        {
                            break;
                        }
                    }

                    if (_processCancel)
                    {
                        Console.WriteLine("  导入终止!");
                    }
                    else
                    {
                        Console.WriteLine("  导入完成!");
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
                finally
                {
                    bllDaImpt.CloseConnection();
                    _processCancel = false;
                    Console.WriteLine("总耗时:{0}", stopWatch.Elapsed);
                }
            }

            UIInProcess(false);
        }