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