Exemple #1
0
    private void LoadDMCongViec()
    {
        var source = new DM_CONGVIECController().GetAll();

        cbStoreCongViecList.DataSource = source;
        cbStoreCongViecList.DataBind();
    }
Exemple #2
0
 protected void btnOK_Click(object sender, DirectEventArgs e)
 {
     try
     {
         DataTable record = new DM_CONGVIECController().GetByPrkey(txtmaloaihdcoppy.Text);
         if (record.Rows.Count > 0)
         {
             Dialog.ShowNotification("Mã đã tồn tại");
         }
         else
         {
             record = new DM_CONGVIECController().GetByPrkey(hdfRecordID.Text);
             record.Rows[0]["MA_CONGVIEC"] = txtmaloaihdcoppy.Text;
             DM_CONGVIECInfo item = new DM_CONGVIECInfo()
             {
                 MA_CONGVIEC  = record.Rows[0]["MA_CONGVIEC"].ToString(),
                 TEN_CONGVIEC = record.Rows[0]["TEN_CONGVIEC"].ToString(),
                 USERNAME     = record.Rows[0]["USERNAME"].ToString(),
                 DATE_CREATE  = DateTime.Parse(record.Rows[0]["DATE_CREATE"].ToString()),
                 MA_DONVI     = record.Rows[0]["MA_DONVI"].ToString(),
             };
             new DM_CONGVIECController().Insert(item);
             //RM.RegisterClientScriptBlock("fd", string.Format("addRecord('{0}', '{1}', '{2}', '{3}', '{4}')", item.MA_CONGVIEC, item.TEN_CONGVIEC, item.USERNAME, item.DATE_CREATE, item.MA_DONVI));
             GridPanel1.Reload();
         }
         wdInputNewPrimaryKey.Hide();
     }
     catch (Exception ex)
     {
         Dialog.ShowError(ex.Message.ToString());
     }
 }
Exemple #3
0
    protected void btnEdit_Click(object sender, DirectEventArgs e)
    {
        DataTable record = new DM_CONGVIECController().GetByPrkey(hdfRecordID.Text);

        txtMA_CONGVIEC.Text     = record.Rows[0]["MA_CONGVIEC"].ToString();
        txtTEN_CONGVIEC.Text    = record.Rows[0]["TEN_CONGVIEC"].ToString();
        txtMA_CONGVIEC.Disabled = true;
        hdfCommand.Text         = "Update";
        wdAddWindow.Icon        = Icon.Pencil;
        wdAddWindow.Title       = "Sửa thông tin công việc";
        wdAddWindow.Show();
    }
Exemple #4
0
    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();
    }
Exemple #5
0
 protected void cbCongViecList_OnRefreshData(object sender, StoreRefreshDataEventArgs e)
 {
     try
     {
         var donViList = new List <string>();
         foreach (var dv in cbDonViList.SelectedItems)
         {
             donViList.Add(dv.Value);
         }
         var dvList = new DM_CONGVIECController().GetAllRecord(donViList);
         cbStoreCongViecList.DataSource = dvList;
         cbStoreCongViecList.DataBind();
     }
     catch (Exception ex)
     {
         X.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show();
     }
 }
Exemple #6
0
    /*[DirectMethod]
     * public void NhanDoiDuLieuTuTang()
     * {
     *  {NhanDoiDuLieuTuTangCode}
     * }*/

    public void mnuNhanDoiDuLieu_Click(object sender, DirectEventArgs e)
    {
        try
        {
            DataTable       record = new DM_CONGVIECController().GetByPrkey(hdfRecordID.Text);
            DM_CONGVIECInfo item   = new DM_CONGVIECInfo()
            {
                TEN_CONGVIEC = record.Rows[0]["TEN_CONGVIEC"].ToString(),
                USERNAME     = record.Rows[0]["USERNAME"].ToString(),
                DATE_CREATE  = DateTime.Parse(record.Rows[0]["DATE_CREATE"].ToString()),
                MA_DONVI     = record.Rows[0]["MA_DONVI"].ToString(),
            };
            item.MA_CONGVIEC = new DM_CONGVIECController().Insert(item);
            //RM.RegisterClientScriptBlock("fd", string.Format("addRecord('{0}', '{1}', '{2}', '{3}', '{4}')", item.MA_CONGVIEC, item.TEN_CONGVIEC, item.USERNAME, item.DATE_CREATE, item.MA_DONVI));
            GridPanel1.Reload();
        }
        catch (Exception ex)
        {
            Dialog.ShowError(ex.Message.ToString());
        }
    }
