private void mnuPurchaseList_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (DBGrid.CurrentRow == null) { return; } modCustomerOrderList mod = (modCustomerOrderList)DBGrid.CurrentRow.DataBoundItem; dalPurchaseList dal = new dalPurchaseList(); BindingCollection <modVPurchaseDetail> list = dal.GetVDetail(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, mod.ProductId, string.Empty, mod.CustOrderNo, string.Empty, string.Empty, out Util.emsg); if (list != null && list.Count > 0) { frmViewList frm = new frmViewList(); frm.InitViewList(clsTranslate.TranslateString("Purchase List"), list); frm.ShowDialog(); } else { MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } finally { this.Cursor = Cursors.Default; } }
protected void LoadData() { try { this.Cursor = Cursors.WaitCursor; string statuslist = "9"; if (chkNotAudit.Checked) { statuslist += ",0"; } if (chkAudited.Checked) { statuslist += ",1"; } string paystatuslist = string.Empty; if (chkPay0.Checked) { paystatuslist += ",0"; } if (chkPay1.Checked) { paystatuslist += ",1"; } string invoicestatuslist = string.Empty; if (chkInvoice0.Checked) { invoicestatuslist += ",0"; } if (chkInvoice1.Checked) { invoicestatuslist += ",1"; } if (chkInvoice2.Checked) { invoicestatuslist += ",2"; } string vendorlist = string.Empty; if (lstVendor.SelectedItems.Count > 0 && lstVendor.SelectedItems.Count < lstVendor.Items.Count) { for (int i = 0; i < lstVendor.SelectedItems.Count; i++) { modVendorList mod = (modVendorList)lstVendor.SelectedItems[i]; if (i == 0) { vendorlist = mod.VendorName; } else { vendorlist += "," + mod.VendorName; } } } BindingCollection <modVPurchaseDetail> list = _dal.GetVDetail(statuslist, cboPurchaseType.SelectedValue.ToString(), vendorlist, string.Empty, txtInvNo.Text.Trim(), paystatuslist, invoicestatuslist, string.Empty, string.Empty, txtProductName.Text.Trim(), string.Empty, dtpFrom.Text, dtpTo.Text, out Util.emsg); DBGrid.DataSource = list; decimal sum = 0; if (list != null && list.Count > 0) { foreach (modVPurchaseDetail mod in list) { sum += mod.Qty * mod.Price; } ShowColor(); StatusLabel1.Text = "共 " + list.Count.ToString() + " 行数据, 合计金额为: " + string.Format("{0:C2}", sum); } else { if (!string.IsNullOrEmpty(Util.emsg)) { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } StatusLabel1.Text = "共 0 行数据, 合计金额为: " + string.Format("{0:C2}", sum); } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { this.Cursor = Cursors.Default; } }
private void DBGrid_DoubleClick(object sender, EventArgs e) { if (DBGrid.CurrentRow == null) { return; } string statuslist = "9"; if (chkNotAudit.Checked) { statuslist += ",0"; } if (chkAudited.Checked) { statuslist += ",1"; } string paystatuslist = string.Empty; if (chkPay0.Checked) { paystatuslist += ",0"; } if (chkPay1.Checked) { paystatuslist += ",1"; } string invoicestatuslist = string.Empty; if (chkInvoice0.Checked) { invoicestatuslist += ",0"; } if (chkInvoice1.Checked) { invoicestatuslist += ",1"; } if (chkInvoice2.Checked) { invoicestatuslist += ",2"; } string vendorlist = string.Empty; if (lstVendor.SelectedItems.Count > 0 && lstVendor.SelectedItems.Count < lstVendor.Items.Count) { for (int i = 0; i < lstVendor.SelectedItems.Count; i++) { modVendorList mod = (modVendorList)lstVendor.SelectedItems[i]; if (i == 0) { vendorlist = mod.VendorName; } else { vendorlist += "," + mod.VendorName; } } } BindingCollection <modVPurchaseDetail> list = new BindingCollection <modVPurchaseDetail>(); if (DBGrid.CurrentRow.Index == DBGrid.RowCount - 1) { list = _dal.GetVDetail(statuslist, cboPurchaseType.SelectedValue.ToString(), vendorlist, string.Empty, string.Empty, paystatuslist, invoicestatuslist, string.Empty, string.Empty, string.Empty, string.Empty, dtpFrom.Text, dtpTo.Text, out Util.emsg); } else { modPurchaseSummary moditem = (modPurchaseSummary)DBGrid.CurrentRow.DataBoundItem; list = _dal.GetVDetail(string.Empty, moditem.PurchaseType, moditem.VendorName, string.Empty, string.Empty, paystatuslist, invoicestatuslist, moditem.Currency, string.Empty, string.Empty, string.Empty, dtpFrom.Text, dtpTo.Text, out Util.emsg); } if (list != null && list.Count > 0) { frmViewList frm = new frmViewList(); frm.InitViewList(clsTranslate.TranslateString("Purchase List"), list); frm.ShowDialog(); } }