public JsonResult GetPODetailItem(int POID, DataSourceRequest request) { KoyoSMS.WCF.Common.Model.PageBase pageCondition = new KoyoSMS.WCF.Common.Model.PageBase(); int page = request.Page; int pageSize = request.PageSize; int iPOID = POID > 0 ? POID : 0; SQLQueryBuilder queryBuilder = new SQLQueryBuilder(); DBPOProfile poProfile = new DBPOProfile(); if (iPOID > 0) { queryBuilder.QueryParameters.Add(new SQLQueryParameter("POID", iPOID)); } pageCondition.PageIndex = page - 1; pageCondition.PageSize = pageSize > 0 ? pageSize : 5; poCollection.PODetailViewItems = poProfile.GetPODetailViews(queryBuilder, pageCondition); int total = pageCondition.TotalRecord; var jsonData = new { total = total, data = poCollection.PODetailViewItems }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetPOViewItems(int MasterID, int ProjectID, int SupplierID, string PONo, DataSourceRequest request) { int masterID = MasterID > 0 ? MasterID : 0; int projectID = ProjectID > 0 ? ProjectID : 0; string pono = !string.IsNullOrEmpty(PONo) ? PONo : ""; int page = request.Page; int pageSize = request.PageSize; SQLQueryBuilder queryBuilder = new SQLQueryBuilder(); KoyoSMS.WCF.Common.Model.PageBase pageCondition = new KoyoSMS.WCF.Common.Model.PageBase(); DBPOProfile poProfile = new DBPOProfile(); if (masterID > 0) { queryBuilder.QueryParameters.Add(new SQLQueryParameter("MasterID", masterID)); } if (projectID > 0) { queryBuilder.QueryParameters.Add(new SQLQueryParameter("ProjectID", projectID)); } if (!string.IsNullOrEmpty(pono)) { queryBuilder.QueryParameters.Add(new SQLQueryParameter("PONo", pono)); } pageCondition.PageIndex = page - 1; pageCondition.PageSize = pageSize > 0 ? pageSize : 5; poCollection.POEntityViewItems = poProfile.GetPOViews(queryBuilder, pageCondition); int total = pageCondition.TotalRecord; var jsonData = new { total = total, data = poCollection.POEntityViewItems }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }