Esempio n. 1
0
        public JsonResult GetBgSound(string currentpage, string pagesize)
        {
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            StatusData myStatusData = new StatusData();//返回状态
            //
            if (checkAuthCodeBool)
            {
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    #region 翻页属性
                    int    recordCount  = 0;
                    int    pageCount    = 0;
                    string orderbyfiled = "OrderBy";
                    bool   isDesc       = true;//倒序
                    //当前页
                    int sqlCurrentpage = 1;
                    if (!String.IsNullOrWhiteSpace(currentpage))
                    {
                        bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                        if (!isOk)
                        {
                            sqlCurrentpage = 1;
                        }
                    }
                    //页大小
                    int sqlPagesize = 10;
                    if (!String.IsNullOrWhiteSpace(pagesize))
                    {
                        bool isOk = int.TryParse(pagesize, out sqlPagesize);
                        if (!isOk)
                        {
                            sqlPagesize = 10;
                        }
                    }
                    #endregion
                    IQueryable <Audio_Background> myIQueryable = null;

                    myIQueryable = myOperating.Audio_Background;
                    //
                    if (myIQueryable != null)
                    {
                        var BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { BgMusicId = s.BgMusicId, MusicTitle = s.MusicTitle, MusicUrl = StaticVarClass.myDomain + s.MusicUrl, TimeSeconds = s.TimeSeconds }).ToList();
                        myStatusData.dataPageCount   = pageCount;
                        myStatusData.dataRecordCount = recordCount;
                        myStatusData.dataTable       = BookTable;
                    }
                    myStatusData.operateStatus = 200;
                }
            }
            else
            {
                myStatusData.operateStatus = 5;//登陆失效
            }
            return(Json(myStatusData));
        }
Esempio n. 2
0
        public JsonResult ArticleContent(string articleid)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                ArticlDataContent myArticlDataContent = new ArticlDataContent();
                long myLong = 0;//文章主键
                bool isLong = long.TryParse(articleid, out myLong);
                if (isLong)
                {
                    Teacher_Article myTable           = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == myLong && p.Status == 200);
                    DataMethodClass myDataMethodClass = new DataMethodClass();
                    if (myTable != null)
                    {
                        myArticlDataContent.ArticleId    = myLong;
                        myArticlDataContent.ArticleTitle = myTable.ArticleTitle;
                        if (!String.IsNullOrWhiteSpace(myTable.ArticleImages))
                        {
                            myArticlDataContent.ArticleImages = StaticVarClass.myDomain + myTable.ArticleImages;
                        }
                        else
                        {
                            myArticlDataContent.ArticleImages = StaticVarClass.myDomain + "defaultTeacherArticle.png";
                        }
                        myArticlDataContent.AddDate   = myTable.AddDate;
                        myArticlDataContent.ReadTimes = myTable.ReadTimes;
                        myArticlDataContent.OpenUrl   = StaticVarClass.myDomain + "Community/" + myLong + ".html";
                        //
                        #region 阅读次数加一
                        if (myTable.ReadTimes != null)
                        {
                            myTable.ReadTimes = myTable.ReadTimes + 1;
                        }
                        else
                        {
                            myTable.ReadTimes = 1;
                        }
                        myOperating.SaveChanges();
                        #endregion
                    }
                    myStatusData.dataTable = myArticlDataContent;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 3
0
        public JsonResult AddComment(string articleid, string content)
        {
            StatusData myStatusData = new StatusData(); //返回的类型
            string     mobilePhone  = "";               //

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
                //
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    Discover_Article_Comment myRecord = new Discover_Article_Comment();

                    long myLong = 0;//要评论的文章
                    bool isOk   = long.TryParse(articleid, out myLong);
                    if (isOk)
                    {
                        try
                        {
                            myRecord.AboutId     = myLong;
                            myRecord.Detail      = content;
                            myRecord.MobilePhone = mobilePhone;
                            myRecord.NickName    = "";
                            myRecord.AddDate     = DateTime.Now;
                            myRecord.Status      = 200;
                            myOperating.Discover_Article_Comment.Add(myRecord);
                            myOperating.SaveChanges();
                            myStatusData.operateStatus = 200;
                        }
                        catch
                        {
                            myStatusData.operateStatus = -1;
                        }
                    }
                    else
                    {
                        myStatusData.operateStatus = 400;
                        myStatusData.operateMsg    = "参数错误";
                    }
                }
            }
            else
            {
                myStatusData.operateStatus = 5;
            }
            return(Json(myStatusData));
        }
Esempio n. 4
0
        //
        #region 检查是否收藏
        public bool CollectExist(int classid, long aboutid, bool isTeacherVideo = false)
        {//
            //
            bool isExist = false;

            //
            #region 检查授权
            string           mobilePhone        = "";//手机号
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
                //
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    int myCount = 0;
                    //
                    try
                    {
                        if (isTeacherVideo)
                        {//classid=45679
                            myCount = myOperating.User_Collect.Count(p => p.MobilePhone == mobilePhone && p.IsTeacherVideo == true && p.AboutId == aboutid);
                        }
                        else
                        {
                            myCount = myOperating.User_Collect.Count(p => p.MobilePhone == mobilePhone && p.ClassId == classid && p.AboutId == aboutid);
                        }

                        if (myCount > 0)
                        {
                            isExist = true;
                        }
                    }
                    catch
                    {
                        isExist = false;
                    }
                }
            }
            return(isExist);
        }
Esempio n. 5
0
 public JsonResult DelCollectItem(string collectid)
 {
     #region 检查授权
     string           myMobilePhone      = "";
     AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
     AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
     bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
     #endregion
     //
     StatusData myStatusData = new StatusData();//返回状态
     //
     if (checkAuthCodeBool)
     {
         myMobilePhone = myAuthCodeInstance.mobilePhone;
         try
         {
             using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
             {
                 long         myLong         = 0;                                  //
                 bool         isLong         = long.TryParse(collectid, out myLong);
                 User_Collect myUser_Collect = new User_Collect();
                 myUser_Collect = myOperating.User_Collect.FirstOrDefault(p => p.MobilePhone == myMobilePhone && p.CollectId == myLong);;
                 //
                 if (myUser_Collect != null)
                 {
                     myOperating.User_Collect.Remove(myUser_Collect);
                     //
                     myOperating.SaveChanges();
                     //
                     myStatusData.operateStatus = 200;
                 }
             }
         }
         catch
         {
             myStatusData.operateStatus = -1;
         }
     }
     else
     {
         myStatusData.operateStatus = 5;
     }
     return(Json(myStatusData));
 }
Esempio n. 6
0
        public JsonResult GetAudio(string myid)
        {                                               //orderby=1按日期排序,2按播放次数排序
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                if (!String.IsNullOrWhiteSpace(myid))
                {
                    long myLong = 0;
                    bool isOk   = long.TryParse(myid, out myLong);
                    if (isOk)
                    {
                        //
                        var myChild_Audio_List = myOperating.Child_Audio_List.Join(myOperating.Child_Audio_Album, tL => tL.AlbumId, album => album.AlbumId, (tL, album) => new { tL.AudioId, tL.AudioTitle, album.AlbumImage, tL.AudioUrl, tL.AudioWords, tL.PlayTimes, tL.TimeSeconds, tL.Status }).Where(p => p.AudioId == myLong && p.Status == 200).Select(s => new { AudioId = s.AudioId, AudioTitle = s.AudioTitle, AudioImage = StaticVarClass.myDomain + s.AlbumImage, AudioUrl = StaticVarClass.myDomain + s.AudioUrl, AudioWords = s.AudioWords, PlayTimes = s.PlayTimes, TimeSeconds = s.TimeSeconds }).ToList();
                        if (myChild_Audio_List != null)
                        {
                            myStatusData.dataTable = myChild_Audio_List;
                        }
                        myStatusData.operateStatus = 200;
                    }
                    else
                    {
                        myStatusData.operateStatus = 400;
                    }
                }
                else
                {
                    myStatusData.operateStatus = 400;
                }
            }
            return(Json(myStatusData));
        }
Esempio n. 7
0
        public JsonResult GetBook(string myid)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                if (!String.IsNullOrWhiteSpace(myid))
                {
                    long myLong = 0;
                    bool isOk   = long.TryParse(myid, out myLong);
                    if (isOk)
                    {
                        var myChild_Book_Click = myOperating.Child_Book_Click.Where(p => p.BookID == myLong && p.BookStatus == 200).Select(s => new { BookID = s.BookID, BookName = s.BookName, BookOnlineUrl = StaticVarClass.BookClickResourceUrl + s.BookOnlineUrl, ScreenH = s.ScreenH }).ToList();
                        if (myChild_Book_Click != null)
                        {
                            myStatusData.dataTable = myChild_Book_Click;
                        }
                        myStatusData.operateStatus = 200;
                    }
                    else
                    {
                        myStatusData.operateStatus = 400;
                    }
                }
                else
                {
                    myStatusData.operateStatus = 400;
                }
            }

            return(Json(myStatusData));
        }
Esempio n. 8
0
        public JsonResult GetUserInfo()
        {
            StatusData myStatusData = new StatusData();//返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            if (checkAuthCodeBool)
            {
                DataMethodClass myDataMethodClass = new DataMethodClass();//检查验证码
                //
                //User_UserName myUserInfo = new User_UserName();
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    var myUserInfo = myOperating.User_UserName.Select(s => new { MobilePhone = s.MobilePhone, HeadImage = StaticVarClass.myDomain + s.HeadImage, NickName = s.NickName, Sex = s.Sex, BirthDate = s.BirthDate, ProvinceName = s.ProvinceName, CityName = s.CityName, DistrictName = s.DistrictName, DistrictNum = s.DistrictNum, Address = s.Address, Kindergarten = s.Kindergarten, RoleId = s.RoleId }).FirstOrDefault(p => p.MobilePhone == myAuthCodeInstance.mobilePhone);
                    if (myUserInfo == null)
                    {
                        myStatusData.operateStatus = 1;//用户名错误
                    }
                    else
                    {
                        try
                        {
                            myStatusData.dataTable     = myUserInfo;
                            myStatusData.operateStatus = 200;
                        }
                        catch
                        {
                            myStatusData.operateStatus = -1;
                        }
                    }
                }
            }
            else
            {
                myStatusData.operateStatus = 5;//登陆失效
            }
            return(Json(myStatusData));
        }
