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)); }