コード例 #1
0
        /// <summary>
        /// 同步用户信息
        /// </summary>
        public void SyncReaderInfo()
        {
            //isSync = true;
            DateTime sdt    = DateTime.Now;
            M_Config config = CommonClass.SystemConfig.GetConfig();

            readerCount = 0;
            updateCount = 0;
            addCount    = 0;
            try
            {
                if (config.FtpSetting.UseFtp)
                {
                    if (SyncMessage != null)
                    {
                        SyncMessage("开始下载FTP文件......");
                    }
                    // 根据uri创建FtpWebRequest对象
                    FtpWebRequest reqFTP = (FtpWebRequest)WebRequest.Create(new Uri(config.FtpSetting.FtpFileUrl));
                    // 指定数据传输类型
                    reqFTP.UseBinary = true;
                    // ftp用户名和密码
                    reqFTP.Credentials = new NetworkCredential(config.FtpSetting.UID, config.FtpSetting.PW);
                    string newFileName = config.FtpSetting.SavePath;
                    if (File.Exists(newFileName))
                    {
                        File.Delete(newFileName);
                    }
                    //连接
                    FtpWebResponse response   = (FtpWebResponse)reqFTP.GetResponse();
                    Stream         ftpStream  = response.GetResponseStream();
                    long           cl         = response.ContentLength;
                    int            bufferSize = 2048;
                    int            readCount;
                    byte[]         buffer = new byte[bufferSize];
                    readCount = ftpStream.Read(buffer, 0, bufferSize);
                    FileStream outputStream = new FileStream(newFileName, FileMode.Create);
                    while (readCount > 0)
                    {
                        outputStream.Write(buffer, 0, readCount);
                        readCount = ftpStream.Read(buffer, 0, bufferSize);
                    }
                    ftpStream.Close();
                    outputStream.Close();
                    response.Close();
                    if (!File.Exists(newFileName))
                    {
                        if (SyncMessage != null)
                        {
                            SyncMessage("FTP文件下载失败!");
                        }
                        return;
                    }
                    if (SyncMessage != null)
                    {
                        SyncMessage("文件下载完成!");
                        SyncMessage("开始获取用户信息......");
                    }
                }
                DataTable newDT = null;
                switch (config.SourceType)
                {
                case E_SyncSourceType.Excel:
                {
                    ReaderInfoSource.ExcelSource source = new ReaderInfoSource.ExcelSource();
                    DataTable testReturn = source.GetReaderInfo(config);
                    source.DataProgress += source_ChangeProgress;
                    readerCount          = testReturn.Rows.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + readerCount.ToString() + "条");
                        SyncMessage("开始转换用户信息......");
                    }
                    newDT = source.GetReaderList(config, testReturn);
                }
                break;

                case E_SyncSourceType.Sybase:
                {
                    ReaderInfoSource.SybaseSource source = new ReaderInfoSource.SybaseSource();
                    DataTable testReturn = source.GetReaderInfo(config);
                    source.DataProgress += source_ChangeProgress;
                    readerCount          = testReturn.Rows.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + readerCount.ToString() + "条");
                        SyncMessage("开始转换用户信息......");
                    }
                    newDT = source.GetReaderList(config, testReturn);
                }
                break;

                case E_SyncSourceType.Orcale:
                {
                    ReaderInfoSource.OrcaleSource source = new ReaderInfoSource.OrcaleSource();
                    DataTable testReturn = source.GetReaderInfo(config);
                    source.DataProgress += source_ChangeProgress;
                    readerCount          = testReturn.Rows.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + readerCount.ToString() + "条");
                        SyncMessage("开始转换用户信息......");
                    }
                    newDT = source.GetReaderList(config, testReturn);
                }
                break;

                case E_SyncSourceType.SQL:
                {
                    ReaderInfoSource.SQLSource source = new ReaderInfoSource.SQLSource();
                    DataTable testReturn = source.GetReaderInfo(config);
                    source.DataProgress += source_ChangeProgress;
                    readerCount          = testReturn.Rows.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + readerCount.ToString() + "条");
                        SyncMessage("开始转换用户信息......");
                    }
                    newDT = source.GetReaderList(config, testReturn);
                }
                break;

                case E_SyncSourceType.TXT:
                {
                    ReaderInfoSource.TxtSource source = new ReaderInfoSource.TxtSource();
                    List <string> testReturn          = source.GetReaderInfo(config);
                    source.DataProgress += source_ChangeProgress;
                    readerCount          = testReturn.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + readerCount.ToString() + "条");
                        SyncMessage("开始转换用户信息......");
                    }
                    newDT = source.GetReaderList(config, testReturn);
                }
                break;

                case E_SyncSourceType.Xml:
                {
                    ReaderInfoSource.XmlSource source = new ReaderInfoSource.XmlSource();
                    XmlNodeList testReturn            = source.GetReaderInfo(config);
                    source.DataProgress += source_ChangeProgress;
                    readerCount          = testReturn.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + readerCount.ToString() + "条");
                        SyncMessage("开始转换用户信息......");
                    }
                    newDT = source.GetReaderList(config, testReturn);
                }
                break;

                case E_SyncSourceType.XZX:
                {
                    try
                    {
                        ReaderInfoSource.XZXSource source = new ReaderInfoSource.XZXSource();
                        int testReturn = source.GetReaderInfo(config);
                        source.DataProgress += source_ChangeProgress;
                        readerCount          = testReturn;
                        if (SyncMessage != null)
                        {
                            SyncMessage("获取到用户信息" + readerCount + "条");
                            SyncMessage("开始转换用户信息......");
                        }

                        newDT = source.GetReaderList(config);
                    }
                    catch (Exception ex)
                    {
                        SeatManage.SeatManageComm.WriteLog.Write(string.Format("异常:" + ex));
                        throw;
                    }
                }
                break;
                }
                if (newDT == null || newDT.Rows.Count < 1)
                {
                    if (SyncMessage != null)
                    {
                        SyncMessage("转换用户信息失败!");
                    }
                }
                else
                {
                    readerCount = newDT.Rows.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("转换有效用户信息" + readerCount + "条");
                        SyncMessage("开始同步数据库......");
                    }
                }
                AddReaderInfo addReader = new AddReaderInfo();
                addReader.DataProgress += addReader_DataProgress;
                addReader.AddNewData(newDT, config.SeatDbSetting.ToConnectionString());
                if (SyncMessage != null)
                {
                    SyncMessage("一卡通信息同步完成!");
                }
                if (config.AccessAccount)
                {
                    if (SyncMessage != null)
                    {
                        SyncMessage("开始激活预约账号......");
                    }
                    AddUserInfo addUser = new AddUserInfo();
                    addUser.DataProgress += addUser_DataProgress;
                    DataSet ds = addUser.GetUserDataTable();
                    readerCount = ds.Tables[0].Rows.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("已激活账号" + readerCount + "条");
                        SyncMessage("开始获取新增用户激活信息......");
                    }
                    addUser.GetList(newDT, ds.Tables[0], config.SyncPw);
                    List <UserInfo> list = addUser.GetAddList();
                    addCount = list.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取新增用户" + addCount + "条");
                        SyncMessage("开始添加新增用户激活信息......");
                    }
                    addUser.AddUser(list);
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取新增用户激活完成!");
                        SyncMessage("开始获取更新用户信息......");
                    }
                    list     = addUser.GetUpdateList(config.ClearAccount, config.SyncPw);
                    addCount = list.Count;
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取更新用户" + addCount + "条");
                        SyncMessage("开始更新用户信息......");
                    }
                    addUser.UpdateUser(list);
                    if (SyncMessage != null)
                    {
                        SyncMessage("更新用户信息完成!");
                    }
                }
                if (SyncMessage != null)
                {
                    SyncMessage("同步完成!本次耗时" + (DateTime.Now - sdt).TotalSeconds + "秒");
                }
                if (config.IsSpanTime)
                {
                    syncTime = DateTime.Now.AddMinutes(int.Parse(config.SyncSpanTime));
                }
                else
                {
                    if (syncTime < DateTime.Now)
                    {
                        syncTime = syncTime.AddDays(1);
                        if (SyncTime != null)
                        {
                            SyncTime(syncTime.ToString("yyy-MM-dd HH:mm:ss"));
                        }
                    }
                }
                if (SyncMessage != null)
                {
                    SyncMessage("下次同步时间:" + syncTime.ToString("yyyy-MM-dd HH:mm:ss"));
                }
            }
            catch (Exception ex)
            {
                if (SyncMessage != null)
                {
                    SyncMessage(ex.Message);
                }
            }
            finally
            {
                //isSync = false;
            }
        }
