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