/// <summary> /// 搜索内容 /// </summary> /// <param name="filter"></param> /// <param name="PageSize"></param> /// <param name="CPage"></param> /// <returns></returns> DataSet ID_CommonModel.ContentSearch(string filter, int PageSize, int CPage) { string strSql = "PR_GetRecordFromPage"; SqlParameter[] cmdParam = new SqlParameter[] { new SqlParameter("@TableName", SqlDbType.VarChar), //表名,可以是多个表 new SqlParameter("@Identity", SqlDbType.VarChar), new SqlParameter("@Fields", SqlDbType.VarChar), //要取出的字段,可以是多个表的字段,可以为空,为空表示select * new SqlParameter("@sqlWhere", SqlDbType.VarChar), //条件,可以为空,不用填 where new SqlParameter("@OrderField", SqlDbType.VarChar), //排序字段,可以为空,为空默认按主键升序排列,不用填 order by new SqlParameter("@pageSize", SqlDbType.Int), //每页记录数 new SqlParameter("@pageIndex", SqlDbType.Int) //当前页,0表示第1页 }; cmdParam[0].Value = "ZL_CommonModel"; cmdParam[1].Value = "GeneralID"; cmdParam[2].Value = "*"; cmdParam[3].Value = filter; cmdParam[4].Value = "GeneralID DESC"; cmdParam[5].Value = PageSize; cmdParam[6].Value = CPage - 1; return(SqlHelper.ExecuteDataSet(CommandType.StoredProcedure, strSql, cmdParam)); }
DataSet ID_Label.GetLabelAll() { string strSql = "Select LabelName,LabelType,LabelCate,LabelDesc,LabelParam,LabelTable,LabelField,LabelWhere,LabelOrder,LabelContent,LabelCount,LabelIdentity from ZL_Label Order by LabelID ASC"; return(SqlHelper.ExecuteDataSet(CommandType.Text, strSql, null)); }