示例#1
0
        public override int run(string[] args)
        {
            shutdownOnInterrupt();
            try
            {
                string endpoint = string.Format("default:tcp -p {0}", ConfigMain.GetConfigValue(BaseCommon.CONFIGICEPORT));
                _ic = communicator();
                ObjectAdapter adapter = _ic.createObjectAdapterWithEndpoints("AASDataServer", endpoint);

                IceDataService dataService = new IceDataService();
                adapter.add(dataService, _ic.stringToIdentity("AASDataServer/DataServant"));
                adapter.activate();
                _isRunning = true;
                LogHelper.Instance.Info(Title + "已启动,端口:" + endpoint);
                _ic.waitForShutdown();
                if (interrupted())
                {
                    LogHelper.Instance.Info(Title + "已中断");
                    return(1);
                }
                LogHelper.Instance.Info(Title + "已停止");
                _isRunning = false;
                return(0);
            }
            catch (System.Exception ex)
            {
                _isRunning = false;
                LogHelper.Instance.Info(Title + "运行出错" + ex);
                return(1);
            }
        }
示例#2
0
        private bool Bind()
        {
            try
            {
                int i = 1;

                socketPub.Bind(string.Format("tcp://*:{0}", ConfigMain.GetConfigValue(BaseCommon.CONFIGPUBPORT)));
                LogHelper.Instance.Info("pub数据端口:" + ConfigMain.GetConfigValue(BaseCommon.CONFIGPUBPORT));

                foreach (var item in dictMyZmq.Values)
                {
                    item.Socket.Connect(string.Format("tcp://{0}:{1}", item.Ip, item.Port));
                    LogHelper.Instance.Info(string.Format("Sub数据地址{0}:{1}:{2}", i, item.Ip, item.Port));
                    item.Socket.SubscribeAll();
                    Thread.Sleep(100);
                    i++;
                }
            }
            catch (System.Exception ex)
            {
                LogHelper.Instance.Info("异常:" + ex.ToString());
                return(false);
            }


            return(true);
        }
示例#3
0
        void MainWindow_Loaded(object sender, RoutedEventArgs e)
        {
            this.dgLogs.ItemsSource = ocLog;
            port        = ConfigMain.GetConfigValue("ServicePort", "42808");
            serverIP    = ConfigMain.GetConfigValue("ServiceIp", "localhost");
            this.Title += string.Format(" [端口:{0}]", port);

            Task task = new Task(InitService);

            task.Start();
        }
示例#4
0
        private bool Bind()
        {
            try
            {
                contextPubMarket = new ZContext();
                contextSubMarket = new ZContext();
                contextPubTran   = new ZContext();
                contextSubTran   = new ZContext();

                socketPubMarket = new ZSocket(contextPubMarket, ZSocketType.PUB);
                socketSubMarket = new ZSocket(contextSubMarket, ZSocketType.SUB);
                socketPubTran   = new ZSocket(contextPubTran, ZSocketType.PUB);
                socketSubTran   = new ZSocket(contextSubTran, ZSocketType.SUB);

                socketPubMarket.Bind(string.Format("tcp://*:{0}", ConfigMain.GetConfigValue(BaseCommon.CONFIGMARKETPUBPORT)));
                LogHelper.Instance.Info("pubMarket数据端口:" + ConfigMain.GetConfigValue(BaseCommon.CONFIGMARKETPUBPORT));
                //socketPubMarket.SendTimeout = TimeSpan.FromSeconds(60);

                //socketSubMarket.ReceiveTimeout = TimeSpan.FromSeconds(60);
                //socketSubMarket.ReconnectInterval = TimeSpan.FromSeconds(60);
                socketSubMarket.Connect(string.Format("tcp://{0}:{1}", ip, ConfigMain.GetConfigValue(BaseCommon.CONFIGMARKETSUBPORT)));
                LogHelper.Instance.Info("SubMarket数据端口:" + ip + ":" + ConfigMain.GetConfigValue(BaseCommon.CONFIGMARKETSUBPORT));
                socketSubMarket.SubscribeAll();


                socketPubTran.Bind(string.Format("tcp://*:{0}", ConfigMain.GetConfigValue(BaseCommon.CONFIGTRANSPUBPORT)));
                LogHelper.Instance.Info("pubTransaction数据端口:" + ConfigMain.GetConfigValue(BaseCommon.CONFIGTRANSPUBPORT));
                //socketPubTran.SendTimeout = TimeSpan.FromSeconds(60);

                //socketSubTran.ReceiveTimeout = TimeSpan.FromSeconds(60);
                //socketSubTran.ReconnectInterval = TimeSpan.FromSeconds(60);
                socketSubTran.Connect(string.Format("tcp://{0}:{1}", ip, ConfigMain.GetConfigValue(BaseCommon.CONFIGTRANSSUBPORT)));
                LogHelper.Instance.Info("SubTransaction数据端口:" + ip + ":" + ConfigMain.GetConfigValue(BaseCommon.CONFIGTRANSSUBPORT));
                socketSubTran.SubscribeAll();

                ////socketSubMarket.TcpKeepAlive = TcpKeepaliveBehaviour.Enable;
                ////socketPubMarket.TcpKeepAliveInterval = 60 * 1000;

                ////socketPubTran.TcpKeepAlive = TcpKeepaliveBehaviour.Enable;
                ////socketPubTran.TcpKeepAliveInterval = 60 * 1000;
            }
            catch (System.Exception ex)
            {
                LogHelper.Instance.Info("异常:" + ex.ToString());
                return(false);
            }


            return(true);
        }
