Esempio n. 1
0
        public JsonResult GetDistrict(string city)
        {
            //
            StatusData myStatusData = new StatusData();//返回状态

            //
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                try
                {
                    long myLong   = 0;
                    bool isNumber = long.TryParse(city, out myLong);
                    if (isNumber)
                    {
                        var myDataTable = myOperating.Sys_Area_District.Where(p => p.CityID == myLong).OrderBy(p => p.OrderBy).Select(s => new { DistrictName = s.DistrictName, DistrictNum = s.DistrictNum }).ToList();
                        myStatusData.operateStatus = 200;
                        myStatusData.dataTable     = myDataTable;
                    }
                    else
                    {
                        myStatusData.operateStatus = 200;
                    }
                }
                catch
                {
                    myStatusData.operateStatus = -1;
                }
            }
            return(Json(myStatusData));
        }
Esempio n. 2
0
        //
        #region 修改密码
        public StatusData EditPwd(string username, string newpwd)
        {
            StatusData myStatusData = new StatusData();//返回状态
            //
            User_UserName myUserInfo = new User_UserName();

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                myUserInfo = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == username);
                if (myUserInfo == null)
                {
                    myStatusData.operateStatus = 1;//用户名错误
                }
                else
                {
                    if (!String.IsNullOrWhiteSpace(newpwd))
                    {
                        newpwd = Md5Class.CreateMd5(newpwd);//
                        myUserInfo.PassWord = newpwd;
                        myOperating.SaveChanges();

                        myStatusData.operateStatus = 200;
                    }
                    else
                    {
                        myStatusData.operateMsg    = "新密码不能为空";
                        myStatusData.operateStatus = 400;//参数错误
                    }
                }
            }
            return(myStatusData);
        }
Esempio n. 3
0
 public static void ClearTable(string tableName, bool clearAll = false)
 {
     if (!String.IsNullOrWhiteSpace(tableName))
     {
         tableName = tableName.ToLower();
     }
     using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作objectContext.DefaultContainerName
     {
         var _metadataWorkspace = myOperating.ObjectContext.MetadataWorkspace;
         var container          = _metadataWorkspace.GetEntityContainer("chefuzi_dataModelStoreContainer", DataSpace.SSpace);
         IEnumerable <string> myEntitySets;
         if (clearAll)
         {
             myEntitySets = container.EntitySets.Select(e => e.Name);
             if (myEntitySets != null)
             {
                 CheFuZi.DataBaseModel.Configuration.DataCache.InvalidateSets(myEntitySets);
                 CheFuZi.DataBaseModel.Configuration.DataCache.Purge();
             }
         }
         else if (!String.IsNullOrWhiteSpace(tableName))
         {
             myEntitySets = container.EntitySets.Where(p => p.Name.ToLower() == tableName).Select(e => e.Name);
             if (myEntitySets != null)
             {
                 CheFuZi.DataBaseModel.Configuration.DataCache.InvalidateSets(myEntitySets);
                 CheFuZi.DataBaseModel.Configuration.DataCache.Purge();
             }
         }
     }
 }
Esempio n. 4
0
        //
        #region 获得阅读名次
        public static long ReadDayRank(string username)
        {
            long myRank = 0;

            //
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                //
                try
                {
                    RankNum RankNumList = new RankNum();
                    //
                    StringBuilder mySqlStr = new StringBuilder();
                    mySqlStr.Append("SELECT [Extent1].[MobilePhone],[Extent1].[GradeNum] From ( SELECT [Extent1].[MobilePhone] AS [MobilePhone], row_number() OVER (ORDER BY [Extent1].[ReadDayCount] DESC) AS [GradeNum] FROM [RuiKa_Public].[dbo].[User_Book_Click_ReadDay] AS [Extent1])  AS [Extent1] Where [Extent1].[MobilePhone]=@MobilePhone");
                    RankNumList = myOperating.ObjectContext.ExecuteStoreQuery <RankNum>(mySqlStr.ToString(), new SqlParameter("@MobilePhone", username)).FirstOrDefault();

                    if (RankNumList != null)
                    {
                        myRank = RankNumList.GradeNum;
                    }
                }
                catch
                { }
            }
            return(myRank);
        }
