public Customer NewData()
{
// 获取新Id（将数据表里的FilmId最大值+1）
// 使用创建时间先后来获取最后ID
int lastId;
Customer lastData = de.ExecuteStoreQuery <Customer>(@"SELECT * FROM Customer ORDER BY CustomerId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.CustomerId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
Customer data = new Customer();
data.CustomerId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 如果有非String类型的值，则赋予默认值，优化速度
de.Customer.AddObject(data);
de.SaveChanges();
return(data);
}
public VoucherType NewData()
{
// 获取新Id
int lastId;
VoucherType lastData = de.ExecuteStoreQuery <VoucherType>(@"SELECT * FROM VoucherType ORDER BY VoucherTypeId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.VoucherTypeId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
VoucherType data = new VoucherType();
data.VoucherTypeId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 如果有非String类型的值，则赋予默认值，优化速度
de.VoucherType.AddObject(data);
de.SaveChanges();
return(data);
}
public ShowType NewData()
{
int lastId;
ShowType lastData = de.ExecuteStoreQuery <ShowType>(@"SELECT * FROM ShowType ORDER BY ShowTypeId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.ShowTypeId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
ShowType data = new ShowType();
data.ShowTypeId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
de.ShowType.AddObject(data);
de.SaveChanges();
return(data);
}
public void Save()
{
// 设置事务参数
TransactionOptions transactionOption = new TransactionOptions();
// 设置事务隔离级别
transactionOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
// 设置事务超时时间为60秒
transactionOption.Timeout = new TimeSpan(0, 60, 0);
// 写入数据库
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, transactionOption))
{
// 保存到数据库，如果遇到开放式冲突，则以本地数据为准
try
{
de.SaveChanges();
}
catch (OptimisticConcurrencyException)
{
de.Refresh(RefreshMode.ClientWins, de.Film);
de.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
ts.Complete();
}
}
public UploadSetting NewData()
{
int lastId;
UploadSetting lastData = de.ExecuteStoreQuery <UploadSetting>(@"SELECT * FROM UploadSetting ORDER BY UploadId*1 DESC LIMIT 1").FirstOrDefault();
Theater theater = de.Theater.FirstOrDefault();
if (lastData != null)
{
lastId = lastData.UploadId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
UploadSetting data = new UploadSetting();
data.UploadId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
data.TheaterId = theater.TheaterId;
data.UploadTime = new TimeSpan(6, 0, 0);
data.FileFormat = "xml";
data.IsActive = false;
de.UploadSetting.AddObject(data);
de.SaveChanges();
return(data);
}
public FilmMode NewData()
{
// 获取新Id（将数据表里的FilmId最大值+1）
int lastId;
FilmMode lastData = de.ExecuteStoreQuery <FilmMode>(@"SELECT * FROM FilmMode ORDER BY FilmModeId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.FilmModeId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
FilmMode data = new FilmMode();
data.FilmModeId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 如果有非String类型的值，则赋予默认值，优化速度
data.FilmModeName = string.Empty;
de.FilmMode.AddObject(data);
de.SaveChanges();
return(data);
}
public Voucher NewData()
{
string year = DateTime.Now.ToString("yyyy");
string month = DateTime.Now.ToString("MM");
string day = DateTime.Now.ToString("dd");
VoucherBatch lastBatch = de.ExecuteStoreQuery <VoucherBatch>(string.Format(@"SELECT * FROM VoucherBatch WHERE VoucherBatchId LIKE '{0}{1}{2}%' ORDER BY VoucherBatchId*1 DESC LIMIT 1", year, month, day)).FirstOrDefault();
if (lastBatch == null)
{
throw new Exception("请先添加票券批次!");
}
// 获取新Id（将数据表里的FilmId最大值+1）
// 使用创建时间先后来获取最后ID
string lastId;
Voucher lastData = de.ExecuteStoreQuery <Voucher>(string.Format(@"SELECT * FROM Voucher WHERE VoucherId LIKE '{0}%' ORDER BY VoucherId*1 DESC LIMIT 1", lastBatch.VoucherBatchId)).FirstOrDefault();
if (lastData != null)
{
lastId = lastData.VoucherId.Substring(10, 6);
}
else
{
lastId = "0";
}
string newId;
// 生成新的Id（这里长度是6位）
try
{
newId = string.Format("{0:D6}", Convert.ToInt64(lastId) + 1);
}
catch
{
newId = string.Format("{0:D6}", 1);
}
Voucher data = new Voucher();
data.VoucherId = lastBatch.VoucherBatchId + newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 更新非String类型的值，优化速度
de.Voucher.AddObject(data);
de.SaveChanges();
return(data);
}
public VoucherBatch NewData()
{
string year = DateTime.Now.ToString("yyyy");
string month = DateTime.Now.ToString("MM");
string day = DateTime.Now.ToString("dd");
// 获取最后ID
string lastId;
VoucherBatch lastData = de.ExecuteStoreQuery <VoucherBatch>(string.Format(@"SELECT * FROM VoucherBatch WHERE VoucherBatchId LIKE '{0}{1}{2}%' ORDER BY VoucherBatchId*1 DESC LIMIT 1", year, month, day)).FirstOrDefault();
if (lastData != null)
{
lastId = lastData.VoucherBatchId.Substring(8, 2);
}
else
{
lastId = "0";
}
string newId;
// 生成新的Id（这里长度是2位）
try
{
newId = string.Format("{0:D2}", Convert.ToInt64(lastId) + 1);
}
catch
{
newId = string.Format("{0:D2}", 1);
}
VoucherBatch data = new VoucherBatch();
data.VoucherBatchId = year + month + day + newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 更新非String类型的值，优化速度
data.PrintStatus = 1;
data.Quantity = 0;
data.UnitPrice = 0;
data.TotalPrice = 0;
data.ExpireDate = DateTime.Now;
data.ReleaseDate = DateTime.Now;
de.VoucherBatch.AddObject(data);
de.SaveChanges();
return(data);
}
public Debt NewData()
{
string year = DateTime.Now.ToString("yyyy");
string month = DateTime.Now.ToString("MM");
string day = DateTime.Now.ToString("dd");
// 获取最后ID
string lastId;
Debt lastData = de.ExecuteStoreQuery <Debt>(string.Format(@"SELECT * FROM Debt WHERE DebtId LIKE '{0}{1}{2}%' ORDER BY DebtId*1 DESC LIMIT 1", year, month, day)).FirstOrDefault();
if (lastData != null)
{
lastId = lastData.DebtId.Substring(8, 2);
}
else
{
lastId = "0";
}
string newId;
// 生成新的Id（这里长度是2位）
try
{
newId = string.Format("{0:D2}", Convert.ToInt64(lastId) + 1);
}
catch
{
newId = string.Format("{0:D2}", 1);
}
Debt data = new Debt();
data.DebtId = year + month + day + newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 更新非String类型的值，优化速度
data.DebtStatus = false;
data.BoughtDate = DateTime.Now;
data.ClearDate = DateTime.Now;
de.Debt.AddObject(data);
de.SaveChanges();
return(data);
}
public Film NewData()
{
// 获取新Id（将数据表里的Id最大值+1）
string lastId;
Film lastData = de.ExecuteStoreQuery <Film>(@"SELECT * FROM Film ORDER BY FilmId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.FilmId;
}
else
{
lastId = "0";
}
string newId;
// 生成新的Id（这里长度是12位）
try
{
newId = string.Format("{0:D12}", Convert.ToInt64(lastId) + 1);
}
catch
{
newId = string.Format("{0:D12}", 1);
}
Film data = new Film();
data.FilmId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 更新非String类型的值，优化速度
data.PublishDate = DateTime.Now;
data.FilmLength = 0;
data.Ratio = 0;
data.LowestPrice = 0;
data.HasMode = false;
de.Film.AddObject(data);
de.SaveChanges();
return(data);
}
public TimeSetting NewData()
{
// 使用创建时间先后来获取最后ID
int lastId;
TimeSetting lastData = de.ExecuteStoreQuery <TimeSetting>(@"SELECT * FROM TimeSetting ORDER BY TimeSettingId*1 DESC LIMIT 1").FirstOrDefault();
Theater theater = de.Theater.FirstOrDefault();
if (lastData != null)
{
lastId = lastData.TimeSettingId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
TimeSetting data = new TimeSetting();
data.TimeSettingId = Convert.ToInt32(newId);
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
//
data.TheaterId = theater.TheaterId;
data.RefundDeadline = -1;
data.TicketingDeadline = -1;
data.Timespan = 0;
data.BookingReleaseTime = -1;
data.RepeatDay = "";
//
data.OpenTime = new TimeSpan(9, 0, 0);
data.CloseTime = new TimeSpan(8, 59, 59);
//data.OpenTime = new TimeSpan(9, 0, 0);
//data.CloseTime = data.Created - data.Updated;
de.TimeSetting.AddObject(data);
de.SaveChanges();
return(data);
}
public FilmCategory NewData()
{
// 获取新Id（将数据表里的FilmId最大值+1）
// 使用创建时间先后来获取最后ID
string lastId;
FilmCategory lastData = de.ExecuteStoreQuery <FilmCategory>(@"SELECT * FROM FilmCategory ORDER BY FilmCategoryId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.FilmCategoryId;
}
else
{
lastId = "0";
}
string newId;
// 生成新的Id（这里长度是1位）
try
{
newId = string.Format("{0:D1}", Convert.ToInt64(lastId) + 1);
}
catch
{
newId = string.Format("{0:D1}", 1);
}
FilmCategory data = new FilmCategory();
data.FilmCategoryId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 如果有非String类型的值，则赋予默认值，优化速度
data.FilmCategoryName = string.Empty;
de.FilmCategory.AddObject(data);
de.SaveChanges();
return(data);
}
public FilmArea NewData()
{
// 获取新Id（将数据表里的Id最大值+1）
string lastId;
FilmArea lastData = de.ExecuteStoreQuery <FilmArea>(@"SELECT * FROM FilmArea ORDER BY FilmAreaId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.FilmAreaId;
}
else
{
lastId = "0";
}
string newId;
// 生成新的Id（这里长度是3位）
try
{
newId = string.Format("{0:D3}", Convert.ToInt64(lastId) + 1);
}
catch
{
newId = string.Format("{0:D3}", 1);
}
FilmArea data = new FilmArea();
data.FilmAreaId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 如果有非String类型的值，则赋予默认值，优化速度
de.FilmArea.AddObject(data);
de.SaveChanges();
return(data);
}
public DownloadSetting NewData()
{
int lastId;
DownloadSetting lastData = de.ExecuteStoreQuery <DownloadSetting>(@"SELECT * FROM DownloadSetting ORDER BY DownloadId*1 DESC LIMIT 1").FirstOrDefault();
Theater threater = de.Theater.FirstOrDefault();
if (lastData != null)
{
lastId = lastData.DownloadId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
DownloadSetting data = new DownloadSetting();
data.DownloadId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 更新非String类型的值，优化速度
data.TheaterId = threater.TheaterId;
data.UserName = string.Empty;
data.SourceName = string.Empty;
data.ProxyPort = 0;
data.Port = 0;
data.IsProxy = false;
data.IsAnonymAllowed = false;
data.DownloadMethod = "HTTP";
de.DownloadSetting.AddObject(data);
de.SaveChanges();
return(data);
}
public Hall NewData()
{
// 使用创建时间先后来获取最后ID
string lastId;
Hall lastData = de.ExecuteStoreQuery <Hall>(@"SELECT * FROM Hall ORDER BY HallId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.HallId;
}
else
{
lastId = "0";
}
string newId;
// 生成新的Id（这里长度是2位）
try
{
newId = string.Format("{0:D2}", Convert.ToInt64(lastId) + 1);
}
catch
{
newId = string.Format("{0:D2}", 1);
}
Hall data = new Hall();
data.HallId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
de.Hall.AddObject(data);
de.SaveChanges();
return(data);
}
public Discount_Type NewData()
{
// 获取最后ID
int lastId;
Discount_Type lastData = de.ExecuteStoreQuery <Discount_Type>(@"SELECT * FROM Discount_Type ORDER BY Discount_TypeId*1 DESC LIMIT 1").FirstOrDefault();
//Theater theater = de.Theater.FirstOrDefault();
if (lastData != null)
{
lastId = lastData.Discount_TypeId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
Discount_Type data = new Discount_Type();
data.Discount_TypeId = newId;
// data.TheaterId = theater.TheaterId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
//data.Discount_TypeId = 1;
//data.DiscountId = 2;
de.Discount_Type.AddObject(data);
de.SaveChanges();
return(data);
}
public FareSetting NewData()
{
// 获取新Id（将数据表里的Id最大值+1）
int lastId;
FareSetting lastData = de.ExecuteStoreQuery <FareSetting>(@"SELECT * FROM FareSetting ORDER BY FareSettingId*1 DESC LIMIT 1").FirstOrDefault();
if (lastData != null)
{
lastId = lastData.FareSettingId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
FareSetting data = new FareSetting();
data.FareSettingId = newId;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
data.SinglePrice = 0;
data.DoublePrice = 0;
data.BoxPrice = 0;
data.StudentPrice = 0;
data.GroupPrice = 0;
data.MemberPrice = 0;
de.FareSetting.AddObject(data);
de.SaveChanges();
return(data);
}
public Tax NewData()
{
int lastId;
string threaId;
Tax lastData = de.ExecuteStoreQuery <Tax>(@"SELECT * FROM Tax ORDER BY TaxId*1 DESC LIMIT 1").FirstOrDefault();
threaId = de.Theater.Select(p => p.TheaterId).FirstOrDefault();
if (lastData != null)
{
lastId = lastData.TaxId;
}
else
{
lastId = 0;
}
int newId = lastId + 1;
Tax data = new Tax();
data.TaxId = newId;
// 更新数据基础值
data.TheaterId = threaId;
data.TaxRate = 0;
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
de.Tax.AddObject(data);
de.SaveChanges();
return(data);
}
/// <summary>
/// 保存区域票价，并更新ShowPlan的价格等级
/// </summary>
/// <param name="blocklist"></param>
/// <returns></returns>
public bool SetBlockPrice(List <BlockPrice> blocklist)
{
if (this.showPlamId == null)
{
return(false);
}
var tmp = de.ShowPlan.Where(p => p.ShowPlanId == this.showPlamId).FirstOrDefault();
var film = de.Film.Where(p => p.FilmId == tmp.FilmId).FirstOrDefault();
var tmplist = de.BlockPrice.Where(p => p.ShowPlanId == this.showPlamId).ToList();
if (tmp == null)
{
return(false);
}
int MaxId = GetMaxBlockId();
try
{
while (blocklist.Remove(blocklist.Where(p => p.BlockId == null || p.BlockId == string.Empty).FirstOrDefault()) == true)
{
;
}
foreach (var obj in blocklist)
{
if (film.LowestPrice > obj.SinglePrice ||
film.LowestPrice > obj.DoublePrice ||
film.LowestPrice > obj.StudentPrice ||
film.LowestPrice > obj.GroupPrice ||
film.LowestPrice > obj.MemberPrice ||
film.LowestPrice > obj.BoxPrice)
{
throw new NotImplementedException("最低票价不能小于影片的最低价！");
}
}
foreach (var list in blocklist)
{
if (list.BlockPriceId == string.Empty)
{
continue;
}
list.BlockPriceId = MaxId.ToString();
list.ShowPlanId = this.showPlamId;
list.Created = DateTime.Now;
list.ActiveFlag = true;
MaxId++;
de.BlockPrice.AddObject(list);
de.Block.Where(p => p.BlockId == list.BlockId).FirstOrDefault().HasBlockPrice = true;
}
//删除已删除的区域票价
foreach (var list in tmplist)
{
var obj = de.BlockPrice.Where(p => p.BlockId == list.BlockId).FirstOrDefault();
if (obj == null)
{
de.Block.Where(p => p.BlockId == list.BlockId).FirstOrDefault().HasBlockPrice = false;
}
if (blocklist.Where(p => p.BlockPriceId == list.BlockPriceId).FirstOrDefault() == null)
{
de.BlockPrice.DeleteObject(list);
}
}
tmp.FareSettingId = GetBlockfareSettingPriceId();
de.SaveChanges();
List <BlockPrice> newlist = de.BlockPrice.Where(p => p.ShowPlanId == this.showPlamId).ToList();
this.blockPriceList = newlist;
return(true);
}
catch (Exception e)
{
throw new NotImplementedException(e.Message);
}
}
/// <summary>
/// 获取影片信息
/// </summary>
/// <returns></returns>
public List <FilmAndFilmMode> GetFilmAndFilmModeList()
{
List <FilmAndFilmMode> tmpDelList = new List <FilmAndFilmMode>();
List <FilmAndFilmMode> filmModeList = new List <FilmAndFilmMode>();
var tmp = from f in de.Film
join m in de.Film_FilmMode on f.FilmId equals m.FilmId
into newffm
from ffm in newffm.DefaultIfEmpty()
join o in de.FilmMode on(int) ffm.FilmModeId equals(int) o.FilmModeId
into newfm
from fm in newfm.DefaultIfEmpty()
select new FilmAndFilmMode
{
FilmId = f.FilmId,
FilmCode = f.FilmCode,
FilmName = f.FilmName,
PublishDate = (DateTime)f.PublishDate,
Publisher = f.Publisher,
Producer = f.Producer,
Director = f.Director,
Cast = f.Cast,
Brief = f.Brief,
// Poster = f.Poster,
StartDate = (DateTime)f.StartDate,
EndDate = (DateTime)f.EndDate,
FilmLength = (int)f.FilmLength,
Rent = (float)f.Rent,
Ratio = (float)f.Ratio,
LowestPrice = (float)f.LowestPrice,
FilmAreaId = f.FilmAreaId,
FilmCategoryId = f.FilmCategoryId,
HasMode = (bool)f.HasMode,
Created = f.Created,
Updated = f.Updated,
ActiveFlag = f.ActiveFlag,
ColorCode = f.BorderColour,
Film_FilmModeId = ffm.Film_FilmModeId,
Film_FilmModeColorCode = ffm.BorderColour,
FilmModeId = fm.FilmModeId,
FilmModeName = fm.FilmModeName,
};
filmModeList.AddRange(tmp);
string oldFilmId = "";
foreach (var list in filmModeList)
{
if (list.HasMode == true && list.Film_FilmModeId != null && list.FilmModeId != null)
{
list.FilmId += ";" + list.Film_FilmModeId;
list.FilmName += "(" + list.FilmModeName + ")";
}
if (list.HasMode == false && list.FilmId == oldFilmId)
{
tmpDelList.Add(list);
}
oldFilmId = list.FilmId;
}
if (tmpDelList.Count > 0)
{
foreach (var del in tmpDelList)
{
filmModeList.Remove(del);
}
}
this.filmAndFilmModeList = filmModeList;
this.filmAndFilmModeList = CheckColor(filmModeList);
de.SaveChanges();
return(this.filmAndFilmModeList);
}
/// <summary>
/// 获取影片信息
/// </summary>
/// <returns></returns>
public List <FilmAndFilmMode> GetFilmAndFilmModeList()
{
List <FilmAndFilmMode> tmpDelList = new List <FilmAndFilmMode>();
List <FilmAndFilmMode> filmModeList = new List <FilmAndFilmMode>();
var tmp = from f in de.Film
join m in de.Film_FilmMode on f.FilmId equals m.FilmId
into newffm
from ffm in newffm.DefaultIfEmpty()
join o in de.FilmMode on(int) ffm.FilmModeId equals(int) o.FilmModeId
into newfm
from fm in newfm.DefaultIfEmpty()
where (f.StartDate <= this.dataMager.DailyShowPlan.DailyPlan.PlanDate && f.EndDate >= this.dataMager.DailyShowPlan.DailyPlan.PlanDate)
select new FilmAndFilmMode
{
FilmId = f.FilmId,
FilmCode = f.FilmCode,
FilmName = f.FilmName,
PublishDate = (DateTime)f.PublishDate,
Publisher = f.Publisher,
Producer = f.Producer,
Director = f.Director,
Cast = f.Cast,
Brief = f.Brief,
// Poster = f.Poster,
StartDate = (DateTime)f.StartDate,
EndDate = (DateTime)f.EndDate,
FilmLength = (int)f.FilmLength,
Rent = (float)f.Rent,
Ratio = (float)f.Ratio,
LowestPrice = (float)f.LowestPrice,
FilmAreaId = f.FilmAreaId,
FilmCategoryId = f.FilmCategoryId,
HasMode = (bool)f.HasMode,
Created = f.Created,
Updated = f.Updated,
ActiveFlag = f.ActiveFlag,
ColorCode = f.BorderColour,
Film_FilmModeId = ffm.Film_FilmModeId,
Film_FilmModeColorCode = ffm.BorderColour,
FilmModeId = fm.FilmModeId,
FilmModeName = fm.FilmModeName,
};
filmModeList.AddRange(tmp);
string oldFilmId = "";
var tmplist = filmModeList.Where(p => p.HasMode == true && p.FilmModeId != null).OrderBy(p => p.FilmId).ToList();
foreach (var obj in tmplist)
{
if (obj.FilmId == oldFilmId ||
filmModeList.Where(p => p.FilmId == obj.FilmId && p.HasMode == false).FirstOrDefault() != null)
{
continue;
}
FilmAndFilmMode tmpobj = new FilmAndFilmMode();
oldFilmId = obj.FilmId;
tmpobj.FilmId = obj.FilmId;
tmpobj.FilmCode = obj.FilmCode;
tmpobj.FilmName = obj.FilmName;
tmpobj.PublishDate = obj.PublishDate;
tmpobj.Publisher = obj.Publisher;
tmpobj.Producer = obj.Producer;
tmpobj.Director = obj.Director;
tmpobj.Cast = obj.Cast;
tmpobj.Brief = obj.Brief;
// Poster = tmoobj..Poster;
tmpobj.StartDate = obj.StartDate;
tmpobj.EndDate = obj.EndDate;
tmpobj.FilmLength = obj.FilmLength;
tmpobj.Rent = obj.Rent;
tmpobj.Ratio = obj.Ratio;
tmpobj.LowestPrice = obj.LowestPrice;
tmpobj.FilmAreaId = obj.FilmAreaId;
tmpobj.FilmCategoryId = obj.FilmCategoryId;
tmpobj.HasMode = false;
tmpobj.Created = obj.Created;
tmpobj.Updated = obj.Updated;
tmpobj.ActiveFlag = obj.ActiveFlag;
tmpobj.ColorCode = obj.Film_FilmModeColorCode;
tmpobj.Film_FilmModeId = null;
tmpobj.Film_FilmModeColorCode = string.Empty;
tmpobj.FilmModeId = null;
tmpobj.FilmModeName = string.Empty;
filmModeList.Add(tmpobj);
}
foreach (var list in filmModeList)
{
if (list.HasMode == true && list.Film_FilmModeId != null && list.FilmModeId != null)
{
list.FilmId += ";" + list.Film_FilmModeId;
list.FilmName += "(" + list.FilmModeName + ")";
}
if (list.HasMode == false && list.FilmId == oldFilmId)
{
tmpDelList.Add(list);
oldFilmId = list.FilmId;
}
}
if (tmpDelList.Count > 0)
{
foreach (var del in tmpDelList)
{
filmModeList.Remove(del);
}
}
this.filmAndFilmModeList = filmModeList;
this.filmAndFilmModeList = CheckColor(filmModeList);
de.SaveChanges();
return(this.filmAndFilmModeList);
}
public void Import()
{
List <FilmDownloadInfo> importList = this.downloadList.Where(p => p.Check == true).ToList();
List <Film> filmList = de.Film.ToList();
List <FilmCategory> filmCategoryList = de.FilmCategory.ToList();
List <FilmArea> filmAreaList = de.FilmArea.ToList();
foreach (FilmDownloadInfo filmDown in importList)
{
Film film = filmList.Where(p => p.FilmCode.Trim() == filmDown.ID).FirstOrDefault();
if (film == null)
{
film = new Film();
// 生成新的Id（这里长度是12位）
// 2011.12.30, Jiang, 生成规则：影片编号+年份
film.FilmId = filmDown.ID + year;
de.Film.AddObject(film);
try
{
film.FilmCode = filmDown.ID;
}
catch { }
try
{
film.FilmName = filmDown.Name;
}
catch { }
try
{
film.FilmAreaId = filmDown.ID.Substring(0, 3);
}
catch { }
if (filmAreaList.Where(p => p.FilmAreaId == film.FilmAreaId).FirstOrDefault() == null)
{
throw new Exception(string.Format("导入影片 \"{0}:{1}\" 失败，原因为：影片产地 \"{2}\" 不存在!", film.FilmId, film.FilmName, film.FilmAreaId));
}
try
{
film.FilmCategoryId = filmDown.ID.Substring(3, 1);
}
catch { }
if (filmCategoryList.Where(p => p.FilmCategoryId == film.FilmCategoryId).FirstOrDefault() == null)
{
throw new Exception(string.Format("导入影片 \"{0}:{1}\" 失败，原因为：影片分类 \"{2}\" 不存在!", film.FilmId, film.FilmName, film.FilmCategoryId));
}
// 添加默认值
film.HasMode = false;
film.FilmLength = 0;
//2011.12.30, Jiang, 这里现在不需要赋值，赋上空值，优化速度
film.Publisher = string.Empty;
film.Producer = string.Empty;
film.Director = string.Empty;
film.Cast = string.Empty;
film.Brief = string.Empty;
try
{
if (string.IsNullOrWhiteSpace(filmDown.PublishDate) != true)
{
film.PublishDate = Convert.ToDateTime(filmDown.PublishDate);
}
}
catch { }
}
}
try
{
de.SaveChanges();
}
catch (OptimisticConcurrencyException)
{
de.Refresh(RefreshMode.ClientWins, de.Film);
de.SaveChanges();
}
}
public DownloadSetting NewData()
{
int lastId;
DownloadSetting lastData = de.DownloadSetting.OrderByDescending(p => p.Created).FirstOrDefault();
Theater threater = de.Theater.FirstOrDefault();
// 不能两条记录的创建时间一样，避免主键重复
if (lastData != null && lastData.Created == DateTime.Now)
{
throw new Exception();
}
if (lastData != null)
{
lastId = lastData.DownloadId;
}
else
{
lastId = 0;
}
string newId;
// 生成新的Id（这里长度是12位）
try
{
newId = string.Format("{0:D12}", Convert.ToInt64(lastId) + 1);
}
catch
{
newId = string.Format("{0:D12}", 1);
}
DownloadSetting data = new DownloadSetting();
data.DownloadId = Convert.ToInt32(newId);
//2011.12.24 LIN 判断是否存在id这一条数据
int id = data.DownloadId;
while (IsCreated(id) != null)
{
id += 1;
IsCreated(id);
}
data.DownloadId = id;
// 更新数据基础值
data.Created = DateTime.Now;
data.Updated = data.Created;
data.ActiveFlag = true;
// 更新非String类型的值，优化速度
data.TheaterId = threater.TheaterId;
data.ProxyPort = 0;
data.Port = 0;
data.IsProxy = false;
data.IsAnonymAllowed = false;
de.DownloadSetting.AddObject(data);
de.SaveChanges();
return(data);
}