From 451ec557d579f8f9e1b0c84754709cc8b3d2090e Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 07 五月 2025 08:37:46 +0800 Subject: [PATCH] 人事管理里边增加 一个权限 --- CY_ECommercePlatform/CY.SQLDAL/OA/Adm_zhanghaomimaDAL.cs | 38 ++++++++++++++++++++++++++++++++++++-- 1 files changed, 36 insertions(+), 2 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_zhanghaomimaDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_zhanghaomimaDAL.cs index a10cafd..8a81138 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_zhanghaomimaDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_zhanghaomimaDAL.cs @@ -69,10 +69,11 @@ new SqlParameter("@createtime",trueModel.createtime), new SqlParameter("@modifier",trueModel.modifier), new SqlParameter("@modifytime",trueModel.modifytime), + new SqlParameter("@Jusequanxian",string.IsNullOrEmpty(trueModel.Jusequanxian)?"":trueModel.Jusequanxian), }; - string sql = "Insert Into Adm_zhanghaomima ([FirmId],[type_id],[chanpinxiangmu],[zhanghao], [mima], [mibao],[rec_status], [creater],[createtime], [modifier],[modifytime])" - + " Values (@FirmId,@type_id,@chanpinxiangmu, @zhanghao, @mima, @mibao, @rec_status, @creater, @createtime, @modifier,@modifytime)"; + string sql = "Insert Into Adm_zhanghaomima ([FirmId],[type_id],[chanpinxiangmu],[zhanghao], [mima], [mibao],[rec_status], [creater],[createtime], [modifier],[modifytime],[Jusequanxian])" + + " Values (@FirmId,@type_id,@chanpinxiangmu, @zhanghao, @mima, @mibao, @rec_status, @creater, @createtime, @modifier,@modifytime,@Jusequanxian)"; try { _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>()); @@ -164,6 +165,39 @@ } + + /// <summary> + /// 鏍规嵁缂栧彿鑾峰緱淇℃伅 + /// </summary> + /// <param name="Keyid">缂栧彿</param> + /// <returns></returns> + public IEnumerable<Adm_zhanghaomima> GetModelByKeyids(string keyids) + { + try + { + string condition = " "; + if (!string.IsNullOrEmpty(keyids)) + { + condition = " Keyid in (" + keyids + ")"; + } + else + { + return null; + } + + // return null;//閿欒鏁版嵁杩斾細绌� + + return _dataBase.SelectModel<Adm_zhanghaomima>("*", "Adm_zhanghaomima", condition) as IList<Adm_zhanghaomima>;//鎵ц鏌ヨ + + + } + catch (Exception ex) + { + throw ex; + } + } + + /// <summary> /// 鍏ㄩ儴鏌ヨ /// </summary> -- Gitblit v1.9.1