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