public List <SV_QuyetDinhKyLuatInfo> GetList(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo)
{
List <SV_QuyetDinhKyLuatInfo> oSV_QuyetDinhKyLuatInfoList = new List <SV_QuyetDinhKyLuatInfo>();
DataTable dtb = Get(pSV_QuyetDinhKyLuatInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oSV_QuyetDinhKyLuatInfo = new SV_QuyetDinhKyLuatInfo();
oSV_QuyetDinhKyLuatInfo.SV_QuyetDinhKyLuatID = int.Parse(dtb.Rows[i]["SV_QuyetDinhKyLuatID"].ToString());
oSV_QuyetDinhKyLuatInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oSV_QuyetDinhKyLuatInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oSV_QuyetDinhKyLuatInfo.SoQuyetDinh = dtb.Rows[i]["SoQuyetDinh"].ToString();
oSV_QuyetDinhKyLuatInfo.NgayQuyetDinh = DateTime.Parse(dtb.Rows[i]["NgayQuyetDinh"].ToString());
oSV_QuyetDinhKyLuatInfo.IDDM_CapKhenThuong = int.Parse(dtb.Rows[i]["IDDM_CapKhenThuong"].ToString());
oSV_QuyetDinhKyLuatInfo.IDDM_HanhVi = int.Parse(dtb.Rows[i]["IDDM_HanhVi"].ToString());
oSV_QuyetDinhKyLuatInfo.NoiDung = dtb.Rows[i]["NoiDung"].ToString();
oSV_QuyetDinhKyLuatInfoList.Add(oSV_QuyetDinhKyLuatInfo);
}
}
return(oSV_QuyetDinhKyLuatInfoList);
}
public void Delete(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_QuyetDinhKyLuatID", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.SV_QuyetDinhKyLuatID));
RunProcedure("sp_SV_QuyetDinhKyLuat_Delete", colParam);
}
public DataTable Get(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_QuyetDinhKyLuatID", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.SV_QuyetDinhKyLuatID));
return(RunProcedureGet("sp_SV_QuyetDinhKyLuat_Get", colParam));
}
public dlgQDKyLuat(EDIT_MODE _edit)
{
InitializeComponent();
edit = _edit;
this.DialogResult = DialogResult.Cancel;
oBSV_QuyetDinhKyLuat = new cBSV_QuyetDinhKyLuat();
pSV_QuyetDinhKyLuatInfo = new SV_QuyetDinhKyLuatInfo();
}
public int Add(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo)
{
int ID = 0;
ID = oDSV_QuyetDinhKyLuat.Add(pSV_QuyetDinhKyLuatInfo);
mErrorMessage = oDSV_QuyetDinhKyLuat.ErrorMessages;
mErrorNumber = oDSV_QuyetDinhKyLuat.ErrorNumber;
return(ID);
}
public void ToInfo(ref SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo, DataRow dr)
{
pSV_QuyetDinhKyLuatInfo.SV_QuyetDinhKyLuatID = int.Parse(dr[pSV_QuyetDinhKyLuatInfo.strSV_QuyetDinhKyLuatID].ToString());
pSV_QuyetDinhKyLuatInfo.IDDM_NamHoc = int.Parse(dr[pSV_QuyetDinhKyLuatInfo.strIDDM_NamHoc].ToString());
pSV_QuyetDinhKyLuatInfo.HocKy = int.Parse(dr[pSV_QuyetDinhKyLuatInfo.strHocKy].ToString());
pSV_QuyetDinhKyLuatInfo.SoQuyetDinh = dr[pSV_QuyetDinhKyLuatInfo.strSoQuyetDinh].ToString();
pSV_QuyetDinhKyLuatInfo.NgayQuyetDinh = DateTime.Parse(dr[pSV_QuyetDinhKyLuatInfo.strNgayQuyetDinh].ToString());
pSV_QuyetDinhKyLuatInfo.IDDM_CapKhenThuong = int.Parse(dr[pSV_QuyetDinhKyLuatInfo.strIDDM_CapKhenThuong].ToString());
pSV_QuyetDinhKyLuatInfo.IDDM_HanhVi = int.Parse(dr[pSV_QuyetDinhKyLuatInfo.strIDDM_HanhVi].ToString());
pSV_QuyetDinhKyLuatInfo.NoiDung = dr[pSV_QuyetDinhKyLuatInfo.strNoiDung].ToString();
}
public void ToDataRow(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo, ref DataRow dr)
{
dr[pSV_QuyetDinhKyLuatInfo.strSV_QuyetDinhKyLuatID] = pSV_QuyetDinhKyLuatInfo.SV_QuyetDinhKyLuatID;
dr[pSV_QuyetDinhKyLuatInfo.strIDDM_NamHoc] = pSV_QuyetDinhKyLuatInfo.IDDM_NamHoc;
dr[pSV_QuyetDinhKyLuatInfo.strHocKy] = pSV_QuyetDinhKyLuatInfo.HocKy;
dr[pSV_QuyetDinhKyLuatInfo.strSoQuyetDinh] = pSV_QuyetDinhKyLuatInfo.SoQuyetDinh;
dr[pSV_QuyetDinhKyLuatInfo.strNgayQuyetDinh] = pSV_QuyetDinhKyLuatInfo.NgayQuyetDinh;
dr[pSV_QuyetDinhKyLuatInfo.strIDDM_CapKhenThuong] = pSV_QuyetDinhKyLuatInfo.IDDM_CapKhenThuong;
dr[pSV_QuyetDinhKyLuatInfo.strIDDM_HanhVi] = pSV_QuyetDinhKyLuatInfo.IDDM_HanhVi;
dr[pSV_QuyetDinhKyLuatInfo.strNoiDung] = pSV_QuyetDinhKyLuatInfo.NoiDung;
}
private void btnXoaQD_Click(object sender, EventArgs e)
{
if (grvDSQuyetDinh.FocusedRowHandle < 0)
{
return;
}
if (ThongBaoChon("Hệ thống sẽ xóa quyết định này cùng với các sinh viên liên quan\nBạn có chắc chắn muốn xóa không?") == DialogResult.Yes)
{
SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo = new SV_QuyetDinhKyLuatInfo();
pSV_QuyetDinhKyLuatInfo.SV_QuyetDinhKyLuatID = int.Parse(drQuyetDinh["SV_QuyetDinhKyLuatID"].ToString());
new cBSV_QuyetDinhKyLuat().Delete(pSV_QuyetDinhKyLuatInfo);
dtQuyetDinh.Rows.Remove(drQuyetDinh);
}
}
public void Update(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.HocKy));
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pSV_QuyetDinhKyLuatInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pSV_QuyetDinhKyLuatInfo.NgayQuyetDinh));
colParam.Add(CreateParam("@IDDM_CapKhenThuong", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.IDDM_CapKhenThuong));
colParam.Add(CreateParam("@IDDM_HanhVi", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.IDDM_HanhVi));
colParam.Add(CreateParam("@NoiDung", SqlDbType.NVarChar, pSV_QuyetDinhKyLuatInfo.NoiDung));
colParam.Add(CreateParam("@SV_QuyetDinhKyLuatID", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.SV_QuyetDinhKyLuatID));
RunProcedure("sp_SV_QuyetDinhKyLuat_Update", colParam);
}
public int Add(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.HocKy));
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pSV_QuyetDinhKyLuatInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pSV_QuyetDinhKyLuatInfo.NgayQuyetDinh));
colParam.Add(CreateParam("@IDDM_CapKhenThuong", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.IDDM_CapKhenThuong));
colParam.Add(CreateParam("@IDDM_HanhVi", SqlDbType.Int, pSV_QuyetDinhKyLuatInfo.IDDM_HanhVi));
colParam.Add(CreateParam("@NoiDung", SqlDbType.NVarChar, pSV_QuyetDinhKyLuatInfo.NoiDung));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_SV_QuyetDinhKyLuat_Add", colParam));
}
public void Delete(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo)
{
oDSV_QuyetDinhKyLuat.Delete(pSV_QuyetDinhKyLuatInfo);
mErrorMessage = oDSV_QuyetDinhKyLuat.ErrorMessages;
mErrorNumber = oDSV_QuyetDinhKyLuat.ErrorNumber;
}
public DataTable Get(SV_QuyetDinhKyLuatInfo pSV_QuyetDinhKyLuatInfo)
{
return(oDSV_QuyetDinhKyLuat.Get(pSV_QuyetDinhKyLuatInfo));
}
