public US_DM_DAT(decimal i_dbID)
{
pm_objDS = new DS_DM_DAT();
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_grid(string ip_str_tu_khoa)
{
DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();
if (ip_str_tu_khoa.Equals(String.Empty))
{
m_us_dm_dat.FillDataset(v_ds_dm_dat);
}
else
{
CStoredProc v_cstore = new CStoredProc("pr_DM_DAT_Search");
v_cstore.addNVarcharInputParam("@TU_KHOA", ip_str_tu_khoa);
v_cstore.fillDataSetByCommand(m_us_dm_dat, v_ds_dm_dat);
}
m_grv_danh_sach_nha.DataSource = v_ds_dm_dat.DM_DAT;
m_grv_danh_sach_nha.DataBind();
}
private List<US_DM_DAT> get_top_dat(string ip_str_ten_ts, decimal ip_dc_id_dv_sd)
{
US_DM_DAT v_us_dm_dat = new US_DM_DAT();
DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();
v_ds_dm_dat.EnforceConstraints = false;
v_us_dm_dat.search_dat_by_dia_chi(v_ds_dm_dat, ip_str_ten_ts, ip_dc_id_dv_sd);
List<US_DM_DAT> v_list = new List<US_DM_DAT>();
for (int i = 0; i < v_ds_dm_dat.DM_DAT.Rows.Count; i++ )
{
US_DM_DAT v_us_temp = new US_DM_DAT();
v_us_temp.dcID = int.Parse(v_ds_dm_dat.DM_DAT.Rows[i][DM_DAT.ID].ToString());
v_us_temp.strDIA_CHI = v_ds_dm_dat.DM_DAT.Rows[i][DM_DAT.DIA_CHI].ToString();
v_list.Add(v_us_temp);
}
return v_list;
}
public static void load_data_to_cbo_dia_chi(
decimal ip_dc_bo_tinh
, decimal ip_dc_id_don_vi_chu_quan
, decimal ip_dc_id_don_vi_su_dung
, decimal ip_dc_id_trang_thai_dat
, eTAT_CA ip_e_tat_ca
, DropDownList op_obj_cbo_dia_chi_dat)
{
DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();
US_DM_DAT v_us_dm_dat = new US_DM_DAT();
string v_str_user_name = HttpContext.Current.Session[SESSION.UserName].ToString();
v_us_dm_dat.FillDatasetByID_DonVi(
ip_dc_bo_tinh
, ip_dc_id_don_vi_chu_quan
, ip_dc_id_don_vi_su_dung
, ip_dc_id_trang_thai_dat
, v_str_user_name
, v_ds_dm_dat);
op_obj_cbo_dia_chi_dat.DataSource = v_ds_dm_dat.DM_DAT;
op_obj_cbo_dia_chi_dat.DataTextField = DM_DAT.DIA_CHI;
op_obj_cbo_dia_chi_dat.DataValueField = DM_DAT.ID;
op_obj_cbo_dia_chi_dat.DataBind();
if (ip_e_tat_ca == eTAT_CA.YES)
{
op_obj_cbo_dia_chi_dat.Items.Insert(0, new ListItem(CONST_QLDB.TAT_CA, CONST_QLDB.ID_TAT_CA.ToString()));
}
}
public void search_dat_by_dia_chi(DS_DM_DAT op_ds_dm_dat, string ip_str_tu_khoa, decimal ip_dc_id_dv_su_dung)
{
CStoredProc v_cstore = new CStoredProc("pr_DM_DAT_Search_By_ten");
v_cstore.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_cstore.addDecimalInputParam("@ip_dc_id_dv_su_dung", ip_dc_id_dv_su_dung);
v_cstore.fillDataSetByCommand(this, op_ds_dm_dat);
}
public void FillDatasetByID_DonVi_Loai_hinh(
decimal ip_dc_id_bo_tinh
, decimal ip_dc_id_dv_chu_quan
, decimal ip_dc_id_dv_su_dung
, decimal ip_dc_id_trang_thai_dat
, string ip_str_loai_hinh_don_vi
, string ip_str_user_name
, DS_DM_DAT op_ds_dat)
{
CStoredProc v_obj_pr = new CStoredProc("pr_DM_DAT_search_by_id_don_vi_loai_hinh");
v_obj_pr.addDecimalInputParam("@ip_id_bo_tinh", ip_dc_id_bo_tinh);
v_obj_pr.addDecimalInputParam("@ip_id_dv_chu_quan", ip_dc_id_dv_chu_quan);
v_obj_pr.addDecimalInputParam("@ip_id_dv_su_dung", ip_dc_id_dv_su_dung);
v_obj_pr.addDecimalInputParam("@ip_dc_id_trang_thai_dat", ip_dc_id_trang_thai_dat);
v_obj_pr.addNVarcharInputParam("@ip_str_loai_hinh_don_vi", ip_str_loai_hinh_don_vi);
v_obj_pr.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
v_obj_pr.fillDataSetByCommand(this, op_ds_dat);
}
public bool check_ma_tai_san_is_valid(string ip_str_ma_tai_san)
{
US_DM_DAT v_us_dm_dat = new US_DM_DAT();
DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();
v_us_dm_dat.FillDataset(v_ds_dm_dat, "where " + DM_DAT.MA_TAI_SAN + " = '" + ip_str_ma_tai_san + "'");
if (v_ds_dm_dat.DM_DAT.Count == 0) return true;
return false;
}
public US_DM_DAT()
{
pm_objDS = new DS_DM_DAT();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
// done
private void load_data_to_cbo_dia_chi()
{
if (m_cbo_don_vi_su_dung.SelectedValue == null)
{
m_cbo_dia_chi.DataSource = null;
return;
}
DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();
US_DM_DAT v_us_dm_dat = new US_DM_DAT();
v_us_dm_dat.FillDataset(v_ds_dm_dat, "where " + DM_DAT.ID_DON_VI_SU_DUNG + " = " + CIPConvert.ToDecimal(m_cbo_don_vi_su_dung.SelectedValue));
m_cbo_dia_chi.DisplayMember = DM_DAT.DIA_CHI;
m_cbo_dia_chi.ValueMember = DM_DAT.ID;
m_cbo_dia_chi.SelectedValueChanged -= new EventHandler(m_cbo_bo_tinh_SelectedValueChanged);
m_cbo_dia_chi.DataSource = v_ds_dm_dat.DM_DAT;
m_cbo_don_vi_su_dung.SelectedValueChanged += new EventHandler(m_cbo_bo_tinh_SelectedValueChanged);
}
private void load_data_to_thong_tin_nha_dat()
{
try
{
string v_id_dat = CIPConvert.ToStr(m_cbo_dia_chi.SelectedValue);
DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();
US_DM_DAT v_us_dm_dat = new US_DM_DAT(CIPConvert.ToDecimal(v_id_dat));
m_lbl_dia_chi.Text = v_us_dm_dat.strDIA_CHI;
m_lbl_dien_tich_khuon_vien_dat.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_KHUON_VIEN, "#,##0.00") + " ";
m_lbl_lam_tru_so_lam_viec.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_TRU_SO_LAM_VIEC, "#,##0.00");
m_lbl_lam_nha_o.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_TRU_SO_LAM_VIEC, "#,##0.00");
m_lbl_lam_co_so_hd_su_nghiep.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_CO_SO_HOAT_DONG_SU_NGHIEP, "#,##0.00");
m_lbl_lam_nha_o.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_LAM_NHA_O, "#,##0.00");
m_lbl_cho_thue.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_CHO_THUE, "#,##0.00");
m_lbl_bo_trong.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_BO_TRONG, "#,##0.00");
m_lbl_bi_lan_chiem.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_BI_LAN_CHIEM, "#,##0.00");
m_lbl_su_dung_vao_muc_dich_khac.Text = CIPConvert.ToStr(v_us_dm_dat.dcDT_SU_DUNG_MUC_DICH_KHAC, "#,##0.00");
m_lbl_gia_tri_theo_so_ke_toan.Text = CIPConvert.ToStr(v_us_dm_dat.dcGT_THEO_SO_KE_TOAN, "#,##0.00");
}
catch (System.Exception ex)
{
CSystemLog_301.ExceptionHandle(ex);
}
}
