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