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_tongxunluDAL.cs | 39 ++++++++++++++++++++++++++++++++++++---
1 files changed, 36 insertions(+), 3 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_tongxunluDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_tongxunluDAL.cs
index 010f0fc..ada61e6 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_tongxunluDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_tongxunluDAL.cs
@@ -69,11 +69,12 @@
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_tongxunlu ([FirmId],[type_id],[danwei_name],[lianxiren], [lianxidianhua], [beuzhu],[rec_status], [creater],[createtime], [modifier],[modifytime])"
- + " Values (@FirmId,@type_id,@danwei_name, @lianxiren, @lianxidianhua, @beuzhu, @rec_status, @creater, @createtime, @modifier,@modifytime)";
+ string sql = "Insert Into Adm_tongxunlu ([FirmId],[type_id],[danwei_name],[lianxiren], [lianxidianhua], [beuzhu],[rec_status], [creater],[createtime], [modifier],[modifytime],[Jusequanxian])"
+ + " Values (@FirmId,@type_id,@danwei_name, @lianxiren, @lianxidianhua, @beuzhu, @rec_status, @creater, @createtime, @modifier,@modifytime,@Jusequanxian)";
try
{
_dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
@@ -165,6 +166,38 @@
/// <summary>
+ /// 鏍规嵁缂栧彿鑾峰緱淇℃伅
+ /// </summary>
+ /// <param name="Keyid">缂栧彿</param>
+ /// <returns></returns>
+ public IEnumerable<Adm_tongxunlu> GetModelByKeyids(string keyids)
+ {
+ try
+ {
+ string condition = " ";
+ if (!string.IsNullOrEmpty(keyids))
+ {
+ condition = " Keyid in (" + keyids + ")";
+ }
+ else
+ {
+ return null;
+ }
+
+ // return null;//閿欒鏁版嵁杩斾細绌�
+
+ return _dataBase.SelectModel<Adm_tongxunlu>("*", "Adm_tongxunlu", condition) as IList<Adm_tongxunlu>;//鎵ц鏌ヨ
+
+
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+ /// <summary>
/// 鍏ㄩ儴鏌ヨ
/// </summary>
/// <param name="query"></param>
--
Gitblit v1.9.1