private void init() { BO_CHUNG_CHI chungchi = new BO_CHUNG_CHI(); DataTable tbl_chungchi = chungchi.getChungChi_All(); if (tbl_chungchi.Rows.Count > 0) { for (int i = 0; i < tbl_chungchi.Rows.Count; i++) { TreeNode node = new TreeNode(); node.Text = tbl_chungchi.Rows[i]["CHC_Name"].ToString(); node.Tag = "CHC"; node.Name = tbl_chungchi.Rows[i]["CHC_ID"].ToString(); treeChungchi.Nodes.Add(node); DateTime fromDates = dateFrom.DateTime; DateTime endDates = dateEnd.DateTime; BO_LOP lop = new BO_LOP(); DataTable tbl_lop = lop.getLopByChungChiIDFromTo(Convert.ToInt32(node.Name), fromDates, endDates); if (tbl_lop.Rows.Count > 0) { for (int j = 0; j < tbl_lop.Rows.Count; j++) { TreeNode childNode = new TreeNode(); childNode.Text = tbl_lop.Rows[j]["LOP_Name"].ToString(); childNode.Tag = "LOP"; childNode.Name = tbl_lop.Rows[j]["LOP_ID"].ToString();// +" KHÓA " + tbl_lop.Rows[j]["LOP_Khoa"].ToString(); node.Nodes.Add(childNode); } } } } }
private void initComboboxLopHoc(int vChungChiID) { balLop = new BO_LOP(); lookLop_InGCN.Properties.DataSource = balLop.getLOP_ByCcID(vChungChiID); lookLop_InGCN.Properties.ValueMember = "LOP_ID"; lookLop_InGCN.Properties.DisplayMember = "LOP_Name"; }
private void loadDuration() { int LOP_ID = int.Parse(lookLopHoc.GetColumnValue("LOP_ID").ToString()); BAL.BO_LOP dao_lop = new BO_LOP(); DataRow row = dao_lop.getLOP_ByID(LOP_ID).Rows[0];// search by ID, so there is only one row txtFromDate.Text = Convert.ToDateTime(row["LOP_Ngay_KG"].ToString()).ToShortDateString(); txtEndDate.Text = Convert.ToDateTime(row["LOP_Ngay_KT"].ToString()).ToShortDateString(); }
private void vLoadThoiGianHoc() { boLop = new BO_LOP(); DataRow row = boLop.getLOP_ByID(int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString())).Rows[0];// search by ID, so there is only one row DateTime DateAllocate = Convert.ToDateTime(row["LOP_Ngay_KG"].ToString()); DateTime DateExpire = Convert.ToDateTime(row["LOP_Ngay_KT"].ToString()); txtDateAllocate.Text = DateAllocate.ToString("dd/MM/yyyy"); txtDateExpire.Text = DateExpire.ToString("dd/MM/yyyy"); }
private void initThongKe() { int _nhomCcID = 0; string _nhomCcName = string.Empty; DataTable tblChungChi = new DataTable(); lop = new BO_LOP(); boCapChungChi = new BO_CAP_CHUNGCHI(); _vDsThongKeCapGCN = new BcChungChi(); int _ChcID = -1; if (lookupNhomCc.ItemIndex > -1 && lookupNhomCc.Enabled == true) { _nhomCcID = int.Parse(lookupNhomCc.GetColumnValue("LOA_ID").ToString()); _nhomCcName = lookupNhomCc.Text; if (lookChungChiTK.ItemIndex > -1 && lookChungChiTK.Enabled == true) { _ChcID = int.Parse(lookChungChiTK.GetColumnValue("CHC_ID").ToString()); tblChungChi = lop.getChungChiThongKeWithCcID(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID, _ChcID); initDataSetThongKeCapGCN(tblChungChi, _nhomCcName); } else { tblChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID); initDataSetThongKeCapGCN(tblChungChi, _nhomCcName); } } else { for (int iNhomCc = 0; iNhomCc < tblNhomChungChi.Rows.Count; iNhomCc++) { _nhomCcID = int.Parse(tblNhomChungChi.Rows[iNhomCc]["LOA_ID"].ToString()); _nhomCcName = tblNhomChungChi.Rows[iNhomCc]["LOA_Name"].ToString(); tblChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID); initDataSetThongKeCapGCN(tblChungChi, _nhomCcName); } } rpThongKeCapGCN rpt = new rpThongKeCapGCN(); rpt.SetDataSource(_vDsThongKeCapGCN.Tables["ThongKeCapChungChi"]); rpt.SetParameterValue("_fromDate", dateFrom.Text); rpt.SetParameterValue("_toDate", dateEnd.Text); rpt.SetParameterValue("_SumCapDoi", _SumCapDoi.ToString("#,##0")); rpt.SetParameterValue("_SumCapMoi", _SumCapMoi.ToString("#,##0")); rpt.SetParameterValue("_SumCapLai", _SumCapLai.ToString("#,##0")); rpt.SetParameterValue("_SumTotal", _SumTotal.ToString("#,##0")); crytalThongKe.ReportSource = rpt; crytalThongKe.ToolPanelView = ToolPanelViewType.None; _SumCapDoi = 0; _SumCapMoi = 0; _SumCapLai = 0; _SumTotal = 0; }
private void loadDuration() { int LOP_ID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString()); BAL.BO_LOP dao_lop = new BO_LOP(); DataRow row = dao_lop.getLOP_ByID(LOP_ID).Rows[0];// search by ID, so there is only one row DateTime DateAllocate = Convert.ToDateTime(row["LOP_Ngay_KG"].ToString()); DateTime DateExpire = Convert.ToDateTime(row["LOP_Ngay_KT"].ToString()); txtDateAllocate.Text = DateAllocate.ToString("dd/MM/yyyy"); txtDateExpire.Text = DateExpire.ToString("dd/MM/yyyy"); }
private void loadDurationNew() { int LOP_ID = int.Parse(lookLopNew.GetColumnValue("LOP_ID").ToString()); BAL.BO_LOP dao_lop = new BO_LOP(); DataRow row = dao_lop.getLOP_ByID(LOP_ID).Rows[0];// search by ID, so there is only one row txtNgayKg.Text = Convert.ToDateTime(row["LOP_Ngay_KG"].ToString()).ToShortDateString(); txtNgayKt.Text = Convert.ToDateTime(row["LOP_Ngay_KT"].ToString()).ToShortDateString(); txtNgayKg.BackColor = Color.White; txtNgayKt.BackColor = Color.White; }
private void DeleteLevel(int levelID) { boLop = new BO_LOP(); try { boLop.DeleteLevel(LevelID); } catch (Exception ex) { MessageBox.Show("Lỗi xóa cấp độ: " + ex.Message, "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private bool saveLevel(int LevelID, int LopID, int LevelNumber) { boLop = new BO_LOP(); try { boLop.SaveLevel(LevelID, LopID, LevelNumber, -1); return(true); } catch (Exception ex) { MessageBox.Show("Có lỗi khi lưu cấp độ: " + ex.Message, "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
private bool DeletedLop(DataRow selectedRow, int lopId) { boLop = new BO_LOP(); try { selectedRow.Delete(); boLop.delete(lopId); return(true); } catch (Exception ex) { MessageBox.Show("Lỗi khi xóa lớp học: " + ex.Message, "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
private void vLoadLopHoc() { boLop = new BO_LOP(); DataTable vtb = new System.Data.DataTable(); vtb = boLop.getLOP_ByCcID(gChungChiID); if (vtb.Rows.Count > 0) { lookUpLop.Properties.DataSource = vtb.DefaultView; lookUpLop.Properties.ValueMember = "LOP_ID"; lookUpLop.Properties.DisplayMember = "LOP_Name"; } else { MessageBox.Show("Không tìm thấy lớp học", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } }
private void loadLevelByLopID(int iLop) { boLop = new BO_LOP(); DataTable tbl = new DataTable(); try { tbl = boLop.LoadLevelByLopID(iLop); if (tbl.Rows.Count > 0) { LevelID = int.Parse(tbl.Rows[0]["LEV_ID"].ToString()); lookLevel.EditValue = tbl.Rows[0]["LEV_Number"]; } } catch (Exception ex) { MessageBox.Show("Lỗi hiển thị cấp độ: " + ex.Message, "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
private void initThongKeDangKiHoc() { vDsThongKeLopHoc _dsThongKeLopHoc = new vDsThongKeLopHoc(); int totalChungchi = 0; int numLop = 0; int numHocvien = 0; int numHocChuaCapCc = 0; int index = 1; int CHC_ID = 0; string CHC_Name = string.Empty; int totalLop = 0; int LOP_ID = 0; string LOP_Name = string.Empty; DataTable tableHocvien = new DataTable();; lop = new BO_LOP(); int _SoHvChuaCapCC = 0; int _SoHvDaCapCc = 0; DataTable TableChungChi = new DataTable(); DataTable tableLop = new DataTable(); string _NhomCc = string.Empty; int _nhomCcID = 0; for (int iLoaiCc = 1; iLoaiCc < tblLoaiChungChi().Rows.Count + 1; iLoaiCc++) { _NhomCc = tblLoaiChungChi().Rows[iLoaiCc - 1]["LOA_Name"].ToString(); _nhomCcID = int.Parse(tblLoaiChungChi().Rows[iLoaiCc - 1]["LOA_ID"].ToString()); TableChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID); totalChungchi += TableChungChi.Rows.Count; for (int iChcID = 0; iChcID < TableChungChi.Rows.Count; iChcID++) { CHC_Name = TableChungChi.Rows[iChcID]["CHC_Name"].ToString(); CHC_ID = int.Parse(TableChungChi.Rows[iChcID]["CHC_ID"].ToString()); tableLop = lop.getLopThongKe(CHC_ID, dateFrom.DateTime, dateEnd.DateTime); totalLop += tableLop.Rows.Count; numLop += totalLop; for (int iLopID = 0; iLopID < tableLop.Rows.Count; iLopID++) { LOP_ID = int.Parse(tableLop.Rows[iLopID]["LOP_ID"].ToString()); //LOP_Name = tableLop.Rows[iLopID]["LOP_ShortName"].ToString(); tableHocvien = lop.getHocVienThongKe(LOP_ID); numHocvien += tableHocvien.Rows.Count; for (int i = 0; i < tableHocvien.Rows.Count; i++) { if (tableHocvien.Rows[i]["CCC_SoCc"].ToString() == string.Empty) { _SoHvChuaCapCC++; } else { _SoHvDaCapCc++; } } DataRow row = _dsThongKeLopHoc.tblThongKeLopHoc.NewRow(); row["STT"] = (index).ToString(); row["CHC_Name"] = CHC_Name; row["TotalLop"] = totalLop; row["LopName"] = LOP_Name; row["TotalHocvien"] = tableHocvien.Rows.Count; row["TotalHocVienDaCapCc"] = _SoHvDaCapCc; row["NhomChungChi"] = _NhomCc; _dsThongKeLopHoc.tblThongKeLopHoc.Rows.Add(row); index++; numHocChuaCapCc += _SoHvDaCapCc; _SoHvChuaCapCC = 0; _SoHvDaCapCc = 0; totalLop = 0; } } } rptStatistics rpt = new rptStatistics(); rpt.SetDataSource(_dsThongKeLopHoc); rpt.SetParameterValue("totalChungChi", totalChungchi.ToString("#,##0")); rpt.SetParameterValue("numHocChuaCapCc", numHocChuaCapCc.ToString("#,##0")); rpt.SetParameterValue("totalLop", numLop.ToString("#,##0")); rpt.SetParameterValue("totalHocvien", numHocvien.ToString("#,##0")); rpt.SetParameterValue("fromDate", dateFrom.Text); rpt.SetParameterValue("endDate", dateEnd.Text); crytalThongKe.ReportSource = rpt; crytalThongKe.ToolPanelView = ToolPanelViewType.None; }
private DataTable getLopHoc(int lookCcID_selected_index) { BAL.BO_LOP bal = new BO_LOP(); return(bal.getLOP_ByCcID(lookCcID_selected_index)); }
private DataTable getLopHoc() { BAL.BO_LOP bal = new BO_LOP(); //return bal.getLop_Alls(); return(bal.getLOP_ByCcID(int.Parse(lookChungChi.GetColumnValue("CHC_ID").ToString()))); }
private DataTable getLopHoc() { BAL.BO_LOP bal = new BO_LOP(); return(bal.getLop_Alls()); }