Esempio n. 9
0
        public JsonResult GetVideo(string myid)
        {                                               //orderby=1按日期排序,2按播放次数排序
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                if (!String.IsNullOrWhiteSpace(myid))
                {
                    long myLong = 0;
                    bool isOk   = long.TryParse(myid, out myLong);
                    if (isOk)
                    {
                        var myTeacher_Video_List = myOperating.Teacher_Video_List.Where(p => p.VideoId == myLong && p.Status == 200).Select(s => new { VideoId = s.VideoId, VideoTitle = s.VideoTitle, VideoDes = s.VideoDes, VideoImage = StaticVarClass.myDomain + s.VideoImage, VideoUrl = StaticVarClass.myDomain + s.VideoUrl, PlayTimes = s.PlayTimes, TimeSeconds = s.TimeSeconds, ClassId = s.ClassId }).ToList();
                        if (myTeacher_Video_List != null)
                        {
                            myStatusData.dataTable = myTeacher_Video_List;
                        }
                        myStatusData.operateStatus = 200;
                    }
                    else
                    {
                        myStatusData.operateStatus = 400;
                    }
                }
                else
                {
                    myStatusData.operateStatus = 400;
                }
            }
            return(Json(myStatusData));
        }
Esempio n. 10
0
        public JsonResult GetReadDays()
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                if (checkAuthCodeBool)
                {
                    mobilePhone = myAuthCodeInstance.mobilePhone;
                    //
                    ReadCount myReadCount = new ReadCount();
                    //
                    var myUser_Book_Click_ReadDay = myOperating.User_Book_Click_ReadDay.Where(p => p.MobilePhone == mobilePhone).Select(s => new { ReadDayCount = s.ReadDayCount, RecentlyReadBookId = s.RecentlyReadBookId }).FirstOrDefault();
                    if (myUser_Book_Click_ReadDay != null)
                    {
                        myReadCount.RecentlyReadBookId = myUser_Book_Click_ReadDay.RecentlyReadBookId;
                        myReadCount.ReadDayCount       = myUser_Book_Click_ReadDay.ReadDayCount;
                        myReadCount.RankNum            = UserOptionClass.ReadDayRank(mobilePhone);
                    }
                    //
                    myStatusData.dataTable     = myReadCount;
                    myStatusData.operateStatus = 200;
                }
            }

            return(Json(myStatusData));
        }
Esempio n. 11
0
        public JsonResult ArticleList(string classid, string currentpage, string pagesize)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount  = 0;
                int    pageCount    = 0;
                string orderbyfiled = "AddDate";
                bool   isDesc       = true;//倒序
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int sqlPagesize = 10;
                if (!String.IsNullOrWhiteSpace(pagesize))
                {
                    bool isOk = int.TryParse(pagesize, out sqlPagesize);
                    if (!isOk)
                    {
                        sqlPagesize = 10;
                    }
                }
                #endregion
                IQueryable <Teacher_Article> myIQueryable = null;
                if (!String.IsNullOrWhiteSpace(classid))
                {
                    int  myInt = 0;
                    bool isOk  = int.TryParse(classid, out myInt);
                    if ((isOk) && (myInt > 0))
                    {
                        myIQueryable = myOperating.Teacher_Article.Where(p => p.ClassId == myInt && p.Status == 200);
                    }
                    else
                    {
                        myIQueryable = myOperating.Teacher_Article.Where(p => p.Status == 200);
                    }
                }
                else
                {
                    myIQueryable = myOperating.Teacher_Article.Where(p => p.Status == 200);
                }
                //
                if (myIQueryable != null)
                {
                    List <ArticlDataList> myArticlDataList = new List <ArticlDataList>();
                    var EfDataTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { ArticlId = s.ArticlId, ArticleTitle = s.ArticleTitle, ArticleImages = s.ArticleImages, ReadTimes = s.ReadTimes }).ToList();
                    if (EfDataTable != null)
                    {
                        long ArticlId = 0;
                        for (int i = 0; i < EfDataTable.Count(); i++)
                        {
                            ArticlDataList ArticlDataListItem = new ArticlDataList();
                            ArticlId = EfDataTable[i].ArticlId;
                            ArticlDataListItem.ArticleId    = EfDataTable[i].ArticlId;
                            ArticlDataListItem.ArticleTitle = EfDataTable[i].ArticleTitle;
                            if (!String.IsNullOrWhiteSpace(EfDataTable[i].ArticleImages))
                            {
                                ArticlDataListItem.ArticleImages = StaticVarClass.myDomain + EfDataTable[i].ArticleImages;
                            }
                            else
                            {
                                ArticlDataListItem.ArticleImages = StaticVarClass.myDomain + "defaultTeacherArticle.png";
                            }

                            ArticlDataListItem.OpenUrl      = StaticVarClass.myDomain + "Community/" + EfDataTable[i].ArticlId + ".html";
                            ArticlDataListItem.ReadTimes    = EfDataTable[i].ReadTimes;
                            ArticlDataListItem.CommentCount = myOperating.Teacher_Article_Comment.Count(p => p.AboutId == ArticlId);
                            myArticlDataList.Add(ArticlDataListItem);
                        }
                    }

                    myStatusData.dataPageCount   = pageCount;
                    myStatusData.dataRecordCount = recordCount;
                    myStatusData.dataTable       = myArticlDataList;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 12
0
        public JsonResult DeleteItem(string myid, string del)
        {
            #region 检查授权
            string           myMobilePhone      = "";//手机号
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            StatusData myStatusData = new StatusData();//返回状态
            //
            if (checkAuthCodeBool)
            {
                myMobilePhone = myAuthCodeInstance.mobilePhone;

                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
                {
                    int  operatType = 0;                                              //1删除全部,2删除指定
                    long idLong     = 0;
                    #region 判断参数
                    if (!String.IsNullOrWhiteSpace(del))
                    {
                        switch (del.ToLower())
                        {
                        case "all":
                            operatType = 1;
                            break;

                        case "single":
                            if (!String.IsNullOrWhiteSpace(myid))
                            {
                                bool isLong = long.TryParse(myid, out idLong);
                                if (isLong)
                                {
                                    operatType = 2;
                                }
                            }
                            break;
                        }
                    }
                    #endregion
                    //
                    if (operatType == 1)
                    {
                        IQueryable <Child_Audio_List_User> myList = myOperating.Child_Audio_List_User.Where(p => p.MobilePhone == myMobilePhone);
                        if (myList != null)
                        {
                            foreach (Child_Audio_List_User recordItem in myList)
                            {
                                FunctionClass.DeleteFile(recordItem.AudioUrl);
                                myOperating.Child_Audio_List_User.Remove(recordItem);
                            }
                            myOperating.SaveChanges();
                        }
                        myStatusData.operateStatus = 200;
                    }
                    else if (operatType == 2)
                    {
                        Child_Audio_List_User myDataRecord = new Child_Audio_List_User();
                        myDataRecord = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioUserId == idLong && p.MobilePhone == myMobilePhone);
                        if (myDataRecord != null)
                        {
                            FunctionClass.DeleteFile(myDataRecord.AudioUrl);
                            myOperating.Child_Audio_List_User.Remove(myDataRecord);
                            myOperating.SaveChanges();
                            myStatusData.operateStatus = 200;
                        }
                    }
                    else
                    {
                        myStatusData.operateStatus = 0;
                    }
                }
            }
            else
            {
                myStatusData.operateStatus = 5;
            }
            return(Json(myStatusData));
        }
