/// <summary>
/// 作者：Primo
/// 日期：2014.06.24
/// 描述：新增产品课节
/// </summary>
/// <param name="pLevelCourseTypeCourse"></param>
/// <param name="course"></param>
/// <returns></returns>
public static bool CreateProductLevelCourseTypeCourse(ProductLevelCourseTypeCourse pLevelCourseTypeCourse, Course course, int loginUserId)
{
using (var edb = new EmeEntities())
{
using (var tran = new TransactionScope())
{
try
{
var result = false;
var modelCourse = edb.Course.FirstOrDefault(p => p.CName == course.CName && p.Status == ConvertEnum.StatusTypeForActive);
var courseId = 0;
edb.Entry(course).State = EntityState.Added;
result = edb.SaveChanges() > 0;
courseId = course.Id;
pLevelCourseTypeCourse.CourseId = courseId;
edb.Entry(pLevelCourseTypeCourse).State = EntityState.Added;
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("ProductBLL-CreateProductLevelCourseTypeCourse：{0};{1};{2}", e.Message, e.InnerException.Message, e.HelpLink),
IsTreat = false,
CreateBy = loginUserId,
CreateTime = DateTime.Now
});
return false;
}
}
}
}
/// <summary>
/// 作者：Raymond
/// 日期：2014-3-27
/// 描述：新增产品课节
/// </summary>
/// <param name="pLevelCourseTypeCourse"></param>
/// <returns></returns>
public static ProductLevelCourseTypeCourse CreateProductLevelCourseTypeCourse(ProductLevelCourseTypeCourse pLevelCourseTypeCourse, int loginUserId)
{
using (var edb = new EmeEntities())
{
try
{
edb.Entry(pLevelCourseTypeCourse).State = EntityState.Added;
edb.SaveChanges();
return pLevelCourseTypeCourse;
}
catch (Exception e)
{
// 异常日志消息队列
Common.MSMQ.QueueManager.AddExceptionLog(new ExceptionLogs()
{
ExceptionType = CommonHelper.To<int>(ExceptionType.Function),
Message = string.Format("ProductBLL-CreateProductLevelCourseTypeCourse：{0};{1};{2}", e.Message, e.InnerException.Message, e.HelpLink),
IsTreat = false,
CreateBy = loginUserId,
CreateTime = DateTime.Now
});
return null;
}
}
}
/// <summary>
/// 作者：Raymond
/// 日期：2014-3-28
/// 描述：更改产品课节
/// </summary>
/// <param name="pLevelCourseTypeCourse"></param>
/// <returns></returns>
public static bool UpdateProductLevelCourseTypeCourse(ProductLevelCourseTypeCourse pLevelCourseTypeCourse)
{
using (var edb = new EmeEntities())
{
var model = edb.ProductLevelCourseTypeCourse.FirstOrDefault(p => p.Id == pLevelCourseTypeCourse.Id);
if (null == model)
return false;
model.BranchId = pLevelCourseTypeCourse.BranchId;
model.ProductLevelCourseTypeId = pLevelCourseTypeCourse.ProductLevelCourseTypeId;
model.Coding = pLevelCourseTypeCourse.Coding;
model.CourseId = pLevelCourseTypeCourse.CourseId;
model.ClassHour = pLevelCourseTypeCourse.ClassHour;
model.Stage = pLevelCourseTypeCourse.Stage;
model.IsSystem = pLevelCourseTypeCourse.IsSystem;
model.Status = pLevelCourseTypeCourse.Status;
model.OrderNum = pLevelCourseTypeCourse.OrderNum;
model.UpdateBy = pLevelCourseTypeCourse.UpdateBy;
model.UpdateTime = pLevelCourseTypeCourse.UpdateTime;
model.Remark = pLevelCourseTypeCourse.Remark;
edb.Entry(model).State = EntityState.Modified;
return edb.SaveChanges() > 0;
}
}
/// <summary>
/// 作者：Primo
/// 日期：2014.06.10
/// 描述：更改产品课节
/// </summary>
/// <param name="pLevelCourseTypeCourse"></param>
/// <param name="course"></param>
/// <param name="loginUserId"></param>
/// <returns></returns>
public static bool UpdateProductLevelCourseTypeCourseAndCourse(ProductLevelCourseTypeCourse pLevelCourseTypeCourse, Course course, int loginUserId)
{
using (var edb = new EmeEntities())
{
try
{
var courseObj = edb.Course.FirstOrDefault(p => p.Id == course.Id);
if (null != courseObj)
{
courseObj.CName = course.CName;
courseObj.EName = course.EName;
courseObj.ClassTime = course.ClassTime;
courseObj.Description = course.Description;
courseObj.StudyTypeId = course.StudyTypeId;
courseObj.UpdateBy = course.UpdateBy;
courseObj.UpdateTime = course.UpdateTime;
edb.Entry(courseObj).State = EntityState.Modified;
}
var pLevelCourseTypeCourseObj = edb.ProductLevelCourseTypeCourse.FirstOrDefault(p => p.Id == pLevelCourseTypeCourse.Id);
if (null != pLevelCourseTypeCourseObj)
{
pLevelCourseTypeCourseObj.ClassHour = pLevelCourseTypeCourse.ClassHour;
pLevelCourseTypeCourseObj.Stage = pLevelCourseTypeCourse.Stage;
pLevelCourseTypeCourseObj.Coding = pLevelCourseTypeCourse.Coding;
pLevelCourseTypeCourseObj.OrderNum = pLevelCourseTypeCourse.OrderNum;
pLevelCourseTypeCourseObj.UpdateBy = pLevelCourseTypeCourse.UpdateBy;
pLevelCourseTypeCourseObj.UpdateTime = pLevelCourseTypeCourse.UpdateTime;
edb.Entry(pLevelCourseTypeCourseObj).State = EntityState.Modified;
}
return edb.SaveChanges() > 0;
}
catch (Exception e)
{
// 异常日志消息队列
Common.MSMQ.QueueManager.AddExceptionLog(new ExceptionLogs()
{
ExceptionType = CommonHelper.To<int>(ExceptionType.Function),
Message = string.Format("ProductBLL-UpdateProductLevelCourseTypeCourseAndCourse：{0};{1};{2}", e.Message, e.InnerException.Message, e.HelpLink),
IsTreat = false,
CreateBy = loginUserId,
CreateTime = DateTime.Now
});
return false;
}
}
}
public JsonResult CreateProductLevelCourseTypeCourse(FormCollection collection)
{
var result = false;
var productId = CommonHelper.To<int>(collection["addProductId"]);
var branchId = CommonHelper.To<int>(collection["hiddenAddBranchId"]);
var cName = collection["AddCName"];
var eName = collection["EName"];
var coding = collection["AddCoding"];
var classTime = CommonHelper.To<int>(collection["ClassTime"]);
var orderNum = CommonHelper.To<int>(collection["OrderNum"]);
var studyType = CommonHelper.To<int>(collection["studyType"]);
var classHour = CommonHelper.To<int>(collection["ClassHour"]);
var stage = CommonHelper.To<int>(collection["Stage"]);
var productLevelId = CommonHelper.To<int>(collection["addProductLevel"]);
var productCourseTypeId = CommonHelper.To<int>(collection["addProductCourseType"]);
var description = collection["Description"];
var pLevelCourseType = ProductBLL.GetProductLevelCourseType(productLevelId, productCourseTypeId);
var productLevelCourseTypeId = pLevelCourseType.Id;
var course = new Model.Eme.Course()
{
CName = cName,
EName = eName,
Description = description,
ClassTime = classTime,
StudyTypeId = studyType,
OrderNum = orderNum,
Status = CommonHelper.To<int>(StatusType.Active),
CreateBy = LoginUserManager.CurrLoginUser.UserId,
CreateTime = DateTime.Now
};
var productModel = ProductBLL.GetProductById(productId);
var isSystem = (productModel.BranchId == branchId ? true : false);
var productLevelCourseTypeCourse = new ProductLevelCourseTypeCourse()
{
ProductLevelCourseTypeId = productLevelCourseTypeId,
ClassHour = classHour,
BranchId = branchId,
Stage = stage,
Coding = coding,
OrderNum = orderNum,
IsSystem = isSystem,
Status = CommonHelper.To<int>(StatusType.Active),
CreateBy = LoginUserManager.CurrLoginUser.UserId,
CreateTime = DateTime.Now
};
result = ProductBLL.CreateProductLevelCourseTypeCourse(productLevelCourseTypeCourse, course, LoginUserManager.CurrLoginUser.UserId);
var msg = result ? "新增产品操作完成！" : "新增产品操作失败！";
return Json(new { msg = msg, status = result, productLevelId = productLevelId }, JsonRequestBehavior.DenyGet);
}