public void LoadCoursesDataGridView()
{
CourseBLL aCourseBLL = new CourseBLL();
DataTable dt = aCourseBLL.ViewCoursesInGridviewBLL();
ViewCoursesdataGridView1.DataSource = dt;
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
Int32 records = 0;
if (validateData())
{
Entities.Course oSubject = new Entities.Course();
oSubject.id = Convert.ToInt32(txtCode.Text);
oSubject.description = txtName.Text;
oSubject.state = Convert.ToInt16(cboState.SelectedValue);
oSubject.oProgram.code = Convert.ToInt32(cboprogram.SelectedValue);
if (CourseBLL.getInstance().exists(oSubject.id))
{
records = CourseBLL.getInstance().modify(oSubject);
}
else
{
records = CourseBLL.getInstance().insert(oSubject);
}
blockControls();
loadData();
if (records > 0)
{
lblMessage.Text = "Datos almacenados correactamente";
}
}
}
/// <summary>
/// 所有课程信息
/// </summary>
/// <returns></returns>
public ActionResult AllCoursePage(int pageIndex, string key, string value)
{
ViewBag.CourseKey = key; //搜索条件
ViewBag.SearchValue = value; //搜索的值
CourseBLL courseBLL = new CourseBLL();
int PageSize = 8; //页容量
int TotalCount = courseBLL.GetDataCount(key, value); //数据总量
int TotalPages = (int)Math.Ceiling(TotalCount / (double)PageSize); //分页张数
int PageIndex = pageIndex; //页面索引
if (PageIndex >= TotalPages)
{
PageIndex = TotalPages - 1;
}
if (PageIndex < 0)
{
PageIndex = 0;
}
PagePading(PageSize, TotalCount, TotalPages, PageIndex);// 分页
DataTable table = courseBLL.GetCourseQuery(PageIndex, PageSize, key, value);
return(View(table));
}
//添加课程
private void ucBtnAdd_BtnClick(object sender, EventArgs e)
{
if (!Check.isCourse(textBox1.Text))
{
MessageBox.Show("课程号错误");
return;
}
string cid = textBox1.Text;
string cname = textBox2.Text;
Course course = new Course()
{
CID = cid,
CName = cname,
Departments = teacher.Departments,
CTeacher = teacher.TID
};
CourseBLL bll = new CourseBLL();
if (bll.AddCourse(course))
{
MessageBox.Show("添加成功");
LoadCourseInfo();
}
else
{
MessageBox.Show("添加失败");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
int queryString = RequestHelper.GetQueryString <int>("ID");
CourseCateInfo CourseCateModel = new CourseCateInfo();
CourseCateModel.Condition = systemCompanyId.ToString();
this.CateId.DataSource = CourseCateBLL.ReadCourseCateNamedList(CourseCateModel);
this.CateId.DataTextField = "CateName";
this.CateId.DataValueField = "CateId";
this.CateId.DataBind();
this.CateId.Items.Insert(0, new ListItem("请选择类别", "-1"));
if (queryString != int.MinValue)
{
base.CheckAdminPower("UpdateCourse", PowerCheckType.Single);
CourseInfo CourseModel = CourseBLL.ReadCourse(queryString);
//if (CompanyId.Items.Contains(CompanyId.Items.FindByValue(CourseModel.CompanyId.ToString()))) CompanyId.Items.FindByValue(CourseModel.CompanyId.ToString()).Selected = true;
if (this.CateId.Items.Contains(this.CateId.Items.FindByValue(CourseModel.CateId.ToString())))
{
this.CateId.Items.FindByValue(CourseModel.CateId.ToString()).Selected = true;
}
this.CourseName.Text = CourseModel.CourseName;
//this.CourseCode.Text = CourseModel.CourseCode;
this.OrderIndex.Text = CourseModel.OrderIndex.ToString();
}
else
{
base.CheckAdminPower("AddCourse", PowerCheckType.Single);
}
}
//Control control = FindControlById(this, "CompanyId1");
//if (control != null) ScriptHelper.Alert("找到了");
}
private void CourseRemove_Click(object sender, EventArgs e)//删除按钮功能
{
var rows = CourseList.SelectedRows;
if (rows.Count > 0)
{
DialogResult result = MessageBox.Show("确定要删除吗？", "提示", MessageBoxButtons.OKCancel);
if (result == DialogResult.Cancel)
{
return;
}
string cno = rows[0].Cells[0].Value.ToString();
CourseBLL courseBLL = new CourseBLL();
if (courseBLL.Remove(cno))
{
MessageBox.Show("删除成功");
LoadCourseList();
}
else
{
MessageBox.Show("删除失败");
}
}
else
{
MessageBox.Show("请选择要删除的行");
}
}
public JsonResult GetById([FromForm] int courseId)
{
DataResult dr = new DataResult();
try
{
CourseBLL courseBLL = new CourseBLL();
CourseEntity courseEntity = courseBLL.GetById(courseId);
courseEntity.videoUrl = "";
TeacherBLL teacherBLL = new TeacherBLL();
courseEntity.teacherEntity = teacherBLL.GetById(courseEntity.teacherId);
CourseOrderBLL courseOrderBLL = new CourseOrderBLL();
courseEntity.countSold = courseOrderBLL.GetCountByCourseId(courseEntity.courseId);
dr.code = "200";
dr.data = courseEntity;
}
catch (Exception ex)
{
dr.code = "999";
dr.msg = ex.Message;
}
return(Json(dr));
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string id = Request.QueryString["id"].ToString();
AttendanceBLL attendBLL = new AttendanceBLL();
attend = attendBLL.get(id);
CourseTableBLL ctBLL = new CourseTableBLL();
CourseTable ct = ctBLL.get(attend.CourTableID);
ClassBLL classBLL = new ClassBLL();
TeacherBLL teacherBLL = new TeacherBLL();
CourseBLL courseBLL = new CourseBLL();
StudentBLL stuBLL = new StudentBLL();
#region 绑定页面数据
Label_class.Text = classBLL.get(ct.ClassID).Name;
Label_course.Text = courseBLL.get(ct.CourId).Name;
Label_teacher.Text = teacherBLL.get(ct.TeachID).Name;
Label_student.Text = stuBLL.get(attend.StudID).Name;
Label_oldStatus.Text = attend.Status;
Label_week.Text = ct.Week;
Label_weekDay.Text = ct.WeekDay;
Label_courseTime.Text = ct.CourseTime;
Label_place.Text = ct.Place;
#endregion
}
private void LoadCounter()
{
try
{
InstituteBLL instituteBLL = new InstituteBLL();
DataTable dtInstitute = instituteBLL.GetAllActive();
lblTotalUniversity.Text = Convert.ToString(dtInstitute.Rows.Count);
LenderBankBLL lenderBankBLL = new LenderBankBLL();
DataTable dtLenderBank = lenderBankBLL.GetAllActive();
lblTotalBank.Text = Convert.ToString(dtLenderBank.Rows.Count);
CourseBLL courseBLL = new CourseBLL();
DataTable dtCourse = courseBLL.GetAllActive();
lblTotalCourse.Text = Convert.ToString(dtCourse.Rows.Count);
BlogPostBLL blogPostBLL = new BlogPostBLL();
DataTable dtBlogPost = blogPostBLL.GetAllActive();
lblTotalBlogPost.Text = Convert.ToString(dtBlogPost.Rows.Count);
UserBLL userBLL = new UserBLL();
DataTable dtUser = userBLL.GetAllActiveMember();
lblTotalMember.Text = Convert.ToString(dtUser.Rows.Count);
}
catch (Exception)
{
//throw;
}
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string courTableID = Request.QueryString["courTableID"];
CourseTableBLL ctBLL = new CourseTableBLL();
TeacherBLL teacherBLL = new TeacherBLL();
CourseBLL courBLL = new CourseBLL();
ClassBLL classBLL = new ClassBLL();
CourseTable ct = ctBLL.get(courTableID);
Class clazz = classBLL.get(ct.ClassID);
#region 页面数据绑定
className.Text = clazz.Name;
courseName.Text = courBLL.get(ct.CourId).Name;
teacherName.Text = teacherBLL.get(ct.TeachID).Name;
week.Text = "第" + ct.Week + "周";
weekDay.Text = ct.WeekDay;
classtTime.Text = ct.CourseTime;
classAddress.Text = ct.Place;
CommonBLL commBLL = new CommonBLL();
DataTable dt = commBLL.getAbsentStudent(courTableID, false);
AspNetPager1.RecordCount = dt.Rows.Count;
int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1;
GridView1.DataSource = PageUtil.getPaged(dt, from, to);
GridView1.DataBind();
#endregion
}
private void LoadCourse()
{
CourseBLL bll = new CourseBLL();
List <Course> list = bll.getCourse();
dataGridView1.DataSource = list;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ClassBLL classBLL = new ClassBLL();
CourseBLL courBLL = new CourseBLL();
TeacherBLL teachBLL = new TeacherBLL();
//绑定页面查询条件的数据
DropDownList_class.DataSource = classBLL.getAll();
DropDownList_class.DataTextField = "name";
DropDownList_class.DataBind();
DropDownList_class.Items.Insert(0, "全部班级");
DropDownList_course.DataSource = courBLL.getAll();
DropDownList_course.DataTextField = "name";
DropDownList_course.DataBind();
DropDownList_course.Items.Insert(0, "全部课程");
DropDownList_teacher.DataSource = teachBLL.getTeachers();
DropDownList_teacher.DataTextField = "name";
DropDownList_teacher.DataBind();
DropDownList_teacher.Items.Insert(0, "全部教师");
bind();
}
}
private void LoadMyCourse()
{
CourseBLL bll = new CourseBLL();
List <Course> list = bll.getMyCourse(sid);
dataGridView2.DataSource = list;
}
protected void BindRelation(ProductInfo product)
{
ProductSearchInfo info2;
if (product.RelationArticle != string.Empty)
{
ArticleSearchInfo articleSearch = new ArticleSearchInfo();
articleSearch.InArticleID = product.RelationArticle;
this.Article.DataSource = ArticleBLL.SearchArticleList(articleSearch);
this.Article.DataTextField = "Title";
this.Article.DataValueField = "ID";
this.Article.DataBind();
}
if (product.RelationProduct != string.Empty)
{
info2 = new ProductSearchInfo();
info2.InProductID = product.RelationProduct;
this.Product.DataSource = ProductBLL.SearchProductList(info2);
this.Product.DataTextField = "Name";
this.Product.DataValueField = "ID";
this.Product.DataBind();
}
if (product.Accessory != string.Empty)
{
CourseInfo courseSearch = new CourseInfo();
courseSearch.Condition = product.Accessory;
courseSearch.Field = "CourseId";
this.Accessory.DataSource = CourseBLL.ReadList(courseSearch);
this.Accessory.DataTextField = "CourseName";
this.Accessory.DataValueField = "CourseId";
this.Accessory.DataBind();
}
}
protected void SearchButton_Click(object sender, EventArgs e)
{
//定义一个课程Id变量，为后续题目的相关搜索条件提供前提搜索条件
string TempStr = string.Empty;
if (SearchCategory.SelectedValue == int.MinValue.ToString() && SearchCourseName.Text == "" && SearchQuestionName.Text == "" && SearchQuestionStyle.SelectedValue == "")
{
ScriptHelper.Alert("请填写搜索条件！");
}
CourseInfo CourseModel = new CourseInfo();
if (SearchCategory.SelectedValue != int.MinValue.ToString())
{
CourseModel.CateId = int.Parse(SearchCategory.SelectedValue);
}
if (!string.IsNullOrEmpty(SearchCourseName.Text))
{
CourseModel.CourseName = SearchCourseName.Text;
}
List <CourseInfo> TempList = CourseBLL.ReadList(CourseModel);
if (TempList != null)
{
foreach (CourseInfo Item in TempList)
{
TempStr = TempStr + "," + Item.CourseId;
}
if (TempStr.StartsWith(","))
{
TempStr = TempStr.Substring(1);
}
}
ResponseHelper.Redirect("Questions.aspx?Action=search&QuestionName=" + Server.UrlEncode(SearchQuestionName.Text) + "&IdCondition=" + TempStr + "&Style=" + SearchQuestionStyle.SelectedValue);
}
private void BindsTypes()
{
ddlCourseId.DataSource = CourseBLL.AllData("", "CourseId", "");
ddlCourseId.DataTextField = "CourseName";
ddlCourseId.DataValueField = "CourseId";
ddlCourseId.DataBind();
ddlSutId.DataSource = SudentsBLL.AllData("", "SutId", "");
ddlSutId.DataTextField = "SutName";
ddlSutId.DataValueField = "SutId";
ddlSutId.DataBind();
ddlSemesterId.DataSource = SemesterBLL.AllData("", "SemesterId", "");
ddlSemesterId.DataTextField = "SemesterName";
ddlSemesterId.DataValueField = "SemesterId";
ddlSemesterId.DataBind();
ddlSemesterName.DataSource = SemesterBLL.AllData("", "SemesterId", "");
ddlSemesterName.DataTextField = "SemesterName";
ddlSemesterName.DataValueField = "SemesterId";
ddlSemesterName.DataBind();
ddlSemesterName.Items.Insert(0, new ListItem("全部", "0"));
ddlCourseName.DataSource = CourseBLL.AllData("", "CourseId", "");
ddlCourseName.DataTextField = "CourseName";
ddlCourseName.DataValueField = "CourseId";
ddlCourseName.DataBind();
ddlCourseName.Items.Insert(0, new ListItem("全部", "0"));
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
try
{
string id = Convert.ToString(e.CommandArgument);
if (!string.IsNullOrEmpty(id))
{
CourseBLL courseBLL = new CourseBLL();
Courses course = new Courses();
course.CourseId = Convert.ToInt32(QuaintSecurityManager.Decrypt(id));
if (course.CourseId > 0)
{
if (courseBLL.Delete(course))
{
Alert(AlertType.Success, "Deleted successfully.");
LoadList();
}
else
{
Alert(AlertType.Error, "Failed to delete.");
}
}
}
}
catch (Exception)
{
Alert(AlertType.Error, "Failed to delete.");
}
}
public EnrollMentUI()
{
InitializeComponent();
aEnrollBll = new EnrollBLL();
aCourseBll = new CourseBLL();
aStudentBll = new StudentBLL();
courseComboBox.DisplayMember = "Name";
List <Course> courses = new List <Course>();
courses = aCourseBll.GetAllCourseName();
foreach (Course aCourse in courses)
{
courseComboBox.Items.Add(aCourse);
}
stdRegNoComboBox.DisplayMember = "RegNo";
List <Student> students;
students = aStudentBll.GetAllRegNo();
foreach (Student aStudent in students)
{
stdRegNoComboBox.Items.Add(aStudent);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CourseTableBLL ctBLL = new CourseTableBLL();
ClassBLL classBLL = new ClassBLL();
CourseBLL courBLL = new CourseBLL();
TeacherBLL teachBLL = new TeacherBLL();
DropDownList_class.DataSource = classBLL.getAll();
DropDownList_class.DataTextField = "name";
DropDownList_class.DataValueField = "ID";
DropDownList_class.DataBind();
DropDownList_course.DataSource = courBLL.getByClassId(DropDownList_class.SelectedValue);
DropDownList_course.DataTextField = "name";
DropDownList_course.DataValueField = "ID";
DropDownList_course.DataBind();
string filterTeacher = "classID='" + DropDownList_class.SelectedValue + "' and courId='" + DropDownList_course.SelectedValue + "'";
DataTable tempDt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filterTeacher, null, false);
DataView dv = tempDt.DefaultView;
tempDt = dv.ToTable(true, "teachID");
foreach (DataRow dr in tempDt.Rows)
{
Teacher teacher = teachBLL.get(dr["teachID"].ToString());
DropDownList_teacher.Items.Add(new ListItem(teacher.Name, teacher.Id));
}
bind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
int id = RequestHelper.GetQueryString <int>("ID");
string Action = RequestHelper.GetQueryString <string>("Action");
if (Action == "Delete")
{
if (id != int.MinValue)
{
base.CheckAdminPower("DeleteCourse", PowerCheckType.Single);
CourseBLL.DeleteCourse(id);
AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("Course"), id);
}
}
base.CheckAdminPower("ReadCourse", PowerCheckType.Single);
if (!IsPostBack)
{
//在此处加载搜索框的类别信息
CourseCateInfo CourseCateModel = new CourseCateInfo();
CourseCateModel.Condition = CompanyBLL.SystemCompanyId.ToString();
SearchCategory.DataSource = CourseCateBLL.ReadCourseCateNamedList(CourseCateModel);
SearchCategory.DataTextField = "CateName";
SearchCategory.DataValueField = "CateId";
SearchCategory.DataBind();
SearchCategory.Items.Insert(0, new ListItem("可以指定类别", "-1"));
CourseInfo Model = new CourseInfo();
Model.CourseName = RequestHelper.GetQueryString <string>("CourseName");
Model.CateIdCondition = RequestHelper.GetQueryString <string>("CateIdCondition");
Model.Condition = CompanyBLL.SystemCompanyId.ToString();
Model.Field = "CompanyId";
base.BindControl(CourseBLL.ReadList(Model, base.CurrentPage, base.PageSize, ref this.Count), this.RecordList, this.MyPager);
}
}
private void yxm_SelectedIndexChanged(object sender, EventArgs e)//院系改变，课程下拉框数据源改变
{
DepartmentBLL departmentBLL = new DepartmentBLL();
CourseBLL courseBLL = new CourseBLL();
kc.DataSource = courseBLL.deptnoGetcname(departmentBLL.GetDeptno(yxm.Text));
}
private void btnOK_Click(object sender, EventArgs e)
{
if (MessageBoxEx.Show("确认开设此课程吗？请注意填写信息", "提示~", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
CourseBLL bll = new CourseBLL();
Course model = new Course(); //建立数据对象
model.Name = txtCourseName.Text.Trim();
model.Room_name = txtRoomName.Text.Trim();
model.Semester = txtSemester.Text;
model.Speciality_id = (int)cbSpeciality.SelectedValue;
model.Submitter_id = frmMain.current_user.Id;
if (bll.AddCourse(model))
{
MessageBoxEx.Show("添加成功！！！");
btnCancel_Click(sender, e); //关闭窗口
}
else
{
MessageBoxEx.Show("添加失败，请检查信息后重试");
}
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string id = Request.QueryString["ID"].ToString();
string week = Request.QueryString["week"].ToString();
CourseBLL courBLL = new CourseBLL();
TeacherBLL teacherBLL = new TeacherBLL();
ClassBLL classBLL = new ClassBLL();
CourseTableBLL ctBLL = new CourseTableBLL();
ct = ctBLL.get(id);
#region 页面数据绑定
Label_course.Text = courBLL.get(ct.CourId).Name;
Label_teacher.Text = teacherBLL.get(ct.TeachID).Name;
Label_class.Text = classBLL.get(ct.ClassID).Name;
PageUtil.bindDropDownList(DropDownList_semester_from, ct.Semester.Substring(0, 4));
PageUtil.bindDropDownList(DropDownList_semester_to, ct.Semester.Substring(5, 4));
PageUtil.bindDropDownList(DropDownList_semester_end, ct.Semester.Substring(9, 3));
PageUtil.bindDropDownList(DropDownList_week_from, week.Split('-')[0]);
PageUtil.bindDropDownList(DropDownList_week_to, week.Split('-')[1]);
PageUtil.bindDropDownList(DropDownList_weekDay, ct.WeekDay);
TextBox_place.Text = ct.Place;
PageUtil.bindDropDownList(DropDownList_courseTime, ct.CourseTime.Split('节')[0]);
#endregion
}
public JsonResult PageList([FromForm] string token, [FromForm] int courseTypeId = -1, [FromForm] int pageNumber = 1, [FromForm] int pageSize = 10)
{
DataResult dr = new DataResult();
try
{
CourseBLL courseBLL = new CourseBLL();
int totalItemCount = courseBLL.Count(courseTypeId);
List <CourseEntity> courseEntities = courseBLL.List(courseTypeId, pageNumber: pageNumber, pageSize: pageSize, totalCount: totalItemCount);
if (courseEntities.Count > 0)
{
CourseOrderBLL courseOrderBLL = new CourseOrderBLL();
courseEntities.ForEach(it =>
{
it.countSold = courseOrderBLL.GetCountByCourseId(it.courseId);
});
}
PageData pageData = new PageData(courseEntities, pageNumber, pageSize, totalItemCount);
dr.code = "200";
dr.data = pageData;
}
catch (Exception ex)
{
dr.code = "999";
dr.msg = ex.Message;
}
return(Json(dr));
}
protected void btnActiveOrDeactive_Command(object sender, CommandEventArgs e)
{
try
{
string id = Convert.ToString(e.CommandArgument);
if (!string.IsNullOrEmpty(id))
{
CourseBLL courseBLL = new CourseBLL();
DataTable dt = courseBLL.GetById(Convert.ToInt32(QuaintSecurityManager.Decrypt(id)));
if (dt != null)
{
if (dt.Rows.Count > 0)
{
string actionStatus = "Updated";
Courses course = new Courses();
course.CourseId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CourseId"]));
course.CourseCode = Convert.ToString(dt.Rows[0]["CourseCode"]);
course.Name = Convert.ToString(dt.Rows[0]["Name"]);
course.Description = Convert.ToString(dt.Rows[0]["Description"]);
course.Attachment = Convert.ToString(dt.Rows[0]["Attachment"]);
course.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"]));
course.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"]));
course.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]);
course.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]);
course.UpdatedDate = DateTime.Now;
course.UpdatedBy = UserInfo;
course.UpdatedFrom = StationInfo;
if (course.IsActive)
{
course.IsActive = false;
actionStatus = "Deactivated";
}
else
{
course.IsActive = true;
actionStatus = "Activated";
}
if (courseBLL.Update(course))
{
Alert(AlertType.Success, actionStatus + " successfully.");
LoadList();
}
else
{
Alert(AlertType.Error, "Failed to update.");
}
}
}
}
}
catch (Exception)
{
Alert(AlertType.Error, "Failed to process.");
}
}
public void TestMethod1()
{
CourseMock userMock = new CourseMock();
CourseBLL userBLL = new CourseBLL(userMock);
var number = 1;
Assert.AreEqual(number, 1);
}
private void Deptname_Cname_LoadList()//设置目录查询的两个下拉框的数据源
{
DepartmentBLL departmentBLL = new DepartmentBLL();
yxm.DataSource = departmentBLL.GetAllDeptname();
CourseBLL courseBLL = new CourseBLL();
kc.DataSource = courseBLL.deptnoGetcname(departmentBLL.GetDeptno(yxm.Text));
}
// GET: UserArea/AboutUsPage
public ActionResult Index()
{
CourseBLL cbll = new CourseBLL();
List <CourseVM> mylist = cbll.getAllCourses();
SelectList li = new SelectList(mylist, "course_id", "course_name");
ViewBag.li = li;
return(View());
}
private void LoadCourseList()//显示课程表的所有数据
{
CourseBLL miBll = new CourseBLL();
CourseList.DataSource = miBll.GetList();
DepartmentBLL departmentBLL = new DepartmentBLL();
Deptno.DataSource = departmentBLL.GetAllDeptno();
}
private void Binds()
{
ddlTeacherId.DataSource = TeacherBLL.AllData("", "TeacherId", "");
ddlTeacherId.DataTextField = "TeacherName";
ddlTeacherId.DataValueField = "TeacherId";
ddlTeacherId.DataBind();
rpView.DataSource = CourseBLL.AllData("", "CourseId", "asc");
rpView.DataBind();
}
private void Del_Click(object sender, EventArgs e)
{
if (txtCourseNum.Text == "")
{
MessageBox.Show("课程号不能为空！\n 请重新输入！");
}
else
{
CourseBLL objCourseBLL = new CourseBLL();
CourseModel objCourseModel = new CourseModel();
objCourseModel.CourseNum = txtCourseNum.Text;
if (objCourseBLL.DelCourse(objCourseModel) == true)
{
MessageBox.Show("成功删除！!");
}
else
{
MessageBox.Show("删除失败!");
}
ShowTable();
}
}
private void ShowTable()
{
CourseBLL objCourseBLL = new CourseBLL();
dgvshow.DataSource = objCourseBLL.ShowCourse();
}
public static List<Course> Course_CourseName_List(string coursename)
{
CourseBLL coursebll = new CourseBLL();
return coursebll.Course_CourseName_List(coursename);
}
public static List<Course> Course_List(Course course, int pageindex, int pagesize)
{
CourseBLL coursebll = new CourseBLL();
return coursebll.Course_List(course, pageindex, pagesize);
}
public static IES.CC.OC.Model.OC OC_Get(int OCID)
{
CourseBLL coursebll = new CourseBLL();
return coursebll.OC_Get(OCID);
}
public static Course Course_Get(int CourseID)
{
CourseBLL coursebll = new CourseBLL();
return coursebll.Course_Get(CourseID);
}
