private void LoadData() { if (_Code == 0) { txtIssuDate.Date = (new JDataBase()).GetCurrentDateTime(); grdReport.DataSource = JAUTDocumentDetails.GetBusCredit(); grdReport.gridEX1.AllowEdit = Janus.Windows.GridEX.InheritableBoolean.True; grdReport.gridEX1.CurrentTable.Columns["AccountNo"].EditType = Janus.Windows.GridEX.EditType.NoEdit; grdReport.gridEX1.CurrentTable.Columns["OwnerPCode"].EditType = Janus.Windows.GridEX.EditType.NoEdit; grdReport.gridEX1.CurrentTable.Columns["BusCode"].EditType = Janus.Windows.GridEX.EditType.NoEdit; grdReport.gridEX1.CurrentTable.Columns["BusNumber"].EditType = Janus.Windows.GridEX.EditType.NoEdit; grdReport.gridEX1.CurrentTable.Columns["OwnerName"].EditType = Janus.Windows.GridEX.EditType.NoEdit; grdReport.gridEX1.CurrentTable.Columns["TotalPrice"].EditType = Janus.Windows.GridEX.EditType.NoEdit; } else { JAUTPayment payment = new JAUTPayment(null, _Code); txtDesc.Text = payment.Description; txtIssuDate.Date = payment.PaymentDate; grdReport.DataSource = JAUTPaymentDetails.GetData(_Code); grdReport.gridEX1.AllowEdit = Janus.Windows.GridEX.InheritableBoolean.False; DisableAll(); } CalcSum(); }
private void btnPayment_Click(object sender, EventArgs e) { #region Validate if (txtDesc.Text.Trim() == "") { JMessages.Error("لطفا شرح پرداخت را وارد کنید.", ""); return; } if (grdReport.DataSource == null || grdReport.gridEX1.CurrentTable.Columns["OwnerPCode"].EditType != Janus.Windows.GridEX.EditType.NoEdit || grdReport.gridEX1.CurrentTable.Columns["AccountNo"].EditType != Janus.Windows.GridEX.EditType.NoEdit || grdReport.gridEX1.CurrentTable.Columns["BusCode"].EditType != Janus.Windows.GridEX.EditType.NoEdit || grdReport.gridEX1.CurrentTable.Columns["BusNumber"].EditType != Janus.Windows.GridEX.EditType.NoEdit || grdReport.gridEX1.CurrentTable.Columns["OwnerName"].EditType != Janus.Windows.GridEX.EditType.NoEdit || grdReport.gridEX1.CurrentTable.Columns["TotalPrice"].EditType != Janus.Windows.GridEX.EditType.NoEdit) { JMessages.Error("ثبت قابل انجام نمیباشد.", ""); return; } if (grdReport.DataSource.Rows.Count == 0) { JMessages.Error("هیچ تراکنشی برای پرداخت ثبت نشده است.", ""); return; } #endregion Validate if (JMessages.Question("آیا میخواهید پرداخت انجام شود؟", "پرداخت") == System.Windows.Forms.DialogResult.Yes) { JDataBase db = new JDataBase(); try { #region Save Payment JAUTPayment payment = new JAUTPayment(db, _Code); payment.Description = txtDesc.Text; payment.PaymentDate = txtIssuDate.Date; payment.Register_Full_Title = JMainFrame.CurrentPostTitle; payment.Register_Post_Code = JMainFrame.CurrentPostCode; payment.Register_User_Code = JMainFrame.CurrentUserCode; db.beginTransaction("SavePayment"); if (_Code > 0) { payment.Update(db); } else { _Code = payment.Insert(db, false); if (_Code == 0) { throw new Exception(); } } #endregion Save #region Save Details DataTable SelectedOwners = grdReport.DataSource; foreach (DataRow row in SelectedOwners.Rows) { JAUTPaymentDetail detail = new JAUTPaymentDetail(); detail.PaymentCode = _Code; detail.BusCode = Convert.ToInt32(row["BusCode"]); detail.OwnerPCode = Convert.ToInt32(row["OwnerPCode"]); detail.PaymentPrice = Convert.ToDecimal(row["PaymentPrice"]); detail.TotalPrice = Convert.ToDecimal(row["TotalPrice"]); if (detail.Insert(db) == 0) { throw new Exception(); } } db.Commit(); if (JMessages.Question("پرداخت با موفقیت انجام شد. آیا میخواهید فایل خروجی را دریافت کنید؟", "") == System.Windows.Forms.DialogResult.Yes) { btnGetFile.PerformClick(); } DisableAll(); #endregion Details } catch (Exception ex) { db.Rollback("SavePayment"); JMessages.Error("عملیات ثبت با مشکل مواجه شده است.", ""); } finally { db.Dispose(); } } }