public US_DM_CO_SO_DINH_MUC(decimal i_dbID) { pm_objDS = new DS_DM_CO_SO_DINH_MUC(); 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_2_cbo_co_so_dm() { US_DM_CO_SO_DINH_MUC v_us = new US_DM_CO_SO_DINH_MUC(); DS_DM_CO_SO_DINH_MUC v_ds = new DS_DM_CO_SO_DINH_MUC(); v_us.FillDataset(v_ds); m_cbo_co_so_dm.ValueMember = DM_CO_SO_DINH_MUC.ID; m_cbo_co_so_dm.DisplayMember = DM_CO_SO_DINH_MUC.MA_CO_SO_DINH_MUC; m_cbo_co_so_dm.DataSource = v_ds.DM_CO_SO_DINH_MUC; }
private bool validate_ma_update(string ip_str_ma, decimal ip_dc_id) { US_DM_CO_SO_DINH_MUC v_us = new US_DM_CO_SO_DINH_MUC(); DS_DM_CO_SO_DINH_MUC v_ds = new DS_DM_CO_SO_DINH_MUC(); v_us.FillDataset(v_ds, "where ma_co_so_dinh_muc='" + ip_str_ma + "' or id=" + ip_dc_id); if (v_ds.DM_CO_SO_DINH_MUC.Count != 1) return false; return true; }
private bool validate_ma_insert(string v_str_ma) { US_DM_CO_SO_DINH_MUC v_us= new US_DM_CO_SO_DINH_MUC(); DS_DM_CO_SO_DINH_MUC v_ds = new DS_DM_CO_SO_DINH_MUC(); v_us.FillDataset(v_ds, "where ma_co_so_dinh_muc='" + v_str_ma + "'"); if (v_ds.DM_CO_SO_DINH_MUC.Count != 0 && m_e_form_mode == DataEntryFormMode.InsertDataState) return false; return true; }
private void load_cbo_co_tinh_dinh_muc(decimal ip_id_loai_dinh_muc) { m_cbo_co_so_tinh_dm.ResetText(); US_DM_CO_SO_DINH_MUC v_us = new US_DM_CO_SO_DINH_MUC(); DS_DM_CO_SO_DINH_MUC v_ds = new DS_DM_CO_SO_DINH_MUC(); v_us.FillDataset(v_ds, "where id_loai_dinh_muc= " + ip_id_loai_dinh_muc); m_cbo_co_so_tinh_dm.DataSource = v_ds.DM_CO_SO_DINH_MUC; m_cbo_co_so_tinh_dm.ValueMember = DM_CO_SO_DINH_MUC.ID; m_cbo_co_so_tinh_dm.DisplayMember = DM_CO_SO_DINH_MUC.TEN_CO_SO_DINH_MUC; //DataRow v_dr = v_ds.DM_CO_SO_DINH_MUC.NewRow(); //v_dr[DM_CO_SO_DINH_MUC.ID] = -1; //v_dr[DM_CO_SO_DINH_MUC.TEN_CO_SO_DINH_MUC] = "Tất cả"; //v_dr[DM_CO_SO_DINH_MUC.MA_CO_SO_DINH_MUC] = ""; //v_dr[DM_CO_SO_DINH_MUC.ID_LOAI_CO_SO_DINH_MUC] = -1; //v_ds.DM_CO_SO_DINH_MUC.Rows.InsertAt(v_dr, 0); //m_cbo_co_so_tinh_dm.SelectedIndex = 0; }
public US_DM_CO_SO_DINH_MUC() { pm_objDS = new DS_DM_CO_SO_DINH_MUC(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
private void load_so_luong_nhan_su() { decimal v_tong_dinh_muc; US_V_GD_THONG_KE v_us = new US_V_GD_THONG_KE(); DS_V_GD_THONG_KE v_ds = new DS_V_GD_THONG_KE(); US_DM_CO_SO_DINH_MUC v_us_cs_dm = new US_DM_CO_SO_DINH_MUC(); DS_DM_CO_SO_DINH_MUC v_ds_cs_dm = new DS_DM_CO_SO_DINH_MUC(); v_us.FillDataset(v_ds,CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value)); if (v_ds.Tables[0].Rows.Count > 0) { m_lbl_tong_nhan_su.Text = v_ds.Tables[0].Rows[0]["GIA_TRI_THONG_KE"].ToString() +" ("+ v_ds.Tables[0].Rows[0]["TEN"].ToString() + ")"; v_us_cs_dm.FillDataset(v_ds_cs_dm, "where ID =" + CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID_CO_SO_DINH_MUC"])); m_lbl_dinh_muc_dau_nguoi.Text = CIPConvert.ToStr(v_ds_cs_dm.Tables[0].Rows[0]["DON_GIA_DINH_MUC"], "#,##0") +" (VNĐ)" + "/" + v_ds.Tables[0].Rows[0]["TEN"].ToString(); v_tong_dinh_muc = (CIPConvert.ToDecimal(v_ds_cs_dm.Tables[0].Rows[0]["DON_GIA_DINH_MUC"])) * (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["GIA_TRI_THONG_KE"])); m_lbl_tong_dinh_muc.Text = v_tong_dinh_muc.ToString("#,##0") + " (VNĐ)"; } else { m_lbl_tong_nhan_su.Text = "?"; m_lbl_dinh_muc_dau_nguoi.Text = "?"; m_lbl_tong_dinh_muc.Text = "?"; } }