Esempio n. 5
0
        //
        #region 获取阅读播放次数
        public int GetReadPlayTimes(int classid, int albumid)
        {
            int            returnCounts = 0;
            Nullable <int> counts       = 0;

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                try
                {
                    switch (classid)
                    {///1点一点;2听一听;3看一看;
                    ///4课程讲解;5幼儿公开课;6教育技能;
                    ///7操作说明;8教师社区;9精彩瞬间;12用户录音
                    case 1:    //点一点
                        counts = myOperating.Child_Book_Click.Where(p => p.BookClassID == albumid).Sum(p => p.ReadCount);
                        break;

                    case 2:    //2听一听
                        counts = myOperating.Child_Audio_List.Where(p => p.AlbumId == albumid).Sum(p => p.PlayTimes);
                        break;

                    case 3:    //3看一看
                        counts = myOperating.Child_Video_List.Where(p => p.AlbumId == albumid).Sum(p => p.PlayTimes);
                        break;
                    }
                }
                catch
                { }
            }
            if (counts != null)
            {
                int.TryParse(counts.ToString(), out returnCounts);
            }
            return(returnCounts);
        }
Esempio n. 6
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. 7
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. 8
0
        /// <summary>
        /// 使用非芮卡家园APP扫码后打开该页下载APP
        /// </summary>
        ///<param name="typestr">1</param>
        /// <param name="codestr">二维码字符串</param>
        /// <returns></returns>
        public ActionResult App(string typestr, string codestr)
        {
            string showMsg   = ""; //提示信息
            int    typeId    = 0;  //类型;1学一学课件注册
            bool   typeIsInt = int.TryParse(typestr, out typeId);

            //-----------------------
            if (typeId == 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 == codestr);
                    if (mySys_BookStudy_QRCode != null)
                    {
                        long myBookId = mySys_BookStudy_QRCode.BookStudyID;
                        if (mySys_BookStudy_QRCode.Used)
                        {//注册码已经使用过
                            showMsg = "该二维码已经使用过,不能再次使用,请核对准确。";
                        }
                        else
                        {
                            #region 要开通那本图书
                            Child_Book_Study myChild_Book_Study = new Child_Book_Study();
                            myChild_Book_Study = myOperating.Child_Book_Study.FirstOrDefault(p => p.BookID == myBookId);
                            if (myChild_Book_Study != null)
                            {
                                showMsg = "要开通:《" + myChild_Book_Study.BookName + "》点读";
                                if (!String.IsNullOrWhiteSpace(myChild_Book_Study.BookImage))
                                {
                                    ViewBag.CoverImage = StaticVarClass.BookStudyResourceUrl + myChild_Book_Study.BookImage;
                                }
                            }
                            else
                            {
                                showMsg = "该电子书不存在,请核实您的二维码。";
                            }
                            #endregion
                        }
                    }
                    else
                    {
                        showMsg = "该编码不存在,请核实您的二维码。";
                    }
                }
                #endregion
            }
            else
            {
                showMsg = "二维码错误。";
            }
            ViewBag.Message = showMsg;
            //========================
            return(View());
        }
Esempio n. 9
0
        public JsonResult Register(string username, string pwd)
        {
            StatusData myStatusData = new StatusData();//返回状态
            //
            DateTime myNowDate = DateTime.Now;
            //
            User_UserName myUserInfo = new User_UserName();

            if (FunctionClass.isMobilePhone(username))
            {//手机号规则判断
                try
                {
                    using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                    {
                        myUserInfo = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == username);
                        if (myUserInfo == null)
                        {
                            int checkCodeCount = myOperating.User_CheckCode.Where(p => p.MobilePhone == username && p.AlreadCheck == true).Count();

                            if (checkCodeCount > 0)
                            {
                                User_UserName newUserInfo = new User_UserName();
                                newUserInfo.MobilePhone       = username;
                                newUserInfo.PassWord          = Md5Class.CreateMd5(pwd);
                                newUserInfo.AddDate           = DateTime.Now;
                                newUserInfo.Status            = 200;
                                newUserInfo.CheckDate         = DateTime.Now;
                                newUserInfo.RecentlyLoginDate = DateTime.Now;
                                newUserInfo.RoleId            = 0;
                                newUserInfo.NickName          = "";
                                myOperating.User_UserName.Add(newUserInfo);
                                myOperating.SaveChanges();
                                myStatusData.operateStatus = 200;
                            }
                            else
                            {
                                myStatusData.operateStatus = 6;//验证码错误
                            }
                        }
                        else
                        {
                            myStatusData.operateStatus = 7;//已经存在
                        }
                    }
                }
                catch
                {
                    myStatusData.operateStatus = -1;
                }
            }
            else
            {//手机号错误
                myStatusData.operateStatus = 400;
            }
            return(Json(myStatusData));
        }
