Пример #1
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));
        }
Пример #2
0
        public ActionResult Details(long myid)
        {
            TeacherArticleModel myArticlDataContent = new TeacherArticleModel();

            //
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                Teacher_Article myTable           = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == myid && p.Status == 200);
                DataMethodClass myDataMethodClass = new DataMethodClass();
                if (myTable != null)
                {
                    myArticlDataContent.ArticlId     = myid;
                    myArticlDataContent.ArticleTitle = myTable.ArticleTitle;
                    if (!String.IsNullOrWhiteSpace(myTable.ArticleImages))
                    {
                        myArticlDataContent.ArticleImages = StaticVarClass.myDomain + myTable.ArticleImages;
                    }
                    if (!String.IsNullOrWhiteSpace(myTable.ArticleVideo))
                    {
                        myArticlDataContent.ArticleVideo = StaticVarClass.myDomain + myTable.ArticleVideo;
                    }
                    DateTime myDateTime = DateTime.Now;
                    DateTime.TryParse(myTable.AddDate.ToString(), out myDateTime);
                    myArticlDataContent.AddDate        = myDateTime;
                    myArticlDataContent.ArticleAuthor  = myTable.ArticleAuthor;
                    myArticlDataContent.ArticleContent = myTable.ArticleContent;
                    myArticlDataContent.CommentCount   = myOperating.Teacher_Article_Comment.Count(p => p.AboutId == myid);
                    myArticlDataContent.ReadTimes      = myTable.ReadTimes;
                    //
                    #region 阅读次数加一
                    if (myTable.ReadTimes != null)
                    {
                        myTable.ReadTimes = myTable.ReadTimes + 1;
                    }
                    else
                    {
                        myTable.ReadTimes = 1;
                    }
                    myOperating.SaveChanges();
                    #endregion
                }
            }
            return(View(myArticlDataContent));
        }
Пример #3
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));
        }
Пример #4
0
        public JsonResult EditPwd(string username, string pwd)
        {
            StatusData myStatusData = new StatusData();                //返回状态
            //
            DataMethodClass myDataMethodClass = new DataMethodClass(); //检查验证码

            //
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                int checkCodeCount = myOperating.User_CheckCode.Where(p => p.MobilePhone == username && p.AlreadCheck == true).Count();
                if (checkCodeCount > 0)
                {
                    myStatusData = myUserOptionClass.EditPwd(username, pwd);
                }
                else
                {
                    myStatusData.operateStatus = 6;//验证码错误
                }
            }
            return(Json(myStatusData));
        }
Пример #5
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));
 }
Пример #6
0
        //
        #region 加载评论
        public JsonResult CommentList(string articleid, string currentpage)
        {
            List <CommentData> myCommentDataList = new List <CommentData>();

            //
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 翻页属性
                int    recordCount  = 0;
                int    pageCount    = 0;
                string orderbyfiled = "AddDate";
                bool   isDesc       = false;//倒序
                //当前页
                int sqlCurrentpage = 1;
                if (!String.IsNullOrWhiteSpace(currentpage))
                {
                    bool isOk = int.TryParse(currentpage, out sqlCurrentpage);
                    if (!isOk)
                    {
                        sqlCurrentpage = 1;
                    }
                }
                //页大小
                int 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)
                {
                    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();
                    //
                    int PageFloor = (sqlCurrentpage - 1) * sqlPagesize; //楼层计基数
                    int myFloor   = 0;                                  //楼层
                    if (EfDataTable != null)
                    {
                        for (int i = 0; i < EfDataTable.Count(); i++)
                        {
                            myFloor = PageFloor + i + 1;//楼层
                            #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;
                            DateTime myDateTime = DateTime.Now;
                            DateTime.TryParse(EfDataTable[i].AddDate.ToString(), out myDateTime);
                            myCommentData.DateDate  = myDateTime.ToString("yyyy-MM-dd");
                            myCommentData.TimeDate  = myDateTime.ToString("HH-mm");
                            myCommentData.NickName  = myNickName;
                            myCommentData.HeadImage = myHeadImage;
                            myCommentData.FloorNum  = myFloor;
                            myCommentData.PageCount = pageCount;
                            myCommentDataList.Add(myCommentData);
                        }
                    }
                }
            }
            return(Json(myCommentDataList));
        }
Пример #7
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));
        }
Пример #8
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));
        }
Пример #9
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));
        }
Пример #10
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));
        }