//
public List<MaterialManagementDetail> Getjjj_MaterialManagementDetail1(string ThumbnailImgPath)
{
var ctx = new MultimediaSYSEntities();
var jjj_MaterialManagementDetail_EntityModel = (from a in ctx.jjj_MaterialManagementDetail
where (a.ThumbnailImgPath == ThumbnailImgPath)
orderby a.UploadTime descending
select new MaterialManagementDetail { MaterialID = a.MaterialID, FileName = a.FileName, FileSize = a.FileSize, FileType = a.FileType, FilePath = a.FilePath, FileSuffixName = a.FileSuffixName, UploadTime = a.UploadTime, TransformFilePath = a.TransformFilePath, UploadUserId = a.UploadUserId, TransformFileSuffixName = a.TransformFileSuffixName, ThumbnailImgPath = a.ThumbnailImgPath, OriginalFileName = a.OriginalFileName })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<MaterialManagementDetail> TerInfoEF = jjj_MaterialManagementDetail_EntityModel.ToList();
return TerInfoEF;
}
//
/// <summary>
/// 添加一条用户基础信息
/// </summary>
/// <param name="usernameTmp"></param>
/// <param name="passwordTmp"></param>
/// <param name="phoneTmp"></param>
/// <param name="isEnableTmp"></param>
public int AddUserInfo1(string usernameTmp, string passwordTmp, string phoneTmp, int isEnableTmp)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var userinfo_tmp = new jjj_users { username = usernameTmp, password = passwordTmp, phone = phoneTmp, isEnable = isEnableTmp };
ctx.jjj_users.Add(userinfo_tmp);
count = ctx.SaveChanges();
}
return count;
}
//
public int AddUser_DrinkCostSerialList(string SerialNumber, string IcCardNo, string CostTime, string DeviceCode, string CostFee, string RunningWaterLitre, string CurrentUserBalance)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var DrinkCostSeria_tmp = new jjj_user_DrinkCostSerialList { SerialNumber = SerialNumber, IcCardNo = IcCardNo, CostTime = Convert.ToDateTime(CostTime), DeviceCode = DeviceCode, CostFee = Convert.ToDecimal(CostFee), RunningWaterLitre = Convert.ToDecimal(RunningWaterLitre), CurrentUserBalance = Convert.ToDecimal(CurrentUserBalance) };
ctx.jjj_user_DrinkCostSerialList.Add(DrinkCostSeria_tmp);
count = ctx.SaveChanges();
}
return count;
}
public List<ProgramInfoItem_DocumentDetail_EntityModel> GetProgramInfoItem_DocumentDetail1(int ProgramInfoItemID)
{
var ctx = new MultimediaSYSEntities();
var programInfoItem_DocumentDetail_EntityModel = (from a in ctx.jjj_ProgramInfoItem_DocumentDetail
join b in ctx.jjj_ProgramInfoListItem on a.ProgramInfoItemID equals b.ProgramInfoItemID
where (a.ProgramInfoItemID == ProgramInfoItemID)
orderby a.ProgramInfoItemID descending
select new ProgramInfoItem_DocumentDetail_EntityModel { ID = a.ID, ProgramInfoItemID = a.ProgramInfoItemID, DocumentLayer = a.DocumentLayer, TimeLength = a.TimeLength, CartoonType = a.CartoonType, DocumentUrl = a.DocumentUrl })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<ProgramInfoItem_DocumentDetail_EntityModel> TerInfoEF = programInfoItem_DocumentDetail_EntityModel.ToList();
return TerInfoEF;
}
public int DeleteUserInfo1(int uidTmp)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var query = from a in ctx.jjj_users
where a.uid == uidTmp
select a;
foreach (var item in query)
{
ctx.jjj_users.Remove(item);
}
count = ctx.SaveChanges();
}
return count;
}
public int UpdateUserPassword1(int uidTmp, string passwordTmp)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var query = from a in ctx.jjj_users
where a.uid == uidTmp
select a;
foreach (var item in query)
{
item.password = passwordTmp;
}
count = ctx.SaveChanges();
}
return count;
}
/// <summary>
/// 查询一组用户信息集
/// </summary>
/// <param name="usernameTmp"></param>
/// <returns></returns>
public List<UserInfo_EntityModel> GetUserInfo1(string usernameTmp)
{
var ctx = new MultimediaSYSEntities();
var userInfo = (from a in ctx.jjj_users
join b in ctx.jjj_usergroups on a.groupid equals b.groupid
where a.username == usernameTmp
orderby a.uid descending
select new UserInfo_EntityModel { uid = a.uid, groupid = b.groupid, password = a.password, username = a.username, grouptitle = b.grouptitle, actualname = a.actualname, phone = a.phone, HengYuCode = a.HengYuCode, isEnable = a.isEnable })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<UserInfo_EntityModel> userInfoEF = userInfo.ToList(); //userInfo2.ToList().FirstOrDefault()写法为返回第一个实体对象
return userInfoEF;
}
public int UpdateTerminalEquipmentInfo3(int TerminalEquipmentIDTmp, int IsSendTmp)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var query = from a in ctx.jjj_TerminalEquipmentList
where a.TerminalEquipmentID == TerminalEquipmentIDTmp
select a;
foreach (var item in query)
{
item.IsSend = IsSendTmp;
}
count = ctx.SaveChanges();
}
return count;
}
public int UpdateTerminalEquipmentSerialCommand2(int TerSerialCommandID, int SendStatus)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var query = from a in ctx.jjj_TerminalEquipmentSerialCommand
where a.TerSerialCommandID == TerSerialCommandID
select a;
foreach (var item in query)
{
item.SendStatus = SendStatus;
}
count = ctx.SaveChanges();
}
return count;
}
//
public int Updatejjj_TerminalSwitchScreenTime1(int TerminalEquipmentID, int IsSend)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var query = from a in ctx.jjj_TerminalSwitchScreenTime
where a.TerminalEquipmentID == TerminalEquipmentID
select a;
foreach (var item in query)
{
item.UpdateTime = DateTime.Now;
item.IsSend = IsSend;
}
count = ctx.SaveChanges();
}
return count;
}
public int UpdateTerminalEquipmentInfo2(string sessionIDTmp)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var query = from a in ctx.jjj_TerminalEquipmentList
where a.SessionId == sessionIDTmp
select a;
foreach (var item in query)
{
item.TerminalStatus = 0;
}
count = ctx.SaveChanges();
}
return count;
}
public int Updatejjj_ProgramSendSerialList3(int ProgramSendSerialID, int SendStatus, Nullable<DateTime> DownloadOverTime)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var query = from a in ctx.jjj_ProgramSendSerialList
where a.ProgramSendSerialID == ProgramSendSerialID
select a;
foreach (var item in query)
{
item.SendStatus = SendStatus;
item.DownloadOverTime = DownloadOverTime;
}
count = ctx.SaveChanges();
}
return count;
}
public List<ProgramInfoList_EntityModel> GetProgramInfoList1(int ProgramInfoID)
{
var ctx = new MultimediaSYSEntities();
var programInfoList_EntityModel = (from a in ctx.jjj_ProgramInfoList
where (a.ProgramInfoID == ProgramInfoID) && (a.ProgramStatus == 1)
orderby a.CreateTime descending
select new ProgramInfoList_EntityModel { ProgramInfoID = a.ProgramInfoID, ProgramWidth = a.ProgramWidth, ProgramHeight = a.ProgramHeight, ProgramStatus = a.ProgramStatus, CreateUserId = a.CreateUserId, ProgramTitle = a.ProgramTitle, CreateTime = a.CreateTime, UpdateTime = a.UpdateTime })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<ProgramInfoList_EntityModel> TerInfoEF = programInfoList_EntityModel.ToList();
return TerInfoEF;
}
public List<ProgramInfoListItem_EntityModel> GetProgramInfoListItem2(int ProgramInfoID, int ProgramInfoItemLayer)
{
var ctx = new MultimediaSYSEntities();
var programInfoListItem_EntityModel = (from a in ctx.jjj_ProgramInfoListItem
join b in ctx.jjj_ProgramInfoList on a.ProgramInfoID equals b.ProgramInfoID
where (a.ProgramInfoID == ProgramInfoID) && (a.ProgramInfoItemLayer == ProgramInfoItemLayer)
orderby a.ProgramInfoItemLayer descending
select new ProgramInfoListItem_EntityModel { ProgramInfoItemID = a.ProgramInfoItemID, ProgramInfoID = a.ProgramInfoID, ProgramInfoItemType = a.ProgramInfoItemType, ProgramInfoItemWidth = a.ProgramInfoItemWidth, ProgramInfoItemHeight = a.ProgramInfoItemHeight, ProgramInfoItemLayer = a.ProgramInfoItemLayer, ProgramInfoItemTitle = a.ProgramInfoItemTitle, ProgramInfoItemLeft = a.ProgramInfoItemLeft, ProgramInfoItemTop = a.ProgramInfoItemTop, IsShowWater = a.IsShowWater })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<ProgramInfoListItem_EntityModel> TerInfoEF = programInfoListItem_EntityModel.ToList();
return TerInfoEF;
}
public List<ProgramInfoItem_VideoDetail_EntityModel> GetProgramInfoItem_VideoDetail1(int ProgramInfoItemID)
{
var ctx = new MultimediaSYSEntities();
var programInfoItem_VideoDetail_EntityModel = (from a in ctx.jjj_ProgramInfoItem_VideoDetail
join b in ctx.jjj_ProgramInfoListItem on a.ProgramInfoItemID equals b.ProgramInfoItemID
where (a.ProgramInfoItemID == ProgramInfoItemID)
orderby a.ProgramInfoItemID descending
select new ProgramInfoItem_VideoDetail_EntityModel { ID = a.ID, ProgramInfoItemID = a.ProgramInfoItemID, VideoLayer = a.VideoLayer, VideoVoice = a.VideoVoice, VideoUrl = a.VideoUrl })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<ProgramInfoItem_VideoDetail_EntityModel> TerInfoEF = programInfoItem_VideoDetail_EntityModel.ToList();
return TerInfoEF;
}
public List<TerminalSwitchScreenTime_EntityModel> GetTerminalSwitchScreenTime3(bool IsEnable, int IsSend, int TerminalStatus, int TerminalEquipmentID)
{
var ctx = new MultimediaSYSEntities();
var terminalSwitchScreenTime_EntityModel = (from a in ctx.jjj_TerminalSwitchScreenTime
join b in ctx.jjj_TerminalEquipmentList on a.TerminalEquipmentID equals b.TerminalEquipmentID
where (a.IsEnable == IsEnable) && (b.TerminalStatus == TerminalStatus) && (a.IsSend == IsSend) && (a.TerminalEquipmentID == TerminalEquipmentID)
orderby a.TerminalSwitchScreenTimeID descending
select new TerminalSwitchScreenTime_EntityModel { TerminalSwitchScreenTimeID = a.TerminalSwitchScreenTimeID, TerminalEquipmentID = a.TerminalEquipmentID, SessionId = b.SessionId, TurnOnTime = a.TurnOnTime, TurnOffTime = a.TurnOffTime, IsMonday = a.IsMonday, IsTuesday = a.IsTuesday, IsWednesday = a.IsWednesday, IsThursday = a.IsThursday, IsFriday = a.IsFriday, IsSaturday = a.IsSaturday, IsSunday = a.IsSunday, IsEnable = a.IsEnable, UpdateTime = a.UpdateTime, IsSend = IsSend })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<TerminalSwitchScreenTime_EntityModel> TerInfoEF = terminalSwitchScreenTime_EntityModel.ToList();
return TerInfoEF;
}
//
public List<TerminalEquipmentSerialCommand_EntityModel> GetTerminalEquipmentSerialCommand1(int TerminalStatus, int SendStatus)
{
var ctx = new MultimediaSYSEntities();
var TerminalEquipmentSerialCommand = (from a in ctx.jjj_TerminalEquipmentSerialCommand
join b in ctx.jjj_TerminalEquipmentList on a.TerminalEquipmentID equals b.TerminalEquipmentID
where (a.SendStatus == SendStatus) && (b.TerminalStatus == TerminalStatus)
orderby a.SendTime descending
select new TerminalEquipmentSerialCommand_EntityModel { TerSerialCommandID = a.TerSerialCommandID, SendAdminName = a.SendAdminName, SendTime = a.SendTime, TerminalEquipmentID = a.TerminalEquipmentID, TerminalStatus = b.TerminalStatus, SessionId = b.SessionId, DeviceCode = b.DeviceCode, TerminalName = b.TerminalName, CommandTypeId = a.CommandTypeId, SendContent = a.SendContent, SendStatus = a.SendStatus, ReceiveBackTime = a.ReceiveBackTime })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<TerminalEquipmentSerialCommand_EntityModel> TerInfoEF = TerminalEquipmentSerialCommand.ToList(); //userInfo2.ToList().FirstOrDefault()写法为返回第一个实体对象
return TerInfoEF;
}
public List<TerminalEquipmentInfo_EntityModel> GetTerminalEquipmentInfo3(int IsSend, int TerminalStatus)
{
var ctx = new MultimediaSYSEntities();
var terInfo = (from a in ctx.jjj_TerminalEquipmentList
join b in ctx.jjj_TerminalEquipmentCategory on a.TerminalEquipmentCategoryId equals b.TerminalEquipmentCategoryId
where a.IsSend == IsSend
orderby a.Layer descending
select new TerminalEquipmentInfo_EntityModel { TerminalEquipmentID = a.TerminalEquipmentID, TerminalEquipmentCategoryId = b.TerminalEquipmentCategoryId, CurrentUserId = a.CurrentUserId, TerminalStatus = a.TerminalStatus, IsRegister = a.IsRegister, Layer = a.Layer, AdvanceDownNum = a.AdvanceDownNum, SessionId = a.SessionId, TerminalVersion = a.TerminalVersion, TerminalIP = a.TerminalIP, TerminalPlatform = a.TerminalPlatform, DeviceCode = a.DeviceCode, TerminalName = a.TerminalName, MainServerIP = a.MainServerIP, MainServerPort = a.MainServerPort, TerminalEquipmentCategoryName = b.TerminalEquipmentCategoryName, DownloadStartTime = a.DownloadStartTime, DownloadEndTime = a.DownloadEndTime })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<TerminalEquipmentInfo_EntityModel> terInfoEF = terInfo.ToList(); //userInfo2.ToList().FirstOrDefault()写法为返回第一个实体对象
return terInfoEF;
}
//
public List<IGrouping<int?, ProgramInfoListItem_EntityModel>> GetProgramInfoListItem3(int ProgramInfoID)
{
var ctx = new MultimediaSYSEntities();
var programInfoListItem_EntityModel = (from a in ctx.jjj_ProgramInfoListItem
join b in ctx.jjj_ProgramInfoList on a.ProgramInfoID equals b.ProgramInfoID
where (a.ProgramInfoID == ProgramInfoID)
orderby a.ProgramInfoItemLayer descending
select new ProgramInfoListItem_EntityModel { ProgramInfoItemLayer = a.ProgramInfoItemLayer })
.Take(1000);
var query = from a in programInfoListItem_EntityModel group a by a.ProgramInfoItemLayer into g select g;
return query.ToList();
}
//开始进行节目制作发送的相关方法
public List<ProgramSendSerialList_EntityModel> GetProgramSendSerialList1(int TerminalStatus, int SendStatus)
{
var ctx = new MultimediaSYSEntities();
var programSendSerialList_EntityModel = (from a in ctx.jjj_ProgramSendSerialList
join b in ctx.jjj_TerminalEquipmentList on a.TerminalEquipmentID equals b.TerminalEquipmentID
where (a.SendStatus == SendStatus) && (b.TerminalStatus == TerminalStatus)
orderby a.CreateTime descending
select new ProgramSendSerialList_EntityModel { ProgramSendSerialID = a.ProgramSendSerialID, TerminalEquipmentID = a.TerminalEquipmentID, ProgramInfoID = a.ProgramInfoID, SendStatus = a.SendStatus, EfficaciousDateStart = a.EfficaciousDateStart, SessionId = b.SessionId, DeviceCode = b.DeviceCode, TerminalName = b.TerminalName, EfficaciousDateEnd = a.EfficaciousDateEnd, EfficaciousTimeStart = a.EfficaciousTimeStart, EfficaciousTimeEnd = a.EfficaciousTimeEnd, ReceiveBackTime = a.ReceiveBackTime })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<ProgramSendSerialList_EntityModel> TerInfoEF = programSendSerialList_EntityModel.ToList();
return TerInfoEF;
}
public int Updatejjj_ProgramSendSerialList1(int ProgramSendSerialID, int SendStatus)
{
int count = 0;
using (var ctx = new MultimediaSYSEntities())
{
var query = from a in ctx.jjj_ProgramSendSerialList
where a.ProgramSendSerialID == ProgramSendSerialID
select a;
foreach (var item in query)
{
item.SendStatus = SendStatus;
}
count = ctx.SaveChanges();
}
return count;
}
public List<ProgramInfoItem_TimeDetail_EntityModel> GetProgramInfoItem_TimeDetail1(int ProgramInfoItemID)
{
var ctx = new MultimediaSYSEntities();
var programInfoItem_TimeDetail_EntityModel = (from a in ctx.jjj_ProgramInfoItem_TimeDetail
join b in ctx.jjj_ProgramInfoListItem on a.ProgramInfoItemID equals b.ProgramInfoItemID
where (a.ProgramInfoItemID == ProgramInfoItemID)
orderby a.ProgramInfoItemID descending
select new ProgramInfoItem_TimeDetail_EntityModel { ID = a.ID, ProgramInfoItemID = a.ProgramInfoItemID, FontSize = a.FontSize, IsBackgroundTransparent = a.IsBackgroundTransparent, IsBold = a.IsBold, FontFamily = a.FontFamily, FontFormat = a.FontFormat, BackgroundColor = a.BackgroundColor, foreColor = a.foreColor })
.Take(1000); //take操作符类似于SQL中的TOP操作符
List<ProgramInfoItem_TimeDetail_EntityModel> TerInfoEF = programInfoItem_TimeDetail_EntityModel.ToList();
return TerInfoEF;
}
