public SqlDataReader GetList(int PageSize, int PageIndex, string tableName, string key, string strWhere, string Fields, string SortStr, bool IsRetCount)
{
SqlParameter[] parameters =
{
new SqlParameter("@TableName", SqlDbType.VarChar, 500),
new SqlParameter("@Fields", SqlDbType.VarChar, 255),
new SqlParameter("@SortStr", SqlDbType.VarChar, 255),
new SqlParameter("@Pkey", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsRetCount", SqlDbType.Bit),
new SqlParameter("@WhereStr", SqlDbType.VarChar, 3000),
};
parameters[0].Value = tableName;
parameters[1].Value = Fields;
parameters[2].Value = SortStr;
parameters[3].Value = key;
parameters[4].Value = PageSize;
parameters[5].Value = PageIndex;
parameters[6].Value = IsRetCount;
parameters[7].Value = strWhere;
return(MySQLHelper.ExecuteReader(SqlConnString, MySQLHelper.CreateCommand(CommandType.StoredProcedure, "UP_GetRecordByPageOrder", parameters)));
}
public string GetJSONInfo(string sql)
{
var reader = MySQLHelper.ExecuteReader(SqlConnString, MySQLHelper.CreateCommand(sql));
return(JSONHelper.ToJson(JSONHelper.DbReaderToHash(reader)));
}