public async Task <IActionResult> PutCoures([FromRoute] string id, [FromBody] Coures c)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
if (id != c.CourseId)
{
return(BadRequest());
}
_database.Entry(c).State = EntityState.Modified;
try
{
await _database.SaveChangesAsync();
}
catch (Exception)
{
if (!CouresExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PostCoures([FromBody] Coures c)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_database.Coures.Add(c);
try
{
await _database.SaveChangesAsync();
}
catch (Exception)
{
if (CouresExists(c.CourseId))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(CreatedAtAction("GetCoures", new { id = c.CourseId }, c));
}
private void Btn_Click(object sender, EventArgs e)
{
Button t = (Button)sender;
Coures c = new Coures();
BLL_Coures bc = new BLL_Coures();
bname.Text = t.Text;
bid.Text = t.ID;
}
public Coures getCouresByID(string couresID)
{
using (ISession session = getSession())
{
Coures c = (Coures)session.Get(typeof(Coures), couresID);
c.ProfessionID = c.Profession.Id;
c.FacultyID = c.Profession.Faculty.Id;
return(c);
}
}
public int total(Coures c)
{
string sql = "select count(*) from CourseDetails where C_ID=@id";
SqlParameter[] par =
{
new SqlParameter("@id", c.C_ID),
};
return(Convert.ToInt32(SQLHelper.ExecuteScalar(sql, System.Data.CommandType.Text, par)));
}
// 删除单词包
public int DeleteCoures(Coures cr)
{
string sql = "delete from Coures where C_ID=@a and C_NAME=@b";
SqlParameter[] par = new SqlParameter[] {
new SqlParameter("@a", cr.C_ID),
new SqlParameter("@b", cr.C_NAME)
};
return(SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, par));
}
//修改单词包
public int UpdateCoures(Coures cr)
{
string sql = @"update Coures set C_NAME=@b where C_ID=@a";
SqlParameter[] par =
{
new SqlParameter("@a", cr.C_ID),
new SqlParameter("@b", cr.C_NAME),
};
return(SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, par));
}
/// <summary>
/// 查询单词包id
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public object QueryCourseID(Coures c)
{
string sqlTest =
@"select C_ID from Coures where C_NAME=@name";
SqlParameter[] par =
{
new SqlParameter("@name", c.C_NAME)
};
return(SQLHelper.ExecuteScalar(sqlTest, CommandType.Text, par));
}
//添加单词包
public int AddCoures(Coures cr)
{
string sql = "insert into Coures values(@a,@b,@c)";
SqlParameter[] par =
{
new SqlParameter("@a", cr.C_NAME),
new SqlParameter("@b", cr.CCT_ID),
new SqlParameter("@c", cr.C_RELEASEDATE),
};
return(SQLHelper.ExecuteNonQuery(sql, System.Data.CommandType.Text, par));
}
/// <summary>
/// 添加单词包
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public int AddCourses(Coures c)
{
string sql = "insert into coures(C_NAME,CCT_ID,C_RELEASEDATE,C_VOCABULARY) values(@name,@type,@releasedate,@vocabulary)";
SqlParameter[] par = new SqlParameter[4]
{
new SqlParameter("@name", c.C_NAME),
new SqlParameter("@type", c.CCT_ID),
new SqlParameter("@releasedate", c.C_RELEASEDATE),
new SqlParameter("@vocabulary", c.C_vocabulary)
};
return(SQLHelper.ExecuteNonQuery(sql, CommandType.Text, par));
}
private void getCouresByID()
{
try
{
string CouresID = context.Request.Form.Get("CouresID");
CouresService cs = new CouresService();
Coures coures = cs.getCouresByID(CouresID);
String json = JsonConvert.SerializeObject(coures);
context.Response.Write(json);
}
catch (Exception e)
{
context.Response.Write("0");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Coures c = new Coures();
BLL_Coures bc = new BLL_Coures();
List <Coures> lc = bc.SeleteCoures();
for (int i = 0; i < bc.SeleteCoures().Count; i++)
{
Button btn = new Button();
btn.Width = 100;
btn.Height = 100;
btn.ID = Convert.ToString(lc[i].C_ID);
btn.CssClass = "book btn btn-info";
btn.Text = lc[i].C_NAME;
btn.Click += Btn_Click;
panel.Controls.Add(btn);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Coures c = new Coures();
if (textBox3.Text == null)
{
MessageBox.Show("单词包名称不能为空");
return;
}
else if (textBox4.Text == null)
{
MessageBox.Show("单词本英语个数不能为空");
return;
}
else
{
CourseContentType cct = new CourseContentType();
cct.CCT_NAME = comboBox1.Text.Trim();
CourseContentType_Bll cct_b = new CourseContentType_Bll();
int id = Convert.ToInt32(cct_b.QueryCourseContTypeID(cct));
c.C_NAME = textBox3.Text.Trim();
c.CCT_ID = id;
c.C_vocabulary = Convert.ToInt32(textBox4.Text.ToString());
c.C_RELEASEDATE = DateTime.Now.ToString();
}
Coures_Bll cb = new Coures_Bll();
int i = cb.AddCourses(c);
if (i > 0)
{
MessageBox.Show("添加成功！");
}
else
{
MessageBox.Show("添加失败！");
}
}
catch
{
MessageBox.Show("出现异常");
Close();
}
}
/// <summary>
/// 显示所有单词包
/// </summary>
/// <returns></returns>
public List <Coures> QueryCouresAll()
{
string sql = "select * from coures";
List <Coures> list = new List <Coures>();
SqlDataReader msdr = SQLHelper.ExecuteReader(sql, CommandType.Text, null);
if (msdr.HasRows)
{
while (msdr.Read())
{
Coures c = new Coures();
c.CCT_ID = int.Parse(msdr["C_ID"].ToString());
c.C_NAME = msdr["C_NAME"].ToString();
c.C_vocabulary = int.Parse(msdr["C_vocabulary"].ToString());
list.Add(c);
}
}
msdr.Close();
return(list);
}
private void saveCoures()
{
try
{
string professionID = context.Request.Form.Get("profession");
DepartmentService ds = new DepartmentService();
Profession profession = ds.getProfessionByID(professionID);
if (profession != null)
{
Coures c = new Coures();
setValue(c, context);
c.Profession = profession;
ds.save(c);
context.Response.Write("1");
}
}
catch (Exception e) {
context.Response.Write("0");
}
}
/// <summary>
/// 根据单词包id获取指定单词包
/// </summary>
/// <param name="cID"></param>
/// <returns></returns>
public Coures GetCourse(int cID)
{
string sql = "select * from Coures where C_ID=@C_ID";
SqlParameter[] p =
{
new SqlParameter("@C_ID", cID)
};
SqlDataReader sdr = SQLHelper.ExecuteReader(sql, CommandType.Text, p);
Coures course = new Coures();
while (sdr.Read())
{
course.C_ID = Convert.ToInt32(sdr["C_ID"]);
course.C_NAME = sdr["C_NAME"].ToString();
course.CCT_ID = Convert.ToInt32(sdr["CCT_ID"]);
course.C_RELEASEDATE = sdr["C_RELEASEDATE"].ToString();
course.C_vocabulary = Convert.ToInt32(sdr["C_vocabulary"]);
}
return(course);
}
private void saveCoures()
{
try
{
string ProfessionID = context.Request.Form.Get("Profession");
string FacultyID = context.Request.Form.Get("Faculty");
DepartmentService ds = new DepartmentService();
Profession profession = ds.getProfessionByID(ProfessionID);
Faculty faculty = ds.getFacultyByID(FacultyID);
if (profession != null && faculty != null)
{
ISet <Coures> couresSet = new HashedSet <Coures>();
string[] couresArr = context.Request.Form.GetValues("Coures");
CouresService cs = new CouresService();
foreach (string c in couresArr)
{
Coures coures = cs.getCouresByID(c);
if (coures != null)
{
couresSet.Add(coures);
}
}
ExamPlan p = new ExamPlan();
setValue(p, context);
p.Profession = profession;
p.Faculty = faculty;
p.CouresSet = couresSet;
PlanService ps = new PlanService();
ps.save(p);
context.Response.Write("1");
}
}
catch (Exception e)
{
context.Response.Write("0");
}
}
//查询所有单词包
public List <Coures> SeleteCoures()
{
string sql = "select * from Coures";
List <Coures> lc = new List <Coures>();
SqlDataReader sdr = SQLHelper.ExecuteReader(sql, System.Data.CommandType.Text, null);
if (sdr.HasRows)
{
while (sdr.Read())
{
Coures cr = new Coures();
cr.C_ID = Convert.ToInt32(sdr["C_ID"].ToString());
cr.C_NAME = sdr["C_NAME"].ToString();
cr.CCT_ID = Convert.ToInt32(sdr["CCT_ID"].ToString());
cr.C_RELEASEDATE = Convert.ToDateTime(sdr["C_RELEASEDATE"].ToString());
cr.C_VOCABULARY = Convert.ToDouble(sdr["C_VOCABULARY"].ToString());
lc.Add(cr);
}
}
sdr.Close();
return(lc);
}
protected void del_Click(object sender, EventArgs e)
{
try
{
Coures cs = new Coures();
cs.C_ID = Convert.ToInt32(wbid.Text);
cs.C_NAME = wbname.Text;
BLL_Coures del = new BLL_Coures();
del.DeleteCoures(cs);
if (del.DeleteCoures(cs) > 0)
{
Response.Write(@"<script>alert('删除成功！');location.reload();</script>");
}
else
{
Response.Write(@"<script>alert('删除失败！');history.go(-1);</script>");
}
}
catch
{
Response.Write(@"<script>alert('删除失败！'); history.go(-1);</script>");
}
}
public List <Coures> select(int id)
{
string sql = "select * from Coures where C_ID=@ID";
Coures cr = new Coures();
List <Coures> lc = new List <Coures>();
SqlParameter[] par =
{
new SqlParameter("@ID", id),
};
SqlDataReader sdr = SQLHelper.ExecuteReader(sql, System.Data.CommandType.Text, par);
while (sdr.Read())
{
cr.C_ID = Convert.ToInt32(sdr["C_ID"].ToString());
cr.C_NAME = sdr["C_NAME"].ToString();
cr.CCT_ID = Convert.ToInt32(sdr["CCT_ID"].ToString());
cr.C_RELEASEDATE = Convert.ToDateTime(sdr["C_RELEASEDATE"].ToString());
cr.C_VOCABULARY = Convert.ToDouble(sdr["C_VOCABULARY"].ToString());
lc.Add(cr);
}
sdr.Close();
return(lc);
}
protected void save_Click(object sender, EventArgs e)
{
try
{
Coures cs = new Coures();
cs.C_NAME = wbname.Text;
cs.CCT_ID = wbtype.SelectedIndex;
cs.C_RELEASEDATE = DateTime.Now;
BLL_Coures save = new BLL_Coures();
save.AddCoures(cs);
if (save.AddCoures(cs) > 0)
{
Response.Write(@"<script>alert('保存成功！'); </script>");
}
else
{
Response.Write(@"<script>alert('保存失败！');history.go(-1);</script>");
}
}
catch
{
Response.Write(@"<script>alert('保存失败！'); history.go(-1);</script>");
}
}
//种子方法
protected override void Seed(CodeFirstDamo.CodeFirstModels.CourseContext context)
{
context.Database.ExecuteSqlCommand("delete Coures");
context.Database.ExecuteSqlCommand("delete departents");
//初始化学院数据
var d1 = new Departent()
{
Name = "电子信息工程",
SortCode = "001",
Description = "第一大学院"
};
var d2 = new Departent()
{
Name = "电子信息工程",
SortCode = "002",
Description = "第二大学院"
};
var d3 = new Departent()
{
Name = "电子信息工程",
SortCode = "003",
Description = "第三大学院"
};
var d4 = new Departent()
{
Name = "电子信息工程",
SortCode = "004",
Description = "第四大学院"
};
context.Departments.Add(d1);
context.Departments.Add(d2);
context.Departments.Add(d3);
context.Departments.Add(d4);
context.SaveChanges();
var c1 = new Coures()
{
Title = "C#程序设计",
Credit = 7,
Department = context.Departments.SingleOrDefault(x => x.Name == "电子信息工程学院")
};
var c2 = new Coures()
{
Title = "Min开发与实战",
Credit = 7,
Department = context.Departments.SingleOrDefault(x => x.Name == "电子信息工程学院")
};
var c3 = new Coures()
{
Title = "web应用开发",
Credit = 7,
Department = context.Departments.SingleOrDefault(x => x.Name == "电子信息工程学院")
};
var c4 = new Coures()
{
Title = "工业制图",
Credit = 4,
Department = context.Departments.SingleOrDefault(x => x.Name == "机电工程学院")
};
var c5 = new Coures()
{
Title = "发动机检测",
Credit = 6,
Department = context.Departments.SingleOrDefault(x => x.Name == "汽车工程学院")
};
var c6 = new Coures()
{
Title = "网络音效",
Credit = 6,
Department = context.Departments.SingleOrDefault(x => x.Name == "财经与物流学院")
};
context.Coures.Add(c1);
context.Coures.Add(c2);
context.Coures.Add(c3);
context.Coures.Add(c4);
context.Coures.Add(c5);
context.Coures.Add(c6);
context.SaveChanges();
var s1 = new Student()
{
StudentName = "肖文斌",
Sex = true,
Class = "17软件技术一班",
phone = "18877213447"
};
var s2 = new Student()
{
StudentName = "黄武建",
Sex = true,
Class = "17软件技术一班",
phone = "18877213447"
};
var s3 = new Student()
{
StudentName = "黄学明",
Sex = true,
Class = "17软件技术一班",
phone = "18877213447"
};
var s4 = new Student()
{
StudentName = "施扬恩",
Sex = true,
Class = "17软件技术一班",
phone = "18877213447"
};
context.Student.Add(s1);
context.Student.Add(s2);
context.Student.Add(s3);
context.Student.Add(s4);
context.SaveChanges();
}
public void update(Coures coures)
{
Session.Update(coures);
Session.Flush();
}
public int DeleteCoures(Coures c)
{
return(dc.DeleteCoures(c));
}
public int UpdateCoures(Coures c)
{
return(dc.UpdateCoures(c));
}
public int AddCoures(Coures c)
{
return(dc.AddCoures(c));
}
/// <summary>
/// 根据单词包名字查询id
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public object QueryCouresID(Coures c)
{
return(DALCourses.QueryCourseID(c));
}
/// <summary>
/// 增加单词包
/// </summary>
/// <param name="l"></param>
/// <returns></returns>
public int AddCourses(Coures l)
{
return(DALCourses.AddCourses(l));
}
public int total(Coures c)
{
return(dd.total(c));
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (comboBox1.Text == null)
{
MessageBox.Show("单词包类型不为空");
return;
}
if (textBox2.Text == null)
{
MessageBox.Show("单词名称不可为空");
return;
}
if (textBox3.Text == null)
{
MessageBox.Show("单词音标不可为空");
return;
}
if (textBox4.Text == null)
{
MessageBox.Show("单词释义不可为空");
return;
}
if (textBox5.Text == null)
{
MessageBox.Show("英文例句不可为空");
return;
}
if (textBox6.Text == null)
{
MessageBox.Show("中文例句不可为空");
return;
}
if (pictureBox1.Image == null)
{
MessageBox.Show("请选择单词正确图片");
return;
}
if (pictureBox2.Image == null)
{
MessageBox.Show("请选择单词错误图片1");
return;
}
if (pictureBox3.Image == null)
{
MessageBox.Show("请选择单词错误图片2");
return;
}
if (pictureBox4.Image == null)
{
MessageBox.Show("请选择单词错误图片3");
return;
}
else
{
Coures c = new Coures();
c.C_NAME = comboBox1.Text.Trim();
Coures_Bll cb = new Coures_Bll();
int id = Convert.ToInt32(cb.QueryCouresID(c));
cd.C_ID = id;
cd.CD_NAME = textBox2.Text.Trim();
cd.CD_YINBIAO = textBox3.Text.Trim();
cd.CD_Mean = textBox4.Text.Trim();
cd.CD_SENEng = textBox5.Text.Trim();
cd.CD_SENChi = textBox6.Text.Trim();
cd.CD_VIDEO = textBox7.Text.Trim();
}
CourseDetail_Bll cdb = new CourseDetail_Bll();
int i = cdb.AddCoursesDetails(cd);
if (i > 0)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
}
catch
{
MessageBox.Show("添加异常");
}
}