Esempio n. 13
0
        public JsonResult UpdateFile(string filetype, string upfilename)
        {
            StatusData myStatusData = new StatusData();//返回的类型

            #region 检查授权
            string           mobilePhone        = "";
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            string myPath   = "";
            string fileExt  = "";
            string myFolder = "";
            int    RandKey  = 1000;
            string fileName = "";
            string filePath = "";

            //
            #region 判断是否续传
            string upfilenamefullpath = "";
            bool   xuchuan            = false;
            //
            if (!String.IsNullOrWhiteSpace(upfilename))
            {
                upfilenamefullpath = Path.Combine(HttpRuntime.AppDomainAppPath, upfilename);
                if (System.IO.File.Exists(upfilenamefullpath))
                {
                    xuchuan = true;
                }
                else
                {
                    xuchuan = false;
                }
            }
            #endregion
            //
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
                try
                {
                    if (!xuchuan)
                    {
                        #region  是续传,获得文件相关属性
                        folderActions myForderObject = new folderActions();
                        //
                        myPath  = StaticVarClass.ImageFolderCfg + "/" + DateTime.Now.Year.ToString() + "/" + mobilePhone + "/" + DateTime.Now.Month.ToString();
                        fileExt = filetype;
                        #region 判断文件类型
                        if (!String.IsNullOrWhiteSpace(fileExt))
                        {
                            fileExt = fileExt.ToLower();
                        }
                        else
                        {
                            fileExt = "";
                        }
                        switch (fileExt)
                        {
                        case "jpg":
                        case "png":
                        case "gif":
                        case "jpeg":
                            myPath = StaticVarClass.ImageFolderCfg;
                            break;

                        case "mp3":
                        case "aac":
                            myPath = StaticVarClass.AudioFolderCfg;
                            break;

                        case "mov":
                        case "mp4":
                            myPath = StaticVarClass.VideoFolderCfg;
                            break;

                        default:
                            myStatusData.operateStatus = 400;
                            myStatusData.operateMsg    = "文件类型错误";
                            return(Json(myStatusData));
                        }
                        myPath = myPath + "/" + DateTime.Now.Year.ToString() + "/" + mobilePhone + "/" + DateTime.Now.Month.ToString();
                        #endregion
                        //
                        myForderObject.setFolderFullName = myPath;
                        myForderObject.CreateFolder();
                        myFolder = myForderObject.getFolderRealPath;
                        Random ran = new Random(unchecked ((int)DateTime.Now.Ticks));
                        RandKey  = ran.Next(1, 9999);
                        fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + RandKey.ToString();
                        filePath = myFolder + "/" + fileName + "." + fileExt;
                        #endregion
                    }
                    else
                    {//续传,直接用文件路径
                        filePath = upfilenamefullpath;
                    }
                    //
                    try
                    {
                        if ((!xuchuan) && (!System.IO.File.Exists(filePath)))
                        {
                            #region 新文件
                            using (Stream stream = new FileStream(filePath, FileMode.Create, FileAccess.Write))
                            {
                                //将字符信息写入文件系统
                                System.IO.Stream s = HttpContext.Request.InputStream;
                                if (s.Length > 10)
                                {
                                    int    count  = 0;
                                    byte[] buffer = new byte[1024];
                                    while ((count = s.Read(buffer, 0, 1024)) > 0)
                                    {
                                        stream.Write(buffer, 0, count);
                                    }
                                    s.Flush();
                                    s.Close();
                                    s.Dispose();

                                    UploadFileClass myUploadFileClass = new UploadFileClass();
                                    myUploadFileClass.filename = myPath + "/" + fileName + "." + fileExt;
                                    myUploadFileClass.fileurl  = myPath + "/" + fileName + "." + fileExt;
                                    //myUploadFileClass.fileurl = StaticVarClass.myDomain + myPath + "/" + fileName + "." + fileExt;
                                    myStatusData.dataTable     = myUploadFileClass;
                                    myStatusData.operateStatus = 200;
                                }
                                else
                                {
                                    myStatusData.operateMsg    = "文件为空";
                                    myStatusData.operateStatus = 0;
                                }
                            }
                            //
                            #endregion
                        }
                        else if (xuchuan)
                        {
                            #region 续传文件
                            using (Stream stream = new FileStream(filePath, FileMode.Append, FileAccess.Write))
                            {
                                //将字符信息写入文件系统
                                System.IO.Stream s = HttpContext.Request.InputStream;
                                if (s.Length > 10)
                                {
                                    int    count  = 0;
                                    byte[] buffer = new byte[1024];
                                    while ((count = s.Read(buffer, 0, 1024)) > 0)
                                    {
                                        stream.Write(buffer, 0, count);
                                    }
                                    s.Flush();
                                    s.Close();
                                    s.Dispose();
                                    //
                                    UploadFileClass myUploadFileClass = new UploadFileClass();
                                    myUploadFileClass.filename = upfilename;
                                    myUploadFileClass.fileurl  = upfilename;
                                    //myUploadFileClass.fileurl = StaticVarClass.myDomain + upfilename;
                                    myStatusData.dataTable     = myUploadFileClass;
                                    myStatusData.operateStatus = 200;
                                }
                                else
                                {
                                    myStatusData.operateMsg    = "文件为空";
                                    myStatusData.operateStatus = 0;
                                }
                            }
                            #endregion
                        }
                        else
                        {
                            myStatusData.operateStatus = 400;
                            myStatusData.operateMsg    = "文件已经存在";
                        }
                    }
                    catch
                    {//发生错误删除文件
                        if (System.IO.File.Exists(filePath))
                        {
                            System.IO.File.Delete(filePath);
                        }
                        myStatusData.operateStatus = -1;
                    }
                }
                catch
                {
                    myStatusData.operateStatus = -1;
                }
            }
            else
            {
                myStatusData.operateStatus = 5;
            }
            return(Json(myStatusData));
        }
Esempio n. 14
0
        public JsonResult AddCollect(string classid, string aboutid)
        {                                             //
            #region 检查授权
            string           myMobilePhone      = ""; //手机号
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            StatusData myStatusData = new StatusData();//返回状态
            //
            if (checkAuthCodeBool)
            {
                myMobilePhone = myAuthCodeInstance.mobilePhone;
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
                {
                    int  myClassid = 0;                                               //类别
                    long myAboutid = 0;                                               //主键
                    #region 判断输入参数
                    bool classIsNumber = false;                                       //判断输入参数类型
                    bool AboutIsNumber = false;                                       //判断输入参数类型
                    if (!String.IsNullOrEmpty(aboutid))
                    {
                        classIsNumber = int.TryParse(classid, out myClassid);
                    }
                    //
                    if (!String.IsNullOrEmpty(aboutid))
                    {
                        AboutIsNumber = long.TryParse(aboutid, out myAboutid);
                    }
                    //
                    if ((myClassid < 1) || (myClassid > 9) || (myAboutid < 1))
                    {
                        myStatusData.operateMsg    = "输入参数错误";
                        myStatusData.operateStatus = 400;
                        return(Json(myStatusData));
                    }
                    #endregion
                    //
                    #region 检查是否已经收藏
                    int checkUser_Collect = myOperating.User_Collect.Count(p => p.ClassId == myClassid && p.AboutId == myAboutid && p.MobilePhone == myMobilePhone);
                    if (checkUser_Collect > 0)
                    {
                        myStatusData.operateMsg    = "已收藏,不能重复收藏";
                        myStatusData.operateStatus = 400;
                        return(Json(myStatusData));
                    }
                    #endregion
                    //
                    bool   isTeacherVideo = false; //类别为45679的收藏为true
                    bool   isExict        = false; //是否存在
                    string myCoverImage   = "";    //图片
                    string myTitle        = "";    //标题
                    string mySummart      = "";    //摘要
                    #region 根据收藏类别取出图片和标题
                    switch (myClassid)
                    {///1点一点;2听一听;3看一看;
                    ///4课程讲解;5幼儿公开课;6教育技能;
                    ///7操作说明;8教师社区;9精彩瞬间;
                    case 1:    //点一点
                        #region 点一点
                        Child_Book_Click myChild_Book_Click = new Child_Book_Click();
                        myChild_Book_Click = myOperating.Child_Book_Click.FirstOrDefault(p => p.BookID == myAboutid);
                        if (myChild_Book_Click != null)
                        {
                            myTitle = myChild_Book_Click.BookName;
                            if (!String.IsNullOrWhiteSpace(myChild_Book_Click.BookOnlineUrl))
                            {
                                myCoverImage = StaticVarClass.BookClickResourceUrl + myChild_Book_Click.BookOnlineUrl + "main.png";
                            }
                            isExict = true;
                        }
                        #endregion
                        break;

                    case 2:    //2听一听
                        #region 听一听
                        Child_Audio_List myChild_Audio_List = new Child_Audio_List();
                        myChild_Audio_List = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == myAboutid);
                        if (myChild_Audio_List != null)
                        {
                            myTitle = myChild_Audio_List.AudioTitle;
                            int    AlibumId   = myChild_Audio_List.AlbumId;
                            string AudioBgImg = "";
                            try
                            {
                                AudioBgImg = myOperating.Child_Audio_Album.FirstOrDefault(p => p.AlbumId == AlibumId).AlbumImage;
                                if (!String.IsNullOrWhiteSpace(AudioBgImg))
                                {
                                    myCoverImage = StaticVarClass.myDomain + AudioBgImg;
                                }
                            }
                            catch { }

                            isExict = true;
                        }
                        #endregion
                        break;

                    case 3:    //3看一看
                        #region  一看
                        Child_Video_List myChild_Video_List = new Child_Video_List();
                        myChild_Video_List = myOperating.Child_Video_List.FirstOrDefault(p => p.VideoId == myAboutid);
                        if (myChild_Video_List != null)
                        {
                            myTitle      = myChild_Video_List.VideoTitle;
                            myCoverImage = StaticVarClass.myDomain + myChild_Video_List.VideoImage;
                            isExict      = true;
                        }
                        #endregion
                        break;

                    case 4:
                    case 5:
                    case 6:
                    case 7:    //4课程讲解;5幼儿公开课;6教育技能;7操作说明
                        #region 教师社区
                        Teacher_Video_List myTeacher_Video_List = new Teacher_Video_List();
                        myTeacher_Video_List = myOperating.Teacher_Video_List.FirstOrDefault(p => p.VideoId == myAboutid);
                        if (myTeacher_Video_List != null)
                        {
                            myTitle        = myTeacher_Video_List.VideoTitle;
                            myCoverImage   = StaticVarClass.myDomain + myTeacher_Video_List.VideoImage;
                            isExict        = true;
                            isTeacherVideo = true;
                        }
                        #endregion
                        break;

                    case 8:    //8教师社区
                        #region 教师社区
                        Teacher_Article myTeacher_Article = new Teacher_Article();
                        myTeacher_Article = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == myAboutid);
                        if (myTeacher_Article != null)
                        {
                            myTitle = myTeacher_Article.ArticleTitle;
                            if (!String.IsNullOrWhiteSpace(myTeacher_Article.ArticleImages))
                            {
                                myCoverImage = StaticVarClass.myDomain + myTeacher_Article.ArticleImages;
                            }

                            if ((myTeacher_Article.ArticleSummary != null) && (myTeacher_Article.ArticleSummary.Length > 50))
                            {
                                mySummart = myTeacher_Article.ArticleSummary.Substring(0, 50);
                            }
                            else
                            {
                                mySummart = myTeacher_Article.ArticleSummary;
                            }
                            isExict = true;
                        }
                        #endregion
                        break;

                    case 9:    //9精彩瞬间
                        #region 精彩瞬间
                        Discover_Article myDiscover_Article = new Discover_Article();
                        myDiscover_Article = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == myAboutid);
                        if (myDiscover_Article != null)
                        {
                            myTitle = myDiscover_Article.ArticleTitle;
                            if (!String.IsNullOrWhiteSpace(myDiscover_Article.ArticleImages))
                            {    //取出第一幅图
                                string[] imageOne = myDiscover_Article.ArticleImages.Split(';');
                                if (imageOne.Count() > 0)
                                {
                                    myCoverImage = StaticVarClass.myDomain + imageOne[0];
                                }
                            }
                            if ((myDiscover_Article.ArticleContent != null) && (myDiscover_Article.ArticleContent.Length > 50))
                            {
                                mySummart = myDiscover_Article.ArticleContent.Substring(0, 50);
                            }
                            else
                            {
                                mySummart = myDiscover_Article.ArticleContent;
                            }
                            isExict = true;
                        }
                        #endregion
                        break;
                    }
                    #endregion
                    //
                    #region 添加到数据库
                    if (isExict)
                    {
                        try
                        {
                            User_Collect myUser_Collect = new User_Collect();
                            //
                            myUser_Collect.ClassId        = myClassid;
                            myUser_Collect.AboutId        = myAboutid;
                            myUser_Collect.AboutTitle     = myTitle;
                            myUser_Collect.AboutImage     = myCoverImage;
                            myUser_Collect.AboutSummary   = mySummart;
                            myUser_Collect.MobilePhone    = myMobilePhone;
                            myUser_Collect.ClassId        = myClassid;//收藏类别
                            myUser_Collect.CollectDate    = DateTime.Now;
                            myUser_Collect.IsTeacherVideo = isTeacherVideo;
                            myUser_Collect.OrderBy        = 10000;
                            //
                            myOperating.User_Collect.Add(myUser_Collect);
                            myOperating.SaveChanges();
                            myStatusData.operateStatus = 200;
                        }
                        catch
                        {
                            myStatusData.operateStatus = -1;
                        }
                    }
                    else
                    {
                        myStatusData.operateMsg    = "不存在";
                        myStatusData.operateStatus = 400;
                    }
                    #endregion
                }
            }
            else
            {
                myStatusData.operateStatus = 5;//登陆失效
            }
            return(Json(myStatusData));
        }
