/// <summary> /// 保存数据 /// </summary> public virtual void SaveImportData(IEnumerable <SysImportExcelLogModel> list) { try { using (DBContainer db = new DBContainer()) { foreach (var model in list) { SysImportExcelLog entity = new SysImportExcelLog(); entity.Id = 0; entity.ImportTime = model.ImportTime; entity.ImportTable = model.ImportTable; entity.ImportFileName = model.ImportFileName; entity.ImportFilePathUrl = model.ImportFilePathUrl; entity.ImportStatus = model.ImportStatus; entity.CreateBy = model.CreateBy; db.SysImportExcelLog.Add(entity); } db.SaveChanges(); } } catch (Exception ex) { throw; } }
/// <summary> /// 写入Excel导入的日志 /// </summary> /// <param name="table">导入的表名</param> /// <param name="fileName">Excel文件名</param> /// <param name="fileUrl">Excel文件Url</param> /// <param name="status">导入状态</param> /// <param name="oper">操作员</param> public static void WriteImportExcelLog(string oper, string table, string fileName, string fileUrl, string status) { SysImportExcelLog entity = new SysImportExcelLog(); entity.Id = 0; entity.ImportTime = DateTime.Now; entity.ImportTable = table; entity.ImportFileName = fileName; entity.ImportFilePathUrl = fileUrl; entity.ImportStatus = status; entity.CreateBy = oper; using (SysImportExcelLogRepository logRepository = new SysImportExcelLogRepository(new DBContainer())) { logRepository.Create(entity); } }
public virtual SysImportExcelLogModel GetById(object id) { if (IsExists(id)) { SysImportExcelLog entity = m_Rep.GetById(id); SysImportExcelLogModel model = new SysImportExcelLogModel(); model.Id = entity.Id; model.ImportTime = entity.ImportTime; model.ImportTable = entity.ImportTable; model.ImportFileName = entity.ImportFileName; model.ImportFilePathUrl = entity.ImportFilePathUrl; model.ImportStatus = entity.ImportStatus; model.CreateBy = entity.CreateBy; return(model); } else { return(null); } }
public virtual bool Create(ref ValidationErrors errors, SysImportExcelLogModel model) { try { SysImportExcelLog entity = m_Rep.GetById(model.Id); if (entity != null) { errors.Add(Resource.PrimaryRepeat); return(false); } entity = new SysImportExcelLog(); entity.Id = model.Id; entity.ImportTime = model.ImportTime; entity.ImportTable = model.ImportTable; entity.ImportFileName = model.ImportFileName; entity.ImportFilePathUrl = model.ImportFilePathUrl; entity.ImportStatus = model.ImportStatus; entity.CreateBy = model.CreateBy; if (m_Rep.Create(entity)) { return(true); } else { errors.Add(Resource.InsertFail); return(false); } } catch (Exception ex) { errors.Add(ex.Message); ExceptionHander.WriteException(ex); return(false); } }
public virtual bool Edit(ref ValidationErrors errors, SysImportExcelLogModel model) { try { SysImportExcelLog entity = m_Rep.GetById(model.Id); if (entity == null) { errors.Add(Resource.Disable); return(false); } entity.Id = model.Id; entity.ImportTime = model.ImportTime; entity.ImportTable = model.ImportTable; entity.ImportFileName = model.ImportFileName; entity.ImportFilePathUrl = model.ImportFilePathUrl; entity.ImportStatus = model.ImportStatus; entity.CreateBy = model.CreateBy; if (m_Rep.Edit(entity)) { return(true); } else { errors.Add(Resource.NoDataChange); return(false); } } catch (Exception ex) { errors.Add(ex.Message); ExceptionHander.WriteException(ex); return(false); } }