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"); }