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));
}
