public List <ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp_Spare> Search(ASSETKKF_MODEL.Request.Mcis.msWorkStationGrp_SpareReq d) { DynamicParameters param = new DynamicParameters(); /* * param.Add("@WorkStationGrpCdIsNull", d.WorkStationGrpCd.ListNull()); * param.Add("@WorkStationGrpCd_SpareIsNull", d.WorkStationGrpCd_Spare.ListNull()); * param.Add("@User_IdIsNull", d.User_Id.ListNull()); * param.Add("@User_dateIsNull", d.User_date.ListNull()); * param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%"); */ string cmd = ""; /* * string cmd = "SELECT * FROM mcis.dbo.msWorkStationGrp_Spare " + * $"WHERE (@WorkStationGrpCdIsNull IS NULL OR WorkStationGrpCd IN ('{ d.WorkStationGrpCd.Join("','") }')) " + * $"AND (@WorkStationGrpCd_SpareIsNull IS NULL OR WorkStationGrpCd_Spare IN ('{ d.WorkStationGrpCd_Spare.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 (WorkStationGrpCd LIKE @txtSearch OR WorkStationGrpCd LIKE @txtSearch) " + * //"ORDER BY ;"; */ var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp_Spare>(cmd, param).ToList(); return(res); }
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp_Spare> GetData(ASSETKKF_MODEL.Request.Mcis.msWorkStationGrp_SpareReq d) { DynamicParameters param = new DynamicParameters(); param.Add("@WorkStationGrpCd", d.WorkStationGrpCd); param.Add("@WorkStationGrpCd_Spare", d.WorkStationGrpCd_Spare); /* param.Add("@User_Id", d.User_Id); * param.Add("@User_date", d.User_date);*/ //param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%"); string cmd = "SELECT * FROM mcis.dbo.msWorkStationGrp_Spare " + $"WHERE (@WorkStationGrpCd IS NULL OR WorkStationGrpCd = @WorkStationGrpCd) " + $" AND (@WorkStationGrpCd_Spare IS NULL OR WorkStationGrpCd_Spare = @WorkStationGrpCd_Spare) " + /*$" AND (@User_Id IS NULL OR User_Id = @User_Id) " + * $" AND (@User_date IS NULL OR User_date = @User_date) " +*/ //$"AND (WorkStationGrpCd LIKE @txtSearch OR WorkStationGrpCd LIKE @txtSearch) " + $"ORDER BY WorkStationGrpCd;"; var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp_Spare>(cmd, param).ToList(); return(res); }