private void btnNotifPDC_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(global.connectString())) { con.Open(); var mos = DateTime.Today.Month; var yr = DateTime.Today.Year; var day = DateTime.Today.Day; DateTime dtNowFrom; DateTime dtNowTo; if (day <= 15) { dtNowFrom = new DateTime(yr, mos, 09); dtNowTo = new DateTime(yr, mos, 15); } else { dtNowFrom = new DateTime(yr, mos, 25); dtNowTo = new DateTime(yr, mos, DateTime.DaysInMonth(yr, mos)); } SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_GetChequeDateDueToday"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ChequeDateFrom", dtNowFrom); cmd.Parameters.AddWithValue("@ChequeDateTo", dtNowTo); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); PDCManagement frm = new PDCManagement(); foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(PDCManagement)) { form.Activate(); frm = (PDCManagement)Application.OpenForms["PDCManagement"]; frm.dataGridView1.DataSource = dt; frm.str = ""; frm.str = "SELECT * FROM vw_PDCManagement WHERE ORNumber is NULL and ChequeDate between '" + dtNowFrom.ToShortDateString() + "' and '" + dtNowTo.ToShortDateString() + "'"; return; } } frm.str = ""; frm.str = "SELECT * FROM vw_PDCManagement WHERE ORNumber is NULL and ChequeDate between '" + dtNowFrom.ToShortDateString() + "' and '" + dtNowTo.ToShortDateString() + "'"; frm.Show(); frm.MdiParent = this; frm.dataGridView1.DataSource = dt; } }
private void panelHeader_Click(object sender, EventArgs e) { foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(PDCManagement)) { form.Activate(); return; } } PDCManagement frm = new PDCManagement(); frm.Show(); frm.MdiParent = this; }
private void button33_Click(object sender, EventArgs e) { panelPDCManagement.Visible = false; //controls foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(PDCManagement)) { form.Activate(); return; } } PDCManagement frm = new PDCManagement(); frm.Show(); frm.MdiParent = this; }