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