using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using SqlSugar;
using Models;
using WebApplication.Dao;
using System.Text;
namespace WebApplication.Controllers
{
/// <summary>
/// 分类接口
/// </summary>
public class classificationController : ApiController
{
/// <summary>
/// 获取分类列表(条件查询，分页) http://192.168.2.177:1222/api/classification/GetclassificationListPage?pageIndex=1&pageSize=10&status=2&title=
/// </summary>
/// <param name="pageIndex">分页索引</param>
/// <param name="pageSize">分页大小</param>
/// <param name="status">状态：0:下线 1：上线 -1：失效,默认传入2获取所有数据</param>
/// <param name="title"></param>
/// <returns></returns>
[Route("api/classification/GetclassificationListPage")]
[HttpGet]
public string GetclassificationListPage(int pageIndex, int pageSize, int status, string title)
{
try
{
using (var db = SugarDao.GetInstance())
{
var qable = db.Queryable<tb_classification>();
var dataCountTable = db.Queryable<tb_classification>();
if (status != 2)
{
qable = qable.Where(i => i.status == status);
dataCountTable = dataCountTable.Where(i => i.status == status);
}
if (status == 2)
{
dataCountTable = dataCountTable.Where(i => i.status != status);
}
if (!string.IsNullOrEmpty(title))
{
qable = qable.Where(i => i.title.Contains(title));
dataCountTable = dataCountTable.Where(i => i.title.Contains(title));
}
var data = qable.OrderBy(it => it.createtime, OrderByType.Asc).ToPageList(pageIndex, pageSize);
var dataCount = dataCountTable.ToList().Count;
if (data.Count > 0)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "获取数据成功", Data = data, Count = dataCount });
}
else
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "获取数据失败", Data = data, Count = dataCount });
}
}
}
catch (Exception ex)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "获取数据失败,原因为:" + ex.Message });
}
}
/// <summary>
/// 获取分类数据，不分页 http://192.168.2.177:1222/api/classification/GetclassificationList?status=2&title=
/// </summary>
/// <param name="status"></param>
/// <param name="title"></param>
/// <returns></returns>
[Route("api/classification/GetclassificationList")]
[HttpGet]
public string GetclassificationList(int status, string title)
{
try
{
using (var db = SugarDao.GetInstance())
{
var qable = db.Queryable<tb_classification>();
if (status != 2)
{
qable = qable.Where(i => i.status == status);
}
if (!string.IsNullOrEmpty(title))
{
qable = qable.Where(i => i.title.Contains(title));
}
var data = qable.OrderBy(it => it.createtime, OrderByType.Asc).ToList();
var dataCount = db.Queryable<tb_classification>().Where(it => it.status != status).ToList().Count;
if (data.Count > 0)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "获取数据成功", Data = data, Count = dataCount });
}
else
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "获取数据失败", Data = data, Count = dataCount });
}
}
}
catch (Exception ex)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "获取数据失败,原因为:" + ex.Message });
}
}
/// <summary>
/// 根据id得到对象 http://192.168.2.177:1222/api/classification/GetclassificationModel?id=1
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
[Route("api/classification/GetclassificationModel")]
[HttpGet, HttpPost]
public string GetclassificationModel(int id)
{
try
{
using (var db = SugarDao.GetInstance())
{
if (id != 0)
{
var classification = db.Queryable<tb_classification>().Single(it => it.id == id);
if (classification != null)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "获取数据成功", Data = classification });
}
else
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "获取数据失败", Data = classification });
}
}
else
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "获取数据失败,无法找到id为:" + id + "的数据", });
}
}
}
catch (Exception ex)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "获取数据失败,原因为:" + ex.Message });
}
}
/// <summary>
/// 新增分类 http://192.168.2.177:1222/api/classification/Postclassification
/// </summary>
/// <param name="classification"></param>
[Route("api/classification/Postclassification")]
[HttpPost]
public string Postclassification(tb_classification classification)
{
try
{
classification.createtime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
using (var db = SugarDao.GetInstance())
{
object result = db.Insert<tb_classification>(classification);
if (Convert.ToInt64(result) > 0)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "添加成功" });
}
else
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "添加失败" });
}
}
}
catch (Exception ex)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "添加失败,原因为:" + ex.Message });
}
}
/// <summary>
/// 修改分类
/// </summary>
/// <param name="id"></param>
/// <param name="value"></param>
[Route("api/classification/Putclassification")]
[HttpPost]
public string Putclassification(tb_classification classification)
{
try
{
classification.createtime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
using (var db = SugarDao.GetInstance())
{
bool result = db.Update<tb_classification>(classification, it => it.id == classification.id);
if (result == true)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "更新成功" });
}
else
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "更新失败" });
}
}
}
catch (Exception ex)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "更新失败,原因为:" + ex.Message });
}
}
/// <summary>
/// 删除 http://192.168.2.177:1222/api/classification/Deleteclassification?ids=4,5
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
[Route("api/classification/Deleteclassification")]
[HttpGet, HttpPost]
public string Deleteclassification(string ids)
{
try
{
string[] input = ids.Split(',');
int[] output = Array.ConvertAll<string, int>(input, delegate (string s) { return int.Parse(s); });
using (var db = SugarDao.GetInstance())
{
bool result = db.Delete<tb_classification, int>(output);
if (result == true)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "删除成功" });
}
else
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "删除失败" });
}
}
}
catch (Exception ex)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "删除失败,原因为:" + ex.Message });
}
}
/// <summary>
/// 更新状态 http://192.168.2.177:1222/api/classification/UpdateStatus?status=0&ids=2,7
/// </summary>
/// <param name="status">状态：0:下线 1：上线 -1：失效 </param>
/// <param name="ids"></param>
/// <returns></returns>
[Route("api/classification/UpdateStatus")]
[HttpGet]
public string UpdateStatus(int status, string ids)
{
try
{
string[] input = ids.Split(',');
int[] output = Array.ConvertAll<string, int>(input, delegate (string s) { return int.Parse(s); });
using (var db = SugarDao.GetInstance())
{
bool result = db.Update<tb_classification, int>(new { status = status }, output);
if (result == true)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "状态更改成功" });
}
else
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "状态更改失败" });
}
}
}
catch (Exception ex)
{
return SqlSugar.JsonConverter.Serialize(new { Result = 0, Msg = "状态更改失败,原因为:" + ex.Message });
}
}
string result = string.Empty;
string ChildResult = string.Empty;
string temp = string.Empty;
/// <summary>
/// 分类树形结构 http://192.168.2.177:1222/api/classification/GetclassificationTree
/// </summary>
/// <returns></returns>
[Route("api/classification/GetclassificationTree")]
[HttpGet]
public string GetclassificationTree()
{
WebApplication.Controllers.TreeMethod tm = new TreeMethod();
// 找到所有的父节点
List<TreeEntity> treeList1 = tm.findAllParents();
if (treeList1 != null)
{
for (int i = 0; i < treeList1.Count; i++)
{
TreeEntity tree = treeList1[i];
// 拼接父节点
//result += "|--" + tree.name;
result += "{id:"+tree.id+ ",pId:"+tree.pid+",name:'"+tree.name+"'},";
// 绑定孩子
ChildResult = tm.BindChildByParent(tree.id, "").TrimEnd(',');
temp = result + ChildResult;
}
}
else
{
temp += "没有数据！";
}
result = "["+ temp.TrimEnd(',')+ "]";
return SqlSugar.JsonConverter.Serialize(new { Result = 1, Msg = "获取数据成功",Data= temp });
}
}
public class TreeEntity
{
public string id { get; set; }
public string name { get; set; }
public string pid { get; set; }
}
internal class TreeMethod
{
/// <summary>
/// 找到所有的父节点
/// </summary>
/// <returns></returns>
public List<TreeEntity> findAllParents()
{
List<TreeEntity> treeList = new List<TreeEntity>();
using (var db = SugarDao.GetInstance())
{
var list = db.Queryable<tb_classification>().Where(it => it.pid == 0 && it.status==1).ToList();
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
TreeEntity myTree = new TreeEntity();
myTree.id = list[i].id.ToString();
myTree.name = list[i].title;
myTree.pid = list[i].pid.ToString();
treeList.Add(myTree);
}
}
}
return treeList;
}
/// <summary>
/// 根据父节点找到所有的子节点
/// </summary>
/// <param name="pid"></param>
/// <returns></returns>
public List<TreeEntity> findChildByPid(string pid)
{
int p_id = Convert.ToInt32(pid);
List<TreeEntity> treeList = new List<TreeEntity>();
using (var db = SugarDao.GetInstance())
{
var list = db.Queryable<tb_classification>().Where(it => it.pid == p_id&&it.status==1).ToList();
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
TreeEntity myTree = new TreeEntity();
myTree.id = list[i].id.ToString();
myTree.name = list[i].title;
myTree.pid = list[i].pid.ToString();
treeList.Add(myTree);
}
}
}
return treeList;
}
/// <summary>
/// 查看是否存在子节点
/// </summary>
/// <param name="pid"></param>
/// <returns></returns>
public bool HasChild(string pid)
{
int p_id = Convert.ToInt32(pid);
int count = 0;
bool flag = false;
using (var db = SugarDao.GetInstance())
{
var list = db.Queryable<tb_classification>().Where(it => it.pid == p_id&it.status==1).ToList();
for (int i = 0; i < list.Count; i++)
{
count++;
}
if (count > 0)
{
flag = true;
}
}
return flag;
}
string Tree = string.Empty;
/// <summary>
/// 使用递归拼接父节点的子节点
/// </summary>
/// <param name="pid"></param>
/// <param name="prefix"></param>
public string BindChildByParent(string pid, string prefix)
{
if (this.HasChild(pid))
{
// 得到当前父节点下的所有孩子
List<TreeEntity> list = this.findChildByPid(pid);
// 循环拼接当前父节点下的孩子
for (int i = 0; i < list.Count; i++)
{
//Tree += "|----" + prefix + list[i].name;
Tree += "{id:" + list[i].id + ",pId:" + list[i].pid + ",name:'" + list[i].name + "'},";
if (this.HasChild(list[i].id))
{
this.BindChildByParent(list[i].id, "--");
}
}
}
return Tree;
}
}
}
js调用：
<div class="jumbotron">
<h1>ASP.NET</h1>
<p class="lead">ASP.NET is a free web framework for building great Web sites and Web applications using HTML, CSS, and JavaScript.</p>
<p><a href="http://asp.net" class="btn btn-primary btn-lg">Learn more »</a></p>
</div>
<div class="row">
<div class="col-md-4">
<h2>Getting started</h2>
<p>ASP.NET Web API is a framework that makes it easy to build HTTP services that reach
a broad range of clients, including browsers and mobile devices. ASP.NET Web API
is an ideal platform for building RESTful applications on the .NET Framework.</p>
<p><a class="btn btn-default" href="http://go.microsoft.com/fwlink/?LinkId=301870">Learn more »</a></p>
</div>
<div class="col-md-4">
<h2>Get more libraries</h2>
<p>NuGet is a free Visual Studio extension that makes it easy to add, remove, and update libraries and tools in Visual Studio projects.</p>
<p><a class="btn btn-default" href="http://go.microsoft.com/fwlink/?LinkId=301871">Learn more »</a></p>
</div>
<div class="col-md-4">
<h2>Web Hosting</h2>
<p>You can easily find a web hosting company that offers the right mix of features and price for your applications.</p>
<p><a class="btn btn-default" href="http://go.microsoft.com/fwlink/?LinkId=301872">Learn more »</a></p>
</div>
</div>
<script src="~/Scripts/jquery-1.10.2.js"></script>
<script>
$(function () {
//var json = "{\"pid\": 0, \"title\": \"123\", \"introduction\":\"321\"}";
//var jsonjson = JSON.parse(json);
//$.ajax({
// type: "post",
// dataType: "json",
// url: " http://192.168.2.177:1222/api/classification/Postclassification",
// data:{"str":"jsonjson"},
// success: function (data) {
// console.log(data);
// }
//});
});
function OK() {
$.ajax({
type: "post",
url: "http://192.168.2.177:1222/api/classification/Postclassification",
data: { pid: 1, title: '123哈哈1', introduction:'介绍1'},
success: function (data) {
console.log(data);
}
});
}
function update() {
$.ajax({
type: "post",
url: "http://192.168.2.177:1222/api/classification/Putclassification",
data: { id: 11, pid: 1, title: '更新一下', introduction: '更新一下介绍吧' },
success: function (data) {
console.log(data);
}
});
}
</script>
<div>
<h1>新增操作</h1>
pid:<input type="text" id="txtPid"/><br />
title:<input type="text" id="txtTitle" /><br />
introduction:<input type="text" id="txtintroduction" /><br />
<input type="button" value="提交" onclick="OK()" />
</div>
<div>
<h1>修改操作</h1>
pid:<input type="text" id="txtPid" /><br />
title:<input type="text" id="txtTitle" /><br />
introduction:<input type="text" id="txtintroduction" /><br />
<input type="button" value="提交" onclick="update()" />
</div>