示例#5
0
 private void MainForm_Load(object sender, EventArgs e)
 {
     port = ConfigMain.GetConfigValue("ServicePort");
     if (string.IsNullOrEmpty(port))
     {
         port = "80";
     }
     serverIP = ConfigMain.GetConfigValue("ServiceIp");
     if (string.IsNullOrEmpty(serverIP))
     {
         serverIP = "localhost";
     }
     this.Text += string.Format(" [端口:{0}]", port);
     this.backgroundWorker1.RunWorkerAsync();
 }
示例#6
0
        public void RunWork()
        {
            ip = ConfigMain.GetConfigValue(BaseCommon.CONFIGIP);
            bool outErr = false;

            writeTxt  = bool.TryParse(ConfigMain.GetConfigValue(BaseCommon.CONFIGWRITETXT), out outErr);
            tranCache = new ConcurrentQueue <ZMessage>();
            tranCount = 0;
            dataCache = new ConcurrentQueue <ZMessage>();
            dataCount = 0;

            if (Bind())
            {
                pubMarketThread = new Thread(new ThreadStart(PubMarket))
                {
                    IsBackground = true
                };
                pubMarketThread.Start();

                subMarketThread = new Thread(new ThreadStart(SubMarket))
                {
                    IsBackground = true
                };
                subMarketThread.Start();

                pubTransThread = new Thread(new ThreadStart(PubTransaction))
                {
                    IsBackground = true
                };
                pubTransThread.Start();

                subTransThread = new Thread(new ThreadStart(SubTransaction))
                {
                    IsBackground = true
                };
                subTransThread.Start();
                if (writeTxt)
                {
                    //marketWriteCache = new ConcurrentQueue<ZMessage>();
                    //tranWriteCache = new ConcurrentQueue<ZMessage>();

                    //writeMarketThread = new Thread(new ThreadStart(WriteMarket)) { IsBackground = true };
                    //writeMarketThread.Start();
                    //writeTranThread = new Thread(new ThreadStart(WriteTran)) { IsBackground = true };
                    //writeTranThread.Start();
                }
            }
        }
