From 529d8cb61421eb65d86559d3d2636ad405b87b41 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 22 七月 2025 08:50:06 +0800 Subject: [PATCH] 专版 四色 八色 自翻印刷的时候 ctp 4张 扣版 8张 --- CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs | 35 +++++++++++++++++++++++++++++++++++ 1 files changed, 35 insertions(+), 0 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs index 71fd4e7..e9829ce 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlanDAL.cs @@ -275,6 +275,41 @@ } } + + /// <summary> + /// 鏍规嵁缂栧彿鑾峰緱淇℃伅 + /// </summary> + /// <param name="Keyid">缂栧彿</param> + /// <returns></returns> + public OA_WorkPlan GetModelByFukuanshenqid(string PlanComplany, string RewardType) + { + try + { + string condi = ""; + if (!string.IsNullOrEmpty(PlanComplany)) + { + condi = " a.PlanComplany = '"+ PlanComplany + "' "; + } + else if (!string.IsNullOrEmpty(RewardType)) + { + condi = " a.RewardType = '" + RewardType + "' "; + } + else + { + return null; + } + + IList<OA_WorkPlan> result = _dataBase.SelectModel<OA_WorkPlan>(" a.* ", " OA_WorkPlan a ", condi) as IList<OA_WorkPlan>;//鎵ц鏌ヨ + + return (null == result || result.Count == 0) ? null : result[0];//杩斿洖缁撴灉 + } + catch (Exception ex) + { + throw ex; + } + } + + /// <summary> /// 鍒嗛〉鏌ヨ /// </summary> -- Gitblit v1.9.1