private void dlgApDungNhieuTuan_Load(object sender, EventArgs e)
{
cBXL_Tuan oBTuan = new cBXL_Tuan();
DataTable dtTuan = oBTuan.GetByTuTuan(Program.IDNamHoc, Program.HocKy, TuanThu);
cmbTuan.Properties.DataSource = dtTuan;
if (dtTuan.Rows.Count > 0)
{
cmbTuan.EditValue = TuanThu + 1;
}
}
private void FormatTieuDe(C1FlexGrid fg, int colBegin, int colWidth, bool ShowThang, bool ShowTuan, bool ShowNgay)
{
cBXL_Tuan oBTuan = new cBXL_Tuan();
XL_TuanInfo pTuanInfo = new XL_TuanInfo();
pTuanInfo.IDDM_NamHoc = Program.IDNamHoc;
DataTable dtTuan = oBTuan.GetByIDNamHoc(pTuanInfo);
int IDTuan, HocKy, TuanThu;
DateTime NgayDau, NgayCuoi;
try
{
string HocCaChuNhat = new cBHT_ThamSoHeThong().GetGiaTriByMaThamSo("HocCaChuNhat").Trim();
int Temp = colBegin;
for (int i = 0; i < dtTuan.Rows.Count; i++)
{
NgayDau = (DateTime)dtTuan.Rows[i]["TuNgay"];
NgayCuoi = (DateTime)dtTuan.Rows[i]["DenNgay"];
IDTuan = int.Parse(dtTuan.Rows[i]["XL_TuanID"].ToString());
TuanThu = int.Parse(dtTuan.Rows[i]["TuanThu"].ToString());
HocKy = int.Parse(dtTuan.Rows[i]["HocKy"].ToString());
//SoNgayTuan = NgayCuoi.Subtract(NgayDau).Days;
//for (int j = 0; j <= SoNgayTuan; j++)
//{
//fg.Cols.Add(1);
//NgayHienTai = NgayDau.AddDays(j);
fg[0, Temp] = IDTuan;
fg[1, Temp] = "Học kỳ " + HocKy.ToString();
fg[2, Temp] = "Tháng " + NgayDau.Month.ToString();
fg[3, Temp] = TuanThu;
if (HocCaChuNhat == "0" && NgayCuoi.DayOfWeek == DayOfWeek.Sunday)
{
fg[4, Temp] = NgayDau.Day.ToString() + " - " + NgayCuoi.AddDays(-1).Day.ToString();
}
else
{
fg[4, Temp] = NgayDau.Day.ToString() + " - " + NgayCuoi.Day.ToString();
}
//fg[5, Temp] = NgayHienTai.Day.ToString();
fg[5, Temp] = "C" + dtTuan.Rows[i]["XL_TuanID"].ToString();
fg.Cols[Temp].Width = colWidth;
fg.Cols[Temp].TextAlign = TextAlignEnum.CenterCenter;
Temp += 1;
//}
//Temp += 1;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "THÔNG BÁO LỖI");
}
}
private void frmBaoBanGiaoVien_Load(object sender, EventArgs e)
{
bar1.Visible = true;
if (Program.IDNamHoc > 0)
{
FlexColorSetup(fg);
FlexColorSetup(fgChiTiet);
cBXL_Tuan oBTuan = new cBXL_Tuan();
dtTuan = oBTuan.GetByHocKy_NamHoc(Program.IDNamHoc, Program.HocKy);
FillBaoBan();
}
}
public frmPhanBoPhongHoc()
{
InitializeComponent();
oBDM_PhongHoc = new cBDM_PhongHoc();
oBDM_Lop = new cBDM_Lop();
oBXL_Tuan= new cBXL_Tuan ();
oBXL_KeHoachToanTruong = new cBXL_KeHoachTruong();
txtNamHoc.Text = Program.NamHoc;
// load combobox
dtTuan = oBXL_Tuan.GetByHocKy_NamHoc(Program.IDNamHoc, Program.HocKy);
cmbTuTuan.Properties.DataSource = dtTuan;
cmbDenTuan.Properties.DataSource = dtTuan;
}
private void frmKeHoachThucHanh_Load(object sender, EventArgs e)
{
bar1.Visible = true;
bar2.Visible = true;
cBXL_Tuan oBTuan = new cBXL_Tuan();
dtTuan = oBTuan.GetByHocKy_NamHoc(Program.IDNamHoc, Program.HocKy);
dtLop = (new cBDM_Lop()).GetTree(Program.NamHoc);
fg.AllowMerging = AllowMergingEnum.Free;
FlexColor(fg);
FlexColor();
FormatGrid();
GetKeHoachThucHanhLop();
}
//private void GetKeHoachThucHanhGiangVien()
//{
//}
#endregion
#region Format Grid
private void FormatTieuDe(int colBegin, int colWidth, bool ShowThang, bool ShowTuan, bool ShowNgay)
{
cBXL_Tuan oBTuan = new cBXL_Tuan();
XL_TuanInfo pTuanInfo = new XL_TuanInfo();
int IDTuan, HocKy, TuanThu, SoNgayTuan;
DateTime NgayDau, NgayCuoi, NgayHienTai;
try
{
int Temp = colBegin;
for (int i = 0; i < dtTuan.Rows.Count; i++)
{
NgayDau = (DateTime)dtTuan.Rows[i]["TuNgay"];
NgayCuoi = (DateTime)dtTuan.Rows[i]["DenNgay"];
IDTuan = int.Parse(dtTuan.Rows[i]["XL_TuanID"].ToString());
TuanThu = int.Parse(dtTuan.Rows[i]["TuanThu"].ToString());
HocKy = int.Parse(dtTuan.Rows[i]["HocKy"].ToString());
SoNgayTuan = NgayCuoi.Subtract(NgayDau).Days;
for (int j = 0; j <= SoNgayTuan; j++)
{
NgayHienTai = NgayDau.AddDays(j);
if (Program.pgrThamSo.THUCHANH_TU_THU <= (int)NgayHienTai.DayOfWeek && (int)NgayHienTai.DayOfWeek <= Program.pgrThamSo.THUCHANH_DEN_THU)
{
if (NgayHienTai.DayOfWeek != DayOfWeek.Sunday)
{
fg.Cols.Add(1);
fg[0, Temp] = IDTuan;
fg[1, Temp] = "Học kỳ " + HocKy.ToString();
fg[2, Temp] = "Tháng " + NgayHienTai.Month.ToString();
fg[3, Temp] = TuanThu;
fg[4, Temp] = NgayDau.Day.ToString() + " - " + NgayCuoi.Day.ToString();
fg[5, Temp] = NgayHienTai.Day;
fg[6, Temp] = "C_" + DateToInt(NgayHienTai);
fg.Cols[Temp].Width = colWidth;
fg.Cols[Temp].TextAlign = TextAlignEnum.CenterCenter;
Temp += 1;
}
}
}
}
}
catch (Exception ex)
{
ThongBaoLoi(ex.Message);
}
}
private void frmKeHoachToanTruong_Load(object sender, EventArgs e)
{
bar2.Visible = true;
bar3.Visible = true;
try
{
FlexColor(fg);
fg.DataSource = null;
cBXL_Tuan oBTuan = new cBXL_Tuan();
XL_TuanInfo pTuanInfo = new XL_TuanInfo();
pTuanInfo.IDDM_NamHoc = Program.IDNamHoc;
dtTuan = oBTuan.GetByIDNamHoc(pTuanInfo);
//barbtnOpen_ItemClick(null, null);
}
catch (Exception ex)
{
ThongBaoLoi(ex.Message);
}
}
