public train_lesson_basicInfo findlessonByID(int ID)
{
var list = kkd.GetTable <train_lesson_basicInfo>();
train_lesson_basicInfo lessonSingle = list.Single(d => d.Id == ID);
return(lessonSingle);
}
public void delete_lesson_basicInfo(int id)
{
train_lesson_basicInfo info = context.train_lesson_basicInfo.Single(i => i.Id == id);
context.train_lesson_basicInfo.DeleteOnSubmit(info);
context.SubmitChanges();
}
private void InitControlValuesForEdit(int lessonId)
{
train_lesson_basicInfo info = bEdit.select_info(lessonId);
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();
btnSave.Enabled = true;
}
// 产品表的相关操作
public void New_Lesson(object sender, EventArgs e)
{
// 存储字段
train_lesson_basicInfo info = new train_lesson_basicInfo();
info.Name = Name.Text;
info.Number = Number.Text;
info.Description = Description.Text;
info.Time = Convert.ToInt32(Time.Text);
info.Type = Convert.ToInt32(Type.Value);
info.ContentTypeId = int.Parse(typeTreeView.SelectedNode.Name);
info.Status = Convert.ToInt32(Status.Value);
// kkdb.train_lesson_basicInfo.InsertOnSubmit(info);
// kkdb.SubmitChanges();
//判断该课程是否已经添加
var lessonInfo = kkdb.GetTable <train_lesson_basicInfo>();
var lessonNum = from t in lessonInfo
where t.Number == info.Number
select t.Number;
foreach (var i in lessonNum)
{
if (i.ToString() != "")
{
Response.Write("<script>alert('该课程已经添加，请勿重复添加！');</script>");
return;
}
}
kkdb.train_lesson_basicInfo.InsertOnSubmit(info);
kkdb.SubmitChanges();
}
public void update_lesson_basicInfo(
int _Id,
String number,
String name,
int time,
int type,
String description
)
{
train_lesson_basicInfo info = context.train_lesson_basicInfo.Single(i => i.Id == _Id);
info.Name = name;
info.Number = number;
info.Time = time;
info.Type = type;
info.Description = description;
context.SubmitChanges();
}
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 SaveInfoAndTab()
{
train_lesson_basicInfo info = new train_lesson_basicInfo();
info.Name = Name.Text.Trim();
info.Number = Number.Text.Trim();
info.Time = Convert.ToInt32(Time.Text.Trim());
info.Type = Convert.ToInt32(Type.Value);
info.Description = Description.Text.Trim();
int lessonId = Convert.ToInt32(Request["lessonId"]);
if (lessonId == -1)
{
bEdit.insert_lesson_basicInfo(info.Number, info.Name, info.Time, info.Type, info.Description);
}
else
{
bEdit.update_lesson_basicInfo(lessonId, info.Number, info.Name, info.Time, info.Type, info.Description);
}
}
