//资料分类统计数据查询 public List <TbAttachment> GetDataList(TbDataClassRequest request) { try { string sql = @"--************************查询各业务表单里面的附件********************************** DECLARE @TabName VARCHAR(32) SET @TabName=(SELECT TableName FROM TbSysMenuTable WHERE MenuCode=( SELECT TOP 1 MenuCode FROM TbSysMenu WHERE (ISNULL(@code,'')='' OR MenuCode=@code))) EXEC ( 'SELECT F.*,U.UserName FunModule FROM '+@TabName+' A OUTER APPLY dbo.StringToRows(A.ID,A.Enclosure) b INNER JOIN TbAttachment f on B.StrField=f.FileID LEFT JOIN TbUser U ON U.UserCode=F.UserCode' )"; SqlParameter[] par = new SqlParameter[] { new SqlParameter("@code", request.code) //菜单编号 }; var list = Db.Context.FromSql(sql).AddParameter(par).ToList <TbAttachment>(); //查询总数 request.records = list.Count(); //参数化 return(list); //List<Dos.ORM.Parameter> para = new List<Dos.ORM.Parameter>(); ////将左侧导航分类的项目编号Code加入参数中 //para.Add(new Dos.ORM.Parameter("@code", request.code, DbType.String, null)); ////将model返回给前台 //var model = Repository<TbAttachment>.FromSql(sql, para, "id", "desc", request.rows, request.page).ToList<TbAttachment>(); //return model; } catch (Exception) { throw; } }
//资料分类统计数据查询 public ActionResult GetDataList(TbDataClassRequest request) { var data = new { rows = _File.GetDataList(request).ToList(), total = request.total, page = request.page, records = request.records }; return(Content(data.ToJson())); }