人事管理里边增加 一个权限

username@email.com

2025-05-07 451ec557d579f8f9e1b0c84754709cc8b3d2090e

 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>