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