public List <XL_KeHoachChiTietInfo> GetList(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo) { List <XL_KeHoachChiTietInfo> oXL_KeHoachChiTietInfoList = new List <XL_KeHoachChiTietInfo>(); DataTable dtb = Get(pXL_KeHoachChiTietInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oXL_KeHoachChiTietInfo = new XL_KeHoachChiTietInfo(); oXL_KeHoachChiTietInfo.XL_KeHoachChiTietID = long.Parse(dtb.Rows[i]["XL_KeHoachChiTietID"].ToString()); oXL_KeHoachChiTietInfo.IDXL_Tuan = long.Parse(dtb.Rows[i]["IDXL_Tuan"].ToString()); oXL_KeHoachChiTietInfo.IDDM_Lop = int.Parse(dtb.Rows[i]["IDDM_Lop"].ToString()); oXL_KeHoachChiTietInfo.IDXL_LopTachGop = int.Parse(dtb.Rows[i]["IDXL_LopTachGop"].ToString()); oXL_KeHoachChiTietInfo.IDXL_MonHocTrongKy = int.Parse(dtb.Rows[i]["IDXL_MonHocTrongKy"].ToString()); oXL_KeHoachChiTietInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString()); oXL_KeHoachChiTietInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString()); oXL_KeHoachChiTietInfo.SoTiet = int.Parse(dtb.Rows[i]["SoTiet"].ToString()); oXL_KeHoachChiTietInfo.LoaiTiet = int.Parse(dtb.Rows[i]["LoaiTiet"].ToString()); oXL_KeHoachChiTietInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString(); oXL_KeHoachChiTietInfoList.Add(oXL_KeHoachChiTietInfo); } } return(oXL_KeHoachChiTietInfoList); }
public void Delete(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@XL_KeHoachChiTietID", SqlDbType.BigInt, pXL_KeHoachChiTietInfo.XL_KeHoachChiTietID)); RunProcedure("sp_XL_KeHoachChiTiet_Delete", colParam); }
public DataTable Get(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@XL_KeHoachChiTietID", SqlDbType.BigInt, pXL_KeHoachChiTietInfo.XL_KeHoachChiTietID)); return(RunProcedureGet("sp_XL_KeHoachChiTiet_Get", colParam)); }
public int Add(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo) { int ID = 0; ID = oDXL_KeHoachChiTiet.Add(pXL_KeHoachChiTietInfo); mErrorMessage = oDXL_KeHoachChiTiet.ErrorMessages; mErrorNumber = oDXL_KeHoachChiTiet.ErrorNumber; return(ID); }
public dlgChonGiaoVien(frmKeHoachChiTiet _frm, XL_KeHoachChiTietInfo _XL_KeHoachChiTietInfo, string _TenLop, string _TenMon, string _IDNS_GiaoVien) { InitializeComponent(); oBXL_GiaoVien_MonHoc = new cBXL_GiaoVien_MonHoc(); frmKeHoach = _frm; pXL_KeHoachChiTietInfo = _XL_KeHoachChiTietInfo; TenLop = _TenLop; TenMon = _TenMon; IDNS_GiaoVien = _IDNS_GiaoVien; }
public void ToDataRow(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo, ref DataRow dr) { dr[pXL_KeHoachChiTietInfo.strXL_KeHoachChiTietID] = pXL_KeHoachChiTietInfo.XL_KeHoachChiTietID; dr[pXL_KeHoachChiTietInfo.strIDXL_Tuan] = pXL_KeHoachChiTietInfo.IDXL_Tuan; dr[pXL_KeHoachChiTietInfo.strIDDM_Lop] = pXL_KeHoachChiTietInfo.IDDM_Lop; dr[pXL_KeHoachChiTietInfo.strIDXL_LopTachGop] = pXL_KeHoachChiTietInfo.IDXL_LopTachGop; dr[pXL_KeHoachChiTietInfo.strIDXL_MonHocTrongKy] = pXL_KeHoachChiTietInfo.IDXL_MonHocTrongKy; dr[pXL_KeHoachChiTietInfo.strIDDM_MonHoc] = pXL_KeHoachChiTietInfo.IDDM_MonHoc; dr[pXL_KeHoachChiTietInfo.strIDNS_GiaoVien] = pXL_KeHoachChiTietInfo.IDNS_GiaoVien; dr[pXL_KeHoachChiTietInfo.strSoTiet] = pXL_KeHoachChiTietInfo.SoTiet; dr[pXL_KeHoachChiTietInfo.strLoaiTiet] = pXL_KeHoachChiTietInfo.LoaiTiet; dr[pXL_KeHoachChiTietInfo.strGhiChu] = pXL_KeHoachChiTietInfo.GhiChu; }
public void ToInfo(ref XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo, DataRow dr) { pXL_KeHoachChiTietInfo.XL_KeHoachChiTietID = long.Parse(dr[pXL_KeHoachChiTietInfo.strXL_KeHoachChiTietID].ToString()); pXL_KeHoachChiTietInfo.IDXL_Tuan = long.Parse(dr[pXL_KeHoachChiTietInfo.strIDXL_Tuan].ToString()); pXL_KeHoachChiTietInfo.IDDM_Lop = int.Parse(dr[pXL_KeHoachChiTietInfo.strIDDM_Lop].ToString()); pXL_KeHoachChiTietInfo.IDXL_LopTachGop = int.Parse(dr[pXL_KeHoachChiTietInfo.strIDXL_LopTachGop].ToString()); pXL_KeHoachChiTietInfo.IDXL_MonHocTrongKy = int.Parse(dr[pXL_KeHoachChiTietInfo.strIDXL_MonHocTrongKy].ToString()); pXL_KeHoachChiTietInfo.IDDM_MonHoc = int.Parse(dr[pXL_KeHoachChiTietInfo.strIDDM_MonHoc].ToString()); pXL_KeHoachChiTietInfo.IDNS_GiaoVien = int.Parse(dr[pXL_KeHoachChiTietInfo.strIDNS_GiaoVien].ToString()); pXL_KeHoachChiTietInfo.SoTiet = int.Parse(dr[pXL_KeHoachChiTietInfo.strSoTiet].ToString()); pXL_KeHoachChiTietInfo.LoaiTiet = int.Parse(dr[pXL_KeHoachChiTietInfo.strLoaiTiet].ToString()); pXL_KeHoachChiTietInfo.GhiChu = dr[pXL_KeHoachChiTietInfo.strGhiChu].ToString(); }
public frmKeHoachChiTiet() { InitializeComponent(); SoNgayTuan = Program.pgrThamSo.THU_KET_THUC - Program.pgrThamSo.THU_BAT_DAU; oBXL_KeHoachTruong = new cBXL_KeHoachTruong(); pXL_KeHoachTruongInfo = new XL_KeHoachTruongInfo(); oBXL_KeHoachChiTiet = new cBXL_KeHoachChiTiet(); pXL_KeHoachChiTietInfo = new XL_KeHoachChiTietInfo(); oBXL_PhanCongGiaoVien = new cBXL_PhanCongGiaoVien(); pDM_LopInfo = new DM_LopInfo(); dtTuan = LoadTuan(); AddBands(); FlexColor(fg); }
public void Update(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDXL_Tuan", SqlDbType.BigInt, pXL_KeHoachChiTietInfo.IDXL_Tuan)); colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDDM_Lop)); colParam.Add(CreateParam("@IDXL_LopTachGop", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDXL_LopTachGop)); colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDXL_MonHocTrongKy)); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDDM_MonHoc)); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pXL_KeHoachChiTietInfo.SoTiet)); colParam.Add(CreateParam("@LoaiTiet", SqlDbType.Int, pXL_KeHoachChiTietInfo.LoaiTiet)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pXL_KeHoachChiTietInfo.GhiChu)); colParam.Add(CreateParam("@XL_KeHoachChiTietID", SqlDbType.BigInt, pXL_KeHoachChiTietInfo.XL_KeHoachChiTietID)); RunProcedure("sp_XL_KeHoachChiTiet_Update", colParam); }
public int Add(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDXL_Tuan", SqlDbType.BigInt, pXL_KeHoachChiTietInfo.IDXL_Tuan)); colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDDM_Lop)); colParam.Add(CreateParam("@IDXL_LopTachGop", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDXL_LopTachGop)); colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDXL_MonHocTrongKy)); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDDM_MonHoc)); colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_KeHoachChiTietInfo.IDNS_GiaoVien)); colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pXL_KeHoachChiTietInfo.SoTiet)); colParam.Add(CreateParam("@LoaiTiet", SqlDbType.Int, pXL_KeHoachChiTietInfo.LoaiTiet)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pXL_KeHoachChiTietInfo.GhiChu)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_XL_KeHoachChiTiet_Add", colParam)); }
public void Delete(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo) { oDXL_KeHoachChiTiet.Delete(pXL_KeHoachChiTietInfo); mErrorMessage = oDXL_KeHoachChiTiet.ErrorMessages; mErrorNumber = oDXL_KeHoachChiTiet.ErrorNumber; }
public DataTable Get(XL_KeHoachChiTietInfo pXL_KeHoachChiTietInfo) { return(oDXL_KeHoachChiTiet.Get(pXL_KeHoachChiTietInfo)); }
private void barbtnLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (fg.Rows.Count > fg.Rows.Fixed) { int IDDM_Lop, DiaChiLop, IDXL_Tuan, IDXL_MonHocTrongKy; string IDDM_MonHoc; Cell_KeHoach ud; CellRange rg; for (int r = RowBegin; r < fg.Rows.Count; r++) { if ("" + fg[r, 0] != "0" && ("" + fg[r, 0]).IndexOf("Tong") < 0) { DiaChiLop = int.Parse(fg[r, 0].ToString()); IDDM_Lop = int.Parse(fg[DiaChiLop, 1].ToString()); IDDM_MonHoc = fg[r, 1].ToString(); IDXL_MonHocTrongKy = int.Parse(fg[r, 7].ToString()); for (int c = ColBegin; c < fg.Cols.Count; c++) { pXL_KeHoachChiTietInfo = new XL_KeHoachChiTietInfo(); rg = fg.GetCellRange(r, c, r, c); IDXL_Tuan = int.Parse(fg[0, c].ToString()); if (rg.UserData != null) { ud = (Cell_KeHoach)rg.UserData; if (ud.Changed == true) { // Nếu thay đổi trên kế hoạch chi tiết đã có thì xóa hoặc sửa if (ud.XL_KeHoachChiTietID > 0) { pXL_KeHoachChiTietInfo.XL_KeHoachChiTietID = ud.XL_KeHoachChiTietID; // Nếu số tiết <= 0 tức là cần phải xóa, ngược lại thì cập nhật if (ud.SoTiet <= 0) { oBXL_KeHoachChiTiet.Delete(pXL_KeHoachChiTietInfo); ud.XL_KeHoachChiTietID = -1; } else { pXL_KeHoachChiTietInfo.SoTiet = ud.SoTiet; pXL_KeHoachChiTietInfo.LoaiTiet = ud.LoaiTiet; pXL_KeHoachChiTietInfo.IDXL_MonHocTrongKy = IDXL_MonHocTrongKy; pXL_KeHoachChiTietInfo.IDDM_MonHoc = int.Parse(IDDM_MonHoc); pXL_KeHoachChiTietInfo.IDDM_Lop = IDDM_Lop; pXL_KeHoachChiTietInfo.IDNS_GiaoVien = ud.IDNS_GiaoVien; pXL_KeHoachChiTietInfo.IDXL_Tuan = IDXL_Tuan; pXL_KeHoachChiTietInfo.GhiChu = "" + ud.GhiChu; oBXL_KeHoachChiTiet.Update(pXL_KeHoachChiTietInfo); } } else { pXL_KeHoachChiTietInfo.SoTiet = ud.SoTiet; pXL_KeHoachChiTietInfo.LoaiTiet = ud.LoaiTiet; pXL_KeHoachChiTietInfo.IDXL_MonHocTrongKy = IDXL_MonHocTrongKy; pXL_KeHoachChiTietInfo.IDDM_MonHoc = int.Parse(IDDM_MonHoc); pXL_KeHoachChiTietInfo.IDDM_Lop = IDDM_Lop; pXL_KeHoachChiTietInfo.IDNS_GiaoVien = ud.IDNS_GiaoVien; pXL_KeHoachChiTietInfo.IDXL_Tuan = IDXL_Tuan; pXL_KeHoachChiTietInfo.GhiChu = "" + ud.GhiChu; ud.XL_KeHoachChiTietID = oBXL_KeHoachChiTiet.Add(pXL_KeHoachChiTietInfo); } // Sau khi cập nhật thì set lại giá trị của các Cell_KeHoach ud.Changed = false; rg.UserData = ud; } } } } } LuuThanhCong(); } else { ThongBao("Không có dữ liệu để lưu !"); } }