Esempio n. 15
0
 public JsonResult PublishAudio(string audioid, string operate)
 {                                             //operate=0保存;1保存并发布
     #region 检查授权
     string           myMobilePhone      = ""; //手机号
     AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
     AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
     bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
     #endregion
     //
     StatusData myStatusData = new StatusData();//返回状态
     //
     if (checkAuthCodeBool)
     {
         myMobilePhone = myAuthCodeInstance.mobilePhone;
         using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
         {
             long myLong = 0;
             bool isLong = false;
             if (!String.IsNullOrEmpty(audioid))
             {
                 isLong = long.TryParse(audioid, out myLong);
             }
             if (isLong)
             {
                 #region 修改状态
                 try
                 {
                     Child_Audio_List_User myChild_Audio_List_User = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioUserId == myLong);
                     //
                     if (myChild_Audio_List_User != null)
                     {
                         if (!String.IsNullOrWhiteSpace(operate))
                         {
                             int  myStatus = 0;
                             bool isInt    = int.TryParse(operate, out myStatus);
                             if (isInt)
                             {
                                 if (myStatus == 1)
                                 {
                                     myChild_Audio_List_User.Status = 200;//发布
                                 }
                                 else
                                 {
                                     myChild_Audio_List_User.Status = 300;//撤下
                                 }
                             }
                             else
                             {
                                 myChild_Audio_List_User.Status = 300;//撤下
                             }
                         }
                         else
                         {
                             myChild_Audio_List_User.Status = 300;//撤下
                         }
                         myOperating.SaveChanges();
                         myStatusData.operateStatus = 200;
                     }
                     else
                     {
                         myStatusData.operateStatus = 400;
                     }
                     //
                 }
                 catch
                 {
                     myStatusData.operateStatus = -1;
                 }
                 #endregion
             }
             else
             {
                 myStatusData.operateStatus = 400;
                 myStatusData.operateMsg    = "参数错误";
             }
         }
     }
     else
     {
         myStatusData.operateStatus = 5;//登陆失效
     }
     return(Json(myStatusData));
 }
Esempio n. 16
0
        public JsonResult GetGameList(string classid, string currentpage, string pagesize)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount  = 0;
                int    pageCount    = 0;
                string orderbyfiled = "OrderBy";
                //
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int sqlPagesize = 10;
                if (!String.IsNullOrWhiteSpace(pagesize))
                {
                    bool isOk = int.TryParse(pagesize, out sqlPagesize);
                    if (!isOk)
                    {
                        sqlPagesize = 10;
                    }
                }
                #endregion
                IQueryable <Game_List> myIQueryable = null;
                if (!String.IsNullOrWhiteSpace(classid))
                {
                    int  myInt = 0;
                    bool isOk  = int.TryParse(classid, out myInt);
                    if (isOk)
                    {
                        myIQueryable = myOperating.Game_List.Where(p => p.GameClass == myInt && p.Status == 200);
                    }
                    else
                    {
                        myIQueryable = null;
                    }
                }
                else
                {
                    myIQueryable = myOperating.Game_List.Where(p => p.Status == 200);
                }
                if (myIQueryable != null)
                {
                    var myTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, false).Select(s => new { GameId = s.GameId, GameName = s.GameName, GameImage = StaticVarClass.myDomain + s.GameImage, GameDescribe = s.GameDescribe, GameUrl = s.GameUrl }).ToList();
                    //
                    myStatusData.dataPageCount   = pageCount;
                    myStatusData.dataRecordCount = recordCount;
                    myStatusData.dataTable       = myTable;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 17
0
        public JsonResult ArticleList(string currentpage, string pagesize)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount  = 0;
                int    pageCount    = 0;
                string orderbyfiled = "ArticlId";
                bool   isDesc       = true;//倒序
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int sqlPagesize = 10;
                if (!String.IsNullOrWhiteSpace(pagesize))
                {
                    bool isOk = int.TryParse(pagesize, out sqlPagesize);
                    if (!isOk)
                    {
                        sqlPagesize = 10;
                    }
                }
                #endregion
                IQueryable <Discover_Article> myIQueryable = null;
                myIQueryable = myOperating.Discover_Article.Where(p => p.Status == 200);
                //
                if (myIQueryable != null)
                {
                    List <DiscoverDataItem> DiscoverDataItemList = new List <DiscoverDataItem>();
                    var EfDataTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { ArticlId = s.ArticlId, ArticleTitle = s.ArticleTitle, ArticleImages = s.ArticleImages, AddDate = s.AddDate, ReadTimes = s.ReadTimes, MobilePhone = s.MobilePhone }).ToList();
                    if (EfDataTable != null)
                    {
                        for (int i = 0; i < EfDataTable.Count(); i++)
                        {
                            #region 昵称和头像
                            string          dataMobilePhone   = EfDataTable[i].MobilePhone;
                            DataMethodClass myDataMethodClass = new DataMethodClass();
                            string          myHeadImage       = StaticVarClass.DefaultHeadImage; //头像
                            string          myNickName        = "匿名";                            //昵称
                            myDataMethodClass.GetNickNameAndPic(dataMobilePhone, out myNickName, out myHeadImage);
                            #endregion
                            int  myCommentTimes = 0; //评论次数
                            long myArticlId     = 0; //文章主键
                            myArticlId = EfDataTable[i].ArticlId;
                            DiscoverDataItem myDiscoverDataItem = new DiscoverDataItem();
                            myDiscoverDataItem.ArticleId    = myArticlId;
                            myDiscoverDataItem.ArticleTitle = EfDataTable[i].ArticleTitle;
                            myDiscoverDataItem.ReadTimes    = EfDataTable[i].ReadTimes;
                            myDiscoverDataItem.AddDate      = EfDataTable[i].AddDate;
                            //
                            myDiscoverDataItem.NickName  = myNickName;
                            myDiscoverDataItem.HeadImage = myHeadImage;
                            //
                            myCommentTimes = myOperating.Discover_Article_Comment.Count(p => p.AboutId == myArticlId);
                            //
                            myDiscoverDataItem.CommentTimes = myCommentTimes;
                            //
                            DiscoverDataItemList.Add(myDiscoverDataItem);
                        }
                    }
                    myStatusData.dataPageCount   = pageCount;
                    myStatusData.dataRecordCount = recordCount;
                    myStatusData.dataTable       = DiscoverDataItemList;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 18
0
        public JsonResult ArticleContent(string articleid)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                DiscoverDataContent myDiscoverDataContent = new DiscoverDataContent();
                long myLong = 0;//文章主键
                bool isLong = long.TryParse(articleid, out myLong);
                if (isLong)
                {
                    Discover_Article myTable = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == myLong && p.Status == 200);
                    if (myTable != null)
                    {
                        #region 昵称和头像
                        string          dataMobilePhone   = myTable.MobilePhone;
                        DataMethodClass myDataMethodClass = new DataMethodClass();
                        string          myHeadImage       = StaticVarClass.DefaultHeadImage; //头像
                        string          myNickName        = "匿名";                            //昵称
                        myDataMethodClass.GetNickNameAndPic(dataMobilePhone, out myNickName, out myHeadImage);
                        #endregion
                        int myCommentTimes = 0;//评论次数
                        myDiscoverDataContent.ArticleId      = myTable.ArticlId;
                        myDiscoverDataContent.ArticleTitle   = myTable.ArticleTitle;
                        myDiscoverDataContent.ArticleImages  = FunctionClass.GetFileUrl(myTable.ArticleImages);
                        myDiscoverDataContent.ArticleVideo   = FunctionClass.GetFileUrl(myTable.ArticleVideo);
                        myDiscoverDataContent.ArticleContent = myTable.ArticleContent;
                        myDiscoverDataContent.AddDate        = myTable.AddDate;
                        myDiscoverDataContent.ReadTimes      = myTable.ReadTimes;
                        myCommentTimes = myOperating.Discover_Article_Comment.Count(p => p.AboutId == myLong);
                        //
                        myDiscoverDataContent.CommentTimes = myCommentTimes;
                        myDiscoverDataContent.HeadImage    = myHeadImage;
                        myDiscoverDataContent.NickName     = myNickName;
                        //
                        #region 阅读次数加一
                        if (myTable.ReadTimes != null)
                        {
                            myTable.ReadTimes = myTable.ReadTimes + 1;
                        }
                        else
                        {
                            myTable.ReadTimes = 1;
                        }
                        myOperating.SaveChanges();
                        #endregion
                    }
                    myStatusData.dataTable = myDiscoverDataContent;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 19