示例#7
0
        private bool Init()
        {
            try
            {
                dictMyZmq = new Dictionary <string, MyZmq>();
                dataCache = new ConcurrentQueue <ZMessage>();

                ip   = ConfigMain.GetConfigValue(BaseCommon.CONFIGIP).Split(',');
                port = ConfigMain.GetConfigValue(BaseCommon.CONFIGSUBPORT).Split(',');
                if (ip.Length == 0 || port.Length == 0)
                {
                    return(false);
                }
                for (int i = 0; i < port.Length; i++)
                {
                    //if (i < ip.Length)
                    //{
                    //    MyZmq mq = new MyZmq();
                    //    mq.Ip = ip[i].Trim();
                    //    mq.Port = int.Parse(port[i].Trim());
                    //    mq.Socket = new ZSocket(new ZContext(), ZSocketType.SUB);
                    //    dictMyZmq.Add(string.Format("{0}:{1}", mq.Ip, mq.Port), mq);
                    //}
                    //else
                    //{
                    //    MyZmq mq = new MyZmq();
                    //    mq.Ip = ip[i - 1].Trim();
                    //    mq.Port = int.Parse(port[i].Trim());
                    //    mq.Socket = new ZSocket(new ZContext(), ZSocketType.SUB);
                    //    dictMyZmq.Add(string.Format("{0}:{1}", mq.Ip, mq.Port), mq);
                    //}
                    MyZmq mq = new MyZmq();
                    mq.Ip     = ip[0].Trim();
                    mq.Port   = int.Parse(port[i].Trim());
                    mq.Socket = new ZSocket(new ZContext(), ZSocketType.SUB);
                    dictMyZmq.Add(string.Format("{0}:{1}", mq.Ip, mq.Port), mq);
                }
                contextPub = new ZContext();
                socketPub  = new ZSocket(contextPub, ZSocketType.PUB);
            }
            catch (Exception ex)
            {
                LogHelper.Instance.Error("Init:" + ex.Message);
                return(false);
            }

            return(true);
        }
示例#8
0
        private void FormLogin_Load(object sender, EventArgs e)
        {
            InitService();
            string userName = ConfigMain.GetConfigValue("userName");
            string userPwd  = ConfigMain.GetConfigValue("userPwd");

            if (userName != string.Empty && userPwd != string.Empty)
            {
                this.txtUserName.Text  = userName;
                this.txtUserPwd.Text   = CommonUtils.DecryptDES(userPwd, CommonUtils.encryptKey);
                this.chkBoxPwd.Checked = true;
            }
            else
            {
                chkBoxPwd.Checked = false;
            }
        }
示例#9
0
        private bool InitService()
        {
            if (Program.DataServiceClient != null)
            {
                return(true);
            }

            servicePort = ConfigMain.GetConfigValue("ServicePort");
            if (string.IsNullOrEmpty(servicePort))
            {
                MessageBox.Show("通讯连接端口为空", "Error");
            }
            serviceIp = ConfigMain.GetConfigValue("ServiceIp");
            if (string.IsNullOrEmpty(serviceIp))
            {
                MessageBox.Show("通讯连接IP为空", "Error");
            }
            string endPoint = string.Format("http://{0}:{1}/", serviceIp, servicePort);

            var httpBinding = new WSHttpBinding(SecurityMode.None);

            httpBinding.MaxReceivedMessageSize = 2147483647;
            httpBinding.ReceiveTimeout         = new TimeSpan(0, 0, 10);
            httpBinding.UseDefaultWebProxy     = false;

            EndpointIdentity ei = null;

            ei = EndpointIdentity.CreateDnsIdentity(serviceIp);
            var endpointAddress = new EndpointAddress(new Uri(endPoint), ei);

            Program.DataServiceClient = new DataServiceClient(httpBinding, endpointAddress);
            if (Program.DataServiceClient == null)
            {
                return(false);
            }
            return(true);
        }
