/// <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; } }
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; } }