public void Initialize(string problemArea, decimal nonconfID, int ncCount, PageUseMode mode) { pageMode = mode; FillLists(true, false); if (!string.IsNullOrEmpty(problemArea)) { //ddlProblemArea.SelectedValue = problemArea; SQMBasePage.DisplayControlValue(ddlProblemArea, problemArea, pageMode, "textStd"); FillLists(false, true); if (nonconfID > 0) { NONCONFORMANCE nconf = SQMResourcesMgr.LookupNonconf(new PSsqmEntities(), nonconfID, ""); if (nconf != null && ddlNCCategory.Items.FindItemByValue(nconf.NONCONF_CATEGORY) != null) { // ddlNCCategory.SelectedValue = nconf.NONCONF_CATEGORY; SQMBasePage.DisplayControlValue(ddlNCCategory, nconf.NONCONF_CATEGORY, pageMode, "textStd"); SelectNCCategory(null, null); // ddlNC.SelectedValue = nconf.NONCONF_ID.ToString(); SQMBasePage.DisplayControlValue(ddlNC, nconf.NONCONF_ID.ToString(), pageMode, "textStd"); // tbCount.Text = ncCount.ToString(); SQMBasePage.DisplayControlValue(tbCount, ncCount.ToString(), pageMode, "textStd"); } } } }
public static NONCONFORMANCE UpdateNonconf(SQM.Website.PSsqmEntities ctx, NONCONFORMANCE nonconf, string updateBy) { try { nonconf = (NONCONFORMANCE)SQMModelMgr.SetObjectTimestamp((object)nonconf, updateBy, nonconf.EntityState); if (nonconf.EntityState == EntityState.Detached || nonconf.EntityState == EntityState.Added) { ctx.AddToNONCONFORMANCE(nonconf); } if (nonconf.STATUS == "D") { ctx.DeleteObject(nonconf); } ctx.SaveChanges(); } catch (Exception e) { //SQMLogger.LogException(e); } return(nonconf); }
public static NONCONFORMANCE LookupNonconf(SQM.Website.PSsqmEntities ctx, decimal nonconfID, string nonconfCode) { NONCONFORMANCE nonconf = null; try { if (nonconfID == 0) { nonconf = (from m in ctx.NONCONFORMANCE where (m.NONCONF_CD.ToUpper() == nonconfCode.ToUpper()) select m).SingleOrDefault(); if (nonconf == null) { nonconf = (from m in ctx.NONCONFORMANCE where (m.NONCONF_NAME.ToUpper() == nonconfCode.ToUpper()) select m).SingleOrDefault(); } } else { nonconf = (from m in ctx.NONCONFORMANCE where (m.NONCONF_ID == nonconfID) select m).SingleOrDefault(); } } catch { } return(nonconf); }
protected void lnkNonconfList_Click(object sender, EventArgs e) { LinkButton lnk = (LinkButton)sender; decimal nonconfID = Convert.ToDecimal(lnk.CommandArgument.ToString().Trim()); BindNonconf((staticNonconf = nonconfList.FirstOrDefault(l => l.NONCONF_ID == nonconfID))); lblAddNonconf.Visible = true; }
public void SetAttributeRef(QSAttribute atrType) { switch (atrType) { case QSAttribute.QS_ACTIVITY: this.Calc.AttributeXref = WebSiteCommon.GetXlatList("qualityActivity", "", "short"); break; case QSAttribute.PROBLEM_AREA: this.Calc.AttributeXref = WebSiteCommon.GetXlatList("problemArea", "", "short"); break; case QSAttribute.NONCONF_CATEGORY: this.NCCategoryList = SQMResourcesMgr.SelectNonconfCategoryList(""); string[] catList = this.RecordList.Where(r => r.Nonconform != null && !string.IsNullOrEmpty(r.Nonconform.NONCONF_CATEGORY)).Select(r => r.Nonconform.NONCONF_CATEGORY).Distinct().ToArray(); this.Calc.AttributeXref = new Dictionary <string, string>(); foreach (string cat in catList) { NONCONFORMANCE nc = this.NCCategoryList.Where(l => l.NONCONF_CD == cat).FirstOrDefault(); this.Calc.AttributeXref.Add(nc.NONCONF_CD.ToString(), nc.NONCONF_NAME); } break; case QSAttribute.NONCONF_ID: this.NonConfList = this.RecordList.Where(r => r.Nonconform != null).Select(r => r.Nonconform).Distinct().ToList(); this.Calc.AttributeXref = new Dictionary <string, string>(); foreach (NONCONFORMANCE nc in this.NonConfList) { this.Calc.AttributeXref.Add(nc.NONCONF_ID.ToString(), nc.NONCONF_NAME); } break; case QSAttribute.DISPOSITION: this.Calc.AttributeXref = WebSiteCommon.GetXlatList("NCDisposition", "", "short"); break; case QSAttribute.SEVERITY: this.Calc.AttributeXref = WebSiteCommon.GetXlatList("incidentSeverity", "", "short"); break; case QSAttribute.PART_TYPE: this.Calc.AttributeXref = new Dictionary <string, string>(); foreach (PART_ATTRIBUTE pat in SQMModelMgr.SelectPartAttributeList("TYPE", "", false)) { this.Calc.AttributeXref.Add(pat.ATTRIBUTE_CD, pat.ATTRIBUTE_VALUE); } break; default: break; } return; }
protected void btnNonconfSave_Click(object sender, EventArgs e) { bool success; if (hfOper.Value == "add") { staticNonconf = new NONCONFORMANCE(); staticNonconf.COMPANY_ID = SessionManager.UserContext.HRLocation.Company.COMPANY_ID; staticNonconf.STATUS = "A"; } else { staticNonconf = SQMResourcesMgr.LookupNonconf(entities, staticNonconf.NONCONF_ID, ""); } btnNonconfSave.Enabled = false; hfOper.Value = ""; staticNonconf.PROBLEM_AREA = ddlProblemArea.SelectedValue; staticNonconf.NONCONF_CATEGORY = ddlNonconfCategory.SelectedValue; staticNonconf.NONCONF_CD = tbNonconfCode.Text; staticNonconf.NONCONF_NAME = tbNonconfName.Text; staticNonconf.NONCONF_DESC = tbNonconfDesc.Text; staticNonconf.STATUS = ddlNonconfStatus.SelectedValue; if ((staticNonconf = SQMResourcesMgr.UpdateNonconf(entities, staticNonconf, SessionManager.UserContext.UserName())) != null) { NONCONFORMANCE nonconf = null; if ((nonconf = nonconfList.FirstOrDefault(l => l.NONCONF_ID == staticNonconf.NONCONF_ID)) == null) { nonconfList.Add(staticNonconf); } else { if (staticNonconf.EntityState == System.Data.EntityState.Detached || staticNonconf.EntityState == System.Data.EntityState.Deleted) { nonconfList.Remove(nonconf); } else { nonconf = (NONCONFORMANCE)SQMModelMgr.CopyObjectValues(nonconf, staticNonconf, false); } } BindNonconfList(nonconfList); } }
public int BindNonconf(NONCONFORMANCE nonconf) { int status = 0; if (nonconf != null) { tbNonconfCode.Text = nonconf.NONCONF_CD; tbNonconfName.Text = nonconf.NONCONF_NAME; tbNonconfDesc.Text = nonconf.NONCONF_DESC; ddlNonconfCategory.SelectedValue = nonconf.NONCONF_CATEGORY; SQMBasePage.SetStatusList(ddlNonconfStatus, nonconf.STATUS); pnlNonconfEdit.Enabled = btnNonconfCancel.Enabled = btnNonconfSave.Enabled = true; } return(status); }
protected void btnNonconfCatSave_Click(object sender, EventArgs e) { bool success; NONCONFORMANCE nonconfCat = null; if (!string.IsNullOrEmpty(tbNonconfCategoryCode.Text)) { nonconfCat = new NONCONFORMANCE(); nonconfCat.NONCONF_CD = tbNonconfCategoryCode.Text; nonconfCat.NONCONF_NAME = nonconfCat.NONCONF_DESC = tbNonconfCategoryName.Text; nonconfCat.STATUS = "A"; nonconfCat.PROBLEM_AREA = ddlProblemArea.SelectedValue; if ((nonconfCat = SQMResourcesMgr.UpdateNonconf(entities, nonconfCat, SessionManager.UserContext.UserName())) != null) { categoryList.Add(nonconfCat); BindNonconfList(nonconfList); BindCategoryList(); } } }
public void gvList_OnNonconfCatRowDataBound(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 { Label lbl = (Label)e.Row.Cells[0].FindControl("lblNonconfCat"); HiddenField hf = (HiddenField)e.Row.Cells[0].FindControl("hfNonconfCat"); NONCONFORMANCE nonconf = categoryList.FirstOrDefault(l => l.NONCONF_CD == hf.Value); if (nonconf != null) { lbl.Text = nonconf.NONCONF_NAME; } GridView gv = (GridView)e.Row.Cells[0].FindControl("gvNonconfList"); gv.DataSource = nonconfList.Where(l => l.NONCONF_CATEGORY == hf.Value).ToList(); gv.DataBind(); } catch (Exception ex) { ; } } }
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); }