Exemple #7
0
    protected void btnCapNhat_Click(object sender, DirectEventArgs e)
    {
        DM_CONGVIECInfo       obj = new DM_CONGVIECInfo();
        DM_CONGVIECController ctr = new DM_CONGVIECController();

        obj.MA_CONGVIEC  = txtMA_CONGVIEC.Text;
        obj.TEN_CONGVIEC = txtTEN_CONGVIEC.Text;
        obj.USERNAME     = CurrentUser.ID.ToString();
        obj.DATE_CREATE  = DateTime.Now;
        obj.MA_DONVI     = Session["MaDonVi"].ToString();
        if (e.ExtraParams["Command"] == "Edit")
        {
            obj.MA_CONGVIEC = hdfRecordID.Text;
            ctr.Update(obj);
            wdAddWindow.Hide();
            //RM.RegisterClientScriptBlock("fd", string.Format("addUpdatedRecord('{0}', '{1}', '{2}', '{3}', '{4}')", txtMA_CONGVIEC.Text, txtTEN_CONGVIEC.Text, txtUSERNAME.Text, txtDATE_CREATE.Text, txtMA_DONVI.Text));
            GridPanel1.Reload();
        }
        else
        {
            DataTable record = new DM_CONGVIECController().GetByPrkey(obj.MA_CONGVIEC);
            if (record.Rows.Count > 0)
            {
                Dialog.ShowNotification("Mã đã tồn tại");
                return;
            }
            ctr.Insert(obj);
            if (e.ExtraParams["Close"] == "True")
            {
                wdAddWindow.Hide();
            }
            //RM.RegisterClientScriptBlock("fd", string.Format("addRecord('{0}', '{1}', '{2}', '{3}', '{4}')", txtMA_CONGVIEC.Text, txtTEN_CONGVIEC.Text, txtUSERNAME.Text, txtDATE_CREATE.Text, txtMA_DONVI.Text));
            GridPanel1.Reload();
        }
        txtMA_CONGVIEC.Reset();
        txtTEN_CONGVIEC.Reset();
    }
    public void CreateDictionary()
    {
        List <StoreComboObject> list = new List <StoreComboObject>();

        dictionary = new Dictionary <string, string>();
        // lấy danh sách các bảng danh mục
        string[] dsDanhMuc = ListCategoriesTableName.Split(',');
        foreach (var it in dsDanhMuc)
        {
            switch (it.Trim())
            {
            case "DM_TT_HN":        // DM_TT_HN
                list = new DM_TT_HNController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TINHTHANH":        // DM_TinhThanh
                list = new DM_TINHTHANHController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_NUOC":         // DM_NUOC
                list = new DM_NUOCController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_DANTOC":       // DM_DANTOC
                list = new DM_DANTOCController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TONGIAO":      // DM_TONGIAO
                list = new DM_TONGIAOController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TT_SUCKHOE":       // DM_TT_SUCKHOE
                list = new DM_TT_SUCKHOEController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TRINHDO":      // DM_TRINHDO
                list = new DM_TRINHDOController().GetAll1();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TD_VANHOA":        // DM_TD_VANHOA
                list = new DM_TD_VANHOAController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_NGOAINGU":         // DM_NGOAINGU
                list = new DM_NGOAINGUController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TINHOC":       // DM_TINHOC
                list = new DM_TINHOCController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_CHUCVU":       // DM_CHUCVU
                list = new DanhMucChucVuController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_NGACH":        // DM_NGACH
                list = new DM_NGACHController().GetAll1();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_DONVI":        // DM_DONVI
                list = new DM_DONVIController().GetAll1();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_NOICAP_CMND":      // DM_NOICAP_CMND
                list = new DM_NOICAP_CMNDController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_LOAI_HDONG":       // DM_LOAI_HDONG
                list = new DM_LOAI_HDONGController().GetAll1();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_CONGVIEC":         // DM_CONGVIEC
                list = new DM_CONGVIECController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_CHUYENNGANH":      // DM_CHUYENNGANH
                list = new DM_CHUYENNGANHController().GetAll1();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TP_BANTHAN":       // DM_TP_BANTHAN
                list = new DM_TP_BANTHANController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TP_GIADINH":       // DM_TP_GIADINH
                list = new DM_TP_GIADINHController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_NOICAP_HOCHIEU":       // DM_NOICAP_HOCHIEU
                list = new DM_NOICAP_HOCHIEUController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TRUONG_DAOTAO":        // DM_TRUONG_DAOTAO
                list = new DM_TRUONG_DAOTAOController().GetAll1();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_XEPLOAI":      // DM_XEPLOAI
                list = new DM_XEPLOAIController().GetAll1();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_HT_TUYENDUNG":         // DM_HT_TUYENDUNG
                list = new DM_HT_TUYENDUNGController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_CONGTRINH":        // DM_CONGTRINH
                list = new DM_CONGTRINHController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_LOAI_CS":          // DM_LOAI_CS
                list = new DM_LOAI_CSController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_NOI_KCB":      // DM_NOI_KCB
                list = new DM_NOI_KCBController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_NOICAP_BHXH":      // DM_NOICAP_BHXH
                list = new DM_NOICAPBAOHIEMXHController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TD_CHINHTRI":      // DM_TD_CHINHTRI
                list = new DM_TD_CHINHTRIController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_CHUCVU_DANG":      // DM_CHUCVU_DANG
                list = new DM_CHUCVU_DANGController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_CHUCVU_DOAN":      // DM_CHUCVU_DOAN
                list = new DM_CHUCVU_DOANController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_BAC_QDOI":         // DM_BAC_QDOI
                list = new DM_CAPBAC_QDOIController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_CHUCVU_QDOI":      // DM_CHUCVU_QDOI
                list = new DM_CHUCVU_QDOIController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TD_QUANLY":        // DM_TD_QUANLY
                list = new DM_TD_QUANLYController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_TD_QLKT":      // DM_TD_QLKT
                list = new DM_TD_QLKTController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_NH":       // DM_NH
                list = new DM_NGANHANGController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;

            case "DM_LYDO_NGHI":        // DM_LYDO_NGHI
                list = new DM_LYDO_NGHIController().GetAll();
                foreach (var item in list)
                {
                    if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
                    {
                        dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
                    }
                }
                break;
            }
        }
    }
