public DataTable Get(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_DiemThi_GetResult>(client.cDKQHT_DiemThi_Get(GlobalVar.MaXacThuc, pKQHT_DiemThiInfo)));
}
}
public List <KQHT_DiemThiInfo> GetList(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
List <KQHT_DiemThiInfo> oKQHT_DiemThiInfoList = new List <KQHT_DiemThiInfo>();
DataTable dtb = Get(pKQHT_DiemThiInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
oKQHT_DiemThiInfo.KQHT_DiemThiID = int.Parse(dtb.Rows[i]["KQHT_DiemThiID"].ToString());
oKQHT_DiemThiInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_DiemThiInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oKQHT_DiemThiInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oKQHT_DiemThiInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oKQHT_DiemThiInfo.LanThi = int.Parse(dtb.Rows[i]["LanThi"].ToString());
oKQHT_DiemThiInfo.Diem = double.Parse(dtb.Rows[i]["Diem"].ToString());
oKQHT_DiemThiInfo.LyDo = dtb.Rows[i]["LyDo"].ToString();
oKQHT_DiemThiInfo.IDHT_User = int.Parse(dtb.Rows[i]["IDHT_User"].ToString());
oKQHT_DiemThiInfo.NgayTao = DateTime.Parse(dtb.Rows[i]["NgayTao"].ToString());
oKQHT_DiemThiInfoList.Add(oKQHT_DiemThiInfo);
}
}
return(oKQHT_DiemThiInfoList);
}
public frmNhapDiemTheoSoPhach()
{
InitializeComponent();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
oBKQHT_DanhSachDuThi = new cBKQHT_DanhSachDuThi();
}
public void Delete(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DiemThiID", SqlDbType.Int, pKQHT_DiemThiInfo.KQHT_DiemThiID));
RunProcedure("sp_KQHT_DiemThi_Delete", colParam);
}
public DataTable Get(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DiemThiID", SqlDbType.Int, pKQHT_DiemThiInfo.KQHT_DiemThiID));
return(RunProcedureGet("sp_KQHT_DiemThi_Get", colParam));
}
public void Update(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
var client = new UnimOsServiceClient();
client.cDKQHT_DiemThi_Update(GlobalVar.MaXacThuc, pKQHT_DiemThiInfo);
client.Close();
mErrorMessage = oDKQHT_DiemThi.ErrorMessages;
mErrorNumber = oDKQHT_DiemThi.ErrorNumber;
}
public int Add(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
int ID = 0;
ID = oDKQHT_DiemThi.Add(pKQHT_DiemThiInfo);
mErrorMessage = oDKQHT_DiemThi.ErrorMessages;
mErrorNumber = oDKQHT_DiemThi.ErrorNumber;
return(ID);
}
public int Add(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_DiemThi_Add(GlobalVar.MaXacThuc, pKQHT_DiemThiInfo);
client.Close();
mErrorMessage = oDKQHT_DiemThi.ErrorMessages;
mErrorNumber = oDKQHT_DiemThi.ErrorNumber;
return(ID);
}
public frmNhapDiemTheoSoBDVaPhach()
{
InitializeComponent();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_ToChucThi = new cBKQHT_ToChucThi();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
cls = new clsDataTableHelper();
}
public void DeleteByInfo(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemThiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DiemThiInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemThiInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemThiInfo.HocKy));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DiemThiInfo.LanThi));
RunProcedure("sp_KQHT_DiemThi_DeleteByInfo", colParam);
}
public void ToInfo(ref KQHT_DiemThiInfo pKQHT_DiemThiInfo, DataRow dr)
{
pKQHT_DiemThiInfo.KQHT_DiemThiID = int.Parse(dr[pKQHT_DiemThiInfo.strKQHT_DiemThiID].ToString());
pKQHT_DiemThiInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DiemThiInfo.strIDSV_SinhVien].ToString());
pKQHT_DiemThiInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_DiemThiInfo.strIDDM_MonHoc].ToString());
pKQHT_DiemThiInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DiemThiInfo.strIDDM_NamHoc].ToString());
pKQHT_DiemThiInfo.HocKy = int.Parse(dr[pKQHT_DiemThiInfo.strHocKy].ToString());
pKQHT_DiemThiInfo.LanThi = int.Parse(dr[pKQHT_DiemThiInfo.strLanThi].ToString());
pKQHT_DiemThiInfo.Diem = double.Parse(dr[pKQHT_DiemThiInfo.strDiem].ToString());
pKQHT_DiemThiInfo.LyDo = dr[pKQHT_DiemThiInfo.strLyDo].ToString();
pKQHT_DiemThiInfo.IDHT_User = int.Parse(dr[pKQHT_DiemThiInfo.strIDHT_User].ToString());
pKQHT_DiemThiInfo.NgayTao = DateTime.Parse(dr[pKQHT_DiemThiInfo.strNgayTao].ToString());
}
public void ToDataRow(KQHT_DiemThiInfo pKQHT_DiemThiInfo, ref DataRow dr)
{
dr[pKQHT_DiemThiInfo.strKQHT_DiemThiID] = pKQHT_DiemThiInfo.KQHT_DiemThiID;
dr[pKQHT_DiemThiInfo.strIDSV_SinhVien] = pKQHT_DiemThiInfo.IDSV_SinhVien;
dr[pKQHT_DiemThiInfo.strIDDM_MonHoc] = pKQHT_DiemThiInfo.IDDM_MonHoc;
dr[pKQHT_DiemThiInfo.strIDDM_NamHoc] = pKQHT_DiemThiInfo.IDDM_NamHoc;
dr[pKQHT_DiemThiInfo.strHocKy] = pKQHT_DiemThiInfo.HocKy;
dr[pKQHT_DiemThiInfo.strLanThi] = pKQHT_DiemThiInfo.LanThi;
dr[pKQHT_DiemThiInfo.strDiem] = pKQHT_DiemThiInfo.Diem;
dr[pKQHT_DiemThiInfo.strLyDo] = pKQHT_DiemThiInfo.LyDo;
dr[pKQHT_DiemThiInfo.strIDHT_User] = pKQHT_DiemThiInfo.IDHT_User;
dr[pKQHT_DiemThiInfo.strNgayTao] = pKQHT_DiemThiInfo.NgayTao;
}
public frmNhapDiemThanhPhan()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_DiemThanhPhan = new cBKQHT_DiemThanhPhan();
pKQHT_DiemThanhPhanInfo = new KQHT_DiemThanhPhanInfo();
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
rdgTuDanhSach.Enabled = false;
}
public frmNhapDiemTheoLopHocLai()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBKQHT_DiemThanhPhan = new cBKQHT_DiemThanhPhan();
pKQHT_DiemThanhPhanInfo = new KQHT_DiemThanhPhanInfo();
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
oBKQHT_LopHocLai = new cBKQHT_LopHocLai();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
}
public void Update(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemThiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DiemThiInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemThiInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemThiInfo.HocKy));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DiemThiInfo.LanThi));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemThiInfo.Diem));
colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DiemThiInfo.LyDo));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DiemThiInfo.IDHT_User));
colParam.Add(CreateParam("@KQHT_DiemThiID", SqlDbType.Int, pKQHT_DiemThiInfo.KQHT_DiemThiID));
RunProcedure("sp_KQHT_DiemThi_Update", colParam);
}
public int Add(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemThiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DiemThiInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DiemThiInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DiemThiInfo.HocKy));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DiemThiInfo.LanThi));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemThiInfo.Diem));
colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DiemThiInfo.LyDo));
colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DiemThiInfo.IDHT_User));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pKQHT_DiemThiInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DiemThi_Add", colParam));
}
public void DeleteByInfo(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
oDKQHT_DiemThi.DeleteByInfo(pKQHT_DiemThiInfo);
mErrorMessage = oDKQHT_DiemThi.ErrorMessages;
mErrorNumber = oDKQHT_DiemThi.ErrorNumber;
}
public void Update(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
oDKQHT_DiemThi.Update(pKQHT_DiemThiInfo);
mErrorMessage = oDKQHT_DiemThi.ErrorMessages;
mErrorNumber = oDKQHT_DiemThi.ErrorNumber;
}
public DataTable Get(KQHT_DiemThiInfo pKQHT_DiemThiInfo)
{
return(oDKQHT_DiemThi.Get(pKQHT_DiemThiInfo));
}
