public void FillDatasetSearch(DS_V_GD_LUONG_THEO_QD op_ds,
decimal ip_dc_id_phap_nhan,
string ip_str_keyword,
bool ip_bool_luong_hien_tai,
decimal ip_dc_id_ky,
decimal ip_dc_id_loai_luong,
DateTime ip_dat_tu_ngay_ap_dung, DateTime ip_dat_den_ngay_ap_dung)
{
CStoredProc v_sp = new CStoredProc("pr_V_GD_LUONG_THEO_QD_Search");
v_sp.addDecimalInputParam("@ip_dc_id_phap_nhan", ip_dc_id_phap_nhan);
v_sp.addNVarcharInputParam("@ip_str_keyword", ip_str_keyword);
v_sp.addNVarcharInputParam("@ip_str_luong_hien_tai", ip_bool_luong_hien_tai ? "Y" : "N");
v_sp.addDecimalInputParam("@ip_dc_id_ky", ip_dc_id_ky);
v_sp.addDecimalInputParam("@ip_dc_id_loai_luong", ip_dc_id_loai_luong);
DateTime v_dat;
// Chuyển thời gian về đầu ngày
v_dat = new DateTime(ip_dat_tu_ngay_ap_dung.Year, ip_dat_tu_ngay_ap_dung.Month, ip_dat_tu_ngay_ap_dung.Day, 0, 0, 0);
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay_ap_dung", v_dat);
// Chuyển thời gian về cuối ngày
v_dat = new DateTime(ip_dat_den_ngay_ap_dung.Year, ip_dat_den_ngay_ap_dung.Month, ip_dat_den_ngay_ap_dung.Day, 23, 59, 59);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay_ap_dung", v_dat);
v_sp.fillDataSetByCommand(this, op_ds);
}
private void load_data_2_grid()
{
m_ds = new DS_V_GD_LUONG_THEO_QD();
// Init id ky
Decimal v_id_ky;
try
{
v_id_ky = (Decimal)m_cbo_ky.SelectedValue;
}
catch (Exception)
{
v_id_ky = -1;
}
// Init id loai luong
Decimal v_id_loai_luong;
try
{
v_id_loai_luong = (Decimal)m_cbo_loai_luong.SelectedValue;
}
catch (Exception)
{
v_id_loai_luong = -1;
}
m_us.FillDatasetSearch(m_ds,
get_id_phap_nhan(),
m_txt_search.Text,
m_ckb_luong_hien_tai.Checked,
v_id_ky,
v_id_loai_luong,
m_dat_ap_dung_tu_ngay.Value, m_dat_ap_dung_den_ngay.Value);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
m_fg.Sort(SortFlags.Ascending, (Int32)e_col_Number.MA_NV);
m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count
, 0
, (int)e_col_Number.MA_NV
, (int)e_col_Number.LUONG
, "{0}"
);
m_fg.Redraw = true;
m_fg.Focus();
// Load grid trước thì mới có dữ liệu
load_data_2_suggest_txt();
}
public US_V_GD_LUONG_THEO_QD(decimal i_dbID)
{
pm_objDS = new DS_V_GD_LUONG_THEO_QD();
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]);
}
public US_V_GD_LUONG_THEO_QD()
{
pm_objDS = new DS_V_GD_LUONG_THEO_QD();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
