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