コード例 #1
0
        public JsonResult GetAllSubject(TranferObj obj)
        {
            TBSUBJECT_BUS        bus     = new TBSUBJECT_BUS();
            string               message = string.Empty;
            List <TBSUBJECT_OBJ> li      = null;

            li = bus.getListByDepartmentCode(obj);
            bus.CloseConnection();
            if (obj.semester != null)
            {
                message = "Danh sách môn học theo kỳ : " + obj.semester;
            }
            else if (obj.speciality != null)
            {
                message = "Danh sách môn học theo theo chuyên ngành";
            }
            return(Json(new
            {
                data = li, //Danh sách
                message = message,
                ret = 0    //ok
            }, JsonRequestBehavior.AllowGet));
        }
コード例 #2
0
ファイル: TBSUBJECT_BUS.cs プロジェクト: VijayMVC/QLSV
        public List <TBSUBJECT_OBJ> getListByDepartmentCode(TranferObj obj)
        {
            List <TBSUBJECT_OBJ> lidata = new List <TBSUBJECT_OBJ>();
            string     sql = "GET_SUBJECT_BY_SPECIALITY";
            SqlCommand cm  = new SqlCommand();

            cm.CommandText = sql;
            cm.CommandType = CommandType.StoredProcedure;
            cm.Parameters.AddWithValue("@specialitycode", obj.speciality == null ? "" : obj.speciality);
            cm.Parameters.AddWithValue("@semester", Convert.ToInt16(obj.semester));
            cm.Parameters.AddWithValue("@leveleducation", obj.leveleducation);
            DataSet ds  = new DataSet();
            int     ret = db.getCommand(ref ds, "Tmp", cm);

            if (ret < 0)
            {
                return(null);
            }
            else
            {
                lidata = FillToOBJ(ds);
            }
            return(lidata);
        }