public List <KQHT_DanhSachDuThiInfo> GetList(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
{
List <KQHT_DanhSachDuThiInfo> oKQHT_DanhSachDuThiInfoList = new List <KQHT_DanhSachDuThiInfo>();
DataTable dtb = Get(pKQHT_DanhSachDuThiInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo();
oKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID = long.Parse(dtb.Rows[i]["KQHT_DanhSachDuThiID"].ToString());
oKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi = int.Parse(dtb.Rows[i]["IDKQHT_ToChucThi"].ToString());
oKQHT_DanhSachDuThiInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_DanhSachDuThiInfo.IDDM_PhongHoc = int.Parse(dtb.Rows[i]["IDDM_PhongHoc"].ToString());
oKQHT_DanhSachDuThiInfo.SoBaoDanh = int.Parse(dtb.Rows[i]["SoBaoDanh"].ToString());
oKQHT_DanhSachDuThiInfo.SoPhach = dtb.Rows[i]["SoPhach"].ToString();
oKQHT_DanhSachDuThiInfo.TuiThiSo = int.Parse(dtb.Rows[i]["TuiThiSo"].ToString());
oKQHT_DanhSachDuThiInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString();
oKQHT_DanhSachDuThiInfoList.Add(oKQHT_DanhSachDuThiInfo);
}
}
return(oKQHT_DanhSachDuThiInfoList);
}
public void Delete(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID));
RunProcedure("sp_KQHT_DanhSachDuThi_Delete", colParam);
}
public DataTable Get(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID));
return(RunProcedureGet("sp_KQHT_DanhSachDuThi_Get", colParam));
}
public int Add(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
{
int ID = 0;
ID = oDKQHT_DanhSachDuThi.Add(pKQHT_DanhSachDuThiInfo);
mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
return(ID);
}
public void ToInfo(ref KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo, DataRow dr)
{
pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID = long.Parse(dr[pKQHT_DanhSachDuThiInfo.strKQHT_DanhSachDuThiID].ToString());
pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDKQHT_ToChucThi].ToString());
pKQHT_DanhSachDuThiInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDSV_SinhVien].ToString());
pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDDM_PhongHoc].ToString());
pKQHT_DanhSachDuThiInfo.SoBaoDanh = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strSoBaoDanh].ToString());
pKQHT_DanhSachDuThiInfo.SoPhach = dr[pKQHT_DanhSachDuThiInfo.strSoPhach].ToString();
pKQHT_DanhSachDuThiInfo.TuiThiSo = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strTuiThiSo].ToString());
pKQHT_DanhSachDuThiInfo.GhiChu = dr[pKQHT_DanhSachDuThiInfo.strGhiChu].ToString();
}
public void ToDataRow(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo, ref DataRow dr)
{
dr[pKQHT_DanhSachDuThiInfo.strKQHT_DanhSachDuThiID] = pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID;
dr[pKQHT_DanhSachDuThiInfo.strIDKQHT_ToChucThi] = pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi;
dr[pKQHT_DanhSachDuThiInfo.strIDSV_SinhVien] = pKQHT_DanhSachDuThiInfo.IDSV_SinhVien;
dr[pKQHT_DanhSachDuThiInfo.strIDDM_PhongHoc] = pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc;
dr[pKQHT_DanhSachDuThiInfo.strSoBaoDanh] = pKQHT_DanhSachDuThiInfo.SoBaoDanh;
dr[pKQHT_DanhSachDuThiInfo.strSoPhach] = pKQHT_DanhSachDuThiInfo.SoPhach;
dr[pKQHT_DanhSachDuThiInfo.strTuiThiSo] = pKQHT_DanhSachDuThiInfo.TuiThiSo;
dr[pKQHT_DanhSachDuThiInfo.strGhiChu] = pKQHT_DanhSachDuThiInfo.GhiChu;
}
public void Update(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi));
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc));
colParam.Add(CreateParam("@SoBaoDanh", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.SoBaoDanh));
colParam.Add(CreateParam("@SoPhach", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.SoPhach));
colParam.Add(CreateParam("@TuiThiSo", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.TuiThiSo));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.GhiChu));
colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID));
RunProcedure("sp_KQHT_DanhSachDuThi_Update", colParam);
}
public int Add(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.LanThi));
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc));
colParam.Add(CreateParam("@SoBaoDanh", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.SoBaoDanh));
colParam.Add(CreateParam("@SoPhach", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.SoPhach));
colParam.Add(CreateParam("@TuiThiSo", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.TuiThiSo));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.GhiChu));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DanhSachDuThi_Add", colParam));
}
public frmToChucThi(int mIDKQHT_ToChucThi, int mIDDM_MonHoc, string TenMonHoc)
{
InitializeComponent();
IDKQHT_ToChucThi = mIDKQHT_ToChucThi;
IDDM_MonHoc = mIDDM_MonHoc;
txtTenMonHoc.Text = TenMonHoc;
oBDM_Lop = new cBDM_Lop();
oBDM_MonHoc = new cBDM_MonHoc();
oBKQHT_ToChucThi = new cBKQHT_ToChucThi();
pKQHT_ToChucThiInfo = new KQHT_ToChucThiInfo();
oBKQHT_DanhSachDuThi = new cBKQHT_DanhSachDuThi();
pKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo();
DataTable dt = (new cBDM_PhongHoc()).GetAll();
repositoryItemLookUpEditPhongThi.DataSource = dt;
dtpNgayThi.EditValue = DateTime.Today;
}
public frmToChucThi_TotNghiep(int mIDKQHT_ToChucThi, int mIDDM_MonHoc, DataTable dtMonHoc)
{
InitializeComponent();
IDKQHT_ToChucThi = mIDKQHT_ToChucThi;
cmbMonThiTotNghiep.Properties.DataSource = dtMonHoc;
cmbMonThiTotNghiep.EditValue = mIDDM_MonHoc;
cmbSapXepDanhSach.Properties.DataSource = bLoadSapXep();
oBDM_Lop = new cBDM_Lop();
oBDM_MonHoc = new cBDM_MonHoc();
oBKQHT_ToChucThi = new cBKQHT_ToChucThi();
pKQHT_ToChucThiInfo = new KQHT_ToChucThiInfo();
oBKQHT_DanhSachDuThi = new cBKQHT_DanhSachDuThi();
pKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo();
DataTable dt = (new cBDM_PhongHoc()).GetAll();
repositoryItemLookUpEditPhongThi.DataSource = dt;
dtpNgayThi.EditValue = DateTime.Today;
}
public void Update(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
{
oDKQHT_DanhSachDuThi.Update(pKQHT_DanhSachDuThiInfo);
mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber;
}
public DataTable Get(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo)
{
return(oDKQHT_DanhSachDuThi.Get(pKQHT_DanhSachDuThiInfo));
}
