public US_GD_CAU_HOI_HOC_VIEN(decimal i_dbID)
{
pm_objDS = new DS_GD_CAU_HOI_HOC_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 US_V_RPT_420_BC_TAI_CHINH_THEO_LOP_MON_HS(decimal i_dbID)
{
pm_objDS = new DS_V_RPT_420_BC_TAI_CHINH_THEO_LOP_MON_HS();
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_V_F320_THONG_TIN_CHI_TIET_DANH_SACH_HOP_DONG_DA_KY_THEO_THOI_GIAN(decimal i_dbID)
{
pm_objDS = new DS_V_F320_THONG_TIN_CHI_TIET_DANH_SACH_HOP_DONG_DA_KY_THEO_THOI_GIAN();
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_V_F460_DANH_SACH_NHAN_VIEN_DANG_HOAT_DONG_O_CONG_TY(decimal i_dbID)
{
pm_objDS = new DS_V_F460_DANH_SACH_NHAN_VIEN_DANG_HOAT_DONG_O_CONG_TY();
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_CM_DM_LOAI_TD(string i_strMaLoaiTD)
{
pm_objDS = new DS_CM_DM_LOAI_TD();
pm_strTableName = c_TableName;
System.Data.SqlClient.SqlCommand v_cmd = default(System.Data.SqlClient.SqlCommand);
IMakeSelectCmd v_MakeSelCommand = default(IMakeSelectCmd);
v_MakeSelCommand = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_MakeSelCommand.AddCondition("MA_LOAI", i_strMaLoaiTD, eKieuDuLieu.KieuString, eKieuSoSanh.Bang);
v_cmd = v_MakeSelCommand.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmd);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
public bool isHaving_thong_tin_don_vi(decimal i_dbID_DON_VI)
{
pm_objDS = new DS_DM_THONG_TIN_DON_VI();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID_DON_VI", i_dbID_DON_VI, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
return (pm_objDS.Tables[0].Rows.Count != 0);
}
public void InitByID_DON_VI(decimal i_dbID_DON_VI)
{
pm_objDS = new DS_DM_THONG_TIN_DON_VI();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID_DON_VI", i_dbID_DON_VI, 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 bool InitUSWithIDIsOK(decimal ip_dc_id_don_vi)
{
pm_objDS = new DS_DM_DON_VI();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", ip_dc_id_don_vi, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
if (pm_objDS.Tables[pm_strTableName].Rows.Count == 0) return false ;
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
return true;
}
public void FillDataset(
decimal ip_dc_don_vi_chu_quan
, decimal ip_dc_trang_thai
, DS_V_DM_OTO op_ds_v_oto)
{
IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(op_ds_v_oto, this.pm_strTableName);
v_obj_mak_cmd.AddCondition(
V_DM_OTO.ID_DON_VI_SU_DUNG
, ip_dc_don_vi_chu_quan
, eKieuDuLieu.KieuNumber
, eKieuSoSanh.Bang);
v_obj_mak_cmd.AddCondition(
V_DM_OTO.ID_TRANG_THAI
, ip_dc_trang_thai
, eKieuDuLieu.KieuNumber
, eKieuSoSanh.Bang);
SqlCommand v_obj_sql_cmd = v_obj_mak_cmd.getSelectCmd();
v_obj_sql_cmd.CommandText += " ORDER BY " + V_DM_OTO.ID_LOAI_TAI_SAN;
this.FillDatasetByCommand(op_ds_v_oto, v_obj_sql_cmd);
}
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_USER_GROUP, i_dc_group_user_id, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
this.FillDatasetByCommand(i_ds, v_obj_mak_cmd.getSelectCmd());
}
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 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 "";
}