public List <ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp> GetData(ASSETKKF_MODEL.Request.Mcis.msWorkStationGrpReq d) { DynamicParameters param = new DynamicParameters(); param.Add("@WorkStationGrpCd", d.WorkStationGrpCd); param.Add("@ExtGrp_Flag", d.ExtGrp_Flag); param.Add("@MulEmp_flag", d.MulEmp_flag); /* * param.Add("@WorkStationGrpNm", d.WorkStationGrpNm); * param.Add("@DLCost", d.DLCost); * param.Add("@FOHCost", d.FOHCost); * param.Add("@MDCost", d.MDCost); * param.Add("@WorkStationCD", d.WorkStationCD); * param.Add("@LastUpdUsr", d.LastUpdUsr); * param.Add("@LastUpdDt", d.LastUpdDt); * param.Add("@UnionDLCost", d.UnionDLCost); * param.Add("@WorkStationNM", d.WorkStationNM); * param.Add("@MulEmp_flag", d.MulEmp_flag); * * param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%"); */ string cmd = "SELECT * FROM mcis.dbo.msWorkStationGrp " + $"WHERE ISNULL(WorkStationGrpCd,'') = ISNULL(@WorkStationGrpCd,'') " + $" AND (@ExtGrp_Flag IS NULL OR ExtGrp_Flag = @ExtGrp_Flag) " + $" AND (@MulEmp_flag IS NULL OR MulEmp_flag = @MulEmp_flag) " + /*$" AND (@WorkStationGrpNm IS NULL OR WorkStationGrpNm = @WorkStationGrpNm) " + * $" AND (@DLCost IS NULL OR DLCost = @DLCost) " + * $" AND (@FOHCost IS NULL OR FOHCost = @FOHCost) " + * $" AND (@MDCost IS NULL OR MDCost = @MDCost) " + * $" AND (@WorkStationCD IS NULL OR WorkStationCD = @WorkStationCD) " + * $" AND (@LastUpdUsr IS NULL OR LastUpdUsr = @LastUpdUsr) " + * $" AND (@LastUpdDt IS NULL OR LastUpdDt = @LastUpdDt) " + * $" AND (@UnionDLCost IS NULL OR UnionDLCost = @UnionDLCost) " + * $" AND (@WorkStationNM IS NULL OR WorkStationNM = @WorkStationNM) " + * * * //$"AND (WorkStationGrpCd LIKE @txtSearch OR WorkStationGrpCd LIKE @txtSearch) " + */ "ORDER BY WorkStationGrpCd;"; var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp>(cmd, param).ToList(); return(res); }
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp> Search(ASSETKKF_MODEL.Request.Mcis.msWorkStationGrpReq d) { DynamicParameters param = new DynamicParameters(); /* * param.Add("@WorkStationGrpCdIsNull", d.WorkStationGrpCd.ListNull()); * param.Add("@WorkStationGrpNmIsNull", d.WorkStationGrpNm.ListNull()); * param.Add("@DLCostIsNull", d.DLCost.ListNull()); * param.Add("@FOHCostIsNull", d.FOHCost.ListNull()); * param.Add("@MDCostIsNull", d.MDCost.ListNull()); * param.Add("@WorkStationCDIsNull", d.WorkStationCD.ListNull()); * param.Add("@LastUpdUsrIsNull", d.LastUpdUsr.ListNull()); * param.Add("@LastUpdDtIsNull", d.LastUpdDt.ListNull()); * param.Add("@UnionDLCostIsNull", d.UnionDLCost.ListNull()); * param.Add("@WorkStationNMIsNull", d.WorkStationNM.ListNull()); * param.Add("@MulEmp_flagIsNull", d.MulEmp_flag.ListNull()); * param.Add("@ExtGrp_FlagIsNull", d.ExtGrp_Flag.ListNull()); * param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%"); */ string cmd = ""; /* * string cmd = "SELECT * FROM mcis.dbo.msWorkStationGrp " + * $"WHERE (@WorkStationGrpCdIsNull IS NULL OR WorkStationGrpCd IN ('{ d.WorkStationGrpCd.Join("','") }')) " + * $"AND (@WorkStationGrpNmIsNull IS NULL OR WorkStationGrpNm IN ('{ d.WorkStationGrpNm.Join("','") }')) " + * $"AND (@DLCostIsNull IS NULL OR DLCost IN ('{ d.DLCost.Join("','") }')) " + * $"AND (@FOHCostIsNull IS NULL OR FOHCost IN ('{ d.FOHCost.Join("','") }')) " + * $"AND (@MDCostIsNull IS NULL OR MDCost IN ('{ d.MDCost.Join("','") }')) " + * $"AND (@WorkStationCDIsNull IS NULL OR WorkStationCD IN ('{ d.WorkStationCD.Join("','") }')) " + * $"AND (@LastUpdUsrIsNull IS NULL OR LastUpdUsr IN ('{ d.LastUpdUsr.Join("','") }')) " + * $"AND (@LastUpdDtIsNull IS NULL OR LastUpdDt IN ('{ d.LastUpdDt.Join("','") }')) " + * $"AND (@UnionDLCostIsNull IS NULL OR UnionDLCost IN ('{ d.UnionDLCost.Join("','") }')) " + * $"AND (@WorkStationNMIsNull IS NULL OR WorkStationNM IN ('{ d.WorkStationNM.Join("','") }')) " + * $"AND (@MulEmp_flagIsNull IS NULL OR MulEmp_flag IN ('{ d.MulEmp_flag.Join("','") }')) " + * $"AND (@ExtGrp_FlagIsNull IS NULL OR ExtGrp_Flag IN ('{ d.ExtGrp_Flag.Join("','") }')) " + * $"AND (WorkStationGrpCd LIKE @txtSearch OR WorkStationGrpCd LIKE @txtSearch) " + * //"ORDER BY ;"; */ var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp>(cmd, param).ToList(); return(res); }