public List <KQHT_DiemMonThiTotNghiepInfo> GetList(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo)
{
List <KQHT_DiemMonThiTotNghiepInfo> oKQHT_DiemMonThiTotNghiepInfoList = new List <KQHT_DiemMonThiTotNghiepInfo>();
DataTable dtb = Get(pKQHT_DiemMonThiTotNghiepInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
pKQHT_DiemMonThiTotNghiepInfo = new KQHT_DiemMonThiTotNghiepInfo();
pKQHT_DiemMonThiTotNghiepInfo.KQHT_DiemMonThiTotNghiepID = long.Parse(dtb.Rows[i][pKQHT_DiemMonThiTotNghiepInfo.strKQHT_DiemMonThiTotNghiepID].ToString());
pKQHT_DiemMonThiTotNghiepInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i][pKQHT_DiemMonThiTotNghiepInfo.strIDSV_SinhVien].ToString());
pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_MonThiTotNghiep_Lop = int.Parse(dtb.Rows[i][pKQHT_DiemMonThiTotNghiepInfo.strIDKQHT_MonThiTotNghiep_Lop].ToString());
pKQHT_DiemMonThiTotNghiepInfo.LanThi = int.Parse(dtb.Rows[i][pKQHT_DiemMonThiTotNghiepInfo.strLanThi].ToString());
pKQHT_DiemMonThiTotNghiepInfo.Diem = double.Parse(dtb.Rows[i][pKQHT_DiemMonThiTotNghiepInfo.strDiem].ToString());
if ("" + dtb.Rows[i][pKQHT_DiemMonThiTotNghiepInfo.strIDKQHT_XepLoai] != "")
{
pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_XepLoai = int.Parse(dtb.Rows[i][pKQHT_DiemMonThiTotNghiepInfo.strIDKQHT_XepLoai].ToString());
}
oKQHT_DiemMonThiTotNghiepInfoList.Add(pKQHT_DiemMonThiTotNghiepInfo);
}
}
return(oKQHT_DiemMonThiTotNghiepInfoList);
}
public void Delete(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DiemMonThiTotNghiepID", SqlDbType.BigInt, pKQHT_DiemMonThiTotNghiepInfo.KQHT_DiemMonThiTotNghiepID));
RunProcedure("sp_KQHT_DiemMonThiTotNghiep_Delete", colParam);
}
public DataTable Get(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DiemMonThiTotNghiepID", SqlDbType.BigInt, pKQHT_DiemMonThiTotNghiepInfo.KQHT_DiemMonThiTotNghiepID));
return(RunProcedureGet("sp_KQHT_DiemMonThiTotNghiep_Get", colParam));
}
public frmNhapDiemThiTotNghiepTheoPhach()
{
InitializeComponent();
oBKQHT_ToChucThi = new cBKQHT_ToChucThi();
oBKQHT_DanhSachDuThi = new cBKQHT_DanhSachDuThi();
oBKQHT_DiemMonThiTotNghiep = new cBKQHT_DiemMonThiTotNghiep();
pKQHT_DiemMonThiTotNghiepInfo = new KQHT_DiemMonThiTotNghiepInfo();
cls = new clsDataTableHelper();
}
public void ToDataRow(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo, ref DataRow dr)
{
dr[pKQHT_DiemMonThiTotNghiepInfo.strKQHT_DiemMonThiTotNghiepID] = pKQHT_DiemMonThiTotNghiepInfo.KQHT_DiemMonThiTotNghiepID;
dr[pKQHT_DiemMonThiTotNghiepInfo.strIDSV_SinhVien] = pKQHT_DiemMonThiTotNghiepInfo.IDSV_SinhVien;
dr[pKQHT_DiemMonThiTotNghiepInfo.strIDKQHT_MonThiTotNghiep_Lop] = pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_MonThiTotNghiep_Lop;
dr[pKQHT_DiemMonThiTotNghiepInfo.strLanThi] = pKQHT_DiemMonThiTotNghiepInfo.LanThi;
dr[pKQHT_DiemMonThiTotNghiepInfo.strDiem] = pKQHT_DiemMonThiTotNghiepInfo.Diem;
dr[pKQHT_DiemMonThiTotNghiepInfo.strIDKQHT_XepLoai] = pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_XepLoai;
}
public long Add(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo)
{
long ID = 0;
ID = oDKQHT_DiemMonThiTotNghiep.Add(pKQHT_DiemMonThiTotNghiepInfo);
mErrorMessage = oDKQHT_DiemMonThiTotNghiep.ErrorMessages;
mErrorNumber = oDKQHT_DiemMonThiTotNghiep.ErrorNumber;
return(ID);
}
public void ToInfo(ref KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo, DataRow dr)
{
pKQHT_DiemMonThiTotNghiepInfo.KQHT_DiemMonThiTotNghiepID = long.Parse(dr[pKQHT_DiemMonThiTotNghiepInfo.strKQHT_DiemMonThiTotNghiepID].ToString());
pKQHT_DiemMonThiTotNghiepInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DiemMonThiTotNghiepInfo.strIDSV_SinhVien].ToString());
pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_MonThiTotNghiep_Lop = int.Parse(dr[pKQHT_DiemMonThiTotNghiepInfo.strIDKQHT_MonThiTotNghiep_Lop].ToString());
pKQHT_DiemMonThiTotNghiepInfo.LanThi = int.Parse(dr[pKQHT_DiemMonThiTotNghiepInfo.strLanThi].ToString());
pKQHT_DiemMonThiTotNghiepInfo.Diem = double.Parse(dr[pKQHT_DiemMonThiTotNghiepInfo.strDiem].ToString());
if ("" + dr[pKQHT_DiemMonThiTotNghiepInfo.strIDKQHT_XepLoai] != "")
{
pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_XepLoai = int.Parse(dr[pKQHT_DiemMonThiTotNghiepInfo.strIDKQHT_XepLoai].ToString());
}
}
public void Update(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDKQHT_MonThiTotNghiep_Lop", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_MonThiTotNghiep_Lop));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.LanThi));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemMonThiTotNghiepInfo.Diem));
colParam.Add(CreateParam("@IDKQHT_XepLoai", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_XepLoai));
colParam.Add(CreateParam("@KQHT_DiemMonThiTotNghiepID", SqlDbType.BigInt, pKQHT_DiemMonThiTotNghiepInfo.KQHT_DiemMonThiTotNghiepID));
RunProcedure("sp_KQHT_DiemMonThiTotNghiep_Update", colParam);
}
public long Add(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDKQHT_MonThiTotNghiep_Lop", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_MonThiTotNghiep_Lop));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.LanThi));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemMonThiTotNghiepInfo.Diem));
colParam.Add(CreateParam("@IDKQHT_XepLoai", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_XepLoai));
colParam.Add(CreateParamOut("@ID", SqlDbType.BigInt));
return((long)RunProcedureOut("sp_KQHT_DiemMonThiTotNghiep_Add", colParam));
}
public void AddUpdate(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo, int IDDM_MonHoc, int IDDM_Lop)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, IDDM_Lop));
colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.LanThi));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_DiemMonThiTotNghiepInfo.Diem));
colParam.Add(CreateParam("@IDKQHT_XepLoai", SqlDbType.Int, pKQHT_DiemMonThiTotNghiepInfo.IDKQHT_XepLoai));
RunProcedure("sp_KQHT_DiemMonThiTotNghiep_AddUpdate", colParam);
}
public void Delete(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo)
{
oDKQHT_DiemMonThiTotNghiep.Delete(pKQHT_DiemMonThiTotNghiepInfo);
mErrorMessage = oDKQHT_DiemMonThiTotNghiep.ErrorMessages;
mErrorNumber = oDKQHT_DiemMonThiTotNghiep.ErrorNumber;
}
public void AddUpdate(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo, int IDDM_MonHoc, int IDDM_Lop)
{
oDKQHT_DiemMonThiTotNghiep.AddUpdate(pKQHT_DiemMonThiTotNghiepInfo, IDDM_MonHoc, IDDM_Lop);
mErrorMessage = oDKQHT_DiemMonThiTotNghiep.ErrorMessages;
mErrorNumber = oDKQHT_DiemMonThiTotNghiep.ErrorNumber;
}
public DataTable Get(KQHT_DiemMonThiTotNghiepInfo pKQHT_DiemMonThiTotNghiepInfo)
{
return(oDKQHT_DiemMonThiTotNghiep.Get(pKQHT_DiemMonThiTotNghiepInfo));
}