public List <KQHT_QuyetDinhTotNghiepInfo> GetList(KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo) { List <KQHT_QuyetDinhTotNghiepInfo> oKQHT_QuyetDinhTotNghiepInfoList = new List <KQHT_QuyetDinhTotNghiepInfo>(); DataTable dtb = Get(pKQHT_QuyetDinhTotNghiepInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { pKQHT_QuyetDinhTotNghiepInfo = new KQHT_QuyetDinhTotNghiepInfo(); pKQHT_QuyetDinhTotNghiepInfo.KQHT_QuyetDinhTotNghiepID = int.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiepInfo.strKQHT_QuyetDinhTotNghiepID].ToString()); pKQHT_QuyetDinhTotNghiepInfo.SoQuyetDinh = dtb.Rows[i][pKQHT_QuyetDinhTotNghiepInfo.strSoQuyetDinh].ToString(); pKQHT_QuyetDinhTotNghiepInfo.NgayQuyetDinh = DateTime.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiepInfo.strNgayQuyetDinh].ToString()); if ("" + dtb.Rows[i][pKQHT_QuyetDinhTotNghiepInfo.strNoiDung] != "") { pKQHT_QuyetDinhTotNghiepInfo.NoiDung = dtb.Rows[i][pKQHT_QuyetDinhTotNghiepInfo.strNoiDung].ToString(); } pKQHT_QuyetDinhTotNghiepInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i][pKQHT_QuyetDinhTotNghiepInfo.strIDDM_NamHoc].ToString()); oKQHT_QuyetDinhTotNghiepInfoList.Add(pKQHT_QuyetDinhTotNghiepInfo); } } return(oKQHT_QuyetDinhTotNghiepInfoList); }
public void ToDataRow(KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo, ref DataRow dr) { dr[pKQHT_QuyetDinhTotNghiepInfo.strKQHT_QuyetDinhTotNghiepID] = pKQHT_QuyetDinhTotNghiepInfo.KQHT_QuyetDinhTotNghiepID; dr[pKQHT_QuyetDinhTotNghiepInfo.strSoQuyetDinh] = pKQHT_QuyetDinhTotNghiepInfo.SoQuyetDinh; dr[pKQHT_QuyetDinhTotNghiepInfo.strNgayQuyetDinh] = pKQHT_QuyetDinhTotNghiepInfo.NgayQuyetDinh; dr[pKQHT_QuyetDinhTotNghiepInfo.strNoiDung] = pKQHT_QuyetDinhTotNghiepInfo.NoiDung; dr[pKQHT_QuyetDinhTotNghiepInfo.strIDDM_NamHoc] = pKQHT_QuyetDinhTotNghiepInfo.IDDM_NamHoc; }
public void Delete(KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_QuyetDinhTotNghiepID", SqlDbType.Int, pKQHT_QuyetDinhTotNghiepInfo.KQHT_QuyetDinhTotNghiepID)); RunProcedure("sp_KQHT_QuyetDinhTotNghiep_Delete", colParam); }
public DataTable Get(KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_QuyetDinhTotNghiepID", SqlDbType.Int, pKQHT_QuyetDinhTotNghiepInfo.KQHT_QuyetDinhTotNghiepID)); return(RunProcedureGet("sp_KQHT_QuyetDinhTotNghiep_Get", colParam)); }
public int Add(KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo) { int ID = 0; ID = oDKQHT_QuyetDinhTotNghiep.Add(pKQHT_QuyetDinhTotNghiepInfo); mErrorMessage = oDKQHT_QuyetDinhTotNghiep.ErrorMessages; mErrorNumber = oDKQHT_QuyetDinhTotNghiep.ErrorNumber; return(ID); }
public void ToInfo(ref KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo, DataRow dr) { pKQHT_QuyetDinhTotNghiepInfo.KQHT_QuyetDinhTotNghiepID = int.Parse(dr[pKQHT_QuyetDinhTotNghiepInfo.strKQHT_QuyetDinhTotNghiepID].ToString()); pKQHT_QuyetDinhTotNghiepInfo.SoQuyetDinh = dr[pKQHT_QuyetDinhTotNghiepInfo.strSoQuyetDinh].ToString(); pKQHT_QuyetDinhTotNghiepInfo.NgayQuyetDinh = DateTime.Parse(dr[pKQHT_QuyetDinhTotNghiepInfo.strNgayQuyetDinh].ToString()); if ("" + dr[pKQHT_QuyetDinhTotNghiepInfo.strNoiDung] != "") { pKQHT_QuyetDinhTotNghiepInfo.NoiDung = dr[pKQHT_QuyetDinhTotNghiepInfo.strNoiDung].ToString(); } pKQHT_QuyetDinhTotNghiepInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_QuyetDinhTotNghiepInfo.strIDDM_NamHoc].ToString()); }
public void Update(KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pKQHT_QuyetDinhTotNghiepInfo.SoQuyetDinh)); colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pKQHT_QuyetDinhTotNghiepInfo.NgayQuyetDinh)); colParam.Add(CreateParam("@NoiDung", SqlDbType.NText, pKQHT_QuyetDinhTotNghiepInfo.NoiDung)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_QuyetDinhTotNghiepInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@KQHT_QuyetDinhTotNghiepID", SqlDbType.Int, pKQHT_QuyetDinhTotNghiepInfo.KQHT_QuyetDinhTotNghiepID)); RunProcedure("sp_KQHT_QuyetDinhTotNghiep_Update", colParam); }
public int Add(KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pKQHT_QuyetDinhTotNghiepInfo.SoQuyetDinh)); colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pKQHT_QuyetDinhTotNghiepInfo.NgayQuyetDinh)); colParam.Add(CreateParam("@NoiDung", SqlDbType.NText, pKQHT_QuyetDinhTotNghiepInfo.NoiDung)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_QuyetDinhTotNghiepInfo.IDDM_NamHoc)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_KQHT_QuyetDinhTotNghiep_Add", colParam)); }
private void barbtnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (grvQuyetDinh.FocusedRowHandle >= 0) { if (ThongBaoChon("Xóa quyết định sẽ xóa cả danh sách sinh viên trong quyết định này.\nBạn có chắc chắn muốn xóa không?") == DialogResult.Yes) { KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo = new KQHT_QuyetDinhTotNghiepInfo(); pKQHT_QuyetDinhTotNghiepInfo.KQHT_QuyetDinhTotNghiepID = int.Parse(drQuyetDinh[pKQHT_QuyetDinhTotNghiepInfo.strKQHT_QuyetDinhTotNghiepID].ToString()); oBKQHT_QuyetDinhTotNghiep.Delete(pKQHT_QuyetDinhTotNghiepInfo); dtQuyetDinh.Rows.Remove(drQuyetDinh); grvQuyetDinh_FocusedRowChanged(null, null); } } }
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_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo) { oDKQHT_QuyetDinhTotNghiep.Delete(pKQHT_QuyetDinhTotNghiepInfo); mErrorMessage = oDKQHT_QuyetDinhTotNghiep.ErrorMessages; mErrorNumber = oDKQHT_QuyetDinhTotNghiep.ErrorNumber; }
public DataTable Get(KQHT_QuyetDinhTotNghiepInfo pKQHT_QuyetDinhTotNghiepInfo) { return(oDKQHT_QuyetDinhTotNghiep.Get(pKQHT_QuyetDinhTotNghiepInfo)); }