public List <BHDONGBAOHIEMTHANGInfo> GetBHDONGBAOHIEMTHANG(string madonvi, int idbangluong, bool locquanlyBH, int start, int limit, string searkey, out int count) { string[] s1 = new DM_DONVIController().GetAllMaDonVi(madonvi).Split(','); string[] s2 = dataContext.BHNHANVIEN_BAOHIEMs.Select(p => p.MaNhanVien).ToArray(); List <BHDONGBAOHIEMTHANGInfo> rs = (from p in dataContext.DanhSachBangLuongs.Where(p => p.ID == idbangluong) join q in dataContext.BangThanhToanLuongs on p.ID equals q.IdBangLuong join h in dataContext.HOSOs on q.MaCB equals h.MA_CB where (madonvi != "" ? s1.Contains(h.MA_DONVI) : 1 == 1) && (string.IsNullOrEmpty(searkey) ? 1 == 1 : System.Data.Linq.SqlClient.SqlMethods.Like(h.HO_TEN, searkey) || System.Data.Linq.SqlClient.SqlMethods.Like(h.MA_CB, searkey)) && (!locquanlyBH || s2.Contains(h.MA_CB)) orderby h.TEN_CB, h.HO_TEN select new BHDONGBAOHIEMTHANGInfo { ID = q.ID, SoTienDVBHTN = q.DVBHTN, SoTienDVBHXH = q.DVBHXH, SoTienDVBHYT = q.DVBHYT, SoTienNVBHTN = q.GiamTruBHTN, SoTienNVBHXH = q.GiamTruBHXH, SoTienNVBHYT = q.GiamTruBHYT, HoTen = h.HO_TEN, MaNhanVien = h.MA_CB, LuongDongBH = q.LuongBaoHiem, TongTienDongBHNV = q.GiamTruBHTN + q.GiamTruBHXH + q.GiamTruBHYT, TongTienDongBHDV = q.DVBHTN + q.DVBHXH + q.DVBHYT, TongCong = q.GiamTruBHTN + q.GiamTruBHXH + q.GiamTruBHYT + q.DVBHTN + q.DVBHXH + q.DVBHYT }).ToList(); count = rs.Count; return(rs.Skip(start).Take(limit).ToList()); }
public List <BHNHANVIEN_BAOHIEMInfo> GetHoSoInfoByMaDonVi(string madonvi, string maphong, string mato, int start, int limit, out int count, string searchkey, bool IsDaNghi) { DM_DONVI dv = new DM_DONVIController().GetById(madonvi); List <BHNHANVIEN_BAOHIEMInfo> rs1 = (from t in dataContext.BHNHANVIEN_BAOHIEMs join q in dataContext.HOSOs on t.MaNhanVien equals q.MA_CB where (string.IsNullOrEmpty(madonvi) ? 1 == 1 : t.MaDonVi == madonvi) && (string.IsNullOrEmpty(searchkey) ? 1 == 1 : (System.Data.Linq.SqlClient.SqlMethods.Like(t.HoTen, searchkey) || System.Data.Linq.SqlClient.SqlMethods.Like(t.MaNhanVien, searchkey) || System.Data.Linq.SqlClient.SqlMethods.Like(t.SoSoBHXH, searchkey) || System.Data.Linq.SqlClient.SqlMethods.Like(t.SoTheBHYT, searchkey))) orderby t.Ten, t.HoTen select new BHNHANVIEN_BAOHIEMInfo { MaNhanVien = t.MaNhanVien, HoTen = t.HoTen, NgaySinh = t.NgaySinh, GioiTinh = t.GioiTinh, SoCMTND = t.SoCMTND, DiaChiLienHe = t.DiaChiLienHe } ).ToList(); count = rs1.Count(); return(rs1.Skip(start).Take(limit).ToList()); }
private void LoadDonVi() { List <StoreComboObject> dvList = new DM_DONVIController().GetStoreByParentID(Session["MaDonVi"].ToString()); Ext.Net.TreeNode root = new Ext.Net.TreeNode(); foreach (var item in dvList) { string actionNode = string.Empty; Ext.Net.TreeNode node = new Ext.Net.TreeNode(item.TEN); node.Icon = Ext.Net.Icon.House; root.Nodes.Add(node); node.Expanded = true; node.NodeID = item.MA; node.Checked = ThreeStateBool.False; hdfStringAllMaDonVi.Text += item.MA + ","; actionNode += LoadChildDepartment(item.MA, node); if (actionNode != "") { node.Listeners.CheckChange.Handler = "TreePanelDonVi.getNodeById('" + actionNode.Remove(actionNode.LastIndexOf(',')).Trim().Replace(",", "').getUI().checkbox.checked = (TreePanelDonVi.getNodeById('" + item.MA + "').getUI().checkbox.checked == true ? true : false);TreePanelDonVi.getNodeById('") + "').getUI().checkbox.checked = (TreePanelDonVi.getNodeById('" + item.MA + "').getUI().checkbox.checked == true ? true : false);"; } } TreePanelDonVi.Listeners.CheckChange.Handler = @"#{ddfDonVi}.setValue(getTasks(this), false); txtTenBangPhanCa.setValue('Bảng phân ca trong năm ' + txtYear.getValue() + ' tại ' + ddfDonVi.getText().replace('[', '').replace(']', '')); GetSelectedNodeDonVi(TreePanelDonVi,hdfStringAllMaDonVi,hdfStringMaDonVi)"; TreePanelDonVi.Root.Clear(); TreePanelDonVi.Root.Add(root); }
/// <summary> /// Lấy những nhân viên đã nghỉ mà vẫn còn lưu trữ trong bảng quản lý ngày phép /// </summary> /// <param name="start"></param> /// <param name="limit"></param> /// <param name="maDonVi"></param> /// <param name="notifyToDeleteAgain">1 = true, 0 = false, -1 = all</param> /// <param name="count"></param> /// <returns></returns> public IEnumerable <HoSoInfo> GetNhanVienDaNghi(int start, int limit, string maDonVi, int notifyToDeleteAgain, out int count) { System.Collections.Generic.List <string> idList = new DM_DONVIController().getChildID(maDonVi, true); string str = "%,"; foreach (var item in idList) { str += item + ","; } str += "%"; var rs = from t in dataContext.DanhSachNgayPheps join dv in dataContext.DM_DONVIs on t.HOSO.MA_DONVI equals dv.MA_DONVI where t.HOSO.DA_NGHI == true && System.Data.Linq.SqlClient.SqlMethods.Like("%" + str + "%", "%," + dv.MA_DONVI + ",%") && ((t.NotifyToDeleteAgain == true && notifyToDeleteAgain == 1) || (t.NotifyToDeleteAgain == false && notifyToDeleteAgain == 0) || notifyToDeleteAgain == -1) select new HoSoInfo { HOTEN = t.HOSO.HO_TEN, MACB = t.HOSO.MA_CB, PRKEY = t.PrKeyHoSo, NGAYSINH = t.HOSO.NGAY_SINH, PHONGBAN = dv.TEN_DONVI, NGAYNGHI = t.HOSO.NGAY_NGHI, }; count = rs.Count(); return(rs.Skip(start).Take(limit)); }
private void LoadDonVi(Ext.Net.TreePanel TreeCoCauToChuc, int currentUserID) { //List<DM_DONVI> dvList = new UserController().GetDonViByUserID(currentUserID); List <DM_DONVI> dvList = new DM_DONVIController().GetByParentID("0"); Ext.Net.TreeNode root = new Ext.Net.TreeNode(); foreach (DM_DONVI dv in dvList) { Ext.Net.TreeNode node = new Ext.Net.TreeNode(dv.TEN_DONVI); node.Icon = Ext.Net.Icon.House; root.Nodes.Add(node); node.Expanded = true; node.NodeID = dv.MA_DONVI; if ((!departmentList.Contains("," + dv.MA_DONVI + ",") && !string.IsNullOrEmpty(departmentList)) || string.IsNullOrEmpty(departmentList)) { node.Disabled = true; } LoadChildDepartment(dv.MA_DONVI, node); if (!string.IsNullOrEmpty(script)) { node.Listeners.Click.Handler = script.Replace(nodeID, node.NodeID).Replace(noteText, node.Text); } } TreeCoCauToChuc.Root.Clear(); TreeCoCauToChuc.Root.Add(root); }
public void ucChooseEmployee1_AfterClickAcceptButton(object sender, EventArgs e) { try { hdfTotalRecord.Text = ucChooseEmployee1.SelectedRow.Count.ToString(); foreach (var item in ucChooseEmployee1.SelectedRow) { // get employee information HOSO hs = new HoSoController().GetByMaCB(item.RecordID); string pr_keyhoso = hs.PR_KEY.ToString(); string ma_cb = hs.MA_CB; string ho_ten = hs.HO_TEN; string ten_donvi = new DM_DONVIController().GetNameById(hs.MA_DONVI); string ten_chucvu = ""; if (hs.DM_CHUCVU != null) { ten_chucvu = hs.DM_CHUCVU.TEN_CHUCVU; } string ten_congviec = ""; if (hs.DM_CONGVIEC != null) { ten_congviec = hs.DM_CONGVIEC.TEN_CONGVIEC; } // insert record to grid RM.RegisterClientScriptBlock("insert" + pr_keyhoso, string.Format("addRecord('{0}', '{1}', '{2}', '{3}', '{4}', '{5}');", pr_keyhoso, ma_cb, ho_ten, ten_donvi, ten_chucvu, ten_congviec)); } } catch (Exception ex) { X.Msg.Alert("Thông báo từ hệ thống", "Có lỗi xảy ra: " + ex.Message).Show(); } }
public void stDonVi_OnRefreshData(object sender, StoreRefreshDataEventArgs e) { List <StoreComboObject> lists = new DM_DONVIController().GetStoreByParentID(DepartmentRoleController.DONVI_GOC); if (dsDv == null || dsDv.Count() == 0) { dsDv = new DepartmentRoleController().GetMaBoPhanByRole(CurrentUser.ID, MenuID).Split(','); } List <object> obj = new List <object>(); foreach (var info in lists) { if (dsDv.Contains(info.MA)) { obj.Add(new { MA = info.MA, TEN = info.TEN }); } else { obj.Add(new { MA = countRole.ToString(), TEN = info.TEN }); countRole--; } obj = LoadChildMenu(obj, info.MA, 1); } stDonVi.DataSource = obj; stDonVi.DataBind(); }
protected void grpDepartmentStore_OnRefreshData(object sender, StoreRefreshDataEventArgs e) { try { if (string.IsNullOrEmpty(hdfRecordID.Text)) { return; } string departmentList = "," + new DepartmentRoleController().GetMaDonViByRole(int.Parse("0" + hdfRecordID.Text), int.Parse("0" + cbMenuList.SelectedItem.Value)) + ","; List <StoreComboObject> lists = new DM_DONVIController().GetStoreByParentID("0");//(Session["MaDonVi"].ToString()); List <object> obj = new List <object>(); foreach (var info in lists) { obj.Add(new { MA = info.MA, TEN = "<b>" + info.TEN + "</b>", Check = departmentList.Contains("," + info.MA + ",") }); obj = LoadMenuCon(obj, info.MA, 1, departmentList); } grpDepartmentStore.DataSource = obj; grpDepartmentStore.DataBind(); } catch (Exception ex) { X.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show(); } }
private void LoadDonVi() { string[] dsdv = new DepartmentRoleController().GetMaBoPhanByRole(CurrentUser.ID, MenuID).Split(','); List <StoreComboObject> dvList = new DM_DONVIController().GetStoreByParentID(Session["MaDonVi"].ToString()); Ext.Net.TreeNode root = new Ext.Net.TreeNode(); foreach (var item in dvList) { string actionNode = string.Empty; Ext.Net.TreeNode node = new Ext.Net.TreeNode(item.TEN); node.Icon = Ext.Net.Icon.House; root.Nodes.Add(node); node.Expanded = true; if (dsdv.Contains(item.MA)) { node.Disabled = false; } node.NodeID = item.MA; node.Checked = ThreeStateBool.False; hdfStringAllMaDonVi.Text += item.MA + ","; actionNode += LoadChildDepartment(item.MA, node); if (actionNode != "") { node.Listeners.CheckChange.Handler = "TreePanelDonVi.getNodeById('" + actionNode.Remove(actionNode.LastIndexOf(',')).Trim().Replace(",", "').getUI().checkbox.checked = (TreePanelDonVi.getNodeById('" + item.MA + "').getUI().checkbox.checked == true ? true : false);TreePanelDonVi.getNodeById('") + "').getUI().checkbox.checked = (TreePanelDonVi.getNodeById('" + item.MA + "').getUI().checkbox.checked == true ? true : false);"; } } TreePanelDonVi.Listeners.CheckChange.Handler = @"#{ddfDonVi}.setValue(getTasks(this), false);"; TreePanelDonVi.Root.Clear(); TreePanelDonVi.Root.Add(root); }
private string LoadChildDepartment(string maDonVi, Ext.Net.TreeNode DvNode) { string[] dsdv = new DepartmentRoleController().GetMaBoPhanByRole(CurrentUser.ID, MenuID).Split(','); List <StoreComboObject> childList = new DM_DONVIController().GetStoreByParentID(maDonVi); string dsChild = ""; foreach (var dv in childList) { string tmp = ""; Ext.Net.TreeNode node = new Ext.Net.TreeNode(dv.TEN); node.Icon = Ext.Net.Icon.Folder; DvNode.Nodes.Add(node); node.Expanded = true; node.NodeID = dv.MA; if (dsdv.Contains(dv.MA)) { node.Disabled = false; } node.Checked = ThreeStateBool.False; hdfStringAllMaDonVi.Text += dv.MA + ","; tmp += LoadChildDepartment(dv.MA, node); if (tmp != "") { node.Listeners.CheckChange.Handler = "TreePanelDonVi.getNodeById('" + tmp.Remove(tmp.LastIndexOf(',')).Trim().Replace(",", "').getUI().checkbox.checked = (TreePanelDonVi.getNodeById('" + dv.MA + "').getUI().checkbox.checked == true ? true : false);TreePanelDonVi.getNodeById('") + "').getUI().checkbox.checked = (TreePanelDonVi.getNodeById('" + dv.MA + "').getUI().checkbox.checked == true ? true : false);"; } tmp += dv.MA + ","; dsChild += tmp; } return(dsChild); }
public string NodeLoad(string nodeID) { try { Ext.Net.TreeNodeCollection nodes = new Ext.Net.TreeNodeCollection(); List <DAL.DM_DONVI> list = new DM_DONVIController().GetByAll(txtSearch.Text, nodeID); foreach (var item in list) { AsyncTreeNode asyncNode = new AsyncTreeNode(); asyncNode.Text = item.TEN_DONVI; asyncNode.NodeID = item.MA_DONVI; asyncNode.Icon = Icon.House; asyncNode.CustomAttributes.Add(new ConfigItem("MA_DONVI", item.MA_DONVI, ParameterMode.Value)); asyncNode.CustomAttributes.Add(new ConfigItem("TEN_DONVI", item.TEN_DONVI, ParameterMode.Value)); asyncNode.CustomAttributes.Add(new ConfigItem("TEN_TAT", item.TEN_TAT, ParameterMode.Value)); asyncNode.CustomAttributes.Add(new ConfigItem("TEN_DONVI_EN", item.TEN_DONVI_EN, ParameterMode.Value)); asyncNode.CustomAttributes.Add(new ConfigItem("DIA_CHI", item.DIA_CHI, ParameterMode.Value)); asyncNode.Expanded = true; nodes.Add(asyncNode); } return(nodes.ToJson()); } catch (Exception ex) { Dialog.ShowError(ex.Message.ToString()); return(null); } }
/// <summary> /// Lấy danh sách cán bộ theo một chuỗi mã đơn vị, cách nhau bằng dấu , /// </summary> /// <param name="maDonVi"></param> /// <param name="start"></param> /// <param name="limit"></param> /// <param name="count"></param> /// <param name="searchKey"></param> /// <param name="IsDaNghi"></param> /// <returns></returns> public List <DM_CBInfo> GetHOSOInfoByMaDonVi(string maDonVi, int start, int limit, out int count, string searchKey, bool IsDaNghi) { //lấy các chuỗi ID System.Collections.Generic.List <string> idList = new DM_DONVIController().getChildID(maDonVi, true); string str = "%,"; foreach (var item in idList) { str += item + ","; } str += "%"; List <DM_CBInfo> rs = (from t in dataContext.HOSOs join dv in dataContext.DM_DONVIs on t.MA_DONVI equals dv.MA_DONVI where (System.Data.Linq.SqlClient.SqlMethods.Like("%" + str + "%", "%," + t.MA_DONVI + ",%")) && (string.IsNullOrEmpty(searchKey) || System.Data.Linq.SqlClient.SqlMethods.Like(t.HO_TEN, searchKey)) && (t.DA_NGHI == IsDaNghi || (t.DA_NGHI.HasValue == false && IsDaNghi == false)) select new DM_CBInfo { MA_CB = t.MA_CB, HO_TEN = t.HO_TEN, NGAY_SINH = t.NGAY_SINH, GIOI_TINH = t.MA_GIOITINH == "F" ? "Nữ" : "Nam", DIA_CHI = t.DIA_CHI_LH, TEN_LOAI_HDONG = t.DM_LOAI_HDONG.TEN_LOAI_HDONG, TEN_TRINHDO = t.DM_TRINHDO.TEN_TRINHDO, DIENTHOAI = t.DI_DONG, DonViCongTac = dv.TEN_DONVI }).ToList(); count = rs.Count(); return(rs.Skip(start).Take(limit).ToList()); }
public void DeleteNode(string maDV) { try { DM_DONVIController ctr = new DM_DONVIController(); // xóa tất cả các con rồi xóa cha List <DAL.DM_DONVI> dv = ctr.GetByParentID(maDV); foreach (var item in dv) { if (item.PARENT_ID == "0") { break; } if (!string.IsNullOrEmpty(item.MA_DONVI)) { DeleteNode(item.MA_DONVI); } } ctr.Delete(maDV); tgDonVi.ReloadAsyncNode("0", new JFunction()); } catch (SqlException sqlEx) { if (sqlEx.Number == ErrorNumber.DATA_IS_INUSED_IN_OTHER_TABLE) { X.Msg.Alert("Có lỗi xảy ra", "Không thể xóa được do có dữ liệu khác tham chiếu tới !").Show(); } } catch (Exception ex) { Dialog.ShowNotification(ex.Message); } }
public IEnumerable <DanhSachCanBoThoiViecInfo> GetAll(int start, int limit, string maDonVi, string searchKey, int tinhTrang, int daTraThe, int daTraSo, int hoanTatCongNo, int banGiaoTaiSan, int userID, int menuID, out int count) { // get role string[] departmentList = new DepartmentRoleController().GetMaBoPhanByRole(userID, menuID).Split(','); string[] dsDonVi = new DM_DONVIController().GetAllMaDonVi(maDonVi).Split(','); var rs = from t in dataContext.DanhSachCanBoThoiViecs let isHoanTatCongNo = (from ts in dataContext.BangTamUngs where ts.PrKeyHoSo == t.PrKeyHoSo && ts.SoTienDaTra < ts.SoTien select ts).ToList().Count > 0 ? 0 : 1 let isBanGiaoTaiSan = (from ts in dataContext.HOSO_TAISANs where ts.FR_KEY == t.PrKeyHoSo && (ts.NgayBanGiao == null || ts.NgayBanGiao.ToString().Contains("1900") || ts.NgayBanGiao.ToString().Contains("0001")) select ts).ToList().Count > 0 ? 0 : 1 join lydoNghi in dataContext.DM_LYDO_NGHIs on t.MaLyDoNghi equals lydoNghi.MA_LYDO_NGHI into j1 from j2 in j1.DefaultIfEmpty() where (dsDonVi.Contains(t.HOSO.MA_DONVI) || maDonVi == "") && (System.Data.Linq.SqlClient.SqlMethods.Like(t.HOSO.HO_TEN, searchKey) || string.IsNullOrEmpty(searchKey) || System.Data.Linq.SqlClient.SqlMethods.Like(t.HOSO.MA_CB, searchKey)) && (t.DaHoanThanhThuTuc == (tinhTrang == 1 ? true : false) || tinhTrang == -1) && (t.DaTraTheBHYT == (daTraThe == 1 ? true : false) || daTraThe == -1) && (t.DaTraSoBHXH == (daTraSo == 1 ? true : false) || daTraSo == -1) && (hoanTatCongNo == -1 || hoanTatCongNo == isHoanTatCongNo) && (banGiaoTaiSan == -1 || banGiaoTaiSan == isBanGiaoTaiSan) && (departmentList.Count() == 0 || departmentList.Contains(t.HOSO.MA_DONVI)) select new DanhSachCanBoThoiViecInfo { DaHoanThanhThuTuc = t.DaHoanThanhThuTuc, ID = t.ID, FrKeyHoSo = t.PrKeyHoSo, DaTraSoBHXH = t.DaTraSoBHXH, DaTraTheBHYT = t.DaTraTheBHYT, HoTen = t.HOSO.HO_TEN, LyDoNghi = j2.TEN_LYDO_NGHI, MaCB = t.HOSO.MA_CB, NgayHoanThanhThuTuc = t.NgayHoanThanhThuTuc, NgayTraSoBHXH = t.NgayTraSo, NgayTraTheBHYT = t.NgayTraThe, HoanTatCongNo = isHoanTatCongNo == 1 ? true : false, BanGiaoTaiSan = isBanGiaoTaiSan == 1 ? true : false, PhongBan = (from tp in dataContext.HOSOs join p in dataContext.DM_DONVIs on tp.MA_DONVI equals p.MA_DONVI where tp.PR_KEY == t.PrKeyHoSo select p.TEN_DONVI).FirstOrDefault(), NgayNghi = t.NgayNghi, IsBelongToBlackList = t.IsBelongToBlackList, DiaChiLienHe = t.HOSO.DIA_CHI_LH, Email = t.HOSO.EMAIL, DiDong = t.HOSO.DI_DONG, ChucVu = t.HOSO.DM_CHUCVU.TEN_CHUCVU, ViTriCongViec = t.HOSO.DM_CONGVIEC.TEN_CONGVIEC, NgaySinh = t.HOSO.NGAY_SINH, GioiTinh = t.HOSO.MA_GIOITINH, NgayLamChinhThuc = t.HOSO.NGAY_TUYEN_CHINHTHUC, NgayThuViec = t.HOSO.NGAY_TUYEN_DTIEN, CanBoDuyetNghi = t.HOSO1.HO_TEN, Photo = t.HOSO.PHOTO, SoQuyetDinh = t.SoQuyetDinh, AttachFile = string.IsNullOrEmpty(t.AttachFile) ? "" : t.AttachFile, GhiChu = t.GhiChu, }; count = rs.Count(); return(rs.Skip(start).Take(limit)); }
public List <BHQUYDINHBIENDONG> GetQuyDinhBienDongByMaDonVi(string MaDonVi, out int count) { DM_DONVI dv = new DM_DONVIController().GetById(MaDonVi); List <BHQUYDINHBIENDONG> rs = (from t in dataContext.BHQUYDINHBIENDONGs where t.MaDonVi.Equals(MaDonVi) select t).ToList(); count = rs.Count(); return(rs); }
public List <DAL.BHMUCDONGBAOHIEM> GetMucDongBaoHiemByMaDonVi(string MaDonVi, out int count) { DM_DONVI dv = new DM_DONVIController().GetById(MaDonVi); List <BHMUCDONGBAOHIEM> rs = (from t in dataContext.BHMUCDONGBAOHIEMs where t.MaDonVi.Equals(MaDonVi) select t).ToList(); count = rs.Count(); return(rs); }
public List <DAL.BHBANGTINHCHEDOBAOHIEM> GetAll(string MaDonVi, out int count) { DM_DONVI dv = new DM_DONVIController().GetById(MaDonVi); List <BHBANGTINHCHEDOBAOHIEM> rs = (from t in dataContext.BHBANGTINHCHEDOBAOHIEMs where t.MaDonVi.Equals(MaDonVi) select t).ToList(); count = rs.Count(); return(rs); }
/// <summary> /// get department list to display on html tree /// </summary> private void LoadDepartment() { List <DonViInfo> childList = new DM_DONVIController().GetEntityByParentID("0"); string s = ""; foreach (var item in childList) { s += string.Format("<li id='{0}' item-expanded='true'>{1}{2}</li>", item.MaDonVi, item.TenDonVi, BindChildDepartment(item.MaDonVi)); } ldlMenuTree.Text = s; }
private string GetChildMaBoPhan(string oldStr, string parentID) { List <StoreComboObject> lists = new DM_DONVIController().GetStoreByParentID(parentID); foreach (var item in lists) { oldStr += item.MA + ","; oldStr = GetChildMaBoPhan(oldStr, item.MA); } return(oldStr); }
public List <DanhSachBienDongInfo> GetDanhSachBienDong(string madonvi, int start, int limit, string searchkey, DateTime tungay, DateTime denngay, out int count) { string[] ds = new DM_DONVIController().GetAllMaDonVi(madonvi).Split(','); List <DanhSachBienDongInfo> result = (from t in dataContext.BHNHANVIEN_BAOHIEMs join q in dataContext.HOSOs on t.MaNhanVien equals q.MA_CB join x in dataContext.BHBIENDONGBAOHIEMs on t.IDNhanVien_BaoHiem equals x.IDNhanVien_BaoHiem where ds.Contains(q.MA_DONVI) && (string.IsNullOrEmpty(searchkey) ? 1 == 1 : (System.Data.Linq.SqlClient.SqlMethods.Like(t.HoTen, searchkey) || System.Data.Linq.SqlClient.SqlMethods.Like(t.MaNhanVien, searchkey))) && x.ThangDangKy >= tungay && x.ThangDangKy <= denngay select new DanhSachBienDongInfo { IDBienDongBaoHiem = x.IDBienDongBaoHiem, IDQuyDinhBienDong = x.IDQuyDinhBienDong, IDNhanVien_BaoHiem = x.IDNhanVien_BaoHiem, MaCanBo = x.MaNhanVien, HoTen = x.HoTen, Ten = x.HoTen, MaSo = t.SoSoBHXH, GioiTinh = !(bool)x.GioiTinh, NgaySinh = x.NgaySinh, Loai = x.Loai, TuNgay = x.TuNgay, DenNgay = x.DenNgay, ThangDangKy = x.ThangDangKy, SoNgay = ((TimeSpan)(x.DenNgay.Value - x.TuNgay)).Days, TienLuongCu = x.TienLuongCu, TongPhuCapCu = x.PhuCapCVCu + x.PhuCapNgheCu + x.PhuCapTNVKCu, TienLuongMoi = x.TienLuongMoi, TongPhuCapMoi = x.PhuCapCVMoi + x.PhuCapTNNgheMoi + x.PhuCapTNVKMoi, KhongTraThe = x.KhongTraThe, DaCoSo = x.DaCoSo, DienGiai = x.DienGiai, }).ToList(); foreach (var item in result) { switch (item.Loai) { case "TLD": item.TrangThai = "1.Tăng lao động"; break; case "GLD": item.TrangThai = "3.Giảm lao động"; break; case "TMD": item.TrangThai = "2.Tăng mức đóng"; break; case "GMD": item.TrangThai = "4.Giảm mức đóng"; break; } } result = (from t in result orderby t.TrangThai, t.Ten, t.HoTen select t).ToList(); count = result.Count; return(result.Skip(start).Take(limit).ToList()); }
//protected void cbb_MaCa_Store_OnRefreshData(object sender, StoreRefreshDataEventArgs e) //{ // int count = 0; // List<DanhSachCaInfo> lists = new DanhSachCaController().MiniGetAll(0, 1000, "", "CN1", out count); // List<object> obj = new List<object>(); // foreach (var item in lists) // { // obj.Add(new { Ma = item.MaCa, Ten = item.TenCa }); // } // cbb_MaCa_Store.DataSource = obj; // cbb_MaCa_Store.DataBind(); //} protected void cbx_bophan_Store_OnRefreshData(object sender, StoreRefreshDataEventArgs e) { List <StoreComboObject> lists = new DM_DONVIController().GetStoreByParentID(DepartmentRoleController.DONVI_GOC); List <object> obj = new List <object>(); foreach (var info in lists) { obj.Add(new { MA = info.MA, TEN = info.TEN }); obj = LoadChildMenu(obj, info.MA, 1); } cbx_bophan_Store.DataSource = obj; cbx_bophan_Store.DataBind(); }
protected void cbxDonViCapCha_Store_OnRefreshData(object sender, StoreRefreshDataEventArgs e) { List <DAL.DM_DONVI> lists = new DM_DONVIController().GetByParentID("0"); List <object> obj = new List <object>(); obj.Add(new { MA_DONVI = "0", TEN_DONVI = "Đơn vị cấp cao nhất" }); foreach (var info in lists) { obj.Add(new { MA_DONVI = info.MA_DONVI, TEN_DONVI = info.TEN_DONVI }); obj = LoadMenuCon(obj, info.MA_DONVI, 1); } cbxDonViCapCha_Store.DataSource = obj; cbxDonViCapCha_Store.DataBind(); }
/// <summary> /// Lấy tổng số bản ghi theo trạng thái /// </summary> /// <param name="filterStatus"></param> /// <param name="maDonVi"></param> /// <returns></returns> public int GetCount(string filterStatus, string maDonVi) { System.Collections.Generic.List <string> idList = new DM_DONVIController().getChildID(maDonVi, true); string str = "%,"; foreach (var item in idList) { str += item + ","; } str += "%"; return((from t in dataContext.HOSO_TUCAPNHATs where (t.TrangThaiDuyet == filterStatus || string.IsNullOrEmpty(filterStatus)) && System.Data.Linq.SqlClient.SqlMethods.Like("%" + str + "%", "%," + t.MA_DONVI + ",%") select t.PR_KEY).Count()); }
private void LoadChildDepartment(string maDonVi, Ext.Net.TreeNode DvNode) { List <DM_DONVI> childList = new DM_DONVIController().GetByParentID(maDonVi); foreach (DM_DONVI dv in childList) { var node = new Ext.Net.TreeNode(dv.TEN_DONVI); node.Icon = Ext.Net.Icon.Folder; DvNode.Nodes.Add(node); node.Expanded = true; node.NodeID = dv.MA_DONVI; node.Listeners.Click.Handler = "#{hdfMaPhong}.setValue('" + node.NodeID + "');hdfMaDonVi.setValue('');txtSearchKey.reset();PagingToolbar1.pageIndex = 0; PagingToolbar1.doLoad();Store1.reload();"; LoadChildDepartment(dv.MA_DONVI, node); } }
private List <object> LoadMenuCon(List <object> obj, string parentID, int k) { List <DAL.DM_DONVI> lists = new DM_DONVIController().GetByParentID(parentID); foreach (var item in lists) { string tmp = ""; for (int i = 0; i < k; i++) { tmp += "-- "; } obj.Add(new { MA_DONVI = item.MA_DONVI, TEN_DONVI = tmp + item.TEN_DONVI }); obj = LoadMenuCon(obj, item.MA_DONVI, k + 1); } return(obj); }
private List <object> LoadChildMenu(List <object> obj, string parentID, int k) { List <StoreComboObject> lists = new DM_DONVIController().GetStoreByParentID(parentID); foreach (var item in lists) { string tmp = ""; for (int i = 0; i < k; i++) { tmp += "----"; } obj.Add(new { MA = item.MA, TEN = tmp + item.TEN }); obj = LoadChildMenu(obj, item.MA, k + 1); } return(obj); }
private void LoadChildDepartment(string maDonVi, Ext.Net.TreeNode DvNode) { List <DM_DONVI> childList = new DM_DONVIController().GetByParentID(maDonVi); foreach (DM_DONVI dv in childList) { Ext.Net.TreeNode node = new Ext.Net.TreeNode(dv.TEN_DONVI); node.Icon = Ext.Net.Icon.Folder; DvNode.Nodes.Add(node); node.Expanded = true; node.NodeID = dv.MA_DONVI; node.Checked = ThreeStateBool.False; //node.Listeners.Click.Handler = "txtTenBangTinhLuong.setValue('Bảng tính lương tháng '+cbChonThang.getValue()+' năm '+spinChonNam.getValue() + ' tại bộ phận ' + Field3.getValue());"; LoadChildDepartment(dv.MA_DONVI, node); } }
/// <summary> /// Thêm nhân viên vào bảng quản lý ngày phép /// </summary> /// <param name="maDonVi"></param> /// <param name="thamNien">thâm niên được tính theo tháng</param> /// <param name="hinhThucLamViec"></param> /// <param name="maLoaiHopDong"></param> /// <param name="soNgayPhepDuocThem"></param> /// <param name="soNgayPhepNamNay"></param> /// <param name="tuDongTinhNgayPhep"></param> /// <param name="timNgayPhepNamTruoc"></param> public void AddAllEmployee(string maCBlist, string maDonVi, int thamNien, int hinhThucLamViec, string maLoaiHopDong, float soNgayPhepDuocThem, float soNgayPhepNamNay, int year, int createdBy, bool tuDongTinhNgayPhep, bool timNgayPhepNamTruoc, bool ghiDeThongTinMoi, DateTime?HanNPNamTruoc) { //lấy các chuỗi ID System.Collections.Generic.List <string> idList = new DM_DONVIController().getChildID(maDonVi, true); string str = ","; foreach (var item in idList) { str += item + ","; } string[] param = { "@maCBList", "@maDonVi", "@thamNien", "@maLoaiHopDong", "@hinhThucLamViec", "@soNgayPhepNamNay", "@soNgayPhepDuocThem", "@Year", "@createdBy", "@TimNapNgayPhepNamTruoc", "@TuDongTimNgayPhepNamNay", "@GhiDeThongTinMoi", "@HanNPNamTruoc" }; DataController.DataHandler.GetInstance().ExecuteNonQuery("ChamCong_ThemNhanVienVaoBangQuanLyNgayPhep", param, maCBlist, str, thamNien, maLoaiHopDong, hinhThucLamViec, soNgayPhepNamNay, soNgayPhepDuocThem, year, createdBy, timNgayPhepNamTruoc, tuDongTinhNgayPhep, ghiDeThongTinMoi, HanNPNamTruoc); }
/// <summary> /// Get data for filling to the grid /// </summary> /// <param name="maPhong"></param> /// <param name="maTo"></param> /// <param name="maDonVi"></param> /// <param name="start"></param> /// <param name="limit"></param> /// <param name="searchKey"></param> /// <param name="count"></param> /// <returns></returns> public IEnumerable <HosoLuongInfo> GetAll(string maDonVi, int start, int limit, string searchKey, out int count, string trangThai, int userID, int menuID) { string dsDonVi = new DepartmentRoleController().GetMaBoPhanByRole(userID, menuID); string[] dvList = new DM_DONVIController().GetAllMaDonVi(maDonVi).Split(','); string[] ds = dsDonVi.Split(','); var rs = from t in dataContext.HOSO_LUONGs join hs in dataContext.HOSOs on t.PrKeyHoSo equals hs.PR_KEY where ds.Contains(hs.MA_DONVI) && //System.Data.Linq.SqlClient.SqlMethods.Like("%" + str + "%", "%," + t.HOSO1.MA_DONVI + ",%") && (string.IsNullOrEmpty(maDonVi) || dvList.Contains(hs.MA_DONVI)) && (string.IsNullOrEmpty(trangThai) || System.Data.Linq.SqlClient.SqlMethods.Like(t.TrangThai, "%" + trangThai + "%")) && (string.IsNullOrEmpty(searchKey) || System.Data.Linq.SqlClient.SqlMethods.Like(hs.HO_TEN, "%" + searchKey + "%") || System.Data.Linq.SqlClient.SqlMethods.Like(hs.MA_CB, "%" + searchKey + "%")) select new HosoLuongInfo { BacLuong = t.BacLuong, BacLuongNB = t.BacLuongNB, GhiChu = t.GhiChu, GioiTinh = hs.MA_GIOITINH, HeSoLuong = t.HeSoLuong, HoTen = hs.HO_TEN, TenBoPhan = (from p in dataContext.DM_DONVIs where p.MA_DONVI == hs.MA_DONVI select p).FirstOrDefault().TEN_DONVI, ID = t.ID, LoaiLuong = t.DM_LOAI_LUONG.TEN_LOAI_LUONG, LuongCung = t.LuongCung, LuongDongBHXH = t.LuongDongBHXH, LuongTrachNhiem = t.LuongTrachNhiem, MaCB = hs.MA_CB, NgayHieuLuc = t.NgayHieuLuc, NgayHuongLuong = t.NgayHuongLuong, NgayHuongLuongNB = t.NgayHuongLuongNB, NgayKetThucHieuLuc = t.NgayKetThucHieuLuc, NgayQuyetDinh = t.NgayQuyetDinh, NgaySinh = hs.NGAY_SINH, NguoiQuyetDinh = t.HOSO.HO_TEN, IdNguoiQuyetDinhPhuCap = t.HOSO.PR_KEY, PhanTramHuongLuong = t.PhanTramHuongLuong, SoQuyetDinh = t.SoQuyetDinh, TrangThai = t.TrangThai, TepTinDinhKem = t.TepTinDinhKem, HasPhuCap = t.HOSO_PHUCAPs.Count() > 0 }; count = rs.Count(); return(rs.OrderByDescending(p => p.NgayHieuLuc).Skip(start).Take(limit)); }
/// <summary> /// Lấy bảng phân ca năm theo ID danh sách bảng phân ca /// </summary> /// <param name="start"></param> /// <param name="limit"></param> /// <param name="count"></param> /// <param name="searchKey"></param> /// <param name="maBangPhanCa"></param> /// <param name="maDonVi">phục vụ cho mục đích filter</param> /// <returns></returns> public IEnumerable <BangPhanCaNamInfo> GetAll(int start, int limit, out int count, string searchKey, int maBangPhanCa, string maDonVi) { string str = string.Empty; if (!string.IsNullOrEmpty(maDonVi)) { System.Collections.Generic.List <string> idList = new DM_DONVIController().getChildID(maDonVi, true); str = "%,"; foreach (var item in idList) { str += item + ","; } str += "%"; } var rs = from t in dataContext.BangPhanCaNams join hs in dataContext.HOSOs on t.MaCB equals hs.MA_CB join dv in dataContext.DM_DONVIs on hs.MA_DONVI equals dv.MA_DONVI where t.IdDanhSachBangPhanCa == maBangPhanCa && (string.IsNullOrEmpty(maDonVi) || System.Data.Linq.SqlClient.SqlMethods.Like("%" + str + "%", "%," + hs.MA_DONVI + ",%")) && (string.IsNullOrEmpty(searchKey) || System.Data.Linq.SqlClient.SqlMethods.Like(hs.HO_TEN, searchKey) || System.Data.Linq.SqlClient.SqlMethods.Like(t.MaCB, searchKey)) select new BangPhanCaNamInfo { HoTen = hs.HO_TEN, MaCB = t.MaCB, BoPhan = dv.TEN_DONVI, Thang1 = t.Thang1, Thang2 = t.Thang2, Thang3 = t.Thang3, Thang4 = t.Thang4, Thang5 = t.Thang5, Thang6 = t.Thang6, Thang7 = t.Thang7, Thang8 = t.Thang8, Thang9 = t.Thang9, Thang10 = t.Thang10, Thang11 = t.Thang11, Thang12 = t.Thang12, ID = t.ID }; count = rs.Count(); return(rs.Skip(start).Take(limit)); }