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 !");
}
}