0
 public JsonResult EditUserInfo(string headimage, string nickname, string birthdate, string districtnum, string address, string kindergarten, string roleid)
 {
     #region 检查授权
     AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
     AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
     bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
     #endregion
     //
     StatusData myStatusData = new StatusData();//返回状态
     //
     if (checkAuthCodeBool)
     {
         DataMethodClass myDataMethodClass = new DataMethodClass();//检查验证码
         //
         User_UserName myUserInfo = new User_UserName();
         using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
         {
             myUserInfo = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == myAuthCodeInstance.mobilePhone);
             if (myUserInfo == null)
             {
                 myStatusData.operateStatus = 1;//用户名错误
             }
             else
             {
                 int nickNameExist = 0;
                 #region 用户昵称是否可用
                 if (!String.IsNullOrEmpty(nickname))
                 {
                     nickNameExist = myOperating.User_UserName.Count(p => p.MobilePhone != myAuthCodeInstance.mobilePhone && p.NickName == nickname);
                 }
                 #endregion
                 //
                 if (nickNameExist == 0)
                 {
                     try
                     {
                         #region 修改信息
                         if (!String.IsNullOrEmpty(headimage))
                         {
                             string temPath = headimage.Replace("\\", "/");
                             if (temPath.IndexOf("http://") == 0)
                             {
                                 int domainPosition = 0;
                                 temPath        = temPath.Replace("http://", "");
                                 domainPosition = temPath.IndexOf('/') + 1;
                                 if (domainPosition < temPath.Length)
                                 {
                                     temPath = temPath.Substring(domainPosition);
                                 }
                             }
                             myUserInfo.HeadImage = temPath;
                         }
                         if (!String.IsNullOrEmpty(nickname))
                         {
                             myUserInfo.NickName = nickname;
                         }
                         if (!String.IsNullOrEmpty(birthdate))
                         {
                             DateTime myDateTime = DateTime.Now;
                             bool     isTrue     = DateTime.TryParse(birthdate, out myDateTime);
                             if (isTrue)
                             {
                                 myUserInfo.BirthDate = myDateTime;
                             }
                         }
                         #region  择地区
                         if (!String.IsNullOrEmpty(districtnum))
                         {
                             int  myInt  = 0;
                             bool isTrue = int.TryParse(districtnum, out myInt);
                             if (isTrue)
                             {
                                 Sys_Area_District myDistrictTable = myOperating.Sys_Area_District.FirstOrDefault(p => p.DistrictNum == myInt);
                                 if (myDistrictTable != null)
                                 {
                                     myUserInfo.DistrictNum  = myDistrictTable.DistrictNum;
                                     myUserInfo.DistrictName = myDistrictTable.DistrictName;
                                     Sys_Area_City myCity = myOperating.Sys_Area_City.FirstOrDefault(p => p.CityNum == myDistrictTable.CityID);
                                     if (myCity != null)
                                     {
                                         myUserInfo.CityNum  = myCity.CityNum;
                                         myUserInfo.CityName = myCity.CityName;
                                         Sys_Area_Province myProvince = myOperating.Sys_Area_Province.FirstOrDefault(p => p.ProvinceNum == myCity.ProvinceID);
                                         if (myProvince != null)
                                         {
                                             myUserInfo.ProvinceNum  = myProvince.ProvinceNum;
                                             myUserInfo.ProvinceName = myProvince.ProvinceName;
                                         }
                                     }
                                 }
                             }
                         }
                         #endregion
                         if (!String.IsNullOrEmpty(address))
                         {
                             myUserInfo.Address = address;
                         }
                         if (!String.IsNullOrEmpty(kindergarten))
                         {
                             myUserInfo.Kindergarten = kindergarten;
                         }
                         if (!String.IsNullOrEmpty(roleid))
                         {
                             if (myUserInfo.RoleId < 100)
                             {
                                 int  myInt  = 0;
                                 bool isTrue = int.TryParse(roleid, out myInt);
                                 if (isTrue)
                                 {
                                     myUserInfo.RoleId = myInt;
                                 }
                             }
                         }
                         #endregion
                         myOperating.SaveChanges();
                         myStatusData.operateStatus = 200;
                     }
                     catch
                     {
                         myStatusData.operateStatus = -1;
                     }
                 }
                 else
                 {
                     myStatusData.operateStatus = 400;
                     myStatusData.operateMsg    = "该用户昵称已经存在";
                 }
             }
         }
     }
     else
     {
         myStatusData.operateStatus = 5;//登陆失效
     }
     return(Json(myStatusData));
 }
Esempio n. 20
0
        public JsonResult AudioList(string albumid, string currentpage, string pagesize, string orderby, string isasc)
        {                                               //orderby=1按日期排序,2按播放次数排序
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount  = 0;
                int    pageCount    = 0;
                string orderbyfiled = "OrderBy";
                bool   isDesc       = true;//倒序
                //
                #region 指定排序规则
                if (String.IsNullOrWhiteSpace(orderby))
                {
                    orderby = "";
                }
                switch (orderby)
                {
                case "1":
                    orderbyfiled = "AddDate";
                    break;

                case "2":
                    orderbyfiled = "PlayTimes";
                    break;
                }
                if (String.IsNullOrWhiteSpace(isasc))
                {
                    isasc = "";
                }
                switch (isasc)
                {
                case "1":
                    isDesc = true;    //倒序
                    break;

                case "2":
                    isDesc = false;    //倒序
                    break;
                }
                #endregion
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int sqlPagesize = 10;
                if (!String.IsNullOrWhiteSpace(pagesize))
                {
                    bool isOk = int.TryParse(pagesize, out sqlPagesize);
                    if (!isOk)
                    {
                        sqlPagesize = 10;
                    }
                }
                #endregion
                string soundBgImage = "";//获取专辑图片
                IQueryable <Child_Audio_List> myIQueryable = null;
                if (!String.IsNullOrWhiteSpace(albumid))
                {
                    int  myInt = 0;
                    bool isOk  = int.TryParse(albumid, out myInt);
                    if (isOk)
                    {
                        #region 背景图片
                        Child_Audio_Album myChild_Audio_Album = myOperating.Child_Audio_Album.FirstOrDefault(p => p.AlbumId == myInt);
                        if (myChild_Audio_Album != null)
                        {
                            soundBgImage = StaticVarClass.myDomain + myChild_Audio_Album.AlbumImage;
                        }
                        #endregion
                        myIQueryable = myOperating.Child_Audio_List.Where(p => p.AlbumId == myInt && p.Status == 200);
                    }
                    else
                    {
                        myIQueryable = null;
                        myStatusData.operateStatus = 400;
                    }
                }
                //
                if (myIQueryable != null)
                {
                    var BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { AudioId = s.AudioId, AudioTitle = s.AudioTitle, AudioImage = soundBgImage, AudioUrl = StaticVarClass.myDomain + s.AudioUrl, PlayTimes = s.PlayTimes, TimeSeconds = s.TimeSeconds, AudioWords = s.AudioWords, AddDate = s.AddDate }).ToList();
                    //
                    myStatusData.dataPageCount   = pageCount;
                    myStatusData.dataRecordCount = recordCount;
                    myStatusData.dataTable       = BookTable;
                    myStatusData.operateStatus   = 200;
                }
            }
            return(Json(myStatusData));
        }
