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); } }