username@email.com
2025-10-22 0de684b2cd131f9801ca96abdb9028f7e30cd31b
CY_ECommercePlatform/CY.SQLDAL/OA/OA_ProcurementDAL.cs
@@ -66,7 +66,11 @@
                    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
            {
@@ -121,7 +125,10 @@
                    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
            {
@@ -207,7 +214,7 @@
            }
            if (!string.IsNullOrEmpty(Operator))
            {
                Condition += string.Format(" and  Operator='{0}'", Operator);
                Condition += string.Format(" and  Caigouren like '%{0}%'", Operator);
            }
            if (!string.IsNullOrEmpty(ClearingStatusId))
            {