コード例 #1
0
        /// <summary>得到一个对象实体
        ///
        /// </summary>
        /// <param name="KeyId">主键</param>
        /// <returns>返回对象实体</returns>
        public Nikita.Assist.CodeMaker.Model.Sys_Roles GetModel(int KeyId)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select * from Sys_Roles ");
            strSql.Append(" where KeyId=@KeyId ");
            DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo();
            h.CreateCommand(strSql.ToString());
            h.AddParameter("@KeyId", KeyId);
            Nikita.Assist.CodeMaker.Model.Sys_Roles model = null;
            using (IDataReader dataReader = h.ExecuteReader())
            {
                if (dataReader.Read())
                {
                    model = ReaderBind(dataReader);
                }
                h.CloseConn();
            }
            return(model);
        }
コード例 #2
0
        /// <summary>根据条件得到一个对象实体
        ///
        /// </summary>
        /// <param name="strCond">条件</param>
        /// <returns>返回对象实体</returns>
        public Nikita.Assist.CodeMaker.Model.Sys_Roles GetModelByCond(string strCond)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select top 1 * from Sys_Roles ");
            if (!string.IsNullOrEmpty(strCond))
            {
                strSql.Append(" where " + strCond);
            }
            DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo();
            h.CreateCommand(strSql.ToString());
            Nikita.Assist.CodeMaker.Model.Sys_Roles model = null;
            using (IDataReader dataReader = h.ExecuteReader())
            {
                if (dataReader.Read())
                {
                    model = ReaderBind(dataReader);
                }
                h.CloseConn();
            }
            return(model);
        }
コード例 #3
0
        /// <summary>分页获取数据列表
        ///
        /// </summary>
        /// <param name="strFields">字段</param>
        /// <param name="strOrder">排序</param>
        /// <param name="strOrderType">排序类型</param>
        /// <param name="intPageSize">每页大小</param>
        /// <param name="intPageIndex">当前第N页</param>
        /// <param name="strWhere">条件</param>
        /// <returns>返回符合条件的对象集合</returns>
        public List <Nikita.Assist.CodeMaker.Model.Sys_Roles> GetListArray(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere)
        {
            DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo();
            h.CreateStoredCommand("[proc_SplitPage]");
            h.AddParameter("@tblName", "Sys_Roles");
            h.AddParameter("@strFields", strFields);
            h.AddParameter("@strOrder", strOrder);
            h.AddParameter("@strOrderType", strOrderType);
            h.AddParameter("@PageSize", intPageSize);
            h.AddParameter("@PageIndex", intPageIndex);
            h.AddParameter("@strWhere", strWhere);
            List <Nikita.Assist.CodeMaker.Model.Sys_Roles> list = new List <Nikita.Assist.CodeMaker.Model.Sys_Roles>();

            using (IDataReader dataReader = h.ExecuteReader())
            {
                while (dataReader.Read())
                {
                    list.Add(ReaderBind(dataReader));
                }
                h.CloseConn();
            }
            return(list);
        }
コード例 #4
0
        /// <summary>获得数据列表(比DataSet效率高,推荐使用)
        ///
        /// </summary>
        /// <param name="strWhere">条件</param>
        /// <returns>返回符合条件的对象集合</returns>
        public List <Nikita.Assist.CodeMaker.Model.Sys_Roles> GetListArray(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select * ");
            strSql.Append(" FROM Sys_Roles ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            List <Nikita.Assist.CodeMaker.Model.Sys_Roles> list = new List <Nikita.Assist.CodeMaker.Model.Sys_Roles>();

            DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo();
            h.CreateCommand(strSql.ToString());
            using (IDataReader dataReader = h.ExecuteReader())
            {
                while (dataReader.Read())
                {
                    list.Add(ReaderBind(dataReader));
                }
                h.CloseConn();
            }
            return(list);
        }