private void tsbAdd_Click(object sender, EventArgs e)
{
if (txtCourseName.Text == "")
{
MessageBox.Show("请输入科目名称！");
}
else
{
if (CourseBll.GetCourse(txtCourseName.Text))
{
try
{
CourseBll.CourseAdd(txtCourseName.Text);
dataGridView1.DataSource = CourseBll.CourseFillDs().Tables[0];
getcolumn();
MessageBox.Show("添加成功！");
}
catch (Exception ee)
{
MessageBox.Show("添加失败！" + ee);
throw;
}
}
else
{
MessageBox.Show("科目已存在！");
}
}
}
public ActionResult ReopenCourse(int courseId)
{
CourseBll bll = new CourseBll();
bll.ReopenCourse(courseId, CurrentUserID);
return(Json(new SuccessJsonResponse()));
}
/// <summary>
/// 编辑
/// </summary>
/// <returns></returns>
public ActionResult Edit(int id = 0)
{
if (id > 0)//禁止编辑
{
return(RedirectToAction("Index"));
}
CashVoucherBll cashVoucherBll = new CashVoucherBll();
CourseBll bll = new CourseBll();
DtoCashVoucher voucher = new DtoCashVoucher();
decimal CashVoucherLimit = -1;
if (id > 0)
{
voucher = cashVoucherBll.GetVoucherById(id);
if (voucher != null)
{
var priceModel = bll.GetCoursePrice(voucher.Ycv_CourseId, CurrentUser.School.Bsl_Level);
if (priceModel != null)
{
CashVoucherLimit = Math.Floor(priceModel.Yce_Price * (100 - CurrentUser.School.Bhl_DividePercent) / 100);
}
}
}
ViewBag.CashVoucherLimit = CashVoucherLimit;
ViewBag.DividePercent = CurrentUser.School.Bhl_DividePercent;
return(View(voucher));
}
/// <summary>
/// 课程中心-课程列表（加载课程列表）
/// </summary>
/// <param name="search">筛选条件、分页信息</param>
/// <returns></returns>
public JsonResult GetCourses(CourseSearch search)
{
CourseBll bll = new CourseBll();
DtoCourseSelectCondition condition = new DtoCourseSelectCondition();
condition.Grade = search.Grade;
condition.CourseType = search.CourseType;
condition.OrderBy = (DtoCourseSelectCondition.DtoCourseSelectOrderEnum)search.OrderBy;
condition.StudentId = GetCurrentUser().StudentId;
PagingObject paging = search.Pagination;
//是否包含价格
bool includePrice = false;
List <DtoSelectCenterResult> entities = bll.GetCourseForSelectCenter(condition, paging, out includePrice);
IEnumerable <CourseViewModel> list = entities.Select(s => {
var model = s.ConvertTo <CourseViewModel>();
if (string.IsNullOrEmpty(model.CourseImage))
{
model.CourseImage = defaultCourseImg;
}
return(model);
});
bool hasMore = paging.TotalCount > search.Pagination.PageIndex * search.Pagination.PageSize;
return(Json(new JsonResponse <CourseSet> {
State = true, ErrorCode = 0, ErrorMsg = "", Data = new CourseSet()
{
DataList = list, HasMore = hasMore, IncludePrice = includePrice
}
}, JsonRequestBehavior.AllowGet));
}
public StudentFormController(StudentForm studentForm, StudentBll studentBll, CourseBll courseBll)
{
_studentForm = studentForm;
_studentBll = studentBll;
_courseBll = courseBll;
UpdateForm();
}
public ActionResult RemoveCoverImage(CoverImageInputModel input)
{
CourseBll bll = new CourseBll();
bll.RemoveCoverImage(input.CourseId);
return(Json(new SuccessJsonResponse(), JsonRequestBehavior.AllowGet));
}
public CourseViewEditPresenter(CourseEditView courseEditView, CourseBll courseBll, TeacherBll teacherBll)
{
_courseEditView = courseEditView;
_courseBll = courseBll;
_teacherBll = teacherBll;
UpdateForm();
}
private void LoadCourse()
{
List <Cours> lisCourse = new CourseBll(mAccount).getElements();
lookUpEditCourse.Properties.DisplayMember = "CourseName";
lookUpEditCourse.Properties.ValueMember = "Id";
lookUpEditCourse.Properties.DataSource = lisCourse;
}
public ActionResult AddCoverImage(CoverImageInputModel input)
{
CourseBll bll = new CourseBll();
string imgUrl = UeditorContentFactory.FetchUrl(
input.CoverImage, UeditorType.Image);
bll.AddCoverImage(input.CourseId, imgUrl);
return(Json(new SuccessJsonResponse()));
}
public ActionResult GetCourses(DtoCurriculumSearch search)
{
CourseBll bll = new CourseBll();
IList <DtoCourseListItem> entities = bll.GetManageCourses(search);
PropertyNamePrefixAction action = PropertyNamePrefixAction.Remove;
IEnumerable <CourseViewModel> list =
entities.Select(s => s.ConvertTo <CourseViewModel>(action));
return(Table(list, search.Pagination.TotalCount));
}
public ActionResult GetLogs(int courseId)
{
CourseBll bll = new CourseBll();
var lessons = bll.GetLogs(courseId);
var result = lessons.ConvertTo <IList <LessonViewModel> >();
SuccessJsonResponse response = new SuccessJsonResponse {
Data = result
};
return(Json(response, JsonRequestBehavior.AllowGet));
}
public ActionResult Pricing(CoursePricingInputModel input)
{
CourseBll bll = new CourseBll();
input.CoverIamge = UeditorContentFactory.FetchUrl(
input.CoverIamge, UeditorType.Image);
DtoCoursePricing price = input.ConvertTo <DtoCoursePricing>();
bll.Pricing(price, CurrentUserID);
return(Json(new SuccessJsonResponse()));
}
public ActionResult AddCourseConfirm(CourseInputModel input)
{
Domain.Dto.Request.DtoCourse course = input.ConvertTo <Domain.Dto.Request.DtoCourse>();
course.CurrentUser = CurrentUserID;
CourseBll bll = new CourseBll();
bll.AddCourse(course);
return(Json(new SuccessJsonResponse(Url.Action(nameof(ListCurriculums)))));
}
// GET: Course
public ActionResult GetPrice(int courseId)
{
CourseBll bll = new CourseBll();
decimal price = 0;
var priceModel = bll.GetCoursePrice(courseId, CurrentUser.School.Bsl_Level);
if (priceModel != null)
{
price = priceModel.Yce_Price;
}
return(Json(price, JsonRequestBehavior.AllowGet));
}
private void saveButton_Click(object sender, EventArgs e)
{
Course aCourse = new Course();
aCourse.Code = codeTextBox.Text;
aCourse.Name = nameTextBox.Text;
aCourse.Credit = (float)Convert.ToDouble(creditTextBox.Text);
CourseBll aCourseBll = new CourseBll();
string msg = aCourseBll.SaveIntoDataBase(aCourse);
MessageBox.Show(msg);
}
/// <summary>
/// 课程中心-课程详情-后台预览
/// </summary>
/// <param name="id">课程Id</param>
/// <returns></returns>
public ActionResult PreviewCourse(int id = 0)
{
CourseBll bll = new CourseBll();
int studentId = GetCurrentUser().StudentId;
DtoSelectCenterCourseDetailResult course = bll.GetCourseDetailForPreview(id, studentId);
CourseDetailViewModel model = course.ConvertTo <CourseDetailViewModel>();
model.StudentId = studentId;
if (string.IsNullOrEmpty(model.CourseImage))
{
model.CourseImage = defaultCourseImg;
}
return(View(model));
}
public ActionResult GetDetails(int id)
{
CourseBll bll = new CourseBll();
var dtoDetails = bll.GetDetailOfManagements(id);
var vm = dtoDetails.ConvertTo <CurriculumDetailsViewModel>(
PropertyNamePrefixAction.Remove);
vm.CoverImage = UeditorContentFactory.RestoreUrl(vm.CoverImage, UeditorType.Image);
SuccessJsonResponse response = new SuccessJsonResponse {
Data = vm
};
return(Json(response, JsonRequestBehavior.AllowGet));
}
private void findButton_Click(object sender, EventArgs e)
{
string regNo = regnoTextBox.Text;
aCourseEnrollment = new CourseEnrollment();
aCourseEnrollmentBll = new CourseEnrollmentBll();
CourseBll aCourseBll = new CourseBll();
aCourseEnrollment = aCourseEnrollmentBll.CheckRegNo(regNo);
nameTextBox.Text = aCourseEnrollment.AStudent.Name;
emailTextBox.Text = aCourseEnrollment.AStudent.Email;
courseComboBox.DataSource = aCourseBll.GetAllCourse();
courseComboBox.DisplayMember = "CourseTitle";
courseComboBox.ValueMember = "CourseId";
enrolledCoursesDataGridView.DataSource = aCourseEnrollmentBll.EnrollmentGridevieDataPicker(aCourseEnrollment.AStudent.RegNo);
}
public void GetCourseForSelectCenterTest()
{
CourseBll bll = new CourseBll();
DtoCourseSelectCondition condition = new DtoCourseSelectCondition();
condition.StudentId = 10003;
condition.Grade = 0;
condition.CourseType = 0;
condition.OrderBy = DtoCourseSelectCondition.DtoCourseSelectOrderEnum.Lastest;
PagingObject paging = new PagingObject()
{
PageIndex = 1, PageSize = 20
};
bool includePrice = false;
List <DtoSelectCenterResult> result = bll.GetCourseForSelectCenter(condition, paging, out includePrice);
}
string[] courseId = new string[20];//储存课程号
private void showCourse(string tea_id)
{
courseBll = new CourseBll();
SqlDataReader sda = courseBll.showCourse(tea_id);
int i = 0;
while (sda.Read())
{
c_course.Items.Add(sda["cou_name"]);
courseId[i] = sda["cou_id"].ToString();
i++;
}
if (c_course.Items.Count == 0)
{
c_course.Text = "您还没有所教的课程";
}
}
/// <summary>
/// 课程中心-课程详情
/// </summary>
/// <param name="id">课程Id</param>
/// <returns></returns>
public ActionResult Detail(int id = 0, int aid = 0)
{
if (id == 0)
{
return(RedirectToAction("Select"));
}
CourseBll bll = new CourseBll();
int studentId = GetCurrentUser().StudentId;
DtoSelectCenterCourseDetailResult course = bll.GetCourseDetailForSelectCenter(id, studentId);
CourseDetailViewModel model = course.ConvertTo <CourseDetailViewModel>();
if (string.IsNullOrEmpty(model.CourseImage))
{
model.CourseImage = defaultCourseImg;
}
model.StudentId = studentId;
model.Ad_Id = aid;
return(View(model));
}
/// <summary>
/// 课程制作详情视图动作
/// </summary>
/// <returns></returns>
public ActionResult MakeInfo(int id = 0)
{
CourseBll bll = new CourseBll();
var model = bll.GetDetails(id);
var vm = model.ConvertTo <CurriculumDetailsViewModel>(
PropertyNamePrefixAction.Remove);
vm.CoverImage = UeditorContentFactory.RestoreUrl(
vm.CoverImage, UeditorType.Image);
if (model != null)
{
return(View(vm));
}
else
{
return(View(new CurriculumDetailsViewModel()));
}
}
public ActionResult CloseCourse(int courseId)
{
CourseBll bll = new CourseBll();
var course = bll.GetCourse(courseId);
if (course.Ycs_Status == (int)CourseStatusEnum.已上架)
{
return(Json(new JsonSimpleResponse
{
State = false,
ErrorMsg = "已上架的课程不能关闭"
}));
}
bll.UpdateStatus(
courseId,
CourseStatusEnum.已关闭,
CourseActionEnum.关闭,
CurrentUserID);
return(Json(new SuccessJsonResponse()));
}
public ActionResult DeleteCourse(int courseId)
{
CourseBll bll = new CourseBll();
var course = bll.GetCourse(courseId);
if (course.Ycs_Status != (int)CourseStatusEnum.已关闭)
{
return(Json(new JsonSimpleResponse
{
State = false,
ErrorMsg = "只有已关闭的课程才能删除"
}));
}
bll.UpdateStatus(
courseId,
CourseStatusEnum.已删除,
CourseActionEnum.除,
CurrentUserID);
return(Json(new SuccessJsonResponse()));
}
public ActionResult GetCourses(int pageNumber, int pageSize, string name)
{
CourseBll courseBll = new CourseBll();
PagingObject paging = new PagingObject(pageNumber, pageSize);
var courses = courseBll.GetPagingCourseByIdOrName(paging, name);
SelectPageModel model = new SelectPageModel();
List <Dictionary <string, object> > listDic = new List <Dictionary <string, object> >();
foreach (var item in courses)
{
var option = new Dictionary <string, object>()
{
{ "name", item.value },
{ "id", item.key }
};
listDic.Add(option);
}
model.list = listDic;
model.totalRow = paging.TotalCount;
return(Json(new { Data = model }));
}
private void tsbDel_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentCell != null)
{
if (MessageBox.Show("是否删除记录？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
try
{
CourseBll.CourseDel(dataGridView1.CurrentRow.Cells[0].Value.ToString());
MessageBox.Show("删除成功！");
dataGridView1.DataSource = CourseBll.CourseFillDs().Tables[0];
getcolumn();
}
catch (Exception ee)
{
MessageBox.Show("删除失败！" + ee);
throw;
}
}
}
}
public void GetCourseByIdOrName()
{
var idOrName = "100";
var dic = new CourseBll().GetCourseByIdOrName(idOrName);
Assert.IsNotNull(dic);
Assert.IsTrue(dic.Count > 0);
idOrName = "测试1";
dic = new CourseBll().GetCourseByIdOrName(idOrName);
Assert.IsNotNull(dic);
Assert.IsTrue(dic.Count == 0);
string fileName = "1/2/3.jpg";
string regStr = @"(\.png)|(\.jpg)";
Regex reg = new Regex(regStr);
Assert.IsTrue(reg.IsMatch(fileName));
Assert.IsTrue(reg.IsMatch("1.jpg"));
}
public void CourseBll_AddCourse_ShouldSuccess()
{
var currentUser = 10000;
CourseBll bll = new CourseBll();
DtoCourse c = new DtoCourse
{
CourseType = 2,
CurrentUser = currentUser,
Description = "d",
Grade = 1,
LessonCount = 3,
Lessons = new List <string> {
"1", "3"
},
Name = "sfsf",
Owner = currentUser,
ResourceGroupId = 2,
Employees = "1,3"
};
bll.AddCourse(c);
Assert.IsTrue(true);
}
public ActionResult StopTrading(int courseId)
{
CourseBll bll = new CourseBll();
var course = bll.GetCourse(courseId);
if (course.Ycs_Status == (int)CourseStatusEnum.已上架)
{
bll.UpdateStatus(
courseId,
CourseStatusEnum.已下架,
CourseActionEnum.架,
CurrentUserID);
return(Json(new SuccessJsonResponse()));
}
else
{
return(Json(new JsonSimpleResponse
{
State = false,
ErrorMsg = "只有已上架的课程才能下架"
}));
}
}
private void frmFillBlankAdd_Load(object sender, EventArgs e)
{
CourseBll.FillcboCourse(cboCourse);
}
