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));
}