示例#10
0
        public bool SendQuotaData(JyDataSet.额度分配DataTable dtLimit, string serverMac)
        {
            try
            {
                if (dtLimit.Rows.Count == 0)
                {
                    Program.logger.LogInfo(string.Format("接收server-{0}的额度分配DataTable.Rows=0", serverMac));
                    return(false);
                }
                //判断当前MAC是否已经更新数据
                string    sqlMac = string.Format("select 更新日期 from dbo.日志表 where 服务器MAC='{0}' and 数据类型='额度'", serverMac);
                DataTable dtMac  = SQLHelper.ExecuteDt(sqlMac);
                if (dtMac.Rows.Count > 0)
                {
                    int cDate = Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd"));
                    if (cDate == Convert.ToInt32(dtMac.Rows[0]["更新日期"].ToString()))
                    {
                        string updateType = ConfigMain.GetConfigValue("UpdateType");
                        if ("0".Equals(updateType))
                        {
                            //删除原有server Mac的数据
                            string sqlDel = string.Format("delete from dbo.额度分配 where 服务器MAC='{0}' and 日期={1}", serverMac, Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd")));
                            SQLHelper.ExecuteSql(sqlDel);
                        }
                    }
                }

                StringBuilder             sb        = new StringBuilder();
                Dictionary <int, decimal> dictPrice = new Dictionary <int, decimal>();
                //sb.Append("begin ");
                Program.logger.LogInfo(string.Format("额度分配数据入库开始:{0},当前server-{1}", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), serverMac));
                foreach (JyDataSet.额度分配Row 额度分配Row1 in dtLimit)
                {
                    decimal closePrice;
                    int     iCode = Convert.ToInt32(额度分配Row1.证券代码.Trim());
                    if (dictPrice.ContainsKey(iCode))
                    {
                        closePrice = dictPrice[iCode];
                    }
                    else
                    {
                        closePrice = CommonUtils.GetClosePrice(额度分配Row1.证券代码.Trim());
                    }
                    string sql = string.Format("insert into dbo.额度分配(交易员,证券代码,组合号,市场,证券名称,拼音缩写,买模式,卖模式,交易额度,手续费率,服务器MAC,收盘价,日期,分组)values('{0}','{1}','{2}',{3},'{4}','{5}',{6},{7},{8},{9},'{10}',{11},{12},'{13}');",
                                               额度分配Row1.交易员,
                                               额度分配Row1.证券代码,
                                               额度分配Row1.组合号,
                                               额度分配Row1.市场,
                                               额度分配Row1.证券名称,
                                               额度分配Row1.拼音缩写,
                                               额度分配Row1.买模式,
                                               额度分配Row1.卖模式,
                                               额度分配Row1.交易额度,
                                               额度分配Row1.手续费率,
                                               serverMac,
                                               closePrice,
                                               Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd")),
                                               额度分配Row1.分组
                                               );
                    //sb.Append(sql);
                    try
                    {
                        SQLHelper.ExecuteSql(sql);
                    }
                    catch (Exception)
                    {
                        continue;
                    }
                }
                //sb.Append(" end;");
                //SQLHelper.ExecuteSql(sb.ToString());

                //更新日志表
                string         sqlLog = string.Empty;
                SqlParameter[] sqlParm;
                if (dtMac.Rows.Count > 0)
                {
                    sqlLog  = "update dbo.日志表 set 更新日期=@更新日期,更新数量=@更新数量 where 服务器MAC=@服务器MAC and 数据类型='委托'";
                    sqlParm = new SqlParameter[] { new SqlParameter("@更新日期", Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd"))), new SqlParameter("@更新数量", dtLimit.Rows.Count), new SqlParameter("@服务器MAC", serverMac) };
                }
                else
                {
                    sqlLog  = "insert into dbo.日志表(服务器MAC,更新数量,数据类型,更新日期)values(@服务器MAC,@更新数量,@数据类型,@更新日期)";
                    sqlParm = new SqlParameter[] { new SqlParameter("@更新日期", Convert.ToInt32(DateTime.Now.ToString("yyyyMMdd"))), new SqlParameter("@更新数量", dtLimit.Rows.Count), new SqlParameter("@数据类型", "额度"), new SqlParameter("@服务器MAC", serverMac) };
                }

                SQLHelper.ExecuteSql(sqlLog, sqlParm);

                Program.logger.LogInfo(string.Format("额度分配数据入库结束:{0},当前server-{1}", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), serverMac));
            }
            catch (Exception ex)
            {
                Program.logger.LogInfo(string.Format("额度分配数据入库异常:{0},当前server-{1}", ex.Message, serverMac));
                return(false);
            }
            return(true);
        }
示例#11
0
        public bool SendWTData(JyDataSet.已发委托DataTable dtWT, string serverMac)
        {
            try
            {
                if (dtWT.Rows.Count == 0)
                {
                    Program.logger.LogInfo(string.Format("接收server-{0}的已发委托DataTable.Rows=0", serverMac));
                    return(false);
                }
                JyDataSet.已发委托Row firstRow1 = dtWT[0];
                //判断当前MAC是否已经更新数据
                string    sqlMac = string.Format("select 更新日期 from dbo.日志表 where 服务器MAC='{0}' and 数据类型='委托'", serverMac);
                DataTable dtMac  = SQLHelper.ExecuteDt(sqlMac);
                if (dtMac.Rows.Count > 0)
                {
                    int cDate = Convert.ToInt32(firstRow1.日期.ToString("yyyyMMdd"));
                    if (cDate == Convert.ToInt32(dtMac.Rows[0]["更新日期"].ToString()))
                    {
                        string updateType = ConfigMain.GetConfigValue("UpdateType");
                        if ("0".Equals(updateType))
                        {
                            //删除原有server Mac的数据
                            string sqlDel = string.Format("delete from dbo.已发委托 where 服务器MAC='{0}' and 日期='{1}'", serverMac, firstRow1.日期.ToString("yyyyMMdd"));
                            SQLHelper.ExecuteSql(sqlDel);
                        }
                    }
                }

                StringBuilder sb = new StringBuilder();
                sb.Append("begin ");
                Program.logger.LogInfo(string.Format("委托数据入库开始:{0},当前server-{1}", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), serverMac));
                foreach (JyDataSet.已发委托Row 已发委托Row1 in dtWT)
                {
                    string sql = string.Format("insert into dbo.已发委托(日期,组合号,委托编号,交易员,状态说明,市场代码,证券代码,证券名称,买卖方向,成交价格,成交数量,委托价格,委托数量,撤单数量,服务器MAC)values('{0}','{1}','{2}','{3}','{4}',{5},'{6}','{7}',{8},'{9}',{10},{11},{12},{13},'{14}');",
                                               已发委托Row1.日期.ToString("yyyyMMdd"),
                                               已发委托Row1.组合号,
                                               已发委托Row1.委托编号,
                                               已发委托Row1.交易员,
                                               已发委托Row1.状态说明,
                                               已发委托Row1.市场代码,
                                               已发委托Row1.证券代码,
                                               已发委托Row1.证券名称,
                                               已发委托Row1.买卖方向,
                                               已发委托Row1.成交价格,
                                               已发委托Row1.成交数量,
                                               已发委托Row1.委托价格,
                                               已发委托Row1.委托数量,
                                               已发委托Row1.撤单数量,
                                               serverMac
                                               );
                    sb.Append(sql);
                }
                sb.Append(" end;");
                SQLHelper.ExecuteSql(sb.ToString());

                //更新日志表
                string         sqlLog = string.Empty;
                SqlParameter[] sqlParm;
                if (dtMac.Rows.Count > 0)
                {
                    sqlLog  = "update dbo.日志表 set 更新日期=@更新日期,更新数量=@更新数量 where 服务器MAC=@服务器MAC and 数据类型='委托'";
                    sqlParm = new SqlParameter[] { new SqlParameter("@更新日期", Convert.ToInt32(firstRow1.日期.ToString("yyyyMMdd"))), new SqlParameter("@更新数量", dtWT.Rows.Count), new SqlParameter("@服务器MAC", serverMac) };
                }
                else
                {
                    sqlLog  = "insert into dbo.日志表(服务器MAC,更新数量,数据类型,更新日期)values(@服务器MAC,@更新数量,@数据类型,@更新日期)";
                    sqlParm = new SqlParameter[] { new SqlParameter("@更新日期", Convert.ToInt32(firstRow1.日期.ToString("yyyyMMdd"))), new SqlParameter("@更新数量", dtWT.Rows.Count), new SqlParameter("@数据类型", "委托"), new SqlParameter("@服务器MAC", serverMac) };
                }

                SQLHelper.ExecuteSql(sqlLog, sqlParm);

                Program.logger.LogInfo(string.Format("委托数据入库结束:{0},当前server-{1}", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), serverMac));
            }
            catch (Exception ex)
            {
                Program.logger.LogInfo(string.Format("委托数据入库异常:{0},当前server-{1}", ex.Message, serverMac));
                return(false);
            }
            return(true);
        }
