C# 使用DataTable返回前端数据基础实践

Controller

public ActionResult GetOrderBookingListByOrderUser(string OrderUser, string NetCode)
{
    int totalCount = 0;
    ContentResult contentResult = new ContentResult();
    if (string.IsNullOrEmpty(OrderUser))
    {
        contentResult.Content = JsonConvert.SerializeObject(new
        {
            code = 0,
            msg = "成功",
            data = new string[] { },
            count = totalCount,
        }, ObjectInstance.GetFormat());
    return contentResult;
    }

    if (string.IsNullOrEmpty(NetCode))
    {
        NetCode = "%%";
    }
    else
    {
        NetCode = "%" + NetCode + "%";
    }

    DataTable dataTable = ObjectInstance.OrderbookingMgr.GetOrderBookingList(OrderUser, NetCode, out totalCount);

    contentResult.Content = JsonConvert.SerializeObject(new
    {
        code = 0,
        msg = "成功",
        data = dataTable,
        count = totalCount,
    }, ObjectInstance.GetFormat());
    return contentResult;
}

IService

DataTable GetOrderBookingList(string orderUser, string netCode, out int totalCount);

Service

public DataTable GetOrderBookingList(string orderUser, string netCode, out int totalCount)
{
    return _OrderBookingDao.GetOrderBookingList(orderUser, netCode, out totalCount);
}

IDao

DataTable GetOrderBookingList(string orderUser, string netCode, out int totalCount);

Dao

public DataTable GetOrderBookingList(string orderUser, string netCode, out int totalCount)
{
    lock (_SynObject)
    {
        totalCount = 0;
        DataTable dataTable = new DataTable();
        IDbCommand cmd = null;
        try
        {
            cmd = SessionFactory.OpenStatelessSession().Connection.CreateCommand();
            cmd.CommandText = "proc_GetOrderBookingList";
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add(CreateParam(cmd, "@orderUser", orderUser));
            cmd.Parameters.Add(CreateParam(cmd, "@netCode", netCode));
            IDbDataParameter bfReturn = CreateOutputParam(cmd, "@bfReturn");
            cmd.Parameters.Add(bfReturn);

            IDataReader reader = cmd.ExecuteReader();
            dataTable = SqlDataBase.DataTableToIDataReader(reader);
            cmd.ExecuteNonQuery();

            totalCount = Convert.ToInt32(bfReturn.Value);
        }
        catch (Exception e)
        {
            _Logger.Error(e.Message);
        }
        finally
        {
            cmd.Dispose();
            cmd.Connection.Close();
            ReleaseSession(Session);
            SessionFactory.Close();
        }
        return dataTable;
    }
}

原文地址：C# 使用DataTable返回前端数据基础实践——一直在路上