From 2605af51ca4787434c8c5f2b10dc0adc78a2fdb0 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 14 三月 2025 17:17:45 +0800 Subject: [PATCH] 外协管理,外协订单,你列表操作后面增加一个完工点,完工就进行。就是说,已完工处理好,前面呢,有个批量完工,好检索查询条件,也加个完工。 --- CY_ECommercePlatform/CY.SQLDAL/OA/OA_KaipiaonewcuishouDAL.cs | 10 +++++----- 1 files changed, 5 insertions(+), 5 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_KaipiaonewcuishouDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_KaipiaonewcuishouDAL.cs index 6c5291e..94d79d1 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_KaipiaonewcuishouDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_KaipiaonewcuishouDAL.cs @@ -67,11 +67,11 @@ new SqlParameter("@CuishouTime",trueModel.CuishouTime), new SqlParameter("@Creater",trueModel.Creater), - + new SqlParameter("@Cuikuanqingkuang",string.IsNullOrWhiteSpace(trueModel.Cuikuanqingkuang)?"":trueModel.Cuikuanqingkuang), }; - string sql = "Insert Into OA_Kaipiaonewcuishou ( [KaipiaoId] , [Creater],[CreateTime],[CuishouTime] )" - + " Values ( @KaipiaoId, @Creater,@CreateTime,@CuishouTime )"; + string sql = "Insert Into OA_Kaipiaonewcuishou ( [KaipiaoId] , [Creater],[CreateTime],[CuishouTime],[Cuikuanqingkuang] )" + + " Values ( @KaipiaoId, @Creater,@CreateTime,@CuishouTime,@Cuikuanqingkuang )"; try { _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>()); @@ -107,9 +107,9 @@ new SqlParameter("@CuishouTime",trueModel.CuishouTime), new SqlParameter("@Creater",trueModel.Creater), - + new SqlParameter("@Cuikuanqingkuang",string.IsNullOrWhiteSpace(trueModel.Cuikuanqingkuang)?"":trueModel.Cuikuanqingkuang), }; - string sql = "Update OA_Kaipiaonewcuishou Set [Creater]=@Creater,[CreateTime]=@CreateTime,[CuishouTime]=@CuishouTime where [Keyid] =@Keyid "; + string sql = "Update OA_Kaipiaonewcuishou Set [Creater]=@Creater,[CreateTime]=@CreateTime,[CuishouTime]=@CuishouTime,[Cuikuanqingkuang]=@Cuikuanqingkuang where [Keyid] =@Keyid "; try { -- Gitblit v1.9.1