通过关键字获得ShowSeq[缺省显示顺序对应的字段]的值 - ShowSeqGetValue

2017-02-21 23:03:27 访问(1521) 赞(0) 踩(0)


        /// <summary>
        /// <para>获得显示顺序的值</para>
        /// <para>通过关键字获得ShowSeq[缺省显示顺序对应的字段]的值</para>
        /// </summary>
        /// <param name="primaryKeyValue">关键字</param>
        /// <param name="xdbHelper">数据库链接串</param>
        /// <returns></returns>
        public int ShowSeqGetValue
            (
                object primaryKeyValue,
                DBHelper xdbHelper
            )
        {
            int theResult = 0;

            bool bIsCreate = true;

            if (xdbHelper == null)
            {
                xdbHelper 
                    = 
                    SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
            }
            else
            {
                // 没有打开链接 //
                bIsCreate = xdbHelper.IsNotOpen();
            }

            try
            {
                if (bIsCreate)
                    xdbHelper.OpenDBHelper();

                BaseEntity entity = this.CreateBaseEntity();

                string showSeqDataColumnName
                    =
                    entity.GetExistShowSeqDataColumnName();

                entity.i_iqueryDriver.AddIQueryItemWithPrimaryKey(primaryKeyValue);

                DataRow dr = GetExistDataRow(entity, xdbHelper);

                theResult = int.Parse(dr[showSeqDataColumnName].ToString());

                if (bIsCreate)
                    xdbHelper.EndDBHelper();

            }
            catch (Exception err)
            {
                if (bIsCreate)
                    xdbHelper.TranDBHelper();

                throw err;
            }
            finally
            {
                if (bIsCreate)
                    xdbHelper.FinallyDBHelper();
            }

            return theResult;
        }

        /// <summary>
        /// 获得显示顺序的值，通过关键字获得ShowSeq[显示顺序对应的字段]的值
        /// </summary>
        /// <param name="showSeqDataColumnName">显示顺序对应的字段</param>
        /// <param name="primaryKeyValue">关键字</param>
        /// <param name="xdbHelper">数据库链接串</param>
        /// <returns></returns>
        public int ShowSeqGetValue
            (
                string showSeqDataColumnName,
                object primaryKeyValue,
                DBHelper xdbHelper
            )
        {
            if (showSeqDataColumnName == null || showSeqDataColumnName.Length == 0 || showSeqDataColumnName.Trim().Length == 0)
            {
                throw new Exception
                    (
                        "方法："
                        + MethodBase.GetCurrentMethod().ReflectedType.FullName
                        + " "
                        + MethodBase.GetCurrentMethod().ToString()
                        + " 发生异常："
                        + "showSeqDataColumnName 为null或为空。"
                    );
            }


            int theResult = 0;

            bool bIsCreate = true;

            if (xdbHelper == null)
            {
                xdbHelper = SlowX.DAL.Helpers.DBHelper.CreateDBHelper();
            }
            else
            {
                // 没有打开链接 //
                bIsCreate = xdbHelper.IsNotOpen();
            }

            try
            {
                if (bIsCreate)
                    xdbHelper.OpenDBHelper();

                BaseEntity entity = this.CreateBaseEntity();

                entity.i_iqueryDriver.AddIQueryItemWithPrimaryKey(primaryKeyValue);

                DataRow dr = GetExistDataRow(entity, xdbHelper);

                theResult = int.Parse(dr[showSeqDataColumnName].ToString());

                if (bIsCreate)
                    xdbHelper.EndDBHelper();

            }
            catch (Exception err)
            {
                if (bIsCreate)
                    xdbHelper.TranDBHelper();

                throw err;
            }
            finally
            {
                if (bIsCreate)
                    xdbHelper.FinallyDBHelper();
            }

            return theResult;
        }