Beispiel #1
0
 public void ToInfo(ref KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo, DataRow dr)
 {
     pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strKQHT_DanhSachKhongThiTotNghiepID].ToString());
     pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDSV_SinhVien].ToString());
     pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo          = dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strLyDo].ToString();
     pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc   = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDDM_NamHoc].ToString());
     pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot        = bool.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strXetVot].ToString());
 }
        public void Delete(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID));

            RunProcedure("sp_KQHT_DanhSachKhongThiTotNghiep_Delete", colParam);
        }
Beispiel #3
0
 public void ToDataRow(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo, ref DataRow dr)
 {
     dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strKQHT_DanhSachKhongThiTotNghiepID] = pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID;
     dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDSV_SinhVien] = pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien;
     dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strLyDo]          = pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo;
     dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDDM_NamHoc]   = pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc;
     dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strXetVot]        = pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot;
 }
        public DataTable Get(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID));

            return(RunProcedureGet("sp_KQHT_DanhSachKhongThiTotNghiep_Get", colParam));
        }
Beispiel #5
0
 public frmXetThiTotNghiep()
 {
     InitializeComponent();
     oBDM_Lop      = new cBDM_Lop();
     pDM_LopInfo   = new DM_LopInfo();
     oBSV_SinhVien = new cBSV_SinhVien();
     oBKQHT_DanhSachKhongThiTotNghiep    = new cBKQHT_DanhSachKhongThiTotNghiep();
     pKQHT_DanhSachKhongThiTotNghiepInfo = new KQHT_DanhSachKhongThiTotNghiepInfo();
 }
Beispiel #6
0
        public int Add(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
        {
            int ID = 0;

            ID            = oDKQHT_DanhSachKhongThiTotNghiep.Add(pKQHT_DanhSachKhongThiTotNghiepInfo);
            mErrorMessage = oDKQHT_DanhSachKhongThiTotNghiep.ErrorMessages;
            mErrorNumber  = oDKQHT_DanhSachKhongThiTotNghiep.ErrorNumber;
            return(ID);
        }
        public void Update(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien));
            colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo));
            colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc));
            colParam.Add(CreateParam("@XetVot", SqlDbType.Bit, pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot));
            colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID));

            RunProcedure("sp_KQHT_DanhSachKhongThiTotNghiep_Update", colParam);
        }
        public int Add(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien));
            colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo));
            colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc));
            colParam.Add(CreateParam("@XetVot", SqlDbType.Bit, pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot));
            colParam.Add(CreateParamOut("@ID", SqlDbType.Int));

            return((int)RunProcedureOut("sp_KQHT_DanhSachKhongThiTotNghiep_Add", colParam));
        }
Beispiel #9
0
        public List <KQHT_DanhSachKhongThiTotNghiepInfo> GetList(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
        {
            List <KQHT_DanhSachKhongThiTotNghiepInfo> oKQHT_DanhSachKhongThiTotNghiepInfoList = new List <KQHT_DanhSachKhongThiTotNghiepInfo>();
            DataTable dtb = Get(pKQHT_DanhSachKhongThiTotNghiepInfo);

            if (dtb != null)
            {
                for (int i = 0; i < dtb.Rows.Count; i++)
                {
                    oKQHT_DanhSachKhongThiTotNghiepInfo = new KQHT_DanhSachKhongThiTotNghiepInfo();

                    oKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID = int.Parse(dtb.Rows[i]["KQHT_DanhSachKhongThiTotNghiepID"].ToString());
                    oKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
                    oKQHT_DanhSachKhongThiTotNghiepInfo.LyDo          = dtb.Rows[i]["LyDo"].ToString();
                    oKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc   = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
                    oKQHT_DanhSachKhongThiTotNghiepInfo.XetVot        = bool.Parse(dtb.Rows[i]["XetVot"].ToString());

                    oKQHT_DanhSachKhongThiTotNghiepInfoList.Add(oKQHT_DanhSachKhongThiTotNghiepInfo);
                }
            }
            return(oKQHT_DanhSachKhongThiTotNghiepInfoList);
        }
Beispiel #10
0
 public void Delete(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
 {
     oDKQHT_DanhSachKhongThiTotNghiep.Delete(pKQHT_DanhSachKhongThiTotNghiepInfo);
     mErrorMessage = oDKQHT_DanhSachKhongThiTotNghiep.ErrorMessages;
     mErrorNumber  = oDKQHT_DanhSachKhongThiTotNghiep.ErrorNumber;
 }
Beispiel #11
0
 public DataTable Get(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo)
 {
     return(oDKQHT_DanhSachKhongThiTotNghiep.Get(pKQHT_DanhSachKhongThiTotNghiepInfo));
 }