private void FrmHistory_Load(object sender, EventArgs e) { DataSet invoices = new DAO.InvoiceDAO().getAllInvoices(); dgvReport.DataSource = invoices.Tables[0]; Utility.setGridHeaderText("លេខកូដវិក្ក័យប័ត្រ|កាលបរិច្ឆេទចេញវិក្ក័យប័ត្រ|ឈ្មោះអ្នកលក់|តម្លៃសរុប", dgvReport); Utility.setGridHeaderWidth("100|200|300|200", dgvReport); dgvReport.Columns["id"].Visible= false; }
private void txtInvoiceCode_Leave(object sender, EventArgs e) { cboOldProduct.Items.Clear(); //List Product from Invoice to Old Combo int invoiceid = int.Parse(txtInvoiceCode.Text.Substring(9)); DTO.Invoice invoice = new DAO.InvoiceDAO().getInvoice(invoiceid); for (int i = 0; i < invoice.InvoiceDetail.Count; i++) { DTO.Product product = ((DTO.InvoiceDetail)invoice.InvoiceDetail[i]).Product; Item item = new Item(product.Productname, product.Productid); cboOldProduct.Items.Add(item); } }
public FrmReport() { InitializeComponent(); productDAO = new DAO.ProductDAO(); invoiceDAO = new DAO.InvoiceDAO(); transactionDAO = new DAO.TransactionDAO(); memberDAO = new DAO.MemberDAO(); staffDAO = new DAO.StaffDAO(); DataSet ds = new DAO.StaffDAO().GetAllStaffs(); //DataRow dr = new DataRow("SELECT"); //ds.Tables[0].Rows.InsertAt(,0); cboStaffs.DataSource = ds.Tables[0]; cboStaffs.DisplayMember = "staffname"; cboStaffs.ValueMember = "staffid"; //cboMember.Items.Insert(0, "-Select-"); }
private void txtInvoiceCode_Leave(object sender, EventArgs e) { try { cboOldProduct.Items.Clear(); //List Product from Invoice to Old Combo int invoiceid = int.Parse(txtInvoiceCode.Text.Substring(2)); DTO.Invoice invoice = new DAO.InvoiceDAO().getInvoice(invoiceid); for (int i = 0; i < invoice.InvoiceDetail.Count; i++) { DTO.Product product = ((DTO.InvoiceDetail)invoice.InvoiceDetail[i]).Product; Item item = new Item(product.Productname, product.Productid); cboOldProduct.Items.Add(item); } } catch (Exception e1) { MessageBox.Show("សូមបំពេញពត័មានឲ្យបានត្រឺមត្រូវ"); } }