如何将数据添加到自定义的DataTable中并赋值给list实现打印功能。

32 篇文章 0 订阅
17 篇文章 0 订阅
 public partial class FormTaxStatementsPrint : Form
    {
        public string Date ;
        public string CustomerName ;
        public string ProductName ;
        public string Taxes ;
        public string Express ;
        public string AccountName ;
        public string YesOrNO ;
        public string PayNo;

        public FormTaxStatementsPrint(string _Date, string _CustomerName, string _ProductName, string _Taxes, string _Express, string _AccountName, string _YesOrNO, string _PayNo)
        {
            InitializeComponent();
            this.Date = _Date;
            this.CustomerName = _CustomerName;
            this.ProductName = _ProductName;
            this.Taxes = _Taxes;
            this.Express= _Express;
            this.AccountName = _AccountName;
            this.YesOrNO = _YesOrNO;
            this.PayNo = _PayNo;
        }

        private void FormTaxStatementsPrint_Load(object sender, EventArgs e)
        {

            Microsoft.Reporting.WinForms.ReportDataSource reportDeliveryOrdersPrintDataSource = new Microsoft.Reporting.WinForms.ReportDataSource();
            reportDeliveryOrdersPrintDataSource.Name = "DataSetTaxStatements";
            reportDeliveryOrdersPrintDataSource.Value = this.dataSetTaxStatementsBindingSource;
            this.rvTaxStatements.LocalReport.DataSources.Clear();
            this.rvTaxStatements.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSetTaxStatements", GetList()));
            //显示报表
            this.rvTaxStatements.RefreshReport();
        }

        /// <summary>
        /// 获取打印的数据源
        /// </summary>
        /// <returns></returns>
        private List<TaxStatementsPrintModel> GetList()
        {

            DataTable dt = new DataTable();
            dt.Columns.Add("Date");
            dt.Columns.Add("CustomerName");
            dt.Columns.Add("ProductName");
            dt.Columns.Add("Taxes");
            dt.Columns.Add("Express");
            dt.Columns.Add("AccountName");
            dt.Columns.Add("YesOrNO");
            dt.Columns.Add("PayNo");

            DataRow dr = dt.NewRow();

            dr[0] = Date;
            dr[1] = CustomerName;
            dr[2] = ProductName;
            dr[3] = Taxes;
            dr[4] = Express;
            dr[5] = AccountName;
            dr[6] = YesOrNO;
            dr[7] = PayNo;
            dt.Rows.Add(dr);
            List<TaxStatementsPrintModel> list = new List<TaxStatementsPrintModel>();
            TaxStatementsPrintModel taxStatementsPrint = null;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                taxStatementsPrint = new TaxStatementsPrintModel();
                taxStatementsPrint.Date = dt.Rows[i]["Date"].ToString();
                taxStatementsPrint.CustomerName = dt.Rows[i]["CustomerName"].ToString();
                taxStatementsPrint.ProductName = dt.Rows[i]["ProductName"].ToString();
                taxStatementsPrint.Taxes = dt.Rows[i]["Taxes"].ToString();
                taxStatementsPrint.Express = dt.Rows[i]["Express"].ToString();
                taxStatementsPrint.AccountName = dt.Rows[i]["AccountName"].ToString();
                taxStatementsPrint.YesOrNO = dt.Rows[i]["YesOrNO"].ToString();
                taxStatementsPrint.PayNo = dt.Rows[i]["PayNo"].ToString();
                list.Add(taxStatementsPrint);
            }
            return list;
        }

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值