static GridViewModel GetListDetailModel(int Query_Id, int UserId)
{
var viewModel = GridViewExtension.GetViewModel("gvDetail|" + Query_Id.ToString() + "|");
if (viewModel == null)
{
viewModel = ReportQueryDetail__List_Model.CreateGridViewModel();
}
return(viewModel);
}
static void DetailProcessCustomBinding(int userId, ReportQuery_ParamModel param, GridViewModel viewModel)
{
viewModel.ProcessCustomBinding(
new GridViewCustomBindingGetDataRowCountHandler(args =>
{
ReportQueryDetail__List_Model.GetDataRowCount(args, userId, param);
}),
new GridViewCustomBindingGetDataHandler(args =>
{
ReportQueryDetail__List_Model.GetData(args, userId, param);
})
);
}
public ActionResult ShowResultQuery([ModelBinder(typeof(DevExpressEditorsBinder))] List <CrystalReportParam> Params)
{
List <CrystalReportParam> crtParams = new List <CrystalReportParam>();
int userId = (int)Session["userId"];
int Query_Id = 0;
if (Request["Query_Id"] == null)
{
Query_Id = 0;
}
else
{
Query_Id = int.Parse(Request["Query_Id"]);
}
// Query_Id = 2;
ViewBag.Query_Id = Query_Id;
var param = GetParam(Query_Id);
param.crtParams = Params;
DataTable dataTable = ReportQueryDetail__List_Model.GetDataTable(userId, param);
ViewBag.dataTable = dataTable;
//---------------------------------
var viewModel = GetListDetailModel(Query_Id, userId);
DetailProcessCustomBinding(userId, param, viewModel);
JavaScriptSerializer serializer = new JavaScriptSerializer();
String param1 = MvcHtmlString.Create(serializer.Serialize(Params)).ToString();
ViewBag.Params = param1;
ViewBag.RowCount = param.RowCount;
return(PartialView(VIEW_LIST_DETAIL_PARTIAL, viewModel));
}
// Sorting
public ActionResult ListDetailSorting(GridViewColumnState column, bool reset)
{
int userId = (int)Session["userId"];
var Query_Id = int.Parse(Request["Query_Id"]);
var param = GetParam(Query_Id);
//-------------------------------------
string cpParams = "";
if (ViewBag.Params != null)
{
cpParams = ViewBag.Params;
}
else
{
cpParams = Request["Params"];
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
List <CrystalReportParam> reportParams;
reportParams = serializer.Deserialize <List <CrystalReportParam> >(cpParams);
param.crtParams = reportParams;
//--------------------------------------
DataTable dataTable = ReportQueryDetail__List_Model.GetDataTable(userId, param);
ViewBag.dataTable = dataTable;
var viewModel = GetListDetailModel(Query_Id, userId);
viewModel.ApplySortingState(column, reset);
DetailProcessCustomBinding(userId, param, viewModel);
ViewBag.RowCount = param.RowCount;
return(PartialView(VIEW_LIST_DETAIL_PARTIAL, viewModel));
}
public ActionResult ExportTo()
{
int userId = (int)Session["userId"];
var hidden_CpGvFind_FilterExpression = Request["hidden_CpGvFind_FilterExpression"];
var hidden_CpGvFind_SortExpression = Request["hidden_CpGvFind_SortExpression"];
var hidden_CpGvFind_PageIndex = Request["hidden_CpGvFind_PageIndex"];
var hidden_CpGvFind_PageSize = Request["hidden_CpGvFind_PageSize"];
int Query_Id = int.Parse(Request["Query_Id"]);
var param = GetParam(Query_Id);
//-------------------------------------
string cpParams = "";
cpParams = Request["Params"];
JavaScriptSerializer serializer = new JavaScriptSerializer();
List <CrystalReportParam> reportParams;
reportParams = serializer.Deserialize <List <CrystalReportParam> >(cpParams);
param.crtParams = reportParams;
//--------------------------------------
IEnumerable items = ReportQueryDetail__List_Model.GetDataList(userId, param, hidden_CpGvFind_FilterExpression, hidden_CpGvFind_SortExpression, Convert.ToInt32(hidden_CpGvFind_PageIndex), Convert.ToInt32(hidden_CpGvFind_PageSize));
return(GridViewExportHelper.ExportTypes["XLS"].Method(GridViewExportHelper.ExportGridViewSettings(userId, param), items));
}
public ActionResult ListDetailPartial()
{
int userId = (int)Session["userId"];
int Query_Id = 0;
if (Request["Query_Id"] == null)
{
Query_Id = 0;
}
else
{
Query_Id = int.Parse(Request["Query_Id"]);
}
//--------------------------------
if (Query_Id == 0)
{
string DXCallbackName = "";
if (Request["DXCallbackName"] != null)
{
DXCallbackName = Request["DXCallbackName"];
if (DXCallbackName.StartsWith("gvDetail|"))
{
var arr = DXCallbackName.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
if (arr.Length > 1)
{
Query_Id = int.Parse(arr[1]);
}
}
}
}
// Query_Id = 2;
ViewBag.Query_Id = Query_Id;
var param = GetParam(Query_Id);
//-------------------------------------
string cpParams = "";
if (ViewBag.Params != null)
{
cpParams = ViewBag.Params;
}
else
{
cpParams = Request["Params"];
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
List <CrystalReportParam> reportParams;
reportParams = serializer.Deserialize <List <CrystalReportParam> >(cpParams);
param.crtParams = reportParams;
//--------------------------------------
DataTable dataTable = ReportQueryDetail__List_Model.GetDataTable(userId, param);
ViewBag.dataTable = dataTable;
//---------------------------------
var viewModel = GetListDetailModel(Query_Id, userId);
DetailProcessCustomBinding(userId, param, viewModel);
ViewBag.RowCount = param.RowCount;
return(PartialView(VIEW_LIST_DETAIL_PARTIAL, viewModel));
}