protected void cbDonViList_OnRefreshData(object sender, StoreRefreshDataEventArgs e) { try { var dvList = new DonViController().GetDonViByUserIdParentChildren(); cbStoreDonViList.DataSource = dvList; cbStoreDonViList.DataBind(); } catch (Exception ex) { X.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show(); } }
private void LoadDonViForComboBox() { var dvList = new DonViController().GetDonViByUserIdParentChildren(); var store = cbDonViList.GetStore(); store.DataSource = dvList; store.DataBind(); var store2 = cbDonVi.GetStore(); store2.DataSource = dvList; store2.DataBind(); }
public void AddDinhBien(bool allDepartments, List <string> departmentCodeList, List <string> workCodeList, DateTime day, bool includeTV, int userId, DateTime createDate) { var hosoController = new HoSoController(); if (departmentCodeList.Count() < 1) { departmentCodeList = new DonViController().GetAllDepartments(); } if (workCodeList.Count() < 1) { workCodeList = new DM_CONGVIECController().GetAllTenCongViec(); } foreach (var department in departmentCodeList) { foreach (var work in workCodeList) { //if (dataContext.DM_CONGVIECs.Any(t => t.MA_CONGVIEC.ToLower() == work.ToLower() && t.MA_DONVI.ToLower() == department.ToLower())) //{ IEnumerable <string> tmpList = dataContext.HOSOs.Where(t => t.MA_DONVI.ToLower() == department.ToLower() && t.MA_CONGVIEC.ToLower() == work.ToLower()).Select(t => t.MA_CHUCVU).Distinct(); foreach (var maChucVu in tmpList) { if (dataContext.DinhBienNhanSus.Any(t => t.MaDonVi.ToLower() == department.ToLower() && t.MaCongViec.ToLower() == work.ToLower() && t.MaChucVu.ToLower() == maChucVu.ToLower() && t.TinhDenNgay == day)) { break; } var dbns = new DinhBienNhanSu(); dbns.MaDonVi = department; dbns.MaCongViec = work; dbns.MaChucVu = maChucVu; dbns.Nam = day.Year; dbns.TinhDenNgay = day; dbns.CreatedBy = userId; dbns.CreatedDate = createDate; dbns.SoLuongNhanSu = hosoController.CountByDVAndDayAndTypeStaff(department, work, maChucVu, day, includeTV); dataContext.DinhBienNhanSus.InsertOnSubmit(dbns); } //} } } Save(); }