条件查询注意

原创于 2019-07-08 09:19:34 发布 · 203 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#条件查询

数据库专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一段用于查询海运转运信息的API代码，该API能够根据不同的筛选条件（如始发港、目的港、装船日期等）从数据库中获取符合要求的海运转运记录。代码使用了动态SQL构建方式，通过条件判断来拼接查询语句，最终返回匹配的海运转运列表。

public List<F_SEAFREIGHT> SeaFreightList(freight model)
{
using (IDbConnection conn = GetConnection(DBType.Forwarder))
{
string query = “select * from F_SEAFREIGHT where TIMESTART <=sysdate and TIMEEND >= sysdate”;
if (!string.IsNullOrEmpty(model.startPort))
{
query = query + " and LOADINGPORTCODE =:startPort";
}
if (!string.IsNullOrEmpty(model.endPort))
{
query = query + " and DESTINATIONPORT =:endPort";
}

            if (!string.IsNullOrEmpty(model.shipDateStart))
            {
                query = query + " and TRANSITDATE >=to_date('" + model.shipDateStart + "', 'yyyy-mm-dd')";
            }
            if (!string.IsNullOrEmpty(model.shipDateEnd))
            {
                query = query + " and TRANSITDATE <=to_date('" + model.shipDateEnd + "', 'yyyy-mm-dd')";
            }
            if (!(string.IsNullOrEmpty(model.shipNo) || model.shipNo == "不限"))
            {
                query = query + " and CARRIERCODE =:shipNo";
            }
            var freightList = conn.Query<F_SEAFREIGHT>(query, model).ToList();
            return freightList;
        }
    }