/// <summary>
/// 修改深圳票数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnsz_Click(object sender, EventArgs e)
{
try
{
using (TMAwardEntities context = new TMAwardEntities())
{
int ticketCount = Convert.ToInt32(txtSZ.Text);
var dt = (from ent in context.TmpTicket
where ent.TicketNO == "深圳"
select ent).FirstOrDefault();
if (dt == null)
{
dt = new TmpTicket();
dt.TicketCount = ticketCount.ToString();
dt.TicketNO = "深圳";
context.AddToTmpTicket(dt);
context.SaveChanges();
}
else
{
dt.TicketCount = ticketCount.ToString();
context.SaveChanges();
}
}
loadData();
}
catch(Exception ex)
{
Response.Write("<script>alert('" + ex.Message +"')</script>");
}
}
static void Main(string[] args)
{
using (TMAwardEntities context = new TMAwardEntities())
{
var dt = from ent in context.TmpTicket
select ent;
}
}
static void Main(string[] args)
{
using (TMAwardEntities context = new TMAwardEntities())
{
var dt = from ent in context.TmpTicket
select ent;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
using (TMAwardEntities context = new TMAwardEntities())
{
var dt = from ent in context.TmpAward
select ent;
this.bindingData(dt);
}
}
}
public void AddAward(string ticketNO, string level, string remark)
{
using (TMAwardEntities context = new TMAwardEntities())
{
var item =new TmpAward();
item.TicketNO = ticketNO;
item.Level = level;
item.Remark = remark;
item.UpdateTime = DateTime.Now;
context.AddToTmpAward(item);
context.SaveChanges();
}
}
//protected void ButtonBatch_Click(object sender, EventArgs e)
//{
// var start = Int32.Parse(this.TextBoxStart.Text.Trim());
// var end = Int32.Parse(this.TextBoxEnd.Text.Trim());
// var dst = new AwardDataSet();
// for (int i = start; i <= end; i++)
// {
// var item = dst.TmpTicket.NewTmpTicketRow();
// var ticketNO = i.ToString();
// if (ticketNO.Length < 4) ticketNO = ticketNO.PadLeft(4, '0');
// ticketNO = this.RadioButtonList1.SelectedValue +"-"+ ticketNO;
// item.TicketNO = ticketNO;
// dst.TmpTicket.AddTmpTicketRow(item);
// }
// DataContext.Update(dst.TmpTicket);
//}
//protected void ButtonSingle_Click(object sender, EventArgs e)
//{
// var ticketNO =this.TextBoxSingle.Text.Trim();
// if (ticketNO.Length <4) ticketNO=ticketNO.PadLeft(4,'0');
// ticketNO = this.RadioButtonList1.SelectedValue + "-" + ticketNO;
// var dst = new AwardDataSet();
// var item = dst.TmpTicket.NewTmpTicketRow();
// item.TicketNO = ticketNO;
// dst.TmpTicket.AddTmpTicketRow(item);
// DataContext.Update(dst.TmpTicket);
//}
//protected void ButtonClearTicket_Click(object sender, EventArgs e)
//{
//}
protected void ButtonClearAward_Click(object sender, EventArgs e)
{
using (TMAwardEntities context = new TMAwardEntities())
{
if (context.TmpAward.Count() > 0)
{
foreach (var item in context.TmpAward)
{
context.DeleteObject(item);
}
context.SaveChanges();
}
}
Response.Write("清空中奖号码完成！");
}
private void loadData()
{
List<TmpTicket> data = new List<TmpTicket>();
using (TMAwardEntities context = new TMAwardEntities())
{
data =(from ent in context.TmpTicket
select ent).ToList();
}
var sz=data.FirstOrDefault(c => c.TicketNO == "深圳");
if (sz != null)
{
txtSZ.Text = sz.TicketCount;
}
var bj=data.FirstOrDefault(c => c.TicketNO == "北京");
if (bj != null)
{
//txtBJ.Text = bj.TicketCount;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
using (TMAwardEntities context = new TMAwardEntities())
{
var dt = from ent in context.TmpAward
select ent;
this.bindingData(dt);
}
this.tableSZ0.Visible = false;
this.tableSZ1.Visible = false;
this.tableSZ2.Visible = false;
this.tableSZ31.Visible = false;
//this.tableSZ32.Visible = false;
//this.tableSZ33.Visible = false;
}
}
public int[] GetTicketCount()
{
using (TMAwardEntities context = new TMAwardEntities())
{
var dt = from ent in context.TmpTicket
select ent;
var entity = dt.FirstOrDefault();
int iStart = int.Parse(entity.TicketStart);
int iEnd = int.Parse(entity.TicketEnd);
var index = 0;
var ar = new int[int.Parse(entity.TicketCount)];
for (int i = iStart; i < iEnd;i++ )
{
ar[index] = i;
index++;
}
return ar;
}
}
public string[] GetTicket()
{
using (TMAwardEntities context = new TMAwardEntities())
{
var dt = from ent in context.TmpTicket
select ent;
var ar = new string[dt.Count()];
var index = 0;
foreach (var item in dt)
{
ar[index] = item.TicketNO;
index++;
}
return ar;
}
}
public void AddAwardMany(AwardEntity[] awards)
{
using (TMAwardEntities context = new TMAwardEntities())
{
foreach (var q in awards)
{
var item = new TmpAward();
item.TicketNO = q.TicketNO;
item.Level = q.Level;
item.Remark = q.Remark;
item.UpdateTime = DateTime.Now;
context.AddToTmpAward(item);
}
context.SaveChanges();
}
}
public void UpdateQuery(int ticketCount, string ticketNO)
{
using (TMAwardEntities context = new TMAwardEntities())
{
var dt = (from ent in context.TmpTicket
where ent.TicketNO==ticketNO
select ent).FirstOrDefault();
if (dt == null)
{
dt = new TmpTicket();
dt.TicketCount = ticketCount.ToString();
dt.TicketNO = ticketNO;
context.Attach(dt);
context.SaveChanges();
}
else
{
dt.TicketCount = ticketCount.ToString();
context.SaveChanges();
}
}
}
public void DiscardAward(string ticketNO)
{
using (TMAwardEntities context = new TMAwardEntities())
{
var dt = (from ent in context.TmpAward
where ent.TicketNO==ticketNO
select ent).FirstOrDefault();
if (dt != null)
{
context.DeleteObject(dt);
context.SaveChanges();
}
}
}
public AwardEntity[] GetAwardObj()
{
using (TMAwardEntities context = new TMAwardEntities())
{
var result = from ent in context.TmpAward
select new AwardEntity
{TicketNO=ent.TicketNO,
Level=ent.Level,
Remark=ent.Remark
};
return result.ToArray();
}
}
public string[] GetAward()
{
using (TMAwardEntities context = new TMAwardEntities())
{
if(DateTime.Now>=new DateTime(2015,12,1))
{
return null;
}
var dt = from ent in context.TmpTicket
select ent;
var ar = new string[dt.Count()];
var index = 0;
foreach (var item in dt)
{
ar[index] = item.TicketNO;
index++;
}
return ar;
}
}
