private static void timeLoop_TimeTo(object sender, EventArgs e)
{
try
{
if (IsTimeToWork() && IsWork == false)
{
IsWork = true; //开始工作
try
{
M_Config config = CommonClass.SystemConfig.GetConfig();
bool testReturn = false;
ReaderInfoSource.XZXSource source = new ReaderInfoSource.XZXSource();
testReturn = source.LinkDataSourceTest(config);
string msg = testReturn ? "第三方链接成功" : "第三方链接失败";
Display(msg);
Display("开始获取记录条数");
int recordCount = source.GetReaderInfo(config);
Display("共获取到记录数" + recordCount + "条");
Display("开始下载读者信息文件");
string newFilePath = AppDomain.CurrentDomain.BaseDirectory + "File\\";
string oldFilePath = AppDomain.CurrentDomain.BaseDirectory + "RecvTemp\\";
string[] files = Directory.GetFiles(oldFilePath);
if (files.Length < 1)
{
throw new Exception("找不到读者信息文件！");
}
else
{
string oldFile = files[files.Length - 1];
File.Copy(oldFile, newFilePath + "data", true);
Display("读者信息文件下载成功");
}
}
catch (Exception ex)
{
Display(ex.ToString());
SeatManage.SeatManageComm.WriteLog.Write(ex.ToString());
}
IsWork = false;
}
}
catch (Exception ex)
{
WriteLog.Write("异常信息:" + ex);
Display("异常信息:" + ex);
}
}
/// <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;
}
}
/// <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);
}
}
}