// #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); }
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)); }
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)); }
// #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)); }
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); }
// #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); }
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)); }
public JsonResult GetUserSoundList(string currentpage, string pagesize) { #region 检查授权 AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance(); AuthCodeClass myAuthCodeClass = new AuthCodeClass(); bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance); #endregion // StatusData myStatusData = new StatusData(); //返回状态 // 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; // if (myIQueryable != null) { var UserSoundTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc).ToList(); List <UserSoundData> myUserSoundDataList = new List <UserSoundData>(); if (UserSoundTable != null) { for (int i = 0; i < UserSoundTable.Count(); i++) { UserSoundData myUserSoundDataItem = new UserSoundData(); string myMobilePhone = ""; string myNickName = "匿名"; Nullable <long> myAudioId = 0; //听一听主键 Nullable <int> myAlbumId = 0; //专辑主键 string myAudioWords = ""; string mySoundTitle = "佚名"; string mySoundImage = "";//封面图片 #region 昵称 if (!String.IsNullOrWhiteSpace(UserSoundTable[i].MobilePhone)) { myMobilePhone = UserSoundTable[i].MobilePhone; myUserSoundDataItem.MobilePhone = myMobilePhone; User_UserName myUser_UserName = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == myMobilePhone); if (myUser_UserName != null) { if (!String.IsNullOrWhiteSpace(myUser_UserName.NickName)) { myNickName = myUser_UserName.NickName; } else { if (myUser_UserName.MobilePhone.Length > 7) { myNickName = myUser_UserName.MobilePhone.Substring(7) + "****"; } } } myUserSoundDataItem.NickName = myNickName; } #endregion // 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.BgMusicUrl = StaticVarClass.myDomain + UserSoundTable[i].BgMusicUrl; myUserSoundDataItem.AudioWords = myAudioWords; myUserSoundDataItem.AudioUrl = StaticVarClass.myDomain + UserSoundTable[i].AudioUrl; myUserSoundDataItem.AddDate = UserSoundTable[i].AddDate; myUserSoundDataItem.TimeSeconds = UserSoundTable[i].TimeSeconds; myUserSoundDataItem.PlayTimes = UserSoundTable[i].PlayTimes; // myUserSoundDataList.Add(myUserSoundDataItem); } myStatusData.dataPageCount = pageCount; myStatusData.dataRecordCount = recordCount; myStatusData.dataTable = myUserSoundDataList; } } myStatusData.operateStatus = 200; } return(Json(myStatusData)); }
public ActionResult UserList(int currentpage = 1, string status = "", string del = "", string search = "") { #region 翻页定义 ViewBag.CurrentPage = 0; //当前页 ViewBag.PPage = 0; //上一页 ViewBag.NPage = 0; //下一页 ViewBag.PageCount = 0; //总页数 ViewBag.RecordCount = 0; //记录总数 ViewBag.IsFirstPage = ""; //第一条记录,禁用首页和上一页 ViewBag.IsEndPage = ""; //最后条记录,禁用首页和下一页 #endregion // ViewBag.Headline = "用户列表";//栏目主题 // ViewBag.DataList = null; ViewBag.RecordItem = null; ViewBag.Search = search; // StatusData myStatusData = new StatusData(); //返回状态 // using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作 { #region 除 if (!String.IsNullOrWhiteSpace(del)) { User_UserName myDelRecord = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == del && p.RoleId < 100); if (myDelRecord != null) { FunctionClass.delFile(myDelRecord.HeadImage); myOperating.User_UserName.Remove(myDelRecord); myOperating.SaveChanges(); } } #endregion // #region 锁定 if (!String.IsNullOrWhiteSpace(status)) { User_UserName myStatusRecord = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == status && p.RoleId < 100); if (myStatusRecord != null) { if (myStatusRecord.Status == 200) { myStatusRecord.Status = 201; } else { myStatusRecord.Status = 200; } myOperating.SaveChanges(); } } #endregion // #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "AddDate"; // //当前页 int sqlCurrentpage = currentpage; if (sqlCurrentpage < 1) { sqlCurrentpage = 1; } //页大小 int sqlPagesize = 10; #endregion // #region 取出内容 IQueryable <User_UserName> myIQueryable = null; if (!String.IsNullOrWhiteSpace(search)) { myIQueryable = myOperating.User_UserName.Where(p => p.MobilePhone.Contains(search)); } else { myIQueryable = myOperating.User_UserName; } // if (myIQueryable != null) { List <User_UserName> myDataTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).ToList(); // ViewBag.DataList = myDataTable; #region 页数取值 ViewBag.CurrentPage = sqlCurrentpage; ViewBag.PageCount = pageCount; ViewBag.RecordCount = recordCount; if (sqlCurrentpage > 1) { ViewBag.PPage = sqlCurrentpage - 1; } else { ViewBag.IsFirstPage = "disabled"; ViewBag.PPage = 1; } if (sqlCurrentpage < pageCount) { ViewBag.NPage = sqlCurrentpage + 1; } else { ViewBag.NPage = sqlCurrentpage; ViewBag.IsEndPage = "disabled"; } #endregion } #endregion } return(View()); }
public JsonResult GetReadDaysList(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 // #region 翻页属性 int recordCount = 0; int pageCount = 0; string orderbyfiled = "ReadDayCount"; // //当前页 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 <User_Book_Click_ReadDay> myIQueryable = null; using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作 { mobilePhone = myAuthCodeInstance.mobilePhone; // myIQueryable = myOperating.User_Book_Click_ReadDay; if (myIQueryable != null) { #region 阅读排行榜 List <ClickBookReadDaysItem> myClickBookReadDaysList = new List <ClickBookReadDaysItem>(); var BookTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, true).Select(s => new { MobilePhone = s.MobilePhone, ReadDayCount = s.ReadDayCount }).ToList(); if (BookTable != null) { for (int i = 0; i < BookTable.Count(); i++) { ClickBookReadDaysItem myClickBookReadDaysItem = new ClickBookReadDaysItem(); string myMobilePhone = ""; if (!String.IsNullOrWhiteSpace(BookTable[i].MobilePhone)) { myMobilePhone = BookTable[i].MobilePhone; } myClickBookReadDaysItem.MobilePhone = BookTable[i].MobilePhone; string myNickName = "匿名"; string myHeadImage = StaticVarClass.DefaultHeadImage; User_UserName myUser_UserName = myOperating.User_UserName.FirstOrDefault(p => p.MobilePhone == myMobilePhone); if (myUser_UserName != null) { if (!String.IsNullOrWhiteSpace(myUser_UserName.NickName)) { myNickName = myUser_UserName.NickName; } // if (!String.IsNullOrWhiteSpace(myUser_UserName.HeadImage)) { myHeadImage = StaticVarClass.myDomain + myUser_UserName.HeadImage; } } myClickBookReadDaysItem.NickName = myNickName; myClickBookReadDaysItem.HeadImage = myHeadImage; myClickBookReadDaysItem.ReadDayCount = BookTable[i].ReadDayCount; myClickBookReadDaysList.Add(myClickBookReadDaysItem); } } #endregion myStatusData.dataPageCount = pageCount; myStatusData.dataRecordCount = recordCount; myStatusData.dataTable = myClickBookReadDaysList; } myStatusData.operateStatus = 200; } return(Json(myStatusData)); }