//资料分类统计数据查询
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()));
}
