C# (CSharp) KQHT_MonThiTotNghiepInfo示例

示例#1

        public void Delete(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@KQHT_MonThiTotNghiepID", SqlDbType.Int, pKQHT_MonThiTotNghiepInfo.KQHT_MonThiTotNghiepID));

            RunProcedure("sp_KQHT_MonThiTotNghiep_Delete", colParam);
        }

示例#2

        public DataTable Get(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@KQHT_MonThiTotNghiepID", SqlDbType.Int, pKQHT_MonThiTotNghiepInfo.KQHT_MonThiTotNghiepID));

            return(RunProcedureGet("sp_KQHT_MonThiTotNghiep_Get", colParam));
        }

示例#3

 public void ToInfo(ref KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo, DataRow dr)
 {
     pKQHT_MonThiTotNghiepInfo.KQHT_MonThiTotNghiepID = int.Parse(dr[pKQHT_MonThiTotNghiepInfo.strKQHT_MonThiTotNghiepID].ToString());
     pKQHT_MonThiTotNghiepInfo.MaMon        = dr[pKQHT_MonThiTotNghiepInfo.strMaMon].ToString();
     pKQHT_MonThiTotNghiepInfo.TenMon       = dr[pKQHT_MonThiTotNghiepInfo.strTenMon].ToString();
     pKQHT_MonThiTotNghiepInfo.TinhDiem     = bool.Parse(dr[pKQHT_MonThiTotNghiepInfo.strTinhDiem].ToString());
     pKQHT_MonThiTotNghiepInfo.DiemDieuKien = double.Parse("0" + dr[pKQHT_MonThiTotNghiepInfo.strDiemDieuKien].ToString());
     pKQHT_MonThiTotNghiepInfo.SoHocTrinh   = double.Parse("0" + dr[pKQHT_MonThiTotNghiepInfo.strSoHocTrinh].ToString());
 }

示例#4

 public void ToDataRow(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo, ref DataRow dr)
 {
     dr[pKQHT_MonThiTotNghiepInfo.strKQHT_MonThiTotNghiepID] = pKQHT_MonThiTotNghiepInfo.KQHT_MonThiTotNghiepID;
     dr[pKQHT_MonThiTotNghiepInfo.strMaMon]        = pKQHT_MonThiTotNghiepInfo.MaMon;
     dr[pKQHT_MonThiTotNghiepInfo.strTenMon]       = pKQHT_MonThiTotNghiepInfo.TenMon;
     dr[pKQHT_MonThiTotNghiepInfo.strTinhDiem]     = pKQHT_MonThiTotNghiepInfo.TinhDiem;
     dr[pKQHT_MonThiTotNghiepInfo.strDiemDieuKien] = pKQHT_MonThiTotNghiepInfo.DiemDieuKien;
     dr[pKQHT_MonThiTotNghiepInfo.strSoHocTrinh]   = pKQHT_MonThiTotNghiepInfo.SoHocTrinh;
 }

示例#5

        public int Add(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo)
        {
            int ID = 0;

            ID            = oDKQHT_MonThiTotNghiep.Add(pKQHT_MonThiTotNghiepInfo);
            mErrorMessage = oDKQHT_MonThiTotNghiep.ErrorMessages;
            mErrorNumber  = oDKQHT_MonThiTotNghiep.ErrorNumber;
            return(ID);
        }

示例#6

        public void Update(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@MaMon", SqlDbType.NVarChar, pKQHT_MonThiTotNghiepInfo.MaMon));
            colParam.Add(CreateParam("@TenMon", SqlDbType.NVarChar, pKQHT_MonThiTotNghiepInfo.TenMon));
            colParam.Add(CreateParam("@TinhDiem", SqlDbType.Bit, pKQHT_MonThiTotNghiepInfo.TinhDiem));
            colParam.Add(CreateParam("@DiemDieuKien", SqlDbType.Float, pKQHT_MonThiTotNghiepInfo.DiemDieuKien));
            colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Float, pKQHT_MonThiTotNghiepInfo.SoHocTrinh));
            colParam.Add(CreateParam("@KQHT_MonThiTotNghiepID", SqlDbType.Int, pKQHT_MonThiTotNghiepInfo.KQHT_MonThiTotNghiepID));

            RunProcedure("sp_KQHT_MonThiTotNghiep_Update", colParam);
        }

示例#7

        public int Add(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@MaMon", SqlDbType.NVarChar, pKQHT_MonThiTotNghiepInfo.MaMon));
            colParam.Add(CreateParam("@TenMon", SqlDbType.NVarChar, pKQHT_MonThiTotNghiepInfo.TenMon));
            colParam.Add(CreateParam("@TinhDiem", SqlDbType.Bit, pKQHT_MonThiTotNghiepInfo.TinhDiem));
            colParam.Add(CreateParam("@DiemDieuKien", SqlDbType.Float, pKQHT_MonThiTotNghiepInfo.DiemDieuKien));
            colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Float, pKQHT_MonThiTotNghiepInfo.SoHocTrinh));
            colParam.Add(CreateParamOut("@ID", SqlDbType.Int));

            return((int)RunProcedureOut("sp_KQHT_MonThiTotNghiep_Add", colParam));
        }

示例#8

        public List <KQHT_MonThiTotNghiepInfo> GetList(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo)
        {
            List <KQHT_MonThiTotNghiepInfo> oKQHT_MonThiTotNghiepInfoList = new List <KQHT_MonThiTotNghiepInfo>();
            DataTable dtb = Get(pKQHT_MonThiTotNghiepInfo);

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

                    oKQHT_MonThiTotNghiepInfo.KQHT_MonThiTotNghiepID = int.Parse(dtb.Rows[i]["KQHT_MonThiTotNghiepID"].ToString());
                    oKQHT_MonThiTotNghiepInfo.MaMon        = dtb.Rows[i]["MaMon"].ToString();
                    oKQHT_MonThiTotNghiepInfo.TenMon       = dtb.Rows[i]["TenMon"].ToString();
                    oKQHT_MonThiTotNghiepInfo.TinhDiem     = bool.Parse(dtb.Rows[i]["TinhDiem"].ToString());
                    oKQHT_MonThiTotNghiepInfo.DiemDieuKien = double.Parse(dtb.Rows[i]["DiemDieuKien"].ToString());
                    oKQHT_MonThiTotNghiepInfo.SoHocTrinh   = double.Parse(dtb.Rows[i]["SoHocTrinh"].ToString());

                    oKQHT_MonThiTotNghiepInfoList.Add(oKQHT_MonThiTotNghiepInfo);
                }
            }
            return(oKQHT_MonThiTotNghiepInfoList);
        }

示例#9

 public void Delete(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo)
 {
     oDKQHT_MonThiTotNghiep.Delete(pKQHT_MonThiTotNghiepInfo);
     mErrorMessage = oDKQHT_MonThiTotNghiep.ErrorMessages;
     mErrorNumber  = oDKQHT_MonThiTotNghiep.ErrorNumber;
 }

示例#10

 public DataTable Get(KQHT_MonThiTotNghiepInfo pKQHT_MonThiTotNghiepInfo)
 {
     return(oDKQHT_MonThiTotNghiep.Get(pKQHT_MonThiTotNghiepInfo));
 }

示例#11

文件： frmMonThiTotNghiep.cs 项目： hiimdat95/Unimos_CNKTHN

 public frmMonThiTotNghiep()
 {
     InitializeComponent();
     pKQHT_MonThiTotNghiepInfo = new KQHT_MonThiTotNghiepInfo();
     oBKQHT_MonThiTotNghiep    = new cBKQHT_MonThiTotNghiep();
 }