Esempio n. 21
0
        public JsonResult GetCollectList(string classid, string currentpage, string pagesize)
        {
            ///1点一点;2听一听;3看一看;
            ///4课程讲解;5幼儿公开课;6教育技能;
            ///7操作说明;8教师社区;9精彩瞬间;
            #region 检查授权
            string           myMobilePhone      = "";
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            StatusData myStatusData = new StatusData();//返回状态
            //
            if (checkAuthCodeBool)
            {
                myMobilePhone = myAuthCodeInstance.mobilePhone;

                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    #region 翻页属性
                    int    recordCount  = 0;
                    int    pageCount    = 0;
                    string orderbyfiled = "CollectDate";
                    bool   isDesc       = true;//倒序
                    //当前页
                    int sqlCurrentpage = 1;
                    if (!String.IsNullOrWhiteSpace(currentpage))
                    {
                        bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                        if (!isOk)
                        {
                            sqlCurrentpage = 1;
                        }
                    }
                    //页大小
                    int sqlPagesize = 10;
                    if (!String.IsNullOrWhiteSpace(pagesize))
                    {
                        bool isOk = int.TryParse(pagesize, out sqlPagesize);
                        if (!isOk)
                        {
                            sqlPagesize = 10;
                        }
                    }
                    int myInt = 0;
                    #endregion
                    if (!String.IsNullOrWhiteSpace(classid))
                    {
                        bool isInt = int.TryParse(classid, out myInt);
                    }
                    //
                    IQueryable <User_Collect> myIQueryable = null;
                    if (myInt > 0)
                    {
                        myIQueryable = myOperating.User_Collect.Where(p => p.MobilePhone == myMobilePhone && p.ClassId == myInt);
                    }
                    else
                    {
                        myIQueryable = myOperating.User_Collect.Where(p => p.MobilePhone == myMobilePhone);
                    }
                    //
                    if (myIQueryable != null)
                    {
                        List <collectData> collectDataList = new List <collectData>();
                        var CollcetTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { CollectId = s.CollectId, ClassId = s.ClassId, AboutId = s.AboutId, AboutTitle = s.AboutTitle, AboutImage = s.AboutImage, AboutSummary = s.AboutSummary, CollectDate = s.CollectDate }).ToList();
                        for (int i = 0; i < CollcetTable.Count; i++)
                        {
                            collectData collectDataItem = new collectData();
                            collectDataItem.CollectId = CollcetTable[i].CollectId;
                            collectDataItem.ClassId   = CollcetTable[i].ClassId;
                            long aboutId = CollcetTable[i].AboutId;
                            #region 听一听返回时长和播放次数
                            if (collectDataItem.ClassId == 2)
                            { //听一听返回时长和播放次数
                                Child_Audio_List myChild_Audio_List = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == aboutId);
                                if (myChild_Audio_List != null)
                                {
                                    collectDataItem.TimeSeconds = myChild_Audio_List.TimeSeconds;
                                    collectDataItem.PlayTimes   = myChild_Audio_List.PlayTimes;
                                }
                            }
                            #endregion
                            collectDataItem.AboutId      = aboutId;
                            collectDataItem.AboutTitle   = CollcetTable[i].AboutTitle;
                            collectDataItem.AboutImage   = CollcetTable[i].AboutImage;
                            collectDataItem.AboutSummary = CollcetTable[i].AboutSummary;
                            collectDataItem.CollectDate  = CollcetTable[i].CollectDate;
                            collectDataList.Add(collectDataItem);
                        }
                        //
                        myStatusData.dataPageCount   = pageCount;
                        myStatusData.dataRecordCount = recordCount;
                        myStatusData.dataTable       = collectDataList;
                    }
                    myStatusData.operateStatus = 200;
                }
            }
            else
            {
                myStatusData.operateStatus = 5;
            }
            return(Json(myStatusData));
        }
Esempio n. 22
0
        public JsonResult AddArticleContent(string articletitle, string content, string images, string videos)
        {
            //
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            #region 判断条件
            if (String.IsNullOrWhiteSpace(articletitle.Trim()))
            {
                myStatusData.operateStatus = 400;
                myStatusData.operateMsg    = "标题不能为空";
                return(Json(myStatusData));
            }
            else if (articletitle.Trim().Length > 50)
            {
                myStatusData.operateStatus = 400;
                myStatusData.operateMsg    = "标题不能多于50个字符";
                return(Json(myStatusData));
            }
            if (String.IsNullOrWhiteSpace(content.Trim()))
            {
                myStatusData.operateStatus = 400;
                myStatusData.operateMsg    = "内容不能为空";
                return(Json(myStatusData));
            }
            else if (content.Trim().Length < 2)
            {
                myStatusData.operateStatus = 400;
                myStatusData.operateMsg    = "内容太少";
                return(Json(myStatusData));
            }
            #endregion
            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    try
                    {
                        Discover_Article myDiscover_Article = new Discover_Article();
                        myDiscover_Article.MobilePhone    = mobilePhone;
                        myDiscover_Article.ArticleTitle   = articletitle;
                        myDiscover_Article.ArticleContent = content;
                        myDiscover_Article.ArticleImages  = images;
                        myDiscover_Article.ArticleVideo   = videos;
                        myDiscover_Article.AddDate        = DateTime.Now;
                        myDiscover_Article.OrderBy        = 10000;
                        myDiscover_Article.PraiseCount    = 0;
                        myDiscover_Article.ReadTimes      = 0;
                        myDiscover_Article.Status         = 200;
                        myOperating.Discover_Article.Add(myDiscover_Article);
                        myOperating.SaveChanges();
                        myStatusData.operateStatus = 200;
                    }
                    catch
                    {
                        myStatusData.operateStatus = -1;
                    }
                }
            }
            else
            {
                myStatusData.operateStatus = 5;
            }
            return(Json(myStatusData));
        }
Esempio n. 23
0
        public JsonResult CommentList(string articleid, string currentpage, string pagesize)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount  = 0;
                int    pageCount    = 0;
                string orderbyfiled = "AddDate";
                bool   isDesc       = true;//倒序
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int sqlPagesize = 10;
                if (!String.IsNullOrWhiteSpace(pagesize))
                {
                    bool isOk = int.TryParse(pagesize, out sqlPagesize);
                    if (!isOk)
                    {
                        sqlPagesize = 10;
                    }
                }
                #endregion
                IQueryable <Teacher_Article_Comment> myIQueryable = null;
                if (!String.IsNullOrWhiteSpace(articleid))
                {
                    long myLong = 0;
                    bool isOk   = long.TryParse(articleid, out myLong);
                    if (isOk)
                    {
                        myIQueryable = myOperating.Teacher_Article_Comment.Where(p => p.AboutId == myLong && p.Status == 200);
                    }
                    else
                    {
                        myIQueryable = null;
                    }
                }
                else
                {
                    myIQueryable = myOperating.Teacher_Article_Comment.Where(p => p.Status == 200);
                }
                //
                if (myIQueryable != null)
                {
                    List <CommentData> myCommentDataList = new List <CommentData>();
                    var EfDataTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).Select(s => new { CommentId = s.CommentId, Detail = s.Detail, AddDate = s.AddDate, MobilePhone = s.MobilePhone }).ToList();
                    //
                    if (EfDataTable != null)
                    {
                        for (int i = 0; i < EfDataTable.Count(); i++)
                        {
                            #region 昵称和头像
                            string          dataMobilePhone   = EfDataTable[i].MobilePhone;
                            DataMethodClass myDataMethodClass = new DataMethodClass();
                            string          myHeadImage       = StaticVarClass.DefaultHeadImage; //头像
                            string          myNickName        = "匿名";                            //昵称
                            myDataMethodClass.GetNickNameAndPic(dataMobilePhone, out myNickName, out myHeadImage);
                            #endregion
                            CommentData myCommentData = new CommentData();
                            myCommentData.CommentId = EfDataTable[i].CommentId;
                            myCommentData.Detail    = EfDataTable[i].Detail;
                            myCommentData.AddDate   = EfDataTable[i].AddDate;
                            myCommentData.NickName  = myNickName;
                            myCommentData.HeadImage = myHeadImage;
                            myCommentDataList.Add(myCommentData);
                        }
                    }
                    //
                    myStatusData.dataPageCount   = pageCount;
                    myStatusData.dataRecordCount = recordCount;
                    myStatusData.dataTable       = myCommentDataList;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 24
0
        public JsonResult PersonalAudioList(string currentpage, string pagesize)
        {
            #region 检查授权
            string           myMobilePhone      = "";//手机号
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            StatusData myStatusData = new StatusData();//返回状态
            //
            if (checkAuthCodeBool)
            {
                myMobilePhone = myAuthCodeInstance.mobilePhone;

                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    #region 翻页属性
                    int    recordCount  = 0;
                    int    pageCount    = 0;
                    string orderbyfiled = "AudioUserId";
                    bool   isDesc       = true;//倒序
                    //当前页
                    int sqlCurrentpage = 1;
                    if (!String.IsNullOrWhiteSpace(currentpage))
                    {
                        bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                        if (!isOk)
                        {
                            sqlCurrentpage = 1;
                        }
                    }
                    //页大小
                    int sqlPagesize = 10;
                    if (!String.IsNullOrWhiteSpace(pagesize))
                    {
                        bool isOk = int.TryParse(pagesize, out sqlPagesize);
                        if (!isOk)
                        {
                            sqlPagesize = 10;
                        }
                    }
                    #endregion
                    IQueryable <Child_Audio_List_User> myIQueryable = null;
                    myIQueryable = myOperating.Child_Audio_List_User.Where(p => p.MobilePhone == myMobilePhone);
                    //
                    if (myIQueryable != null)
                    {
                        var UserSoundTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).ToList();
                        List <PersonalSoundData> myUserSoundDataList = new List <PersonalSoundData>();
                        if (UserSoundTable != null)
                        {
                            for (int i = 0; i < UserSoundTable.Count(); i++)
                            {
                                PersonalSoundData myUserSoundDataItem = new PersonalSoundData();
                                Nullable <long>   myAudioId           = 0; //听一听主键
                                Nullable <int>    myAlbumId           = 0; //专辑主键
                                string            mySoundTitle        = "佚名";
                                string            myAudioWords        = "";
                                string            mySoundImage        = "";//封面图片
                                //
                                myAudioId = UserSoundTable[i].AudioId;
                                #region 音乐名称和歌词
                                if (myAudioId != null)
                                {
                                    Child_Audio_List myChild_Audio_List = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == myAudioId);
                                    if (myChild_Audio_List != null)
                                    {
                                        myAlbumId    = myChild_Audio_List.AlbumId;
                                        mySoundTitle = myChild_Audio_List.AudioTitle;
                                        myAudioWords = myChild_Audio_List.AudioWords;
                                    }
                                }
                                #endregion
                                //
                                #region 背景图片
                                if (myAlbumId != null)
                                {
                                    Child_Audio_Album myChild_Audio_Album = myOperating.Child_Audio_Album.FirstOrDefault(p => p.AlbumId == myAlbumId);
                                    if (myChild_Audio_Album != null)
                                    {
                                        mySoundImage = StaticVarClass.myDomain + myChild_Audio_Album.AlbumImage;
                                    }
                                }
                                #endregion
                                //
                                myUserSoundDataItem.AudioUserId = UserSoundTable[i].AudioUserId;
                                myUserSoundDataItem.MusicTitle  = mySoundTitle;
                                myUserSoundDataItem.AudioImage  = mySoundImage;
                                myUserSoundDataItem.AudioWords  = myAudioWords;
                                myUserSoundDataItem.BgMusicUrl  = StaticVarClass.myDomain + UserSoundTable[i].BgMusicUrl;
                                myUserSoundDataItem.AudioUrl    = StaticVarClass.myDomain + UserSoundTable[i].AudioUrl;
                                myUserSoundDataItem.AddDate     = UserSoundTable[i].AddDate;
                                myUserSoundDataItem.TimeSeconds = UserSoundTable[i].TimeSeconds;
                                myUserSoundDataItem.PlayTimes   = UserSoundTable[i].PlayTimes;
                                myUserSoundDataItem.Status      = UserSoundTable[i].Status;
                                //
                                myUserSoundDataList.Add(myUserSoundDataItem);
                            }
                            myStatusData.dataPageCount   = pageCount;
                            myStatusData.dataRecordCount = recordCount;
                            myStatusData.dataTable       = myUserSoundDataList;
                        }
                    }
                    myStatusData.operateStatus = 200;
                }
            }
            else
            {
                myStatusData.operateStatus = 5;
            }
            return(Json(myStatusData));
        }
