private void bindDiary() { SqlDataAdapter addiary, addiary1; // B7 addiary = new SqlDataAdapter("select DiaryEntry.DiaryNo,DiaryEntry.Diary,DiaryEntry.Status,DiaryEntry.CourierNo as RefNo,DiaryEntry.IMID as Membership from DiaryEntry where SubmittedTo='Project'and Status='ProReceive' and DiaryNo in (select DairyNo from DairyCount where Department='Project') and ExamSession='" + lblHiddenSeason.Text + "'", con); addiary1 = new SqlDataAdapter("select DiaryEntry.DiaryNo,DiaryEntry.Diary,DiaryEntry.Status,DiaryEntry.CourierNo as RefNo,DiaryEntry.IMID as Membership from DiaryEntry where SubmittedTo='Project'and Status='CountDispatch' and DiaryNo in (select DairyNo from DairyCount where Department='Account') and ExamSession='" + lblHiddenSeason.Text + "'", con); DataTable ds = new DataTable(); addiary.Fill(ds); addiary1.Fill(ds); GridDiaryNo.DataSource = ds; GridDiaryNo.DataBind(); //B6 addiary = new SqlDataAdapter("select DairyNo,Status,IMID from DairyCount where DairyNo IN (select Distinct DiaryNo From DiaryEntry where Status='CountDispatch' and ExamSession='" + lblHiddenSeason.Text.ToString() + "') and Department='Project' order by DairyNo desc", con); DataTable dt = new DataTable(); addiary.Fill(dt); GrdCountDispatch.DataSource = dt; GrdCountDispatch.DataBind(); //B8 addiary = new SqlDataAdapter("select Status,DairyNo,IMID,DDRcv,DDSub,ProformaARcv,ProformaASub,ProformaBRcv,ProformaBSub,CurrentDate from Projectcount where Session='" + lblHiddenSeason.Text + "' and dairyNo in(select DiaryNo from DiaryEntry where SubmittedTo='Project') order by DairyNo desc", con); DataTable dt1 = new DataTable(); addiary.Fill(dt1); GridProject.DataSource = dt1; GridProject.DataBind(); }
private void CreateNew() { if (!checkSave()) { return; } CurrentTask = new GridProject(CurrentGridConfig, CurrentPrinterConfig); }
private void getProjectData() { string status = ViewState["projectStatus"].ToString(); DataTable dt = status == "2" ? projBLL.getMyNeedFollowUpProject() : projBLL.getFinishedProject(); if (dt.Rows.Count > 0) { ViewState["GridProjData"] = dt; GridProject.DataSource = dt; GridProject.DataBind(); } }
protected void btnQuery_Click(object sender, EventArgs e) { projectTable entity = new projectTable(); if (cmbStatus.SelectedIndex > 0) { entity.projectStatus = Convert.ToInt32(cmbStatus.SelectedValue); } if (cmbType.SelectedIndex > 0) { entity.projectType = Convert.ToInt32(cmbType.SelectedValue); } if (cmbSite.SelectedIndex > 0) { entity.projectSite = Convert.ToInt32(cmbSite.SelectedValue); } if (cmbPriority.SelectedIndex > 0) { entity.priority = Convert.ToInt32(cmbPriority.SelectedValue); } string startDate = "", endDate = ""; if (dateStart.SelectedDate.HasValue) { startDate = dateStart.SelectedDate.Value.ToShortDateString(); } if (dateEnd.SelectedDate.HasValue) { endDate = dateEnd.SelectedDate.Value.ToShortDateString(); } DataTable dt = projBLL.getDataTableByEntity(entity, startDate, endDate); ViewState["GridProjData"] = dt; GridProject.DataSource = dt; GridProject.DataBind(); }