| | |
| | | if (!string.IsNullOrEmpty(FMateralId)) |
| | | sqlwhere += $" and FHMATERID='{FMateralId}'"; |
| | | } |
| | | |
| | | //齐套 |
| | | string FCompleteStatus = Convert.ToString(this.Model.GetValue("FCompleteStatus")); |
| | | if (!string.IsNullOrEmpty(FCompleteStatus)) |
| | | sqlwhere += $" and CompleteStatus='{FCompleteStatus}'"; |
| | | |
| | | //生产订单号 |
| | | string PRDBillNo = Convert.ToString(this.Model.GetValue("FScOrderNo")); |
| | | if (!string.IsNullOrEmpty(PRDBillNo)) |
| | | sqlwhere += $" and PRDBillNo='{PRDBillNo}'"; |
| | | |
| | | sql += sqlwhere; |
| | | DataTable dt = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0]; |
| | | this.Model.DeleteEntryData("FEntity"); |