/// <summary>
/// 修改题库名称信息
/// </summary>
/// <param name="data"></param>
/// <param name="id">对应题库ID编号</param>
/// <returns></returns>
public HttpResponseMessage Update(dynamic data, int id)
{
Entity.test t = test.Value.SetData(data);
string sql = "update test_classify set t_name=@t_name,us_id=" + t.us_id + "," +
"head_id=" + t.head_id + ",type_a=" + t.type_a + ",type_b=" + t.type_b + ",type_c=" + t.type_c + "," +
"type_d=" + t.type_d + ",defen_a=" + t.defen_a + ",defen_b=" + t.defen_b + ",defen_c=" + t.defen_c + ",defen_d=" + t.defen_d + ",t_types=" + t.t_types + " where id=" + id;
SqlParameter[] sp =
{
new SqlParameter("@t_name", t.t_name)
};
int i = help.Count(sql, sp);
if (i > 0)
{
obj = new
{
code = 0,
msg = "修改成功"
};
}
else
{
obj = new
{
code = 1,
msg = "修改失败"
};
}
return(Zh.Tool.Json.GetJson(obj));
}
/// <summary>
/// 上传试题分类名称
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public HttpResponseMessage Add(dynamic data)
{
Entity.test t = test.Value.SetData(data);
string sql = "insert into test_classify(t_name,create_time,us_id,head_id,type_a,type_b,type_c,type_d,is_send,defen_a,defen_b," +
"defen_c,defen_d,t_types) values(" +
"@t_name," + t.create_time + "," + t.us_id + "," + t.head_id + "," + t.type_a + "," + t.type_b + "," + t.type_c + "," + t.type_d + "," +
"0," + t.defen_a + "," + t.defen_b + "," + t.defen_c + "," + t.defen_d + "," + t.t_types + " )";
SqlParameter[] sp =
{
new SqlParameter("@t_name", t.t_name)
};
int i = help.Count(sql, sp);
if (i > 0)
{
obj = new
{
code = 0,
msg = "上传成功"
};
}
else
{
obj = new
{
code = 1,
msg = "上传失败"
};
}
return(Zh.Tool.Json.GetJson(obj));
}
