public static DataTable list(DBInstance dbmgr, List <Param> searchParam, string orderby = "") { StringBuilder sql_where = new StringBuilder(); if (Param.FindContainParamKey(searchParam, "orderno")) { sql_where.Append(" and r_main.orderno like @orderno "); } if (Param.FindContainParamKey(searchParam, "time_end")) { sql_where.Append(" and r_main.time_end like @time_end "); } if (Param.FindContainParamKey(searchParam, "openid")) { sql_where.Append(" and r_main.openid like @openid "); } if (Param.FindContainParamKey(searchParam, "total_fee")) { sql_where.Append(" and r_main.total_fee=@total_fee "); } if (Param.FindContainParamKey(searchParam, "trade_type")) { sql_where.Append(" and r_main.trade_type like @trade_type "); } if (Param.FindContainParamKey(searchParam, "transaction_id")) { sql_where.Append(" and r_main.transaction_id like @transaction_id "); } if (Param.FindContainParamKey(searchParam, "result_code")) { sql_where.Append(" and r_main.result_code like @result_code "); } string sql = "select r_main.id ,r_main.orderno ,r_main.time_end ,r_main.openid ,r_main.total_fee ,r_main.trade_type ,r_main.transaction_id ,r_main.result_code from tb_payment r_main where 1=1 " + sql_where.ToString() + " " + orderby; return(dbmgr.ExecuteDataTable(sql, searchParam)); }