public void ToDataRow(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo, ref DataRow dr)
{
dr[pKQHT_HoiDongMon_DiemInfo.strKQHT_HoiDongMon_DiemID] = pKQHT_HoiDongMon_DiemInfo.KQHT_HoiDongMon_DiemID;
dr[pKQHT_HoiDongMon_DiemInfo.strIDKQHT_HoiDongMon_ChiTiet] = pKQHT_HoiDongMon_DiemInfo.IDKQHT_HoiDongMon_ChiTiet;
dr[pKQHT_HoiDongMon_DiemInfo.strIDSV_SinhVien] = pKQHT_HoiDongMon_DiemInfo.IDSV_SinhVien;
dr[pKQHT_HoiDongMon_DiemInfo.strDiem] = pKQHT_HoiDongMon_DiemInfo.Diem;
}
public void ToInfo(ref KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo, DataRow dr)
{
pKQHT_HoiDongMon_DiemInfo.KQHT_HoiDongMon_DiemID = long.Parse(dr[pKQHT_HoiDongMon_DiemInfo.strKQHT_HoiDongMon_DiemID].ToString());
pKQHT_HoiDongMon_DiemInfo.IDKQHT_HoiDongMon_ChiTiet = int.Parse(dr[pKQHT_HoiDongMon_DiemInfo.strIDKQHT_HoiDongMon_ChiTiet].ToString());
pKQHT_HoiDongMon_DiemInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_HoiDongMon_DiemInfo.strIDSV_SinhVien].ToString());
pKQHT_HoiDongMon_DiemInfo.Diem = double.Parse(dr[pKQHT_HoiDongMon_DiemInfo.strDiem].ToString());
}
public void Delete(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_HoiDongMon_DiemID", SqlDbType.BigInt, pKQHT_HoiDongMon_DiemInfo.KQHT_HoiDongMon_DiemID));
RunProcedure("sp_KQHT_HoiDongMon_Diem_Delete", colParam);
}
public DataTable Get(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_HoiDongMon_DiemID", SqlDbType.BigInt, pKQHT_HoiDongMon_DiemInfo.KQHT_HoiDongMon_DiemID));
return(RunProcedureGet("sp_KQHT_HoiDongMon_Diem_Get", colParam));
}
public int Add(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo)
{
int ID = 0;
ID = oDKQHT_HoiDongMon_Diem.Add(pKQHT_HoiDongMon_DiemInfo);
mErrorMessage = oDKQHT_HoiDongMon_Diem.ErrorMessages;
mErrorNumber = oDKQHT_HoiDongMon_Diem.ErrorNumber;
return(ID);
}
public frmNhapDiemHoiDongMonHoc()
{
InitializeComponent();
oBKQHT_HoiDongMon = new cBKQHT_HoiDongMon();
pKQHT_HoiDongMonInfo = new KQHT_HoiDongMonInfo();
pKQHT_HoiDongMon_DiemInfo = new KQHT_HoiDongMon_DiemInfo();
oBKQHT_HoiDongMon_Diem = new cBKQHT_HoiDongMon_Diem();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
}
public void Update(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_HoiDongMon_ChiTiet", SqlDbType.Int, pKQHT_HoiDongMon_DiemInfo.IDKQHT_HoiDongMon_ChiTiet));
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_HoiDongMon_DiemInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_HoiDongMon_DiemInfo.Diem));
colParam.Add(CreateParam("@KQHT_HoiDongMon_DiemID", SqlDbType.BigInt, pKQHT_HoiDongMon_DiemInfo.KQHT_HoiDongMon_DiemID));
RunProcedure("sp_KQHT_HoiDongMon_Diem_Update", colParam);
}
public int Add(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_HoiDongMon_ChiTiet", SqlDbType.Int, pKQHT_HoiDongMon_DiemInfo.IDKQHT_HoiDongMon_ChiTiet));
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_HoiDongMon_DiemInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@Diem", SqlDbType.Real, pKQHT_HoiDongMon_DiemInfo.Diem));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_HoiDongMon_Diem_Add", colParam));
}
public List <KQHT_HoiDongMon_DiemInfo> GetList(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo)
{
List <KQHT_HoiDongMon_DiemInfo> oKQHT_HoiDongMon_DiemInfoList = new List <KQHT_HoiDongMon_DiemInfo>();
DataTable dtb = Get(pKQHT_HoiDongMon_DiemInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_HoiDongMon_DiemInfo = new KQHT_HoiDongMon_DiemInfo();
oKQHT_HoiDongMon_DiemInfo.KQHT_HoiDongMon_DiemID = long.Parse(dtb.Rows[i]["KQHT_HoiDongMon_DiemID"].ToString());
oKQHT_HoiDongMon_DiemInfo.IDKQHT_HoiDongMon_ChiTiet = int.Parse(dtb.Rows[i]["IDKQHT_HoiDongMon_ChiTiet"].ToString());
oKQHT_HoiDongMon_DiemInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_HoiDongMon_DiemInfo.Diem = double.Parse(dtb.Rows[i]["Diem"].ToString());
oKQHT_HoiDongMon_DiemInfoList.Add(oKQHT_HoiDongMon_DiemInfo);
}
}
return(oKQHT_HoiDongMon_DiemInfoList);
}
public void Delete(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo)
{
oDKQHT_HoiDongMon_Diem.Delete(pKQHT_HoiDongMon_DiemInfo);
mErrorMessage = oDKQHT_HoiDongMon_Diem.ErrorMessages;
mErrorNumber = oDKQHT_HoiDongMon_Diem.ErrorNumber;
}
public DataTable Get(KQHT_HoiDongMon_DiemInfo pKQHT_HoiDongMon_DiemInfo)
{
return(oDKQHT_HoiDongMon_Diem.Get(pKQHT_HoiDongMon_DiemInfo));
}
