private void load_2_cbo_don_vi_quan_ly() { try { DS_CM_DM_TU_DIEN v_ds_cm_tu_dien = new DS_CM_DM_TU_DIEN(); US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); //v_ds_cm_tu_dien.Clear(); //DataRow v_dr_all_dv_quan_ly = m_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); ////add item Tat Ca //v_dr_all_dv_quan_ly[CM_DM_TU_DIEN.ID] = 0; //v_dr_all_dv_quan_ly[CM_DM_TU_DIEN.TEN] = "Tất cả"; //v_ds_cm_tu_dien.EnforceConstraints = false; //v_ds_cm_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr_all_dv_quan_ly, 0); // Đổ dữ liệu vào DS v_us_cm_tu_dien.FillDataset(v_ds_cm_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.DON_VI_QUAN_LY_CHINH); // Đây là lấy theo điều kiện m_cbo_don_vi_quan_ly_search.Items.Add(new ListItem("Tất cả", "0")); for (int i = 0; i < v_ds_cm_tu_dien.CM_DM_TU_DIEN.Rows.Count; i++) { m_cbo_don_vi_quan_ly_search.Items.Add(new ListItem(v_ds_cm_tu_dien.CM_DM_TU_DIEN[i][CM_DM_TU_DIEN.TEN].ToString(), v_ds_cm_tu_dien.CM_DM_TU_DIEN[i][CM_DM_TU_DIEN.ID].ToString())); } //for (int i = 0; i < v_ds_cm_tu_dien.CM_DM_TU_DIEN.Rows.Count; i++) //{ // m_cbo_don_vi_q_ly.Items.Add(new ListItem(v_ds_cm_tu_dien.CM_DM_TU_DIEN[i][CM_DM_TU_DIEN.TEN].ToString(), v_ds_cm_tu_dien.CM_DM_TU_DIEN[i][CM_DM_TU_DIEN.ID].ToString())); //} } catch (Exception v_e) { throw v_e; } }
// // Region for search // private void load_2_cbo_trang_thai_giang_vien() { try { DS_CM_DM_TU_DIEN v_ds_cm_tu_dien = new DS_CM_DM_TU_DIEN(); US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); // DataRow v_dr_all = m_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); // Đổ dữ liệu vào DS v_us_cm_tu_dien.FillDataset(v_ds_cm_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.TRANG_THAI_GIANG_VIEN); // Đây là lấy theo điều kiện //m_cbo_trang_thai_g_vien.DataValueField = CM_DM_TU_DIEN.ID; //m_cbo_trang_thai_g_vien.DataTextField = CM_DM_TU_DIEN.TEN; //m_cbo_trang_thai_g_vien.DataSource = v_ds_cm_tu_dien.CM_DM_TU_DIEN; //m_cbo_trang_thai_g_vien.DataBind(); m_cbo_trang_thai_g_vien.Items.Add(new ListItem("Tất cả", "0")); for (int i = 0; i < v_ds_cm_tu_dien.CM_DM_TU_DIEN.Rows.Count; i++) { m_cbo_trang_thai_g_vien.Items.Add(new ListItem(v_ds_cm_tu_dien.CM_DM_TU_DIEN[i][CM_DM_TU_DIEN.TEN].ToString(), v_ds_cm_tu_dien.CM_DM_TU_DIEN[i][CM_DM_TU_DIEN.ID].ToString())); } } catch (Exception v_e) { throw v_e; } }
// Load loại giảng viên private void load_loai_giang_vien() { try { US_CM_DM_TU_DIEN v_cm_dm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN(); string m_str_loai_giang_vien = ""; US_DM_HO_SO_GIANG_VIEN v_us_gd_ho_so_gv = new US_DM_HO_SO_GIANG_VIEN(CIPConvert.ToDecimal(Request.QueryString["id_hs"])); if (!v_us_gd_ho_so_gv.IsIDNull()) { m_str_loai_giang_vien = get_mapping_loai_giang_vien(v_us_gd_ho_so_gv.dcID_GIANG_VIEN); if (m_str_loai_giang_vien == "NY" || m_str_loai_giang_vien == "YY") { m_lbl_loai_giang_vien.Text = "Giảng viên chuyên môn"; v_cm_dm_tu_dien.FillDataset(v_ds_cm_dm_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.LOAI_HO_SO_GV_CM); } else { m_lbl_loai_giang_vien.Text = "Giảng viên hướng dẫn"; v_cm_dm_tu_dien.FillDataset(v_ds_cm_dm_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.LOAI_HO_SO_GV_HD); } m_cbo_loai_ho_so.DataTextField = CM_DM_TU_DIEN.TEN; m_cbo_loai_ho_so.DataValueField = CM_DM_TU_DIEN.ID; m_cbo_loai_ho_so.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN; m_cbo_loai_ho_so.DataBind(); } } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(this, v_e); } }
private void load_data_2_cbo_don_vi_lien_quan() { US_CM_DM_TU_DIEN v_us_tu_dien_dv_lien_quan = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_dv_lien_quan = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_dv_lien_quan.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_dv_lien_quan); DataRow v_dr = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); v_dr[CM_DM_TU_DIEN.ID] = "0"; v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "- Tất cả -"; v_dr[CM_DM_TU_DIEN.TEN] = "- Tất cả -"; v_ds_tu_dien_dv_lien_quan.EnforceConstraints = false; v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_don_vi_lien_quan.DataSource = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN; m_cbo_don_vi_lien_quan.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_don_vi_lien_quan.ValueMember = CM_DM_TU_DIEN.ID; // Linhdh: 2014-05-22: Chọn trường liên quan đến câu hỏi trùng với trường sinh viên đang học if (m_cbo_truong.SelectedIndex != 0) { DataRow[] v_drs = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.Select(CM_DM_TU_DIEN.MA_TU_DIEN + "='" + m_cbo_truong.SelectedValue + "'"); decimal v_dc_id = 0; if (v_drs.Length > 0) { v_dc_id = CIPConvert.ToDecimal(v_drs[0][CM_DM_TU_DIEN.ID]); } m_cbo_don_vi_lien_quan.SelectedValue = v_dc_id; } }
public DialogResult UpdateObj(US_CM_DM_TU_DIEN i_objTuDien) { m_FormMode = IPConstants.DataEntryFormMode.UpdateDataState; m_USTuDien = i_objTuDien; this.ShowDialog(); return m_DialogResult; }
private void load_data_2_trang_thai_hop_dong() { try { DS_CM_DM_TU_DIEN v_ds_cm_tu_dien = new DS_CM_DM_TU_DIEN(); US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); //v_ds_cm_tu_dien.Clear(); //DataRow v_dr_all_trang_thai_hdong = m_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); ////add item Tat Ca //v_dr_all_trang_thai_hdong[CM_DM_TU_DIEN.ID] = 0; //v_dr_all_trang_thai_hdong[CM_DM_TU_DIEN.TEN] = "Tất cả"; //v_ds_cm_tu_dien.EnforceConstraints = false; //v_ds_cm_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr_all_trang_thai_hdong, 0); // Đổ dữ liệu vào DS v_us_cm_tu_dien.FillDataset(v_ds_cm_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.TRANG_THAI_HOP_DONG_KHUNG); // Đây là lấy theo điều kiện m_cbo_trang_thai_hop_dong_search.Items.Add(new ListItem("Tất cả", "0")); for (int i = 0; i < v_ds_cm_tu_dien.CM_DM_TU_DIEN.Rows.Count; i++) { m_cbo_trang_thai_hop_dong_search.Items.Add(new ListItem(v_ds_cm_tu_dien.CM_DM_TU_DIEN[i][CM_DM_TU_DIEN.TEN].ToString(), v_ds_cm_tu_dien.CM_DM_TU_DIEN[i][CM_DM_TU_DIEN.ID].ToString())); } //m_cbo_trang_thai_hop_dong_search.DataValueField = CM_DM_TU_DIEN.ID; //m_cbo_trang_thai_hop_dong_search.DataTextField = CM_DM_TU_DIEN.TEN; //m_cbo_trang_thai_hop_dong_search.DataSource = v_ds_cm_tu_dien.CM_DM_TU_DIEN; //m_cbo_trang_thai_hop_dong_search.DataBind(); } catch (Exception v_e) { throw v_e; } }
private void us_object_2_form(US_CM_DM_TU_DIEN i_us_dm_tu_dien) { m_cbo_loai_tu_dien.SelectedValue = CIPConvert.ToStr(i_us_dm_tu_dien.dcID_LOAI_TU_DIEN); m_txt_ma_tu_dien.Text = i_us_dm_tu_dien.strMA_TU_DIEN; m_txt_ten.Text = i_us_dm_tu_dien.strTEN; m_txt_ten_ngan.Text = i_us_dm_tu_dien.strTEN_NGAN; m_txt_ghi_chu.Text = i_us_dm_tu_dien.strGHI_CHU; }
private void grid2us_object(US_CM_DM_TU_DIEN i_us , int i_grid_row) { DataRow v_dr; v_dr = (DataRow)m_fg.Rows[i_grid_row].UserData; m_obj_trans.GridRow2DataRow(i_grid_row, v_dr); i_us.DataRow2Me(v_dr); }
private void load_data_2_cbo_chuc_nang() { US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN(); v_us.FillDatasetByIdLoaiTuDien(v_ds, 14); m_cbo_chuc_nang.DataSource = v_ds.Tables[0]; m_cbo_chuc_nang.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_chuc_nang.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN; }
public CDictionaryDesc(string strLoaiTuDien, System.Data.SqlClient.SqlTransaction i_trans = null) { US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN(); if (!(i_trans == null)) { v_us.SetTransaction(i_trans); } IP.Core.IPData.DS_CM_DM_TU_DIEN v_ds = v_us.getLoaiTuDienDS(strLoaiTuDien); m_list_of_desc = new CListOfDataFromDB(v_ds, "MA_TU_DIEN", "TEN_NGAN"); }
private void load_data_2_cbo_loai_hop_dong() { DS_CM_DM_TU_DIEN v_ds_cm_dm_td = new DS_CM_DM_TU_DIEN(); US_CM_DM_TU_DIEN v_us_cm_dm_td = new US_CM_DM_TU_DIEN(); v_us_cm_dm_td.FillDatasetByIdLoaiTuDien(v_ds_cm_dm_td, 6); m_cbo_loai_hop_dong.DataSource = v_ds_cm_dm_td.Tables[0]; m_cbo_loai_hop_dong.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN; m_cbo_loai_hop_dong.ValueMember = CM_DM_TU_DIEN.ID; }
private void load_data_2_cbo_don_vi_truong() { US_CM_DM_TU_DIEN v_us_tu_dien_trang_thai = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_trang_thai = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_trang_thai.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai); m_cbo_don_vi_truong.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN; m_cbo_don_vi_truong.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_don_vi_truong.ValueMember = CM_DM_TU_DIEN.ID; }
private void load_data_2_cbo_danh_gia_cau_tra_loi() { US_CM_DM_TU_DIEN v_us_tu_dien_danh_gia = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_danh_gia = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_danh_gia.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.HANG_DANH_GIA, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_danh_gia); m_cbo_danh_gia_tra_loi.DataSource = v_ds_tu_dien_danh_gia.CM_DM_TU_DIEN; m_cbo_danh_gia_tra_loi.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_danh_gia_tra_loi.ValueMember = CM_DM_TU_DIEN.ID; }
private void load_data_2_cbo_nhom_cau_hoi() { US_CM_DM_TU_DIEN v_us_tu_dien_trang_thai = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_trang_thai = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_trang_thai.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.NHOM_CAU_HOI, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai); m_cbo_nhom_cau_hoi.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN; m_cbo_nhom_cau_hoi.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_nhom_cau_hoi.ValueMember = CM_DM_TU_DIEN.ID; }
private void xuat_word() { if (m_us.dcID == -1) { BaseMessages.MsgBox_Infor("Phải lưu thông tin hợp đồng trước khi in."); return; } US_GD_HOP_DONG v_us_gd_hop_dong = new US_GD_HOP_DONG(m_us.dcID); US_DM_NHAN_SU v_us_dm_nhan_su = new US_DM_NHAN_SU(v_us_gd_hop_dong.dcID_NHAN_SU); US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(v_us_gd_hop_dong.dcID_LOAI_HOP_DONG); m_sfd_in_hop_dong.Filter = "(*.doc)|*.doc|(*.docx)|*.docx"; m_sfd_in_hop_dong.Title = "Lưu Hợp Đồng Lao Động"; DialogResult result = m_sfd_in_hop_dong.ShowDialog(); if (result == DialogResult.OK) { CWordReport v_obj_word = new CWordReport("THR_Hopdonglaodong_KTH_v2_TU.docx", m_sfd_in_hop_dong.FileName); v_obj_word.AddFindAndReplace("<HO_TEN>", v_us_dm_nhan_su.strHO_DEM + " " + v_us_dm_nhan_su.strTEN); if (v_us_dm_nhan_su.datNGAY_SINH > DateTime.Parse("1/1/1900") && v_us_dm_nhan_su.datNGAY_SINH != null) { v_obj_word.AddFindAndReplace("<NGAY_SINH>", v_us_dm_nhan_su.datNGAY_SINH.ToShortDateString()); } else { v_obj_word.AddFindAndReplace("<NGAY_SINH>", ""); } v_obj_word.AddFindAndReplace("<CHO_O>", v_us_dm_nhan_su.strCHO_O); v_obj_word.AddFindAndReplace("<CMTND>", v_us_dm_nhan_su.strCMND); v_obj_word.AddFindAndReplace("<NGAY_CAP>", v_us_dm_nhan_su.datNGAY_CAP_CMND.ToShortDateString()); v_obj_word.AddFindAndReplace("<NOI_CAP>", v_us_dm_nhan_su.strNOI_CAP_CMND); v_obj_word.AddFindAndReplace("<MOBILE>", v_us_dm_nhan_su.strDI_DONG); v_obj_word.AddFindAndReplace("<LOAI_HOP_DONG>", v_us_tu_dien.strTEN); v_obj_word.AddFindAndReplace("<NGAY_KY>", v_us_gd_hop_dong.datNGAY_KY_HOP_DONG.ToShortDateString()); v_obj_word.AddFindAndReplace("<CHUYEN_NGANH>", v_us_dm_nhan_su.strCHUYEN_NGANH); v_obj_word.AddFindAndReplace("<MA_PHONG>", "..."); v_obj_word.AddFindAndReplace("<MA_BAN>", "..."); v_obj_word.AddFindAndReplace("<MA_NHAN_VIEN>", v_us_dm_nhan_su.strMA_NV); if (v_us_gd_hop_dong.datNGAY_KY_HOP_DONG > DateTime.Parse("1/1/1900") && v_us_gd_hop_dong.datNGAY_KY_HOP_DONG != null) { v_obj_word.AddFindAndReplace("<NGAY>", v_us_gd_hop_dong.datNGAY_KY_HOP_DONG.Day.ToString()); v_obj_word.AddFindAndReplace("<THANG>", v_us_gd_hop_dong.datNGAY_KY_HOP_DONG.Month.ToString()); v_obj_word.AddFindAndReplace("<NAM>", v_us_gd_hop_dong.datNGAY_KY_HOP_DONG.Year.ToString()); } else { v_obj_word.AddFindAndReplace("<NGAY>", "..."); v_obj_word.AddFindAndReplace("<THANG>", "..."); v_obj_word.AddFindAndReplace("<NAM>", "..."); v_obj_word.Export2Word("", false); } } }
public string mapping_ma_to_ten(string ip_ma_tu_dien) { if (ip_ma_tu_dien == "") { return(""); } US_CM_DM_TU_DIEN v_us_cm_dm = new US_CM_DM_TU_DIEN("MA_TAN_SUAT", ip_ma_tu_dien); return(v_us_cm_dm.strTEN); }
private void load_cbo_truong_sinh_vien() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.ID, v_ds_tu_dien); m_cbo_sv_truong.DisplayMember = CM_DM_TU_DIEN.MA_TU_DIEN; m_cbo_sv_truong.ValueMember = CM_DM_TU_DIEN.TEN; m_cbo_sv_truong.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; }
private void load_ds_nguoi_dai_dien(int ip_i_cau_hoi_row) { if (!HelpUtils.is_validated_edit_grid_row(ip_i_cau_hoi_row, m_fg)) { return; } US_CM_DM_TU_DIEN v_us_dm = new US_CM_DM_TU_DIEN(); grid2us_object(v_us_dm, m_fg.Row); load_data_2_grid_nguoi_dai_dien(v_us_dm.dcID); }
private decimal get_id_trang_thai_chua_duyet() { US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = 15 AND MA_TU_DIEN LIKE N'%CHUNG_TU_KHONG_DUOC_DUYET%'"); if (v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0) { return(513); } return(CIPConvert.ToDecimal(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[0][CM_DM_TU_DIEN.ID])); }
private decimal get_id_trang_thai_dot_tt_da_lap_dot() { US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = 14 AND MA_TU_DIEN LIKE N'%DA_LAP_DOT%'"); if (v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0) { return(503); } return(CIPConvert.ToDecimal(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[0][CM_DM_TU_DIEN.ID])); }
private decimal get_id_trang_thai_ngan_hang_chuyen_khoan_thanh_cong() { US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = 15 AND MA_TU_DIEN LIKE N'%NGAN_HANG_CHUYEN_KHOAN_THANH_CONG%'"); if (v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0) { return(515); } return(CIPConvert.ToDecimal(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[0][CM_DM_TU_DIEN.ID])); }
private decimal get_id_trang_thai_da_len_bang_ke() { US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = 15 AND MA_TU_DIEN LIKE N'%DA_LEN_BANG_KE%'"); if (v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0) { return(511); } return(CIPConvert.ToDecimal(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[0][CM_DM_TU_DIEN.ID])); }
private void load_data_2_cbo_trang_thai_cv_gv() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.TRANG_THAI_CONG_VIEC_GV); m_cbo_trang_thai_cv_gv.Items.Add(new ListItem("Tất cả", "0")); for (int v_i = 0; v_i < v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count; v_i++) { m_cbo_trang_thai_cv_gv.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[v_i][CM_DM_TU_DIEN.TEN]), CIPConvert.ToStr(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[v_i][CM_DM_TU_DIEN.ID]))); } }
private void load_cbo_truong() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); string v_str_loai_tu_dien = LOAI_TU_DIEN_ID.TO_CHUC_TRUONG.ToString(); v_us_tu_dien.fill_tu_dien_by_procedure("pr_CM_DM_TU_DIEN_Load_tu_dien_by_procedure", v_str_loai_tu_dien, v_ds_tu_dien); m_cbo_qlht_truong.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_qlht_truong.ValueMember = CM_DM_TU_DIEN.MA_TU_DIEN; m_cbo_qlht_truong.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; }
private decimal get_id_trang_thai_ngan_hang_chuyen_khoan_khong_thanh_cong() { US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = 15 AND MA_TU_DIEN LIKE N'%NGAN_HANG_CHUYEN_KHOAN_KHONG_THANH_CONG%'"); // Nếu ko có giá trị phù hợp, ta dùng id_trang_thai hiện tại của cbo_trang_thai_thanh_toan if (v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0) { return(CIPConvert.ToDecimal(m_cbo_trang_thai_thanh_toan.SelectedValue)); } return(CIPConvert.ToDecimal(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[0][CM_DM_TU_DIEN.ID])); }
private decimal get_id_trang_thai_chung_tu_da_duoc_duyet() { US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = 15 AND MA_TU_DIEN LIKE N'%CHUNG_TU_DA_DUOC_DUYET%'"); // Nếu ko có giá trị phù hợp, ta dùng id_trang_thai hiện tại của cbo_trang_thai_thanh_toan if (v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0) { return(0); } return(CIPConvert.ToDecimal(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[0][CM_DM_TU_DIEN.ID])); }
private void load_data_2_cbo_truong() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); string v_str_loai_tu_dien = LOAI_TU_DIEN_ID.TO_CHUC_TRUONG.ToString(); v_us_tu_dien.fill_tu_dien_by_procedure("pr_CM_DM_TU_DIEN_Load_tu_dien_by_procedure", v_str_loai_tu_dien, v_ds_tu_dien); m_cbo_truong.DataTextField = CM_DM_TU_DIEN.MA_TU_DIEN; m_cbo_truong.DataValueField = CM_DM_TU_DIEN.TEN_NGAN; m_cbo_truong.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; m_cbo_truong.DataBind(); }
private decimal get_id_trang_thai_da_thanh_toan() { US_CM_DM_TU_DIEN v_us_cm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = 14 AND MA_TU_DIEN LIKE N'%DA_THANH_TOAN%'"); // Nếu ko có giá trị phù hợp, ta dùng id_trang_thai hiện tại của cbo_trang_thai_thanh_toan if (v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0) { return(CIPConvert.ToDecimal(m_cbo_trang_thai_thanh_toan.SelectedValue)); } return(CIPConvert.ToDecimal(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[0][CM_DM_TU_DIEN.ID])); }
private void load_data_2_cbo_trang_thai_cau_tra_loi() { US_CM_DM_TU_DIEN v_us_tu_dien_trang_thai = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_trang_thai = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_trang_thai.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_GD_CAU_HOI_SV, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai); v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.Rows.RemoveAt(1); m_cbo_trang_thai_cau_hoi.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN; m_cbo_trang_thai_cau_hoi.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_trang_thai_cau_hoi.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_trang_thai_cau_hoi.SelectedIndex = 1; }
private void load_2_cbo_trang_thai_sk() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.FillDataset(v_ds_tu_dien, "WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.TRANG_THAI_SU_KIEN_GV); m_cbo_trang_thai_sk.DataTextField = CM_DM_TU_DIEN.TEN; m_cbo_trang_thai_sk.DataValueField = CM_DM_TU_DIEN.ID; m_cbo_trang_thai_sk.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; m_cbo_trang_thai_sk.DataBind(); }
private void load_2_cbo_vai_tro_giang_vien() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.VAI_TRO_GV); m_cbo_vai_tro_gv.DataTextField = CM_DM_TU_DIEN.TEN; m_cbo_vai_tro_gv.DataValueField = CM_DM_TU_DIEN.ID; m_cbo_vai_tro_gv.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; m_cbo_vai_tro_gv.DataBind(); }
private void load_data_2_cbo_loai_su_kien() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.LOAI_SU_KIEN); m_cbo_loai_su_kien.DataTextField = CM_DM_TU_DIEN.TEN; m_cbo_loai_su_kien.DataValueField = CM_DM_TU_DIEN.ID; m_cbo_loai_su_kien.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; m_cbo_loai_su_kien.DataBind(); }
private void load_cbo_user_group() { try { US_CM_DM_TU_DIEN us_cm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN ds_cm_tu_dien = new DS_CM_DM_TU_DIEN(); us_cm_tu_dien.FillDataset(ds_cm_tu_dien, " WHERE ID_LOAI_TU_DIEN =7"); m_cbo_trang_thai.DataSource = ds_cm_tu_dien.CM_DM_TU_DIEN; m_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN_NGAN; m_cbo_trang_thai.DataValueField = CM_DM_LOAI_TD.ID; m_cbo_trang_thai.DataBind(); } catch (Exception v_e) { throw v_e; } }
public static void load_data_to_cbo_tu_dien( eLOAI_TU_DIEN ip_e_trang_thai_chuc_vu , eTAT_CA ip_e_tat_ca , ComboBox ip_obj_cbo_trang_thai) { US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN(); string v_str_loai_tu_dien = ""; switch (ip_e_trang_thai_chuc_vu) { case eLOAI_TU_DIEN.TRANG_THAI_CHUC_VU: v_str_loai_tu_dien = MA_LOAI_TU_DIEN.TRANG_THAI_CHUC_VU; break; case eLOAI_TU_DIEN.LOAI_HOP_DONG: v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_HOP_DONG; break; case eLOAI_TU_DIEN.LOAI_DON_VI: v_str_loai_tu_dien = MA_LOAI_TU_DIEN.LOAI_DON_VI; break; case eLOAI_TU_DIEN.CAP_DON_VI: v_str_loai_tu_dien = MA_LOAI_TU_DIEN.CAP_DON_VI; break; } v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds( v_str_loai_tu_dien , CM_DM_TU_DIEN.GHI_CHU , v_ds_dm_tu_dien); ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN; ip_obj_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN; ip_obj_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID; if (ip_e_tat_ca == eTAT_CA.YES) { DataRow v_dr = v_ds_dm_tu_dien.CM_DM_TU_DIEN.NewRow(); v_dr[CM_DM_TU_DIEN.ID] = -1; v_dr[CM_DM_TU_DIEN.TEN] = "------ Tất cả ------"; v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = ""; v_dr[CM_DM_TU_DIEN.TEN_NGAN] = ""; v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 1; v_dr[CM_DM_TU_DIEN.GHI_CHU] = ""; v_ds_dm_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); ip_obj_cbo_trang_thai.SelectedIndex = 0; } }
public static void load_data_to_cbo_tu_dien( string ip_str_ma_loai_tu_dien , eTAT_CA ip_e_tat_ca , DropDownList ip_obj_cbo_trang_thai) { US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds( ip_str_ma_loai_tu_dien , CM_DM_TU_DIEN.GHI_CHU , v_ds_dm_tu_dien); ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN; ip_obj_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN; ip_obj_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.ID; ip_obj_cbo_trang_thai.DataBind(); if (ip_e_tat_ca == eTAT_CA.YES) { ip_obj_cbo_trang_thai.Items.Insert(0, new ListItem(CONST_GIAO_DICH.STR_VALUE_TAT_CA, CONST_GIAO_DICH.ID_TAT_CA.ToString())); } }
public string get_ten_loai_hinh_don_vi() { if (m_cbo_loai_hinh_don_vi.SelectedValue.Equals(CONST_QLDB.MA_TAT_CA)) return "Tất cả"; US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN(MA_LOAI_TU_DIEN.LOAI_HINH_DON_VI, m_cbo_loai_hinh_don_vi.SelectedValue); return v_us_cm_dm_tu_dien.strTEN; }
private void grid2us_object(US_CM_DM_TU_DIEN i_us , int i_grid_row) { DataRow v_dr; v_dr = (DataRow) m_fg.Rows[i_grid_row].UserData; m_obj_trans.GridRow2DataRow(i_grid_row,v_dr); i_us.DataRow2Me(v_dr);
private void load_update_dm_tu_dien(int i_int_row_index) { decimal v_dc_id_dm_tu_dien = CIPConvert.ToDecimal(m_grv_dm_tu_dien.DataKeys[i_int_row_index].Value); US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN(v_dc_id_dm_tu_dien); m_hdf_id_dm_tu_dien.Value = CIPConvert.ToStr(v_dc_id_dm_tu_dien); us_object_2_form(v_us_dm_tu_dien); }
private void load_data_2_cbo_don_vi_noi_bo() { m_e_trang_thai_cbo_dv = e_trang_thai_cbo_don_vi.DANG_FILL_DATA; US_CM_DM_TU_DIEN v_us_tu_dien_trang_thai = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_trang_thai = new DS_CM_DM_TU_DIEN(); DataRow v_dr = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); v_dr[CM_DM_TU_DIEN.ID] = "0"; v_dr[CM_DM_TU_DIEN.TEN] = "-- Chọn đơn vị liên quan --"; v_ds_tu_dien_trang_thai.EnforceConstraints = false; v_us_tu_dien_trang_thai.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.PHONG_BAN_NOI_BO, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai); v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_don_vi_noi_bo.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN; m_cbo_don_vi_noi_bo.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_don_vi_noi_bo.ValueMember = CM_DM_TU_DIEN.ID; m_e_trang_thai_cbo_dv = e_trang_thai_cbo_don_vi.DA_FILL_XONG; }
public static void load_data_to_cbo_loai_hinh_don_vi( eLOAI_TU_DIEN ip_e_trang_thai_tai_san , eTAT_CA ip_e_tat_ca , DropDownList ip_obj_cbo_trang_thai) { US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN(); string v_str_loai_trang_thai = ""; v_str_loai_trang_thai = MA_LOAI_TU_DIEN.LOAI_HINH_DON_VI; v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds( v_str_loai_trang_thai , CM_DM_TU_DIEN.GHI_CHU , v_ds_dm_tu_dien); ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN; ip_obj_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN; ip_obj_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.MA_TU_DIEN; ip_obj_cbo_trang_thai.DataBind(); if (ip_e_tat_ca == eTAT_CA.YES) { ip_obj_cbo_trang_thai.Items.Insert(0, new ListItem(CONST_QLDB.TAT_CA, CONST_QLDB.ID_TAT_CA.ToString())); } }
public static void load_data_to_ddl_loai_nhiem_vu(DropDownList op_ddl) { US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN(); v_us.FillDataset(v_ds, "where " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + "=" + ID_LOAI_TU_DIEN.LOAI_NHIEM_VU_NS + "order by " + CM_DM_TU_DIEN.GHI_CHU); string v_str_data_default = "---Chọn loại nhiệm vụ---"; for (int i = 0; i < v_ds.CM_DM_TU_DIEN.Count; i++) { v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.TEN] = v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.GHI_CHU].ToString() + " - " + v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.TEN]; v_ds.AcceptChanges(); } op_ddl.DataTextField = CM_DM_TU_DIEN.TEN; op_ddl.DataValueField = CM_DM_TU_DIEN.ID; op_ddl.DataSource = v_ds.CM_DM_TU_DIEN; op_ddl.DataBind(); op_ddl.Items.Insert(0, new ListItem(v_str_data_default, "-1")); }
public static void load_data_to_ddl_loai_nhiem_vu(DropDownList op_ddl, bool ip_b_is_nguon_ns, bool ip_b_is_chi_du_an) { /* * Tác dụng: Load dữ liệu Loại nhiệm vụ theo điều kiện sau: * 1. Nguồn Quỹ BT * - Chi Dự án: Dữ liệu A - Bảo dưỡng..., B - Sửa chữa định kỳ, C -.., D -..., E - ..., F - Văn phòng cục * - Chi theo CLKM: như Chi Dự án, mặc định chọn F - Văn phòng Cục * 2. Nguồn Ngân Sách * - Chi Dự án: A - ..., B - ..., C -..., D - ..., E - ..., F - ... * - Chi theo CLKM: I - Thu, chi, nộp ngân sách phí, lệ phí; II - Dự toán chi ngân sách nhà nước; * Mặc định chọn II và không cho chọn option khác * Giải pháp: * 1. Fill data vào dataset theo điều kiện trên * 2. Convert lại dữ liệu: ghép tên: Sửa chữa thường xuyên, ghi chú: A -> A - Sửa chữa thường xuyên * 3. Fill data vào dropdownlist * 4. Đặt giá trị mặc định cho dropdownlist */ US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN(); //1. Fill data vào dataset if (ip_b_is_chi_du_an)//Chi Dự án { v_us.FillDataset(v_ds, "where " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + "=" + ID_LOAI_TU_DIEN.LOAI_NHIEM_VU + "order by " + CM_DM_TU_DIEN.GHI_CHU); } else//Chi theo CLKM - Chương Loại Khoản Mục { if (!ip_b_is_nguon_ns)//Nguồn Quỹ BT { v_us.FillDataset(v_ds, "where " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + "=" + ID_LOAI_TU_DIEN.LOAI_NHIEM_VU + "order by " + CM_DM_TU_DIEN.GHI_CHU); } else//Nguồn Ngân sách { v_us.FillDataset(v_ds, "where " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + "=" + ID_LOAI_TU_DIEN.LOAI_NHIEM_VU_NS + "order by " + CM_DM_TU_DIEN.GHI_CHU); } } //2. Convert dữ liệu string v_str_data_default = "---Chọn loại nhiệm vụ---"; for (int i = 0; i < v_ds.CM_DM_TU_DIEN.Count; i++) { v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.TEN] = v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.GHI_CHU].ToString() + " - " + v_ds.Tables[0].Rows[i][CM_DM_TU_DIEN.TEN]; v_ds.AcceptChanges(); } //3. Fill dữ liệu vào dropdownlist op_ddl.DataTextField = CM_DM_TU_DIEN.TEN; op_ddl.DataValueField = CM_DM_TU_DIEN.ID; op_ddl.DataSource = v_ds.CM_DM_TU_DIEN; op_ddl.DataBind(); op_ddl.Items.Insert(0, new ListItem(v_str_data_default, "-1")); op_ddl.Enabled = true; //4. Đặt giá trị mặc định cho dropdownlist if (!ip_b_is_chi_du_an)//Chi theo CLKM if (!ip_b_is_nguon_ns)//Nguồn Quỹ BT { //op_ddl.SelectedValue = ID_LOAI_NHIEM_VU.VAN_PHONG_CUC.ToString(); } else { op_ddl.SelectedValue = ID_LOAI_NHIEM_VU_NS.DU_TOAN_CHI_NS_NN.ToString(); op_ddl.Enabled = false; } }
private void load_data_2_cbo_loai_cau_hoi_tren() { m_e_trangThai_cbo_Nhom_cau_hoi = e_trangThai_cbo_Nhom_cau_hoi.DANG_FILL_DATA; US_CM_DM_TU_DIEN v_us_tu_dien_truong = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_truong = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_truong.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.NHOM_CAU_HOI, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_truong); DataRow v_dr = v_ds_tu_dien_truong.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); v_dr[CM_DM_TU_DIEN.ID] = "0"; v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "- Tất cả -"; v_dr[CM_DM_TU_DIEN.TEN] = "- Tất cả -"; v_ds_tu_dien_truong.EnforceConstraints = false; v_ds_tu_dien_truong.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_loai_cau_hoi_tren.DataSource = v_ds_tu_dien_truong.CM_DM_TU_DIEN; m_cbo_loai_cau_hoi_tren.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_loai_cau_hoi_tren.ValueMember = CM_DM_TU_DIEN.ID; m_e_trangThai_cbo_Nhom_cau_hoi = e_trangThai_cbo_Nhom_cau_hoi.DA_FILL_XONG; }
private void load_data_2_cbo_don_vi_lien_quan() { m_e_trangThai_cbo_Don_vi = e_trangThai_cbo_Don_vi.DANG_FILL_DATA; US_CM_DM_TU_DIEN v_us_tu_dien_dv_lien_quan = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_dv_lien_quan = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_dv_lien_quan.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_dv_lien_quan); DataRow v_dr = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); v_dr[CM_DM_TU_DIEN.ID] = "0"; v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "- Tất cả -"; v_dr[CM_DM_TU_DIEN.TEN] = "- Tất cả -"; v_ds_tu_dien_dv_lien_quan.EnforceConstraints = false; v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_don_vi_lien_quan.DataSource = v_ds_tu_dien_dv_lien_quan.CM_DM_TU_DIEN; m_cbo_don_vi_lien_quan.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_don_vi_lien_quan.ValueMember = CM_DM_TU_DIEN.ID; m_e_trangThai_cbo_Don_vi = e_trangThai_cbo_Don_vi.DA_FILL_XONG; }
private void load_data_trang_thai() { DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN(); US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN(); v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(MA_LOAI_TU_DIEN.TRANG_THAI_DAT, CM_DM_TU_DIEN.GHI_CHU, v_ds_cm_dm_tu_dien); m_cbo_trang_thai_dat_up.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN; m_cbo_trang_thai_dat_up.DataTextField = CM_DM_TU_DIEN.TEN; m_cbo_trang_thai_dat_up.DataValueField = CM_DM_TU_DIEN.ID; m_cbo_trang_thai_dat_up.DataBind(); m_cbo_trang_thai_dat_up.SelectedValue = ID_TRANG_THAI_DAT.DANG_SU_DUNG.ToString(); }
private void load_data_2_truong_quan_ly() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.DON_VI_QUAN_LY_CHINH , CM_DM_TU_DIEN.TEN , v_ds_tu_dien); DataRow v_dr = v_ds_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); v_dr[CM_DM_TU_DIEN.ID] = 0; v_dr[CM_DM_TU_DIEN.TEN] = "- Chọn một trường quản lý -"; v_ds_tu_dien.EnforceConstraints = false; v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_dv_quan_ly.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; m_cbo_dv_quan_ly.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_dv_quan_ly.ValueMember = CM_DM_TU_DIEN.ID; }
private void load_data_2_cbo_trang_thai_cau_hoi() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_GD_CAU_HOI_SV, CM_DM_TU_DIEN.ID, v_ds_tu_dien); DataRow v_dr = v_ds_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); v_dr[CM_DM_TU_DIEN.ID] = "0"; v_dr[CM_DM_TU_DIEN.TEN] = "-- Tất cả trạng thái --"; v_ds_tu_dien.EnforceConstraints = false; v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.ID; m_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN; m_cbo_trang_thai.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; m_cbo_trang_thai.DataBind(); }
private void load_data_2_trang_thai_thanh_toan() { US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_LUONG_ONL , CM_DM_TU_DIEN.TEN , v_ds_tu_dien); DataRow v_dr = v_ds_tu_dien.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); v_dr[CM_DM_TU_DIEN.ID] = 0; v_dr[CM_DM_TU_DIEN.TEN] = "- Tất cả trạng thái -"; v_ds_tu_dien.EnforceConstraints = false; v_ds_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_trang_thai_thanh_toan.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN; m_cbo_trang_thai_thanh_toan.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_trang_thai_thanh_toan.ValueMember = CM_DM_TU_DIEN.ID; m_e_cbo_trang_thai_tt_state = e_cbo_state_data.DA_FILL_DATA_XONG; }
private Hashtable get_data_map_trang_thai() { US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN(); v_us.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_GD_CAU_HOI_SV, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds); Hashtable v_htb = new Hashtable(); foreach (DS_CM_DM_TU_DIEN.CM_DM_TU_DIENRow v_tu_dien in v_ds.CM_DM_TU_DIEN.Rows) { v_htb.Add(v_tu_dien[CM_DM_TU_DIEN.ID], v_tu_dien[CM_DM_TU_DIEN.TEN]); } return v_htb; }
public static void load_data_to_cbo_tu_dien( eLOAI_TU_DIEN ip_e_trang_thai_tai_san , eTAT_CA ip_e_tat_ca , DropDownList ip_obj_cbo_trang_thai) { US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN(); string v_str_loai_trang_thai = ""; switch (ip_e_trang_thai_tai_san) { case eLOAI_TU_DIEN.TRANG_THAI_DAT: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TRANG_THAI_DAT; break; case eLOAI_TU_DIEN.TRANG_THAI_NHA: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TRANG_THAI_NHA; break; case eLOAI_TU_DIEN.TRANG_THAI_OTO: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TRANG_THAI_OTO; break; case eLOAI_TU_DIEN.TRANG_THAI_TAI_SAN_KHAC: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TRANG_THAI_TAI_SAN_KHAC; break; case eLOAI_TU_DIEN.LOAI_HINH_DON_VI: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.LOAI_HINH_DON_VI; break; case eLOAI_TU_DIEN.PHAN_LOAI_TAI_SAN: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.PHAN_LOAI_TAI_SAN; break; case eLOAI_TU_DIEN.LOAI_BAO_CAO: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.LOAI_BAO_CAO; break; case eLOAI_TU_DIEN.TINH_TRANG_TAI_SAN: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.TINH_TRANG_TAI_SAN; break; case eLOAI_TU_DIEN.LY_DO_TANG_GIAM_TS: v_str_loai_trang_thai = MA_LOAI_TU_DIEN.LY_DO_TANG_GIAM_TS; break; } v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds( v_str_loai_trang_thai , CM_DM_TU_DIEN.GHI_CHU , v_ds_dm_tu_dien); ip_obj_cbo_trang_thai.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN; ip_obj_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN; ip_obj_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.ID; ip_obj_cbo_trang_thai.DataBind(); if (ip_e_tat_ca == eTAT_CA.YES) { ip_obj_cbo_trang_thai.Items.Insert(0, new ListItem(CONST_QLDB.TAT_CA, CONST_QLDB.ID_TAT_CA.ToString())); } }
private void load_data_2_cbo_trang_thai_cau_hoi() { US_CM_DM_TU_DIEN v_us_tu_dien_trang_thai = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_trang_thai = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_trang_thai.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TRANG_THAI_GD_CAU_HOI_SV, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_trang_thai); DataRow v_dr = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow(); v_dr[CM_DM_TU_DIEN.ID] = "0"; v_dr[CM_DM_TU_DIEN.TEN] = "-- Tất cả --"; v_ds_tu_dien_trang_thai.EnforceConstraints = false; v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0); m_cbo_trang_thai_cau_hoi.DataSource = v_ds_tu_dien_trang_thai.CM_DM_TU_DIEN; m_cbo_trang_thai_cau_hoi.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_trang_thai_cau_hoi.ValueMember = CM_DM_TU_DIEN.ID; }
private void load_data_2_cbo_trang_thai_oto() { US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(MA_LOAI_TU_DIEN.TRANG_THAI_OTO, v_ds_cm_dm_tu_dien); m_cbo_trang_thai_tai_san.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_trang_thai_tai_san.ValueMember = CM_DM_TU_DIEN.ID; m_cbo_trang_thai_tai_san.SelectedValueChanged -= new EventHandler(m_cbo_bo_tinh_SelectedValueChanged); m_cbo_trang_thai_tai_san.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN; m_cbo_trang_thai_tai_san.SelectedValueChanged += new EventHandler(m_cbo_bo_tinh_SelectedValueChanged); }
private void load_data_2_cbo_truong() { US_CM_DM_TU_DIEN v_us_tu_dien_truong = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_tu_dien_truong = new DS_CM_DM_TU_DIEN(); v_us_tu_dien_truong.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.TO_CHUC_TRUONG, CM_DM_TU_DIEN.MA_TU_DIEN, v_ds_tu_dien_truong); m_cbo_truong.DataSource = v_ds_tu_dien_truong.CM_DM_TU_DIEN; m_cbo_truong.DisplayMember = CM_DM_TU_DIEN.TEN; m_cbo_truong.ValueMember = CM_DM_TU_DIEN.TEN_NGAN; }
// Load dữ liệu vào list loại báo cáo private void load_data_loai_bao_cao() { US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds_dm_tu_dien = new DS_CM_DM_TU_DIEN(); v_us_dm_tu_dien.fill_tu_dien_cung_loai_ds( MA_LOAI_TU_DIEN.LOAI_BAO_CAO , CM_DM_TU_DIEN.GHI_CHU , v_ds_dm_tu_dien); m_lst_loai_bao_cao.DataSource = v_ds_dm_tu_dien.CM_DM_TU_DIEN; m_lst_loai_bao_cao.DataTextField = CM_DM_TU_DIEN.TEN; m_lst_loai_bao_cao.DataValueField = CM_DM_TU_DIEN.ID; m_lst_loai_bao_cao.DataBind(); }
private void load_ds_nguoi_dai_dien(int ip_i_cau_hoi_row) { if (!HelpUtils.is_validated_edit_grid_row(ip_i_cau_hoi_row, m_fg)) return; US_CM_DM_TU_DIEN v_us_dm = new US_CM_DM_TU_DIEN(); grid2us_object(v_us_dm, m_fg.Row); load_data_2_grid_nguoi_dai_dien(v_us_dm.dcID);
// Load dữ liệu vào combo trạng thái private void load_data_trang_thai() { try { DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN(); US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN(); v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(MA_LOAI_TU_DIEN.TRANG_THAI_OTO, CM_DM_TU_DIEN.GHI_CHU, v_ds_cm_dm_tu_dien); m_ddl_trang_thai_oto.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN; m_ddl_trang_thai_oto.DataTextField = CM_DM_TU_DIEN.TEN; m_ddl_trang_thai_oto.DataValueField = CM_DM_TU_DIEN.ID; m_ddl_trang_thai_oto.DataBind(); } catch (Exception v_e) { throw v_e; } }