public void Del_Type(object sender, EventArgs e)
{
if (typeTreeView.SelectedNode.Name == null)
{
Response.Write("请选择要删除的类型");
}
// return;
var typeID = int.Parse(typeTreeView.SelectedNode.Name);
// 先判断类型下是否还有类型
var typeList = kkdb.GetTable <train_lesson_content_type>();
var productList = kkdb.GetTable <train_lesson_basicInfo>();
if (typeList.Any(d => d.ParentID == int.Parse(typeTreeView.SelectedNode.Name)))
{
ErrorMessage.Text = "此类型已进行过分类，请先删除下属类型";
return;
}
else
{
// 判断该类型是否有产品
if (productList.Any(d => d.ContentTypeId == int.Parse(typeTreeView.SelectedNode.Name)))
{
ErrorMessage.Text = "此类型已经建立课程，请先删除课程";
return;
}
else
{
train_lesson_content_type newType = typeList.Single(d => d.ID == int.Parse(typeTreeView.SelectedNode.Name));
kkdb.train_lesson_content_type.DeleteOnSubmit(newType);
kkdb.SubmitChanges();
typeTreeView.RefreshVirtualTree();
Page_Load(sender, e);
}
}
}
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();
}
/// <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 InitControlValuesForEdit(int id)
{
train_course_view info = db1.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;
train_lesson_type typeinfo = db1.train_lesson_type.Single(i => i.id == info.Type);
if (typeinfo == null)
{
return;
}
Type.Value = typeinfo.lesson_type_name;
Type.Enabled = false;
train_lesson_content_type contentinfo = db1.train_lesson_content_type.Single(i => i.ID == info.ContentTypeId);
ContentType.Value = contentinfo.TypeName;
ContentType.Enabled = false;
Place.Text = info.Place;
Place.Enabled = false;
Class_time.Text = info.Class_time;
Class_time.Enabled = false;
start_date.Text = info.Start_date.ToString();
start_date.Enabled = false;
end_date.Text = info.End_date.ToString();
end_date.Enabled = false;
EndChooseDate.Text = info.End_choose_date.ToString();
EndChooseDate.Enabled = false;
employeename.Value = info.employeename;
employeename.Enabled = false;
StatusName.Value = info.StatusName;
StatusName.Enabled = false;
Create_time.Text = info.Create_time.ToString();
Create_time.Enabled = false;
}
// 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;
}
