public void Edit_Type(object sender, EventArgs e)
{
var typeList = kkdb.GetTable <train_lesson_content_type>();
train_lesson_content_type editType = typeList.Single(d => d.ID == int.Parse(typeTreeView.SelectedNode.Name));
editType.TypeName = EditTypeName.Text;
kkdb.SubmitChanges();
typeTreeView.RefreshVirtualTree();
// 还没有对产品表里进行过更改 后期加上
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//string course_id = "";
login_name = Session["login_user_name"].ToString();
// login_name = "admin";
ASPxGridView1.KeyFieldName = "Course_id";
ASPxGridView1.SettingsBehavior.ProcessSelectionChangedOnServer = true;
//查询用户id
var EmployeeInfo = db1.GetTable <S_User_Info>();
var employee_id = from t in EmployeeInfo
where t.LoginName == login_name
select t.id;
foreach (var i in employee_id)
{
Hidden2.Value = i.ToString();
}
id = Convert.ToInt32(Hidden2.Value);
// var GradeInfo = db1.GetTable<train_personal_record_view>();
int year = DateTime.Now.Year;// 取当前时间年
int j = 0;
for (int i = year; i > year - 20; i--)
{
ASPxComboBox1.Items.Add((year - j).ToString());
j++;
}
ASPxComboBox2.Items.Add("上半年");
ASPxComboBox2.Items.Add("下半年");
}
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
login_name = Session["login_user_name"].ToString();
// login_name = "admin";
ASPxGridView2.KeyFieldName = "Course_id";
string date = DateTime.Now.ToString();
Hidden.Value = date;
//string login_name = Session["login_user_name"].ToString();
// Hidden2.Value = Session["Employee_Id"].ToString();
//查询用户id
var EmployeeInfo = db1.GetTable <S_User_Info>();
var employee_id = from t in EmployeeInfo
where t.LoginName == login_name
select t.id;
foreach (var i in employee_id)
{
//Response.Write(i);
Hidden2.Value = i.ToString();
}
var recordsInfo = db1.GetTable <Employee_train_record>();
var courseInfo = db1.GetTable <train_course_view>();
var selectedInfo = from t in courseInfo
where (
from t1 in recordsInfo
where t1.Employee_id == Convert.ToInt32(Hidden2.Value)
select t1.Course_id
).Contains(t.Lesson_id)
select t.Lesson_id;
foreach (var i in selectedInfo)
{
// Response.Write(i.ToString());
//LinqDataSource1.Where += " and Lesson_id != (16)";
//Hidden3.Value = i.ToString();
}
//LinqDataSource1.Where += " and Lesson_id in selectedInfo";
}
// 2. 建立相应的方法
// 3. 建立treeview
public void newCreateTree(TreeViewVirtualModeCreateChildrenEventArgs e, int root_type_ID)
{
List <TreeViewVirtualNode> children = new List <TreeViewVirtualNode>();
var lesson_content_type_table = kkd.GetTable <train_lesson_content_type>();
if (string.IsNullOrEmpty(e.NodeName))
{
// 查询节点信息
train_lesson_content_type root_type = lesson_content_type_table.Single(d => d.ID == root_type_ID);
// 建立节点
TreeViewVirtualNode childNode = new TreeViewVirtualNode(root_type.ID.ToString(), root_type.TypeName);
childNode.IsLeaf = lesson_content_type_table.Any(d => d.ParentID == root_type.ID) ? false : true;
children.Add(childNode);
}
else
{
this.tree_view_child(children, int.Parse(e.NodeName), lesson_content_type_table);
}
e.Children = children;
}
// 产品表的相关操作
public void New_By_Department(object sender, EventArgs e)
{
int departmentId = Convert.ToInt32(Department.Value);
List <S_User_Info> userList = new List <S_User_Info>();
var UserArray = kkdb.GetTable <S_User_Info>();
var users = from t in UserArray
where t.DepartmentId == departmentId
select t;
List <int> allUsrId = getIds(allUser);
if (users != null)
{
foreach (var t in users)
{
if (!allUsrId.Contains(t.id))
{
insert_Employee_Train_Record(t.id);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// int lessonid = Convert.ToInt32(Request["Lesson_id"]);
// Response.Write(lessonid);
int courseid = Convert.ToInt32(Request.QueryString["Course_id"].ToString());
hidden.Value = courseid.ToString();
InitControlValuesForEdit(courseid);
if (HttpContext.Current.Request.UrlReferrer.PathAndQuery.ToString() == "/train/train_course_select.aspx")
{
ASPxPageControl1.Visible = false;
}
else
{
ASPxPageControl1.Visible = true;
var EmployeeInfo = db1.GetTable <train_record_view>();
//统计学员总人数
var allInfo1 = from t in EmployeeInfo
where t.Course_id == Convert.ToInt32(courseid)
select t;
int count1 = 0;
foreach (var i in allInfo1)
{
count1++;
}
Students_num.Text = count1.ToString();
//统计成绩合格的总人数
var allInfo2 = from t in allInfo1
where t.Grade >= 60
select t;
int count2 = 0;
foreach (var i in allInfo2)
{
count2++;
}
pass_num.Text = count2.ToString();
//统计成绩不合格的总人数
var allInfo3 = from t in allInfo1
where t.Grade >= 0 & t.Grade < 60
select t;
int count3 = 0;
foreach (var i in allInfo3)
{
count3++;
}
notpass_num.Text = count3.ToString();
}
}
//public void New_By_Department(object sender, EventArgs e)
//{
// int departmentId = Convert.ToInt32(Department.Value);
// List<S_User_Info> userList = new List<S_User_Info>();
// var UserArray = kkdb.GetTable<S_User_Info>();
// var users = from t in UserArray
// where t.DepartmentId == departmentId
// select t;
// List<Train_Employee_User_view> allUser = findAllUser(Convert.ToInt32(Request["Id"]));
// List<int> allUsrId = getIds(allUser);
// if (users != null)
// {
// foreach (var t in users)
// {
// if (!allUsrId.Contains(t.id))
// {
// insert_Employee_Train_Record(t.id);
// }
// }
// }
// ASPxGridView2.DataBind();
//}
//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();
//}
// 查找符合类型的所有产品
public List <Train_Employee_User_view> findAllUser(int courseId)
{
List <Train_Employee_User_view> userList = new List <Train_Employee_User_view>();
var UserArray = kkdb.GetTable <Train_Employee_User_view>();
var users = from t in UserArray
where t.Course_id == courseId
select t;
foreach (var i in users)
{
userList.Add(i);
}
return(userList);
}
private List <Employee_train_record> contains(int courseId, int employeeId)
{
train_courseDataContext kkdb = new train_courseDataContext();
List <Employee_train_record> userList = new List <Employee_train_record>();
var UserArray = kkdb.GetTable <Employee_train_record>();
var users = from t in UserArray
where t.Course_id == courseId
where t.Employee_id == employeeId
select t;
foreach (var i in users)
{
userList.Add(i);
}
return(userList);
}
protected bool isGradeRight(int id)
{
//List<Employee_train_record> res = new List<Employee_train_record>();
train_courseDataContext kkdb = new train_courseDataContext();
var UserArray = kkdb.GetTable <Employee_train_record>();
var users = from t in UserArray
where t.Course_id == id
select t;
foreach (var i in users)
{
if (i.Grade == null && i.Remark == null)
{
return(false);
}
}
return(true);
}
//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>");
}