110,533
社区成员
发帖
与我相关
我的任务
分享
//数据集
DsSaleInfo _dataSetSaleInfo = new DsSaleInfo();
DataTable _reportDataTable = _dataSetSaleInfo.Tables[0];
//数据源
DataTable dtOrderInfo = GetOrderInfo(strOrderStates);
for (int i = 0; i < dtOrderInfo.Rows.Count; i++)
{
DataRow _reportDataRow = _reportDataTable.NewRow();
_reportDataRow["id"] = i + 1;
_reportDataRow["deptName"] = dtOrderInfo.Rows[i]["vcdeptname"];
_reportDataRow["orderId"] = dtOrderInfo.Rows[i]["order_id"];
_reportDataRow["orderDate"] = dtOrderInfo.Rows[i]["dtbooktime"];
_reportDataRow["fee"] = dtOrderInfo.Rows[i]["fee"];
_reportDataRow["vcPnr"] = dtOrderInfo.Rows[i]["vcpnr"];
_reportDataRow["vcPnr2"] = dtOrderInfo.Rows[i]["vcPnr2"];
_reportDataRow["vcProviderName"] = dtOrderInfo.Rows[i]["vcprovidername"];
_reportDataRow["vcSaleDeptName"] = dtOrderInfo.Rows[i]["vcsaleagentname"];
_reportDataRow["vcSaleUserName"] = dtOrderInfo.Rows[i]["vcsaleusername"];
_reportDataRow["vcTksState"] = dtOrderInfo.Rows[i]["itksstate"];
_reportDataTable.Rows.Add(_reportDataRow);
}
//报表
SaleInfoReport1.SetDataSource(_dataSetSaleInfo);
ReportDataSource rds = new ReportDataSource("JwcgqTableEntity", dts);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();