Esempio n. 10
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. 11
0
        public JsonResult LessonList()
        {
            StatusData myStatusData = new StatusData();                           //返回的类型

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
            {
                var myTable = myOperating.Teacher_Video_Class_Lesson.Where(p => p.Status == 200).OrderBy(p => p.OrderBy).Select(s => new { ClassId = s.ClassId, ClassTitle = s.ClassTitle }).ToList();
                myStatusData.dataTable     = myTable;
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 12
0
        public JsonResult BookClassList()
        {
            StatusData myStatusData = new StatusData();                           //返回的类型

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
            {
                var myTable = myOperating.Child_Book_Click_Class.Where(p => p.Status == 200).OrderBy(p => p.OrderBy).Select(s => new { BookClassID = s.BookClassID, BookClassName = s.BookClassName, ClassImage = StaticVarClass.BookClickResourceUrl + s.ClassImage, ImgWidth = s.ImgWidth, ImgHeight = s.ImgHeight }).ToList();
                myStatusData.dataTable     = myTable;
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData));
        }
Esempio n. 13
0
        public JsonResult ClassList()
        {
            StatusData myStatusData = new StatusData();                           //返回的类型

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
            {
                var myTable = myOperating.Child_Audio_Class.Where(p => p.Status == 200).OrderBy(p => p.OrderBy).Select(s => new { ClassId = s.ClassId, ClassTitle = s.ClassTitle }).ToList();
                myStatusData.dataTable     = myTable;
                myStatusData.operateStatus = 200;
            }
            return(Json(myStatusData, JsonRequestBehavior.AllowGet));
        }
Esempio n. 14
0
        //
        #region 获得听一听大类名称
        public string GetAudioClassName(Nullable <int> classid)
        {
            string myClassName = "";

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 所属类别名
                try
                {
                    myClassName = myOperating.Child_Audio_Class.FirstOrDefault(p => p.ClassId == classid).ClassTitle;
                }
                catch
                { }
                #endregion
            }
            return(myClassName);
        }
Esempio n. 15
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. 16
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));
        }
Esempio n. 17
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. 18
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. 19
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. 20
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. 21
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. 22
0
        public bool lookCheckCode(string username, string myCode)
        {
            bool isOk = false;

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                DateTime myNowDate = DateTime.Now;
                int      isExist   = myOperating.User_CheckCode.Count(p => p.MobilePhone == username && p.CheckCode == myCode && p.ExpiredDate > myNowDate);
                if (isExist > 0)
                {
                    isOk = true;
                }
                else
                {
                    isOk = false;
                }
            }
            return(isOk);
        }
Esempio n. 23
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));
        }
Esempio n. 24
0
        public JsonResult GetProvince()
        {
            //
            StatusData myStatusData = new StatusData();//返回状态

            //
            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                try
                {
                    var myDataTable = myOperating.Sys_Area_Province.OrderBy(p => p.OrderBy).Select(s => new { ProvinceName = s.ProvinceName, ProvinceNum = s.ProvinceNum }).ToList();
                    myStatusData.operateStatus = 200;//登录成功
                    myStatusData.dataTable     = myDataTable;
                }
                catch
                {
                    myStatusData.operateStatus = -1;
                }
            }
            return(Json(myStatusData));
        }
Esempio n. 25
0
        public JsonResult CheckCode(string username, string checkcode)
        {
            StatusData myStatusData = new StatusData();//返回状态
            //
            DateTime myNowDate = DateTime.Now;
            //
            User_UserName myUserInfo = new User_UserName();

            try
            {
                using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
                {
                    User_CheckCode myUserCheckCode = myOperating.User_CheckCode.FirstOrDefault(p => p.MobilePhone == username && p.CheckCode == checkcode && p.ExpiredDate > myNowDate);

                    if (myUserCheckCode != null)
                    {
                        try
                        {
                            myUserCheckCode.AlreadCheck = true;
                            myOperating.SaveChanges();
                            myStatusData.operateMsg    = "验证通过";
                            myStatusData.operateStatus = 200;
                        }
                        catch
                        {
                            myStatusData.operateStatus = -1;
                        }
                    }
                    else
                    {
                        myStatusData.operateStatus = 6;//验证码错误
                    }
                }
            }
            catch
            {
                myStatusData.operateStatus = -1;
            }
            return(Json(myStatusData));
        }