Exemple #9
0
    public void CreateDictionary()
    {
        List <StoreComboObject> list = new List <StoreComboObject>();

        dictionary = new Dictionary <string, string>();
        // DM_TT_HN
        list = new DM_TT_HNController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TinhThanh
        list = new DM_TINHTHANHController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_NUOC
        list = new DM_NUOCController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_DANTOC
        list = new DM_DANTOCController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TONGIAO
        list = new DM_TONGIAOController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TT_SUCKHOE
        list = new DM_TT_SUCKHOEController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TRINHDO
        list = new DM_TRINHDOController().GetAll1();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TD_VANHOA
        list = new DM_TD_VANHOAController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TD_NGOAINGU
        list = new DM_NGOAINGUController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TD_TINHOC
        list = new DM_TINHOCController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_CHUCVU
        list = new DanhMucChucVuController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_NGACH
        list = new DM_NGACHController().GetAll1();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_DONVI
        list = new DM_DONVIController().GetAll1();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_NOICAP_CMND
        list = new DM_NOICAP_CMNDController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_LOAI_HDONG
        list = new DM_LOAI_HDONGController().GetAll1();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_CONGVIEC
        list = new DM_CONGVIECController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_CHUYENNGANH
        list = new DM_CHUYENNGANHController().GetAll1();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TP_BANTHAN
        list = new DM_TP_BANTHANController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TP_GIADINH
        list = new DM_TP_GIADINHController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_NOICAP_HOCHIEU
        list = new DM_NOICAP_HOCHIEUController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TRUONG_DAOTAO
        list = new DM_TRUONG_DAOTAOController().GetAll1();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_XEPLOAI
        list = new DM_XEPLOAIController().GetAll1();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_HT_TUYENDUNG
        list = new DM_HT_TUYENDUNGController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_CONGTRINH
        list = new DM_CONGTRINHController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_LOAI_CS
        list = new DM_LOAI_CSController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_NOI_KCB
        list = new DM_NOI_KCBController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_NOICAP_BHXH
        list = new DM_NOICAPBAOHIEMXHController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TD_CHINHTRI
        list = new DM_TD_CHINHTRIController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_CHUCVU_DANG
        list = new DM_CHUCVU_DANGController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_CHUCVU_DOAN
        list = new DM_CHUCVU_DOANController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_BAC_QDOI
        list = new DM_CAPBAC_QDOIController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_CHUCVU_QDOI
        list = new DM_CHUCVU_QDOIController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TD_QUANLY
        list = new DM_TD_QUANLYController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_TD_QLKT
        list = new DM_TD_QLKTController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_NH
        list = new DM_NGANHANGController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // DM_LYDO_NGHI
        list = new DM_LYDO_NGHIController().GetAll();
        foreach (var item in list)
        {
            if (!dictionary.ContainsKey(item.TEN.ToLower().Trim()))
            {
                dictionary.Add(item.TEN.ToLower().Trim(), item.MA);
            }
        }
        // HinhThucLamViec
        //IEnumerable<DAL.ThamSoTrangThai> lt = new ThamSoTrangThaiController().GetByParamName("HinhThucLamViec", true);
        //foreach (var item in lt)
        //{
        //    if (!dictionary.ContainsKey(item.Value.ToLower().Trim()))
        //        dictionary.Add(item.Value.ToLower().Trim(), item.ID.ToString());
        //}
    }