private void LoadIncidentIssueInfo(decimal incidentID)
{
// for quality incidents, load the part/item identifications
if (this.ProbCase.PROBCASE_TYPE == "QI")
{
QualityIssue qualityIssue = new QualityIssue().Load(incidentID);
this.IssueList.Add(qualityIssue);
if (qualityIssue.IssueOccur == null)
{
qualityIssue.IssueOccur = new QI_OCCUR();
}
else
{
foreach (QI_OCCUR_ITEM item in qualityIssue.IssueOccur.QI_OCCUR_ITEM)
{
PartIssueItem partItem = new PartIssueItem();
if (qualityIssue.Partdata != null && qualityIssue.Partdata.Part.PART_ID > 0)
{
partItem.PART_NUM = qualityIssue.Partdata.Part.PART_NUM;
partItem.LOT_NUM = item.LOT_NUM;
partItem.CONTAINER_NUM = item.CONTAINER_NUM;
partItem.NC_QTY = Math.Max(0, (decimal)item.INSPECT_NC_QTY);
this.PartIssueItemList.Add(partItem);
}
}
}
}
else if (this.ProbCase.PROBCASE_TYPE == "EHS")
{
;
}
}
private void uclSearchBar_OnCancelClick()
{
qualityIssue = null;
uclSearchBar.SetButtonsEnabled(true, false, true, false, false, false);
uclSearchBar.PageTitle.Text = lblNCOccurTitle.Text;
ResetControlValues(divPageBody.Controls);
divPageBody.Visible = false;
}
private void SearchList(string cmd)
{
uclIssueList.Visible = true;
string context = "CST";
QSCalcsCtl calcsCtl = new QSCalcsCtl().CreateNew();
uclIssueList.BindCSTIssueList(calcsCtl.SetIncidentHistory(QualityIssue.SelectIncidentDataList(uclIssueSearch.DDLPlantSelectIDS(), uclIssueSearch.FromDate, uclIssueSearch.ToDate, context, "", false, uclIssueSearch.ShowImages)), context, uclIssueSearch.ShowImages);
}
protected void OnIssue_Click(decimal issueID)
{
qualityIssue = new QualityIssue().CreateNew().Load(issueID);
pnlSearchList.Visible = false;
uclSearchBar.SetButtonsEnabled(true, true, true, false, false, false);
uclSearchBar.SetButtonsNotClicked();
EnableControls(divPageBody.Controls, false);
SetupPage();
}
private void uclSearchBar_OnSearchClick()
{
initSearch = true;
divPageBody.Visible = false;
pnlSearchList.Visible = true;
uclSearchBar.TitleItem.Visible = false;
uclIssueList.BindQualityIssueList(QualityIssue.SelectIncidentList(SessionManager.SessionContext.ActiveCompany().COMPANY_ID, "QI", uclSearchBar.SearchText.Text, false));
uclIssueList.QualityIssueListGrid.Columns[0].Visible = false;
}
public void TestItemDescription()
{
ItemViewModel item = new ItemViewModel();
QualityResults results = QualityEngine.CheckItem(item);
Assert.IsNotNull(results);
Assert.IsTrue(results.Count > 0);
QualityIssue descriptionEmpty = results.FindFirstIssue(QualityEngine.DescriptionIsEmpty);
Assert.IsNotNull(descriptionEmpty);
}
private void uclSearchBar_OnNewClick()
{
qualityIssue = new QualityIssue().CreateNew();
qualityIssue.AddItem();
qualityIssue.AddSample();
qualityIssue.AddSampleMeasure(1);
qualityIssue.AddSampleMeasure(1);
pnlSearchList.Visible = false;
uclSearchBar.SetButtonsEnabled(true, false, true, true, false, false);
EnableControls(divPageBody.Controls, true);
SetupPage();
}
private void SearchList(string cmd)
{
uclReceiptList.Visible = false;
uclIssueList.Visible = ddlChartType.Enabled = true;
IssueCtl().InitializeCalcs();
uclIssueList.BindCSTIssueList(IssueCtl().CalcsCtl.SetIncidentHistory(QualityIssue.SelectIncidentDataList(uclIssueSearch.DDLPlantSelectIDS(), uclIssueSearch.FromDate, uclIssueSearch.ToDate, IssueCtl().Context, "", false, uclIssueSearch.ShowImages)), IssueCtl().Context, uclIssueSearch.ShowImages);
if (uclIssueList.CSTListCount > 0)
{
lblChartType.Visible = ddlChartType.Visible = true;
}
ddlChartType.SelectedIndex = 0;
ddlChartTypeChange(ddlChartType, null);
}
private void SetupPage()
{
SessionManager.ReturnStatus = false;
SessionManager.ReturnObject = null;
ddlPlantWhereUsed.DataSource = SQMModelMgr.SelectPlantList(entities, searchMgr.CompanyID, searchMgr.BusorgID);
ddlPlantWhereUsed.DataTextField = "PLANT_NAME";
ddlPlantWhereUsed.DataValueField = "PLANT_ID";
ddlPlantWhereUsed.DataBind();
ddlPlantWhereUsed.Items.Insert(0, new ListItem("", "0"));
ddlPlantWhereUsed.SelectedValue = searchMgr.PlantID.ToString();
searchMgr.PlantID = Convert.ToInt32(ddlPlantWhereUsed.SelectedValue);
uclIssueList.BindQualityIssueList(QualityIssue.SelectIncidentList(SessionManager.SessionContext.ActiveCompany().COMPANY_ID, "QI", "", false));
uclIssueList.QualityIssueListGrid.Columns[0].Visible = false;
divIssueList.Visible = true;
uclIssueList.OnQualityIssueClick += lnkIssue_Click;
}
protected void Page_PreRender(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
HiddenField hfld = (HiddenField)this.Form.Parent.FindControl("form1").FindControl("ContentPlaceHolder1").FindControl("hdCurrentActiveTab");
hfld.Value = SessionManager.CurrentAdminTab = "lbNCOccur";
uclSearchBar.PageTitle.Text = lblNCOccurTitle.Text;
divPageBody.Visible = false;
if ((bool)SessionManager.ReturnStatus)
{
string s = SessionManager.ReturnObject.GetType().ToString();
if (SessionManager.ReturnObject.GetType().ToString().ToUpper().Contains("QI_OCCUR"))
{
QI_OCCUR qiOccur = (QI_OCCUR)SessionManager.ReturnObject;
qualityIssue = new QualityIssue().Load(qiOccur.QIO_ID);
SetupPage();
uclSearchBar.SetButtonsEnabled(true, true, true, false, false, false);
uclSearchBar.SetButtonsNotClicked();
}
}
}
else
{
if ((bool)SessionManager.ReturnStatus)
{
string s = SessionManager.ReturnObject.GetType().ToString();
if (SessionManager.ReturnObject.GetType().ToString().ToUpper().Contains("PLANTPART"))
{
vw_CustPlantPart plantPart = (vw_CustPlantPart)SessionManager.ReturnObject;
if (qualityIssue != null)
{
qualityIssue.AddPartInfo(plantPart.PART_ID, plantPart.PART_NUM, plantPart.PART_NAME);
qualityIssue.AddSupplierInfo(plantPart.SUPP_COMPANY_ID, plantPart.SUPP_COMPANY_NAME);
}
SetupPage();
}
}
}
SessionManager.ReturnObject = null;
SessionManager.ReturnStatus = false;
}
protected void btnDupIncident_Click(object sender, EventArgs e)
{
QualityIssue QIRef = new QualityIssue().CreateNew("", ddlIncidentType.SelectedValue);
QIRef.IssueOccur.PART_TYPE = ddlPartType.SelectedValue;
try
{
QIRef.IssueOccur.PROBLEM_AREA = uclNC.ProblemArea;
QIRef.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().NONCONF_ID = Convert.ToDecimal(uclNC.NCDefect);
}
catch
{
QIRef.IssueOccur.PROBLEM_AREA = "";
QIRef.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().NONCONF_ID = 0;
}
// uclQISearch1.Initialize("", IssueCtl().qualityIssue, IssueCtl().qualityIssue.Partdata.B2BList, DateTime.Now.AddYears(-2), DateTime.Now, false, IssueCtl().qualityIssue.IssueOccur.RELATED_INCIDENTS);
// uclQISearch1.QITextBox.Focus();
// udpDup.Update();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["issue"] == null)
{
return;
}
try
{
int issueID = Convert.ToInt32(Request.QueryString["issue"]);
QualityIssue qs = new QualityIssue();
string strHtml = qs.Load(issueID).FormatLabelContent("testlabel.txt");
if (!String.IsNullOrEmpty(strHtml))
{
divLabel.InnerHtml += strHtml;
}
}
catch (Exception ex)
{
}
}
public int SaveAttachments(QualityIssue theIssue)
{
// save attachments
int status = 0;
if (uclRadAttach.RAUpload.UploadedFiles.Count > 0)
{
SessionManager.DocumentContext =
new SQM.Shared.DocumentScope().CreateNew(SessionManager.UserContext.WorkingLocation.Company.COMPANY_ID, "BLI", 0, "",
SessionManager.UserContext.WorkingLocation.Plant.PLANT_ID, "", 0);
SessionManager.DocumentContext.RecordType = 20;
SessionManager.DocumentContext.RecordID = theIssue.Incident.INCIDENT_ID;
SessionManager.DocumentContext.RecordStep = "1";
uclRadAttach.SaveFiles();
theIssue.LoadAttachments();
}
uclResponse.SaveAttachments(theIssue.TeamResponse.ResponseList.LastOrDefault());
return(status);
}
public void gvMeasure_OnRowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
if ((!e.Row.RowType.ToString().Trim().Equals(System.Web.UI.WebControls.ListItemType.Header.ToString())) & (!e.Row.RowType.ToString().Trim().Equals(System.Web.UI.WebControls.ListItemType.Footer.ToString())))
{
try
{
HiddenField hf;
if (measureList == null || measureList.Count == 0)
{
measureList = QualityIssue.SelectMeasuresList(0);
}
DropDownList ddl = (DropDownList)e.Row.Cells[0].FindControl("ddlMeasure");
ddl.DataSource = measureList;
ddl.DataTextField = "MEASURE_NAME";
ddl.DataValueField = "CTLMEASURE_ID";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("", "0"));
}
catch
{
}
}
}
public QualityIssue UpdateIssue(QualityIssue theIssue)
{
bool success;
decimal decVal;
RESPONSE response = null;
theIssue.Status = QualityIssue.UpdateStatus.Pending;
if (IssueCtl().PageMode == PageUseMode.Active)
{
// re-activate issue
IssueCtl().qualityIssue.IssueOccur.STATUS = ddlStatus.SelectedValue;
IssueCtl().qualityIssue.SetTasksOpen("C", DateTime.UtcNow.AddDays(14));
IssueCtl().qualityIssue.StatusChanged = true;
theIssue.Status = QualityIssue.UpdateStatus.Success;
return(theIssue = IssueCtl().qualityIssue);
}
// trading partners or personse responsible can only add to the response list
if (IssueCtl().PageMode == PageUseMode.EditPartial)
{
if (!string.IsNullOrEmpty(uclResponse.ResponseInput.Trim()))
{
IssueCtl().qualityIssue.TeamResponse.CreateResponse(20, IssueCtl().qualityIssue.IssueOccur.QIO_ID, "", SessionManager.UserContext.Person.PERSON_ID, uclResponse.ResponseInput, SessionManager.UserContext.HRLocation.Company.COMPANY_NAME);
IssueCtl().qualityIssue.SetTasksStatus("R", TaskStatus.AwaitingClosure, SessionManager.UserContext.Person.PERSON_ID);
theIssue.Status = QualityIssue.UpdateStatus.Success;
return(theIssue = IssueCtl().qualityIssue);
}
}
if (radIssueDate.SelectedDate.HasValue == false ||
string.IsNullOrEmpty(ddlIncidentSeverity2.SelectedValue) ||
IssueCtl().qualityIssue.IssueOccur.PART_ID == null ||
IssueCtl().qualityIssue.IssueOccur.PART_ID < 1 ||
(theIssue.IssueOccur.QS_ACTIVITY == "CST" && string.IsNullOrEmpty(ddlPartType.SelectedValue) ||
string.IsNullOrEmpty(tbNCTotalQty.Text) ||
string.IsNullOrEmpty(tbNCSampleQty.Text) ||
string.IsNullOrEmpty(tbNCNonConformQty.Text) ||
string.IsNullOrEmpty(ddlResponsibleLocation.SelectedValue)))
{
theIssue.Status = QualityIssue.UpdateStatus.RequiredInputs;
return(theIssue);
}
if ((!string.IsNullOrEmpty(tbActCost.Text) || !string.IsNullOrEmpty(tbPotCost.Text)) && string.IsNullOrEmpty(ddlCurrency.SelectedValue))
{
theIssue.Status = QualityIssue.UpdateStatus.Incomplete;
return(theIssue);
}
// update the INCIDENT record
IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY = ddlIncidentType.SelectedValue;
IssueCtl().qualityIssue.Incident.INCIDENT_DT = (DateTime)radIssueDate.SelectedDate;
IssueCtl().qualityIssue.Incident.DESCRIPTION = tbIssueDesc.Text.Trim();
IssueCtl().qualityIssue.SetDetectedLocation(Convert.ToDecimal(ddlReportedLocation.SelectedValue));
IssueCtl().qualityIssue.SetResponsibleLocation(Convert.ToDecimal(ddlResponsibleLocation.SelectedValue));
IssueCtl().qualityIssue.IssueOccur.RELATED_PARTS = tbRelatedParts.Text;
if (!string.IsNullOrEmpty(ddlPartType.SelectedValue))
{
IssueCtl().qualityIssue.IssueOccur.PART_TYPE = ddlPartType.SelectedValue;
}
else
{
IssueCtl().qualityIssue.IssueOccur.PART_TYPE = null;
}
IssueCtl().qualityIssue.IssueOccur.SEVERITY = ddlIncidentSeverity2.SelectedValue;
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().LOT_NUM = tbNCLotNum.Text;
if (decimal.TryParse(tbNCTotalQty.Text.Trim(), out decVal))
{
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_QTY = decVal;
}
if (decimal.TryParse(tbNCSampleQty.Text.Trim(), out decVal))
{
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_QTY = decVal;
}
if (decimal.TryParse(tbNCNonConformQty.Text.Trim(), out decVal))
{
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_NC_QTY = decVal;
}
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_NC_QTY = (IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_NC_QTY / IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_QTY) * IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_QTY;
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().PROBLEM_AREA = "";
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().NONCONF_ID = null;
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().PROBLEM_COUNT = 0;
if (!string.IsNullOrEmpty(uclNC.ProblemArea))
{
IssueCtl().qualityIssue.IssueOccur.OCCUR_DESC = uclNC.ProblemAreaDesc;
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().PROBLEM_AREA = IssueCtl().qualityIssue.IssueOccur.PROBLEM_AREA = uclNC.ProblemArea;
if (!string.IsNullOrEmpty(uclNC.NCDefect))
{
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().NONCONF_ID = Convert.ToDecimal(uclNC.NCDefect);
int NCCount = 0;
if (int.TryParse(uclNC.NCCount, out NCCount) == true)
{
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().PROBLEM_COUNT = NCCount;
}
else
{
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().PROBLEM_COUNT = 1;
}
}
}
foreach (GridViewRow row in gvMeasureGrid.Rows)
{
try
{
QI_OCCUR_NC sample = IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.FirstOrDefault();
QI_OCCUR_MEASURE measure = sample.QI_OCCUR_MEASURE.FirstOrDefault();
if (sample != null && measure != null)
{
measure.QIO_SAMPLE_ID = sample.QIO_SAMPLE_ID;
measure.MEASURE_NUM = 1;
measure.MEASURE_NAME = ((TextBox)row.Cells[0].FindControl("tbMeasureName")).Text;
TextBox tb = (TextBox)row.Cells[0].FindControl("tbMeasureValue");
if (!string.IsNullOrEmpty(tb.Text))
{
measure.MEASURE_IND = true;
measure.MEASURE_VALUE = Convert.ToDecimal(tb.Text);
}
}
}
catch { }
}
IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().SAMPLE_COMMENTS = tbObservations.Text.Trim();
IssueCtl().qualityIssue.IssueOccur.DISPOSITION = ddlDisposition.SelectedValue;
IssueCtl().qualityIssue.IssueOccur.PROBCASE_REQD = cb8DRequired.Checked;
IssueCtl().qualityIssue.IssueOccur.REF_OPERATION = tb8DRef.Text;
if (IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY == "CST")
{
IssueCtl().qualityIssue.IssueOccur.REF_OPERATION = tb8DRef.Text;
}
else if (IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY == "RCV")
{
IssueCtl().qualityIssue.IssueOccur.REF_OPERATION = tbReceipt.Text;
}
else
{
IssueCtl().qualityIssue.IssueOccur.REF_OPERATION = "";
}
decimal value = 0;
if (!string.IsNullOrEmpty(tbActCost.Text) && decimal.TryParse(tbActCost.Text, out value))
{
IssueCtl().qualityIssue.IssueOccur.EST_ACT_COST = value;
IssueCtl().qualityIssue.IssueOccur.ACT_COST_COMMENT = tbActCostNote.Text;
}
else
{
IssueCtl().qualityIssue.IssueOccur.EST_ACT_COST = null;
IssueCtl().qualityIssue.IssueOccur.ACT_COST_COMMENT = "";
}
IssueCtl().qualityIssue.IssueOccur.CURRENCY_CODE = ddlCurrency.SelectedValue;
if (!string.IsNullOrEmpty(tbPotCost.Text) && decimal.TryParse(tbPotCost.Text, out value))
{
IssueCtl().qualityIssue.IssueOccur.EST_POT_COST = value;
IssueCtl().qualityIssue.IssueOccur.POT_COST_COMMENT = tbPotCostNote.Text;
}
else
{
IssueCtl().qualityIssue.IssueOccur.EST_POT_COST = null;
IssueCtl().qualityIssue.IssueOccur.POT_COST_COMMENT = "";
}
IssueCtl().qualityIssue.IssueOccur.RELATED_INCIDENTS = tbDupIssue.Text;
/*
* string[] args = uclQISearch1.Text.Split(' ');
* if (args.Length > 0 && !string.IsNullOrEmpty(args[0]) && args[0] != WebSiteCommon.FormatID(IssueCtl().qualityIssue.Incident.INCIDENT_ID, 6))
* IssueCtl().qualityIssue.IssueOccur.RELATED_INCIDENTS = args[0];
*/
// create person response tasks if not currently existing
IssueCtl().qualityIssue.IssueOccur.INIT_ACTION = null;
if (ddlResponsible.CheckedItems.Count > 0 && !string.IsNullOrEmpty(ddlResponseTime.SelectedValue))
{
IssueCtl().qualityIssue.IssueOccur.INIT_ACTION = ddlResponseTime.SelectedValue;
}
IssueCtl().qualityIssue.UpdateTasks(new decimal[1] {
(decimal)IssueCtl().qualityIssue.Incident.CREATE_PERSON
}, "C", 14, false);
IssueCtl().qualityIssue.ResponseRequired = cbResponseAlert.Checked;
IssueCtl().qualityIssue.UpdateTasks(Array.ConvertAll(ddlResponsible.Items.Where(l => l.Checked).Select(l => l.Value).ToArray(), new Converter <string, decimal>(decimal.Parse)),
"R", Convert.ToInt32(IssueCtl().qualityIssue.IssueOccur.INIT_ACTION), IssueCtl().qualityIssue.ResponseRequired);
if (!string.IsNullOrEmpty(uclResponse.ResponseInput.Trim()))
{
IssueCtl().qualityIssue.TeamResponse.CreateResponse(20, IssueCtl().qualityIssue.IssueOccur.QIO_ID, "", SessionManager.UserContext.Person.PERSON_ID, uclResponse.ResponseInput, SessionManager.UserContext.HRLocation.Company.COMPANY_NAME);
}
// complete all tasks when the issue is closed
if (IssueCtl().qualityIssue.IssueOccur.STATUS != ddlStatus.SelectedValue && ddlStatus.SelectedValue == "C")
{
IssueCtl().qualityIssue.SetTasksStatus("C", TaskStatus.Complete, SessionManager.UserContext.Person.PERSON_ID);
IssueCtl().qualityIssue.SetTasksStatus("R", TaskStatus.Complete, SessionManager.UserContext.Person.PERSON_ID);
IssueCtl().qualityIssue.StatusChanged = true;
}
IssueCtl().qualityIssue.IssueOccur.STATUS = ddlStatus.SelectedValue;
if (cbNotify.Checked) // td: to test mail functions
{
IssueCtl().qualityIssue.ResetIndicators(true);
IssueCtl().qualityIssue.StatusChanged = false;
}
//btnPrintLabel.OnClientClick = "Popup('../Quality/QualityIssue_Label.aspx?issue=" + qualityIssue.IssueOccur.QIO_ID.ToString() + "', 'newPage', 600, 450); return false;";
IssueCtl().qualityIssue.Status = QualityIssue.UpdateStatus.Success;
return(theIssue = IssueCtl().qualityIssue);
}
protected void SaveIssue()
{
bool success;
decimal decVal;
// update the INCIDENT record
qualityIssue.Incident.INCIDENT_DT = WebSiteCommon.ConvertDateFromString(tbDateDetected.Text, Convert.ToDateTime(WebSiteCommon.GetXlatValue("effDates", "MIN")));
qualityIssue.Incident.DESCRIPTION = tbIssueDesc.Text.Trim();
qualityIssue.Incident.COMPANY_ID = SessionManager.SessionContext.ActiveCompany().COMPANY_ID;
qualityIssue.Incident.BUS_ORG_ID = SessionManager.UserContext.BusinessOrg.BUS_ORG_ID;
qualityIssue.Incident.PLANT_ID = Convert.ToDecimal(ddlPlant.SelectedValue);
if (ddlPlantLine.SelectedIndex > -1)
{
qualityIssue.Incident.PLANT_LINE_ID = Convert.ToDecimal(ddlPlantLine.SelectedValue);
}
// QUALITY ISSUE records
qualityIssue.IssueOccur.PROBLEM_TYPE = ddlQualityIssueType.SelectedItem.Text;
qualityIssue.IssueOccur.SOURCE = rblSource.SelectedValue;
if (ddlCustomer.SelectedIndex > -1)
{
qualityIssue.IssueOccur.CUSTOMER_ID = Convert.ToDecimal(ddlCustomer.SelectedValue);
}
if (ddlCustomerPlant.SelectedIndex > -1)
{
qualityIssue.IssueOccur.CUSTOMER_PLANT_ID = Convert.ToDecimal(ddlCustomerPlant.SelectedValue);
}
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().LOT_NUM = tbNCLotNum.Text;
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().CONTAINER_NUM = tbNCContainer.Text;
if (decimal.TryParse(tbNCTotalQty.Text.Trim(), out decVal))
{
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_QTY = decVal;
}
if (decimal.TryParse(tbNCSampleQty.Text.Trim(), out decVal))
{
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_QTY = decVal;
}
if (decimal.TryParse(tbNCNonConformQty.Text.Trim(), out decVal))
{
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_NC_QTY = decVal;
}
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_NC_QTY = (qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_NC_QTY / qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_QTY) * qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_QTY;
int nrow = -1;
DropDownList ddl;
HiddenField hf;
foreach (GridViewRow row in gvQISamples.Rows)
{
++nrow;
ddl = (DropDownList)row.FindControl("ddlPrimaryNC");
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().PROBLEM_PRIMARY = ddl.SelectedItem.Text;
ddl = (DropDownList)row.FindControl("ddlSecondaryNC");
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().PROBLEM_SECONDARY = ddl.SelectedItem.Text;
TextBox tb = (TextBox)row.FindControl("tbNCCount");
int count = 1;
if (int.TryParse(tb.Text.Trim(), out count))
{
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().PROBLEM_COUNT = count;
}
hf = (HiddenField)row.FindControl("hfAttachmentID");
if (!String.IsNullOrEmpty(hf.Value))
{
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().ATTACHMENT_ID = Convert.ToInt32(hf.Value);
}
else
{
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().ATTACHMENT_ID = 0;
}
}
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_SAMPLE.First().SAMPLE_COMMENTS = tbObservations.Text.Trim();
qualityIssue.IssueOccur.DISPOSITION = ddlDisposition.SelectedValue;
qualityIssue.IssueOccur.RESPONSIBLE = rblResponsible.SelectedValue;
qualityIssue.IssueOccur.ACTION_REQD = cbActionRequired.Checked;
qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().ITEM_COMMENTS = tbComments.Text.Trim();
if (QualityIssue.AddIssue(qualityIssue) != null)
{
btnPrintLabel.OnClientClick = "Popup('../Problem/QualityIssue_Label.aspx?issue=" + qualityIssue.IssueOccur.QIO_ID.ToString() + "', 'newPage', 600, 450); return false;";
DisplayIssue();
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alertResult('hfAlertSaveSuccess');", true);
}
}
public PROB_DEFINE UpdateProblemDefinition(PROB_DEFINE prDefine)
{
foreach (INCIDENT incident in this.IncidentList)
{
if (this.ProbCase.PROBCASE_TYPE == "QI")
{
QualityIssue qualityIssue = new QualityIssue().Load(incident.INCIDENT_ID);
string str = "";
// who reported the problem
str = incident.CREATE_BY;
if (incident.CREATE_PERSON != null && incident.CREATE_PERSON > 0)
{
PERSON person = SQMModelMgr.LookupPerson((decimal)incident.CREATE_PERSON, "");
COMPANY company = SQMModelMgr.LookupCompany(person.COMPANY_ID);
str += " (" + company.COMPANY_NAME + ")";
}
if (string.IsNullOrEmpty(prDefine.WHO_IS) || !prDefine.WHO_IS.Contains(str))
{
if (!string.IsNullOrEmpty(prDefine.WHO_IS))
{
prDefine.WHO_IS += ", ";
}
prDefine.WHO_IS += str;
}
// where did the problem occur
str = qualityIssue.DetectedLocation.Company.COMPANY_NAME;
if (incident.DETECT_BUS_ORG_ID != null && incident.DETECT_BUS_ORG_ID > 0)
{
str += (" / " + qualityIssue.DetectedLocation.BusinessOrg.ORG_NAME);
}
if (incident.DETECT_PLANT_ID != null && incident.DETECT_PLANT_ID > 0)
{
str += (" / " + qualityIssue.DetectedLocation.Plant.PLANT_NAME);
}
if (string.IsNullOrEmpty(prDefine.WHERE_IS) || !prDefine.WHERE_IS.Contains(str))
{
if (!string.IsNullOrEmpty(prDefine.WHERE_IS))
{
prDefine.WHERE_IS += ", ";
}
prDefine.WHERE_IS += str;
}
// where detected
str = WebSiteCommon.GetXlatValueLong("issueResponsible", qualityIssue.IssueOccur.SOURCE);
if (string.IsNullOrEmpty(prDefine.DETECTED_IS) || !prDefine.DETECTED_IS.Contains(str))
{
if (!string.IsNullOrEmpty(prDefine.DETECTED_IS))
{
prDefine.DETECTED_IS += ", ";
}
prDefine.DETECTED_IS += str;
}
// who or where is impacted
if (!string.IsNullOrEmpty(prDefine.IMPACT_IS))
{
prDefine.IMPACT_IS += ", ";
}
prDefine.IMPACT_IS += WebSiteCommon.GetXlatValueLong("issueResponsible", qualityIssue.IssueOccur.SOURCE);
// when did the problem occur
str = WebSiteCommon.FormatDateString(WebSiteCommon.LocalTime(incident.INCIDENT_DT, SessionManager.UserContext.TimeZoneID), false);
if (string.IsNullOrEmpty(prDefine.WHEN_IS) || !prDefine.WHEN_IS.Contains(str))
{
if (!string.IsNullOrEmpty(prDefine.WHEN_IS))
{
prDefine.WHEN_IS += ", ";
}
prDefine.WHEN_IS += str;
}
// what is the problem
if (!string.IsNullOrEmpty(prDefine.WHAT_IS))
{
prDefine.WHAT_IS += ", ";
}
prDefine.WHAT_IS += (" " + qualityIssue.Partdata.Part.PART_NUM + "(" + qualityIssue.Partdata.Part.PART_NAME + ")");
// how many how often detected
double qty = 0;
if (!string.IsNullOrEmpty(prDefine.HOW_MANY))
{
qty = double.Parse(prDefine.HOW_MANY);
}
foreach (QI_OCCUR_ITEM item in qualityIssue.IssueOccur.QI_OCCUR_ITEM)
{
qty += Convert.ToDouble(item.INSPECT_NC_QTY);
foreach (QI_OCCUR_NC sample in item.QI_OCCUR_NC)
{
if (!string.IsNullOrEmpty(prDefine.NC_IS))
{
prDefine.NC_IS += ", ";
}
NONCONFORMANCE nc = SQMResourcesMgr.LookupNonconf(this.Entities, (decimal)sample.NONCONF_ID, "");
if (nc != null)
{
prDefine.NC_IS += (qualityIssue.IssueOccur.OCCUR_DESC + ": " + nc.NONCONF_DESC);
}
}
}
prDefine.HOW_MANY = qty.ToString();
str = qualityIssue.IssueOccur.OCCUR_DESC;
if (string.IsNullOrEmpty(prDefine.WHY_IS) || !prDefine.WHY_IS.Contains(str))
{
if (!string.IsNullOrEmpty(prDefine.WHY_IS))
{
prDefine.WHY_IS += ", ";
}
prDefine.WHY_IS += str;
}
prDefine.URGENT_IS = prDefine.MEASURE_IS = prDefine.OFTEN_IS = "TBD";
}
}
return(prDefine);
}
protected void DisplayIssue()
{
SetupPage();
if (ddlIncidentType.Items.FindItemByValue(IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY) != null)
{
SQMBasePage.DisplayControlValue(ddlIncidentType, IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY, PageUseMode.ViewOnly, "");
SelectActivityType(null, null);
trQIActivity.Visible = false;
switch (IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY)
{
case "CST":
trPartType.Visible = true;
ph8DRef.Visible = true; // external problem control system reference number
trReceipt.Visible = false;
break;
case "RCV":
trPartType.Visible = false;
ph8DRef.Visible = false;
trReceipt.Visible = true; // reference receipt or po number
break;
default:
trPartType.Visible = false;
ph8DRef.Visible = false;
trReceipt.Visible = false;
break;
}
}
tbTotalEstNCQty.ReadOnly = true;
QI_OCCUR_NC sample = IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.FirstOrDefault();
if (sample != null)
{
if (IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().NONCONF_ID.HasValue)
{
uclNC.Initialize(IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().PROBLEM_AREA,
(decimal)IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().NONCONF_ID,
(int)IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().PROBLEM_COUNT, IssueCtl().PageMode);
}
else
{
uclNC.Initialize("", 0, 0, IssueCtl().PageMode);
}
gvMeasureGrid.DataSource = sample.QI_OCCUR_MEASURE;
gvMeasureGrid.DataBind();
}
SetB2BLocation(Convert.ToDecimal(IssueCtl().qualityIssue.DetectedLocation.Plant.PLANT_ID.ToString()));
if (ddlReportedLocation.Items.FindItemByValue(IssueCtl().qualityIssue.DetectedLocation.Plant.PLANT_ID.ToString()) != null)
{
SQMBasePage.DisplayControlValue(ddlReportedLocation, IssueCtl().qualityIssue.DetectedLocation.Plant.PLANT_ID.ToString(), IssueCtl().PageMode, "textStd");
}
else
{
// add the reported location in case the viewing user doesn't have it assigned to him
BusinessLocation reportLoc = new BusinessLocation().Initialize(IssueCtl().qualityIssue.DetectedLocation.Plant.PLANT_ID);
if (reportLoc != null)
{
ddlReportedLocation.Items.Add(SQMBasePage.SetLocationItem(reportLoc, true));
SQMBasePage.DisplayControlValue(ddlReportedLocation, IssueCtl().qualityIssue.DetectedLocation.Plant.PLANT_ID.ToString(), IssueCtl().PageMode, "textStd");
}
}
ddlResponsibleLocation.Items.Clear();
if (IssueCtl().qualityIssue.Partdata.B2BList != null)
{
foreach (BusinessLocation loc in IssueCtl().qualityIssue.Partdata.B2BList)
{
ddlResponsibleLocation.Items.Add(SQMBasePage.SetLocationItem(loc, true));
}
// ddlResponsibleLocation.SelectedValue = qualityIssue.Incident.RESP_PLANT_ID.ToString();
SQMBasePage.DisplayControlValue(ddlResponsibleLocation, IssueCtl().qualityIssue.Incident.RESP_PLANT_ID.ToString(), IssueCtl().PageMode, "textStd");
}
if (IssueCtl().qualityIssue.Partdata != null && IssueCtl().qualityIssue.Partdata.Part != null)
{
SQMBasePage.DisplayControlValue(uclPartSearch1.PartTextBox, IssueCtl().qualityIssue.Partdata.PartDisplayNum(IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY), IssueCtl().PageMode, "textStd");
lblPartDesc.Text = IssueCtl().qualityIssue.Partdata.Part.PART_NAME;
SQMBasePage.DisplayControlValue(tbRelatedParts, IssueCtl().qualityIssue.IssueOccur.RELATED_PARTS, IssueCtl().PageMode, "textStd");
}
ddlDisposition.SelectedIndex = ddlStatus.SelectedIndex = 0;
if (IssueCtl().qualityIssue.IsNew)
{
cbNotify.Checked = true;
cbNotify.Enabled = false;
ddlResponseTime.SelectedIndex = 1;
}
else
{
cbNotify.Checked = false;
cbNotify.Enabled = true;
lblIssueDate_out.Text = SQMBasePage.FormatDate(WebSiteCommon.LocalTime((DateTime)IssueCtl().qualityIssue.Incident.CREATE_DT, SessionManager.UserContext.TimeZoneID), "d", false);
SQMBasePage.DisplayControlValue(radIssueDate, IssueCtl().qualityIssue.Incident.INCIDENT_DT.ToShortDateString(), IssueCtl().PageMode, "textStd");
SQMBasePage.DisplayControlValue(tbIssueDesc, IssueCtl().qualityIssue.Incident.DESCRIPTION, IssueCtl().PageMode, "textStd");
lblOriginator_out.Text = IssueCtl().qualityIssue.Incident.CREATE_BY;
SQMBasePage.DisplayControlValue(ddlIncidentSeverity2, IssueCtl().qualityIssue.IssueOccur.SEVERITY, IssueCtl().PageMode, "textStd");
SQMBasePage.DisplayControlValue(tbReceipt, IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY == "RCV" ? IssueCtl().qualityIssue.IssueOccur.REF_OPERATION : "", IssueCtl().PageMode, "textStd");
if (ddlPartType.Items.FindItemByValue(IssueCtl().qualityIssue.IssueOccur.PART_TYPE) != null)
{
SQMBasePage.DisplayControlValue(ddlPartType, IssueCtl().qualityIssue.IssueOccur.PART_TYPE, IssueCtl().PageMode, "textStd");
}
SQMBasePage.DisplayControlValue(tbNCLotNum, IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().LOT_NUM, IssueCtl().PageMode, "textStd");
try
{
SQMBasePage.DisplayControlValue(tbNCTotalQty, IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_QTY.ToString(), IssueCtl().PageMode, "textStd");
SQMBasePage.DisplayControlValue(tbNCSampleQty, IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_QTY.ToString(), IssueCtl().PageMode, "textStd");
SQMBasePage.DisplayControlValue(tbNCNonConformQty, IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().INSPECT_NC_QTY.ToString(), IssueCtl().PageMode, "textStd");
SQMBasePage.DisplayControlValue(tbTotalEstNCQty, Math.Round((decimal)IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().TOTAL_NC_QTY, 1).ToString(), IssueCtl().PageMode, "labelEmphasis");
lnkCalculateNC.Visible = IssueCtl().PageMode == PageUseMode.EditEnabled ? true : false;
lblCalculateNC.Visible = IssueCtl().PageMode == PageUseMode.EditEnabled ? false : true;
}
catch
{
tbNCTotalQty.Text = tbNCSampleQty.Text = tbNCNonConformQty.Text = tbTotalEstNCQty.Text = "";
}
SQMBasePage.DisplayControlValue(tbObservations, IssueCtl().qualityIssue.IssueOccur.QI_OCCUR_ITEM.First().QI_OCCUR_NC.First().SAMPLE_COMMENTS, IssueCtl().PageMode, "textStd");
cb8DRequired.Checked = (bool)(IssueCtl().qualityIssue.IssueOccur.PROBCASE_REQD.HasValue == true ? IssueCtl().qualityIssue.IssueOccur.PROBCASE_REQD : false);
if (IssueCtl().PageMode != PageUseMode.EditEnabled)
{
cb8DRequired.Enabled = phNotify.Visible = false;
}
SQMBasePage.DisplayControlValue(tb8DRef, IssueCtl().qualityIssue.IssueOccur.QS_ACTIVITY == "CST" && !string.IsNullOrEmpty(IssueCtl().qualityIssue.IssueOccur.REF_OPERATION) ? IssueCtl().qualityIssue.IssueOccur.REF_OPERATION : "", IssueCtl().PageMode, "refText");
SQMBasePage.DisplayControlValue(ddlDisposition, IssueCtl().qualityIssue.IssueOccur.DISPOSITION, IssueCtl().PageMode, "textStd");
if (IssueCtl().PageMode == PageUseMode.Active)
{
if (ddlStatus.Items.FindItemByValue(IssueCtl().qualityIssue.IssueOccur.STATUS) != null)
{
ddlStatus.SelectedValue = IssueCtl().qualityIssue.IssueOccur.STATUS;
}
}
else
{
SQMBasePage.DisplayControlValue(ddlStatus, IssueCtl().qualityIssue.IssueOccur.STATUS, IssueCtl().PageMode, "textStd");
}
if (ddlCurrency.Items.FindItemByValue(IssueCtl().qualityIssue.IssueOccur.CURRENCY_CODE) != null)
{
SQMBasePage.DisplayControlValue(ddlCurrency, IssueCtl().qualityIssue.IssueOccur.CURRENCY_CODE, IssueCtl().PageMode, "textStd");
}
SQMBasePage.DisplayControlValue(tbActCost, IssueCtl().qualityIssue.IssueOccur.EST_ACT_COST.HasValue ? SQMBasePage.FormatValue((decimal)IssueCtl().qualityIssue.IssueOccur.EST_ACT_COST, 2) : "", IssueCtl().PageMode, "textStd");
SQMBasePage.DisplayControlValue(tbActCostNote, IssueCtl().qualityIssue.IssueOccur.ACT_COST_COMMENT, IssueCtl().PageMode, "textStd");
SQMBasePage.DisplayControlValue(tbPotCost, IssueCtl().qualityIssue.IssueOccur.EST_POT_COST.HasValue ? SQMBasePage.FormatValue((decimal)IssueCtl().qualityIssue.IssueOccur.EST_POT_COST, 2) : "", IssueCtl().PageMode, "textStd");
SQMBasePage.DisplayControlValue(tbPotCostNote, IssueCtl().qualityIssue.IssueOccur.POT_COST_COMMENT, IssueCtl().PageMode, "textStd");
if (IssueCtl().PageMode == PageUseMode.EditEnabled)
{
uclRadAttach.SetReportOption(false);
uclRadAttach.GetUploadedFiles(20, IssueCtl().qualityIssue.Incident.INCIDENT_ID, "1");
}
else
{
Ucl_Attach attch = (Ucl_Attach)Page.LoadControl("/Include/Ucl_Attach.ascx");
uclRadAttach.Parent.Controls.AddAt(uclRadAttach.Parent.Controls.IndexOf(uclRadAttach), attch);
attch.BindDisplayAttachments(20, IssueCtl().qualityIssue.Incident.INCIDENT_ID, "1", 0);
uclRadAttach.Visible = false;
}
btnDupIncident.Visible = IssueCtl().PageMode == PageUseMode.EditEnabled ? true : false;
//uclQISearch1.Load(false);
if (!string.IsNullOrEmpty(IssueCtl().qualityIssue.IssueOccur.RELATED_INCIDENTS))
{
QualityIssue refIssue = new QualityIssue().Load(Convert.ToDecimal(IssueCtl().qualityIssue.IssueOccur.RELATED_INCIDENTS));
if (refIssue != null)
{
tbDupIssue.Text = IssueCtl().qualityIssue.IssueOccur.RELATED_INCIDENTS + " - " + refIssue.Incident.DESCRIPTION;
}
}
else
{
tbDupIssue.Text = "";
}
// determine selectable list of responsible persons based on the trading partner locations
GetResponsibleList();
if (ddlResponseTime.Items.FindItemByValue(IssueCtl().qualityIssue.IssueOccur.INIT_ACTION) != null)
{
SQMBasePage.DisplayControlValue(ddlResponseTime, IssueCtl().qualityIssue.IssueOccur.INIT_ACTION, IssueCtl().PageMode, "textStd");
}
// update the ddl based per selected persons in the task list
foreach (TASK_STATUS task in IssueCtl().qualityIssue.TeamTask.TaskList)
{
RadComboBoxItem resp = null;
if ((resp = ddlResponsible.FindItemByValue(task.RESPONSIBLE_ID.ToString())) != null)
{
resp.Checked = true;
}
}
if (IssueCtl().PageMode != PageUseMode.EditEnabled)
{
SQMBasePage.DisplayControlValue(ddlResponsible, "", IssueCtl().PageMode, "textSTd");
}
// btnPrintLabel.OnClientClick = "Popup('../Quality/QualityIssue_Label.aspx?issue=" + qualityIssue.IssueOccur.INCIDENT_ID.ToString() + "', 'newPage', 600, 450); return false;";
}
uclResponse.BindResponseList(IssueCtl().qualityIssue.TeamResponse.ResponseList, IssueCtl().PageMode == PageUseMode.EditEnabled || IssueCtl().PageMode == PageUseMode.EditPartial ? true : false, true);
lblIssueResponseCount.Text = IssueCtl().qualityIssue.TeamResponse.ResponseList.Count.ToString();
phResponseAlert.Visible = IssueCtl().PageMode == PageUseMode.EditEnabled ? true : false;
}
