/// <summary>
/// 作者：Primo
/// 日期：2014.07.23
/// 描述：更新ContractTypeProductLevel
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateContractTypeProductLevel(ContractTypeProductLevel model)
{
using (var edb = new EmeEntities())
{
using (var tran = new TransactionScope())
{
try
{
//获取更新对象
var modelObj = edb.ContractTypeProductLevel.FirstOrDefault(p => p.Id == model.Id);
modelObj.MajorTotal = model.MajorTotal;
modelObj.ElectiveTotal = model.ElectiveTotal;
modelObj.Absence = model.Absence;
modelObj.Repair = model.Repair;
edb.Entry(modelObj).State = EntityState.Modified;
var result = edb.SaveChanges() > 0;
tran.Complete();
return result;
}
catch (Exception e)
{
tran.Dispose();
// 异常日志消息队列
Common.MSMQ.QueueManager.AddExceptionLog(new ExceptionLogs()
{
ExceptionType = CommonHelper.To<int>(ExceptionType.Function),
Message = string.Format("StudentBLL-UpdateContractTypeProductLevel：{0};{1};{2}", e.Message, e.InnerException.Message, e.HelpLink),
IsTreat = false,
CreateBy = model.UpdateBy,
CreateTime = DateTime.Now
});
return false;
}
}
}
}
/// <summary>
/// 作者：Primo
/// 日期：2014.07.23
/// 描述：添加ContractTypeProductLevel
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool CreateContractTypeProductLevel(ContractTypeProductLevel model)
{
using (var edb = new EmeEntities())
{
using (var tran = new TransactionScope())
{
try
{
//创建添加对象
var modelObj = new ContractTypeProductLevel()
{
BranchId = model.BranchId,
ContractTypeId = model.ContractTypeId,
ProductLevelId = model.ProductLevelId,
MajorTotal = model.MajorTotal,
ElectiveTotal = model.ElectiveTotal,
Absence = model.Absence,
Repair = model.Repair,
IsSystem = false,
Status = ConvertEnum.StatusTypeForActive,
CreateBy = model.CreateBy,
CreateTime = DateTime.Now
};
edb.Entry(modelObj).State = EntityState.Added;
var result = edb.SaveChanges() > 0;
tran.Complete();
return result;
}
catch (Exception e)
{
tran.Dispose();
// 异常日志消息队列
Common.MSMQ.QueueManager.AddExceptionLog(new ExceptionLogs()
{
ExceptionType = CommonHelper.To<int>(ExceptionType.Function),
Message = string.Format("StudentBLL-UpdateContractTypeProductLevel：{0};{1};{2}", e.Message, e.InnerException.Message, e.HelpLink),
IsTreat = false,
CreateBy = model.UpdateBy,
CreateTime = DateTime.Now
});
return false;
}
}
}
}
/// <summary>
/// 作者：Primo
/// 日期：2014.07.23
/// 描述：添加ContractTypeProductLevel
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool CreateContractTypeProductLevel(ContractTypeProductLevel model)
{
using (var edb = new EmeEntities())
{
try
{
//存在，修改
if (edb.ContractTypeProductLevel.Any(a => a.BranchId == model.BranchId && a.ContractTypeId == model.ContractTypeId && a.ProductLevelId == model.ProductLevelId))
{
var modelObjUpdate = edb.ContractTypeProductLevel.SingleOrDefault(a => a.BranchId == model.BranchId && a.ContractTypeId == model.ContractTypeId && a.ProductLevelId == model.ProductLevelId);
if (null != modelObjUpdate)
{
modelObjUpdate.BranchId = model.BranchId;
modelObjUpdate.ContractTypeId = model.ContractTypeId;
modelObjUpdate.ProductLevelId = model.ProductLevelId;
modelObjUpdate.MajorTotal = model.MajorTotal;
modelObjUpdate.ElectiveTotal = model.ElectiveTotal;
modelObjUpdate.Absence = model.Absence;
modelObjUpdate.Repair = model.Repair;
modelObjUpdate.IsSystem = false;
modelObjUpdate.Status = ConvertEnum.StatusTypeForActive;
modelObjUpdate.CreateBy = model.CreateBy;
modelObjUpdate.CreateTime = DateTime.Now;
edb.Entry(modelObjUpdate).State = EntityState.Modified;
}
}
else//不存在，录入
{
//创建添加对象
var modelObj = new ContractTypeProductLevel()
{
BranchId = model.BranchId,
ContractTypeId = model.ContractTypeId,
ProductLevelId = model.ProductLevelId,
MajorTotal = model.MajorTotal,
ElectiveTotal = model.ElectiveTotal,
Absence = model.Absence,
Repair = model.Repair,
IsSystem = false,
Status = ConvertEnum.StatusTypeForActive,
CreateBy = model.CreateBy,
CreateTime = DateTime.Now
};
edb.Entry(modelObj).State = EntityState.Added;
}
var result = edb.SaveChanges() > 0;
return result;
}
catch (Exception e)
{
// 异常日志消息队列
Common.MSMQ.QueueManager.AddExceptionLog(new ExceptionLogs()
{
ExceptionType = CommonHelper.To<int>(ExceptionType.Function),
Message = string.Format("StudentBLL-UpdateContractTypeProductLevel：{0};{1};{2}", e.Message, e.InnerException.Message, e.HelpLink),
IsTreat = false,
CreateBy = model.UpdateBy,
CreateTime = DateTime.Now
});
return false;
}
}
}
