private void LoadCustomers() { string strItem; string strCustomerName; string strCustomerCode; this.cmbCustomers.Items.Add("همه مشتریان"); DataTable dtCustomerNames = new DataTable(); BL_frmReporting M = new BL_frmReporting(); dtCustomerNames = M.CustomerList(); int i; for (i = 0; i <= dtCustomerNames.Rows.Count - 1; i++) { strCustomerName = Convert.ToString(dtCustomerNames.Rows[i][1]); strCustomerCode = Convert.ToString(dtCustomerNames.Rows[i][0]); strItem = strCustomerName + "(" + strCustomerCode + ")"; this.cmbCustomers.Items.Add(strItem); } this.cmbCustomers.SelectedIndex = 0; }
private void btnShow_Click(object sender, EventArgs e) { if (txtFDate1.Text == "" || txtFDate2.Text == "") { MessageBox.Show("لطفا محدوده تاریخ را وارد کنید", "خطا", MessageBoxButtons.OK); return; } bool validfdate1 = G.ValidateParsianDate(txtFDate1.Text.ToString()); bool validfdate2 = G.ValidateParsianDate(txtFDate2.Text.ToString()); if (validfdate1 == false || validfdate2 == false) { txtFDate1.BackColor = Color.Red; txtFDate1.ForeColor = Color.White; txtFDate2.BackColor = Color.Red; txtFDate2.ForeColor = Color.White; MessageBox.Show("تاریخ را بطور صحیح وارد کنید", "خطا", MessageBoxButtons.OK); return; } else { txtFDate1.BackColor = Color.White; txtFDate1.ForeColor = Color.Black; txtFDate2.BackColor = Color.White; txtFDate2.ForeColor = Color.Black; } string strCustomerCode = ""; DataTable dtCustomerNames = new DataTable(); BL_frmCustomerSupport M = new BL_frmCustomerSupport(); dtCustomerNames = M.CustomerList(); int intindex; if (this.cmbCustomers.SelectedIndex != 0) { intindex = cmbCustomers.SelectedIndex - 1; strCustomerCode = Convert.ToString(dtCustomerNames.Rows[intindex][0]); MessageBox.Show(strCustomerCode, "customer code", MessageBoxButtons.OK); } //گزارش کلی از کلیه مشتریان if (cmbReportType.SelectedIndex == 0 && cmbCustomers.SelectedIndex == 0) { BL_frmReporting M1 = new BL_frmReporting(); M1.FDate1 = this.txtFDate1.Text.ToString(); M1.FDate2 = this.txtFDate2.Text.ToString(); this.dataGridView1.DataSource = M1.TotalizedAll(); TotalizedDatagridUpdate(); this.txtTotalPrice.Text = Convert.ToString(M1.GetSumTotalizedAll()); this.txtTotalTax.Text = Convert.ToString(M1.GetTaxTotalizedAll()); } // گزارش کلی از یک مشتری مشحض if (cmbReportType.SelectedIndex == 0 && cmbCustomers.SelectedIndex != 0) { BL_frmReporting M2 = new BL_frmReporting(); M2.FDate1 = this.txtFDate1.Text.ToString(); M2.FDate2 = this.txtFDate2.Text.ToString(); M2.CustomerCode = strCustomerCode; this.dataGridView1.DataSource = M2.TotalizedByCustomer(); TotalizedDatagridUpdate(); this.txtTotalPrice.Text = Convert.ToString(M2.GetSumTotalizedByCustomer()); this.txtTotalTax.Text = Convert.ToString(M2.GetTaxTotalizedByCustomer()); } // گزارش جزئی از کلیه مشتریان if (cmbReportType.SelectedIndex == 1 && cmbCustomers.SelectedIndex == 0) { BL_frmReporting M3 = new BL_frmReporting(); M3.FDate1 = this.txtFDate1.Text.ToString(); M3.FDate2 = this.txtFDate2.Text.ToString(); this.dataGridView1.DataSource = M3.DetailedAll(); DetailedDatagridUpdate(); this.txtTotalPrice.Text = Convert.ToString(M3.GetSumDetailedAll()); //this.txtTotalPrice.Text="Error"; this.txtTotalTax.Text = Convert.ToString(M3.GetTaxDetailedAll()); //this.txtTotalTax.Text = "Error"; } // گزراش جزئی از یک مشتری مشخص if (cmbReportType.SelectedIndex == 1 && cmbCustomers.SelectedIndex != 0) { BL_frmReporting M4 = new BL_frmReporting(); M4.FDate1 = this.txtFDate1.Text.ToString(); M4.FDate2 = this.txtFDate2.Text.ToString(); M4.CustomerCode = strCustomerCode; this.dataGridView1.DataSource = M4.DetailedByCustomer(); DetailedDatagridUpdate(); this.txtTotalPrice.Text = Convert.ToString(M4.GetSumDetailedByCustomer()); //this.txtTotalPrice.Text = "Error"; this.txtTotalTax.Text = Convert.ToString(M4.GetTaxDetailedByCustomer()); //this.txtTotalTax.Text = "Error"; } }