示例#12
0
        public bool SendYJData(JyDataSet.业绩统计DataTable dtYJ, string serverMac)
        {
            try
            {
                if (dtYJ.Rows.Count == 0)
                {
                    Program.logger.LogInfo(string.Format("接收server-{0}的业绩统计DataTable.Rows=0", serverMac));
                    return(false);
                }
                JyDataSet.业绩统计Row firstRow1 = dtYJ[0];
                //判断当前MAC是否已经更新数据
                string    sqlMac = string.Format("select 更新日期 from dbo.日志表 where 服务器MAC='{0}' and 数据类型='业绩'", serverMac);
                DataTable dtMac  = SQLHelper.ExecuteDt(sqlMac);
                if (dtMac.Rows.Count > 0)
                {
                    if (firstRow1.日期 == Convert.ToInt32(dtMac.Rows[0]["更新日期"]))
                    {
                        string updateType = ConfigMain.GetConfigValue("UpdateType");
                        if ("0".Equals(updateType))
                        {
                            //删除原有server Mac的数据
                            string sqlDel = string.Format("delete from dbo.业绩统计 where 服务器MAC='{0}' and 日期={1}", serverMac, firstRow1.日期);
                            SQLHelper.ExecuteSql(sqlDel);
                        }
                    }
                }
                decimal closePrice;
                Dictionary <int, decimal> dictPrice = new Dictionary <int, decimal>();
                StringBuilder             sb        = new StringBuilder();
                sb.Append("begin ");
                Program.logger.LogInfo(string.Format("业绩数据入库开始:{0},当前server-{1}", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), serverMac));
                foreach (JyDataSet.业绩统计Row 业绩统计Row1 in dtYJ)
                {
                    //string sql = "insert into 业绩统计(交易员,组合号,证券代码,证券名称,毛利,交易费用,净利润,买入数量,买入金额,买入均价,卖出数量,卖出金额,卖出均价)values(@交易员,@组合号,@证券代码,@证券名称,@毛利,@交易费用,@净利润,@买入数量,@买入金额,@买入均价,@卖出数量,@卖出金额,@卖出均价)";
                    //SqlParameter[] sqlParm = new SqlParameter[] { new SqlParameter("@交易员", 业绩统计Row1.交易员),new SqlParameter("@组合号", 业绩统计Row1.组合号), new SqlParameter("@证券代码", 业绩统计Row1.证券代码) ,
                    //new SqlParameter("@证券名称", 业绩统计Row1.证券名称), new SqlParameter("@毛利", 业绩统计Row1.毛利),new SqlParameter("@交易费用", 业绩统计Row1.交易费用),
                    //new SqlParameter("@净利润", 业绩统计Row1.净利润),new SqlParameter("@买入数量", 业绩统计Row1.买入数量),new SqlParameter("@买入金额", 业绩统计Row1.买入金额),new SqlParameter("@买入均价", 业绩统计Row1.买入均价),new SqlParameter("@卖出数量", 业绩统计Row1.卖出数量),
                    //new SqlParameter("@卖出金额", 业绩统计Row1.卖出金额),new SqlParameter("@卖出均价", 业绩统计Row1.卖出均价)};

                    //SQLHelper.ExecuteSql(sql, sqlParm);
                    int iCode = Convert.ToInt32(业绩统计Row1.证券代码.Trim());
                    if (dictPrice.ContainsKey(iCode))
                    {
                        closePrice = dictPrice[iCode];
                    }
                    else
                    {
                        closePrice = CommonUtils.GetClosePrice(业绩统计Row1.证券代码.Trim());
                    }
                    string sql = string.Format("insert into dbo.业绩统计(交易员,组合号,证券代码,证券名称,毛利,交易费用,净利润,买入数量,买入金额,买入均价,卖出数量,卖出金额,卖出均价,日期,交易额度,收盘价,分组,服务器MAC)values('{0}','{1}','{2}','{3}',{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},'{16}','{17}');",
                                               业绩统计Row1.交易员,
                                               业绩统计Row1.组合号,
                                               业绩统计Row1.证券代码,
                                               业绩统计Row1.证券名称,
                                               业绩统计Row1.毛利,
                                               业绩统计Row1.交易费用,
                                               业绩统计Row1.净利润,
                                               业绩统计Row1.买入数量,
                                               业绩统计Row1.买入金额,
                                               业绩统计Row1.买入均价,
                                               业绩统计Row1.卖出数量,
                                               业绩统计Row1.卖出金额,
                                               业绩统计Row1.卖出均价,
                                               业绩统计Row1.日期,
                                               业绩统计Row1.交易额度,
                                               closePrice,
                                               业绩统计Row1.分组,
                                               serverMac
                                               );
                    sb.Append(sql);
                }
                sb.Append(" end;");
                SQLHelper.ExecuteSql(sb.ToString());

                //更新日志表
                string         sqlLog = string.Empty;
                SqlParameter[] sqlParm;
                if (dtMac.Rows.Count > 0)
                {
                    sqlLog  = "update dbo.日志表 set 更新日期=@更新日期,更新数量=@更新数量 where 服务器MAC=@服务器MAC and 数据类型='业绩'";
                    sqlParm = new SqlParameter[] { new SqlParameter("@更新日期", firstRow1.日期), new SqlParameter("@更新数量", dtYJ.Rows.Count), new SqlParameter("@服务器MAC", serverMac) };
                }
                else
                {
                    sqlLog  = "insert into dbo.日志表(服务器MAC,更新数量,数据类型,更新日期)values(@服务器MAC,@更新数量,@数据类型,@更新日期)";
                    sqlParm = new SqlParameter[] { new SqlParameter("@更新日期", firstRow1.日期), new SqlParameter("@更新数量", dtYJ.Rows.Count), new SqlParameter("@数据类型", "业绩"), new SqlParameter("@服务器MAC", serverMac) };
                }

                SQLHelper.ExecuteSql(sqlLog, sqlParm);

                Program.logger.LogInfo(string.Format("业绩数据入库结束:{0},当前server-{1}", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), serverMac));
            }
            catch (Exception ex)
            {
                Program.logger.LogInfo(string.Format("业绩数据入库异常:{0},当前server-{1}", ex.Message, serverMac));
                return(false);
            }
            return(true);
        }
