//显示
public DataTable ExecTable(string sql)
{
DataSet set = new DataSet();
using (SqlConnection conn = new SqlConnection(con))
{
conn.Open();
using (SqlCommand comm = new SqlCommand(sql,conn))
{
SqlDataAdapter adapter = new SqlDataAdapter(comm);
adapter.Fill(set);
}
}
return set.Tables[0];
}
//增删改
public int ExecNounQuery(string sql)
{
int flag = 0;
using (SqlConnection conn = new SqlConnection(con))
{
conn.Open();
using (SqlCommand comm = new SqlCommand(sql, conn))
{
flag = comm.ExecuteNonQuery();
}
}
return flag;
}
DBHelper db = new DBHelper();
//显示
public DataTable GetShow()
{
string sql = "select * from ProductTB p join ProductType t on p.TID=t.TID";
return db.ExecTable(sql);
}
//添加
public int GetAdd(RoweModel m)
{
string sql = $"insert into ProductTB values('{m.PName}','{m.Price}','{m.State}','{m.TID}')";
return db.ExecNounQuery(sql);
}
RoweBLL bll = new RoweBLL();
//显示
[HttpGet]
[Route("api/GetShow")]
public IHttpActionResult GetShow(string name = "")
{
DataTable tb = bll.GetShow();
string json = JsonConvert.SerializeObject(tb);
List<RoweModel> list = JsonConvert.DeserializeObject<List<RoweModel>>(json);
var list1 = (from s in list select s).ToList();
if (!string.IsNullOrEmpty(name))
{
list1 = list1.Where(s => s.PName.Contains(name)).ToList();
}
return Json<List<RoweModel>>(list1);
}
//添加
[HttpPost]
public int GetAdd(RoweModel m)
{
int flag = bll.GetAdd(m);
return flag;
}
<script>
$(function () {
Show();
});
//显示
function Show() {
$.ajax({
url: "http://localhost:58473/api/GetShow",
type: "get",
dataType: "json",
}).done(function (da) {
ShowList(da);
});
}
function ShowList(da) {
//清空
$("#tb").empty();
$.each(da, function (index, item) {
var str = "<tr>"
+ "<td>" + item.ID + "</td>"
+ "<td>" + item.PName + "</td>"
+ "<td>" + item.TName + "</td>"
+ "<td>" + item.Price + "</td>"
+ "<td>" + item.State + "</td>"
+ "</tr>";
$("#tb").append(str);
})
}
</script>