public void FillDatasetByQueryString(
WebDS.DS_DM_DON_VI op_ds_don_vi
, string v_dc_id_loai_don_vi)
{
CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_grid");
cstored.addDecimalInputParam("@ID_LOAI_DON_VI", v_dc_id_loai_don_vi);
cstored.fillDataSetByCommand(this, op_ds_don_vi);
}
public void FillDatasetSearch(WebDS.DS_DM_OTO m_ds_dm_oto, string v_str_tu_khoa, string v_str_query)
{
CStoredProc cstored = new CStoredProc("pr_DM_OTO_get_search");
cstored.addNVarcharInputParam("@TU_KHOA", v_str_tu_khoa);
cstored.addNVarcharInputParam("@QUERY",v_str_query);
cstored.fillDataSetByCommand(this, m_ds_dm_oto);
}
/// <summary>
///
/// </summary>
/// <param name="op_ds_don_vi"></param>
/// <param name="ip_dc_id_loai_don_vi"></param>
/// <param name="ip_dc_id_don_vi"></param>
/// <param name="ip_dc_id_don_vi_cap_tren1"></param>
/// <param name="ip_dc_id_don_vi_cap_tren2"></param>
/// <param name="ip_str_user_name"></param>
public void FillDataset(
WebDS.DS_DM_DON_VI op_ds_don_vi
, decimal ip_dc_id_loai_don_vi
, decimal ip_dc_id_don_vi_cap_tren1
, decimal ip_dc_id_don_vi_cap_tren2
, string ip_str_user_name)
{
CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_Select_by_user_name");
cstored.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
cstored.addDecimalInputParam("@ip_dc_loai_don_vi", ip_dc_id_loai_don_vi);
cstored.addDecimalInputParam("@ip_dc_id_dv_cap_tren1", ip_dc_id_don_vi_cap_tren1);
cstored.addDecimalInputParam("@ip_dc_id_dv_cap_tren2", ip_dc_id_don_vi_cap_tren2);
cstored.fillDataSetByCommand(this, op_ds_don_vi);
}
public void FillDatasetBySearch(WebDS.DS_DM_OTO m_ds_dm_oto,
string v_str_tu_khoa,
decimal v_dc_id_trang_thai,
decimal v_dc_id_dv_bo_tinh,
decimal v_dc_id_dv_quan_ly,
decimal v_dc_id_dv_su_dung)
{
CStoredProc cstored = new CStoredProc("pr_DM_OTO_Search");
cstored.addNVarcharInputParam("@TU_KHOA", v_str_tu_khoa);
cstored.addDecimalInputParam("@ID_TRANG_THAI", v_dc_id_trang_thai);
cstored.addDecimalInputParam("@ID_DV_SU_DUNG", v_dc_id_dv_su_dung);
cstored.addDecimalInputParam("@ID_DV_QUAN_LY",v_dc_id_dv_quan_ly);
cstored.addDecimalInputParam("@ID_DV_BO_TINH", v_dc_id_dv_bo_tinh);
cstored.fillDataSetByCommand(this, m_ds_dm_oto);
}