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 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_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 dm_grid2us_object(US_DM_CO_SO_DINH_MUC i_us
, int i_grid_row)
{
DataRow v_dr;
v_dr = (DataRow)m_grv_co_so_dinh_muc.Rows[i_grid_row].UserData;
m_obj_trans.GridRow2DataRow(i_grid_row, v_dr);
}
private void delete_v_dm_co_so_dinh_muc()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_co_so_dinh_muc)) return;
if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_co_so_dinh_muc, m_grv_co_so_dinh_muc.Row)) return;
if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return;
US_DM_CO_SO_DINH_MUC v_us = new US_DM_CO_SO_DINH_MUC();
dm_grid2us_object(v_us, m_grv_co_so_dinh_muc.Row);
try {
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
m_grv_co_so_dinh_muc.Rows.Remove(m_grv_co_so_dinh_muc.Row);
}
catch (Exception v_e) {
v_us.Rollback();
CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e,
new CDBClientDBExceptionInterpret());
v_objErrHandler.showErrorMessage();
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;
}
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 = "?";
}
}
