private void load_data_to_grid()
{
try
{
m_lbl_ket_qua_loc_du_lieu.Text = "DANH SÁCH Ô TÔ";
// Đổ dữ liệu từ US vào DS
US_V_DM_OTO v_us_v_dm_oto = new US_V_DM_OTO();
DS_V_DM_OTO v_ds_v_dm_oto = new DS_V_DM_OTO();
v_us_v_dm_oto.FillDatasetLoadDataToGridOto_by_tu_khoa(
m_txt_tim_kiem.Text.Trim()
, CONST_QLDB.ID_TAT_CA
, CONST_QLDB.ID_TAT_CA
, CONST_QLDB.ID_TAT_CA
, CONST_QLDB.ID_TAT_CA
, CONST_QLDB.ID_TAT_CA
, CONST_QLDB.MA_TAT_CA
, Person.get_user_name()
, v_ds_v_dm_oto);
// Treo dữ liệu lên lưới
string v_str_thong_tin = " (Có " + v_ds_v_dm_oto.V_DM_OTO.Rows.Count + " bản ghi)";
m_lbl_ket_qua_loc_du_lieu.Text += v_str_thong_tin;
m_grv_dm_oto.DataSource = v_ds_v_dm_oto.V_DM_OTO;
m_grv_dm_oto.DataBind();
}
catch (Exception v_e)
{
//nhớ using Ip.Common
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
protected void m_grv_bao_cao_oto_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
m_grv_bao_cao_oto.PageIndex = e.NewPageIndex;
System.Threading.Thread.Sleep(1000);
string v_str_user_name = Person.get_user_name();
if (v_str_user_name.Equals(null)) return;
US_V_DM_OTO v_us_v_dm_oto = new US_V_DM_OTO();
DS_V_DM_OTO v_ds_v_dm_oto = new DS_V_DM_OTO();
v_us_v_dm_oto.FillDatasetLoadDataToGridOto_by_tu_khoa(
m_txt_tu_khoa.Text.Trim()
, CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_quan_ly.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_su_dung.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_loai_xe.SelectedValue)
, m_cbo_loai_hinh_don_vi.SelectedValue
, v_str_user_name
, v_ds_v_dm_oto
);
m_grv_bao_cao_oto.DataSource = v_ds_v_dm_oto.V_DM_OTO;
m_grv_bao_cao_oto.DataBind();
}
catch (System.Exception ex)
{
CSystemLog_301.ExceptionHandle(this, ex);
}
}
private void load_data_to_ten_tai_san()
{
DS_V_DM_OTO v_ds_v_dm_oto = new DS_V_DM_OTO();
US_V_DM_OTO v_us_v_dm_oto = new US_V_DM_OTO();
v_us_v_dm_oto.FillDatasetLoadDataToGridOto_by_tu_khoa(
String.Empty
, CIPConvert.ToDecimal(m_cbo_bo_tinh_up.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan_up.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san_up.SelectedValue)
, ID_TRANG_THAI_OTO.DANG_SU_DUNG
, CIPConvert.ToDecimal(m_cbo_loai_o_to_up.SelectedValue)
, CONST_QLDB.MA_TAT_CA
, Person.get_user_name()
, v_ds_v_dm_oto);
m_cbo_ten_tai_san.DataSource = v_ds_v_dm_oto.V_DM_OTO;
m_cbo_ten_tai_san.DataTextField = V_DM_OTO.TEN_TAI_SAN;
m_cbo_ten_tai_san.DataValueField = V_DM_OTO.ID;
m_cbo_ten_tai_san.DataBind();
}
private void load_data_to_grid_oto()
{
reset_thong_bao();
m_lbl_thong_tin_oto.Text = "DANH SÁCH Ô TÔ";
if (!check_validate_data_is_ok()) return;
string v_str_user_name = Person.get_user_name();
if (v_str_user_name.Equals(null)) return;
US_V_DM_OTO v_us_v_dm_oto = new US_V_DM_OTO();
DS_V_DM_OTO v_ds_v_dm_oto = new DS_V_DM_OTO();
v_us_v_dm_oto.FillDatasetLoadDataToGridOto_by_tu_khoa(
m_txt_tu_khoa.Text.Trim()
, CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_quan_ly.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_su_dung.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_loai_xe.SelectedValue)
, m_cbo_loai_hinh_don_vi.SelectedValue
, v_str_user_name
, v_ds_v_dm_oto
);
m_grv_bao_cao_oto.DataSource = v_ds_v_dm_oto.V_DM_OTO;
if (v_ds_v_dm_oto.V_DM_OTO.Count == 0) thong_bao("Không có kết quả tìm kiếm phù hợp!");
System.Threading.Thread.Sleep(1000);
string v_str_thong_tin = " (Có " + v_ds_v_dm_oto.V_DM_OTO.Rows.Count + " bản ghi)";
m_lbl_thong_tin_oto.Text += v_str_thong_tin;
m_grv_bao_cao_oto.DataBind();
m_grv_bao_cao_oto.Visible = true;
}
private void load_data_to_grid()
{
m_lbl_ket_qua_loc_du_lieu.Text = "Kết quả lọc dữ liệu";
US_V_DM_OTO v_us_v_dm_oto = new US_V_DM_OTO();
DS_V_DM_OTO v_ds_v_dm_oto = new DS_V_DM_OTO();
v_us_v_dm_oto.FillDatasetLoadDataToGridOto_by_tu_khoa(
m_txt_tim_kiem.Text.Trim()
, CIPConvert.ToDecimal(m_ddl_bo_tinh.SelectedValue)
, CIPConvert.ToDecimal(m_ddl_dv_chu_quan.SelectedValue)
, CIPConvert.ToDecimal(m_ddl_dv_sd_ts.SelectedValue)
, CIPConvert.ToDecimal(m_ddl_trang_thai_oto.SelectedValue)
, CONST_QLDB.ID_TAT_CA
, CONST_QLDB.MA_TAT_CA
, Person.get_user_name()
, v_ds_v_dm_oto);
string v_str_thong_tin = " (Có " + v_ds_v_dm_oto.V_DM_OTO.Rows.Count + " bản ghi)";
m_lbl_ket_qua_loc_du_lieu.Text += v_str_thong_tin;
m_grv_dm_oto.DataSource = v_ds_v_dm_oto.V_DM_OTO;
m_grv_dm_oto.DataBind();
}
