public US_V_DM_OTO(decimal i_dbID)
{
pm_objDS = new DS_V_DM_OTO();
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]);
}
private List<US_V_DM_OTO> get_top_dm_oto_by_name(string ip_str_oto_name, decimal ip_dc_id_dv_su_dung)
{
DS_V_DM_OTO v_ds_oto = new DS_V_DM_OTO();
US_V_DM_OTO v_us = new US_V_DM_OTO();
v_ds_oto.EnforceConstraints = false;
v_us.load_oto_by_ten(v_ds_oto, ip_str_oto_name, ip_dc_id_dv_su_dung);
if (v_ds_oto.V_DM_OTO.Rows.Count == 0) return null;
List<US_V_DM_OTO> v_teachers = new List<US_V_DM_OTO>();
if (v_ds_oto.V_DM_OTO.Rows.Count > 0)
for (int i = 0; i < v_ds_oto.V_DM_OTO.Rows.Count; i++)
{
US_V_DM_OTO v_oto = new US_V_DM_OTO();
v_oto.dcID = int.Parse(v_ds_oto.V_DM_OTO.Rows[i]["ID"].ToString());
v_oto.strTEN_TAI_SAN = v_ds_oto.V_DM_OTO.Rows[i][V_DM_OTO.TEN_TAI_SAN].ToString().TrimEnd();
v_teachers.Add(v_oto);
}
return v_teachers;
}
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);
}
}
public void load_oto_by_ten(DS_V_DM_OTO op_ds_oto, string ip_str_search, decimal ip_dc_id_dv_su_dung)
{
CStoredProc v_cstore = new CStoredProc("pr_V_DM_OTO_Search_by_Ten");
v_cstore.addNVarcharInputParam("@ip_str_ten_oto_search", ip_str_search);
v_cstore.addDecimalInputParam("@ip_dc_id_dv_su_dung", ip_dc_id_dv_su_dung);
v_cstore.fillDataSetByCommand(this, op_ds_oto);
}
public void FillDatasetLoadDataToGridOto_by_tu_khoa(
string ip_str_tu_khoa
, decimal ip_dc_id_bo_tinh
, decimal ip_dc_id_don_vi_chu_quan
, decimal ip_dc_id_don_vi_su_dung
, decimal ip_dc_id_trang_thai
, decimal ip_dc_id_loai_tai_san
, string ip_str_loai_hinh_don_vi
, string ip_str_user_name
, DS_V_DM_OTO op_ds_v_dm_oto)
{
CStoredProc v_obj_procedure = new CStoredProc("pr_V_DM_OTO_Load_data_to_grid_by_tu_khoa");
v_obj_procedure.addDecimalInputParam("@ip_dc_id_bo_tinh", ip_dc_id_bo_tinh);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_don_vi_chu_quan", ip_dc_id_don_vi_chu_quan);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_don_vi_su_dung", ip_dc_id_don_vi_su_dung);
v_obj_procedure.addNVarcharInputParam("@ip_str_loai_hinh_don_vi", ip_str_loai_hinh_don_vi);
v_obj_procedure.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_trang_thai", ip_dc_id_trang_thai);
v_obj_procedure.addDecimalInputParam("@ip_dc_id_loai_tai_san", ip_dc_id_loai_tai_san);
v_obj_procedure.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_obj_procedure.fillDataSetByCommand(this, op_ds_v_dm_oto);
}
public void FillDataset(
decimal ip_dc_bo_tinh
, decimal ip_dc_don_vi_chu_quan
, decimal ip_dc_don_vi_su_dung
, decimal ip_dc_id_loai_tai_san
, decimal ip_id_trang_thai
, string ip_str_tu_khoa
, string ip_str_user_name
, DS_V_DM_OTO op_ds_v_dm_oto)
{
CStoredProc v_obj_procedure = new CStoredProc("pr_V_DM_OTO_Search");
v_obj_procedure.addDecimalInputParam("@ip_id_bo_tinh", ip_dc_bo_tinh);
v_obj_procedure.addDecimalInputParam("@ip_id_dvql", ip_dc_don_vi_chu_quan);
v_obj_procedure.addDecimalInputParam("@ip_id_dvsd", ip_dc_don_vi_su_dung);
v_obj_procedure.addDecimalInputParam("@ip_id_loai_tai_san", ip_dc_id_loai_tai_san);
v_obj_procedure.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
v_obj_procedure.addDecimalInputParam("@ip_id_trang_thai", ip_id_trang_thai);
v_obj_procedure.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_obj_procedure.fillDataSetByCommand(this, op_ds_v_dm_oto);
}
public void FillDataset(
decimal ip_dc_don_vi_chu_quan
, decimal ip_dc_trang_thai
, DS_V_DM_OTO op_ds_v_oto)
{
IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(op_ds_v_oto, this.pm_strTableName);
v_obj_mak_cmd.AddCondition(
V_DM_OTO.ID_DON_VI_SU_DUNG
, ip_dc_don_vi_chu_quan
, eKieuDuLieu.KieuNumber
, eKieuSoSanh.Bang);
v_obj_mak_cmd.AddCondition(
V_DM_OTO.ID_TRANG_THAI
, ip_dc_trang_thai
, eKieuDuLieu.KieuNumber
, eKieuSoSanh.Bang);
SqlCommand v_obj_sql_cmd = v_obj_mak_cmd.getSelectCmd();
v_obj_sql_cmd.CommandText += " ORDER BY " + V_DM_OTO.ID_LOAI_TAI_SAN;
this.FillDatasetByCommand(op_ds_v_oto, v_obj_sql_cmd);
}
public US_V_DM_OTO()
{
pm_objDS = new DS_V_DM_OTO();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
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_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_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()
{
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();
}
