public void ToInfo(ref KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo, DataRow dr) { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.KQHT_QuyetDinhTotNghiep_SinhVienID = long.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strKQHT_QuyetDinhTotNghiep_SinhVienID].ToString()); pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_QuyetDinhTotNghiep = int.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDKQHT_QuyetDinhTotNghiep].ToString()); pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDSV_SinhVien].ToString()); if ("" + dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep1] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep1 = double.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep1].ToString()); } if ("" + dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep2] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep2 = double.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep2].ToString()); } if ("" + dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep3] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep3 = double.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep3].ToString()); } if ("" + dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep4] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep4 = double.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep4].ToString()); } if ("" + dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungToanKhoa] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungToanKhoa = double.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungToanKhoa].ToString()); } if ("" + dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungTotNghiep] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungTotNghiep = double.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungTotNghiep].ToString()); } if ("" + dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDKQHT_XepLoaiTotNghiep] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_XepLoaiTotNghiep = int.Parse(dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDKQHT_XepLoaiTotNghiep].ToString()); } }
public void Delete(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_QuyetDinhTotNghiep_SinhVienID", SqlDbType.BigInt, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.KQHT_QuyetDinhTotNghiep_SinhVienID)); RunProcedure("sp_KQHT_QuyetDinhTotNghiep_SinhVien_Delete", colParam); }
public DataTable Get(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_QuyetDinhTotNghiep_SinhVienID", SqlDbType.BigInt, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.KQHT_QuyetDinhTotNghiep_SinhVienID)); return(RunProcedureGet("sp_KQHT_QuyetDinhTotNghiep_SinhVien_Get", colParam)); }
public long Add(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo) { long ID = 0; ID = oDKQHT_QuyetDinhTotNghiep_SinhVien.Add(pKQHT_QuyetDinhTotNghiep_SinhVienInfo); mErrorMessage = oDKQHT_QuyetDinhTotNghiep_SinhVien.ErrorMessages; mErrorNumber = oDKQHT_QuyetDinhTotNghiep_SinhVien.ErrorNumber; return(ID); }
public void ToDataRow(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo, ref DataRow dr) { dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strKQHT_QuyetDinhTotNghiep_SinhVienID] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.KQHT_QuyetDinhTotNghiep_SinhVienID; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDKQHT_QuyetDinhTotNghiep] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_QuyetDinhTotNghiep; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDSV_SinhVien] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDSV_SinhVien; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep1] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep1; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep2] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep2; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep3] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep3; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep4] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep4; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungToanKhoa] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungToanKhoa; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungTotNghiep] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungTotNghiep; dr[pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDKQHT_XepLoaiTotNghiep] = pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_XepLoaiTotNghiep; }
public List <KQHT_QuyetDinhTotNghiep_SinhVienInfo> GetList(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo) { List <KQHT_QuyetDinhTotNghiep_SinhVienInfo> oKQHT_QuyetDinhTotNghiep_SinhVienInfoList = new List <KQHT_QuyetDinhTotNghiep_SinhVienInfo>(); DataTable dtb = Get(pKQHT_QuyetDinhTotNghiep_SinhVienInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { pKQHT_QuyetDinhTotNghiep_SinhVienInfo = new KQHT_QuyetDinhTotNghiep_SinhVienInfo(); pKQHT_QuyetDinhTotNghiep_SinhVienInfo.KQHT_QuyetDinhTotNghiep_SinhVienID = long.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strKQHT_QuyetDinhTotNghiep_SinhVienID].ToString()); pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_QuyetDinhTotNghiep = int.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDKQHT_QuyetDinhTotNghiep].ToString()); pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDSV_SinhVien].ToString()); if ("" + dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep1] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep1 = double.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep1].ToString()); } if ("" + dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep2] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep2 = double.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep2].ToString()); } if ("" + dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep3] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep3 = double.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep3].ToString()); } if ("" + dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep4] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep4 = double.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemMonTotNghiep4].ToString()); } if ("" + dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungToanKhoa] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungToanKhoa = double.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungToanKhoa].ToString()); } if ("" + dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungTotNghiep] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungTotNghiep = double.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strDiemTrungBinhChungTotNghiep].ToString()); } if ("" + dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDKQHT_XepLoaiTotNghiep] != "") { pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_XepLoaiTotNghiep = int.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiep_SinhVienInfo.strIDKQHT_XepLoaiTotNghiep].ToString()); } oKQHT_QuyetDinhTotNghiep_SinhVienInfoList.Add(pKQHT_QuyetDinhTotNghiep_SinhVienInfo); } } return(oKQHT_QuyetDinhTotNghiep_SinhVienInfoList); }
public void Update(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDKQHT_QuyetDinhTotNghiep", SqlDbType.Int, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_QuyetDinhTotNghiep)); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@DiemMonTotNghiep1", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep1)); colParam.Add(CreateParam("@DiemMonTotNghiep2", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep2)); colParam.Add(CreateParam("@DiemMonTotNghiep3", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep3)); colParam.Add(CreateParam("@DiemMonTotNghiep4", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep4)); colParam.Add(CreateParam("@DiemTrungBinhChungToanKhoa", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungToanKhoa)); colParam.Add(CreateParam("@DiemTrungBinhChungTotNghiep", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungTotNghiep)); colParam.Add(CreateParam("@DiemXepLoaiTotNghiep", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemXepLoaiTotNghiep)); colParam.Add(CreateParam("@IDKQHT_XepLoaiTotNghiep", SqlDbType.Int, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_XepLoaiTotNghiep)); colParam.Add(CreateParam("@KQHT_QuyetDinhTotNghiep_SinhVienID", SqlDbType.BigInt, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.KQHT_QuyetDinhTotNghiep_SinhVienID)); RunProcedure("sp_KQHT_QuyetDinhTotNghiep_SinhVien_Update", colParam); }
public long Add(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDKQHT_QuyetDinhTotNghiep", SqlDbType.Int, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_QuyetDinhTotNghiep)); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@DiemMonTotNghiep1", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep1)); colParam.Add(CreateParam("@DiemMonTotNghiep2", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep2)); colParam.Add(CreateParam("@DiemMonTotNghiep3", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep3)); colParam.Add(CreateParam("@DiemMonTotNghiep4", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemMonTotNghiep4)); colParam.Add(CreateParam("@DiemTrungBinhChungToanKhoa", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungToanKhoa)); colParam.Add(CreateParam("@DiemTrungBinhChungTotNghiep", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemTrungBinhChungTotNghiep)); colParam.Add(CreateParam("@DiemXepLoaiTotNghiep", SqlDbType.Float, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.DiemXepLoaiTotNghiep)); colParam.Add(CreateParam("@IDKQHT_XepLoaiTotNghiep", SqlDbType.Int, pKQHT_QuyetDinhTotNghiep_SinhVienInfo.IDKQHT_XepLoaiTotNghiep)); colParam.Add(CreateParamOut("@ID", SqlDbType.BigInt)); return((long)RunProcedureOut("sp_KQHT_QuyetDinhTotNghiep_SinhVien_Add", colParam)); }
public dlgQuyetDinhTotNghiep(frmQuyetDinhTotNghiep_QCNghe _frmQuyetDinh, DataRow _drQuyetDinh) { InitializeComponent(); oBKQHT_QuyetDinhTotNghiep = new cBKQHT_QuyetDinhTotNghiep(); oBKQHT_QuyetDinhTotNghiep_SinhVien = new cBKQHT_QuyetDinhTotNghiep_SinhVien(); pKQHT_QuyetDinhTotNghiepInfo = new KQHT_QuyetDinhTotNghiepInfo(); pKQHT_QuyetDinhTotNghiep_SinhVienInfo = new KQHT_QuyetDinhTotNghiep_SinhVienInfo(); oBSV_SinhVien = new cBSV_SinhVien(); frmQuyetDinh_QCNghe = _frmQuyetDinh; repositoryItemCmbXepLoaiTN.DataSource = (new cBKQHT_XepLoaiTotNghiep()).Get(new KQHT_XepLoaiTotNghiepInfo()); drQuyetDinh = _drQuyetDinh; if (_drQuyetDinh != null && "" + _drQuyetDinh[pKQHT_QuyetDinhTotNghiepInfo.strKQHT_QuyetDinhTotNghiepID] != "") { SetText(); } }
public void Delete(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo) { oDKQHT_QuyetDinhTotNghiep_SinhVien.Delete(pKQHT_QuyetDinhTotNghiep_SinhVienInfo); mErrorMessage = oDKQHT_QuyetDinhTotNghiep_SinhVien.ErrorMessages; mErrorNumber = oDKQHT_QuyetDinhTotNghiep_SinhVien.ErrorNumber; }
public DataTable Get(KQHT_QuyetDinhTotNghiep_SinhVienInfo pKQHT_QuyetDinhTotNghiep_SinhVienInfo) { return(oDKQHT_QuyetDinhTotNghiep_SinhVien.Get(pKQHT_QuyetDinhTotNghiep_SinhVienInfo)); }