/// <summary> /// 根据城市获取柜台地址 /// </summary> /// <param name="city"></param> /// <returns></returns> public static List <city> GetCounterAddr(string city) { city = city.Replace("'", "''"); var ets = new Tab_Order1Counter().ListAll("select * from Tab_Order1Counter where CounterCity='" + city + "' and LEN(counteraddr)>0"); if (null == ets || ets.Count() < 1) { return(null); } return(ets.Select(k => new city { name = k.CounterCity, address = k.CounterAddr, Idx = k.Idx.ToString() }).ToList()); }
protected void Page_Load(object sender, EventArgs e) { VerfiyAdmin.CheckVIPUserLogin(this); UserAvaPoint = VerfiyAdmin.LoginUser.AvailablePoints; if (!IsPostBack) { var Id = 0; var idx = Request["Id"]; if (string.IsNullOrEmpty(idx) || !Int32.TryParse(idx, out Id)) { return; } var et = new Tab_Order4Total().Get(Id.ToString()); if (null == et) { return; } lblOrdNo.Text = et.OrderNo; var usr = VerfiyAdmin.LoginUser; if (null == usr) { return; } lblMail.Text = usr.UserEmail; var counter = new Tab_Order1Counter().Get(et.CounterIdx.ToString()); if (null == counter) { return; } lblCounterName.Text = counter.CounterName; lblCounterPhone.Text = counter.CounterPhone; lblAddr.Text = counter.CounterAddr; } //子订单数据获取应该从库中来 //柜台 }