public IList <PRMWorkOrderItemMap_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression) { IList <PRMWorkOrderItemMap_DetailedEntity> pRMWorkOrderItemMap_DetailedEntityList = new List <PRMWorkOrderItemMap_DetailedEntity>(); try { if (String.IsNullOrEmpty(sortExpression)) { sortExpression = "PRMWorkOrderItemMap." + PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderItemMapID + " " + SQLConstants.SORT_ORDER_DESCENDING; } Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1; //startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1; if (pageSize == -1) { pageSize = 1000000000; } pRMWorkOrderItemMap_DetailedEntityList = FCCPRMWorkOrderItemMap_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression); if (pRMWorkOrderItemMap_DetailedEntityList != null && pRMWorkOrderItemMap_DetailedEntityList.Count > 0) { totalRowCount = pRMWorkOrderItemMap_DetailedEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(pRMWorkOrderItemMap_DetailedEntityList ?? new List <PRMWorkOrderItemMap_DetailedEntity>()); }
protected void lvCMBill_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; CMBill_DetailedEntity ent = (CMBill_DetailedEntity)dataItem.DataItem; HyperLink hypReport = (HyperLink)e.Item.FindControl("hypReport"); HyperLink lnkShowApprovalStatus = (HyperLink)e.Item.FindControl("lnkShowApprovalStatus"); HyperLink hypWorkOrderNo = (HyperLink)e.Item.FindControl("hypWorkOrderNo"); Panel pnlRequisitonNoLV = (Panel)e.Item.FindControl("pnlRequisitonNoLV"); Panel pnlMRRNoLV = (Panel)e.Item.FindControl("pnlMRRNoLV"); hypWorkOrderNo.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString(); APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.BILL, ent.BillID); if (aPApprovalProcessEntity.APApprovalProcessID > 0) { lnkShowApprovalStatus.NavigateUrl = UrlHelper.BuildSecureUrl( "~/AP/APView.aspx", string.Empty, APApprovalProcessEntity.FLD_NAME_APApprovalProcessID, aPApprovalProcessEntity.APApprovalProcessID.ToString() ).ToString(); lnkShowApprovalStatus.Target = "_blank"; } else { lnkShowApprovalStatus.NavigateUrl = String.Empty; lnkShowApprovalStatus.Enabled = false; } String fe_mrr = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_WorkOrderID, ent.WorkOrderID.ToString(), SQLMatchType.Equal); IList <PRMMaterialReceiveEntity> lstPRMMaterialReceive = FCCPRMMaterialReceive.GetFacadeCreate().GetIL(null, null, String.Empty, fe_mrr, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMMaterialReceive != null && lstPRMMaterialReceive.Count > 0) { //btnResetWorkOrderLV.Visible = false; foreach (PRMMaterialReceiveEntity pRMMaterialReceiveEntity in lstPRMMaterialReceive) { HyperLink hypMaterialReceive = new HyperLink(); hypMaterialReceive.Text = pRMMaterialReceiveEntity.MRRNo; hypMaterialReceive.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "MaterialReceiveReport", UrlConstants.OVERVIEW_MATERIAL_RECEIVE_ID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString()).ToString(); hypMaterialReceive.Target = "_blank"; hypMaterialReceive.CssClass = "CommonButtonLink"; pnlMRRNoLV.Controls.Add(hypMaterialReceive); pnlMRRNoLV.Controls.Add(new LiteralControl("<br/>")); } } String fe_req = SqlExpressionBuilder.PrepareFilterExpression("PRMWorkOrderItemMap." + PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, ent.WorkOrderID.ToString(), SQLMatchType.Equal); IList <PRMWorkOrderItemMap_DetailedEntity> lstPRMWorkOrderItemMap = FCCPRMWorkOrderItemMap_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_req); if (lstPRMWorkOrderItemMap != null && lstPRMWorkOrderItemMap.Count > 0) { List <PRMWorkOrderItemMap_DetailedEntity> distinct = lstPRMWorkOrderItemMap .GroupBy(car => car.WorkOrderID) .Select(g => g.First()) .ToList(); foreach (PRMWorkOrderItemMap_DetailedEntity pRMWorkOrderItemMapEntity in distinct) { HyperLink hypRequisitionNo = new HyperLink(); hypRequisitionNo.Text = pRMWorkOrderItemMapEntity.RequisitionNo.ToString(); hypRequisitionNo.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.REQUISITION_REPORT, UrlConstants.REQUISITION_ID, pRMWorkOrderItemMapEntity.RequisitionID.ToString()).ToString(); hypRequisitionNo.Target = "_blank"; hypRequisitionNo.CssClass = "CommonButtonLink"; pnlRequisitonNoLV.Controls.Add(hypRequisitionNo); pnlRequisitonNoLV.Controls.Add(new LiteralControl("<br/>")); } } hypReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.BILL_REPORT, UrlConstants.OVERVIEW_CM_BILL_ID, ent.BillID.ToString()).ToString(); hypReport.Target = "_blank"; hypWorkOrderNo.Target = "_blank"; } }
protected void lvREQRequisition_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; REQRequisition_DetailedEntity ent = (REQRequisition_DetailedEntity)dataItem.DataItem; HyperLink hypRequisition = (HyperLink)e.Item.FindControl("hypRequisition"); HyperLink hypEdit = (HyperLink)e.Item.FindControl("lnkBtnEdit"); HyperLink hypRequisitionReport = (HyperLink)e.Item.FindControl("hypRequisitionReport"); HyperLink hypCRMAdRequisitionReport = (HyperLink)e.Item.FindControl("hypCRMAdRequisitionReport"); HyperLink hypRequisitionDetail = (HyperLink)e.Item.FindControl("hypRequisitionDetail"); HyperLink lnkShowApprovalStatus = (HyperLink)e.Item.FindControl("lnkShowApprovalStatus"); Label lblRequisitionItem = (Label)e.Item.FindControl("lblRequisitionItem"); Label lblWorkOrderCreated = (Label)e.Item.FindControl("lblWorkOrderCreated"); if (ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.MIGRATE_TO_TRF) { String fe_TRF = SqlExpressionBuilder.PrepareFilterExpression(INVTransferEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal); IList <INVTransferEntity> iNVTransferEntityList = FCCINVTransfer.GetFacadeCreate().GetIL(null, null, String.Empty, fe_TRF, DatabaseOperationType.LoadWithFilterExpression); if (iNVTransferEntityList != null && iNVTransferEntityList.Count > 0) { Panel pnlTRFNoLV = (Panel)e.Item.FindControl("pnlTRFNoLV"); foreach (INVTransferEntity invTransferEntity in iNVTransferEntityList) { HyperLink hypTRFNoLV = new HyperLink(); hypTRFNoLV.Text = iNVTransferEntityList[0].TRFNo; hypTRFNoLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/INV/INVTransferItem.aspx", string.Empty, UrlConstants.OVERVIEW_TRANSFER_ID, invTransferEntity.TransferID.ToString()).ToString(); hypTRFNoLV.Target = "_blank"; hypTRFNoLV.CssClass = "CommonButtonLink"; pnlTRFNoLV.Controls.Add(hypTRFNoLV); pnlTRFNoLV.Controls.Add(new LiteralControl("<br/>")); } } } Boolean IsAdvertisementRequisition = false; String feReqItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal); IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, feReqItem); if (lst != null && lst.Count > 0) { foreach (REQRequisitionItem_DetailedEntity entREQRequisitionItem_DetailedEntity in lst) { lblRequisitionItem.Text += entREQRequisitionItem_DetailedEntity.MDItemItemName + ", "; if (entREQRequisitionItem_DetailedEntity.ItemCategoryID == MasterDataConstants.ItemDefaults.DEFAULT_ADVERTIESMENT_ITEM_CATEGORY) { IsAdvertisementRequisition = true; } } lblRequisitionItem.Text = lblRequisitionItem.Text.Substring(0, lblRequisitionItem.Text.Length - 2); } IList <PRMWorkOrderNoByRequisition_CustomEntity> lstWONO = FCCPRMWorkOrderNoByRequisition_Custom.GetFacadeCreate().GetIL(Int64.Parse(ent.RequisitionID.ToString())); if (lstWONO != null && lstWONO.Count > 0) { lblWorkOrderCreated.Text = lstWONO[0].WorkOrderNo.ToString(); } String fe_req = SqlExpressionBuilder.PrepareFilterExpression("PRMWorkOrderItemMap." + PRMWorkOrderItemMapEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal); IList <PRMWorkOrderItemMap_DetailedEntity> lstPRMWorkOrderItemMap = FCCPRMWorkOrderItemMap_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_req); if (lstPRMWorkOrderItemMap != null && lstPRMWorkOrderItemMap.Count > 0) { Panel pnlWorkOrderLV = (Panel)e.Item.FindControl("pnlWorkOrderLV"); List <PRMWorkOrderItemMap_DetailedEntity> distinct = lstPRMWorkOrderItemMap .GroupBy(car => car.WorkOrderID) .Select(g => g.First()) .ToList(); foreach (PRMWorkOrderItemMap_DetailedEntity pRMWorkOrderItemMapEntity in distinct) { HyperLink hypWorkOrder = new HyperLink(); hypWorkOrder.Text = pRMWorkOrderItemMapEntity.WorkOrderNo.ToString(); hypWorkOrder.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, pRMWorkOrderItemMapEntity.WorkOrderID.ToString()).ToString(); hypWorkOrder.Target = "_blank"; hypWorkOrder.CssClass = "CommonButtonLink"; pnlWorkOrderLV.Controls.Add(hypWorkOrder); pnlWorkOrderLV.Controls.Add(new LiteralControl("<br/>")); String fe_mrr = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_WorkOrderID, pRMWorkOrderItemMapEntity.WorkOrderID.ToString(), SQLMatchType.Equal); IList <PRMMaterialReceiveEntity> lstPRMMaterialReceive = FCCPRMMaterialReceive.GetFacadeCreate().GetIL(null, null, String.Empty, fe_mrr, DatabaseOperationType.LoadWithFilterExpression); if (lstPRMMaterialReceive != null && lstPRMMaterialReceive.Count > 0) { Panel pnlMRRLV = (Panel)e.Item.FindControl("pnlMRRLV"); foreach (PRMMaterialReceiveEntity pRMMaterialReceiveEntity in lstPRMMaterialReceive) { HyperLink hypMaterialReceive = new HyperLink(); hypMaterialReceive.Text = pRMMaterialReceiveEntity.MRRNo; hypMaterialReceive.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "MaterialReceiveReport", UrlConstants.OVERVIEW_MATERIAL_RECEIVE_ID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString()).ToString(); hypMaterialReceive.Target = "_blank"; hypMaterialReceive.CssClass = "CommonButtonLink"; pnlMRRLV.Controls.Add(hypMaterialReceive); pnlMRRLV.Controls.Add(new LiteralControl("<br/>")); } } } } if (ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.APPROVED || ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.MIGRATE_TO_TRF) { hypEdit.Visible = false; } String NavigationUrl = String.Empty; NavigationUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "RequisitionReport", UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString(); if (IsAdvertisementRequisition) { NavigationUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.CRM_AD_REQUISITION_REPORT, UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString(); } hypRequisitionReport.NavigateUrl = NavigationUrl; hypRequisitionReport.Target = "_blank"; hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisition.aspx", string.Empty, "do", "Edit", UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString(); if (this.OverviewProjectID > 0) { hypRequisition.NavigateUrl = UrlHelper.BuildSecureUrl("~/BD/BDProjectRequisitionItem.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString(); } else { hypRequisition.NavigateUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisitionItem.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString(); hypRequisitionDetail.NavigateUrl = UrlHelper.BuildSecureUrl("~/Site/REQRequisitionItemView.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString(); } APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.REQUISITION, ent.RequisitionID); if (aPApprovalProcessEntity.APApprovalProcessID > 0) { lnkShowApprovalStatus.NavigateUrl = UrlHelper.BuildSecureUrl( "~/AP/APView.aspx", string.Empty, APApprovalProcessEntity.FLD_NAME_APApprovalProcessID, aPApprovalProcessEntity.APApprovalProcessID.ToString() ).ToString(); lnkShowApprovalStatus.Target = "_blank"; } else { lnkShowApprovalStatus.NavigateUrl = String.Empty; lnkShowApprovalStatus.Enabled = false; } hypEdit.Target = "_blank"; hypRequisitionReport.Target = "_blank"; hypRequisitionDetail.Target = "_blank"; } }