private void button1_Click(object sender, EventArgs e) { DateTime date = reportDatePicker.Value; Object tmpDeptNameObj = DeptCmbMonthly.SelectedItem; string qry = ""; if (tmpDeptNameObj == null) { qry = "select b.bag_id, d.deptName, b.date, b.bagNo, b.issued, i.place " + "from bag b left join issuedto i on b.place_id=i.place_id " + "inner join department d on b.deptNo=d.deptNo where MONTH(b.date)=" + date.Month; } else { string deptName = tmpDeptNameObj.ToString(); if (deptName.Equals("All")) { qry = "select b.bag_id, d.deptName, b.date, b.bagNo, b.issued, i.place " + "from bag b left join issuedto i on b.place_id=i.place_id " + "inner join department d on b.deptNo=d.deptNo where MONTH(b.date)=" + date.Month; } else { qry = "select b.bag_id, d.deptName, b.date, b.bagNo, b.issued, i.place " + "from bag b left join issuedto i on b.place_id=i.place_id " + "inner join department d on b.deptNo=d.deptNo " + "where d.deptName='" + deptName + "' and MONTH(b.date)=" + date.Month; } } testReport frm = new testReport(qry); frm.Show(); }
private void issuedSelectedDay_Click(object sender, EventArgs e) { DateTime date = dateTimePickerIssuedDaily.Value; string qry = "select b.bag_id, d.deptName, b.issuedDate as date, b.bagNo, b.issued, i.place " + "from bag b inner join department d on b.deptNo=d.deptNo " + "inner join issuedto i on i.place_id=b.place_id " + "where b.issued=1 and b.issuedDate<='" + date.ToString("yyyy/M/d") + "'"; testReport frm = new testReport(qry); frm.Show(); }
private void IssuedSelectedMonth_Click_1(object sender, EventArgs e) { DateTime date = dateTimePickerIssued.Value; Object tmpIssuedPlaceObj = IssuedPlaceCmbMonthly.SelectedItem; string qry = ""; if (tmpIssuedPlaceObj == null) { qry = "select b.bag_id, d.deptName, b.issuedDate as date, b.bagNo, b.issued, i.place " + "from bag b inner join department d on b.deptNo=d.deptNo " + "inner join issuedto i on i.place_id=b.place_id " + "where b.issued=1 and MONTH(b.issuedDate)=" + date.Month; } else { string place = tmpIssuedPlaceObj.ToString(); if (place.Equals("All")) { qry = "select b.bag_id, d.deptName, b.issuedDate as date, b.bagNo, b.issued, i.place " + "from bag b inner join department d on b.deptNo=d.deptNo " + "inner join issuedto i on i.place_id=b.place_id " + "where b.issued=1 and MONTH(b.issuedDate)=" + date.Month; } else { qry = "select b.bag_id, d.deptName, b.issuedDate as date, b.bagNo, b.issued, i.place " + "from bag b inner join department d on b.deptNo=d.deptNo " + "inner join issuedto i on i.place_id=b.place_id " + "where b.issued=1 and i.place='" + place + "' and MONTH(b.issuedDate)=" + date.Month; } } testReport frm = new testReport(qry); frm.Show(); }
private void balanceSelectedDay_Click(object sender, EventArgs e) { DateTime date = dailyReportDateTimePicker.Value; Object tmpDeptNameObj = DeptCmbMonthly.SelectedItem; string qry = ""; if (tmpDeptNameObj == null) { qry = "select b.bag_id, d.deptName, b.date, b.bagNo, b.issued, i.place " + "from bag b inner join department d on b.deptNo=d.deptNo " + "left join issuedto i on b.place_id=i.place_id " + "where b.issued=0 and b.date<='" + date.ToString("yyyy/M/d") + "'"; } else { string deptName = tmpDeptNameObj.ToString(); if (deptName.Equals("All")) { qry = "select b.bag_id, d.deptName, b.date, b.bagNo, b.issued, i.place " + "from bag b inner join department d on b.deptNo=d.deptNo " + "left join issuedto i on b.place_id=i.place_id " + "where b.issued=0 and b.date='" + date.ToString("yyyy/M/d") + "'"; } else { qry = "select b.bag_id, d.deptName, b.date, b.bagNo, b.issued, i.place " + "from bag b inner join department d on b.deptNo=d.deptNo " + "left join issuedto i on b.place_id=i.place_id " + "where b.issued=0 and d.deptName='" + deptName + "' and b.date='" + date.ToString("yyyy/M/d") + "'"; } } testReport frm = new testReport(qry); frm.Show(); }