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();
}
private void init()
{
int id = Convert.ToInt32(Request["Id"]);
train_course info = context.train_course.Single(i => i.Id == id);
if (info.Remark == null)
{
ASPxLabel7.Visible = false;
Suggest.Visible = false;
}
else
{
ASPxLabel7.Visible = true;
Suggest.Visible = true;
Suggest.Text = info.Remark;
Suggest.Enabled = false;
}
dbDataContext db1 = new dbDataContext();
var departmentInfo = db1.GetTable <S_Department_Info>();
var departmentid = from t in departmentInfo
where t.DepartmentName == "培训部"
select t.id;
foreach (var i in departmentid)
{
// Response.Write(i);
HiddenField1.Value = i.ToString();
}
}
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('mainsplitter_RefreshBtn').click();</script>");
}
// Response.Write("<script>alert(window.parent.location);</script>");
// Response.Write()
//Response.Write(123);
//Course.test();
// Response.Write("<script language=javascript>window.location.href=document.URL;</script>");
// ASPxGridView1.DataBind();
}
public void update_course_status(int id, int status, String suggest = "")
{
train_course info = context.train_course.Single(i => i.Id == id);
info.Status = status;
info.Remark = suggest;
context.SubmitChanges();
}
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>");
}
//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>");
}
private void SaveInfoAndTab()
{
train_course info = new train_course();
//info.Course_name = Name.Text.Trim();
//info.Course_number = Number.Text.Trim();
//info.Learn_time = Convert.ToInt32(Time.Text.Trim());
//info.CourseType = Convert.ToInt32(Type.Value);
//info.Description = Description.Text.Trim();
info.Create_time = DateTime.Now;
info.Class_time = Class_time.Text;
info.Start_date = start_date.Date;
info.End_choose_date = getEndChooseDate();
info.End_date = end_date.Date;
info.Lesson_id = Convert.ToInt32(Request["Id"]);
info.Place = Place.Text;
info.Status = 1;
info.Teacher = Convert.ToInt32(Teacher.Value);
coursedb.insert_course(info.Create_time, info.Teacher, info.Class_time, info.Place, info.End_choose_date, info.Start_date, info.End_date, info.Status, info.Lesson_id);
}
public void update_train_course(
int id,
int teacher,
String classTime,
String place,
DateTime end_choose_time,
DateTime start_date,
DateTime end_date,
int status
)
{
train_course info = context.train_course.Single(i => i.Id == id);
info.Class_time = classTime;
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;
context.SubmitChanges();
}
