private void Load_CongViec()
{
clsCongViec cls = new clsCongViec();
cls.ID_CongViec = Convert.ToInt32(m_iID_CongViec);
DataTable dt = cls.SelectOne();
txtMaCV.EditValue = dt.Rows[0]["Ma_CongViec"];
txtTieuDe.EditValue = dt.Rows[0]["TieuDe"];
txtMoTa.EditValue = dt.Rows[0]["MoTa"];
cmbLoaiCongViec.EditValue = dt.Rows[0]["ID_LoaiCV"];
cmbDoUuTien.EditValue = int.Parse(dt.Rows[0]["ID_MucDoUuTien"].ToString());
cmbCongViecGoc.EditValue = dt.Rows[0]["ID_CongViec_Goc"].ToString();
cmbNguoiGiaoViec.EditValue = dt.Rows[0]["ID_NguoiYeuCau"].ToString();
dtNgayDenHan.Value = dt.Rows[0]["Ngay_DenHan"];
dtNgayYeuCauMoi.Value = dt.Rows[0]["Ngay_YeuCau"];
txtThoiGianDuKien.EditValue = dt.Rows[0]["ThoiGian_DuKien"];
cmbDonViTG.SelectedValue = short.Parse(dt.Rows[0]["ID_ThoiGian"].ToString());
dtNgayBatDau.Value = dt.Rows[0]["Ngay_BatDau"];
dtNgayHT.Value = dt.Rows[0]["Ngay_HoanThanh"];
cmbTrangThai.EditValue = int.Parse(dt.Rows[0]["ID_TrangThai"].ToString());
txtDiaDiemMoi.EditValue = dt.Rows[0]["DiaDiem"];
string[] nhanvien = dt.Rows[0]["DS_ID_NhanVien"].ToString().Split(',');
cmbNhanVien.EditValue = nhanvien[0];
cmbNguoiThucHien.SetEditValue(dt.Rows[0]["DS_ID_NhanVien"].ToString());
}
private void CB_CongViecHoanThanhTrongNgay()
{
var cls = new clsCongViec();
var dt = cls.CongViec_HoanThanhTrongNgay(GlobalVariables.GetID_NhanSu()
.ToString(CultureInfo.InvariantCulture));
switch (dt.Rows.Count)
{
case 0:
break;
case 1:
m_iCongViecTH = 1;
m_iID_CongViecTH = int.Parse(dt.Rows[0]["ID_CongViec"].ToString());
alertControl1.Show(ActiveMdiChild, "Thông báo",
"Có " + 1 + " công việc phải hoàn thành trong ngày hôm nay!");
break;
default:
if (dt.Rows.Count > 1)
{
m_iCongViecTH = dt.Rows.Count;
alertControl1.Show(ActiveMdiChild, "Thông báo",
"Có " + m_iCongViecTH + " công việc phải hoàn thành trong ngày hôm nay!");
}
break;
}
}
private void CB_ThongBao_DenHan_VaoForm()
{
//1. Lay cv chua hoan thanh va thoi gian can canh bao
var cls = new clsCongViec();
var dt = cls.Select_CongViec_ThongBaoTruocKhoangThoiGian(GlobalVariables.GetID_NhanSu().ToString());
var strMessage = "";
foreach (DataRow dataRow in dt.Rows)
{
strMessage = string.Format("Công việc '{0}' sắp đến hạn hoàn thành!", dataRow["TieuDe"]);
alertControl2.Show(ActiveMdiChild, "Thông báo", strMessage);
}
}
private void CB_ThongBao_KhiCoThayDoi_VaoForm()
{
//1. Lay cv chua hoan thanh va thoi gian can canh bao
var cls = new clsCongViec();
var dt = cls.Select_CongViec_ThongBao_KhiCoThayDoi(GlobalVariables.GetID_NhanSu().ToString());
var strMessage = "";
foreach (DataRow dataRow in dt.Rows)
{
strMessage = dataRow["NoiDung"].ToString();
alertControl3.Show(ActiveMdiChild, "Thông báo", strMessage);
}
}
private void LoadcmbCongViecGocCu()
{
var cmb = cmbCVGocCu;
cmb.Tag = 0;
clsCongViec cls = new clsCongViec();
DataTable dt = cls.SelectAll();
cmb.Properties.DataSource = dt.DefaultView.ToTable();
cmb.Properties.DisplayMember = "TieuDe";
cmb.Properties.ValueMember = "ID_CongViec";
cmb.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
cmb.Tag = 1;
}
private void CB_ThongBao_KhiCoThayDoi()
{
var cls = new clsCongViec();
var dt = cls.Select_CongViec_ThongBao_KhiCoThayDoi(GlobalVariables.GetID_NhanSu()
.ToString(CultureInfo.InvariantCulture));
var strMessage = "";
int iID_ThongBao;
foreach (DataRow dataRow in dt.Rows)
{
iID_ThongBao = int.Parse(dataRow["ID_ThongBao"].ToString());
if (!m_lstID_DaThongBao.Contains(iID_ThongBao))
{
m_lstID_DaThongBao.Add(iID_ThongBao);
strMessage = dataRow["NoiDung"].ToString();
alertControl3.Show(ActiveMdiChild, "Thông báo", strMessage);
}
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (fg.Row < fg.Rows.Fixed)
{
BaseMessages.ShowInformationMessage("Chưa chọn công việc!");
return;
}
if (BaseMessages.ShowDeleteQuestionMessage() == DialogResult.No)
{
return;
}
clsCongViec cls = new clsCongViec();
cls.ID_CongViec = Convert.ToInt32(fg[fg.Row, "ID_CongViec"]);
cls.TonTai = false;
cls.Update();
BaseMessages.ShowInformationMessage("Xóa thành công!");
Loadfg();
fg.ApplyFilters();
}
private void CB_ThongBao_DenHan()
{
//1. Lay cv chua hoan thanh va thoi gian can canh bao
var cls = new clsCongViec();
var dt = cls.Select_CongViec_ThongBaoTruocKhoangThoiGian(GlobalVariables.GetID_NhanSu()
.ToString(CultureInfo.InvariantCulture));
var strMessage = "";
int iID_CongViec;
foreach (DataRow dataRow in dt.Rows)
{
iID_CongViec = int.Parse(dataRow["ID_CongViec_ThongBao"].ToString());
if (!m_lstID_CongViec_DaThongBao.Contains(iID_CongViec))
{
m_lstID_CongViec_DaThongBao.Add(iID_CongViec);
strMessage = string.Format("Công việc '{0}' sắp đến hạn hoàn thành!", dataRow["TieuDe"]);
alertControl2.Show(ActiveMdiChild, "Thông báo", strMessage);
}
}
}
private void LoadView(int cheDo)
{
InstalCsStyle();
fg.BeginUpdate();
fg.ClearRows();
if (cheDo == 1)
{
}
if (cheDo == 2)
{
fg.Cols[1].Caption = "Chủ nhật";
fg.Cols[1].Width = 205;
fg.Cols[1].Style = csNghi;
for (int c = 0; c < 7; ++c)
{
C1.Win.C1FlexGrid.Column col = fg.Cols.Add();
col.Width = 200;
col.Caption = "Thứ " + (c + 2);
col.Name = c.ToString();
}
for (int r = 1; r <= 30; ++r)
{
C1.Win.C1FlexGrid.Row row = fg.Rows.Add();
for (int c = fg.Cols.Fixed; c < fg.Cols.Count; ++c)
{
if (r % 6 == 0)
{
this.fg.SetCellStyle(r, c, "b");
}
}
}
for (int c = fg.Cols.Fixed + 1; c < fg.Cols.Count; ++c)
{
fg.Cols[c].Style = csNgayThuong;
}
fg.Cols[fg.Cols.Fixed].Style = csNghi;
DateTime d = firstDayCalendar;
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; r += 6)
{
for (int c = fg.Cols.Fixed; c < fg.Cols.Count; ++c)
{
if (d.Day == 1)
{
fg[r, c] = d.Day + " tháng " + d.Month;
}
else
{
fg[r, c] = d.Day;
}
d = d.AddDays(1);
}
}
}
if (cheDo == 3)
{
DateTime date = monthCalendar.SelectionRange.Start;
int totalCalendarDays = 42; // matrix 7 x 5
// set the first month day
DateTime firstDayMonth = new DateTime(date.Year, date.Month, 1);
// set the lastmonth day
DateTime lastDayMonth = new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month));
// now get the first day week of the first day month (0-6 Sun-Sat)
byte firstDayWeek = (byte)firstDayMonth.DayOfWeek;
// now get the first day week of the last day month (0-6 Sun-Sat)
byte lastDayWeek = (byte)lastDayMonth.DayOfWeek;
// now the first day show in calendar is the first day month minus the days to 0 (sunday)
firstDayCalendar = firstDayMonth.Subtract(TimeSpan.FromDays(firstDayWeek));
int tempDays = (lastDayMonth - firstDayCalendar).Days;
lastDayCalendar = lastDayMonth.Add(TimeSpan.FromDays(totalCalendarDays - tempDays - 1));
for (int r = 1; r <= 36; ++r)
{
C1.Win.C1FlexGrid.Row row = fg.Rows.Add();
for (int c = fg.Cols.Fixed; c < fg.Cols.Count; ++c)
{
if (r % 6 == 0)
{
this.fg.SetCellStyle(r, c, "b");
}
}
}
for (int c = fg.Cols.Fixed + 1; c < fg.Cols.Count; ++c)
{
fg.Cols[c].Style = csNgayThuong;
}
DateTime d = firstDayCalendar;
clsCongViec cls = new clsCongViec();
DataTable dt_DsNgayNghi = cls.DS_NgayNghi(firstDayCalendar, lastDayCalendar);
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; r += 6)
{
for (int c = fg.Cols.Fixed; c < fg.Cols.Count; ++c)
{
if (d.Day == 1)
{
fg[r, c] = d.Day + "/" + d.Month;
}
else
{
fg[r, c] = d.Day + "/" + d.Month;
}
if (d.Date == dtNow.Date)
{
for (int i = 0; i < 1; ++i)
{
CellRange range = fg.GetCellRange(r + i, c);
range.Style = csNgayHomNay;
}
}
if (Trong_DsNgayNghi(dt_DsNgayNghi, d))
{
for (int i = 0; i < 1; ++i)
{
CellRange range = fg.GetCellRange(r + i, c);
range.Style = csNghi;
}
}
d = d.AddDays(1);
}
}
LoadCalendar(cheDo, firstDayCalendar);
fg.AllowMerging = AllowMergingEnum.Custom;
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; ++i)
{
fg.Rows[i].AllowMerging = true;
}
}
fg.EndUpdate();
fg.AllowMerging = AllowMergingEnum.Free;
}
private void LoadCalendar(int cheDo, DateTime ngayBatDau)
{
if (cheDo == 1)
{
}
if (cheDo == 2)
{
}
if (cheDo == 3)
{
cell_IDLich = new int[252];
DateTime ngayCuoi = ngayBatDau.AddDays(35);
clsCongViec cls = new clsCongViec();
DataTable dt_Lich = cls.CongViec_Lich(ngayBatDau, ngayCuoi, id_NhanVien_DangNhap, ds_LoaiCV);
//
TinhSoCongViecTrongMoiNgay(dt_Lich);
foreach (DataRow dr in dt_Lich.Rows)
{
DateTime thoiGian_BatDau, thoiGian_KetThuc;
if (dr["Ngay_DenHan"].ToString() == "")
{
thoiGian_KetThuc = lastDayCalendar;
}
else
{
thoiGian_KetThuc = (DateTime)(dr["Ngay_DenHan"]);
}
if (dr["Ngay_YeuCau"].ToString() != "")
{
thoiGian_BatDau = (DateTime)(dr["Ngay_YeuCau"]);
}
else
{
thoiGian_BatDau = firstDayCalendar;
}
if (thoiGian_BatDau > thoiGian_KetThuc)
{
thoiGian_KetThuc = dtNow;
}
if (thoiGian_BatDau.Date > lastDayCalendar.Date || thoiGian_KetThuc.Date < firstDayCalendar.Date)
{
continue;
}
if (thoiGian_BatDau < firstDayCalendar)
{
thoiGian_BatDau = firstDayCalendar;
}
while ((thoiGian_BatDau) <= thoiGian_KetThuc)
{
if (thoiGian_BatDau.Date < firstDayCalendar || thoiGian_BatDau.Date > lastDayCalendar)
{
thoiGian_BatDau = thoiGian_BatDau.AddDays(1);
continue;
}
if (dr["DS_Thu"].ToString() == "" && dr["DS_Ngay"].ToString() == "" && dr["DS_Thang"].ToString() == "")
{
}
else
{
if (!TrongDSNgay(dr["DS_Thu"].ToString(), dr["DS_Ngay"].ToString(), dr["DS_Thang"].ToString(), thoiGian_BatDau))
{
thoiGian_BatDau = thoiGian_BatDau.AddDays(1);
continue;
}
}
if (dr["ID_TrangThai"].ToString() == "3" || dr["ID_TrangThai"].ToString() == "4")
{
thoiGian_BatDau = thoiGian_BatDau.AddDays(1);
continue;
}
int[] rc = DateToInt(thoiGian_BatDau);
bool thoaManHienThiThanhMotHangNgang = true;
int r = rc[0];
int soNgayCuaCongViecTrongHang = 0;
int soNgay = (int)(thoiGian_KetThuc - thoiGian_BatDau).TotalDays;
for (r = rc[0] + 1; r <= rc[0] + 5; ++r)
{
thoaManHienThiThanhMotHangNgang = true;
int c = rc[1];
while (c <= (rc[1] + soNgay) && c < fg.Cols.Count)
{
if (fg.GetDataDisplay(r, c) != "")
{
thoaManHienThiThanhMotHangNgang = false;
break;
}
++c;
}
if (thoaManHienThiThanhMotHangNgang && (c == (rc[1] + soNgay + 1) || c == fg.Cols.Count))
{
soNgayCuaCongViecTrongHang = c - rc[1];
break;
}
}
if (r <= rc[0] + 5)
{
DateTime d;
for (d = thoiGian_BatDau.Date; d <= thoiGian_BatDau.Date.AddDays(soNgayCuaCongViecTrongHang - 1); d = d.AddDays(1))
{
//
if (dr["DS_Thu"].ToString() == "" && dr["DS_Ngay"].ToString() == "" && dr["DS_Thang"].ToString() == "")
{
}
else
{
if (!TrongDSNgay(dr["DS_Thu"].ToString(), dr["DS_Ngay"].ToString(), dr["DS_Thang"].ToString(), d))
{
//thoiGian_BatDau = thoiGian_BatDau.AddDays(1);
continue;
}
}
//
int[] row_col = DateToInt(d);
int index = (r - 1) * 7 + row_col[1];
cell_IDLich[index] = int.Parse(dr["ID_CongViec"].ToString());
fg[r, row_col[1]] = dr["TieuDe"];
string[] loaiCV_Array = ds_LoaiCV.Split(',');
if (dr["ID_LoaiCV"].ToString() == "1")
{
CellRange range = fg.GetCellRange(r, row_col[1]);
range.Style = csHop;
//fg.SetCellImage(r, row_col[1], ProjectManagements.Properties.Resources.ico_Blue_Rec_img);
}
if (dr["ID_LoaiCV"].ToString() == "2")
{
CellRange range = fg.GetCellRange(r, row_col[1]);
range.Style = csCongTac;
//fg.SetCellImage(r, row_col[1], ProjectManagements.Properties.Resources.ico_Purple_Rec_img);
}
if (dr["ID_LoaiCV"].ToString() != "2" && dr["ID_LoaiCV"].ToString() != "1")
{
CellRange range = fg.GetCellRange(r, row_col[1]);
range.Style = csCongViec;
//fg.SetCellImage(r, row_col[1], ProjectManagements.Properties.Resources.ico_Purple_Rec_img);
}
//
}
thoiGian_BatDau = d;
continue;
}
thoiGian_BatDau = thoiGian_BatDau.AddDays(1);
}
}
}
}
private void Loadfg()
{
fg.Tag = 0;
fg.BeginUpdate();
clsCongViec cls = new clsCongViec();
SqlDateTime TuNgay = SqlDateTime.Null;
SqlDateTime DenNgay = SqlDateTime.Null;
SqlDateTime BatDauTuNgay = SqlDateTime.Null;
SqlDateTime BatDauDenNgay = SqlDateTime.Null;
if (dtmTuNgay.Text.Length == dtmTuNgay.CustomFormat.Length)
{
TuNgay = DateTime.Parse(dtmTuNgay.Text);
}
if (dtmDenNgay.Text.Length == dtmDenNgay.CustomFormat.Length)
{
DenNgay = DateTime.Parse(dtmDenNgay.Text).AddDays(1);
}
if (dtmBatDauTuNgay.Text.Length == dtmBatDauTuNgay.CustomFormat.Length)
{
BatDauTuNgay = DateTime.Parse(dtmBatDauTuNgay.Text);
}
if (dtmBatDauDenNgay.Text.Length == dtmBatDauDenNgay.CustomFormat.Length)
{
BatDauDenNgay = DateTime.Parse(dtmBatDauDenNgay.Text).AddDays(1);
}
DataTable dt;
//if (!isView)
//{
// dt = cls.SelectDS_CongViec(TuNgay, DenNgay, BatDauTuNgay, BatDauDenNgay, id_NhanSu);
//}
//else
//{
// dt = cls.SelectDS_CongViec_Trong1Ngay(ngayLuaChon, id_NhanSu);
//}
//dt = cls.SelectDS_CongViec(TuNgay, DenNgay, BatDauTuNgay, BatDauDenNgay, id_NhanSu);
dt = cls.SelectDS_CongViec_Trong1Ngay(ds_ID_CongViec);
fg.ClearRows();
fg.SetDataSource(dt);
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
int ID_TrangThai = Convert.ToInt32(fg[i, "ID_TrangThai"]);
if (ID_TrangThai == (int)TrangThai.ChuaThucHien)
{
fg.Rows[i].Style = csChuaThucHien;
}
else if (ID_TrangThai == (int)TrangThai.DangThucHien)
{
fg.Rows[i].Style = csDangThucHien;
}
else if (ID_TrangThai == (int)TrangThai.Huy)
{
fg.Rows[i].Style = csHuy;
}
else if (ID_TrangThai == (int)TrangThai.DaXong)
{
fg.Rows[i].Style = csDaXong;
}
if ((fg[i, "DS_Ten_NhanVien"] ?? "").ToString() != "")
{
string[] tenNhanVien = fg[i, "DS_Ten_NhanVien"].ToString().Split(',');
fg[i, "DS_Ten_NhanVien"] = "";
foreach (var name in tenNhanVien)
{
fg[i, "DS_Ten_NhanVien"] += name.Trim() + "\n";
}
}
if ((fg[i, "ThoiGian_DuKien"] ?? "").ToString() != "")
{
fg[i, "ThoiGian_DuKien"] += " " + fg[i, "Ten_ThoiGian"];
}
}
fg.Row = -1;
fg.AutoSizeRows();
fg.EndUpdate();
fg.Tag = 1;
}
public void LoadData()
{
fg.Tag = 0;
//m_iSelectedRow = fg.Row;
//for (int i = 2; i < cmbTuyChonHienThi.Properties.Items.Count; i++)
//{
// if (cmbTuyChonHienThi.Properties.Items[i].CheckState == CheckState.Checked)
// {
// string nameCol = cmbTuyChonHienThi.Properties.Items[i].Value.ToString();
// fg.Cols[nameCol].Visible = true;
// }
// else
// {
// string nameCol = cmbTuyChonHienThi.Properties.Items[i].Value.ToString();
// fg.Cols[nameCol].Visible = false;
// }
//}
m_irowDateOfTimeline = 30;
fg.Cols.RemoveRange(m_irowDateOfTimeline, (fg.Cols.Count - m_irowDateOfTimeline));
m_dtD1 = (DateTime)dteNgayBatDau.Value;
m_dtD2 = (DateTime)dteNgayKetThuc.Value;
if (m_dtD1.Date > m_dtD2.Date)
{
BaseMessages.ShowWarningMessage("Ngày bắt đầu phải nhỏ hơn ngày kết thúc");
return;
}
if ((int)(m_dtD2.Date - m_dtD1.Date).TotalDays > 365)
{
BaseMessages.ShowWarningMessage("Khoảng thời gian quá dài");
return;
}
//
clsCongViec cls = new clsCongViec();
dt = new DataTable();
dt = cls.CongViec_SelecAll_List_IDNhanVien_IDTrangThai(m_dtD1, m_dtD2, m_sds_NhanVien, m_sds_TrangThai,
m_sds_LoaiCV, m_sds_MucDoUuTien, m_sds_NguoiYeuCau);
//
fg.BeginUpdate();
fg.ClearRows();
clsDM_LoaiCV cls_LoaiCV = new clsDM_LoaiCV();
//DataTable dt_LoaiCV = cls_LoaiCV.SelectAll(); // Lay tat ca loai cong viec
DataTable dt_LoaiCV = new DataTable();
cls_LoaiCV.ID_DonVi = GlobalVariables.uID_DonVi; // lay don vi cua nguoi dang nhap
dt_LoaiCV = cls_LoaiCV.SelectAll_TheoDonVi(); // Lay tat ca loai cong viec theo don vi
foreach (DataRow dr in dt_LoaiCV.Rows)
{
Row fgRow = fg.Rows.Add();
fgRow["ID_CongViec"] = "-" + dr["ID_LoaiCV"];
fgRow["TieuDe"] = dr["Ten_LoaiCV"];
fgRow["ID_LoaiCV"] = dr["ID_LoaiCV"];
if (dr["ID_LoaiCV_Cha"].ToString() == "")
{
}
else
{
fgRow["ID_CongViec_Goc"] = "-" + dr["ID_LoaiCV_Cha"];
}
}
decimal giaTri = 0;
foreach (DataRow dr in dt.Rows)
{
DateTime d = m_dtD1;
if (fg.Rows.Count > 1)
{
if (fg.GetDataDisplay(fg.Rows.Count - 1, "Ma_CongViec").ToString() ==
dr["Ma_CongViec"].ToString() &&
fg.GetDataDisplay(fg.Rows.Count - 1, "Ma_CongViec").ToString() != "")
{
decimal giaTri_Sau = 0;
decimal.TryParse(dr["GiaTri"].ToString(), out giaTri_Sau);
giaTri = giaTri + giaTri_Sau;
fg.Rows[fg.Rows.Count - 1]["GiaTri"] = giaTri;
continue;
}
decimal.TryParse(dr["GiaTri"].ToString(), out giaTri);
}
Row fgRow = fg.Rows.Add();
//
fgRow["ID_CongViec"] = dr["ID_CongViec"];
fgRow["Ma_CongViec"] = dr["Ma_CongViec"];
fgRow["GiaTri"] = giaTri;
fgRow["DS_ID_NhanVien"] = dr["DS_ID_NhanVien"];
fgRow["ID_MucDoUuTien"] = dr["ID_MucDoUuTien"];
fgRow["TieuDe"] = dr["TieuDe"];
fgRow["MoTa"] = dr["MoTa"];
fgRow["Ngay_YeuCau"] = dr["Ngay_YeuCau"];
fgRow["Ngay_DenHan"] = dr["Ngay_DenHan"];
fgRow["ThoiGian_DuKien"] = dr["ThoiGian_DuKien"];
fgRow["ID_ThoiGian"] = dr["ID_ThoiGian"];
if (dr["PhanTramHoanThanh"].ToString() == "")
{
dr["PhanTramHoanThanh"] = 0;
}
fgRow["PhanTramHoanThanh"] = dr["PhanTramHoanThanh"] + " %";
fgRow["Ngay_BatDau"] = dr["Ngay_BatDau"];
fgRow["ID_TrangThai"] = dr["ID_TrangThai"];
fgRow["ID_LoaiCV"] = dr["ID_LoaiCV"];
fgRow["ID_CongViec_Goc"] = dr["ID_CongViec_Goc"];
fgRow["Ngay_HoanThanh"] = dr["Ngay_HoanThanh"];
fgRow["Ngay_Lap"] = dr["Ngay_Lap"];
fgRow["ID_NguoiLap"] = dr["ID_NguoiLap"];
fgRow["Ngay_SuaCuoi"] = dr["Ngay_SuaCuoi"];
fgRow["ID_NguoiSuaCuoi"] = dr["ID_NguoiSuaCuoi"];
fgRow["ID_NguoiYeuCau"] = dr["ID_NguoiYeuCau"];
fgRow["Ten_TrangThai"] = dr["Ten_TrangThai"];
fgRow["Ten_MucDo"] = dr["Ten_MucDo"];
fgRow["ID_NGuoiYeuCau"] = dr["ID_NGuoiYeuCau"];
fgRow["Ten_KetQua_DonVi"] = dr["Ten_KetQua_DonVi"];
fgRow["SoLuong_KeHoach"] = dr["SoLuong_KeHoach"];
clsNhanSu clsNS = new clsNhanSu();
//dt_NhanSu = cls.GetNhanSu(SystemModule.HeThong.GlobalVariables.uID_DonVi, 0);
dt_NhanSu = clsNS.SelectW_ID_NguoiQuanLy(DataAccess.QLCV.Global.GlobalVariables.GetID_NhanSu(), GlobalVariables.uID_DonVi);
for (int j = 0; j < dt_NhanSu.Rows.Count; ++j)
{
if (dr["ID_NGuoiYeuCau"].ToString() == dt_NhanSu.Rows[j]["ID_NhanSu"].ToString().Trim())
{
fgRow["NGuoi_YeuCau"] = dt_NhanSu.Rows[j]["HoTen"].ToString().Trim();
}
}
//Lấy tên nhân viên
string ds_Ten_NhanVien = "";
string[] ds_ID_NhanVien = dr["DS_ID_NhanVien"].ToString().Split(',');
if (ds_ID_NhanVien.Length > 1)
{
for (int i = 0; i < ds_ID_NhanVien.Length; ++i)
{
foreach (DataRow drNV in dt_NhanSu.Select("ID_NhanSu = " + ds_ID_NhanVien[i].Trim()))
{
ds_Ten_NhanVien += drNV["HoTen"].ToString().Trim() + ", ";
break;
}
}
}
if (ds_Ten_NhanVien.Length > 2)
{
fgRow["ds_NhanVien"] = ds_Ten_NhanVien.Remove(ds_Ten_NhanVien.Length - 2, 1); // Xoa 2 ky tu o cuoi
}
}
//insert loaiCV
//Add ID_COngViec_Goc bằng ID_LoaiCV
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
if (fg.GetDataDisplay(r, "ID_CongViec_Goc").ToString() == "" &&
int.Parse(fg.GetDataDisplay(r, "ID_CongViec").ToString()) > 0)
{
if (fg.GetDataDisplay(r, "ID_LoaiCV").ToString() == "")
{
}
else
{
fg.Rows[r]["ID_CongViec_Goc"] = "-" + fg.Rows[r]["ID_LoaiCV"];
}
}
}
//Add Node công việc con
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
fg.Rows[r].Visible = false;
fg.Rows.InsertNode(r + 1, 0);
GetDataTwoRow(r + 1, r);
++r;
}
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; r++)
{
if (!fg.Rows[r].Visible)
{
fg.Rows.Remove(r);
r = r - 1;
}
}
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
if (fg.Rows[r].Node.Level == 0 && fg.Rows[r].Visible && IsNode0(r))
{
r = TimCongViecGoc(r, 1);
}
}
int level = 1;
while (TonTaiCongViecGoc(level))
{
for (int r1 = fg.Rows.Fixed; r1 < fg.Rows.Count; ++r1)
{
if (fg.Rows[r1].Node.Level == level && fg.Rows[r1].Visible)
{
r1 = TimCongViecGoc(r1, level + 1);
}
}
++level;
}
fg.Tree.Column = 1;
//ShowTimeline(m_dtDtNow);
DoiMauTrangThai(fg);
ChiHienThiCoCongViec(chkHienThiKhiCoCV.Checked);
HienThi_ChuaDoc_Comment();
SetSTT();
fg.Row = -1;
fg.EndUpdate();
fg.Tag = 1;
//fg.Row = m_iSelectedRow;
}
private void LoadfgBaoCaoNgay()
{
var fg = fgBaoCaoNgay;
fg.Tag = 0;
fg.BeginUpdate();
var cls = new clsCongViec();
m_dtD3 = (DateTime)dtmTuNgay.Value;
m_dtD4 = (DateTime)dtmDenNgay.Value;
if (m_dtD3.Date > m_dtD4.Date)
{
BaseMessages.ShowWarningMessage("Ngày bắt đầu phải nhỏ hơn ngày kết thúc");
return;
}
if ((int)(m_dtD4.Date - m_dtD3.Date).TotalDays > 365)
{
BaseMessages.ShowWarningMessage("Khoảng thời gian quá dài");
return;
}
DataTable dt;
dt = cls.SelectAll_CongViec_BaoCaoNgay(m_dtD3, m_dtD4, m_sds_NhanVien);
fg.ClearRows();
fg.SetDataSource(dt);
var ID_NhanVien = m_sds_NhanVien.ToString().Split(',');
for (var i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
var ID_TrangThai = Convert.ToInt32(fg[i, "ID_TrangThai"]);
if (ID_TrangThai == (int)TrangThai.ChuaThucHien)
{
fg.Rows[i].Style = csChuaThucHien;
}
else if (ID_TrangThai == (int)TrangThai.DangThucHien)
{
fg.Rows[i].Style = csDangThucHien;
}
else if (ID_TrangThai == (int)TrangThai.Huy)
{
fg.Rows[i].Style = csHuy;
}
else if (ID_TrangThai == (int)TrangThai.DaXong)
{
fg.Rows[i].Style = csDaXong;
}
if ((fg[i, "DS_Ten_NhanVien"] ?? "").ToString() != "")
{
string[] tenNhanVien = fg[i, "DS_Ten_NhanVien"].ToString().Split(',');
fg[i, "DS_Ten_NhanVien"] = "";
foreach (var name in tenNhanVien)
{
fg[i, "DS_Ten_NhanVien"] += name.Trim() + "\n";
}
}
if ((fg[i, "ThoiGian_DuKien"] ?? "").ToString() != "")
{
fg[i, "ThoiGian_DuKien"] += " " + fg[i, "Ten_ThoiGian"];
}
}
LoadTree(fgBaoCaoNgay);
int iSTT = 0;
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
if (fg.Rows[i].IsNode)
{
iSTT = 0;
}
else
{
fg[i, "STT"] = iSTT;
}
iSTT++;
}
fg.Row = -1;
fg.AutoSizeRows();
LocTheoNhanVien(fgBaoCaoNgay);
fg.Cols.Frozen = fg.Cols["TieuDe"].Index + 1;
fg.EndUpdate();
fg.Tag = 1;
}
