public static void load_data_2_cbo_trang_thai_hoc_sinh(
decimal ip_dc_id_trang_thai_hoc_sinh
, System.Windows.Forms.ComboBox op_cbo_trang_thai_hoc_sinh
)
{
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "where id_loai_tu_dien = " + ip_dc_id_trang_thai_hoc_sinh);
//DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow();
//v_dr[CM_DM_TU_DIEN.ID] = -1;
//v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "All";
//v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 10;
//v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "--Tất cả---";
//v_dr[CM_DM_TU_DIEN.TEN] = "--Tất cả---";
//v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
//DS_V_RPT_210_DM_LOP_MON v_ds_v_rpt_210_dm_lop_mon = new DS_V_RPT_210_DM_LOP_MON();
//US_V_RPT_210_DM_LOP_MON v_us_v_rpt_210_dm_lop_mon = new US_V_RPT_210_DM_LOP_MON();
//v_us_v_rpt_210_dm_lop_mon.FillDataset(v_ds_v_rpt_210_dm_lop_mon, "Where TRANG_THAI_LOP_MON = " + ip_dc_id_trang_thai_lop_mon.ToString());
op_cbo_trang_thai_hoc_sinh.DataSource = v_ds.CM_DM_TU_DIEN;
op_cbo_trang_thai_hoc_sinh.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
op_cbo_trang_thai_hoc_sinh.ValueMember = CM_DM_TU_DIEN.ID;
op_cbo_trang_thai_hoc_sinh.SelectedIndex = 0;
}
private void fill_data_2_le_trang_thai_lao_dong()
{
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 ID_LOAI_TU_DIEN = " + CONST_ID_LOAI_TU_DIEN.TRANG_THAI_LAO_DONG);
m_le_trang_thai_hien_tai.Properties.DataSource = v_ds.Tables[0];
}
private decimal find_id_cach_tinh_thue(string ip_str_cach_tinh_thue)
{
try
{
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);
string v_str_filter = "TEN = '" + ip_str_cach_tinh_thue + "'";
DataRow[] v_dr = v_ds.CM_DM_TU_DIEN.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return -1;
}
else
{
return CIPConvert.ToDecimal(v_dr.First()["ID"].ToString());
}
}
catch (Exception v_e)
{
throw v_e;
}
}
private void load_data_to_sle_nhom_ld()
{
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, 18);
m_sle_nhom_ld.Properties.DataSource = v_ds.Tables[0];
}
private void load_data_to_combobox_khoan_tien()
{
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, 19);
m_cmb_khoan_tien.DataSource = v_ds.Tables[0];
m_cmb_khoan_tien.DisplayMember = "TEN";
m_cmb_khoan_tien.ValueMember = "ID";
}
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;
}
private void load_data_2_cbo()
{
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.FillDataset(v_ds_cm_dm_tu_dien, "where id_loai_tu_dien = "+ CONST_ID_CM_DM_LOAI_TD.ID_LOAI_DINH_MUC);
m_cbo_loai_dinh_muc.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
m_cbo_loai_dinh_muc.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
m_cbo_loai_dinh_muc.ValueMember = CM_DM_TU_DIEN.ID;
}
public US_CM_DM_TU_DIEN(decimal i_dbID)
{
pm_objDS = new DS_CM_DM_TU_DIEN();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
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 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_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 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_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_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();
}
public static void load_data_2_cbo_trang_thai_hoc_sinh(
System.Windows.Forms.ComboBox op_cbo_trang_thai_hoc_sinh
)
{
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "where id_loai_tu_dien = " + CONST_LOAI_TU_DIEN.TRANG_THAI_HOC_SINH);
op_cbo_trang_thai_hoc_sinh.DataSource = v_ds.CM_DM_TU_DIEN;
op_cbo_trang_thai_hoc_sinh.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
op_cbo_trang_thai_hoc_sinh.ValueMember = CM_DM_TU_DIEN.ID;
op_cbo_trang_thai_hoc_sinh.SelectedIndex = 0;
}
public US_CM_DM_TU_DIEN(decimal i_dbID)
{
pm_objDS = new DS_CM_DM_TU_DIEN();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
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 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 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_DM_CAU_TRA_LOI, 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_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;
}
}
private void load_data_2_trang_thai_don_hang()
{
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_DON_HANG
, CM_DM_TU_DIEN.TEN
, v_ds_tu_dien);
m_cbo_trang_thai_don_hang.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai_don_hang.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_don_hang.ValueMember = CM_DM_TU_DIEN.ID;
m_e_cbo_trang_thai_don_hang = e_cbo_state.DA_FILL_DATA_XONG;
}
/// <summary>
/// Hàm lấy mã từ điển (string) dựa vào mã ID
/// </summary>
/// <param name="ip_dc_id"></param>
/// <returns></returns>
private string load_ma_tu_dien_by_id(decimal ip_dc_id)
{
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.FillDataset(v_ds_cm_dm_tu_dien, " WHERE ID= " + ip_dc_id);
if (v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows.Count < 0)
{
return("");
}
else
{
return(v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows[0][CM_DM_TU_DIEN.MA_TU_DIEN].ToString());
}
}
private void load_data_2_trang_thai_don_hang_de_cap_nhat()
{
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 " + CM_DM_TU_DIEN.ID_LOAI_TU_DIEN + " = "
+ LOAI_TU_DIEN_ID.TRANG_THAI_GD_YEU_CAU
+ " AND " + CM_DM_TU_DIEN.ID + " <> " + TU_DIEN_TRANG_THAI_DON_HANG.DA_DONG
+ " ORDER BY " + CM_DM_TU_DIEN.TEN);
m_cbo_trang_thai_don_hang.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai_don_hang.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_don_hang.ValueMember = CM_DM_TU_DIEN.ID;
m_e_cbo_trang_thai_don_hang = e_cbo_state.DA_FILL_DATA_XONG;
}
private string get_ma_from_id(string ip_dc_id_trang_thai_giang_vien)
{
try
{
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.FillDataset(v_ds_dm_tu_dien, " WHERE ID = " + ip_dc_id_trang_thai_giang_vien + "");
return(CIPConvert.ToStr(v_ds_dm_tu_dien.CM_DM_TU_DIEN[0][CM_DM_TU_DIEN.MA_TU_DIEN]));
}
catch (Exception v_e)
{
throw v_e;
}
}
private void load_data_2_cbo_loai_hanh_dong()
{
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();
DataRow v_dr = v_ds_cm_dm_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ả";
v_ds_cm_dm_tu_dien.EnforceConstraints = false;
v_us_cm_dm_tu_dien.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.LOG_LOAI_HANH_DONG
, CM_DM_TU_DIEN.TEN
, v_ds_cm_dm_tu_dien);
v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
m_cbo_loai_hanh_dong.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_loai_hanh_dong.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_loai_hanh_dong.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
}
private void load_2_cbo_loai_hop_dong()
{
US_CM_DM_TU_DIEN v_us_dm_loai_hop_dong = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_dm_loai_hop_dong = new DS_CM_DM_TU_DIEN();
try
{
v_us_dm_loai_hop_dong.FillDataset(v_ds_dm_loai_hop_dong, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.LOAI_HOP_DONG);
m_cbo_dm_loai_hop_dong.DataSource = v_ds_dm_loai_hop_dong.CM_DM_TU_DIEN;
m_cbo_dm_loai_hop_dong.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_dm_loai_hop_dong.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_dm_loai_hop_dong.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
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_loai_su_kien()
{
try
{
US_CM_DM_TU_DIEN v_us_loai_su_kien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_loai_loai_su_kien = new DS_CM_DM_TU_DIEN();
v_us_loai_su_kien.FillDataset(v_ds_loai_loai_su_kien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.LOAI_SU_KIEN);
m_cbo_loai_su_kien.DataSource = v_ds_loai_loai_su_kien.CM_DM_TU_DIEN;
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.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
private void load_cbo_loai_hop_dong()
{
try
{
US_CM_DM_TU_DIEN v_us_loai_hop_dong = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_loai_loai_hop_dong = new DS_CM_DM_TU_DIEN();
v_us_loai_hop_dong.FillDataset(v_ds_loai_loai_hop_dong, " WHERE ID_LOAI_TU_DIEN = 5");
m_cbo_loai_hop_dong.DataSource = v_ds_loai_loai_hop_dong.CM_DM_TU_DIEN;
m_cbo_loai_hop_dong.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_loai_hop_dong.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_loai_hop_dong.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
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);
DataRow v_dr = v_ds_tu_dien_truong.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_dr[CM_DM_TU_DIEN.TEN] = "------";
v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "------";
v_ds_tu_dien_truong.EnforceConstraints = false;
v_ds_tu_dien_truong.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
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.MA_TU_DIEN;
}
private void load_2_cbo_trang_thai_hd()
{
US_CM_DM_TU_DIEN v_us_trang_thai_hd = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_trang_thai_hd = new DS_CM_DM_TU_DIEN();
try
{
v_us_trang_thai_hd.FillDataset(v_ds_trang_thai_hd, " WHERE ID_LOAI_TU_DIEN =" + (int)e_loai_tu_dien.TRANG_THAI_HOP_DONG_KHUNG + " ORDER BY GHI_CHU");
m_cbo_dm_trang_thai_hop_dong.DataSource = v_ds_trang_thai_hd.CM_DM_TU_DIEN;
m_cbo_dm_trang_thai_hop_dong.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_dm_trang_thai_hop_dong.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_dm_trang_thai_hop_dong.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
private void load_data_2_grid()
{
m_ds = new DS_CM_DM_TU_DIEN();
switch (m_e_form_mode)
{
case e_formMode.VIEW_TOAN_BO:
m_us.fill_tu_dien_cung_loai_ds(LOAI_TU_DIEN_TEXT.PHONG_BAN_NOI_BO, CM_DM_TU_DIEN.ID, m_ds);
break;
case e_formMode.VIEW_QLHT:
m_us.fill_tu_dien_by_procedure("pr_CM_DM_TU_DIEN_Load_Phong_QLHT", "", m_ds);
break;
}
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
load_data_2_grid_nguoi_dai_dien(0);
}
private void load_2_cbo_don_vi_quan_ly()
{
US_CM_DM_TU_DIEN v_us_don_vi_quan_ly = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_don_vi_quan_ly = new DS_CM_DM_TU_DIEN();
try
{
v_us_don_vi_quan_ly.FillDataset(v_ds_don_vi_quan_ly, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.DON_VI_QUAN_LY_CHINH);
m_cbo_dm_loai_don_vi_quan_li.DataSource = v_ds_don_vi_quan_ly.CM_DM_TU_DIEN;
m_cbo_dm_loai_don_vi_quan_li.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_dm_loai_don_vi_quan_li.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_dm_loai_don_vi_quan_li.DataBind();
}
catch (Exception v_e)
{
throw v_e;
}
}
private void load_data_2_cbo_loai_cau_hoi_duoi()
{
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_duoi.DataSource = v_ds_tu_dien_truong.CM_DM_TU_DIEN;
m_cbo_loai_cau_hoi_duoi.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_loai_cau_hoi_duoi.ValueMember = CM_DM_TU_DIEN.ID;
}
// load dữ liệu lên combo trạng thái
private void load_data_2_combo_trang_thai()
{
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();
try
{
v_cm_dm_tu_dien.FillDataset(v_ds_cm_dm_tu_dien, "WHERE ID_LOAI_TU_DIEN = 23");
m_cbo_trang_thai.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai.DataValueField = CM_DM_TU_DIEN.ID;
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private void load_data_2_cbo_trang_thai_thanh_toan()
{
DS_CM_DM_TU_DIEN v_ds_trang_thai_thanh_toan = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us_trang_thai_thanh_toan = new US_CM_DM_TU_DIEN();
DataRow v_dr_none = v_ds_trang_thai_thanh_toan.CM_DM_TU_DIEN.NewCM_DM_TU_DIENRow();
v_ds_trang_thai_thanh_toan.EnforceConstraints = false;
v_dr_none[CM_DM_TU_DIEN.ID] = "0";
v_dr_none[CM_DM_TU_DIEN.MA_TU_DIEN] = "All";
v_dr_none[CM_DM_TU_DIEN.TEN] = "Tất cả";
v_ds_trang_thai_thanh_toan.CM_DM_TU_DIEN.Rows.InsertAt(v_dr_none, 0);
v_us_trang_thai_thanh_toan.FillDataset(v_ds_trang_thai_thanh_toan, " WHERE ID_LOAI_TU_DIEN = 15");
m_cbo_trang_thai_thanh_toan.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_thanh_toan.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_trang_thai_thanh_toan.DataSource = v_ds_trang_thai_thanh_toan.CM_DM_TU_DIEN;
m_cbo_trang_thai_thanh_toan.DataBind();
}
private void get_so_ky_hieu()
{
var v_us_cm_dm_tu_dien = new US_CM_DM_TU_DIEN();
var v_ds_cm_dm_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_cm_dm_tu_dien.FillDataset(v_ds_cm_dm_tu_dien, "where MA_TU_DIEN = '" + _loaiCongVan + "' and TEN = '" + getYear() + "'");
var v_int_cv_count = 1;
if (v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows.Count > 0)
{
var v_dr = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN.Rows[0];
int.TryParse(v_dr[CM_DM_TU_DIEN.TEN_NGAN].ToString(), out v_int_cv_count);
}
else if(!string.IsNullOrEmpty(_loaiCongVan))
{
//v_us_cm_dm_tu_dien.strMA_TU_DIEN = _loaiCongVan;
//v_us_cm_dm_tu_dien.dcID_LOAI_TU_DIEN = 26;
//v_us_cm_dm_tu_dien.strTEN_NGAN = "01";
//v_us_cm_dm_tu_dien.strTEN = this.Text;
//v_us_cm_dm_tu_dien.Insert();
}
this.Text = string.Format("{0:00}", v_int_cv_count) + "/" + getYear();
}
public static void load_data_2_cbo_loai_phieu_thu(
decimal ip_dc_id_loai_tu_dien
, System.Windows.Forms.ComboBox op_cbo_tu_dien)
{
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "where id_loai_tu_dien = " + ip_dc_id_loai_tu_dien);
DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow();
v_dr[CM_DM_TU_DIEN.ID] = -1;
v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "TAT_CA";
v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = -1;
v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "--Tất cả--";
v_dr[CM_DM_TU_DIEN.TEN] = "--Tất cả--";
v_dr[CM_DM_TU_DIEN.GHI_CHU] = "";
v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
op_cbo_tu_dien.DataSource = v_ds.CM_DM_TU_DIEN;
op_cbo_tu_dien.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
op_cbo_tu_dien.ValueMember = CM_DM_TU_DIEN.ID;
op_cbo_tu_dien.SelectedIndex = 0;
}
private void load_data_to_sle_loai_quy()
{
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, 16);
m_sle_loai_quy_thu_nhap.Properties.DataSource = v_ds.Tables[0];
}
private string find_id_cm_dm_tu_dien_by_trinh_do_van_hoa(string ip_str_trinh_do_van_hoa)
{
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);
ip_str_trinh_do_van_hoa = ip_str_trinh_do_van_hoa.Trim().ToUpper();
string v_str_filter = "MA_TU_DIEN = '" + ip_str_trinh_do_van_hoa + "'";
DataRow[] v_dr = v_ds.CM_DM_TU_DIEN.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return null;
}
else
{
return v_dr.First()["ID"].ToString();
}
}
/// <summary>
/// Trả về danh sách các nhân viên được quyền chọn theo user người sử dụng
/// </summary>
/// <param name="ip_id_user"></param>
public static void load_data_2_cbo_trang_thai_lop_mon(
decimal ip_dc_id_trang_thai_lop_mon
, System.Windows.Forms.ComboBox op_cbo_trang_thai_lop_mon
)
{
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "where id_loai_tu_dien = " + ip_dc_id_trang_thai_lop_mon);
//DS_V_RPT_210_DM_LOP_MON v_ds_v_rpt_210_dm_lop_mon = new DS_V_RPT_210_DM_LOP_MON();
//US_V_RPT_210_DM_LOP_MON v_us_v_rpt_210_dm_lop_mon = new US_V_RPT_210_DM_LOP_MON();
//v_us_v_rpt_210_dm_lop_mon.FillDataset(v_ds_v_rpt_210_dm_lop_mon, "Where TRANG_THAI_LOP_MON = " + ip_dc_id_trang_thai_lop_mon.ToString());
op_cbo_trang_thai_lop_mon.DataSource = v_ds.CM_DM_TU_DIEN;
op_cbo_trang_thai_lop_mon.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
op_cbo_trang_thai_lop_mon.ValueMember = CM_DM_TU_DIEN.ID;
op_cbo_trang_thai_lop_mon.SelectedIndex = 0;
}
private void get_loai_phu_cap()
{
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, 5);
m_search_lookup_edit_loai_phu_cap.Properties.DataSource = v_ds.Tables[0];
m_search_lookup_edit_loai_phu_cap.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
//DataSet v_ds = new DataSet();
//DataTable v_dt = new DataTable();
//US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
//v_ds.Tables.Add(v_dt);
//v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM CM_DM_TU_DIEN WHERE ID_LOAI_TU_DIEN = 5");
//m_search_lookup_edit_loai_phu_cap.Properties.DataSource = v_ds.Tables[0];
//m_search_lookup_edit_loai_phu_cap.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
}
private void load_data_to_sle_muc_lcd()
{
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, 4);
m_sle_muc_lcd.Properties.DataSource = v_ds.Tables[0];
m_sle_muc_lcd.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_muc_lcd.Properties.ValueMember = CM_DM_TU_DIEN.ID;
//m_sle_chuc_danh_lns.EditValue = null;
//m_sle_muc_lcd.Properties.NullText = "--Chọn mức--";
}
private void load_data_to_le_ly_do_chinh_sua()
{
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, CONST_ID_LOAI_TU_DIEN.LY_DO_CHINH_SUA_HS_LNS);
m_le_ly_do_chinh_sua.Properties.DataSource = v_ds.Tables[0];
}
private void load_data_to_sle_loai_chuc_vu()
{
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 ID_LOAI_TU_DIEN = 21");
m_sle_loai_chuc_vu.Properties.ValueMember = CM_DM_TU_DIEN.ID;
m_sle_loai_chuc_vu.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_loai_chuc_vu.Properties.DataSource = v_ds.Tables[0];
}
private decimal find_id_tu_dien_by_ma_tu_dien(string ma_tu_dien)
{
try
{
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);
decimal id = (from DataRow dr in v_ds.Tables[0].Rows
where (string)dr["MA_TU_DIEN"] == ma_tu_dien
select (decimal)dr["ID"]).FirstOrDefault();
return id;
}
catch(Exception v_e)
{
throw v_e;
}
}
private bool insert_data()
{
try
{
string v_str_file_name = m_txt_file_upload.Text.Split('\\')[m_txt_file_upload.Text.Split('\\').Length - 1];
string v_str_save_file = ConfigurationSettings.AppSettings["DOMAIN"] + "/" + "FileUpload_Vanthu" + "/" + v_str_file_name.Replace(ConfigurationSettings.AppSettings["DOMAIN"] + "/" + "FileUpload_Vanthu" + "/","");
if (!m_txt_file_upload.Text.Trim().Equals("") && !m_txt_file_upload.Text.Contains(ConfigurationSettings.AppSettings["DOMAIN"]))
{
if (!HelpUtils.ftpTransfer(m_txt_file_upload.Text.Replace(v_str_file_name, ""), v_str_file_name)) return false;
}
US_GD_VAN_THU v_us_gd_van_thu = new US_GD_VAN_THU();
if (m_dc_id_van_thu != 0) v_us_gd_van_thu = new US_GD_VAN_THU(m_dc_id_van_thu);
if (m_tcd_ngay_tren_cv.getValue() == null) v_us_gd_van_thu.SetNGAY_THANG_TREN_CONG_VANNull();
else
v_us_gd_van_thu.datNGAY_THANG_TREN_CONG_VAN = CIPConvert.ToDatetime(m_tcd_ngay_tren_cv.Text, "dd/MM/yyyy");
if (m_tcd_ngay_nhap.getValue() == null) v_us_gd_van_thu.SetNGAY_LAPNull();
else
v_us_gd_van_thu.datNGAY_LAP = CIPConvert.ToDatetime(m_tcd_ngay_nhap.Text, "dd/MM/yyyy");
v_us_gd_van_thu.strSO_VA_KY_HIEU = m_txt_so_va_ky_hieu.Text.Trim();
v_us_gd_van_thu.strTEN_LOAI_VA_TRICH_YEU_ND = m_txt_ten_loai.Text.Trim();
US_DM_PHONG_BAN_PHAP_NHAN v_us_dm_phong_ban = new US_DM_PHONG_BAN_PHAP_NHAN();
DS_DM_PHONG_BAN_PHAP_NHAN v_ds_dm_phong_ban = new DS_DM_PHONG_BAN_PHAP_NHAN();
if (m_cbx_ban_luu.SelectedValue != null)
{
v_us_dm_phong_ban.FillDataset(v_ds_dm_phong_ban,
" where id_phong_ban = " + m_cbx_ban_luu.SelectedValue);
v_us_gd_van_thu.dcID_NGUOI_NHAN_BAN_LUU = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue);
v_us_gd_van_thu.dcID_NOI_NGUOI_NHAN = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue);
}
else
{
v_us_gd_van_thu.SetID_NGUOI_NHAN_BAN_LUUNull();
v_us_gd_van_thu.SetID_NOI_NGUOI_NHANNull();
}
if (v_ds_dm_phong_ban.Tables[0].Rows.Count > 0)
v_us_gd_van_thu.dcID_PHAP_NHAN = CIPConvert.ToDecimal(v_ds_dm_phong_ban.Tables[0].Rows[0][DM_PHONG_BAN_PHAP_NHAN.ID_PHAP_NHAN]);
else v_us_gd_van_thu.SetID_PHAP_NHANNull();
v_us_gd_van_thu.strGHI_CHU = m_txt_ghi_chu.Text.Trim();
v_us_gd_van_thu.dcID_TRANG_THAI = CIPConvert.ToDecimal(m_cbx_trang_thai.SelectedValue);
v_us_gd_van_thu.strNGUOI_LAP = m_txt_nguoi_nhap.Text.Trim();
if (!m_txt_file_upload.Text.Trim().Equals(string.Empty))
v_us_gd_van_thu.strLINK_SCAN = v_str_save_file;
else v_us_gd_van_thu.strLINK_SCAN = string.Empty;
v_us_gd_van_thu.strSO_CV_DEN = m_txt_so_cv_den.Text.Trim();
v_us_gd_van_thu.strNOI_GUI = m_txt_noi_gui.Text.Trim();
v_us_gd_van_thu.dcID_LOAI_CONG_VAN = ID_LOAI_VAN_THU.CONG_VAN_DEN;
v_us_gd_van_thu.strNOI_NHAN = m_cbx_ban_luu.Text.Trim();
if (v_us_dm_phong_ban.dcID == -1)
{
v_us_gd_van_thu.Insert();
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 ma_tu_dien='CV_DEN'");
if (v_ds.CM_DM_TU_DIEN.Count > 0)
{
v_us.DataRow2Me(v_ds.Tables[0].Rows[0]);
string v_str_so = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN_NGAN].ToString();
string v_str_nam = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN].ToString();
v_str_so = CIPConvert.ToStr(CIPConvert.ToDecimal(v_str_so) + 1, "0#");
m_txt_so_cv_den.Text = v_str_so + "/" + v_str_nam;
v_us.strTEN = v_str_nam;
v_us.strTEN_NGAN = v_str_so;
v_us.Update();
}
}
else
{
v_us_dm_phong_ban.Update();
}
return true;
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
return false;
}
}
private void load_data_2_sle_chon_loai_trang_thai_lao_dong()
{
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 ID_LOAI_TU_DIEN = 17");
m_sle_chon_loai_trang_thai_lao_dong.Properties.DataSource = v_ds.Tables[0];
m_sle_chon_loai_trang_thai_lao_dong.Properties.ValueMember = CM_DM_TU_DIEN.ID;
m_sle_chon_loai_trang_thai_lao_dong.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_chon_loai_trang_thai_lao_dong.Properties.PopulateViewColumns();
m_sle_chon_loai_trang_thai_lao_dong.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
m_sle_chon_loai_trang_thai_lao_dong.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit;
}
private DataTable load_data_from_tu_dien(decimal id_loai_tu_dien)
{
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 ID_LOAI_TU_DIEN = " + id_loai_tu_dien);
return v_ds.Tables[0];
}
private DS_CM_DM_TU_DIEN load_data_2_cm_dm_tu_dien(int m_id_lns_lcd_trong_loai_td)
{
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, m_id_lns_lcd_trong_loai_td);
return v_ds;
}
private void load_data_2_cbo()
{
US_CM_DM_TU_DIEN v_us_td = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_td = new DS_CM_DM_TU_DIEN();
v_us_td.FillDataset(v_ds_td," where id_loai_tu_dien= 16 ");
m_cbo_loai_co_so.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbo_loai_co_so.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_loai_co_so.DataSource = v_ds_td.CM_DM_TU_DIEN;
}
private void load_data_to_sle_loai_lao_dong()
{
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, 6);
m_sle_loai_lao_dong.Properties.DataSource = v_ds.Tables[0];
m_sle_loai_lao_dong.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_loai_lao_dong.Properties.ValueMember = CM_DM_TU_DIEN.ID;
//m_sle_loai_lao_dong.Properties.NullText = "---Chọn loại lao động---";
}
private void load_cbo_loai_de_xuat()
{
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 id_loai_tu_dien ="+17);
m_cbo_loai_de_xuat.DataSource = v_ds.CM_DM_TU_DIEN;
m_cbo_loai_de_xuat.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_loai_de_xuat.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
}
private void load_data_to_sle_muc_lns()
{
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, 2);
m_sle_muc_lns.Properties.DataSource = v_ds.Tables[0];
m_sle_muc_lns.Properties.DisplayMember = CM_DM_TU_DIEN.TEN;
m_sle_muc_lns.Properties.ValueMember = CM_DM_TU_DIEN.ID;
}
private void load_data_trang_thai()
{
try
{
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.FillDataset(v_ds_cm_dm_tu_dien, "where ma_tu_dien in ('CHO_SO_VAO_SO_DONG_DAU','DA_LUU','DA_CHUYEN_DEN_NGUOI_NHAN','NGUOI_NHAN_DA_NHAN_DUOC') order by ten_ngan");
m_cbx_trang_thai.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
m_cbx_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN;
m_cbx_trang_thai.ValueMember = CM_DM_TU_DIEN.ID;
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void load_thong_tin_so_va_ky_hieu_van_ban()
{
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 ma_tu_dien='CV_DEN'");
if (v_ds.CM_DM_TU_DIEN.Count > 0)
{
string v_str_so = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN_NGAN].ToString();
string v_str_nam = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN].ToString();
m_txt_so_cv_den.Text = v_str_so + "/" + v_str_nam;
}
}
private DataSet load_data_2_cm_dm_tu_dien(int m_id_vt)
{
DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();
US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
v_us.FillDatasetByIdLoaiTuDien(v_ds, m_id_vt);
return v_ds;
}
