//
#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));
}
