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