/// <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));
}
