public List <ASSETKKF_MODEL.Data.Mssql.Mcis.ViewWorkOrderD> Search(ASSETKKF_MODEL.Request.Mcis.ViewWorkOrderDReq d) { DynamicParameters param = new DynamicParameters(); /* * param.Add("@QtyAmtIsNull", d.QtyAmt.ListNull()); * param.Add("@ItemCodeIsNull", d.ItemCode.ListNull()); * param.Add("@ItemNameIsNull", d.ItemName.ListNull()); * param.Add("@WorkOrderIDIsNull", d.WorkOrderID.ListNull()); * param.Add("@MatItemCdIsNull", d.MatItemCd.ListNull()); * param.Add("@MatTypeIsNull", d.MatType.ListNull()); * param.Add("@MatUnitCdIsNull", d.MatUnitCd.ListNull()); * param.Add("@MatSize1IsNull", d.MatSize1.ListNull()); * param.Add("@MatSize2IsNull", d.MatSize2.ListNull()); * param.Add("@MatQtyIsNull", d.MatQty.ListNull()); * param.Add("@CrtReqDocFlgIsNull", d.CrtReqDocFlg.ListNull()); * param.Add("@AppvNoIsNull", d.AppvNo.ListNull()); * param.Add("@AppvSeqNoIsNull", d.AppvSeqNo.ListNull()); * param.Add("@SumQtyIsNull", d.SumQty.ListNull()); * param.Add("@PUR_FLAGIsNull", d.PUR_FLAG.ListNull()); * param.Add("@NOTPUR_FLAGIsNull", d.NOTPUR_FLAG.ListNull()); * param.Add("@CALCOST_FLAGIsNull", d.CALCOST_FLAG.ListNull()); * param.Add("@NOTCALCOST_FLAGIsNull", d.NOTCALCOST_FLAG.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.vWorkOrderD_FAR " + * $"WHERE (@QtyAmtIsNull IS NULL OR QtyAmt IN ('{ d.QtyAmt.Join("','") }')) " + * $"AND (@ItemCodeIsNull IS NULL OR ItemCode IN ('{ d.ItemCode.Join("','") }')) " + * $"AND (@ItemNameIsNull IS NULL OR ItemName IN ('{ d.ItemName.Join("','") }')) " + * $"AND (@WorkOrderIDIsNull IS NULL OR WorkOrderID IN ('{ d.WorkOrderID.Join("','") }')) " + * $"AND (@MatItemCdIsNull IS NULL OR MatItemCd IN ('{ d.MatItemCd.Join("','") }')) " + * $"AND (@MatTypeIsNull IS NULL OR MatType IN ('{ d.MatType.Join("','") }')) " + * $"AND (@MatUnitCdIsNull IS NULL OR MatUnitCd IN ('{ d.MatUnitCd.Join("','") }')) " + * $"AND (@MatSize1IsNull IS NULL OR MatSize1 IN ('{ d.MatSize1.Join("','") }')) " + * $"AND (@MatSize2IsNull IS NULL OR MatSize2 IN ('{ d.MatSize2.Join("','") }')) " + * $"AND (@MatQtyIsNull IS NULL OR MatQty IN ('{ d.MatQty.Join("','") }')) " + * $"AND (@CrtReqDocFlgIsNull IS NULL OR CrtReqDocFlg IN ('{ d.CrtReqDocFlg.Join("','") }')) " + * $"AND (@AppvNoIsNull IS NULL OR AppvNo IN ('{ d.AppvNo.Join("','") }')) " + * $"AND (@AppvSeqNoIsNull IS NULL OR AppvSeqNo IN ('{ d.AppvSeqNo.Join("','") }')) " + * $"AND (@SumQtyIsNull IS NULL OR SumQty IN ('{ d.SumQty.Join("','") }')) " + * $"AND (@PUR_FLAGIsNull IS NULL OR PUR_FLAG IN ('{ d.PUR_FLAG.Join("','") }')) " + * $"AND (@NOTPUR_FLAGIsNull IS NULL OR NOTPUR_FLAG IN ('{ d.NOTPUR_FLAG.Join("','") }')) " + * $"AND (@CALCOST_FLAGIsNull IS NULL OR CALCOST_FLAG IN ('{ d.CALCOST_FLAG.Join("','") }')) " + * $"AND (@NOTCALCOST_FLAGIsNull IS NULL OR NOTCALCOST_FLAG IN ('{ d.NOTCALCOST_FLAG.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 (QtyAmt LIKE @txtSearch OR QtyAmt LIKE @txtSearch) " + * //"ORDER BY ;"; */ var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.ViewWorkOrderD>(cmd, param).ToList(); return(res); }
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.ViewWorkOrderD> GetData(ASSETKKF_MODEL.Request.Mcis.ViewWorkOrderDReq d) { DynamicParameters param = new DynamicParameters(); param.Add("@WorkOrderID", d.WorkOrderID); /* * param.Add("@QtyAmt", d.QtyAmt); * param.Add("@ItemCode", d.ItemCode); * param.Add("@ItemName", d.ItemName); * param.Add("@WorkOrderID", d.WorkOrderID); * param.Add("@MatItemCd", d.MatItemCd); * param.Add("@MatType", d.MatType); * param.Add("@MatUnitCd", d.MatUnitCd); * param.Add("@MatSize1", d.MatSize1); * param.Add("@MatSize2", d.MatSize2); * param.Add("@MatQty", d.MatQty); * param.Add("@CrtReqDocFlg", d.CrtReqDocFlg); * param.Add("@AppvNo", d.AppvNo); * param.Add("@AppvSeqNo", d.AppvSeqNo); * param.Add("@SumQty", d.SumQty); * param.Add("@PUR_FLAG", d.PUR_FLAG); * param.Add("@NOTPUR_FLAG", d.NOTPUR_FLAG); * param.Add("@CALCOST_FLAG", d.CALCOST_FLAG); * param.Add("@NOTCALCOST_FLAG", d.NOTCALCOST_FLAG); * param.Add("@USER_ID", d.USER_ID); * param.Add("@USER_DATE", d.USER_DATE); * //param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");*/ string cmd = " SELECT H.QtyAmt,R.ItemCode,R.ItemName,D.* FROM vWorkOrderD D " + $"INNER JOIN mtWorkOrderH H " + $"ON D.WorkOrderID = H.WorkOrderID " + $"LEFT JOIN stksamw.dbo.rmItem R " + $"ON D.MatItemCd = R.ItemCode " + $" WHERE (@WorkOrderID IS NULL OR D.WorkOrderID = @WorkOrderID) " + /* * $"WHERE (@QtyAmt IS NULL OR QtyAmt = @QtyAmt) " + * $" AND (@ItemCode IS NULL OR ItemCode = @ItemCode) " + * $" AND (@ItemName IS NULL OR ItemName = @ItemName) " + * $" AND (@WorkOrderID IS NULL OR WorkOrderID = @WorkOrderID) " + * $" AND (@MatItemCd IS NULL OR MatItemCd = @MatItemCd) " + * $" AND (@MatType IS NULL OR MatType = @MatType) " + * $" AND (@MatUnitCd IS NULL OR MatUnitCd = @MatUnitCd) " + * $" AND (@MatSize1 IS NULL OR MatSize1 = @MatSize1) " + * $" AND (@MatSize2 IS NULL OR MatSize2 = @MatSize2) " + * $" AND (@MatQty IS NULL OR MatQty = @MatQty) " + * $" AND (@CrtReqDocFlg IS NULL OR CrtReqDocFlg = @CrtReqDocFlg) " + * $" AND (@AppvNo IS NULL OR AppvNo = @AppvNo) " + * $" AND (@AppvSeqNo IS NULL OR AppvSeqNo = @AppvSeqNo) " + * $" AND (@SumQty IS NULL OR SumQty = @SumQty) " + * $" AND (@PUR_FLAG IS NULL OR PUR_FLAG = @PUR_FLAG) " + * $" AND (@NOTPUR_FLAG IS NULL OR NOTPUR_FLAG = @NOTPUR_FLAG) " + * $" AND (@CALCOST_FLAG IS NULL OR CALCOST_FLAG = @CALCOST_FLAG) " + * $" AND (@NOTCALCOST_FLAG IS NULL OR NOTCALCOST_FLAG = @NOTCALCOST_FLAG) " + * $" AND (@USER_ID IS NULL OR USER_ID = @USER_ID) " + * $" AND (@USER_DATE IS NULL OR USER_DATE = @USER_DATE) " +*/ //$"AND (QtyAmt LIKE @txtSearch OR QtyAmt LIKE @txtSearch) " + $"order by d.matType,d.MatItemCd "; var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.ViewWorkOrderD>(cmd, param).ToList(); return(res); }