public void DeleteModelInPrintLogCollection(PrintLogViewModel printLog)
{
string sql = "delete from T_PrintLog where GUID ='" + printLog.Guid + "'";
sqlo.getSomeDate(sql);
PrintLogCollection.Remove(printLog);
}
private void GetPrintLogCollection()
{
string sql = "select * from T_PrintLog";
sqlo.getSomeDate(sql);
foreach (DataRow dr in sqlo.dt.Rows)
{
PrintLogViewModel printModel = new PrintLogViewModel(dr["GUID"].ToString())
{
ExecuteTime = (DateTime)dr["ExecuteTime"],
UserName = dr["UserName"].ToString(),
IPAddress = dr["IPAddress"].ToString(),
ComputerName = dr["ComputerName"].ToString(),
MACAddress = dr["MACAddress"].ToString(),
ProgramName = dr["ProgramName"].ToString(),
PrintType = dr["PrintType"].ToString(),
FileName = dr["FileName"].ToString()
};
PrintLogCollection.Add(printModel);
}
}
private void GetData()
{
DataTable dt = new ExcelOper(FilePath).GetContentFromExcel();
int startRow = DataTableHelper.RowIndex(dt, "执行时间", 0);
//生成模型
for (int i = startRow + 1; i < dt.Rows.Count; i++)
{
PrintLogViewModel printLog = new PrintLogViewModel();
printLog.ExecuteTime = DateTimeBuilder.dtDateTime(dt.Rows[i][0].ToString());
printLog.UserName = dt.Rows[i][1].ToString();
printLog.IPAddress = dt.Rows[i][2].ToString();
printLog.ComputerName = dt.Rows[i][3].ToString();
printLog.MACAddress = dt.Rows[i][4].ToString();
printLog.ProgramName = dt.Rows[i][5].ToString();
printLog.PrintType = dt.Rows[i][6].ToString();
printLog.FileName = dt.Rows[i][7].ToString();
if (ShareDataEntity.GetSingleton().PrintLogCollection.Where(p => p.ExecuteTime == printLog.ExecuteTime && p.UserName == printLog.UserName && p.IPAddress == printLog.IPAddress && p.FileName == printLog.FileName).ToList().Count == 0)
{
PrintLogList.Add(printLog);
}
}
}
