/// <summary>
/// 取报表排序后某一页的数据
/// </summary>
/// <param name="code"></param>
/// <param name="page"></param>
/// <param name="_params"></param>
/// <returns></returns>
public string getReportDataPage(int code, int page, IList <_param> _params)
{
CT_Fields_list _fie_list = getFl_Date(code);
if (_fie_list == null)
{
return(string.Empty);
}
string _sql = SqlParamReplace(_fie_list.FL_RP_Code, _params);
_sql = _sql.Replace("'", "''");
IList <CT_Fields_Name> _fie_name = getReportTitle(code);
if (_fie_name == null || _fie_name.Count <= 0)
{
return(string.Empty);
}
string _zj = _fie_name[0].FN_FieldName;
string _px = _zj;
string _or = "DESC";
string z_exec = string.Format(@"DECLARE @SumPage INT ,@Sum INT
EXEC [dbo].[public_pager_01] '{0}','{1}','{2}','{3}',{4},10,@SumPage OUTPUT,@Sum OUTPUT SELECT @SumPage AS SumPage,@Sum AS SumRow;", _sql, _zj, _px, _or, page);
return(DataHelper.ConvertToJSONPage(z_exec));
}
/// <summary>
/// 获取报表的数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public string getReportData(int code, IList <_param> _params)
{
CT_Fields_list _fie_list = getFl_Date(code);
if (_fie_list == null)
{
return(string.Empty);
}
string _sql = SqlParamReplace(_fie_list.FL_RP_Code, _params);
return(DataHelper.ConvertToJSON(_sql));
}
/// <summary>
/// 列表配置
/// </summary>
/// <param name="data">查询条件</param>
private void DataGrid(dynamic data)
{
dynamic o = new ExpandoObject();
o._winID = Guid.NewGuid();
var MF_FL_FB_Code = -1;
if (data.MF_FL_FB_Code != null)
{
MF_FL_FB_Code = (int)data.MF_FL_FB_Code;
}
var db = DBCRMTree.GetInstance();
o.options = CT_Fields_list.SingleOrDefault(MF_FL_FB_Code);
//标题
if (o.options.FL_Type == 2)
{
o.columns = db.Query <dynamic>(string.Format(@"
SELECT [FN_FieldName] as [title]
,[FN_FieldName] as [field]
,case when [FN_Type] = 2 or [FN_Type] = 12 then 1 else 0 end as [sortable]
,[FN_Width] as [width]
,[FN_Format]
,[FN_Font]
,'left' as halign
,(case when isnull(FN_Option,1) = 2 then 'center' when isnull(FN_Option,1) = 3 then 'right' else 'left' end) as align,FN_Type
FROM [CT_Fields_Names]
where [FN_FL_FB_Code] = @0
order by fn_order", Interna ? "[FN_Desc_EN]" : "[FN_Desc_CN]"), MF_FL_FB_Code);
}
else
{
o.columns = db.Query <dynamic>(string.Format(@"
SELECT {0} as [title]
,[FN_FieldName] as [field]
,case when [FN_Type] = 2 or [FN_Type] = 12 then 1 else 0 end as [sortable]
,[FN_Width] as [width]
,[FN_Format]
,[FN_Font]
,'left' as halign
,(case when isnull(FN_Option,1) = 2 then 'center' when isnull(FN_Option,1) = 3 then 'right' else 'left' end) as align,FN_Type
FROM [CT_Fields_Names]
where [FN_FL_FB_Code] = @0
order by fn_order", Interna ? "[FN_Desc_EN]" : "[FN_Desc_CN]"), MF_FL_FB_Code);
}
if (o.options.FL_Type >= 10) //Survey Report. Find out how many columns there are
{
o.FN_Type50 = db.Query <dynamic>(string.Format(@"
select max(sq.cnt) as Max_Col from
(
select SQ_CG_Code, count(SQ_Code) as cnt from CT_Survey_Questions
left join CT_Campaigns on CG_Code=SQ_CG_Code
where CG_AD_OM_Code={0} and CG_UType=1 and SQ_SF_Code>=50
group by SQ_CG_Code
) SQ", UserSession.Dealer.AD_Code));
}
//btns
if (data.NB == null || (int)data.NB != 1)
{
o.buttons = GetButtons(MF_FL_FB_Code);
}
//search
o.search = GetSearch(MF_FL_FB_Code);
var dataGridInfo = JsonConvert.SerializeObject(o);
Response.Write(dataGridInfo);
}
