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();
}
}
