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