public US_V_DM_TAI_SAN_KHAC(decimal i_dbID)
{
pm_objDS = new DS_V_DM_TAI_SAN_KHAC();
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 void load_data_to_ten_ts()
{
US_V_DM_TAI_SAN_KHAC v_us_v_dm_tai_san_khac = new US_V_DM_TAI_SAN_KHAC();
DS_V_DM_TAI_SAN_KHAC v_ds_v_dm_tai_san_khac = new DS_V_DM_TAI_SAN_KHAC();
v_us_v_dm_tai_san_khac.FillDataSetLoadDataToGridTaiSanKhac(
Person.get_user_name()
, 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)
, CIPConvert.ToDecimal(m_cbo_trang_thai_tai_san_up.SelectedValue)
, v_ds_v_dm_tai_san_khac);
m_cbo_ten_tai_san.DataSource = v_ds_v_dm_tai_san_khac.V_DM_TAI_SAN_KHAC;
m_cbo_ten_tai_san.DataTextField = V_DM_TAI_SAN_KHAC.TEN_TAI_SAN;
m_cbo_ten_tai_san.DataValueField = V_DM_TAI_SAN_KHAC.ID;
m_cbo_ten_tai_san.DataBind();
}
private void load_data_to_grid()
{
m_grv_danh_sach_tai_san_khac.Visible = true;
US_V_DM_TAI_SAN_KHAC m_us_v_tai_san_khac = new US_V_DM_TAI_SAN_KHAC();
DS_V_DM_TAI_SAN_KHAC m_ds_v_tai_san_khac = new DS_V_DM_TAI_SAN_KHAC();
US_DM_DON_VI m_us_don_vi = new US_DM_DON_VI();
DS_DM_DON_VI m_ds_don_vi = new DS_DM_DON_VI();
m_us_v_tai_san_khac.FillDataSetLoadDataToGridTaiSanKhacLoaiHinh(CIPConvert.ToStr(m_txt_tim_kiem.Text)
, CIPConvert.ToStr(m_cbo_loai_hinh_don_vi.SelectedValue)
, Person.get_user_name()
, CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_loai_tai_san.SelectedValue)
, m_ds_v_tai_san_khac);
m_lbl_title.Text = "DANH MỤC TÀI SẢN KHÁC (TRỪ TRỤ SỞ LÀM VIỆC, CƠ SỞ HOẠT ĐỘNG SỰ NGHIỆP VÀ XE Ô TÔ)";
string v_str_thong_tin = " (Có " + m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC.Rows.Count + " bản ghi)";
m_lbl_title.Text += v_str_thong_tin;
m_grv_danh_sach_tai_san_khac.DataSource = m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC;
m_grv_danh_sach_tai_san_khac.DataBind();
}
private void load_data_to_grid()
{
US_V_DM_TAI_SAN_KHAC m_us_v_tai_san_khac = new US_V_DM_TAI_SAN_KHAC();
DS_V_DM_TAI_SAN_KHAC m_ds_v_tai_san_khac = new DS_V_DM_TAI_SAN_KHAC();
US_DM_DON_VI m_us_don_vi = new US_DM_DON_VI();
DS_DM_DON_VI m_ds_don_vi = new DS_DM_DON_VI();
m_us_v_tai_san_khac.FillDatasetLoadDataToGridTaiSanKhac_by_tu_khoa(m_txt_tim_kiem.Text.Trim()
, CIPConvert.ToDecimal(m_cbo_bo_tinh.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_chu_quan.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_don_vi_su_dung_tai_san.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue)
, CIPConvert.ToStr(m_cbo_loai_hinh_don_vi.SelectedValue)
, Person.get_user_name()
, m_ds_v_tai_san_khac);
m_grv_danh_sach_tai_san_khac.DataSource = m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC;
string v_str_thong_tin = " (Có " + m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC.Rows.Count + " bản ghi)";
m_lbl_tieu_de.Text = "DANH SÁCH TÀI SẢN KHÁC";
m_lbl_tieu_de.Text += v_str_thong_tin;
m_grv_danh_sach_tai_san_khac.DataBind();
}
private void load_data_2_grid_tai_san_co_nguyen_gia_tren_500_trieu(CObjExcelAssetParameters op_obj_excel_parameters)
{
US_V_DM_TAI_SAN_KHAC v_us_v_dm_tai_san_khac = new US_V_DM_TAI_SAN_KHAC();
DS_V_DM_TAI_SAN_KHAC v_ds_v_dm_tai_san_khac = new DS_V_DM_TAI_SAN_KHAC();
v_us_v_dm_tai_san_khac.FillDatasetLoadDataToGridTaiSanCoNguyenGiaTren500_by_tu_khoa(
op_obj_excel_parameters.strKEY_SEARCH,
op_obj_excel_parameters.dcID_BO_TINH,
op_obj_excel_parameters.dcID_DON_VI_CHU_QUAN,
op_obj_excel_parameters.dcID_DON_VI_SU_DUNG,
op_obj_excel_parameters.dcID_TRANG_THAI_TAI_SAN,
op_obj_excel_parameters.strMA_LOAI_HINH_DON_VI,
op_obj_excel_parameters.strUSER_NAME,
v_ds_v_dm_tai_san_khac);
m_fg.Redraw = false;
CGridUtils.Dataset2C1Grid(v_ds_v_dm_tai_san_khac, m_fg, m_obj_trans);
m_fg.Redraw = true;
}
private List<US_V_DM_TAI_SAN_KHAC> get_top_dm_tai_san_khac(string ip_str_ten_ts, decimal ip_dc_id_ts)
{
DS_V_DM_TAI_SAN_KHAC v_ds_v_dm_ts_khac = new DS_V_DM_TAI_SAN_KHAC();
US_V_DM_TAI_SAN_KHAC v_us_v_dm_ts_khac = new US_V_DM_TAI_SAN_KHAC();
v_ds_v_dm_ts_khac.EnforceConstraints = false;
v_us_v_dm_ts_khac.search_by_name(v_ds_v_dm_ts_khac, ip_str_ten_ts, ip_dc_id_ts);
List<US_V_DM_TAI_SAN_KHAC> v_list = new List<US_V_DM_TAI_SAN_KHAC>();
for (int i = 0; i < v_ds_v_dm_ts_khac.V_DM_TAI_SAN_KHAC.Rows.Count; i++)
{
US_V_DM_TAI_SAN_KHAC v_us_temp = new US_V_DM_TAI_SAN_KHAC();
v_us_temp.dcID = int.Parse(v_ds_v_dm_ts_khac.V_DM_TAI_SAN_KHAC.Rows[i][V_DM_TAI_SAN_KHAC.ID].ToString());
v_us_temp.strTEN_TAI_SAN = v_ds_v_dm_ts_khac.V_DM_TAI_SAN_KHAC.Rows[i][V_DM_TAI_SAN_KHAC.TEN_TAI_SAN].ToString().TrimEnd();
v_list.Add(v_us_temp);
}
return v_list;
}
private void load_data_2_grid()
{
US_V_DM_TAI_SAN_KHAC m_us_v_tai_san_khac = new US_V_DM_TAI_SAN_KHAC();
DS_V_DM_TAI_SAN_KHAC m_ds_v_tai_san_khac = new DS_V_DM_TAI_SAN_KHAC();
m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC.Clear();
m_us_v_tai_san_khac.FillDatasetLoadDataToGridTaiSanKhac_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.ToString()
, Person.get_user_name()
, m_ds_v_tai_san_khac);
m_grv_tai_san_khac.DataSource = m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC;
string v_str_thong_tin = " (Có " + m_ds_v_tai_san_khac.V_DM_TAI_SAN_KHAC.Rows.Count + " bản ghi)";
m_lbl_title.Text = "DANH SÁCH TÀI SẢN KHÁC";
m_lbl_title.Text += v_str_thong_tin;
m_grv_tai_san_khac.DataBind();
}
public void search_by_name(
DS_V_DM_TAI_SAN_KHAC op_ds_v_dm_tai_san_khac
, string ip_str_name
, decimal ip_dc_don_vi_su_dung)
{
CStoredProc v_obj_procedure = new CStoredProc("pr_V_DM_TAI_SAN_KHAC_Search_by_name");
v_obj_procedure.addDecimalInputParam("@ip_dc_id_dv_su_dung", ip_dc_don_vi_su_dung);
v_obj_procedure.addNVarcharInputParam("@ip_str_ten", ip_str_name);
v_obj_procedure.fillDataSetByCommand(this, op_ds_v_dm_tai_san_khac);
}
public void FillDatasetLoadDataToGridTaiSanKhac_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
, string ip_str_loai_hinh_don_vi
, string ip_str_user_name
, DS_V_DM_TAI_SAN_KHAC op_dat_v_dm_tai_san_khac)
{
CStoredProc v_obj_procedure = new CStoredProc("pr_V_DM_TAI_SAN_KHAC_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.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_obj_procedure.fillDataSetByCommand(this, op_dat_v_dm_tai_san_khac);
}
public void FillDataSetLoadDataToGridTaiSanCoNguyenGiaTren500TrieuLoaiHinh(
string ip_str_loai_hinh_don_vi
, string ip_str_user_name
, 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
, DS_V_DM_TAI_SAN_KHAC op_dat_v_dm_tai_san_khac)
{
CStoredProc v_obj_procedure = new CStoredProc("pr_V_DM_TAI_SAN_KHAC_Load_data_to_grid_tai_san_co_nguyen_gia_tren_500_trieu_loai_hinh");
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.addDecimalInputParam("@ip_dc_id_trang_thai", ip_dc_id_trang_thai);
v_obj_procedure.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
v_obj_procedure.addNVarcharInputParam("@ip_str_loai_hinh_don_vi", ip_str_loai_hinh_don_vi);
v_obj_procedure.fillDataSetByCommand(this, op_dat_v_dm_tai_san_khac);
}
public void FillDataset(
decimal ip_dc_don_vi_chu_quan
, decimal ip_dc_trang_thai
, DS_V_DM_TAI_SAN_KHAC op_ds_v_tai_san_khac)
{
IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(op_ds_v_tai_san_khac, this.pm_strTableName);
v_obj_mak_cmd.AddCondition(
V_DM_TAI_SAN_KHAC.ID_DON_VI_SU_DUNG
, ip_dc_don_vi_chu_quan
, eKieuDuLieu.KieuNumber
, eKieuSoSanh.Bang);
v_obj_mak_cmd.AddCondition(
V_DM_TAI_SAN_KHAC.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_TAI_SAN_KHAC.ID_LOAI_TAI_SAN;
this.FillDatasetByCommand(op_ds_v_tai_san_khac, v_obj_sql_cmd);
}
public US_V_DM_TAI_SAN_KHAC()
{
pm_objDS = new DS_V_DM_TAI_SAN_KHAC();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
