private void btnEnter_Click(object sender, EventArgs e) { try { if (lnkProjectType.Text == "طرح پژوهشی") { if (rdbISGharardad.Checked == true) { FrmFlagProject objFlag = new FrmFlagProject(); objFlag.ShowDialog(); QueryString = "AND GharardadNumber != ''"; } else { year = cboYear.Text; GharardadFlag = 0; FrmReportViewerGharardad objReport = new FrmReportViewerGharardad(); objReport.Show(); } } else if(lnkProjectType.Text == "پایان نامه") { if (rdbISGharardad.Checked == true) { FrmFlagProject objFlag = new FrmFlagProject(); objFlag.ShowDialog(); QueryString = "AND GharardadNumber != ''"; } else { year = cboYear.Text; GharardadFlag = 0; FrmReportViewerThesisGharardad objReport = new FrmReportViewerThesisGharardad(); objReport.Show(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnEnter_Click(object sender, EventArgs e) { objDataAdapter.SelectCommand = new SqlCommand(); objDataAdapter.SelectCommand.Connection = FrmEnter.objConnection; objDataAdapter.SelectCommand.Parameters.AddWithValue("@DeliveryDate" , "00/00/00"); objDataAdapter.SelectCommand.Parameters.AddWithValue("@ProjectType", "طرح پژوهشی"); objDataAdapter.SelectCommand.Parameters.AddWithValue("@DeliveryDate1", cboYear.Text + "%"); objDataAdapter.SelectCommand.Parameters.AddWithValue("@StartDate", cboYear.Text + "%"); objTbl.Clear(); year = cboYear.Text; if (FrmSelectTypeGharardad.lnkProjectType1 == "طرح پژوهشی") { FrmProjectReportViewer objViewer = new FrmProjectReportViewer(); if (rdbEjra.Checked == true) { ProjectFlag = 0; objDataAdapter.SelectCommand.CommandText = "Select * from VwProjectFlag where DeliveryDate = @DeliveryDate AND StartDate Like @StartDate AND ProjectType = @ProjectType " + FrmSelectTypeGharardad.QueryString; objDataAdapter.Fill(objTbl); objViewer.Show(); } else if (rdbPayan.Checked == true) { ProjectFlag = 1; objDataAdapter.SelectCommand.CommandText = "Select * from VwProjectFlag where DeliveryDate != @DeliveryDate AND DeliveryDate Like @DeliveryDate1 AND ProjectType = @ProjectType " + FrmSelectTypeGharardad.QueryString; objDataAdapter.Fill(objTbl); objViewer.Show(); } else if (rdbISGharardad.Checked == true) { FrmSelectTypeGharardad.GharardadFlag = 1; FrmReportViewerGharardad objGharardad = new FrmReportViewerGharardad(); objGharardad.Show(); } } else if (FrmSelectTypeGharardad.lnkProjectType1 == "پایان نامه") { FrmReportViewerThesisMain objViewer = new FrmReportViewerThesisMain(); if (rdbEjra.Checked == true) { ProjectFlag = 0; objDataAdapter.SelectCommand.CommandText = "Select * from VwCommentThesis where DeliveryDate = @DeliveryDate AND StartDate Like @StartDate " + FrmSelectTypeGharardad.QueryString; objDataAdapter.Fill(objTbl); objViewer.Show(); } else if (rdbPayan.Checked == true) { ProjectFlag = 1; objDataAdapter.SelectCommand.CommandText = "Select * from VwCommentThesis where DeliveryDate != @DeliveryDate AND DeliveryDate Like @DeliveryDate1 " + FrmSelectTypeGharardad.QueryString; objDataAdapter.Fill(objTbl); objViewer.Show(); } else if (rdbISGharardad.Checked == true) { FrmReportViewerThesisGharardad objReport = new FrmReportViewerThesisGharardad(); objReport.Show(); } } }