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); } } }