public String KeyValuePList(String groupCode)
{
KeyValuePListViewData view = new KeyValuePListViewData();
view.List = new List <KeyValueP>();
view.Code = groupCode;
view.PageData = new PaginationData();
view.PageData.PageIndex = 1;
view.PageData.PageSize = 10;
view.PageData.PagintionJsFunction = "window.System.KeyValuePList.search()";
view.PageData.OrderBy = "Code";
string sql = @"SELECT A.*, B.[Name] AS ParentName
FROM KeyValuePair AS A
LEFT JOIN KeyValuePair AS B ON A.ParentGuid = B.ID
WHERE A.[Group] = @Group
";
view.List = new Pagintion(sql, new { Group = groupCode }, view.PageData).ToList <KeyValueP>();
return(PageViewHelper.LoadPage("/System/KeyValuePList.aspx", view));
}
public string Search(PaginationData pd, String code)
{
KeyValuePListViewData view = new KeyValuePListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.KeyValuePList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.[Name] AS ParentName
FROM KeyValuePair AS A
LEFT JOIN KeyValuePair AS B ON A.ParentGuid = B.ID
WHERE A.[Group] = @Group
";
view.List = new Pagintion(sql, new { Group = code }, view.PageData).ToList <KeyValueP>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/KeyValuePList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
