private void btnAddResult_Click(object sender, EventArgs e)
{
if (this.txtResult.Text.Trim().Length == 0)
{
MessageBox.Show("请输入成绩！", "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
ResultInsert result = new ResultInsert(
this.Stu.StudentNo, Convert.ToInt32(this.cboSub.SelectedValue)
, Convert.ToInt32(this.txtResult.Text), this.picExamDate.Value
);
try
{
if (ResultBLL.AddResult(result))
{
MessageBox.Show("添加成功！", "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information);
ShowStudentResultSeach();
}
else
{
MessageBox.Show("添加失败！", "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("添加出现异常\n" + ex.Message, "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public async Task <IHttpActionResult> Post([FromBody] PostData p)
{
var r = new ResultInsert <int>();
var md = p.md;
var id = p.id;
using (db0 = new Bpple_DBEntities())
{
try
{
db0.Member.Add(md);
await db0.SaveChangesAsync();
r.state = 0;
r.id = md.id;
}
catch (Exception ex)
{
r.state = 999;
r.message = ex.Message;
}
return(Ok(r));
}
}
public static bool AddResult(ResultInsert result)
{
try
{
return(ResultDAL.AddResult(result));
}
catch (Exception)
{
throw;
}
}
//新增成绩
public static bool AddResult(ResultInsert result)
{
string sql = "insert Result Values(@StuNo,@SubNo,@Result,@ExamDate)";
SqlParameter [] paras =
{
new SqlParameter("@StuNo", result.StudentNo),
new SqlParameter("@SubNo", result.SubjectNo),
new SqlParameter("@Result", result.StudentResult),
new SqlParameter("@ExamDate", result.ExamDate)
};
try
{
return(SQLDBHelper.ExecuteNonQueryByDBHelper(sql, paras));
}
catch (Exception)
{
throw;
}
}