コード例 #2
0
        /// <summary>
        /// 获取数据测试
        /// </summary>
        public void GetDateTest()
        {
            M_Config config = CommonClass.SystemConfig.GetConfig();

            if (SyncMessage != null)
            {
                SyncMessage("获取到用户信息测试......");
            }
            try
            {
                switch (config.SourceType)
                {
                case E_SyncSourceType.Excel:
                {
                    ReaderInfoSource.ExcelSource source = new ReaderInfoSource.ExcelSource();
                    DataTable testReturn = source.GetReaderInfo(config);
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + testReturn.Rows.Count.ToString() + "条");
                    }
                }
                break;

                case E_SyncSourceType.Sybase:
                {
                    ReaderInfoSource.SybaseSource source = new ReaderInfoSource.SybaseSource();
                    DataTable testReturn = source.GetReaderInfo(config);
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + testReturn.Rows.Count.ToString() + "条");
                    }
                }
                break;

                case E_SyncSourceType.Orcale:
                {
                    ReaderInfoSource.OrcaleSource source = new ReaderInfoSource.OrcaleSource();
                    DataTable testReturn = source.GetReaderInfo(config);
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + testReturn.Rows.Count.ToString() + "条");
                    }
                }
                break;

                case E_SyncSourceType.SQL:
                {
                    ReaderInfoSource.SQLSource source = new ReaderInfoSource.SQLSource();
                    DataTable testReturn = source.GetReaderInfo(config);
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + testReturn.Rows.Count.ToString() + "条");
                    }
                }
                break;

                case E_SyncSourceType.TXT:
                {
                    ReaderInfoSource.TxtSource source = new ReaderInfoSource.TxtSource();
                    List <string> testReturn          = source.GetReaderInfo(config);
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + testReturn.Count.ToString() + "条");
                    }
                }
                break;

                case E_SyncSourceType.Xml:
                {
                    ReaderInfoSource.XmlSource source = new ReaderInfoSource.XmlSource();
                    XmlNodeList testReturn            = source.GetReaderInfo(config);
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + testReturn.Count.ToString() + "条");
                    }
                }
                break;

                case E_SyncSourceType.XZX:
                {
                    ReaderInfoSource.XZXSource source = new ReaderInfoSource.XZXSource();
                    int testReturn = source.GetReaderInfo(config);
                    if (SyncMessage != null)
                    {
                        SyncMessage("获取到用户信息" + testReturn + "条");
                    }
                }
                break;
                }
            }
            catch (Exception ex)
            {
                if (SyncMessage != null)
                {
                    SyncMessage(ex.Message);
                }
            }
        }