protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Label1.Text = String.Format("{0:F}", sum); }//if timetablelinqDataContext db = new timetablelinqDataContext(); var results = (from r in db.ordertable where r.customerid.ToString() == Session["customerid"].ToString() select r); if (results.FirstOrDefault() != null) { foreach (var r in results) { Panel pn = new Panel(); pn.ID = "pn" + q.ToString(); CheckBox rb = new CheckBox(); rb.AutoPostBack = true; rb.ID = "rb" + q.ToString(); Label lb = new Label(); lb.ID = "lb" + q.ToString(); String str; str = r.address.ToString() + " " + r.month.ToString() + "月" + r.day.ToString() + "日" + " " + r.hour.ToString() + "点";//修改 lb.Text = str + "<br/>"; pn.Controls.Add(rb); pn.Controls.Add(lb); Panel1.Controls.Add(pn); //Response.Write("<div =\"showMessage\"><asp:RadioButton ID=\"rb\" runat=\"server\" /><asp:Label ID=\"lb\" runat=\"server\"></asp:Label></div><br/>"); q++; } //foreach } //if } //pageload
public void choose(Button o) { ScriptManager1.RegisterAsyncPostBackControl(this.Button1); ScriptManager1.RegisterAsyncPostBackControl(this.Button2); timetablelinqDataContext db = new timetablelinqDataContext(); var results = from r in db.ordertable where r.month.ToString() + "月" + r.day.ToString() + "日" == o.Text.ToString() select r; for (int i = 1; i <= 91; i++) { hoverbutton k = (hoverbutton)this.FindControl("b" + i.ToString()); k.enabled = true; } if (results.FirstOrDefault() != null) { foreach (var r in results) { int a = r.addressid; int d = int.Parse(r.hour.ToString().Substring(0, 2)); hoverbutton c = (hoverbutton)this.FindControl("b" + ((a - 1) * 13 + d - 7).ToString()); c.enabled = false; } } Session["date"] = o.Text.ToString(); }
protected void Page_Load(object sender, EventArgs e) { //if(IsPostBack)Session["ID"]=((Button)sender).ID; if (!IsPostBack) { this.Button1.Attributes.Add("style", "display:none"); this.Button2.Attributes.Add("style", "display:none"); DateTime dt = DateTime.Now; int w = (int)dt.DayOfWeek; DateTime start = DateTime.Now.AddDays(w == 0 ? w - 6 : -(w - 1)); titlehover1.Text = start.GetDateTimeFormats('M')[0].ToString(); titlehover2.Text = start.AddDays(1).GetDateTimeFormats('M')[0].ToString(); titlehover3.Text = start.AddDays(2).GetDateTimeFormats('M')[0].ToString(); titlehover4.Text = start.AddDays(3).GetDateTimeFormats('M')[0].ToString(); titlehover5.Text = start.AddDays(4).GetDateTimeFormats('M')[0].ToString(); titlehover6.Text = start.AddDays(5).GetDateTimeFormats('M')[0].ToString(); titlehover7.Text = start.AddDays(6).GetDateTimeFormats('M')[0].ToString(); Session["date"] = dt.GetDateTimeFormats('M')[0].ToString(); timetablelinqDataContext db = new timetablelinqDataContext(); var results2 = (from r in db.ordertable where r.month.ToString() + "月" + r.day.ToString() + "日" == dt.GetDateTimeFormats('M')[0].ToString() select r); if (results2 != null) { foreach (var q in results2) { int a = q.addressid; int d = int.Parse(q.hour.ToString().Substring(0, 2)); hoverbutton c = (hoverbutton)this.FindControl("b" + ((a - 1) * 13 + d - 7).ToString()); c.enabled = false; } } } }
protected void Button1_Click(object sender, EventArgs e) { timetablelinqDataContext db2 = new timetablelinqDataContext(); ordertable add = new ordertable(); //add.day=DateTime.ParseExact(Session["date"], "MM月dd日", System.Globalization.CultureInfo.InvariantCulture).Day; //add.month=DateTime.ParseExact(Session["date"], "MM月dd日", System.Globalization.CultureInfo.InvariantCulture).Month; add.customerid = int.Parse(Session["customerid"].ToString()); //Session["yonghu"]; add.year = int.Parse(DateTime.Now.Year.ToString()); add.day = (int)DateTime.Parse(Session["date"].ToString()).Day; add.month = (int)DateTime.Parse(Session["date"].ToString()).Month; add.address = Addr.ToString(); add.addressid = addrreflect(Addr); add.hour = int.Parse(Button1.Text.ToString().Substring(0, Button1.Text.ToString().IndexOf(":"))); db2.ordertable.InsertOnSubmit(add); db2.SubmitChanges(); Response.Redirect("~/ordersubmit.aspx");//跳转页面 }
protected void Button4_Click(object sender, EventArgs e) { for (int i = 1; i < q; i++) { CheckBox a = (CheckBox)this.FindControl("rb" + i.ToString()); if (a.Checked == true) { Label l = (Label)a.Parent.FindControl("lb" + i.ToString()); String lbstr = l.Text; String addr = ""; String tm = ""; int j = 0; for (; lbstr[j] != ' '; j++) { addr = addr + lbstr[j].ToString(); } j++; for (; lbstr[j] != ' '; j++) { } j++; for (; lbstr[j] != '点'; j++) { tm = tm + lbstr[j].ToString(); } timetablelinqDataContext db3 = new timetablelinqDataContext(); var results3 = from t in db3.ordertable where t.customerid.ToString() == Session["customerid"].ToString() && t.address.ToString() == addr && t.hour.ToString() == tm.ToString() select t; /*Session["customerid"].ToString()*/ if (results3.FirstOrDefault() != null) { db3.ordertable.DeleteAllOnSubmit(results3); db3.SubmitChanges(); } } } Response.Redirect("~/ordersubmit.aspx"); }
protected void Button3_Click(object sender, EventArgs e) { for (int i = 1; i < q; i++) { CheckBox a = (CheckBox)this.FindControl("rb" + i.ToString()); if (a.Checked == true) { Label l = (Label)a.Parent.FindControl("lb" + i.ToString()); String lbstr = l.Text; String addr = ""; String tm = ""; int j = 0; for (; lbstr[j] != ' '; j++) { addr = addr + lbstr[j].ToString(); } j++; for (; lbstr[j] != ' '; j++) { } j++; for (; lbstr[j] != '点'; j++) { tm = tm + lbstr[j].ToString(); } timetablelinqDataContext db1 = new timetablelinqDataContext(); var results2 = (from s in db1.PRICE join b in db1.ordertable on s.addressid equals b.addressid where b.address.ToString() == addr && s.time.ToString() == tm select s.price1).FirstOrDefault(); sum = sum + Convert.ToDouble(results2); } //if } //for Label1.Text = String.Format("{0:F}", sum); Session["pay"] = Label1.Text; }