C# (CSharp) XCLCMS.Data.Model.View.v_SysFunction Beispiele

Beispiel #1

Datei: v_SysFunction.cs Projekt: jiangnanwoniu/XCLCMS_asp.net

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public XCLCMS.Data.Model.View.v_SysFunction GetModel(long SysFunctionID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 * from v_SysFunction  WITH(NOLOCK)  ");
            strSql.Append(" where SysFunctionID=@SysFunctionID ");
            XCLCMS.Data.Model.View.v_SysFunction model = new XCLCMS.Data.Model.View.v_SysFunction();
            Database  db        = base.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());

            db.AddInParameter(dbCommand, "SysFunctionID", DbType.Int64, SysFunctionID);
            using (var dr = db.ExecuteReader(dbCommand))
            {
                return(XCLNetTools.DataSource.DataReaderHelper.DataReaderToEntity <XCLCMS.Data.Model.View.v_SysFunction>(dr));
            }
        }

Beispiel #2

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public XCLCMS.Data.Model.View.v_SysFunction GetModel(long SysFunctionID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 * from v_SysFunction ");
            strSql.Append(" where SysFunctionID=@SysFunctionID ");
            XCLCMS.Data.Model.View.v_SysFunction model = new XCLCMS.Data.Model.View.v_SysFunction();
            Database  db        = base.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());

            db.AddInParameter(dbCommand, "SysFunctionID", DbType.Int64, SysFunctionID);
            DataSet ds  = db.ExecuteDataSet(dbCommand);
            var     lst = XCLNetTools.Generic.ListHelper.DataSetToList <XCLCMS.Data.Model.View.v_SysFunction>(ds);

            return(null != lst && lst.Count > 0 ? lst[0] : null);
        }