private void DoDeptList() { PLANT plant = (PLANT)SessionManager.EffLocation.Plant; LocalOrg().DeptList = SQMModelMgr.SelectDepartmentList(entities, (decimal)plant.COMPANY_ID, (decimal)plant.BUS_ORG_ID, plant.PLANT_ID); uclSubLists.BindDeptList(LocalOrg().DeptList); }
private void DoDeptList() { BUSINESS_ORG busOrg = (BUSINESS_ORG)SessionManager.EffLocation.BusinessOrg; LocalOrg().DeptList = SQMModelMgr.SelectDepartmentList(entities, SessionManager.EffLocation.Company.COMPANY_ID, busOrg.BUS_ORG_ID, 0); uclSubLists.BindDeptList(LocalOrg().DeptList); }
public void BindIncident(decimal incidentID) { staticIncidentID = incidentID; try { COST_REPORT_ITEM item = costReport.CostReport.COST_REPORT_ITEM.Where(l => l.INCIDENT_ID == incidentID).FirstOrDefault(); QualityIncidentData qiData = costReport.IncidentList.Where(l => l.Incident.INCIDENT_ID == item.INCIDENT_ID).FirstOrDefault(); lblCRIncidentIDHdr.Text = WebSiteCommon.FormatID(qiData.Incident.INCIDENT_ID, 6); tbCRItemQtyActual.Text = item.NCM_ACT_QTY.ToString(); tbCRItemQtyActual.Focus(); tbCRItemQtyAvoid.Text = item.NCM_POT_QTY.ToString(); tbCRUnitCostActual.Text = item.UNIT_COST.ToString(); tbCRUnitCostAvoid.Text = item.UNIT_COST.ToString(); tbCRItemCostActual.Text = item.NCM_ACT_COST.ToString(); tbCRItemCostAvoid.Text = item.NCM_POT_COST.ToString(); tbCRItemNote.Text = item.NCM_COMMENTS; List <PLANT_LINE> lineList = SQMModelMgr.SelectPlantLineList(this.entities, (decimal)qiData.Incident.DETECT_PLANT_ID); ddlCRPlantLineActual.DataSource = lineList; ddlCRPlantLineActual.DataValueField = "PLANT_LINE_ID"; ddlCRPlantLineActual.DataTextField = "PLANT_LINE_NAME"; ddlCRPlantLineActual.DataBind(); ddlCRPlantLineActual.Items.Insert(0, new ListItem("", "0")); ddlCRPlantLineAvoid.DataSource = lineList; ddlCRPlantLineAvoid.DataValueField = "PLANT_LINE_ID"; ddlCRPlantLineAvoid.DataTextField = "PLANT_LINE_NAME"; ddlCRPlantLineAvoid.DataBind(); ddlCRPlantLineAvoid.Items.Insert(0, new ListItem("", "0")); if (ddlCRPlantLineActual.Items.FindByValue(item.DWN_ACT_LINE_ID.ToString()) != null) { ddlCRPlantLineActual.SelectedValue = item.DWN_ACT_LINE_ID.ToString(); } tbCRDowntimeRateActual.Text = item.DWN_ACT_RATE.ToString(); tbCRDowntimeRateAvoid.Text = item.DWN_POT_RATE.ToString(); tbCRDowntimeActual.Text = item.DWN_ACT.ToString(); if (ddlCRPlantLineAvoid.Items.FindByValue(item.DWN_POT_LINE_ID.ToString()) != null) { ddlCRPlantLineAvoid.SelectedValue = item.DWN_POT_LINE_ID.ToString(); } tbCRDowntimeAvoid.Text = item.DWN_POT.ToString(); tbCRDowntimeCostActual.Text = item.DWN_ACT_COST.ToString(); tbCRDowntimeCostAvoid.Text = item.DWN_POT_COST.ToString(); tbCRDowntimeNote.Text = item.DWN_COMMENTS; List <DEPARTMENT> deptList = SQMModelMgr.SelectDepartmentList(this.entities, (decimal)qiData.Incident.DETECT_COMPANY_ID, 0, (decimal)qiData.Incident.DETECT_PLANT_ID); ddlCRLaborDeptActual.DataSource = deptList; ddlCRLaborDeptActual.DataValueField = "DEPT_ID"; ddlCRLaborDeptActual.DataTextField = "DEPT_NAME"; ddlCRLaborDeptActual.DataBind(); ddlCRLaborDeptActual.Items.Insert(0, new ListItem("", "0")); ddlCRLaborDeptAvoid.DataSource = deptList; ddlCRLaborDeptAvoid.DataValueField = "DEPT_ID"; ddlCRLaborDeptAvoid.DataTextField = "DEPT_NAME"; ddlCRLaborDeptAvoid.DataBind(); ddlCRLaborDeptAvoid.Items.Insert(0, new ListItem("", "0")); List <LABOR_TYPE> laborList = SQMModelMgr.SelectLaborTypeList(this.entities, (decimal)qiData.Incident.DETECT_COMPANY_ID, 0, (decimal)qiData.Incident.DETECT_PLANT_ID); ddlCRLaborTypeActual.DataSource = laborList; ddlCRLaborTypeActual.DataValueField = "LABOR_TYP_ID"; ddlCRLaborTypeActual.DataTextField = "LABOR_NAME"; ddlCRLaborTypeActual.DataBind(); ddlCRLaborTypeActual.Items.Insert(0, new ListItem("", "0")); ddlCRLaborTypeAvoid.DataSource = laborList; ddlCRLaborTypeAvoid.DataValueField = "LABOR_TYP_ID"; ddlCRLaborTypeAvoid.DataTextField = "LABOR_NAME"; ddlCRLaborTypeAvoid.DataBind(); ddlCRLaborTypeAvoid.Items.Insert(0, new ListItem("", "0")); if (ddlCRLaborDeptActual.Items.FindByValue(item.LABOR_ACT_DEPT_ID.ToString()) != null) { ddlCRLaborDeptActual.SelectedValue = item.LABOR_ACT_DEPT_ID.ToString(); } if (ddlCRLaborTypeActual.Items.FindByValue(item.LABOR_ACT_TYPE_ID.ToString()) != null) { ddlCRLaborTypeActual.SelectedValue = item.LABOR_ACT_TYPE_ID.ToString(); } tbCRLaborRateActual.Text = item.LABOR_ACT_RATE.ToString(); tbCRLaborRateAvoid.Text = item.LABOR_POT_RATE.ToString(); tbCRLaborActual.Text = item.LABOR_ACT.ToString(); if (ddlCRLaborDeptAvoid.Items.FindByValue(item.LABOR_POT_DEPT_ID.ToString()) != null) { ddlCRLaborDeptAvoid.SelectedValue = item.LABOR_POT_DEPT_ID.ToString(); } if (ddlCRLaborTypeAvoid.Items.FindByValue(item.LABOR_POT_TYPE_ID.ToString()) != null) { ddlCRLaborTypeAvoid.SelectedValue = item.LABOR_POT_TYPE_ID.ToString(); } tbCRLaborAvoid.Text = item.LABOR_POT.ToString(); tbCRLaborCostActual.Text = item.LABOR_ACT_COST.ToString(); tbCRLaborCostAvoid.Text = item.LABOR_POT_COST.ToString(); tbCRLaborNote.Text = item.LABOR_COMMENTS; tbCRShipDescActual.Text = item.SHIP_ACT_TYPE.ToString(); tbCRShipDescAvoid.Text = item.SHIP_POT_TYPE.ToString(); tbCRShipCostActual.Text = item.SHIP_ACT_COST.ToString(); tbCRShipCostAvoid.Text = item.SHIP_POT_COST.ToString(); tbCRShipNote.Text = item.SHIP_COMMENTS; tbCRIncidentCostActual.Text = FormatValue((decimal)item.TOTAL_ACT_COST, 2); tbCRIncidentCostAvoid.Text = FormatValue((decimal)item.TOTAL_POT_COST, 2); tbCRIncidentCostActual.Enabled = tbCRIncidentCostAvoid.Enabled = false; btnCRCalculate.Enabled = true; tbCRTotalNote.Text = item.TOTAL_COMMENTS; // copy relevant incident data to the cost report when creating new if (costReport.IsNew || item.EntityState == System.Data.EntityState.Added || item.EntityState == System.Data.EntityState.Detached) { QI_OCCUR_ITEM insp = qiData.QIIssue.QI_OCCUR_ITEM.FirstOrDefault(); tbCRItemQtyActual.Text = FormatValue((decimal)insp.TOTAL_NC_QTY, 2); tbCRUnitCostActual.Text = tbCRUnitCostAvoid.Text = "1.0"; // td tbCRItemCostActual.Text = FormatValue((decimal)insp.TOTAL_NC_QTY, 2); if (qiData.Incident.DETECT_PLANT_LINE_ID.HasValue && ddlCRPlantLineActual.Items.FindByValue(qiData.Incident.DETECT_PLANT_LINE_ID.ToString()) != null) { PLANT_LINE line = lineList.Where(l => l.PLANT_LINE_ID == qiData.Incident.DETECT_PLANT_LINE_ID).FirstOrDefault(); ddlCRPlantLineActual.SelectedValue = qiData.Incident.DETECT_PLANT_LINE_ID.ToString(); tbCRDowntimeRateActual.Text = FormatValue((decimal)line.DOWNTIME_RATE, 2); } } } catch { } }