//
#region 阅读播放次数加一
public bool TimesAdd(int classid, long aboutid)
{
bool isOk = false;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
try
{
switch (classid)
{///1点一点；2听一听；3看一看；
///4课程讲解；5幼儿公开课；6教育技能；
///7操作说明；8教师社区；9精彩瞬间;12用户录音
case 1: //点一点
Child_Book_Click myChild_Book_Click = new Child_Book_Click();
myChild_Book_Click = myOperating.Child_Book_Click.FirstOrDefault(p => p.BookID == aboutid);
if (myChild_Book_Click != null)
{
myChild_Book_Click.ReadCount = myChild_Book_Click.ReadCount + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 2: //2听一听
Child_Audio_List myChild_Audio_List = new Child_Audio_List();
myChild_Audio_List = myOperating.Child_Audio_List.FirstOrDefault(p => p.AudioId == aboutid);
if (myChild_Audio_List != null)
{
myChild_Audio_List.PlayTimes = myChild_Audio_List.PlayTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 3: //3看一看
Child_Video_List myChild_Video_List = new Child_Video_List();
myChild_Video_List = myOperating.Child_Video_List.FirstOrDefault(p => p.VideoId == aboutid);
if (myChild_Video_List != null)
{
myChild_Video_List.PlayTimes = myChild_Video_List.PlayTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 4:
case 5:
case 6:
case 7: //4课程讲解；5幼儿公开课；6教育技能；7操作说明
Teacher_Video_List myTeacher_Video_List = new Teacher_Video_List();
myTeacher_Video_List = myOperating.Teacher_Video_List.FirstOrDefault(p => p.VideoId == aboutid);
if (myTeacher_Video_List != null)
{
myTeacher_Video_List.PlayTimes = myTeacher_Video_List.PlayTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 8: //8教师社区
Teacher_Article myTeacher_Article = new Teacher_Article();
myTeacher_Article = myOperating.Teacher_Article.FirstOrDefault(p => p.ArticlId == aboutid);
if (myTeacher_Article != null)
{
myTeacher_Article.ReadTimes = myTeacher_Article.ReadTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 9: //9精彩瞬间
Discover_Article myDiscover_Article = new Discover_Article();
myDiscover_Article = myOperating.Discover_Article.FirstOrDefault(p => p.ArticlId == aboutid);
if (myDiscover_Article != null)
{
myDiscover_Article.ReadTimes = myDiscover_Article.ReadTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
case 12: //用户录音
Child_Audio_List_User myChild_Audio_List_User = new Child_Audio_List_User();
myChild_Audio_List_User = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioUserId == aboutid);
if (myChild_Audio_List_User != null)
{
myChild_Audio_List_User.PlayTimes = myChild_Audio_List_User.PlayTimes + 1;
myOperating.SaveChanges();
isOk = true;
}
break;
}
}
catch
{ }
}
return(isOk);
}
public JsonResult DeleteItem(string myid, string del)
{
#region 检查授权
string myMobilePhone = "";//手机号
AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
AuthCodeClass myAuthCodeClass = new AuthCodeClass();
bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
#endregion
//
StatusData myStatusData = new StatusData();//返回状态
//
if (checkAuthCodeBool)
{
myMobilePhone = myAuthCodeInstance.mobilePhone;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
int operatType = 0; //1删除全部，2删除指定
long idLong = 0;
#region 判断参数
if (!String.IsNullOrWhiteSpace(del))
{
switch (del.ToLower())
{
case "all":
operatType = 1;
break;
case "single":
if (!String.IsNullOrWhiteSpace(myid))
{
bool isLong = long.TryParse(myid, out idLong);
if (isLong)
{
operatType = 2;
}
}
break;
}
}
#endregion
//
if (operatType == 1)
{
IQueryable <Child_Audio_List_User> myList = myOperating.Child_Audio_List_User.Where(p => p.MobilePhone == myMobilePhone);
if (myList != null)
{
foreach (Child_Audio_List_User recordItem in myList)
{
FunctionClass.DeleteFile(recordItem.AudioUrl);
myOperating.Child_Audio_List_User.Remove(recordItem);
}
myOperating.SaveChanges();
}
myStatusData.operateStatus = 200;
}
else if (operatType == 2)
{
Child_Audio_List_User myDataRecord = new Child_Audio_List_User();
myDataRecord = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioUserId == idLong && p.MobilePhone == myMobilePhone);
if (myDataRecord != null)
{
FunctionClass.DeleteFile(myDataRecord.AudioUrl);
myOperating.Child_Audio_List_User.Remove(myDataRecord);
myOperating.SaveChanges();
myStatusData.operateStatus = 200;
}
}
else
{
myStatusData.operateStatus = 0;
}
}
}
else
{
myStatusData.operateStatus = 5;
}
return(Json(myStatusData));
}
public JsonResult AddSoundRecord(string audioid, string audiourl, string bgmusic, string seconds, string operate)
{ //operate=0保存；1保存并发布
#region 检查授权
string myMobilePhone = ""; //新授权码
AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
AuthCodeClass myAuthCodeClass = new AuthCodeClass();
bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
#endregion
//
#region 替换域名信息
if (!String.IsNullOrWhiteSpace(bgmusic))
{
bgmusic = bgmusic.ToLower().Replace("http://", "");
int strIndex = bgmusic.IndexOf('/') + 1;
if (strIndex < bgmusic.Length)
{
bgmusic = bgmusic.Substring(strIndex);
}
}
#endregion
//
StatusData myStatusData = new StatusData();//返回状态
//
if (checkAuthCodeBool)
{
myMobilePhone = myAuthCodeInstance.mobilePhone;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
long myLong = 0;
bool isLong = false;
if (!String.IsNullOrEmpty(audioid))
{
isLong = long.TryParse(audioid, out myLong);
}
if (isLong)
{
try
{
Child_Audio_List_User oldChild_Audio_List_User = new Child_Audio_List_User();
oldChild_Audio_List_User = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioId == myLong && p.MobilePhone == myMobilePhone);
if (oldChild_Audio_List_User == null)
{
#region 添加新的
Child_Audio_List_User myChild_Audio_List_User = new Child_Audio_List_User();
//
myChild_Audio_List_User.AudioId = myLong;
myChild_Audio_List_User.MobilePhone = myMobilePhone;
if (!String.IsNullOrEmpty(audiourl))
{
myChild_Audio_List_User.AudioUrl = audiourl;
}
if (!String.IsNullOrEmpty(bgmusic))
{
myChild_Audio_List_User.BgMusicUrl = bgmusic;
}
int myseconds = 0;//时长
if (!String.IsNullOrWhiteSpace(seconds))
{
int.TryParse(seconds, out myseconds);
}
myChild_Audio_List_User.TimeSeconds = myseconds;
myChild_Audio_List_User.AddDate = DateTime.Now;
myChild_Audio_List_User.PlayTimes = 0;
myChild_Audio_List_User.PraiceCount = 0;
myChild_Audio_List_User.OrderBy = 10000;
if (!String.IsNullOrWhiteSpace(operate))
{
if (operate == "1")
{
myChild_Audio_List_User.Status = 200;//
}
else
{
myChild_Audio_List_User.Status = 300;//
}
}
else
{
myChild_Audio_List_User.Status = 300;//
}
myOperating.Child_Audio_List_User.Add(myChild_Audio_List_User);
#endregion
}
else
{//修改
#region 修改状态
if (!String.IsNullOrWhiteSpace(operate))
{
if (operate == "1")
{
oldChild_Audio_List_User.Status = 200;//
}
else
{
oldChild_Audio_List_User.Status = 300;//
}
}
else
{
oldChild_Audio_List_User.Status = 300;//
}
#endregion
}
myOperating.SaveChanges();
myStatusData.operateStatus = 200;
}
catch
{
myStatusData.operateStatus = -1;
}
}
else
{
myStatusData.operateStatus = 400;
myStatusData.operateMsg = "参数错误";
}
}
}
else
{
myStatusData.operateStatus = 5;//登陆失效
}
return(Json(myStatusData));
}
public JsonResult PublishAudio(string audioid, string operate)
{ //operate=0保存；1保存并发布
#region 检查授权
string myMobilePhone = ""; //手机号
AuthCodeInstance myAuthCodeInstance = new AuthCodeInstance();
AuthCodeClass myAuthCodeClass = new AuthCodeClass();
bool checkAuthCodeBool = myAuthCodeClass.checkAuthCode(out myAuthCodeInstance);
#endregion
//
StatusData myStatusData = new StatusData();//返回状态
//
if (checkAuthCodeBool)
{
myMobilePhone = myAuthCodeInstance.mobilePhone;
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities())//数据库操作
{
long myLong = 0;
bool isLong = false;
if (!String.IsNullOrEmpty(audioid))
{
isLong = long.TryParse(audioid, out myLong);
}
if (isLong)
{
#region 修改状态
try
{
Child_Audio_List_User myChild_Audio_List_User = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioUserId == myLong);
//
if (myChild_Audio_List_User != null)
{
if (!String.IsNullOrWhiteSpace(operate))
{
int myStatus = 0;
bool isInt = int.TryParse(operate, out myStatus);
if (isInt)
{
if (myStatus == 1)
{
myChild_Audio_List_User.Status = 200;//发布
}
else
{
myChild_Audio_List_User.Status = 300;//撤下
}
}
else
{
myChild_Audio_List_User.Status = 300;//撤下
}
}
else
{
myChild_Audio_List_User.Status = 300;//撤下
}
myOperating.SaveChanges();
myStatusData.operateStatus = 200;
}
else
{
myStatusData.operateStatus = 400;
}
//
}
catch
{
myStatusData.operateStatus = -1;
}
#endregion
}
else
{
myStatusData.operateStatus = 400;
myStatusData.operateMsg = "参数错误";
}
}
}
else
{
myStatusData.operateStatus = 5;//登陆失效
}
return(Json(myStatusData));
}
//
#region 用户上传的音频列表
public ActionResult UserAudioList(string mobilephone, string currentpage, long del = 0)
{
#region 翻页定义
ViewBag.CurrentPage = 0; //当前页
ViewBag.PPage = 0; //上一页
ViewBag.NPage = 0; //下一页
ViewBag.PageCount = 0; //总页数
ViewBag.RecordCount = 0; //记录总数
ViewBag.IsFirstPage = ""; //第一条记录，禁用首页和上一页
ViewBag.IsEndPage = ""; //最后条记录，禁用首页和下一页
#endregion
//
ViewBag.Headline = "用户上传音频管理";//栏目主题
//
ViewBag.mobilephone = mobilephone;
ViewBag.DataList = null;
//
StatusData myStatusData = new StatusData(); //返回状态
//
using (chefuzi_dataEntities myOperating = new chefuzi_dataEntities()) //数据库操作
{
#region 除
if (del > 0)
{
Child_Audio_List_User myDelRecord = myOperating.Child_Audio_List_User.FirstOrDefault(p => p.AudioUserId == del);
if (myDelRecord != null)
{
FunctionClass.delFile(myDelRecord.AudioUrl);
myOperating.Child_Audio_List_User.Remove(myDelRecord);
myOperating.SaveChanges();
}
}
#endregion
#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;
#endregion
IQueryable <Child_Audio_List_User> myIQueryable = null;
if (!String.IsNullOrWhiteSpace(mobilephone))
{
myIQueryable = myOperating.Child_Audio_List_User.Where(p => p.MobilePhone == mobilephone);
}
else
{
myIQueryable = myOperating.Child_Audio_List_User;
}
//
if (myIQueryable != null)
{
IQueryable <Child_Audio_List_User> UserSoundTable = QueryableExtensions.OrderBy(myIQueryable, orderbyfiled, out recordCount, out pageCount, ref sqlCurrentpage, sqlPagesize, isDesc);
//
List <UserSoundData> myUserSoundDataList = new List <UserSoundData>();
if (UserSoundTable != null)
{
foreach (Child_Audio_List_User item in UserSoundTable)
{
UserSoundData myUserSoundDataItem = new UserSoundData();
Nullable <long> myAudioId = 0;//听一听主键
string myAudioWords = "";
string mySoundTitle = "佚名";
//
myAudioId = item.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)
{
mySoundTitle = myChild_Audio_List.AudioTitle;
myAudioWords = myChild_Audio_List.AudioWords;
}
}
#endregion
//
myUserSoundDataItem.AudioUserId = item.AudioUserId;
myUserSoundDataItem.MobilePhone = item.MobilePhone;
myUserSoundDataItem.MusicTitle = mySoundTitle;
if (!String.IsNullOrWhiteSpace(item.BgMusicUrl))
{
myUserSoundDataItem.BgMusicUrl = StaticVarClass.myDomain + item.BgMusicUrl;
}
myUserSoundDataItem.AudioWords = myAudioWords;
if (!String.IsNullOrWhiteSpace(item.AudioUrl))
{
myUserSoundDataItem.AudioUrl = StaticVarClass.myDomain + item.AudioUrl;
}
myUserSoundDataItem.AddDate = item.AddDate;
myUserSoundDataItem.PlayTimes = item.PlayTimes;
//
myUserSoundDataList.Add(myUserSoundDataItem);
}
ViewBag.DataList = myUserSoundDataList;
}
//
#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
}
}
return(View());
}
