public List <ASSETKKF_MODEL.Data.Mssql.Mcis.mmStdSequence> GetData(ASSETKKF_MODEL.Request.Mcis.mmStdSequenceReq d)
{
DynamicParameters param = new DynamicParameters();
param.Add("@DrawingCd", d.DrawingCd);
/*
* param.Add("@SeqNo", d.SeqNo);
* param.Add("@WorkStationGrp", d.WorkStationGrp);
* param.Add("@TaskCode", d.TaskCode);
* param.Add("@WorkCenterCode", d.WorkCenterCode);
* param.Add("@MachCode", d.MachCode);
* param.Add("@SetupTime", d.SetupTime);
* param.Add("@NoOfMins", d.NoOfMins);
* param.Add("@ProductionRate", d.ProductionRate);
* param.Add("@UnitCode", d.UnitCode);
* param.Add("@TimeCode", d.TimeCode);
* param.Add("@CycleTime", d.CycleTime);
* param.Add("@LastUpdDt", d.LastUpdDt);
* param.Add("@LastUpdUser", d.LastUpdUser);
* param.Add("@SECM_NO", d.SECM_NO);
* param.Add("@Tm", d.Tm);
* param.Add("@USER_ID", d.USER_ID);
* param.Add("@USER_DATE", d.USER_DATE);
* param.Add("@RoutingDateSt", d.RoutingDateSt);
* param.Add("@RoutingDateEnd", d.RoutingDateEnd);
* param.Add("@NewFlag", d.NewFlag);
* //param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
*/
string cmd = "SELECT * FROM mcis.dbo.mmStdSequence " +
$"WHERE ISNULL(DrawingCd,'') = ISNULL(@DrawingCd,'') " +
/*$" AND (@SeqNo IS NULL OR SeqNo = @SeqNo) " +
* $" AND (@WorkStationGrp IS NULL OR WorkStationGrp = @WorkStationGrp) " +
* $" AND (@TaskCode IS NULL OR TaskCode = @TaskCode) " +
* $" AND (@WorkCenterCode IS NULL OR WorkCenterCode = @WorkCenterCode) " +
* $" AND (@MachCode IS NULL OR MachCode = @MachCode) " +
* $" AND (@SetupTime IS NULL OR SetupTime = @SetupTime) " +
* $" AND (@NoOfMins IS NULL OR NoOfMins = @NoOfMins) " +
* $" AND (@ProductionRate IS NULL OR ProductionRate = @ProductionRate) " +
* $" AND (@UnitCode IS NULL OR UnitCode = @UnitCode) " +
* $" AND (@TimeCode IS NULL OR TimeCode = @TimeCode) " +
* $" AND (@CycleTime IS NULL OR CycleTime = @CycleTime) " +
* $" AND (@LastUpdDt IS NULL OR LastUpdDt = @LastUpdDt) " +
* $" AND (@LastUpdUser IS NULL OR LastUpdUser = @LastUpdUser) " +
* $" AND (@SECM_NO IS NULL OR SECM_NO = @SECM_NO) " +
* $" AND (@Tm IS NULL OR Tm = @Tm) " +
* $" AND (@USER_ID IS NULL OR USER_ID = @USER_ID) " +
* $" AND (@USER_DATE IS NULL OR USER_DATE = @USER_DATE) " +
* $" AND (@RoutingDateSt IS NULL OR RoutingDateSt = @RoutingDateSt) " +
* $" AND (@RoutingDateEnd IS NULL OR RoutingDateEnd = @RoutingDateEnd) " +
* $" AND (@NewFlag IS NULL OR NewFlag = @NewFlag) " +*/
//$"AND (DrawingCd LIKE @txtSearch OR DrawingCd LIKE @txtSearch) " +
"ORDER BY DrawingCd;";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.mmStdSequence>(cmd, param).ToList();
return(res);
}
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.mmStdSequence> Search(ASSETKKF_MODEL.Request.Mcis.mmStdSequenceReq d)
{
DynamicParameters param = new DynamicParameters();
/*
* param.Add("@DrawingCdIsNull", d.DrawingCd.ListNull());
* param.Add("@SeqNoIsNull", d.SeqNo.ListNull());
* param.Add("@WorkStationGrpIsNull", d.WorkStationGrp.ListNull());
* param.Add("@TaskCodeIsNull", d.TaskCode.ListNull());
* param.Add("@WorkCenterCodeIsNull", d.WorkCenterCode.ListNull());
* param.Add("@MachCodeIsNull", d.MachCode.ListNull());
* param.Add("@SetupTimeIsNull", d.SetupTime.ListNull());
* param.Add("@NoOfMinsIsNull", d.NoOfMins.ListNull());
* param.Add("@ProductionRateIsNull", d.ProductionRate.ListNull());
* param.Add("@UnitCodeIsNull", d.UnitCode.ListNull());
* param.Add("@TimeCodeIsNull", d.TimeCode.ListNull());
* param.Add("@CycleTimeIsNull", d.CycleTime.ListNull());
* param.Add("@LastUpdDtIsNull", d.LastUpdDt.ListNull());
* param.Add("@LastUpdUserIsNull", d.LastUpdUser.ListNull());
* param.Add("@SECM_NOIsNull", d.SECM_NO.ListNull());
* param.Add("@TmIsNull", d.Tm.ListNull());
* param.Add("@USER_IDIsNull", d.USER_ID.ListNull());
* param.Add("@USER_DATEIsNull", d.USER_DATE.ListNull());
* param.Add("@RoutingDateStIsNull", d.RoutingDateSt.ListNull());
* param.Add("@RoutingDateEndIsNull", d.RoutingDateEnd.ListNull());
* param.Add("@NewFlagIsNull", d.NewFlag.ListNull());
* param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
*/
string cmd = "";
/*
* string cmd = "SELECT * FROM mcis.dbo.mmStdSequence " +
* $"WHERE (@DrawingCdIsNull IS NULL OR DrawingCd IN ('{ d.DrawingCd.Join("','") }')) " +
* $"AND (@SeqNoIsNull IS NULL OR SeqNo IN ('{ d.SeqNo.Join("','") }')) " +
* $"AND (@WorkStationGrpIsNull IS NULL OR WorkStationGrp IN ('{ d.WorkStationGrp.Join("','") }')) " +
* $"AND (@TaskCodeIsNull IS NULL OR TaskCode IN ('{ d.TaskCode.Join("','") }')) " +
* $"AND (@WorkCenterCodeIsNull IS NULL OR WorkCenterCode IN ('{ d.WorkCenterCode.Join("','") }')) " +
* $"AND (@MachCodeIsNull IS NULL OR MachCode IN ('{ d.MachCode.Join("','") }')) " +
* $"AND (@SetupTimeIsNull IS NULL OR SetupTime IN ('{ d.SetupTime.Join("','") }')) " +
* $"AND (@NoOfMinsIsNull IS NULL OR NoOfMins IN ('{ d.NoOfMins.Join("','") }')) " +
* $"AND (@ProductionRateIsNull IS NULL OR ProductionRate IN ('{ d.ProductionRate.Join("','") }')) " +
* $"AND (@UnitCodeIsNull IS NULL OR UnitCode IN ('{ d.UnitCode.Join("','") }')) " +
* $"AND (@TimeCodeIsNull IS NULL OR TimeCode IN ('{ d.TimeCode.Join("','") }')) " +
* $"AND (@CycleTimeIsNull IS NULL OR CycleTime IN ('{ d.CycleTime.Join("','") }')) " +
* $"AND (@LastUpdDtIsNull IS NULL OR LastUpdDt IN ('{ d.LastUpdDt.Join("','") }')) " +
* $"AND (@LastUpdUserIsNull IS NULL OR LastUpdUser IN ('{ d.LastUpdUser.Join("','") }')) " +
* $"AND (@SECM_NOIsNull IS NULL OR SECM_NO IN ('{ d.SECM_NO.Join("','") }')) " +
* $"AND (@TmIsNull IS NULL OR Tm IN ('{ d.Tm.Join("','") }')) " +
* $"AND (@USER_IDIsNull IS NULL OR USER_ID IN ('{ d.USER_ID.Join("','") }')) " +
* $"AND (@USER_DATEIsNull IS NULL OR USER_DATE IN ('{ d.USER_DATE.Join("','") }')) " +
* $"AND (@RoutingDateStIsNull IS NULL OR RoutingDateSt IN ('{ d.RoutingDateSt.Join("','") }')) " +
* $"AND (@RoutingDateEndIsNull IS NULL OR RoutingDateEnd IN ('{ d.RoutingDateEnd.Join("','") }')) " +
* $"AND (@NewFlagIsNull IS NULL OR NewFlag IN ('{ d.NewFlag.Join("','") }')) " +
* $"AND (DrawingCd LIKE @txtSearch OR DrawingCd LIKE @txtSearch) " +
* //"ORDER BY ;";
*/
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.mmStdSequence>(cmd, param).ToList();
return(res);
}
