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