public List <T_Lable> GetLable_Datail(T_Lable model)
{
using (IDbConnection conn = DapperAdapter.MySQLOpenConnection(ConfigurationHelper.MySQLConnectionStr))
{
DynamicParameters param = new DynamicParameters();
StringBuilder sb = new StringBuilder();
sb.AppendLine("SELECT * FROM ( ");
sb.AppendLine("SELECT l.*,(SELECT group_concat(lable) FROM T_LableDetail where parentID=l.id) as lableDetail FROM T_Lable L where L.typeid=@typeid GROUP BY lableName");
sb.AppendLine(" ) as tb");
param.Add("@typeid", model.typeid);
if (!string.IsNullOrWhiteSpace(model.lableName))
{
sb.AppendLine("WHERE lableName LIKE @lableName");
param.Add("@lableName", "%" + model.lableName.Trim() + "%");
}
sb.AppendLine(" ORDER BY " + model.orderBy);
string sqlCount = sb.ToString().Replace("SELECT * ", " SELECT count(1) totalCount ");
//分页记录列表
var list = conn.Query <T_Lable>(sb.ToString(), param).ToList();
if (list != null && list.Count() > 0)
{
//总记录数列表
dynamic identity = conn.Query(sqlCount, param).Single();
list[0].totalCount = Convert.ToInt64(identity.totalCount);
list[0].pageIndex = model.pageIndex;
list[0].pageSize = model.pageSize;
}
return(list);
}
}
public int UpdateLableType(T_Lable model)
{
using (IDbConnection conn = DapperAdapter.MySQLOpenConnection(ConfigurationHelper.MySQLConnectionStr))
{
string updateSql = "UPDATE T_Lable SET typeid=@typeid,lableName=@lableName WHERE id=@id;";
return(conn.Execute(updateSql, model));
}
}
public int SaveLableType(T_Lable model)
{
using (IDbConnection conn = DapperAdapter.MySQLOpenConnection(ConfigurationHelper.MySQLConnectionStr))
{
string addSQL = @"INSERT INTO T_Lable (typeid,lableName,createTime) VALUE (@typeid,@lableName,@createTime);";
return(conn.Execute(addSQL, model));
}
}
public ActionResult Edit(int id)
{
T_Lable lable = this._lable.GetLable(id, (int)Entity.Enum.RelateEnum.label);
if (null == lable)
{
lable = new T_Lable();
}
return(View(lable));
}
public ActionResult SaveLable(T_Lable model)
{
int result = 0;
if (model.id == 0)
{
model.createTime = DateTime.Now;
model.typeid = (int)RelateEnum.label;
result = this._lable.SaveLableType(model);
}
else
{
model.typeid = (int)RelateEnum.label;
result = this._lable.UpdateLableType(model);
}
return(Response(result));
}
public ActionResult GetPageList(string pagination, string keyword)
{
Pagination paginationobj = pagination.ToObject <Pagination>();
T_Lable lable = new T_Lable();
lable.pageIndex = paginationobj.page;
lable.pageSize = paginationobj.rows;
lable.totalCount = paginationobj.total;
lable.lableName = keyword;
lable.orderBy = paginationobj.sidx + " " + paginationobj.sord;
lable.typeid = (int)RelateEnum.label;
List <T_Lable> list = this._lable.GetLable_Datail(lable);
var jsonData = new
{
rows = list,
total = list.Count > 0 ? list[0].total : 0,
page = paginationobj.page,
records = list.Count > 0 ? list[0].totalCount : 0
};
return(Success(jsonData));
}
