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