public void FillDatasetByUserID(decimal i_dc_user_id
, DS_HT_QUYEN_USER i_ds)
{
IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(i_ds, i_ds.HT_QUYEN_USER.TableName);
v_obj_mak_cmd.AddCondition("ID_USER", i_dc_user_id, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
this.FillDatasetByCommand(i_ds, v_obj_mak_cmd.getSelectCmd());
}
public void FillDatasetByGroupUserID(decimal i_dc_group_user_id
, DS_HT_PHAN_QUYEN_CHO_NHOM i_ds)
{
IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(i_ds, i_ds.HT_PHAN_QUYEN_CHO_NHOM.TableName);
v_obj_mak_cmd.AddCondition(HT_PHAN_QUYEN_CHO_NHOM.ID_NHOM_NGUOI_SU_DUNG, i_dc_group_user_id, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
this.FillDatasetByCommand(i_ds, v_obj_mak_cmd.getSelectCmd());
}
public US_DM_DON_VI(decimal i_dbID)
{
pm_objDS = new DS_DM_DON_VI();
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]);
}
public US_RPT_BAO_CAO_THONG_KE_SO_TIEN_THANH_TOAN_HD_GIANG_VIEN(decimal i_dbID)
{
pm_objDS = new DS_RPT_BAO_CAO_THONG_KE_SO_TIEN_THANH_TOAN_HD_GIANG_VIEN();
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]);
}
public string get_station_id_by_user(decimal i_dc_user_id)
{
DS_DM_NGUOI_DUNG_STATION v_ds = new DS_DM_NGUOI_DUNG_STATION();
IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(v_ds, v_ds.DM_NGUOI_DUNG_STATION.TableName);
v_obj_mak_cmd.AddCondition(DM_NGUOI_DUNG_STATION.ID_NGUOI_DUNG, i_dc_user_id, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
this.FillDatasetByCommand(v_ds, v_obj_mak_cmd.getSelectCmd());
if (v_ds.DM_NGUOI_DUNG_STATION.Rows.Count > 0)
{
return(CIPConvert.ToStr(v_ds.DM_NGUOI_DUNG_STATION[0][DM_NGUOI_DUNG_STATION.STATION_CODE]));
}
else
{
return("");
}
}
public bool check_trung_ma_lop_mon(string i_str_ma_lop_mon)
{
try {
DS_GD_LOP_MON v_ds = new DS_GD_LOP_MON();
IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(v_ds, v_ds.GD_LOP_MON.TableName);
v_obj_mak_cmd.AddCondition("MA_LOP_MON", i_str_ma_lop_mon, eKieuDuLieu.KieuString, eKieuSoSanh.Bang);
this.FillDatasetByCommand(v_ds, v_obj_mak_cmd.getSelectCmd());
if (v_ds.GD_LOP_MON.Rows.Count > 0)
{
//this.DataRow2Me(v_ds.GD_LOP_MON.Rows[0]);
return(true);
}
return(false);
}
catch (Exception v_e) {
throw v_e;
}
}