Esempio n. 25
0
        public JsonResult VideoList(string classid, string lessonid, string currentpage, string pagesize, string orderby, string isasc)
        {                                               //orderby=1按日期排序,2按播放次数排序
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount   = 0;
                int    pageCount     = 0;
                string orderbyfiled  = "Recommended";
                string orderbyfiled2 = "OrderBy";
                bool   isDesc        = true;//倒序
                //
                #region 指定排序规则
                if (String.IsNullOrWhiteSpace(orderby))
                {
                    orderby = "";
                }
                switch (orderby)
                {
                case "1":
                    orderbyfiled = "AddDate";
                    break;

                case "2":
                    orderbyfiled = "PlayTimes";
                    break;

                case "3":
                    orderbyfiled = "OrderBy";
                    break;
                }
                if (String.IsNullOrWhiteSpace(isasc))
                {
                    isasc = "";
                }
                switch (isasc)
                {
                case "1":
                    isDesc = false;    //正序
                    break;

                case "2":
                    isDesc = true;    //倒序
                    break;
                }
                #endregion
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int sqlPagesize = 10;
                if (!String.IsNullOrWhiteSpace(pagesize))
                {
                    bool isOk = int.TryParse(pagesize, out sqlPagesize);
                    if (!isOk)
                    {
                        sqlPagesize = 10;
                    }
                }
                #endregion
                IQueryable <Teacher_Video_List> myIQueryable = null;
                if (!String.IsNullOrWhiteSpace(classid))
                {
                    int  myInt = 0;
                    bool isOk  = int.TryParse(classid, out myInt);
                    if ((isOk) && (myInt > 0))
                    {
                        //lessonid
                        if (!String.IsNullOrWhiteSpace(lessonid))
                        {//课程类别
                            int myLessonid = 0;
                            isOk = int.TryParse(lessonid, out myLessonid);
                            if ((isOk) && (myLessonid > 0))
                            {
                                myIQueryable = myOperating.Teacher_Video_List.Where(p => p.ClassId == myInt && p.LessonId == myLessonid && p.Status == 200);
                            }
                            else
                            {
                                myIQueryable = myOperating.Teacher_Video_List.Where(p => p.ClassId == myInt && p.Status == 200);
                            }
                        }
                        else
                        {
                            myIQueryable = myOperating.Teacher_Video_List.Where(p => p.ClassId == myInt && p.Status == 200);
                        }
                    }
                    else
                    {
                        myIQueryable = null;
                    }
                }
                else
                {
                    myIQueryable = myOperating.Teacher_Video_List.Where(p => p.Status == 200 && p.Recommended > 0);
                }
                //
                if (myIQueryable != null)
                {
                    var BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc, orderbyfiled2).Select(s => new { VideoId = s.VideoId, VideoTitle = s.VideoTitle, VideoDes = s.VideoDes, VideoImage = StaticVarClass.myDomain + s.VideoImage, VideoUrl = StaticVarClass.myDomain + s.VideoUrl, PlayTimes = s.PlayTimes, TimeSeconds = s.TimeSeconds, ClassId = s.ClassId }).ToList();

                    myStatusData.dataPageCount   = pageCount;
                    myStatusData.dataRecordCount = recordCount;
                    myStatusData.dataTable       = BookTable;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 26
0
        public JsonResult BookList(string bookclassid, string currentpage, string pagesize)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount  = 0;
                int    pageCount    = 0;
                string orderbyfiled = "OrderBy";
                //
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int sqlPagesize = 10;
                if (!String.IsNullOrWhiteSpace(pagesize))
                {
                    bool isOk = int.TryParse(pagesize, out sqlPagesize);
                    if (!isOk)
                    {
                        sqlPagesize = 10;
                    }
                }
                #endregion
                IQueryable <Child_Book_Click> myIQueryable = null;
                if (!String.IsNullOrWhiteSpace(bookclassid))
                {
                    int  myInt = 0;
                    bool isOk  = int.TryParse(bookclassid, out myInt);
                    if (isOk)
                    {
                        myIQueryable = myOperating.Child_Book_Click.Where(p => p.BookClassID == myInt && p.BookStatus == 200);
                    }
                    else
                    {
                        myIQueryable = null;
                    }
                }
                else
                {
                    myIQueryable = myOperating.Child_Book_Click.Where(p => p.BookStatus == 200);
                }
                //
                if (myIQueryable != null)
                {
                    var BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, false).Select(s => new { BookID = s.BookID, BookName = s.BookName, BookOnlineUrl = StaticVarClass.BookClickResourceUrl + s.BookOnlineUrl, ScreenH = s.ScreenH }).ToList();
                    //
                    myStatusData.dataPageCount   = pageCount;
                    myStatusData.dataRecordCount = recordCount;
                    myStatusData.dataTable       = BookTable;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 27
0
        public JsonResult AlbumList(string classid, string currentpage, string pagesize)
        {
            string mobilePhone = "";//
            //
            DataOptionClass myDataOptionClass = new DataOptionClass();
            //
            StatusData myStatusData = new StatusData();//返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
            }
            #endregion
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount  = 0;
                int    pageCount    = 0;
                string orderbyfiled = "OrderBy";
                //
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int sqlPagesize = 10;
                if (!String.IsNullOrWhiteSpace(pagesize))
                {
                    bool isOk = int.TryParse(pagesize, out sqlPagesize);
                    if (!isOk)
                    {
                        sqlPagesize = 10;
                    }
                }
                #endregion
                IQueryable <Child_Audio_Album> myIQueryable = null;
                if (!String.IsNullOrWhiteSpace(classid))
                {
                    int  myInt = 0;
                    bool isOk  = int.TryParse(classid, out myInt);
                    if (isOk)
                    {
                        myIQueryable = myOperating.Child_Audio_Album.Where(p => p.ClassId == myInt && p.Status == 200);
                    }
                    else
                    {
                        myIQueryable = null;
                    }
                }
                else
                {
                    myIQueryable = myOperating.Child_Audio_Album.Where(p => p.Status == 200);
                }
                //
                if (myIQueryable != null)
                {
                    DataMethodClass       myDataMethodClass    = new DataMethodClass();
                    List <AudioAlbumData> myAudioAlbumDataList = new List <AudioAlbumData>();
                    var BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).Select(s => new { AlbumId = s.AlbumId, AlbumTitle = s.AlbumTitle, Anchor = s.Anchor, AlbumImage = StaticVarClass.myDomain + s.AlbumImage, AlbumDescrib = s.AlbumDescrib, AudioCount = s.AudioCount, PlayTimes = s.PlayTimes, ClassId = s.ClassId }).ToList();
                    if (BookTable != null)
                    {
                        for (int i = 0; i < BookTable.Count(); i++)
                        {
                            AudioAlbumData   myAudioAlbumData   = new AudioAlbumData();
                            int              myInt              = BookTable[i].AlbumId;
                            int              ListCount          = 0;//总共数量
                            Child_Audio_List myChild_Audio_List = new Child_Audio_List();
                            ListCount = myOperating.Child_Audio_List.Count(p => p.AlbumId == myInt);
                            //
                            myAudioAlbumData.AlbumId      = BookTable[i].AlbumId;
                            myAudioAlbumData.AlbumTitle   = BookTable[i].AlbumTitle;
                            myAudioAlbumData.Anchor       = BookTable[i].Anchor;
                            myAudioAlbumData.AlbumImage   = BookTable[i].AlbumImage;
                            myAudioAlbumData.AlbumDescrib = BookTable[i].AlbumDescrib;
                            myAudioAlbumData.AudioCount   = ListCount;
                            myAudioAlbumData.PlayTimes    = myDataOptionClass.GetReadPlayTimes(2, myInt);
                            myAudioAlbumData.ClassName    = myDataMethodClass.GetAudioClassName(BookTable[i].ClassId);
                            myAudioAlbumDataList.Add(myAudioAlbumData);
                        }
                    }
                    myStatusData.dataPageCount   = pageCount;
                    myStatusData.dataRecordCount = recordCount;
                    myStatusData.dataTable       = myAudioAlbumDataList;
                }
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 28
0
        public JsonResult PersonalList(string currentpage, string pagesize)
        {
            string mobilePhone = "";                    //
            //
            StatusData myStatusData = new StatusData(); //返回状态

            //
            #region 检查授权
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            if (checkAuthCodeBool)
            {
                mobilePhone = myAuthCodeInstance.mobilePhone;
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    #region 翻页属性
                    int    recordCount  = 0;
                    int    pageCount    = 0;
                    string orderbyfiled = "ArticlId";
                    bool   isDesc       = true;//倒序
                    //当前页
                    int sqlCurrentpage = 1;
                    if (!String.IsNullOrWhiteSpace(currentpage))
                    {
                        bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                        if (!isOk)
                        {
                            sqlCurrentpage = 1;
                        }
                    }
                    //页大小
                    int sqlPagesize = 10;
                    if (!String.IsNullOrWhiteSpace(pagesize))
                    {
                        bool isOk = int.TryParse(pagesize, out sqlPagesize);
                        if (!isOk)
                        {
                            sqlPagesize = 10;
                        }
                    }
                    #endregion
                    IQueryable <Discover_Article> myIQueryable = null;
                    myIQueryable = myOperating.Discover_Article.Where(p => p.MobilePhone == mobilePhone);
                    //
                    if (myIQueryable != null)
                    {
                        List <DiscoverPersonDataItem> DiscoverDataItemList = new List <DiscoverPersonDataItem>();
                        IQueryable <Discover_Article> EfDataTable          = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc);
                        foreach (Discover_Article item in EfDataTable)
                        {
                            DiscoverPersonDataItem dataItem = new DiscoverPersonDataItem();
                            dataItem.ArticleId     = item.ArticlId;
                            dataItem.ArticleTitle  = item.ArticleTitle;
                            dataItem.ArticleImages = FunctionClass.GetFileUrl(item.ArticleImages);
                            dataItem.AddDate       = item.AddDate;
                            dataItem.ReadTimes     = item.ReadTimes;
                            DiscoverDataItemList.Add(dataItem);
                        }
                        myStatusData.dataPageCount   = pageCount;
                        myStatusData.dataRecordCount = recordCount;
                        myStatusData.dataTable       = DiscoverDataItemList;
                    }
                    myStatusData.operateStatus = 200;
                }
            }
            else
            {
                myStatusData.operateStatus = 5;
            }
            return(Json(myStatusData));
        }
