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