Ejemplo n.º 1
0
        private void grdUsage_CommandCellClick(object sender, EventArgs e)
        {
            string cntrNo     = grdUsage.CurrentRow.Cells["tbl_usage.cntr_No"].Value.ToString();
            string payBalance = grdUsage.CurrentRow.Cells["priceSum"].Value.ToString();
            string custNo     = grdUsage.CurrentRow.Cells["Cust_No"].Value.ToString();
            string custName   = grdUsage.CurrentRow.Cells["FName"].Value.ToString() + grdUsage.CurrentRow.Cells["LName"].Value.ToString();
            int    termNo     = Convert.ToInt16(lstTermNo.SelectedItem.Text);

            if (grdUsage.CurrentColumn.Name == "cmdDelete")
            {
                if (MessageBox.Show("اطلاعات مربوط به این قبض حذف خواهند گردید. آیا تأیید می نمایید؟", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    dataAccess.ExecuteAccess("delete from tbl_Usage where term_No = " + lstTermNo.SelectedItem.Text +
                                             " and cntr_No = " + cntrNo);
                    lstTermNo_SelectedIndexChanged(null, null);
                }
            }
            else if (grdUsage.CurrentColumn.Name == "cmdPrintBill")
            {
                frmFastReport frmRep = new frmFastReport(this);
                frmRep.FastReportBill(termNo, cntrNo, txtBillDescription.Text);
                //frmRep.MdiParent = this;
                frmRep.Show();
            }
            else if (grdUsage.CurrentColumn.Name == "cmdInstalment")
            {
                frmInstalmentInsertUpdate frmIns = new frmInstalmentInsertUpdate(cntrNo, termNo.ToString(), custNo, custName, payBalance);
                frmIns.ShowDialog();
            }
        }
Ejemplo n.º 2
0
        private void btnPrintCustomerList_Click(object sender, EventArgs e)
        {
            frmFastReport frmRep = new frmFastReport(this);

            frmRep.FastReportCustomerlList();
            //frmRep.MdiParent = this;
            frmRep.Show();
        }
Ejemplo n.º 3
0
        private void btnTermDebtorList_Click(object sender, EventArgs e)
        {
            frmFastReport frmRep = new frmFastReport(this);

            frmRep.FastReportDebtorList(Convert.ToInt16(lstTermNo.SelectedItem.Text));
            //frmRep.MdiParent = this;
            frmRep.Show();
        }
Ejemplo n.º 4
0
        private void btnTermBillPrint_Click(object sender, EventArgs e)
        {
            //DisableReporting();
            frmFastReport frmRep = new frmFastReport(this);

            frmRep.FastReportBill(Convert.ToInt16(lstTermNo.SelectedItem.Text), txtBillDescription.Text);

            frmRep.Show();


            #region Old Comment
            //frmRep.MdiParent = this;
            //string min = (DateTime.Now.Minute - tm.Minute).ToString();
            //string sec = (DateTime.Now.Second - tm.Second).ToString();
            //string msg = "محاسبات قبوض انجام گردید" + "\n";
            //msg += "تعداد کل رکوردها " + billCount.ToString() + "\n";
            //msg += "زمان محاسبات برای هر رکورد" + ((float)(DateTime.Now.Subtract(tm).TotalSeconds) / billCount).ToString().Substring(0, 4) + " ثانیه" + "\n";
            //msg += "زمان کل محاسبات" + ((float)DateTime.Now.Subtract(tm).TotalMinutes).ToString().Substring(0,4) + " دقیقه و " +
            //    (DateTime.Now.Subtract(tm).TotalSeconds - DateTime.Now.Subtract(tm).TotalMinutes * 60).ToString().Substring(0, 4) + " ثانیه";
            //MessageBox.Show(msg,"گزارش محاسبات",MessageBoxButtons.OK,MessageBoxIcon.Information,MessageBoxDefaultButton.Button1,MessageBoxOptions.RightAlign,false);
            #endregion
        }
Ejemplo n.º 5
0
 private void grdCust_CommandCellClick(object sender, EventArgs e)
 {
     if (grdCust.CurrentColumn.Name == "cmdDelete")
     {
         if (MessageBox.Show("تمامی اطلاعات مربوط به " + grdCust.SelectedRows[0].Cells["FName"].Value.ToString() + " " + grdCust.SelectedRows[0].Cells["LName"].Value.ToString() + " حذف خواهند گردید. آیا تأیید می نمایید؟", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
         {
             dataAccess.ExecuteAccess("delete from tbl_usage where cntr_no = " + grdCust.SelectedRows[0].Cells["Cntr_No"].Value.ToString()
                                      + " and cust_no = " + grdCust.SelectedRows[0].Cells["Cust_No"].Value.ToString());
             dataAccess.ExecuteAccess("delete from tbl_cust where cntr_no = " + grdCust.SelectedRows[0].Cells["Cntr_No"].Value.ToString()
                                      + " and cust_no = " + grdCust.SelectedRows[0].Cells["Cust_No"].Value.ToString());
             dataAccess.ExecuteAccess("delete from tbl_payment where cntr_no = " + grdCust.SelectedRows[0].Cells["Cntr_No"].Value.ToString()
                                      + " and cust_no = " + grdCust.SelectedRows[0].Cells["Cust_No"].Value.ToString());
             btnRefreshCust_Click(null, null);
             FillLstTermNo();
             lstTermNo_SelectedIndexChanged(null, null);
             btnRefreshUsage_Click(null, null);
             btnRefreshPayment_Click(null, null);
         }
     }
     else if (grdCust.CurrentColumn.Name == "cmdUpdate")
     {
         frmCustInsertUpdate frm = new frmCustInsertUpdate(grdCust.SelectedRows[0].Cells["Cntr_No"].Value.ToString());
         if (frm.ShowDialog() == DialogResult.OK)
         {
             btnRefreshCust_Click(null, null);
             btnRefreshUsage_Click(null, null);
             btnRefreshPayment_Click(null, null);
         }
     }
     else if (grdCust.CurrentColumn.Name == "cmdFinancialList")
     {
         frmFastReport frmRep = new frmFastReport(this);
         frmRep.FastReportFinancialList(grdCust.SelectedRows[0].Cells["Cntr_No"].Value.ToString(),
                                        grdCust.SelectedRows[0].Cells["FName"].Value.ToString() + " " +
                                        grdCust.SelectedRows[0].Cells["LName"].Value.ToString());
         //frmRep.MdiParent = this;
         frmRep.Show();
     }
 }