public List <KQHT_DanhSachNgungHocInfo> GetList(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo)
{
List <KQHT_DanhSachNgungHocInfo> oKQHT_DanhSachNgungHocInfoList = new List <KQHT_DanhSachNgungHocInfo>();
DataTable dtb = Get(pKQHT_DanhSachNgungHocInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_DanhSachNgungHocInfo = new KQHT_DanhSachNgungHocInfo();
oKQHT_DanhSachNgungHocInfo.KQHT_DanhSachNgungHocID = int.Parse(dtb.Rows[i]["KQHT_DanhSachNgungHocID"].ToString());
oKQHT_DanhSachNgungHocInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oKQHT_DanhSachNgungHocInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oKQHT_DanhSachNgungHocInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oKQHT_DanhSachNgungHocInfo.SoQuyetDinh = dtb.Rows[i]["SoQuyetDinh"].ToString();
oKQHT_DanhSachNgungHocInfo.NgayQuyetDinh = DateTime.Parse(dtb.Rows[i]["NgayQuyetDinh"].ToString());
oKQHT_DanhSachNgungHocInfo.NoiDung = dtb.Rows[i]["NoiDung"].ToString();
oKQHT_DanhSachNgungHocInfo.IDDM_LopCu = int.Parse(dtb.Rows[i]["IDDM_LopCu"].ToString());
oKQHT_DanhSachNgungHocInfo.TrangThai = int.Parse(dtb.Rows[i]["TrangThai"].ToString());
oKQHT_DanhSachNgungHocInfoList.Add(oKQHT_DanhSachNgungHocInfo);
}
}
return(oKQHT_DanhSachNgungHocInfoList);
}
public void Delete(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DanhSachNgungHocID", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.KQHT_DanhSachNgungHocID));
RunProcedure("sp_KQHT_DanhSachNgungHoc_Delete", colParam);
}
public DataTable Get(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_DanhSachNgungHocID", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.KQHT_DanhSachNgungHocID));
return(RunProcedureGet("sp_KQHT_DanhSachNgungHoc_Get", colParam));
}
public int Add(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo)
{
int ID = 0;
ID = oDKQHT_DanhSachNgungHoc.Add(pKQHT_DanhSachNgungHocInfo);
mErrorMessage = oDKQHT_DanhSachNgungHoc.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachNgungHoc.ErrorNumber;
return(ID);
}
public void ToInfo(ref KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo, DataRow dr)
{
pKQHT_DanhSachNgungHocInfo.KQHT_DanhSachNgungHocID = int.Parse(dr[pKQHT_DanhSachNgungHocInfo.strKQHT_DanhSachNgungHocID].ToString());
pKQHT_DanhSachNgungHocInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DanhSachNgungHocInfo.strIDSV_SinhVien].ToString());
pKQHT_DanhSachNgungHocInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DanhSachNgungHocInfo.strIDDM_NamHoc].ToString());
pKQHT_DanhSachNgungHocInfo.HocKy = int.Parse(dr[pKQHT_DanhSachNgungHocInfo.strHocKy].ToString());
pKQHT_DanhSachNgungHocInfo.SoQuyetDinh = dr[pKQHT_DanhSachNgungHocInfo.strSoQuyetDinh].ToString();
pKQHT_DanhSachNgungHocInfo.NgayQuyetDinh = DateTime.Parse(dr[pKQHT_DanhSachNgungHocInfo.strNgayQuyetDinh].ToString());
pKQHT_DanhSachNgungHocInfo.NoiDung = dr[pKQHT_DanhSachNgungHocInfo.strNoiDung].ToString();
pKQHT_DanhSachNgungHocInfo.IDDM_LopCu = int.Parse(dr[pKQHT_DanhSachNgungHocInfo.strIDDM_LopCu].ToString());
pKQHT_DanhSachNgungHocInfo.TrangThai = int.Parse(dr[pKQHT_DanhSachNgungHocInfo.strTrangThai].ToString());
}
public void ToDataRow(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo, ref DataRow dr)
{
dr[pKQHT_DanhSachNgungHocInfo.strKQHT_DanhSachNgungHocID] = pKQHT_DanhSachNgungHocInfo.KQHT_DanhSachNgungHocID;
dr[pKQHT_DanhSachNgungHocInfo.strIDSV_SinhVien] = pKQHT_DanhSachNgungHocInfo.IDSV_SinhVien;
dr[pKQHT_DanhSachNgungHocInfo.strIDDM_NamHoc] = pKQHT_DanhSachNgungHocInfo.IDDM_NamHoc;
dr[pKQHT_DanhSachNgungHocInfo.strHocKy] = pKQHT_DanhSachNgungHocInfo.HocKy;
dr[pKQHT_DanhSachNgungHocInfo.strSoQuyetDinh] = pKQHT_DanhSachNgungHocInfo.SoQuyetDinh;
dr[pKQHT_DanhSachNgungHocInfo.strNgayQuyetDinh] = pKQHT_DanhSachNgungHocInfo.NgayQuyetDinh;
dr[pKQHT_DanhSachNgungHocInfo.strNoiDung] = pKQHT_DanhSachNgungHocInfo.NoiDung;
dr[pKQHT_DanhSachNgungHocInfo.strIDDM_LopCu] = pKQHT_DanhSachNgungHocInfo.IDDM_LopCu;
dr[pKQHT_DanhSachNgungHocInfo.strTrangThai] = pKQHT_DanhSachNgungHocInfo.TrangThai;
}
public void Update(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.HocKy));
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pKQHT_DanhSachNgungHocInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pKQHT_DanhSachNgungHocInfo.NgayQuyetDinh));
colParam.Add(CreateParam("@NoiDung", SqlDbType.NVarChar, pKQHT_DanhSachNgungHocInfo.NoiDung));
colParam.Add(CreateParam("@IDDM_LopCu", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.IDDM_LopCu));
colParam.Add(CreateParam("@TrangThai", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.TrangThai));
colParam.Add(CreateParam("@KQHT_DanhSachNgungHocID", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.KQHT_DanhSachNgungHocID));
RunProcedure("sp_KQHT_DanhSachNgungHoc_Update", colParam);
}
public int Add(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.HocKy));
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pKQHT_DanhSachNgungHocInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pKQHT_DanhSachNgungHocInfo.NgayQuyetDinh));
colParam.Add(CreateParam("@NoiDung", SqlDbType.NVarChar, pKQHT_DanhSachNgungHocInfo.NoiDung));
colParam.Add(CreateParam("@IDDM_LopCu", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.IDDM_LopCu));
colParam.Add(CreateParam("@TrangThai", SqlDbType.Int, pKQHT_DanhSachNgungHocInfo.TrangThai));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_DanhSachNgungHoc_Add", colParam));
}
public dlgQuyetDinh(string mSinhVienIDs, string mTrangThai, string mKQHT_DanhSachNgungHocIDs, DataRow mdr)
{
InitializeComponent();
oBSinhVien = new cBSV_SinhVien();
oBKQHT_DanhSachNgungHoc = new cBKQHT_DanhSachNgungHoc();
pKQHT_DanhSachNgungHocInfo = new KQHT_DanhSachNgungHocInfo();
pSV_SinhVienInfo = new SV_SinhVienInfo();
pKQHT_DanhSachNgungHocInfo = new KQHT_DanhSachNgungHocInfo();
oBKQHT_DanhSachHocTiep = new cBKQHT_DanhSachHocTiep();
pKQHT_DanhSachHocTiepInfo = new KQHT_DanhSachHocTiepInfo();
SinhVienIDs = mSinhVienIDs;
dtNgayQD.EditValue = DateTime.Now;
dr = mdr;
TrangThai = mTrangThai;
KQHT_DanhSachNgungHocIDs = mKQHT_DanhSachNgungHocIDs;
//load combobox
cmbTrangThai.Properties.DataSource = oBSinhVien.CreateTableTrangThai();
cmbLop.Properties.DataSource = LoadLopTheoKhoa(0);
// Sửa quyết định
if (TrangThai == "1")
{
txtSoQuyetDinh.Text = dr["SoQuyetDinh"].ToString();
txtNoiDung.Text = dr["GhiChu"].ToString();
}
else if (TrangThai == "2")
{
// xet hoc tiep
txtSoQuyetDinh.Text = dr["SoQuyetDinh"].ToString();
txtNoiDung.Text = dr["GhiChu"].ToString();
cmbLop.Enabled = true;
cmbLop.EditValue = dr["IDDM_Lop"];
}
}
public DataTable Get(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo)
{
return(oDKQHT_DanhSachNgungHoc.Get(pKQHT_DanhSachNgungHocInfo));
}
public void Delete(KQHT_DanhSachNgungHocInfo pKQHT_DanhSachNgungHocInfo)
{
oDKQHT_DanhSachNgungHoc.Delete(pKQHT_DanhSachNgungHocInfo);
mErrorMessage = oDKQHT_DanhSachNgungHoc.ErrorMessages;
mErrorNumber = oDKQHT_DanhSachNgungHoc.ErrorNumber;
}
