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); } }