示例#13
0
        protected DataServantPrx GetDataServant()
        {
            try
            {
                lock (this)
                {
                    if (_dataServant != null)
                    {
                        _dataServant.ice_ping();
                        return(_dataServant);
                    }

                    if (_ic == null)
                    {
                        InitializationData icData = new InitializationData();
                        Ice.Properties     icProp = Util.createProperties();
                        icProp.setProperty("Ice.ACM.Client", "0");
                        icProp.setProperty("Ice.MessageSizeMax", "2097152");//2gb in kb
                        icData.properties = icProp;
                        Communicator ic = Util.initialize(icData);

                        if (ic != null)
                        {
                            _ic = ic;
                        }
                    }

                    if (_ic != null)
                    {
                        string         endpoint = string.Format("AASDataServer/DataServant:tcp -h {0} -p {1}", ConfigMain.GetConfigValue(BaseCommon.CONFIGIP), ConfigMain.GetConfigValue(BaseCommon.CONFIGICEPORT));
                        Ice.ObjectPrx  obj      = _ic.stringToProxy(endpoint);
                        DataServantPrx client   = DataServantPrxHelper.checkedCast(obj);
                        if (client == null)
                        {
                            LogHelper.Instance.Info("DataServerClient:无法获得有效数据服务器接口");
                            return(null);
                        }

                        client.ice_ping();
                        _dataServant = client;
                        return(_dataServant);
                    }
                }
            }
            catch (Ice.ConnectionRefusedException)
            {
                //计算机积极拒绝,认为未部署鱼头,不进行记录。
                //Program.logger.LogRunning("DataServerClient:数据服务器连接失败\r\n  {0}", ex.InnerException.Message);
            }
            catch (System.Exception ex)
            {
                _dataServant = null;
                LogHelper.Instance.Info("DataServerClient:数据服务器连接失败" + ex.Message);
            }

            return(null);
        }