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