Esempio n. 26
0
 //
 #region 文章查看
 public ActionResult ItemView(DiscoverArticleModel model, string ReturnUrl, Nullable <long> myid = 0)
 {
     #region 获取来路路径
     if (System.Web.HttpContext.Current.Request.UrlReferrer != null)
     {
         ViewBag.ReturnUrl = System.Web.HttpContext.Current.Request.UrlReferrer.PathAndQuery;
     }
     #endregion
     ViewBag.Headline = "文章查看";                                            //栏目主题
     //
     using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
     {
         if ((myid > 0) && (model.Operate == null))
         {
             long mySelfId = 0;
             long.TryParse(myid.ToString(), out mySelfId);
             ViewBag.Headline = "文章查看";
             //
             model.Operate = "";
             #region 取出数据
             Discover_Article editRecord = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == mySelfId);
             if (editRecord != null)
             {
                 model.ArticlId       = editRecord.ArticlId;
                 model.MobilePhone    = editRecord.MobilePhone;
                 model.ArticleTitle   = editRecord.ArticleTitle;
                 model.ArticleImages  = FunctionClass.GetFileUrl(editRecord.ArticleImages);
                 model.ArticleVideo   = FunctionClass.GetFileUrl(editRecord.ArticleVideo);
                 model.ArticleContent = editRecord.ArticleContent;
                 model.ReadTimes      = editRecord.ReadTimes;
                 model.OrderBy        = editRecord.OrderBy;
                 model.Status         = editRecord.Status;
                 model.Operate        = "look";
             }
             #endregion
         }
     }
     //
     return(View(model));
 }
Esempio n. 27
0
 //
 #region 用户信息查看
 public ActionResult UserView(User_UserName model, string mobilestr = "")
 {
     #region 获取来路路径
     if (System.Web.HttpContext.Current.Request.UrlReferrer != null)
     {
         ViewBag.ReturnUrl = System.Web.HttpContext.Current.Request.UrlReferrer.PathAndQuery;
     }
     #endregion
     ViewBag.Headline = "用户查看";                                            //栏目主题
     //
     using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
     {
         if (!String.IsNullOrWhiteSpace(mobilestr))
         {
             #region 取出数据
             model = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == mobilestr);
             #endregion
         }
     }
     //
     return(View(model));
 }
Esempio n. 28
0
        public StatusData Login(string username, string pwd, bool remember = true)
        {
            StatusData myStatusData = new StatusData();          //返回状态
            //
            AuthCodeClass myAuthCodeClass = new AuthCodeClass(); //授权码类
            //
            User_UserName myUserInfo = new User_UserName();

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                //
                myUserInfo = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == username);
                if (myUserInfo != null)
                {
                    if (!String.IsNullOrWhiteSpace(pwd))
                    {
                        pwd = Md5Class.CreateMd5(pwd);//
                    }
                    if (myUserInfo.PassWord != pwd)
                    {
                        myStatusData.operateStatus = 2;//密码错误
                    }
                    else if (myUserInfo.Status != 200)
                    {
                        myStatusData.operateStatus = myUserInfo.Status;//201锁定,联系客服
                    }
                    else
                    {
                        string myAuthCodeStr = myAuthCodeClass.CreateAuthCode(myUserInfo.MobilePhone, myUserInfo.RoleId, remember);
                        myStatusData.operateStatus   = 200;//登录成功
                        myStatusData.userAuthCode    = myAuthCodeStr;
                        myUserInfo.RecentlyLoginDate = DateTime.Now;
                        myOperating.SaveChanges();
                    }
                }
            }
            return(myStatusData);
        }
Esempio n. 29
0
        //
        #region 获取用户昵称和头像
        public bool GetNickNameAndPic(string username, out string nickname, out string headimage)
        {
            bool isOk = false;

            using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
            {
                #region 昵称和头像
                headimage = StaticVarClass.DefaultHeadImage; //头像
                nickname  = "匿名";                            //昵称
                if (!String.IsNullOrWhiteSpace(username))
                {
                    User_UserName myUserNameTable = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == username);
                    if (myUserNameTable != null)
                    {
                        if (!String.IsNullOrWhiteSpace(myUserNameTable.NickName))
                        {//昵称
                            nickname = myUserNameTable.NickName;
                        }
                        else
                        {
                            if (myUserNameTable.MobilePhone.Length > 7)
                            {
                                nickname = myUserNameTable.MobilePhone.Substring(7) + "****";
                            }
                        }
                        //
                        if (!String.IsNullOrWhiteSpace(myUserNameTable.HeadImage))
                        {//头像
                            headimage = StaticVarClass.myDomain + myUserNameTable.HeadImage;
                        }
                        isOk = true;
                    }
                }
                #endregion
            }
            return(isOk);
        }
Esempio n. 30
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));
        }