private void ucHoatDongHNXH_Load(object sender, EventArgs e)
{
registerButtonArray(btnControl);
deSearchTuNgay.Ex_FormatCustomDateEdit();
deSearchDenNgay.Ex_FormatCustomDateEdit();
deTuNgay.Ex_FormatCustomDateEdit();
deDenNgay.Ex_FormatCustomDateEdit();
seTongSoTien.Ex_FormatCustomSpinEdit();
seSoLuongNguoiThamGia.Ex_FormatCustomSpinEdit();
var current = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
var nextMonth = current.AddMonths(1);
deSearchTuNgay.DateTime = current;
deSearchDenNgay.DateTime = nextMonth.AddDays(-1);
_listDM = FuncCategory.loadDMHNXH();
lueLoaiTapHuan.Properties.DataSource = _listDM;
lueLoaiTapHuan.EditValue = _id_loai;
_changeLayout((CategoryHNXH)_id_loai);
FormStatus = EnumFormStatus.VIEW;
}
private void ucUser_Load(object sender, EventArgs e)
{
initData();
base.registerButtonArray(btnControl);
repLueFucnName.DataSource = FuncCategory.loadFunctionName();
FormStatus = EnumFormStatus.VIEW;
}
private void frmNhaTaiTro_V2_Load(object sender, EventArgs e)
{
lueCaNhanToChuc.Properties.DataSource = FuncCategory.loadDMCaNhanToChuc();
FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_NHA_TAI_TRO_LOAI, lueLoaiNhaTaiTro);
seSoTien.Ex_FormatCustomSpinEdit();
FormStatus = EnumFormStatus.VIEW;
}
private void ucBCHoiVienTongNKTTheoTrinhDoHocVan_Load(object sender, EventArgs e)
{
registerButtonArray(btnControl);
FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_TINH, lueThanhPho);
LibraryDev.PermissionButton(btnControl, previewBar1);
lueThanhPho.Properties.PopupFormMinSize = lueThanhPho.Size;
_loadData();
}
private void _loadData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOATDONG_TAPHUAN.Load();
var listDMHoiThao = FuncCategory.loadDMTapHuan();
var data = (from p in context.QL_HOATDONG_TAPHUAN
where deTuNgay.DateTime.Date <= p.TH_THOIGIAN_BATDAU &&
p.TH_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date
select p).ToList();
List <clsTongKetHoatDong> lists = new List <clsTongKetHoatDong>();
foreach (QL_HOATDONG_TAPHUAN row in data)
{
clsTongKetHoatDong item = new clsTongKetHoatDong();
item.HD_ID = row.TH_ID;
item.HD_TEN = row.TH_TEN;
item.HD_THOIGIAN_BATDAU = row.TH_THOIGIAN_BATDAU;
item.HD_THOIGIAN_KETTHUC = row.TH_THOIGIAN_KETTHUC;
//item.HD_DIADIEM = row.TH_DIADIEM;
//item.HD_TONGTIEN = row.TH_TONGTIEN??0;
//item.HD_SONGUOI_THAMGIA = row.TH_SOLUONG??0;
item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.TH_THOIGIAN_BATDAU, row.TH_THOIGIAN_KETTHUC);
var dm = listDMHoiThao.Where(p => p.ID == row.TH_LOAI_ID).First();
if (dm != null)
{
item.HD_LOAI_STT = dm.STT;
item.HD_LOAI = dm.NAME;
}
item.HD_NOIDUNG = row.TH_NOIDUNG;
lists.Add(item);
}
rptBCTongKetHoatDong_NangCaoNangLucVaVanDongChinhSach rpt = new rptBCTongKetHoatDong_NangCaoNangLucVaVanDongChinhSach();
string tableName = "TongKetHoatDong";
DataTable dataPrint = FunctionHelper.ConvertToDataTable(lists);
dataPrint.TableName = tableName;
rpt.pLeftHeader.Value = clsParameter.pHospital;
rpt.pParentLeftHeader.Value = clsParameter.pParentHospital;
rpt.pTuNgayDenNgay.Value = FunctionHelper.formatFromDateToDate(deTuNgay.DateTime, deDenNgay.DateTime);
//rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM10);
//rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM10);
rpt.DataSource = dataPrint;
rpt.DataMember = tableName;
printControl.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument(true);
rptGlobal = rpt;
_wait.Close();
}
private void btnControl_btnEventView_Click(object sender, EventArgs e)
{
List <clsBCHoatDongTheoDieuKien> listData = new List <clsBCHoatDongTheoDieuKien>();
if (deTuNgay.EditValue == null || deDenNgay.EditValue == null)
{
clsMessage.MessageWarning("Vui lòng nhập điều kiện tìm kiếm");
return;
}
else if (deTuNgay.DateTime.Date > deDenNgay.DateTime.Date)
{
clsMessage.MessageWarning("Thời gian tìm kiếm không phù hợp");
return;
}
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
QL_HOIVIEN_KTEntities context = new QL_HOIVIEN_KTEntities();
List <QL_HOIVIEN> listHoiVien = context.QL_HOIVIEN.ToList();
string hoiVienId = lueSearchHoiVien.EditValue + string.Empty;
//Tập huấn
var listDayNgheData = (from p in context.QL_HOATDONG_TAPHUAN
let diadiem = p.QL_HOATDONG_TAPHUAN_DIADIEM.FirstOrDefault()
where deTuNgay.DateTime.Date <= p.TH_THOIGIAN_BATDAU &&
p.TH_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date &&
p.TH_DOITUONG_HV_ID.Contains(hoiVienId)
select new clsBCHoatDongTheoDieuKien
{
HD_LOAI_ID = p.TH_LOAI_ID,
HD_THOIGIAN_BATDAU = p.TH_THOIGIAN_BATDAU,
HD_THOIGIAN_KETTHUC = p.TH_THOIGIAN_KETTHUC,
HD_TEN = p.TH_TEN,
HD_DIADIEM = diadiem.TH_DD_TEN,
HD_DONVI_PHUTRACH = p.TH_DONVI_PHUTRACH,
HD_DONVI_TAITRO = p.NTT_TEN,
}
).ToList();
listData.AddRange(listDayNgheData);
listData = listData.OrderBy(p => p.HD_LOAI).OrderBy(p => p.HD_THOIGIAN_BATDAU).ToList();
List <dynamicObject> listDm = FuncCategory.loadDMTapHuan();
foreach (var item in listData)
{
var rowCategory = listDm.Where(p => p.ID == item.HD_LOAI_ID).FirstOrDefault();
item.HD_LOAI = rowCategory != null ? rowCategory.NAME : "";
item.HD_NGAY = item.HD_THOIGIAN_BATDAU.Value.Date.ToString("dd/MM/yyyy") + " - " + item.HD_THOIGIAN_KETTHUC.Value.Date.ToString("dd/MM/yyyy");
}
gcGrid.DataSource = listData;
_wait.Close();
}
private void frmNhaTaiTro_Load(object sender, EventArgs e)
{
FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_GIOITINH, lueGioiTinh);
FunctionHelper.dateFormat(deNgayCap_Nam, deNgayCap_Thang, deNgayCap_Ngay);
seThuLao_1.Ex_FormatCustomSpinEdit();
seThuLao_2.Ex_FormatCustomSpinEdit();
seThuLao_3.Ex_FormatCustomSpinEdit();
seThuLao_4.Ex_FormatCustomSpinEdit();
string tinhTrangKT_Value = lueDangTat.EditValue + string.Empty;
lueDangTat.Ex_SetDataSource(CategoryEntitiesTable.DM_KHUYETTAT_TINHTRANG.Ex_ToString());
lueDangTat.EditValue = tinhTrangKT_Value;
lueDangTat.RefreshEditValue();
FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_DOITUONG2, lueDoiTuong);
_changeLayout((CategoryTapHuanChiTietLoai)_loai_id);
FormStatus = EnumFormStatus.VIEW;
}
private void ucBaoCaoHoiVienTheoDieuKien_Load(object sender, EventArgs e)
{
btnControl_btnEventView_Click(null, null);
foreach (var item in grpDisplayColumn.Controls)
{
CheckEdit chk = item as CheckEdit;
if (item != null)
{
chk.Checked = true;
chk.CheckedChanged += new System.EventHandler(this.DisplayColumn_CheckedChanged);
}
}
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_GIOITINH, repLueGioiTinh);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_DANTOC, repLueDanToc);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TONGIAO, repLueTonGiao);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_NGHE_NGHIEP, repLueNgheNghiep);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TRINH_DO_HOC_VAN, repLueTrinhDoVanHoa);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TRINH_DO_CHUYEN_MON, repLueTrinhDoChuyenMon);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_CHUCVU_HOI, repLueChucVu);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_XA, repLueThuongTru_Phuong);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_HUYEN, repLueThuongTru_Quan);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TINH, repLueThuongTru_ThanhPho);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_XA, repLueTamTru_Phuong);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_HUYEN, repLueTamTru_Quan);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TINH, repLueTamTru_ThanhPho);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_KHUYETTAT_MUCDO, repLueMucDo);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_KHUYETTAT_TINHTRANG, repLueKTTinhTrang);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_KHUYETTAT_NGUYENNHAN, repLueKTNguyenNhan);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_PHUONGTIEN_DILAI, repLuePhuongTienDiLai);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_TINHTRANG_HONNHAN, repLueHonNhan);
FuncCategory.loadCategoryForRepositoryItemLookUpEditByName(CategoryEntitiesTable.DM_DOITUONG, repLueDoiTuong);
}
private void frmHoatDongDayNgheDoiTuongKhac_Load(object sender, EventArgs e)
{
FuncCategory.loadCategoryByName(CategoryEntitiesTable.DM_GIOITINH, lueGioiTinh);
FunctionHelper.dateFormat(deNgayCap_Nam, deNgayCap_Thang, deNgayCap_Ngay);
FormStatus = EnumFormStatus.VIEW;
}
private void lueQuan_EditValueChanged(object sender, EventArgs e)
{
FuncCategory.loadDMXa(luePhuong, lueQuan.EditValue + string.Empty);
luePhuong.EditValue = null;
}
private void lueThanhPho_EditValueChanged(object sender, EventArgs e)
{
FuncCategory.loadDMHuyen(lueQuan, lueThanhPho.EditValue + string.Empty);
}
private void _loadData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOATDONG_DAYNGHE.Load();
//Dạy nghề
var data = (from p in context.QL_HOATDONG_DAYNGHE
where deTuNgay.DateTime.Date <= p.DN_THOIGIAN_BATDAU &&
p.DN_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date
select p).ToList();
List <clsTongKetHoatDong> lists = new List <clsTongKetHoatDong>();
foreach (QL_HOATDONG_DAYNGHE row in data)
{
clsTongKetHoatDong item = new clsTongKetHoatDong();
item.HD_ID = row.DN_ID;
item.HD_TEN = row.DN_NGHE;
item.HD_THOIGIAN_BATDAU = row.DN_THOIGIAN_BATDAU;
item.HD_THOIGIAN_KETTHUC = row.DN_THOIGIAN_KETTHUC;
item.HD_DIADIEM = row.DN_DIADIEM;
item.HD_SONGUOI_THAMGIA = row.DN_SOLUONG_NU ?? 0;
item.HD_SONGUOI_NU_TONGSO = string.Format("{0}/{1}", row.DN_SOLUONG_NU, row.DN_SOLUONG);
item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.DN_THOIGIAN_BATDAU, row.DN_THOIGIAN_KETTHUC);
item.HD_LOAI_STT = 1;
item.HD_LOAI = "Việc làm";
item.HD_NOIDUNG = row.DN_NOIDUNG;
lists.Add(item);
}
//Giai quyet viẹc lam
context.QL_HOATDONG_VIECLAM.Load();
var listDMViecLam = FuncCategory.loadDMViecLam();
var dataViecLam = (from p in context.QL_HOATDONG_VIECLAM
where deTuNgay.DateTime.Date <= p.VL_THOIGIAN_BATDAU &&
p.VL_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date
select p).ToList();
foreach (QL_HOATDONG_VIECLAM row in dataViecLam)
{
clsTongKetHoatDong item = new clsTongKetHoatDong();
item.HD_ID = row.VL_ID;
item.HD_TEN = row.VL_TEN;
item.HD_THOIGIAN_BATDAU = row.VL_THOIGIAN_BATDAU;
item.HD_THOIGIAN_KETTHUC = row.VL_THOIGIAN_KETTHUC;
item.HD_DIADIEM = row.VL_DIADIEM;
item.HD_SONGUOI_THAMGIA = row.VL_SOLUONG_NU ?? 0;
item.HD_SONGUOI_NU_TONGSO = string.Format("{0}/{1}", row.VL_SOLUONG_NU, row.VL_SOLUONG);
item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.VL_THOIGIAN_BATDAU, row.VL_THOIGIAN_KETTHUC);
var dm = listDMViecLam.Where(p => p.ID == row.VL_LOAI_ID).FirstOrDefault();
if (dm != null)
{
item.HD_LOAI_STT = 2;
item.HD_LOAI = dm.NAME;
}
item.HD_NOIDUNG = row.VL_NOIDUNG;
lists.Add(item);
}
//vay vốn
context.QL_HOATDONG_VIECLAM.Load();
var dataVayVon = (from p in context.QL_HOATDONG_VAYVON
where deTuNgay.DateTime.Date <= p.VV_THOIGIAN_BATDAU &&
p.VV_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date
select p).ToList();
foreach (QL_HOATDONG_VAYVON row in dataVayVon)
{
clsTongKetHoatDong item = new clsTongKetHoatDong();
item.HD_ID = row.VV_ID;
item.HD_TEN = row.VV_TEN;
item.HD_THOIGIAN_BATDAU = row.VV_THOIGIAN_BATDAU;
item.HD_THOIGIAN_KETTHUC = row.VV_THOIGIAN_KETTHUC;
item.HD_DIADIEM = row.VV_DIADIEM;
item.HD_SONGUOI_THAMGIA = row.VV_SOLUONG_NU ?? 0;
item.HD_SONGUOI_NU_TONGSO = string.Format("{0}/{1}", row.VV_SOLUONG_NU, row.VV_SOLUONG);
item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.VV_THOIGIAN_BATDAU, row.VV_THOIGIAN_KETTHUC);
item.HD_LOAI_STT = 3;
item.HD_LOAI = "Vay vốn nhỏ tự mưu sinh";
item.HD_NOIDUNG = row.VV_NOIDUNG;
lists.Add(item);
}
//hội trợ triễn lãm
context.QL_HOATDONG_HOICHO_TRIENLAM.Load();
var dataHoiCho = (from p in context.QL_HOATDONG_HOICHO_TRIENLAM
where deTuNgay.DateTime.Date <= p.HC_THOIGIAN_BATDAU &&
p.HC_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date
select p).ToList();
foreach (QL_HOATDONG_HOICHO_TRIENLAM row in dataHoiCho)
{
clsTongKetHoatDong item = new clsTongKetHoatDong();
item.HD_ID = row.HC_ID;
item.HD_TEN = row.HC_TEN;
item.HD_THOIGIAN_BATDAU = row.HC_THOIGIAN_BATDAU;
item.HD_THOIGIAN_KETTHUC = row.HC_THOIGIAN_KETTHUC;
item.HD_DIADIEM = row.HC_DIADIEM;
item.HD_SONGUOI_THAMGIA = row.HC_SOLUONG_NU ?? 0;
item.HD_SONGUOI_NU_TONGSO = string.Format("{0}/{1}", row.HC_SOLUONG_NU, row.HC_SOLUONG);
item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.HC_THOIGIAN_BATDAU, row.HC_THOIGIAN_KETTHUC);
item.HD_LOAI_STT = 4;
item.HD_LOAI = "Hội chợ triễn lãm, thi tay nghề";
item.HD_NOIDUNG = row.HC_NOIDUNG;
lists.Add(item);
}
rptBCTongKetHoatDong_ViecLam rpt = new rptBCTongKetHoatDong_ViecLam();
string tableName = "TongKetHoatDong";
DataTable dataPrint = FunctionHelper.ConvertToDataTable(lists);
dataPrint.TableName = tableName;
rpt.pLeftHeader.Value = clsParameter.pHospital;
rpt.pParentLeftHeader.Value = clsParameter.pParentHospital;
rpt.pTuNgayDenNgay.Value = FunctionHelper.formatFromDateToDate(deTuNgay.DateTime, deDenNgay.DateTime);
//rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM10);
//rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM10);
rpt.DataSource = dataPrint;
rpt.DataMember = tableName;
printControl.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument(true);
rptGlobal = rpt;
_wait.Close();
}
protected override bool SaveData()
{
if (_validateControl())
{
WaitDialogForm _wait = new WaitDialogForm("Đang lưu dữ liệu ...", "Vui lòng đợi giây lát");
using (var _context = new QL_HOIVIEN_KTEntities())
{
QL_USERS item;
switch (_formStatus)
{
case EnumFormStatus.ADD:
item = new QL_USERS();
_setObjectEntities(ref item);
_context.QL_USERS.Add(item);
var listFunc = FuncCategory.loadFunctionName();
foreach (var func in listFunc)
{
QL_USERS_PERMISSION per = new QL_USERS_PERMISSION();
per.PER_NAME = Convert.ToInt32(func.ID);
per.PER_VIEW = true;
per.PER_ADD = false;
per.PER_MODIFY = false;
per.PER_DELETE = false;
per.PER_PRINT = false;
per.QL_USERS = item;
_context.QL_USERS_PERMISSION.Add(per);
}
break;
case EnumFormStatus.MODIFY:
Int64 userId = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colUSER_ID));
item = (from p in _context.QL_USERS where p.USER_ID == userId select p).FirstOrDefault <QL_USERS>();
if (item != null)
{
_setObjectEntities(ref item);
}
var entity = _context.QL_USERS.Find(userId);
_context.Entry(entity).CurrentValues.SetValues(item);
gvChucNang.PostEditor();
gvChucNang.UpdateCurrentRow();
context.SaveChanges();
break;
case EnumFormStatus.DELETE:
Int64 deleteId = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colUSER_ID));
var entitiesPermission = (from p in _context.QL_USERS_PERMISSION where p.USER_ID == deleteId select p);
foreach (var per in entitiesPermission)
{
_context.QL_USERS_PERMISSION.Remove(per);
}
QL_USERS entities = (from p in _context.QL_USERS where p.USER_ID == deleteId select p).FirstOrDefault();
_context.QL_USERS.Remove(entities);
break;
default:
break;
}
_context.SaveChanges();
}
FormStatus = EnumFormStatus.VIEW;
_wait.Close();
}
return(base.SaveData());
}