Esempio n. 29
0
        public JsonResult Scan(string codestr)
        {
            StatusData myStatusData = new StatusData();//返回状态

            //
            #region 检查授权
            string           myMobilePhone      = "";//手机号码
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            int    myTypeInt   = 0;  //类型;0注册开通课件;1学一学电子书注册
            string myCodeStr   = ""; //二维码
            string tempCodeStr = ""; //临时
            #region 解析二维码字符串
            if (!String.IsNullOrWhiteSpace(codestr))
            {
                tempCodeStr = codestr.ToUpper().Replace(StaticVarClass.QRCodeUrl.ToUpper(), "");
                tempCodeStr = tempCodeStr.Replace("\\", "/");
                string[] temCode = tempCodeStr.Split('/');
                if (temCode.Length > 1)
                {
                    bool isInt = int.TryParse(temCode[0], out myTypeInt);
                    if (isInt)
                    {
                        myCodeStr = temCode[1];//
                    }
                    else
                    {
                        if (myTypeInt < 1)
                        {
                            myStatusData.operateStatus = 400;
                            myStatusData.operateMsg    = "类型错误:" + codestr;
                            return(Json(myStatusData));
                        }
                    }
                }
                else
                {
                    myTypeInt = 0;
                    myCodeStr = codestr;
                }
            }
            else
            {
                myStatusData.operateStatus = 400;
                return(Json(myStatusData));
            }
            #endregion
            //
            if (checkAuthCodeBool)
            {
                myMobilePhone = myAuthCodeInstance.mobilePhone;
                //
                switch (myTypeInt)
                {
                case 0:
                    break;

                case 1:
                    #region 判断并开通学一学电子书
                    using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())    //数据库操作
                    {
                        Sys_BookStudy_QRCode mySys_BookStudy_QRCode = new Sys_BookStudy_QRCode();
                        mySys_BookStudy_QRCode = myOperating.Sys_BookStudy_QRCode.FirstOrDefault(p => p.QRCode == myCodeStr);
                        if (mySys_BookStudy_QRCode != null)
                        {
                            if (mySys_BookStudy_QRCode.Used)
                            {    //注册码已经使用过
                                myStatusData.operateStatus = 500;
                            }
                            else
                            {
                                #region 判断是否已经开通该课程,否则开通
                                int TheBookIsReg = myOperating.User_RegBook_List.Count(p => p.MobilePhone == myMobilePhone && p.BookStudyID == mySys_BookStudy_QRCode.BookStudyID);
                                if (TheBookIsReg == 0)
                                {    //判断该用户是否已经开通该课件
                                    #region 注册开通
                                    User_RegBook_List newUser_RegBook_List = new User_RegBook_List();
                                    int isReg = myOperating.User_RegBook_List.Count(p => p.QRCode == myCodeStr);
                                    if (isReg == 0)
                                    {
                                        newUser_RegBook_List.QRCode      = myCodeStr;
                                        newUser_RegBook_List.MobilePhone = myMobilePhone;
                                        newUser_RegBook_List.BookStudyID = mySys_BookStudy_QRCode.BookStudyID;
                                        newUser_RegBook_List.RegDate     = DateTime.Now;
                                        myOperating.User_RegBook_List.Add(newUser_RegBook_List);
                                        //
                                        mySys_BookStudy_QRCode.MobilePhone = myMobilePhone;
                                        mySys_BookStudy_QRCode.Used        = true;
                                        mySys_BookStudy_QRCode.UsedDate    = DateTime.Now;
                                        //
                                        myOperating.SaveChanges();
                                        myStatusData.operateStatus = 200;
                                    }
                                    else
                                    {
                                        myStatusData.operateStatus = 500;
                                    }
                                    #endregion
                                }
                                else
                                {
                                    myStatusData.operateStatus = 400;
                                    myStatusData.operateMsg    = "已经开通,无需重新开通";
                                }
                                #endregion
                            }
                        }
                        else
                        {
                            myStatusData.operateStatus = 400;
                            myStatusData.operateMsg    = "不存在";
                        }
                    }
                    #endregion
                    break;
                }
                //
            }
            else
            {
                myStatusData.operateStatus = 5;
            }
            return(Json(myStatusData));
        }
Esempio n. 30
0
        public JsonResult AddSoundRecord(string audioid, string audiourl, string bgmusic, string seconds, string operate)
        {                                             //operate=0保存;1保存并发布
            #region 检查授权
            string           myMobilePhone      = ""; //新授权码
            AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
            AuthCodeClass    myAuthCodeClass    = new AuthCodeClass();
            bool             checkAuthCodeBool  = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
            #endregion
            //
            #region 替换域名信息
            if (!String.IsNullOrWhiteSpace(bgmusic))
            {
                bgmusic = bgmusic.ToLower().Replace("http://", "");
                int strIndex = bgmusic.IndexOf('/') + 1;
                if (strIndex < bgmusic.Length)
                {
                    bgmusic = bgmusic.Substring(strIndex);
                }
            }
            #endregion
            //
            StatusData myStatusData = new StatusData();//返回状态
            //
            if (checkAuthCodeBool)
            {
                myMobilePhone = myAuthCodeInstance.mobilePhone;
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    long myLong = 0;
                    bool isLong = false;
                    if (!String.IsNullOrEmpty(audioid))
                    {
                        isLong = long.TryParse(audioid, out myLong);
                    }
                    if (isLong)
                    {
                        try
                        {
                            Child_Audio_List_User oldChild_Audio_List_User = new Child_Audio_List_User();
                            oldChild_Audio_List_User = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioId == myLong && p.MobilePhone == myMobilePhone);
                            if (oldChild_Audio_List_User == null)
                            {
                                #region 添加新的
                                Child_Audio_List_User myChild_Audio_List_User = new Child_Audio_List_User();
                                //
                                myChild_Audio_List_User.AudioId     = myLong;
                                myChild_Audio_List_User.MobilePhone = myMobilePhone;
                                if (!String.IsNullOrEmpty(audiourl))
                                {
                                    myChild_Audio_List_User.AudioUrl = audiourl;
                                }
                                if (!String.IsNullOrEmpty(bgmusic))
                                {
                                    myChild_Audio_List_User.BgMusicUrl = bgmusic;
                                }
                                int myseconds = 0;//时长
                                if (!String.IsNullOrWhiteSpace(seconds))
                                {
                                    int.TryParse(seconds, out myseconds);
                                }
                                myChild_Audio_List_User.TimeSeconds = myseconds;

                                myChild_Audio_List_User.AddDate     = DateTime.Now;
                                myChild_Audio_List_User.PlayTimes   = 0;
                                myChild_Audio_List_User.PraiceCount = 0;
                                myChild_Audio_List_User.OrderBy     = 10000;
                                if (!String.IsNullOrWhiteSpace(operate))
                                {
                                    if (operate == "1")
                                    {
                                        myChild_Audio_List_User.Status = 200;//
                                    }
                                    else
                                    {
                                        myChild_Audio_List_User.Status = 300;//
                                    }
                                }
                                else
                                {
                                    myChild_Audio_List_User.Status = 300;//
                                }
                                myOperating.Child_Audio_List_User.Add(myChild_Audio_List_User);
                                #endregion
                            }
                            else
                            {//修改
                                #region 修改状态
                                if (!String.IsNullOrWhiteSpace(operate))
                                {
                                    if (operate == "1")
                                    {
                                        oldChild_Audio_List_User.Status = 200;//
                                    }
                                    else
                                    {
                                        oldChild_Audio_List_User.Status = 300;//
                                    }
                                }
                                else
                                {
                                    oldChild_Audio_List_User.Status = 300;//
                                }
                                #endregion
                            }
                            myOperating.SaveChanges();
                            myStatusData.operateStatus = 200;
                        }
                        catch
                        {
                            myStatusData.operateStatus = -1;
                        }
                    }
                    else
                    {
                        myStatusData.operateStatus = 400;
                        myStatusData.operateMsg    = "参数错误";
                    }
                }
            }
            else
            {
                myStatusData.operateStatus = 5;//登陆失效
            }
            return(Json(myStatusData));
        }