public static bool Upload()
{
try
{
StringBuilder sb = new StringBuilder();
AMS.ServiceProxy.FileOperate fileOperate = new AMS.ServiceProxy.FileOperate();
SeatManage.DAL.T_SM_Reader t_sm_Reader = new SeatManage.DAL.T_SM_Reader();
DataSet ds = t_sm_Reader.GetList(null, null);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
sb.Append(ds.Tables[0].Rows[i]["cardId"].ToString());
sb.Append(ds.Tables[0].Rows[i]["cardNo"].ToString());
sb.Append(ds.Tables[0].Rows[i]["ReaderName"].ToString());
sb.Append(ds.Tables[0].Rows[i]["ReaderTypeName"].ToString());
sb.Append(ds.Tables[0].Rows[i]["Sex"].ToString());
sb.Append(ds.Tables[0].Rows[i]["ReaderDeptName"].ToString());
sb.Append(ds.Tables[0].Rows[i]["Flag"].ToString());
sb.AppendLine("");
}
SaveLog("RI", sb.ToString());
string fileDircetoryPath = AppDomain.CurrentDomain.BaseDirectory + "RITmp\\";
SeatManage.SeatManageComm.ZipUtil.ZipFile(fileDircetoryPath + "RI", fileDircetoryPath + "ZRI");
//上传文件
fileOperate.UpdateFile(fileDircetoryPath + "ZRI", ServiceSet.SchoolNums + "_ZRI", SeatManageSubsystem.ReaderInfo);
//删除缓存文件
Directory.Delete(fileDircetoryPath, true);
return(true);
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(string.Format("获取信息失败：{0}", ex.Message));
return(false);
}
}
/// <summary>
/// 上传设备截图
/// </summary>
/// <returns></returns>
public static bool UpdateCaputre()
{
try
{
List <SeatManage.ClassModel.TerminalInfoV2> terminalList = SeatManage.Bll.TerminalOperatorService.GetAllTeminalInfo();
SeatManage.Bll.FileOperate seatfileTransport = new SeatManage.Bll.FileOperate();
AMS.ServiceProxy.FileOperate advertTransport = new AMS.ServiceProxy.FileOperate();
foreach (SeatManage.ClassModel.TerminalInfoV2 terminal in terminalList)
{
if (!string.IsNullOrEmpty(terminal.ScreenshotPath))
{
AMS.Model.AMS_Device model = AMS.ServiceProxy.IDevice.GetDevicebyNo(terminal.ClientNo);
if (model == null)
{
return(true);//如果媒体服务器上获取不到信息，直接返回true，以便结束命令。
}
string fileFullName = string.Format("{0}{1}", ServiceSet.TempFilePath, terminal.ScreenshotPath);
if (seatfileTransport.FileDownLoad(fileFullName, terminal.ScreenshotPath, SeatManage.EnumType.SeatManageSubsystem.Caputre))
{
if (advertTransport.UpdateFile(fileFullName, terminal.ScreenshotPath, SeatManage.EnumType.SeatManageSubsystem.Caputre) == "")
{
File.Delete(fileFullName);
//上传完成，更新一下截图路径。
model.CaputrePath = terminal.ScreenshotPath;
AMS.ServiceProxy.IDevice.UpdateDeviceModel(model);
}
}
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 开始计算
/// </summary>
public bool Upload()
{
try
{
DateTime sdt;
string lastdate = GetLastDate();
if (!string.IsNullOrEmpty(lastdate))
{
sdt = DateTime.Parse(lastdate);
}
else
{
sdt = seatService.GetFristLogDate();
}
if (sdt <= DateTime.Parse("2000-1-1"))
{
return(true);
}
AMS.ServiceProxy.FileOperate fileOperate = new AMS.ServiceProxy.FileOperate();
sdt = sdt.AddDays(1);
while (true)
{
//获取进出记录
List <EnterOutLogInfo> enterOutLogList = seatService.GetEnterOutBakLogsByDate(sdt);
List <BespeakLogInfo> bespeakLogList = seatService.GetBespeakLogs(null, null, sdt, 0, null);
List <ViolationRecordsLogInfo> violationLogList = seatService.GetViolationRecordsLogs(null, null, sdt.ToShortDateString(), sdt.Date.AddDays(1).AddSeconds(-1).ToString(), LogStatus.None, LogStatus.None);
List <BlackListInfo> blacklistList = seatService.GetBlacklistInfos(null, LogStatus.None, sdt.ToShortDateString(), sdt.Date.AddDays(1).AddSeconds(-1).ToString());
if (enterOutLogList.Count <= 0 && bespeakLogList.Count <= 0 && violationLogList.Count <= 0 && sdt >= DateTime.Now.Date.AddDays(-1))
{
break;
}
StringBuilder eolsb = new StringBuilder();
StringBuilder blisb = new StringBuilder();
StringBuilder vrisb = new StringBuilder();
StringBuilder bllsb = new StringBuilder();
foreach (EnterOutLogInfo eol in enterOutLogList)
{
//记录内容
eolsb.Append(eol.EnterOutLogID + ",");
eolsb.Append(eol.EnterOutLogNo + ",");
eolsb.Append(eol.EnterOutState + ",");
eolsb.Append(eol.EnterOutTime + ",");
//座位信息
eolsb.Append(eol.TerminalNum + ",");
eolsb.Append(eol.SeatNo + ",");
eolsb.Append(eol.ReadingRoomNo + ",");
eolsb.Append(eol.ReadingRoomName + ",");
//备注
eolsb.Append(eol.Flag + ",");
eolsb.Append(eol.Remark + ",");
//读者信息
eolsb.Append(eol.CardNo + ",");
eolsb.Append(eol.ReaderName + ",");
eolsb.Append(eol.Sex + ",");
vrisb.Append(eol.DeptName + ",");
vrisb.Append(eol.TypeName + ";");
eolsb.AppendLine();
}
foreach (BespeakLogInfo bli in bespeakLogList)
{
blisb.Append(bli.BsepeaklogID + ",");
blisb.Append(bli.BsepeakTime + ",");
blisb.Append(bli.BsepeakState + ",");
blisb.Append(bli.SubmitTime + ",");
blisb.Append(bli.CancelPerson + ",");
blisb.Append(bli.CancelTime + ",");
blisb.Append(bli.SeatNo + ",");
blisb.Append(bli.ReadingRoomNo + ",");
blisb.Append(bli.ReadingRoomName + ",");
blisb.Append(bli.Remark + ",");
blisb.Append(bli.CardNo + ",");
blisb.Append(bli.ReaderName + ",");
blisb.Append(bli.Sex + ",");
vrisb.Append(bli.DeptName + ",");
vrisb.Append(bli.TypeName + ";");
blisb.AppendLine();
}
foreach (ViolationRecordsLogInfo vri in violationLogList)
{
vrisb.Append(vri.ID + ",");
vrisb.Append(vri.BlacklistID + ",");
vrisb.Append(vri.WarningState + ",");
vrisb.Append(vri.EnterFlag + ",");
vrisb.Append(vri.EnterOutTime + ",");
vrisb.Append(vri.Flag + ",");
vrisb.Append(vri.SeatID + ",");
vrisb.Append(vri.ReadingRoomID + ",");
vrisb.Append(vri.ReadingRoomName + ",");
vrisb.Append(vri.Remark + ",");
vrisb.Append(vri.CardNo + ",");
vrisb.Append(vri.ReaderName + ",");
vrisb.Append(vri.Sex + ",");
vrisb.Append(vri.DeptName + ",");
vrisb.Append(vri.TypeName + ";");
vrisb.AppendLine();
}
foreach (BlackListInfo bli in blacklistList)
{
bllsb.Append(bli.ID + ",");
bllsb.Append(bli.AddTime + ",");
bllsb.Append(bli.BlacklistState + ",");
bllsb.Append(bli.OutBlacklistMode + ",");
bllsb.Append(bli.OutTime + ",");
bllsb.Append(bli.ReadingRoomID + ",");
bllsb.Append(bli.ReadingRoomName + ",");
bllsb.Append(bli.ReMark + ",");
bllsb.Append(bli.CardNo + ",");
bllsb.Append(bli.ReaderName + ",");
bllsb.Append(bli.Sex + ",");
bllsb.Append(bli.DeptName + ",");
bllsb.Append(bli.TypeName + ";");
bllsb.AppendLine();
}
try
{
string filedateName = sdt.Year + "-" + sdt.Month + "-" + sdt.Day;
SaveLog("EOL_" + filedateName, eolsb.ToString());
SaveLog("BSL_" + filedateName, blisb.ToString());
SaveLog("VRL_" + filedateName, vrisb.ToString());
SaveLog("BLL_" + filedateName, bllsb.ToString());
//压缩文件
string fileDircetoryPath = AppDomain.CurrentDomain.BaseDirectory + "StatisticsTmp\\";
SeatManage.SeatManageComm.ZipUtil.ZipFile(fileDircetoryPath + "EOL_" + filedateName, fileDircetoryPath + "ZEOL_" + filedateName);
SeatManage.SeatManageComm.ZipUtil.ZipFile(fileDircetoryPath + "BSL_" + filedateName, fileDircetoryPath + "ZBSL_" + filedateName);
SeatManage.SeatManageComm.ZipUtil.ZipFile(fileDircetoryPath + "VRL_" + filedateName, fileDircetoryPath + "ZVRL_" + filedateName);
SeatManage.SeatManageComm.ZipUtil.ZipFile(fileDircetoryPath + "BLL_" + filedateName, fileDircetoryPath + "ZBLL_" + filedateName);
//上传文件
fileOperate.UpdateFile(fileDircetoryPath + "ZEOL_" + filedateName, ServiceSet.SchoolNums + "_ZEOL_" + filedateName, SeatManageSubsystem.EnterOutLog);
fileOperate.UpdateFile(fileDircetoryPath + "ZBSL_" + filedateName, ServiceSet.SchoolNums + "_ZBSL_" + filedateName, SeatManageSubsystem.BespeakLog);
fileOperate.UpdateFile(fileDircetoryPath + "ZVRL_" + filedateName, ServiceSet.SchoolNums + "_ZVRL_" + filedateName, SeatManageSubsystem.ViolateDiscipline);
fileOperate.UpdateFile(fileDircetoryPath + "ZBLL_" + filedateName, ServiceSet.SchoolNums + "_ZBLL_" + filedateName, SeatManageSubsystem.Blistlist);
//删除缓存文件
Directory.Delete(fileDircetoryPath, true);
SetLastDate(sdt.ToShortDateString());
sdt = sdt.AddDays(1);
if (sdt >= DateTime.Now.Date)
{
break;
}
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(string.Format("统计{0}记录失败：{1}", sdt.ToShortDateString(), ex.Message));
return(false);
}
}
return(true);
}
catch (Exception ex)
{
SeatManage.SeatManageComm.WriteLog.Write(string.Format("统计记录失败：{0}", ex.Message));
return(false);
}
}
