private void BtnFilterOption_Click(object sender, EventArgs e) { FilterRptSalesRegister frm = new FilterRptSalesRegister(); frm.StartPosition = FormStartPosition.CenterScreen; frm.ShowDialog(); BindReport(frm); }
private void AfterLoading(object sender, EventArgs e) { this.Activated -= AfterLoading; FilterRptSalesRegister frm = new FilterRptSalesRegister(); frm.ShowDialog(); BindReport(frm); }
private void BindReport(FilterRptSalesRegister frm) { DataTable dtTerm = new DataTable(); DataSet ds = new DataSet(); if (frm.ButtonAction == "OK") { DataTable NullDt = new DataTable(); Grid.DataSource = NullDt; DateTime FromDate = new DateTime(); DateTime ToDate = new DateTime(); if (ClsGlobal.DateType == "D") { FromDate = Convert.ToDateTime(frm.TxtFromDate.Text); ToDate = Convert.ToDateTime(frm.TxtToDate.Text); } else { FromDate = Convert.ToDateTime(frm.TxtFromDate.Tag.ToString()); ToDate = Convert.ToDateTime(frm.TxtToDate.Tag.ToString()); } if (frm.ChkDetails.Checked == true && frm.ChkHorizontal.Checked == true) //------ DETAILS WITH HORIZONTAL DATE WISE ---------- { ds = _objRptSalesRegister.SalesOrderRegisterDetailsHorizontalDateWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId); dtTerm = ds.Tables[1]; Grid.DataSource = ds.Tables[0]; Grid.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Rate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Basic Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Net Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Date"].Width = 75; Grid.Columns["Qty"].Width = 100; Grid.Columns["Rate"].Width = 90; Grid.Columns["Basic Amt"].Width = 90; Grid.Columns["Net Amt"].Width = 90; Grid.Columns["Particular"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; foreach (DataColumn col1 in dtTerm.Columns) { Grid.Columns[col1.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns[col1.ColumnName].Width = 90; } foreach (DataGridViewRow row in Grid.Rows) { if (row.Cells["Particular"].Value.ToString() == "Total :" || row.Cells["Particular"].Value.ToString() == "Grand Total :") { Grid.Rows[row.Index].Cells[1].Style.Alignment = DataGridViewContentAlignment.BottomRight; } } } else if (frm.ChkDetails.Checked == true) //------ DETAILS WITH VERTICLE DATE WISE ---------- { ds = _objRptSalesRegister.SalesOrderRegisterDetailsVerticleDateWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId); dtTerm = ds.Tables[1]; Grid.DataSource = ds.Tables[0]; Grid.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Rate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Basic Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Date"].Width = 75; Grid.Columns["Qty"].Width = 100; Grid.Columns["Rate"].Width = 90; Grid.Columns["Basic Amt"].Width = 90; Grid.Columns["Particular"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; foreach (DataGridViewRow row in Grid.Rows) { if (row.Cells["Particular"].Value.ToString() == "Total :" || row.Cells["Particular"].Value.ToString() == "Grand Total :") { Grid.Rows[row.Index].Cells[1].Style.Alignment = DataGridViewContentAlignment.BottomRight; } foreach (DataColumn col1 in dtTerm.Columns) { if (row.Cells["Particular"].Value.ToString() == col1.ColumnName) { Grid.Rows[row.Index].Cells[1].Style.Alignment = DataGridViewContentAlignment.BottomRight; } } } } else //--------------- SUMMARY DATE WISE ---------------- { ds = _objRptSalesRegister.SalesOrderRegisterSummaryDateWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId); if (ds.Tables.Count > 1) { dtTerm = ds.Tables[1].Copy(); } Grid.DataSource = ds.Tables[0]; Grid.Columns["Voucher No"].Width = 80; Grid.Columns["Date"].Width = 75; Grid.Columns["Miti"].Width = 75; Grid.Columns["Customer Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; Grid.Columns["Qty"].Width = 70; Grid.Columns["Basic Amt"].Width = 90; Grid.Columns["Net Amt"].Width = 90; Grid.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Basic Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns["Net Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; foreach (DataColumn col1 in dtTerm.Columns) { Grid.Columns[col1.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; Grid.Columns[col1.ColumnName].Width = 90; } Grid.Columns["Miti"].Visible = false; //if (frm.ChkOrderNo.Checked == false) //{ // Grid.Columns["OrderNo"].Visible = false; //} Grid.Rows[Grid.Rows.Count - 1].Cells[3].Style.Alignment = DataGridViewContentAlignment.MiddleRight; } Grid.Columns.Cast <DataGridViewColumn>().ToList().ForEach(f => f.SortMode = DataGridViewColumnSortMode.NotSortable); Grid.Columns["IsBold"].Visible = false; foreach (DataGridViewRow row in Grid.Rows) { if (row.Cells["IsBold"].Value.ToString() == "Y") { Grid.Rows[row.Index].DefaultCellStyle.Font = new Font("Arial", 8f, FontStyle.Bold); } } } frm.Dispose(); }