public string[] GetVoucherIdList(string columnName, string value)
{
string sql = string.Format(@"SELECT * FROM VoucherType WHERE {0} LIKE '%{1}%'", columnName, value);
var list = de.ExecuteStoreQuery <VoucherType>(sql).ToList();
string[] array = new string[list.Count];
int i = 0;
foreach (var var in list)
{
array[i] = var.VoucherTypeId.ToString();
i++;
}
return(array);
}
/// <summary>
/// 根据输入的内容模糊查CustomerId
/// </summary>
/// <param name="columnName"></param>
/// <param name="value"></param>
/// <returns></returns>
public string[] GetCustomerIdList(string columnName, string value)
{
string sql = string.Format(@"SELECT * FROM Customer WHERE {0} LIKE '%{1}%'", columnName, value);
var list = de.ExecuteStoreQuery <Customer>(sql).ToList();
string[] ayyay = new string[list.Count];
int i = 0;
foreach (var var in list)
{
ayyay[i] = var.CustomerId.ToString();
i++;
}
return(ayyay);
}
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 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 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 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 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);
}
/// <summary>
/// 获取影片的基础查询信息
/// </summary>
/// <param name="FilmId"></param>
/// <returns></returns>
public List <Ticket_BaseQuery> GetFilmTicket_BaseQuery(string FilmId, DateTime dt)
{
Ticket_BaseQueryList.Clear();
if (FilmId.Contains(";") == true)
{
sql = string.Format(@"SELECT ShowPlanId, SUM(Ticketprice) as Total from Ticket where TicketStatus=0 and ShowPlanId in(select ShowPlanId from ShowPlan where FilmId='{0}' and Film_FilmModeId={1} and DailyPlanId=(select DailyPlanId from DailyPlan where PlanDate='{2}')) group by ShowPlanId", FilmId.Split(';')[0].ToString(), Convert.ToInt32(FilmId.Split(';')[1]), dt.Date);
}
else
{
sql = string.Format(@"SELECT ShowPlanId, SUM(Ticketprice) as Total from Ticket where TicketStatus=0 and ShowPlanId in(select ShowPlanId from ShowPlan where FilmId='{0}' and DailyPlanId=(select DailyPlanId from DailyPlan where PlanDate='{1}')) group by ShowPlanId", FilmId, dt.Date);
}
var dataList = de.ExecuteStoreQuery <Ticket_BaseQuery>(sql).ToList();
Ticket_BaseQueryList.AddRange(dataList);
FillOther();
return(Ticket_BaseQueryList);
}
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 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 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 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 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);
}
public List <DownloadSetting> GetSearchList(string columnName, string value)
{
return(de.ExecuteStoreQuery <DownloadSetting>(string.Format(@"SELECT * FROM DownloadSetting WHERE {0} LIKE '%{1}%'", columnName, value)).ToList());
}
public List <Voucher> GetSearchList(string columnName, string value)
{
return(de.ExecuteStoreQuery <Voucher>(string.Format(@"SELECT * FROM Voucher WHERE {0} LIKE '%{1}%'", columnName, value)).ToList());
}