public List <PROCESS_SHEET> GetProcessSheetDetailsByPartNumber(PROCESS_SHEET paramEntity = null) { List <PROCESS_SHEET> lstEntity = null; try { if (!DB.IsNotNullOrEmpty()) { return(lstEntity); } if (paramEntity.IsNotNullOrEmpty() && paramEntity.PART_NO.IsNotNullOrEmpty()) { lstEntity = (from row in DB.PROCESS_SHEET where row.PART_NO == paramEntity.PART_NO orderby row.SEQ_NO select row).ToList <PROCESS_SHEET>(); } else { lstEntity = (from row in DB.PROCESS_SHEET orderby row.SEQ_NO select row).ToList <PROCESS_SHEET>(); } if (paramEntity.IsNotNullOrEmpty() && paramEntity.ROUTE_NO.IsNotNullOrEmpty() && lstEntity.IsNotNullOrEmpty()) { lstEntity = (from row in lstEntity.AsEnumerable() where row.PART_NO == paramEntity.PART_NO && row.ROUTE_NO == paramEntity.ROUTE_NO orderby row.SEQ_NO select row).ToList <PROCESS_SHEET>(); } } catch (Exception ex) { ex.LogException(); } return(lstEntity); }
public bool GetSequenceNoDetailsByPartNoRouteNo(PCCSModel pccsModel, string partNo, decimal routeNo) { try { DataTable dt = new DataTable(); if (partNo.IsNotNullOrEmpty()) { dt = ToDataTable((from o in DB.PROCESS_SHEET where o.PART_NO == partNo && o.ROUTE_NO == routeNo && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) select new { o.SEQ_NO, o.OPN_DESC }).ToList()); } if (dt != null) { pccsModel.SeqNoDetails = dt.DefaultView; try { if (pccsModel.SeqNoDetails.IsNotNullOrEmpty()) { if (pccsModel.SeqNoDetails.Table.Columns.IndexOf("SnoSort") < 0) { pccsModel.SeqNoDetails.Table.Columns.Add("SnoSort", typeof(decimal)); } for (int i = 0; i < pccsModel.SeqNoDetails.Count; i++) { pccsModel.SeqNoDetails[i]["SnoSort"] = pccsModel.SeqNoDetails[i]["SEQ_NO"]; } pccsModel.SeqNoDetails.Sort = "SnoSort ASC"; foreach (DataRowView item in pccsModel.SeqNoDetails) { item["SnoSort"] = item["SEQ_NO"]; } pccsModel.SeqNoDetails.Sort = "SnoSort ASC"; } } catch (Exception ex) { ex.LogException(); } PROCESS_SHEET procesSheet = (from o in DB.PROCESS_SHEET where o.PART_NO == partNo && o.ROUTE_NO == routeNo && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) //where o.PART_NO == partNo && o.ROUTE_NO == routeNo && o.SEQ_NO == 20 && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) select o).FirstOrDefault <PROCESS_SHEET>(); if (procesSheet.IsNotNullOrEmpty()) { pccsModel.SeqNo = procesSheet.SEQ_NO.ToValueAsString(); pccsModel.OperDesc = procesSheet.OPN_DESC.ToValueAsString(); } else { if (pccsModel.SeqNoDetails.Count > 0) { pccsModel.SeqNo = pccsModel.SeqNoDetails.Table.Rows[0]["SEQ_NO"].ToString(); pccsModel.OperDesc = pccsModel.SeqNoDetails.Table.Rows[0]["OPN_DESC"].ToString(); } } // pccsModel.SeqNoDetails.AddNew(); } else { pccsModel.SeqNoDetails = null; } return(true); } catch (Exception ex) { ex.LogException(); return(false); } }
public bool GetCPGAvailable(CPGModel cpgModel) { try { PROCESS_SHEET process_sheet = new PROCESS_SHEET(); try { // select opn_cd,opn_desc from process_sheet process_sheet = (from o in DB.PROCESS_SHEET where o.PART_NO == cpgModel.PartNo && o.SEQ_NO == cpgModel.SeqNo && o.ROUTE_NO == cpgModel.RouteNo select o).FirstOrDefault <PROCESS_SHEET>(); if (process_sheet.IsNotNullOrEmpty()) { cpgModel.OperCode = process_sheet.OPN_CD; cpgModel.OperDesc = process_sheet.OPN_DESC; } } catch (Exception ex) { ex.LogException(); process_sheet = null; cpgModel.OperCode = 0; cpgModel.OperDesc = ""; } DataTable dt = new DataTable(); DataSet dsMaster = new DataSet(); decimal sno = 0; if (cpgModel.OperCode == 1020 || cpgModel.OperCode == 1030 || cpgModel.OperCode == 1040) { List <StringBuilder> sbSQL = new List <StringBuilder>(); try { List <FEATURE_MASTER> featureDetails = new List <FEATURE_MASTER>(); sbSQL.Add(new StringBuilder("select ROW_NUMBER() OVER(ORDER BY feature_desc asc) AS SNO,* from (select distinct M.FEATURE_CODE,FEATURE_DESC,MEASURING_TECHNIQUE,SAMPLE_SIZE,SAMPLE_FREQUENCY, CONTROL_METHOD,REACTION_PLAN FROM FEATURE_MASTER M,FORGING_MASTER D,PRD_MAST P WHERE M.FEATURE_CODE=D.FEATURE_CODE AND ( P.TYPE =D.PRD_CODE OR P.HEAD_STYLE =D.PRD_CODE OR P.APPLICATION=D.PRD_CODE OR P.PRD_CLASS_CD =D.PRD_CODE OR P.PRD_GRP_CD =D.PRD_CODE OR P.ADDL_FEATURE=D.PRD_CODE OR P.KEYWORDS = D.PRD_CODE ) AND PART_NO='" + cpgModel.PartNo + "') sf order by feature_desc ")); dsMaster = Dal.GetDataSet(sbSQL); if (dsMaster.Tables[0] != null) { cpgModel.AvailableCharacteristcsDetails = dsMaster.Tables[0].DefaultView; } else { cpgModel.AvailableCharacteristcsDetails = null; } } catch (Exception ex) { throw ex.LogException(); } } else { List <FEATURE_MASTER> lstFEATURE_MASTER = (from o in DB.FEATURE_MASTER where o.OPER_CODE == cpgModel.OperCode && ((Convert.ToBoolean(Convert.ToInt16(o.DELETE_FLAG)) == false) || (o.DELETE_FLAG == null)) orderby o.FEATURE_DESC ascending select o).Distinct().ToList(); dt = lstFEATURE_MASTER.Select((o, index) => new FEATURE_MASTER() { SNO = ++sno, FEATURE_CODE = o.FEATURE_CODE, FEATURE_DESC = o.FEATURE_DESC, MEASURING_TECHNIQUE = o.MEASURING_TECHNIQUE, SAMPLE_SIZE = o.SAMPLE_SIZE, SAMPLE_FREQUENCY = o.SAMPLE_FREQUENCY, CONTROL_METHOD = o.CONTROL_METHOD, REACTION_PLAN = o.REACTION_PLAN }).ToList().ToDataTable <FEATURE_MASTER>(); //, o.FEATURE_CODE, o.FEATURE_DESC, o.MEASURING_TECHNIQUE, o.SAMPLE_SIZE, o.SAMPLE_FREQUENCY, o.CONTROL_METHOD, o.REACTION_PLAN if (dt != null) { cpgModel.AvailableCharacteristcsDetails = dt.DefaultView; } else { cpgModel.AvailableCharacteristcsDetails = null; } } if (cpgModel.AvailableCharacteristcsDetails.IsNotNullOrEmpty()) { DataTable dtTemp = new DataTable(); dtTemp = cpgModel.AvailableCharacteristcsDetails.Table.Clone(); for (int i = 0; i < cpgModel.AvailableCharacteristcsDetails.Table.Rows.Count; i++) { dtTemp.DefaultView.RowFilter = "FEATURE_DESC='" + cpgModel.AvailableCharacteristcsDetails[i]["FEATURE_DESC"] + "'"; if (dtTemp.DefaultView.Count == 0) { dtTemp.ImportRow(cpgModel.AvailableCharacteristcsDetails[i].Row); dtTemp.Rows[dtTemp.Rows.Count - 1]["SNO"] = dtTemp.Rows.Count; } dtTemp.DefaultView.RowFilter = string.Empty; } cpgModel.AvailableCharacteristcsDetails = dtTemp.DefaultView; } return(true); } catch (Exception ex) { throw ex.LogException(); } }