/// <summary> /// Create custom source for autocomplete from DM_KY /// </summary> /// <returns>Custom source</returns> public static AutoCompleteStringCollection create_csac_ky() { // Initialize US_DM_KY v_us_dm_ky = new US_DM_KY(); DS_DM_KY v_ds_dm_ky = new DS_DM_KY(); AutoCompleteStringCollection v_acsc = new AutoCompleteStringCollection(); try { // Fill dataset v_us_dm_ky.FillDataset(v_ds_dm_ky); // Create custom source foreach (var v_rows in v_ds_dm_ky.DM_KY) { v_acsc.Add((String)v_rows[DM_KY.MA_KY]); } } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); return(null); } return(v_acsc); }
public void FillDataset_Search(DS_DM_KY op_ds, string ip_key_word) { CStoredProc v_sp = new CStoredProc("pr_DM_KY_Search"); v_sp.addNVarcharInputParam("@ip_key_word", ip_key_word); v_sp.fillDataSetByCommand(this, op_ds); }
private void load_data_2_grid() { m_ds = new DS_DM_KY(); m_us.FillDataset_Search(m_ds, m_txt_search.Text); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; }
/// <summary> /// Tạo datasource mã kỳ /// </summary> /// <returns>DataSet làm DataSource</returns> public static DataSet create_datasrc_ma_ky() { // Initialize US_DM_KY v_us = new US_DM_KY(); DS_DM_KY v_ds = new DS_DM_KY(); v_us.FillDataset(v_ds); return(v_ds); }
public US_DM_KY(decimal i_dbID) { pm_objDS = new DS_DM_KY(); 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]); }
/// <summary> /// Load DataSource Mã kỳ cho ComboBox /// </summary> /// <param name="op_cbo"></param> /// <returns>Thành công trả lại true, ngược lại false</returns> public static bool load_datasrc_ma_ky(ComboBox op_cbo) { try { DS_DM_KY v_ds = (DS_DM_KY)create_datasrc_ma_ky(); op_cbo.DataSource = v_ds.DM_KY; op_cbo.DisplayMember = DM_KY.MA_KY; op_cbo.ValueMember = DM_KY.ID; return(true); } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); return(false); } }
/// <summary> /// Hàm setup các properties của members /// </summary> private void init_members() { // m_cmd_xuat_exel m_cmd_xuat_excel.Visible = false; // m_ds_tong_luong_n m_ds_tong_luong_n = new Dictionary <string, DS_RPT_TONG_LUONG>(); // Init US_DM_KY v_us_ky = new US_DM_KY(); DS_DM_KY v_ds_ky = new DS_DM_KY(); // Fill DS v_us_ky.FillDataset(v_ds_ky); // m_fg m_fg.AllowEditing = false; Column v_col; // Add column mã tổng lương v_col = m_fg.Cols.Add(); v_col.Name = "MA_TONG_LUONG"; v_col.Caption = "Mã tổng lương"; v_col.DataType = typeof(string); // Add các column mã kỳ foreach (DataRow v_row in v_ds_ky.DM_KY.Rows) { string v_ma_ky = (String)v_row[DM_KY.MA_KY]; v_col = m_fg.Cols.Add(); v_col.Name = v_ma_ky; v_col.Caption = v_ma_ky; v_col.DataType = typeof(Decimal); v_col.Format = "#,###"; } }
private void load_data_2_cbo() { // Cbo ma ky US_DM_KY v_us_dm_ky = new US_DM_KY(); DS_DM_KY v_ds_dm_ky = new DS_DM_KY(); v_us_dm_ky.FillDataset(v_ds_dm_ky); DataTable v_dt = v_ds_dm_ky.Tables[0]; DataRow v_dr = v_dt.NewRow(); v_dr[DM_KY.ID] = -1; v_dr[DM_KY.MA_KY] = "Tất cả"; v_dt.Rows.InsertAt(v_dr, 0); m_cbo_ky.DataSource = v_dt; m_cbo_ky.ValueMember = DM_KY.ID; m_cbo_ky.DisplayMember = DM_KY.MA_KY; // Cbo loai luong CUtils.load_datasource_loai_quyet_dinh(m_cbo_loai_luong, 1, true); }
public US_DM_KY() { pm_objDS = new DS_DM_KY(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }