public void SaveEditData(IEnumerable <Spl_WarehouseWarrantDetailsOUTModel> personList, string warehouseWarrantId)
{
try
{
using (DBContainer db = new DBContainer())
{
int count = db.Database.ExecuteSqlCommand("delete Spl_WarehouseWarrantDetailsOUT where WarehouseWarrantId=@WarehouseWarrantId", new SqlParameter("@WarehouseWarrantId", warehouseWarrantId));
foreach (var model in personList)
{
Spl_WarehouseWarrantDetailsOUT entity = new Spl_WarehouseWarrantDetailsOUT();
entity.Id = model.Id;
entity.WareDetailsId = model.WareDetailsId;
entity.WarehouseId = model.WarehouseId;
entity.WarehouseWarrantId = model.WarehouseWarrantId;
entity.Quantity = model.Quantity;
entity.Price = model.Price;
entity.TotalPrice = model.TotalPrice;
entity.Defined = model.Defined;
entity.CreateTime = model.CreateTime;
entity.Id = ResultHelper.NewId;
db.Spl_WarehouseWarrantDetailsOUT.Add(entity);
}
db.SaveChanges();
}
}
catch
{
throw;
}
}
/// <summary>
/// 保存数据
/// </summary>
public virtual void SaveImportData(IEnumerable <Spl_WarehouseWarrantDetailsOUTModel> list)
{
try
{
using (DBContainer db = new DBContainer())
{
foreach (var model in list)
{
Spl_WarehouseWarrantDetailsOUT entity = new Spl_WarehouseWarrantDetailsOUT();
entity.Id = ResultHelper.NewId;
entity.WareDetailsId = model.WareDetailsId;
entity.WarehouseId = model.WarehouseId;
entity.WarehouseWarrantId = model.WarehouseWarrantId;
entity.Quantity = model.Quantity;
entity.Price = model.Price;
entity.TotalPrice = model.TotalPrice;
entity.Defined = model.Defined;
entity.CreateTime = ResultHelper.NowTime;
db.Spl_WarehouseWarrantDetailsOUT.Add(entity);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 保存数据
/// </summary>
public void SaveData(IEnumerable <Spl_WarehouseWarrantDetailsOUTModel> personList)
{
try
{
using (DBContainer db = new DBContainer())
{
foreach (var model in personList)
{
Spl_WarehouseWarrantDetailsOUT entity = new Spl_WarehouseWarrantDetailsOUT();
entity.Id = model.Id;
entity.WareDetailsId = model.WareDetailsId;
entity.WarehouseId = model.WarehouseId;
entity.WarehouseWarrantId = model.WarehouseWarrantId;
entity.Quantity = model.Quantity;
entity.Price = model.Price;
entity.TotalPrice = model.TotalPrice;
entity.Defined = model.Defined;
entity.CreateTime = model.CreateTime;
//新增
if (string.IsNullOrEmpty(model.Id))
{
entity.Id = ResultHelper.NewId;
db.Spl_WarehouseWarrantDetailsOUT.Add(entity);
}
else
{
//修改
db.Set <Spl_WarehouseWarrantDetailsOUT>().Attach(entity);
db.Entry <Spl_WarehouseWarrantDetailsOUT>(entity).State = EntityState.Modified;
}
}
db.SaveChanges();
}
}
catch
{
throw;
}
}
public virtual bool Create(ref ValidationErrors errors, Spl_WarehouseWarrantDetailsOUTModel model)
{
try
{
Spl_WarehouseWarrantDetailsOUT entity = m_Rep.GetById(model.Id);
if (entity != null)
{
errors.Add(Resource.PrimaryRepeat);
return(false);
}
entity = new Spl_WarehouseWarrantDetailsOUT();
entity.Id = model.Id;
entity.WareDetailsId = model.WareDetailsId;
entity.WarehouseId = model.WarehouseId;
entity.WarehouseWarrantId = model.WarehouseWarrantId;
entity.Quantity = model.Quantity;
entity.Price = model.Price;
entity.TotalPrice = model.TotalPrice;
entity.Defined = model.Defined;
entity.CreateTime = model.CreateTime;
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 Spl_WarehouseWarrantDetailsOUTModel GetById(object id)
{
if (IsExists(id))
{
Spl_WarehouseWarrantDetailsOUT entity = m_Rep.GetById(id);
Spl_WarehouseWarrantDetailsOUTModel model = new Spl_WarehouseWarrantDetailsOUTModel();
model.Id = entity.Id;
model.WareDetailsId = entity.WareDetailsId;
model.WarehouseId = entity.WarehouseId;
model.WarehouseWarrantId = entity.WarehouseWarrantId;
model.Quantity = entity.Quantity;
model.Price = entity.Price;
model.TotalPrice = entity.TotalPrice;
model.Defined = entity.Defined;
model.CreateTime = entity.CreateTime;
return(model);
}
else
{
return(null);
}
}
