private void printInvoice() { if ((gridData.SelectedRows.Count > 0 && !(gridData.SelectedRows[0].Cells[0].Value + "").Equals(""))) { List <reportInvoice> list = new List <reportInvoice>(); string invCode = gridData.SelectedRows[0].Cells["InvoiceCode"].Value + ""; DataTable dt = Data.Datatable("EXECUTE listInvoiceDetail2 @InvoiceCode = '" + invCode + "';"); foreach (DataRow row in dt.Rows) { reportInvoice inv = new reportInvoice(); inv.InvoiceCode = row["InvoiceCode"] + ""; inv.EmpName = row["Name"] + ""; inv.Date = row["Date"] + ""; inv.ServiceCode = row["ServiceCode"] + ""; inv.ServiceName = row["ServiceName"] + ""; inv.ServiceQty = int.Parse(row["ServiceQty"] + ""); inv.ServicePrice = double.Parse(row["ServicePrice"] + ""); inv.ServiceType = row["ServiceType"] + ""; list.Add(inv); } Reports.RevenueInvoiceDetail report = new Reports.RevenueInvoiceDetail(); report.SetDataSource(list); new frmReport(report).ShowDialog(); } else { MessageBox.Show("Please select one to print!"); } }
private void addCurrentInvoiceToPrint(string code) { DataSet ds = Helper.getDataSet("SELECT * FROM viewInvoice3 WHERE Code = '" + code + "';"); DataTable dt = ds.Tables[0]; listReport = new List <reportInvoice>(); for (int i = 0; i < dt.Rows.Count; i++) { reportInvoice dataList = new reportInvoice(); dataList.InvoiceCode = dt.Rows[i]["Code"].ToString(); dataList.ProCode = dt.Rows[i]["ProCode"].ToString(); dataList.ProName = dt.Rows[i]["ProductName"].ToString(); dataList.Quantity = Convert.ToInt32(dt.Rows[i]["Quantity"].ToString()); dataList.Price = Convert.ToDouble(dt.Rows[i]["Price"].ToString()); dataList.Amount = Convert.ToDouble(dt.Rows[i]["Amount"].ToString()); dataList.Sellby = dt.Rows[i]["EmployeeName"].ToString(); dataList.CustomerName = dt.Rows[i]["CustomerName"].ToString(); dataList.Phone = dt.Rows[i]["Phone"].ToString(); dataList.Address = dt.Rows[i]["Address"].ToString(); dataList.Date = dt.Rows[i]["Date"].ToString(); listReport.Add(dataList); } }
private void printInvoiceType() { if (gridData.SelectedRows.Count > 0 && !(gridData.SelectedRows[0].Cells[0].Value + "").Equals("")) { List <reportInvoice> list = new List <reportInvoice>(); DataGridViewRow row = null; for (int i = 0; i < gridData.RowCount - 1; i++) { row = gridData.Rows[i]; reportInvoice inv = new reportInvoice(); inv.ServiceType = row.Cells["ServiceType"].Value + ""; inv.ServiceQty = int.Parse(row.Cells["ServiceQty"].Value + ""); inv.ServicePrice = double.Parse(row.Cells["ServicePrice"].Value + ""); inv.ServiceName = row.Cells["ServiceName"].Value + ""; inv.InvoiceCode = row.Cells["InvoiceCode"].Value + ""; list.Add(inv); } Reports.RevenueInvoiceDetailType report = new Reports.RevenueInvoiceDetailType(); report.SetDataSource(list); new frmReport(report).ShowDialog(); } else { MessageBox.Show("No invoice to print!"); } }