/// <summary>
/// 获取分类下的功能集合
/// </summary>
/// <param name="funtypeid">功能分类</param>
/// <returns>功能集合</returns>
private static DataTable GetFunDataTable(string funtypeid)
{
var bllgndy = new XT_QX_GNDY(request);
var sbwhere = new StringBuilder();
var valueobject = new object[1];
sbwhere.Append(" and SFSC = 'N' ");
if (!string.IsNullOrWhiteSpace(funtypeid))
{
sbwhere.Append(" and FLBM=:FLBM ");
valueobject[0] = funtypeid;
}
var ds = bllgndy.GetList(sbwhere.ToString(), valueobject);
return((ds != null && ds.Tables.Count > 0) ? ds.Tables[0] : new DataTable());
}
public static string GetFunData(string page, string rows, string flbm, string gnmc, string gnbm)
{
int pageNumber = int.Parse(page);
int pageSize = int.Parse(rows);
var sbwhere = new StringBuilder();
sbwhere.Append(" and SFSC = 'N'");
//添加分类编码查询条件
var objectValues = new object[3];
if (!string.IsNullOrWhiteSpace(flbm))
{
sbwhere.Append(" and FLBM=:FLBM");
objectValues[0] = flbm;
}
//添加功能名称条件
if (!string.IsNullOrWhiteSpace(gnmc))
{
sbwhere.Append(" and GNMC like :GNMC");
objectValues[1] = "%" + gnmc + "%";
}
//添加功能编码条件
if (!string.IsNullOrWhiteSpace(gnbm))
{
sbwhere.Append(" and GNBM like :GNBM ");
objectValues[2] = "%" + gnbm + "%";
}
var bllGndy = new XT_QX_GNDY(request);
var ds = bllGndy.GetListByPage(sbwhere.ToString(), "", (pageSize * pageNumber) - pageSize + 1,
(pageSize * pageNumber), objectValues);
int count = ds.Tables[0].Rows.Count;
List <EDRS.Model.XT_QX_GNDY> modeList = bllGndy.DataTableToList(ds.Tables[0]);
var resJson = JsonHelper.JsonString(modeList);
string j = "{\"total\":" + count + ",\"rows\":" + resJson + "}";
return(j);
}
