private void btPrint_Click(object sender, EventArgs e) { if (this.invoiceMasterBindingSource.Count == 0) { return; } MDataSet.InvoiceMasterRow _curentMasterRow = (this.invoiceMasterBindingSource.Current as DataRowView).Row as MDataSet.InvoiceMasterRow; if (_curentMasterRow == null) { return; } try { FormPrintDialog fromDialog = new FormPrintDialog("/ReportRetailTrade/InvoiceMasterByID"); ReportParameter ReceiptMasterRef = new ReportParameter("InvoiceMasterRef", _curentMasterRow.ID.ToString()); fromDialog.reportViewer.ServerReport.SetParameters(new ReportParameter[] { ReceiptMasterRef }); fromDialog.ShowDialog(this); } catch (Exception err) { MessageBox.Show(err.Message); } }
private void gridViewInvDetAll_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e) { DevExpress.XtraGrid.Views.Grid.GridView CurrentView = (sender as DevExpress.XtraGrid.Views.Grid.GridView); MDataSet.InvoiceMasterRow _row = (CurrentView.GetDataRow(e.RowHandle) as MDataSet.InvoiceDetailRow).InvoiceMasterRow; if (_row.NumCheck > 0) { e.Appearance.Font = e.Cache.GetFont(e.Appearance.Font, FontStyle.Italic); // if (e.RowHandle == CurrentView.FocusedRowHandle) return; e.Appearance.ForeColor = Color.Gray; } if (_row.DocumentTypeRef == 4) { e.Appearance.Font = e.Cache.GetFont(e.Appearance.Font, FontStyle.Italic); // if (e.RowHandle == CurrentView.FocusedRowHandle) return; e.Appearance.ForeColor = Color.Gray; // e.Appearance.BackColor = Color.LightPink; } }
private void btMakeToNew_Click(object sender, EventArgs e) { MDataSet.InvoiceMasterRow _dr = (this.grid.FocusedView as GridView).GetDataRow((this.grid.FocusedView as GridView).FocusedRowHandle) as MDataSet.InvoiceMasterRow; if ((_dr) == null) { return; } if (_dr.RemoteStockRef != 0) { MessageBox.Show("Ќельз¤ удал¤ть внутренние перемещени¤!"); return; } try { (this.ParentForm as MainForm).invoiceMasterTableAdapter.InvoiceMasterMakeToNew(_dr.ID); (this.ParentForm as MainForm).FillTableNewDocuments(this.mDataSet.InvoiceMaster); } catch (Exception err) { MessageBox.Show(err.Message); } }
public InvoiceDetailEdit(MDataSet.InvoiceMasterRow source, MDataSet.ProductDataTable product, MainForm mainForm) { InitializeComponent(); _mainForm = mainForm; this.mDataSet = source.Table.DataSet as MDataSet; this.productBindingSource.DataSource = product; this.productBindingSource.ResetBindings(false); // this.RemainsBindingSource.DataSource = new DataView(this.mDataSet.Remains, "MainStockRef=" + source.MainStockRef.ToString(), null, DataViewRowState.CurrentRows); this.RemainsBindingSource.DataSource = new DataView(this.mDataSet.Remains, "Quantityremains<>0 and MainStockRef=" + source.MainStockRef.ToString(), "ProductName", DataViewRowState.CurrentRows); this.RemainsBindingSource.ResetBindings(true); this.invoiceMasterBindingSource.DataSource = source; this.invoiceMasterBindingSource.ResetBindings(true); this.invoiceMasterBindingSourceView.DataSource = source.Table; this.invoiceMasterBindingSourceView.ResetBindings(true); this.invoiceMasterBindingSourceView.CurrencyManager.Position = this.invoiceMasterBindingSourceView.Find("ID", source.ID); this.invoiceDetailBindingSource.DataSource = this.invoiceMasterBindingSourceView; this.invoiceDetailBindingSource.DataMember = "FK_InvoiceDetail_InvoiceMaster"; this.invoiceDetailBindingSource.ResetBindings(true); }
private void btOpen_Click(object sender, EventArgs e) { MDataSet.InvoiceMasterRow _row = this.gridViewInvAll.GetDataRow(this.gridViewInvAll.FocusedRowHandle) as MDataSet.InvoiceMasterRow; if (_row != null) { if (_row.DocumentTypeRef == 0) { InvoicePrintMar _invoiceDetail = new InvoicePrintMar(this.ParentForm as MainForm, _row, _printer); if (DialogResult.OK == _invoiceDetail.ShowDialog(this)) { this.labelCashCustomer.Text = _invoiceDetail.CashCustomer.ToString(); this.LableChanges.Text = _invoiceDetail.Changes.ToString(); this.LabelLastSum.Text = _invoiceDetail.LastSum.ToString(); } _invoiceDetail.Dispose(); GC.Collect(); } } }
private void btDelete_Click(object sender, EventArgs e) { try { //удалить пустую строку MDataSet.InvoiceMasterRow mast = this.gridViewInvDatAll.GetDataRow(this.gridViewInvDatAll.FocusedRowHandle) as MDataSet.InvoiceMasterRow; if (mast == null) { return; } if (mast.GetInvoiceDetailRows().Length == 0) { this.invoiceMasterBindingSource.RemoveCurrent(); this.invoiceMasterBindingSource.EndEdit(); this._mainForm.SaveToBase(mast); } else { MessageBox.Show("Документ не пустой!"); } } catch (Exception err) { MainForm.Log("btDelete_Click" + err.Message); MessageBox.Show("Ошибка : " + err.Message); } }
public bool RefreshData(MDataSet.InvoiceMasterRow sourceRow) { if (sourceRow == null) { return(false); } MDataSet.InvoiceMasterDataTable _invoiceMasterDataTable = new MDataSet.InvoiceMasterDataTable(); MDataSet.InvoiceDetailDataTable _invoiceDetailDataTable = new MDataSet.InvoiceDetailDataTable(); MDataSet.RemainsDataTable _remainsDataTable = new MDataSet.RemainsDataTable(); try { this.RemainsTableAdapter.FillByInvoiceMasterID(_remainsDataTable, sourceRow.ID); this.invoiceMasterTableAdapter.FillNew(_invoiceMasterDataTable); this.invoiceDetailTableAdapter.FillByInvoiceMasterRef(_invoiceDetailDataTable, sourceRow.ID); } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.InvoiceMasterRow sourceRow) " + err.Message + " " + err.Source); return(false); } finally { this.mDataSet.Remains.Merge(_remainsDataTable); this.mDataSet.InvoiceMaster.Merge(_invoiceMasterDataTable); this.mDataSet.InvoiceDetail.Merge(_invoiceDetailDataTable); } return(true); }
private void btDelete_Click(object sender, EventArgs e) { try { MDataSet.InvoiceMasterRow master = this.gridViewInvAll.GetDataRow(this.gridViewInvAll.FocusedRowHandle) as MDataSet.InvoiceMasterRow; if (master == null) { return; } if (master.GetInvoiceDetailRows().Length > 0) { MessageBox.Show("Невозможно удалить документ!"); return; } this.invoiceMasterBindingSource.RemoveCurrent(); this.invoiceMasterBindingSource.EndEdit(); this._mainForm.SaveToBase(master); } catch (Exception err) { MainForm.Log(" btDelete_Click" + err.Message); MessageBox.Show(err.Message); } }
public InvoiceRow(MDataSet.InvoiceMasterRow source) { InitializeComponent(); _curentMasterRow = source; mainDataset = source.Table.DataSet as MDataSet; }
public InvoiceRow(MDataSet.InvoiceMasterRow source) { InitializeComponent(); _curentMasterRow = source; mainDataset= source.Table.DataSet as MDataSet; }
public Payment(MDataSet.InvoiceMasterRow sourceRow) { InitializeComponent(); _sourceRow = sourceRow; // _CashCustomer = 0; this.invoiceMasterBindingSource.DataSource = _sourceRow; CashEdit.DataBindings.Add(new Binding("Text", this, "CashCustomer")); labelCanges.DataBindings.Add(new Binding("Text", this, "Change")); }
public bool SaveToBase(MDataSet.InvoiceMasterRow sourceRow) { MDataSet.RemainsDataTable _rem = new MDataSet.RemainsDataTable(); try { int res = this.invoiceMasterTableAdapter.Update(sourceRow); int res1 = this.invoiceDetailTableAdapter.Update(this.mDataSet.InvoiceDetail); if (sourceRow.HasVersion(DataRowVersion.Current)) { this.RemainsTableAdapter.FillByInvoiceMasterID(_rem, sourceRow.ID); this.mDataSet.Remains.Merge(_rem); } } catch (DBConcurrencyException dbcx) { this.onInvoiceMasterDBCError(dbcx); return(false); } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { OnInvoiceMasterSQLError(sqlerr, sourceRow); } else { caughtGlobalError(sqlerr); } Log("SaveToBase(MDataSet.InvoiceMasterRow sourceRow) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return(false); } catch (Exception err) { MessageBox.Show(err.Message); Log("SaveToBase(MDataSet.InvoiceMasterRow sourceRow) ERROR" + err.Message + " " + err.Source); return(false); } finally { RefreshData(sourceRow.Table as MDataSet.InvoiceMasterDataTable); } return(true); }
public Payment(MDataSet.InvoiceMasterRow sourceRow) { InitializeComponent(); _sourceRow = sourceRow; // _CashCustomer = 0; this.invoiceMasterBindingSource.DataSource = _sourceRow; CashEdit.DataBindings.Add(new Binding("Text",this,"CashCustomer")); labelCanges.DataBindings.Add(new Binding("Text", this, "Change")); }
public InvoicePrintMar(MainForm mainForm, MDataSet.InvoiceMasterRow source, Maria301Printer printer) { InitializeComponent(); this.mDataSet = mainForm.mDataSet; _mainForm = mainForm; _printer = printer; this.remainsBindingSource.DataSource = new DataView(this.mDataSet.Remains, "QuantityRemains >0 ", null, DataViewRowState.CurrentRows); _invmasterRow = source; }
public bool RefreshData(MDataSet.InvoiceMasterRow sourceRow) { if (sourceRow == null) { return(false); } MDataSet.InvoiceMasterDataTable _invoiceMasterDataTable = new MDataSet.InvoiceMasterDataTable(); MDataSet.InvoiceDetailDataTable _invoiceDetailDataTable = new MDataSet.InvoiceDetailDataTable(); MDataSet.RemainsDataTable _remainsDataTable = new MDataSet.RemainsDataTable(); try { this.invoiceDetailTableAdapter.Update(this.mDataSet.InvoiceDetail); this.RemainsTableAdapter.FillByInvoiceMasterID(_remainsDataTable, sourceRow.ID); this.invoiceMasterTableAdapter.FillNew(_invoiceMasterDataTable); this.invoiceDetailTableAdapter.FillNew(_invoiceDetailDataTable); } catch (DBConcurrencyException dbcx) { this.onInvoiceDetailDBCError(dbcx); this.LabelUser.Text = "Ошибка совмесного доступа"; MainForm.Log(dbcx.Message); RefreshData(sourceRow); return(false); } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.InvoiceMasterRow sourceRow) " + err.Message + " " + err.Source); return(false); } finally { MergeRemains(_remainsDataTable); this.mDataSet.InvoiceMaster.Merge(_invoiceMasterDataTable); this.mDataSet.InvoiceDetail.Merge(_invoiceDetailDataTable); } return(true); }
private void btAdd_Click(object sender, EventArgs e) { if ((this.ParentForm as MainForm) != null) { this.invoiceMasterBindingSource.CurrencyManager.EndCurrentEdit(); MDataSet.InvoiceMasterRow sourceRow = (this.invoiceMasterBindingSource.AddNew() as DataRowView).Row as MDataSet.InvoiceMasterRow; this.invoiceMasterBindingSource.CurrencyManager.EndCurrentEdit(); Object[] paramtrs = new Object[1] { sourceRow }; (this.ParentForm as MainForm).ShowNewDataTab("InvoiceRow", "Создание накладной", paramtrs); } }
private void btOpen_Click(object sender, EventArgs e) { /* if (_) * { * * MessageBox.Show("Ошибка принтера :InitDataCash false"); * return; * }*/ MDataSet.InvoiceMasterRow _master = this.gridViewInvDatAll.GetDataRow(this.gridViewInvDatAll.FocusedRowHandle) as MDataSet.InvoiceMasterRow; if (_master == null) { return; } if (_master.DocumentTypeRef != 0) { MessageBox.Show("Документ закрыт!"); return; } InvoiceDetailDatecs _InvoiceDetailDatecs = new InvoiceDetailDatecs(this.ParentForm as MainForm, _master); _InvoiceDetailDatecs.Text = "Открыть расходный документ"; if (DialogResult.OK == _InvoiceDetailDatecs.ShowDialog(this)) { if (!InitDataCash()) { MessageBox.Show("Ошибка принтера :InitDataCash false"); return; } } else { this.mDataSet.InvoiceMaster.RejectChanges(); } _InvoiceDetailDatecs.Free(); _InvoiceDetailDatecs = null; GC.Collect(); }
public bool MakeToReturn(MDataSet.InvoiceMasterRow sourceRow) { int res; try { this.SaveToBase(sourceRow); res = this.invoiceMasterTableAdapter.InvoiceMasterMakeToReturn(sourceRow.ID); } catch (DBConcurrencyException dbcx) { this.onInvoiceMasterDBCError(dbcx); return(false); } catch (SqlException sqlerr) { if (sqlerr.Class < 17) { OnInvoiceMasterSQLError(sqlerr, sourceRow); } else { caughtGlobalError(sqlerr); } Log("SaveToBase(MDataSet.InvoiceMasterRow sourceRow) ERROR" + sqlerr.Message + " " + sqlerr.Source + sqlerr.InnerException.Message); return(false); } catch (Exception err) { MessageBox.Show(err.Message); Log("SaveToBase(MDataSet.InvoiceMasterRow sourceRow) ERROR" + err.Message + " " + err.Source + err.InnerException.Message); return(false); } finally { RefreshData(sourceRow as MDataSet.InvoiceMasterRow); } return(true); }
public InvoiceDetailDatecs(MainForm mainForm, MDataSet.InvoiceMasterRow sourcerow) { InitializeComponent(); this.mDataSet = mainForm.mDataSet; _mainForm = mainForm; _invmasterRow = sourcerow; this.CashBindingSource.DataSource = _mainForm.cashBindingSource.Current as MDataSet.CashRow; this.remainsBindingSource.DataSource = new DataView(this.mDataSet.Remains, "QuantityRemains >0 ", null, DataViewRowState.CurrentRows); if (_mainForm.LocalSettingRow.PrDiscount != 0) { btPayDiscount.Visible = true; cardDiscountButton.Visible = true; } }
public bool RefreshData(MDataSet.InvoiceMasterRow sourceRow, bool isMerge) { MDataSet.InvoiceMasterDataTable _invoiceMasterDataTable = new MDataSet.InvoiceMasterDataTable(); try { this.invoiceMasterTableAdapter.FillNew(_invoiceMasterDataTable); } catch (Exception err) { MessageBox.Show(err.Message); Log("RefreshData(MDataSet.InvoiceMasterRow sourceRow) " + err.Message + " " + err.Source + err.InnerException.Message); return(false); } finally { this.mDataSet.InvoiceMaster.Merge(_invoiceMasterDataTable); } return(true); }
private void InvoicePrintMar_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'mDataSet.Product' table. You can move, or remove it, as needed. // this.productTableAdapter.Fill(this.mDataSet.Product); _printer.Info.RefreshData(); if (_printer.HasError) { MessageBox.Show(_printer.ErrorText); this.DialogResult = DialogResult.Abort; return; } else { this.invoiceMasterBindingSourceView.DataSource = mDataSet.InvoiceMaster; this.invoiceMasterBindingSourceView.ResetBindings(true); // если новый документ if (_invmasterRow == null) { _invmasterRow = (invoiceMasterBindingSourceView.AddNew() as DataRowView).Row as MDataSet.InvoiceMasterRow; this.invoiceMasterBindingSourceView.EndEdit(); this.btDelete.Visible = false; _printer.OpenCheck(_mainForm.LocalSettingRow.MainTradePutletRef.ToString()); } else //если открыть { this.invoiceMasterBindingSourceView.Position = this.invoiceMasterBindingSourceView.Find("Id", _invmasterRow.ID); this.gridRem.Enabled = false; this.btPay.Visible = false; this.btPrintCheck.Visible = true; this.btDelete.Visible = true; this.btPayMenu.Enabled = false; } this._mainForm.SaveToBase(_invmasterRow); this.invoiceMasterBindingSource.DataSource = _invmasterRow; this.invoiceMasterBindingSource.ResetBindings(true); this.invoiceDetailBindingSource.DataSource = this.invoiceMasterBindingSourceView; this.invoiceDetailBindingSource.DataMember = "FK_InvoiceDetail_InvoiceMaster"; this.invoiceDetailBindingSource.ResetBindings(true); foreach (GridView view in this.gridRem.ViewCollection) { string fileName = new FileInfo(Application.ExecutablePath).DirectoryName + "\\" + view.Name.ToString() + ".xml"; if (File.Exists(fileName)) { view.RestoreLayoutFromXml(fileName); } } foreach (GridView view in this.gridDet.ViewCollection) { string fileName = new FileInfo(Application.ExecutablePath).DirectoryName + "\\" + view.Name.ToString() + ".xml"; if (File.Exists(fileName)) { view.RestoreLayoutFromXml(fileName); } } } }
private void OnInvoiceMasterSQLError(SqlException sqlerr, MDataSet.InvoiceMasterRow sourceRow) { MessageBox.Show(sqlerr.Message); }
private void OnInvoiceMasterSQLError(SqlException sqlerr, MDataSet.InvoiceMasterRow sourceRow) { throw new Exception("The method or operation is not implemented."); }
private void InvoiceDetailDatecs_Load(object sender, EventArgs e) { _printer = new Datecs(); if (_printer.HasError) { MessageBox.Show(_printer.ErrorText); _printer.Close(); this.DialogResult = DialogResult.Abort; return; } else { this.invoiceMasterBindingSourceView.DataSource = mDataSet.InvoiceMaster; this.invoiceMasterBindingSourceView.ResetBindings(true); // если новый документ if (_invmasterRow == null) { _invmasterRow = (invoiceMasterBindingSourceView.AddNew() as DataRowView).Row as MDataSet.InvoiceMasterRow; this.invoiceMasterBindingSourceView.EndEdit(); _printer.OpenCheck(_mainForm.LocalSettingRow.Num); } else //если открыть { this.invoiceMasterBindingSourceView.Position = this.invoiceMasterBindingSourceView.Find("Id", _invmasterRow.ID); this.gridRem.Enabled = false; this.btPay.Visible = false; this.creditCardButton.Visible = false; this.cardDiscountButton.Visible = false; this.btPayDiscount.Visible = false; this.btDeleteInСheck.Visible = false; this.btPrintCheck.Visible = true; this.printCreditCardButton.Visible = true; this.btDelete.Visible = true; this.btPayMenu.Enabled = false; } this.invoiceMasterBindingSource.DataSource = _invmasterRow; this.invoiceMasterBindingSource.ResetBindings(true); this.invoiceDetailBindingSource.DataSource = this.invoiceMasterBindingSourceView; this.invoiceDetailBindingSource.DataMember = "FK_InvoiceDetail_InvoiceMaster"; this.invoiceDetailBindingSource.ResetBindings(true); foreach (GridView view in this.gridRem.ViewCollection) { string fileName = new FileInfo(Application.ExecutablePath).DirectoryName + "\\" + view.Name.ToString() + ".xml"; if (File.Exists(fileName)) { view.RestoreLayoutFromXml(fileName); } } foreach (GridView view in this.gridDet.ViewCollection) { string fileName = new FileInfo(Application.ExecutablePath).DirectoryName + "\\" + view.Name.ToString() + ".xml"; if (File.Exists(fileName)) { view.RestoreLayoutFromXml(fileName); } } } }
private void InvoicePrintMar_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'mDataSet.Product' table. You can move, or remove it, as needed. // this.productTableAdapter.Fill(this.mDataSet.Product); _printer.Info.RefreshData(); if (_printer.HasError) { MessageBox.Show(_printer.ErrorText); this.DialogResult = DialogResult.Abort; return; } else { this.invoiceMasterBindingSourceView.DataSource = mDataSet.InvoiceMaster; this.invoiceMasterBindingSourceView.ResetBindings(true); // если новый документ if (_invmasterRow == null) { _invmasterRow = (invoiceMasterBindingSourceView.AddNew() as DataRowView).Row as MDataSet.InvoiceMasterRow; this.invoiceMasterBindingSourceView.EndEdit(); this.btDelete.Visible = false; _printer.OpenCheck(_mainForm.LocalSettingRow.MainTradePutletRef.ToString()); } else //если открыть { this.invoiceMasterBindingSourceView.Position = this.invoiceMasterBindingSourceView.Find("Id", _invmasterRow.ID); this.gridRem.Enabled = false; this.btPay.Visible = false; this.btPrintCheck.Visible = true; this.btDelete.Visible = true; this.btPayMenu.Enabled = false; } this._mainForm.SaveToBase(_invmasterRow); this.invoiceMasterBindingSource.DataSource = _invmasterRow; this.invoiceMasterBindingSource.ResetBindings(true); this.invoiceDetailBindingSource.DataSource = this.invoiceMasterBindingSourceView; this.invoiceDetailBindingSource.DataMember = "FK_InvoiceDetail_InvoiceMaster"; this.invoiceDetailBindingSource.ResetBindings(true); foreach (GridView view in this.gridRem.ViewCollection) { string fileName = new FileInfo(Application.ExecutablePath).DirectoryName + "\\" + view.Name.ToString() + ".xml"; if (File.Exists(fileName)) view.RestoreLayoutFromXml(fileName); } foreach (GridView view in this.gridDet.ViewCollection) { string fileName = new FileInfo(Application.ExecutablePath).DirectoryName + "\\" + view.Name.ToString() + ".xml"; if (File.Exists(fileName)) view.RestoreLayoutFromXml(fileName); } } }
private void InvoiceDetailDatecs_Load(object sender, EventArgs e) { _printer = new Datecs(); if (_printer.HasError) { MessageBox.Show(_printer.ErrorText); _printer.Close(); this.DialogResult = DialogResult.Abort; return; } else { this.invoiceMasterBindingSourceView.DataSource = mDataSet.InvoiceMaster; this.invoiceMasterBindingSourceView.ResetBindings(true); // если новый документ if (_invmasterRow == null) { _invmasterRow = (invoiceMasterBindingSourceView.AddNew() as DataRowView).Row as MDataSet.InvoiceMasterRow; this.invoiceMasterBindingSourceView.EndEdit(); _printer.OpenCheck(_mainForm.LocalSettingRow.Num); } else //если открыть { this.invoiceMasterBindingSourceView.Position = this.invoiceMasterBindingSourceView.Find("Id", _invmasterRow.ID); this.gridRem.Enabled = false; this.btPay.Visible = false; this.creditCardButton.Visible = false; this.cardDiscountButton.Visible = false; this.btPayDiscount.Visible = false; this.btDeleteInСheck.Visible = false; this.btPrintCheck.Visible = true; this.printCreditCardButton.Visible = true; this.btDelete.Visible = true; this.btPayMenu.Enabled = false; } this.invoiceMasterBindingSource.DataSource = _invmasterRow; this.invoiceMasterBindingSource.ResetBindings(true); this.invoiceDetailBindingSource.DataSource = this.invoiceMasterBindingSourceView; this.invoiceDetailBindingSource.DataMember = "FK_InvoiceDetail_InvoiceMaster"; this.invoiceDetailBindingSource.ResetBindings(true); foreach (GridView view in this.gridRem.ViewCollection) { string fileName = new FileInfo(Application.ExecutablePath).DirectoryName + "\\" + view.Name.ToString() + ".xml"; if (File.Exists(fileName)) view.RestoreLayoutFromXml(fileName); } foreach (GridView view in this.gridDet.ViewCollection) { string fileName = new FileInfo(Application.ExecutablePath).DirectoryName + "\\" + view.Name.ToString() + ".xml"; if (File.Exists(fileName)) view.RestoreLayoutFromXml(fileName); } } }