MVC增删改查（API一个项目文本框查询）
/////Api页面增删改查
day19_BookManagerEntities book = new day19_BookManagerEntities();
// GET: api/BookApi
public IEnumerable<Book> Get()
{
return book.Book;
}
// GET: api/BookApi/5
public List<Book> Get(string id)
{
return book.Book.Where(T => T.Book_Name.Contains(id)).ToList();
}
// POST: api/BookApi
public void Post([FromBody]Book value)
{
book.Book.Add(value);
book.SaveChanges();
}
// PUT: api/BookApi/5
public void Put(int id, [FromBody] Book value)
{
var b = book.Book.Where(T => T.Book_ID ==id).FirstOrDefault();
if (b != null)
{
b.Book_ID = value.Book_ID;
b.Book_Name = value.Book_Name;
b.Book_Num = value.Book_Num;
b.Book_Price = value.Book_Price;
}
book.SaveChanges();
}
// DELETE: api/BookApi/5
public HttpResponseMessage Delete(int id)
{
var b = book.Book.Where(T => T.Book_ID == id).FirstOrDefault();
try
{
if (b != null)
{
book.Book.Remove(b);
book.SaveChanges();
return new HttpResponseMessage() { StatusCode = HttpStatusCode.OK };
}
else
{
return new HttpResponseMessage() { StatusCode = HttpStatusCode.NoContent };
}
}
catch (Exception)
{
return new HttpResponseMessage() { StatusCode = HttpStatusCode.InternalServerError };
}
}
//////控制器方法
public ActionResult Client_Get(int pageIndex=1)
{
Uri url = new Uri("http://localhost:56860/");
HttpClient client = new HttpClient();
client.BaseAddress = url;
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage message = client.GetAsync("api/BookApi").Result;
List<Book> list = new List<Book>();
if (message.IsSuccessStatusCode)
{
list = message.Content.ReadAsAsync<List<Book>>().Result;
}
client.Dispose();
return View(list.ToPagedList(pageIndex,2));
}
public ActionResult Client_Post()
{
return View();
}
[HttpPost]
public ActionResult Client_Post(Book b)
{
Uri url = new Uri("http://localhost:56860/");
HttpClient client = new HttpClient();
client.BaseAddress = url;
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpContent content = new StringContent("{Book_Name:'" + b.Book_Name + "',Book_Num:'" + b.Book_Num + "',Book_Price:'" + b.Book_Price + "'}");
content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json");
HttpResponseMessage message = client.PostAsync("api/BookApi",content).Result;
if (message.IsSuccessStatusCode)
{
client.Dispose();
return Content("<script>alert('提交成功');location.href='/Home/Client_Get'</script>");
}
else
{
return Content("<script>alert('提交失败')</script>");
}
}
public ActionResult Client_Put(int id)
{
day19_BookManagerEntities book = new day19_BookManagerEntities();
var b = book.Book.Where(T => T.Book_ID == id).FirstOrDefault();
var data = new Book()
{
Book_Name = b.Book_Name,
Book_Num = b.Book_Num,
Book_Price = b.Book_Price,
Book_ID =b.Book_ID
};
return View(data);
}
[HttpPost]
public ActionResult Client_put(Book b)
{
Uri url = new Uri("http://localhost:56860/");
HttpClient client = new HttpClient();
client.BaseAddress = url;
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpContent content = new StringContent("{ Book_ID:" +b.Book_ID+",Book_Name:'" + b.Book_Name + "',Book_Num:'" + b.Book_Num + "',Book_Price:'" + b.Book_Price + "'}");
content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json");
HttpResponseMessage message = client.PutAsync("api/BookApi/"+b.Book_ID, content).Result;
if (message.IsSuccessStatusCode)
{
client.Dispose();
return Content("<script>alert('提交成功');location.href='/Home/Client_Get'</script>");
}
else
{
return Content("<script>alert('提交失败')</script>");
}
}
public ActionResult Client_Delect(int id)
{
Uri url = new Uri("http://localhost:56860/");
HttpClient client = new HttpClient();
client.BaseAddress = url;
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage message = client.DeleteAsync("api/BookApi/"+id).Result;
if (message.IsSuccessStatusCode)
{
client.Dispose();
return Content("<script>alert('删除成功');location.href='/Home/Client_Get'</script>");
}
else
{
return Content("<script>alert('删除失败')</script>");
}
}
public ActionResult Client_Select(string name,int pageIndex=1)
{
Uri url = new Uri("http://localhost:56860/");
HttpClient client = new HttpClient();
client.BaseAddress = url;
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage message = client.GetAsync("/api/BookApi/"+name).Result;
List<Book> list = new List<Book>();
if (message.IsSuccessStatusCode)
{
list = message.Content.ReadAsAsync<List<Book>>().Result;
}
client.Dispose();
return View("Client_Get",list.ToPagedList(pageIndex,2));
}
<td><input type="checkbox" id="CheckAll" />全选</td>
<td><input type="checkbox" name="CheckChild" value="@item.Gid "/></td>
//全选
$("#CheckAll").click(function(){
$("input[name='CheckChild']").prop("checked",this.checked);
})
//批量删除
function DelAll() {
var id = "";
$("input[name='CheckChild']:checked").each(function () {
id += $(this).val() + ",";
})
id = id.substring(0, id.length - 1);
if (id.length > 0) {
Del(id);
}
else{
alert("至少选择一提条起数据");
}
}
