username@email.com
2025-05-07 451ec557d579f8f9e1b0c84754709cc8b3d2090e
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>