| | |
| | | new SqlParameter("@PaperWeightId",trueModel.PaperWeightId), |
| | | new SqlParameter("@tanPrice",trueModel.TanPrice??0), |
| | | new SqlParameter("@ReceiveMoney",decimal.Parse("0")), |
| | | new SqlParameter("@Commodityid",trueModel.Commodityid) |
| | | new SqlParameter("@Commodityid",trueModel.Commodityid), |
| | | new SqlParameter("@orderId",trueModel.orderId.HasValue?trueModel.orderId.Value:0), |
| | | new SqlParameter("@DocumentName",string.IsNullOrEmpty(trueModel.DocumentName)?"":trueModel.DocumentName), |
| | | new SqlParameter("@CaigourenId",trueModel.CaigourenId.HasValue?trueModel.CaigourenId.Value:0), |
| | | new SqlParameter("@Caigouren",string.IsNullOrEmpty(trueModel.Caigouren)?"":trueModel.Caigouren), |
| | | }; |
| | | try |
| | | { |
| | |
| | | new SqlParameter("@PaperWeightId",trueModel.PaperWeightId), |
| | | new SqlParameter("@tanPrice",trueModel.TanPrice??0), |
| | | new SqlParameter("@ReceiveMoney",trueModel.ReceiveMoney), |
| | | new SqlParameter("@Commodityid",trueModel.Commodityid) |
| | | new SqlParameter("@Commodityid",trueModel.Commodityid), |
| | | new SqlParameter("@WarehouseName",string.IsNullOrEmpty(trueModel.WarehouseName)?"":trueModel.WarehouseName), |
| | | new SqlParameter("@CaigourenId",trueModel.CaigourenId.HasValue?trueModel.CaigourenId.Value:0), |
| | | new SqlParameter("@Caigouren",string.IsNullOrEmpty(trueModel.Caigouren)?"":trueModel.Caigouren), |
| | | }; |
| | | try |
| | | { |
| | |
| | | } |
| | | if (!string.IsNullOrEmpty(Operator)) |
| | | { |
| | | Condition += string.Format(" and Operator='{0}'", Operator); |
| | | Condition += string.Format(" and Caigouren like '%{0}%'", Operator); |
| | | } |
| | | if (!string.IsNullOrEmpty(ClearingStatusId)) |
| | | { |