public void insert_course( DateTime createTime, int teacher, String classTime, String place, DateTime end_choose_time, DateTime start_date, DateTime end_date, int status, int lesson_id ) { train_course info = new train_course(); info.Class_time = classTime; info.Create_time = createTime; info.End_choose_date = end_choose_time; info.End_date = end_date; info.Start_date = start_date; info.Status = status; info.Teacher = teacher; info.Place = place; info.Lesson_id = lesson_id; context.train_course.InsertOnSubmit(info); context.SubmitChanges(); }
/// <summary> /// 类型更改相关操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void New_Type(object sender, EventArgs e) { train_lesson_content_type newType = new train_lesson_content_type(); newType.TypeName = NewTypeName.Text; newType.ParentID = int.Parse(typeTreeView.SelectedNode.Name); kkdb.train_lesson_content_type.InsertOnSubmit(newType); kkdb.SubmitChanges(); typeTreeView.RefreshVirtualTree(); }
private void SaveInfoAndTab() { int lessonId = Convert.ToInt32(Request["Id"]); train_course info = context.train_course.Single(i => i.Id == lessonId); info.Class_time = Class_time.Text; info.End_choose_date = getEndChooseDate(); info.End_date = end_date.Date; info.Place = Place.Text; info.Teacher = Convert.ToInt32(Teacher.Value); info.Start_date = start_date.Date; context.SubmitChanges(); Response.Write("<script>window.parent.document.getElementById('mainsplitter_RefreshBtn').click();</script>"); }
public void insert_lesson_basicInfo( String number, String name, int time, int type, String description ) { train_lesson_basicInfo info = new train_lesson_basicInfo(); info.Name = name; info.Number = number; info.Time = time; info.Type = type; info.Description = description; context.train_lesson_basicInfo.InsertOnSubmit(info); context.SubmitChanges(); }
private void insert_Employee_Train_Record(int userId) { Employee_train_record r = new Employee_train_record(); r.Course_id = courseId; r.Employee_id = userId; r.Grade = 0; kkdb.Employee_train_record.InsertOnSubmit(r); kkdb.SubmitChanges(); }
//private void insert_Employee_Train_Record(int userId) //{ // Employee_train_record r = new Employee_train_record(); // r.Course_id = Convert.ToInt32(Request["Id"]); // r.Employee_id = userId; // r.Grade = 0; // kkdb.Employee_train_record.InsertOnSubmit(r); // kkdb.SubmitChanges(); // ASPxGridView1.DataBind(); // ASPxGridView2.DataBind(); //} private void insert_Employee_Train_Record(int userId) { if (!getUserByUserIdAndCouresId(userId, Convert.ToInt32(Request["Id"]))) { return; } Employee_train_record r = new Employee_train_record(); r.Course_id = Convert.ToInt32(Request["Id"]); r.Employee_id = userId; r.Remark = 3; //r.Grade = 0; kkdb.Employee_train_record.InsertOnSubmit(r); kkdb.SubmitChanges(); //ASPxGridView1.DataBind(); ASPxGridView2.DataBind(); }
//private void InitControlValuesForEdit(int id) //{ // train_course_view info = context.train_course_view.Single(i => i.Id == id); // if (info == null) return; // Name.Text = info.Name; // Name.Enabled = false; // Number.Text = info.Number; // Number.Enabled = false; // Time.Text = info.Time.ToString(); // Time.Enabled = false; // Description.Text = info.Description; // Description.Enabled = false; // Type.Value = info.Type; // Type.DataBind(); // Type.Enabled = false; // lessonType.DataBind(); // ContentType.Value = info.ContentTypeId; // ContentType.DataBind(); // ContentType.Enabled = false; // LinqContentType.DataBind(); // Place.Text = info.Place; // Class_time.Text = info.Class_time; // start_date.Date = info.Start_date; // end_date.Date = info.End_date; // EndChooseDate.Date = info.End_choose_date; // Teacher.Value = info.Teacher; // TeacherType.DataBind(); // Status.Value = info.Status; // Status.DataBind(); // Status.Enabled = false; // CourseStatus.DataBind(); // Create_time.Text = info.Create_time.ToString(); // Create_time.Enabled = false; //} protected void btnDelete_Click(object sender, EventArgs e) { var courseId = Convert.ToInt32(Request["Id"]); // 先判断类型下是否还有类型 var recordList = context.GetTable <Employee_train_record>(); if (recordList.Any(i => i.Course_id == courseId)) { showMessage("有学员选课,请先删除学员"); return; } else { train_course info = context.train_course.Single(i => i.Id == courseId); context.train_course.DeleteOnSubmit(info); context.SubmitChanges(); } // Response.Write("<script>window.parent.document.getElementById('RefreshBtn').click();</script>"); }
protected void ASPxButton1_Click(object sender, EventArgs e) { int course_id = Convert.ToInt32(HiddenField1.Value); int employee_id = Convert.ToInt32(Hidden2.Value); // Employee_train_record Info = db.Employee_train_record.Single(i => i.Course_id == (course_id) & i.Employee_id == (employee_id)); if (contains(course_id, employee_id).Count != 0) { Response.Write("您已选该课程!"); return; } Employee_train_record record = new Employee_train_record(); record.Employee_id = Convert.ToInt32(Hidden2.Value); record.Course_id = Convert.ToInt32(course_id); record.Grade = null; db1.Employee_train_record.InsertOnSubmit(record); db1.SubmitChanges(); Response.Write("<script language=javascript>window.location.href=document.URL;</script>"); }
protected void ASPxButton2_Click(object sender, EventArgs e) { string course_id = HiddenField1.Value; string employee_id = Hidden2.Value; train_courseDataContext db = new train_courseDataContext(); if (course_id != null) { List <Employee_train_record> list = contains(Convert.ToInt32(course_id), Convert.ToInt32(employee_id)); if (list == null || list.Count == 0) { Response.Write("未选择该课程!"); return; } Employee_train_record info = db.Employee_train_record.Single(i => i.Id == list[0].Id);; db.Employee_train_record.DeleteOnSubmit(info); db.SubmitChanges(); Response.Write("<script language=javascript>window.location.href=document.URL;</script>"); } else { Response.Write("请您进行选课!"); } }
public void saveLesson() { kkd.SubmitChanges(); }