private void btnDeclare_Click(object sender, EventArgs e) { System.Data.DataTable result = new System.Data.DataTable(); result.Columns.Add(new DataColumn("SI", typeof(String))); result.Columns.Add(new DataColumn("SIdate", typeof(DateTime))); result.Columns.Add(new DataColumn("PO", typeof(String))); result.Columns.Add(new DataColumn("custName", typeof(String))); result.Columns.Add(new DataColumn("address", typeof(String))); result.Columns.Add(new DataColumn("business", typeof(String))); result.Columns.Add(new DataColumn("Tin", typeof(String))); result.Columns.Add(new DataColumn("Terms", typeof(String))); result.Columns.Add(new DataColumn("productCode", typeof(String))); result.Columns.Add(new DataColumn("description", typeof(String))); result.Columns.Add(new DataColumn("qty", typeof(int))); result.Columns.Add(new DataColumn("unit", typeof(String))); result.Columns.Add(new DataColumn("price", typeof(Decimal))); result.Columns.Add(new DataColumn("dics", typeof(int))); result.Columns.Add(new DataColumn("amount", typeof(Decimal))); result.Columns.Add(new DataColumn("totalAmount", typeof(Decimal))); result.Columns.Add(new DataColumn("vat", typeof(Decimal))); result.Columns.Add(new DataColumn("discount", typeof(Decimal))); result.Columns.Add(new DataColumn("amountDue", typeof(Decimal))); DataRow resultRow = result.NewRow(); var dt = DataSupport.RunDataSet("SELECT * FROM Global_ProductTrans p join Global_ProductTransDetails d on p.outgoing_Id = d.outgoing_Id join base_customer c on p.custCode = c.custCode where p.siNo = '" + txtsI.Text + "'").Tables[0]; foreach (DataRow row in dt.Rows) { resultRow = result.NewRow(); resultRow["SI"] = row["siNo"].ToString(); resultRow["SIdate"] = row["sidate"].ToString(); resultRow["PO"] = row["poNo"].ToString(); resultRow["custName"] = row["custName"].ToString(); resultRow["address"] = row["address"].ToString(); resultRow["business"] = row["BusinessStyle"].ToString(); resultRow["Tin"] = row["tinNo"].ToString(); resultRow["Terms"] = row["terms"].ToString(); resultRow["productCode"] = row["product_code"].ToString(); resultRow["description"] = row["description"].ToString(); resultRow["qty"] = row["qty"].ToString(); resultRow["unit"] = row["uom"].ToString(); resultRow["price"] = row["price"].ToString(); resultRow["dics"] = row["dics"].ToString(); resultRow["amount"] = row["amount"].ToString(); resultRow["totalAmount"] = row["totalAmount"].ToString(); resultRow["vat"] = row["vat"].ToString(); resultRow["discount"] = row["discount"].ToString(); resultRow["amountDue"] = row["AmountDue"].ToString(); result.Rows.Add(resultRow); } var viewer = new Reports.ReportViewer(); ReportDocument ReportDocs = new ReportDocument(); if (cbxchoose.Text == "Extra Copy") { ReportDocs = new Reports.Extracopy.extraSI(); } else { ReportDocs = new Reports.SalesInvoice(); } ReportDocs.Database.Tables[0].SetDataSource(result); viewer.Viewer.ReportSource = ReportDocs; viewer.btnDeclare.Visible = false; viewer.ShowDialog(); }
private void btnDeclare_Click(object sender, EventArgs e) { System.Data.DataTable result = new System.Data.DataTable(); result.Columns.Add(new DataColumn("SI", typeof(String))); result.Columns.Add(new DataColumn("SIdate", typeof(DateTime))); result.Columns.Add(new DataColumn("PO", typeof(String))); result.Columns.Add(new DataColumn("custName", typeof(String))); result.Columns.Add(new DataColumn("address", typeof(String))); result.Columns.Add(new DataColumn("business", typeof(String))); result.Columns.Add(new DataColumn("Tin", typeof(String))); result.Columns.Add(new DataColumn("Terms", typeof(String))); result.Columns.Add(new DataColumn("productCode", typeof(String))); result.Columns.Add(new DataColumn("description", typeof(String))); result.Columns.Add(new DataColumn("qty", typeof(int))); result.Columns.Add(new DataColumn("unit", typeof(String))); result.Columns.Add(new DataColumn("price", typeof(Decimal))); result.Columns.Add(new DataColumn("dics", typeof(int))); result.Columns.Add(new DataColumn("amount", typeof(Decimal))); result.Columns.Add(new DataColumn("totalAmount", typeof(Decimal))); result.Columns.Add(new DataColumn("vat", typeof(Decimal))); result.Columns.Add(new DataColumn("discount", typeof(Decimal))); result.Columns.Add(new DataColumn("amountDue", typeof(Decimal))); DataRow resultRow = result.NewRow(); resultRow = result.NewRow(); resultRow["SI"] = txtSI.Text; resultRow["SIdate"] = txtSiDate.Text; resultRow["PO"] = txtPO.Text; resultRow["custName"] = txtCustName.Text; resultRow["address"] = txtAddress.Text; resultRow["business"] = Business; resultRow["Tin"] = txtTin.Text; resultRow["Terms"] = txtTerms.Text; result.Rows.Add(resultRow); foreach (DataGridViewRow dRow in dataGridView1.Rows) { if (dataGridView1.Rows.IndexOf(dRow) == dataGridView1.Rows.Count - 1) { break; } resultRow = result.NewRow(); resultRow["productCode"] = dRow.Cells[colCode.Name].Value; resultRow["description"] = dRow.Cells[colDescription.Name].Value; resultRow["qty"] = dRow.Cells[colQty.Name].Value; resultRow["unit"] = dRow.Cells[colUnit.Name].Value; resultRow["price"] = dRow.Cells[colPrice.Name].Value; resultRow["dics"] = dRow.Cells[colDisc.Name].Value; resultRow["amount"] = dRow.Cells[colAmount.Name].Value; result.Rows.Add(resultRow); } resultRow = result.NewRow(); resultRow["totalAmount"] = Details[2].ToString(); resultRow["vat"] = Details[1].ToString(); resultRow["discount"] = Details[3].ToString(); resultRow["amountDue"] = Details[0].ToString(); result.Rows.Add(resultRow); var viewer = new Reports.ReportViewer(); ReportDocument ReportDocs = new ReportDocument(); ReportDocs = new Reports.SalesInvoice(); ReportDocs.Database.Tables[0].SetDataSource(result); viewer.Viewer.ReportSource = ReportDocs; viewer.btnPrint.Visible = false; viewer.ShowDialog(); if (viewer._status == "save") { saved(); clear(); } }