原创---switch(T obj)选择语句如何判断是某一个对象

最新推荐文章于 2022-06-23 10:08:49 发布

weixin_34143774

最新推荐文章于 2022-06-23 10:08:49 发布

阅读量446

点赞数

文章标签： c# 数据库

原文链接：http://www.cnblogs.com/smthts/archive/2012/07/26/2610378.html

版权

        /// <summary>
        /// 判断警单是否存在
        /// </summary>
        /// <typeparam name="T">对象类型</typeparam>
        /// <param name="ajbh">案件编号</param>
        /// <param name="obj">对象实例(T1,T2,T3)</param>
        /// <returns>true为存在，false为不存在</returns>
        public bool GetCase<T>( string ajbh, T obj )
        {
            if (string.IsNullOrEmpty( ajbh ))
            {
                return true;
            }
            if (obj is Nullable)
            {
                return true;
            }
            int count = 0;
            string sql = string.Empty;
            switch (obj.GetType().Name.ToLower())
            {
                case "t1":
                    sql = string.Format( "select count(*) from t_case_1 t where t.bh='{0}'", ajbh );
                    break;
                case "t2":
                    sql = string.Format( "select count(*) from t_case_2 t where t.bh='{0}'", ajbh );
                    break;
                case "t3":
                    sql = string.Format( "select count(*) from t_case_3 t where t.bh='{0}'", ajbh );
                    break;
            }

            if (string.IsNullOrEmpty( sql ))
            {
                return true;
            }
            using (DbCommand cmd = database.GetSqlStringCommand( sql ))
            {
                count = Convert.ToInt32( database.ExecuteScalar( cmd ) );
            }
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

转载于:https://www.cnblogs.com/smthts/archive/2012/07/26/2610378.html