/// <summary> /// 返回数据结果 /// </summary> /// <param name="context"></param> /// <returns></returns> public DataSet GetDataSet(IQueryServerContext context) { //核算单位,好像不管用 var hsdwmc = context[resdwmc].ToString(); context.AddMacroVal("hsdwmc", hsdwmc); //资源类别和资源表联查 var resCountSql = @"SELECT lsbzdw.lsbzdw_dwmc hsdwmc, Zylb.path, Zylb.Zylbbh, Zylb.Zylbmc, Zylb.Layer, fqres.resslormj, fqres.resnm, fqres.reskpbh, fqres.reslbbh, fqres.reslbmc, fqres.resjyfs, fqres.reszybh, fqres.reszymc, fqres.ResSyzk, fqres.resbmmc, fqres.ressjnms, fqres.restzrq, fqres.resstatename from Zylb left join fqres on fqres.ResTypeId = Zylb.Zylbnm"; var joinPart = GetResFilter(context); if (!string.IsNullOrEmpty(joinPart)) { resCountSql = String.Concat(resCountSql, " and ", joinPart); } resCountSql = String.Concat(resCountSql, " left join lsbzdw on fqres.resssdwid = lsbzdw.lsbzdw_dwbh "); var orderByPart = " order by Zylb.Path"; //根据资源编号排序汇总,前台默认是类别必须必填 resCountSql = string.Concat(resCountSql, orderByPart); var result = Utility.CurDatabase.ExecuteDataSet(resCountSql); //统计结果 //获取查询级数 int resLbQueryLayer = Convert.ToInt32(context["reslblayer"]); //int resLbQueryLayer = 4; GetNotDetailCount(result, resLbQueryLayer); return(result); }
/// <summary> /// 返回数据结果 /// </summary> /// <param name="context"></param> /// <returns></returns> public DataSet GetDataSet(IQueryServerContext context) { //把选中的核算单位名称加入到副标题 var hsdwmc = context[resdwmc].ToString(); context.AddMacroVal("hsdwmc", hsdwmc); var sql = $"select {resQueryFileds} from fqres"; var wherePart = GetResFilter(context); if (!string.IsNullOrEmpty(wherePart)) { sql = String.Concat(sql, " where ", wherePart); } var result = Utility.CurDatabase.ExecuteDataSet(sql); return(result); }