public DataTable GetByTuanThu(XL_TuanInfo pTuanInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_Tuan_GetByTuanThuResult>(client.cDXL_Tuan_GetByTuanThu(GlobalVar.MaXacThuc, pTuanInfo)));
}
}
public DataTable GetByIDNamHoc(XL_TuanInfo pTuanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNamHoc", SqlDbType.Int, pTuanInfo.IDDM_NamHoc));
return(RunProcedureGet("sp_XL_Tuan_GetByIDNamHoc", colParam));
}
public void Delete(XL_TuanInfo pXL_TuanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_TuanID", SqlDbType.BigInt, pXL_TuanInfo.XL_TuanID));
RunProcedure("sp_XL_Tuan_Delete", colParam);
}
public DataTable Get(XL_TuanInfo pXL_TuanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_TuanID", SqlDbType.BigInt, pXL_TuanInfo.XL_TuanID));
return(RunProcedureGet("sp_XL_Tuan_Get", colParam));
}
public int Add(XL_TuanInfo pXL_TuanInfo)
{
int ID = 0;
ID = oDXL_Tuan.Add(pXL_TuanInfo);
mErrorMessage = oDXL_Tuan.ErrorMessages;
mErrorNumber = oDXL_Tuan.ErrorNumber;
return(ID);
}
public void DeleteTuanThua(XL_TuanInfo pTuanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TuanThu", SqlDbType.Int, pTuanInfo.TuanThu));
colParam.Add(CreateParam("@IDNamHoc", SqlDbType.Int, pTuanInfo.IDDM_NamHoc));
RunProcedure("sp_XL_Tuan_DeleteTuanThua", colParam);
}
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");
}
}
public void Update(XL_TuanInfo pXL_TuanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pXL_TuanInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@TuanThu", SqlDbType.Int, pXL_TuanInfo.TuanThu));
colParam.Add(CreateParam("@TuNgay", SqlDbType.DateTime, pXL_TuanInfo.TuNgay));
colParam.Add(CreateParam("@DenNgay", SqlDbType.DateTime, pXL_TuanInfo.DenNgay));
colParam.Add(CreateParam("@ChoPhepXemLich", SqlDbType.Bit, pXL_TuanInfo.ChoPhepXemLich));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pXL_TuanInfo.HocKy));
colParam.Add(CreateParam("@XL_TuanID", SqlDbType.BigInt, pXL_TuanInfo.XL_TuanID));
RunProcedure("sp_XL_Tuan_Update", colParam);
}
public int Add(XL_TuanInfo pXL_TuanInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pXL_TuanInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@TuanThu", SqlDbType.Int, pXL_TuanInfo.TuanThu));
colParam.Add(CreateParam("@TuNgay", SqlDbType.DateTime, pXL_TuanInfo.TuNgay));
colParam.Add(CreateParam("@DenNgay", SqlDbType.DateTime, pXL_TuanInfo.DenNgay));
colParam.Add(CreateParam("@ChoPhepXemLich", SqlDbType.Bit, pXL_TuanInfo.ChoPhepXemLich));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pXL_TuanInfo.HocKy));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_Tuan_Add", colParam));
}
//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);
}
}
public List <XL_TuanInfo> GetList(XL_TuanInfo pXL_TuanInfo)
{
List <XL_TuanInfo> oXL_TuanInfoList = new List <XL_TuanInfo>();
DataTable dtb = Get(pXL_TuanInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oXL_TuanInfo = new XL_TuanInfo();
oXL_TuanInfo.XL_TuanID = long.Parse(dtb.Rows[i]["XL_TuanID"].ToString());
oXL_TuanInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oXL_TuanInfo.TuanThu = int.Parse(dtb.Rows[i]["TuanThu"].ToString());
oXL_TuanInfo.TuNgay = DateTime.Parse(dtb.Rows[i]["TuNgay"].ToString());
oXL_TuanInfo.DenNgay = DateTime.Parse(dtb.Rows[i]["DenNgay"].ToString());
oXL_TuanInfo.ChoPhepXemLich = bool.Parse(dtb.Rows[i]["ChoPhepXemLich"].ToString());
oXL_TuanInfoList.Add(oXL_TuanInfo);
}
}
return(oXL_TuanInfoList);
}
public DataTable GetByTuanThu(XL_TuanInfo pTuanInfo)
{
return(oDXL_Tuan.GetByTuanThu(pTuanInfo));
}
public void DeleteTuanThua(XL_TuanInfo pTuanInfo)
{
oDXL_Tuan.DeleteTuanThua(pTuanInfo);
mErrorMessage = oDXL_Tuan.ErrorMessages;
mErrorNumber = oDXL_Tuan.ErrorNumber;
}
public void Delete(XL_TuanInfo pXL_TuanInfo)
{
oDXL_Tuan.Delete(pXL_TuanInfo);
mErrorMessage = oDXL_Tuan.ErrorMessages;
mErrorNumber = oDXL_Tuan.ErrorNumber;
}
public DataTable GetByIDNamHoc(XL_TuanInfo pTuanInfo)
{
return(oDXL_Tuan.GetByIDNamHoc(pTuanInfo));
}
public DataTable Get(XL_TuanInfo pXL_TuanInfo)
{
return(oDXL_Tuan.Get(pXL_TuanInfo));
}
public void TaoKeHoachTuan(int IDNamHoc, DateTime TuNgay, DateTime DenNgay, int Ky2TuTuan)
{
XL_TuanInfo pXL_TuanInfo = new XL_TuanInfo();
cBXL_Tuan oBXL_Tuan = new cBXL_Tuan();
pXL_TuanInfo.IDDM_NamHoc = IDNamHoc;
DataView dv = oBXL_Tuan.GetByIDNamHoc(pXL_TuanInfo).DefaultView;
DateTime NgayDau, NgayCuoi;
int TuanThu, Tuan, Ky, idx;
// Lấy tuần thứ mấy trong năm. Dùng hàm DatePart của VB.NET
TuanThu = DateAndTime.DatePart(DateInterval.WeekOfYear, TuNgay, FirstDayOfWeek.Sunday, FirstWeekOfYear.Jan1);
NgayDau = TuNgay;
NgayCuoi = NgayDau.AddDays(1);
Tuan = 1;
Ky = 1;
do
{
if ((TuanThu != DateAndTime.DatePart(DateInterval.WeekOfYear, NgayCuoi, FirstDayOfWeek.Sunday, FirstWeekOfYear.Jan1)) && (NgayCuoi.DayOfWeek == DayOfWeek.Sunday))
{
dv.Sort = "TuanThu";
idx = dv.Find(Tuan);
if (idx < 0)
{
pXL_TuanInfo.TuanThu = Tuan;
pXL_TuanInfo.IDDM_NamHoc = IDNamHoc;
pXL_TuanInfo.TuNgay = NgayDau;
pXL_TuanInfo.DenNgay = NgayCuoi;
pXL_TuanInfo.ChoPhepXemLich = false;
pXL_TuanInfo.HocKy = Ky;
oBXL_Tuan.Add(pXL_TuanInfo);
}
else
{
pXL_TuanInfo.XL_TuanID = long.Parse(dv[idx]["XL_TuanID"].ToString());
pXL_TuanInfo.TuanThu = Tuan;
pXL_TuanInfo.IDDM_NamHoc = IDNamHoc;
pXL_TuanInfo.TuNgay = NgayDau;
pXL_TuanInfo.DenNgay = NgayCuoi;
pXL_TuanInfo.ChoPhepXemLich = false;
pXL_TuanInfo.HocKy = Ky;
oBXL_Tuan.Update(pXL_TuanInfo);
}
NgayCuoi = NgayCuoi.AddDays(1);
NgayDau = NgayCuoi;
TuanThu = DateAndTime.DatePart(DateInterval.WeekOfYear, NgayCuoi, FirstDayOfWeek.Sunday, FirstWeekOfYear.Jan1);
Tuan += 1;
if (Tuan < Ky2TuTuan)
{
Ky = 1;
}
else
{
Ky = 2;
}
}
NgayCuoi = NgayCuoi.AddDays(1);
}while (NgayCuoi <= DenNgay);
pXL_TuanInfo.TuanThu = Tuan;
oBXL_Tuan.DeleteTuanThua(pXL_TuanInfo);
}
