protected void Page_Load(object sender, EventArgs e) { DataSet ds = bll.GetList(100, "msn='" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "id"); foreach (DataRow dr in ds.Tables[0].Rows) { model = bll.GetModel(int.Parse(dr["id"].ToString())); try { string title = "積分清零提醒"; string str = "您還有" + dr["point"] + "積分年底到期請注意使用。"; TWMail.sendMail(siteConfig.emailsmtp, siteConfig.emailssl, siteConfig.emailport, siteConfig.emailusername, siteConfig.emailpassword, siteConfig.emailnickname, siteConfig.emailfrom, dr["email"].ToString(), title + " - " + siteConfig.webname + "", str); } catch (Exception eee) { } model.msn = System.DateTime.Now.ToString("yyyyMMdd"); bll.Update(model); } if (ds.Tables[0].Rows.Count > 0) { Response.Write("正在發送請勿關閉本頁"); Response.Redirect("mail.aspx"); } else { Response.Write("發送完畢可以關閉本頁"); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { id = TWRequest.GetQueryInt("id"); if (id != 0) { model = bll.GetModel(id); weburl = config.weburl; } }
protected void Page_Load(object sender, EventArgs e) { data_type.DataSource = Tea.DBUtility.DbHelperSQL.Query("select * from shop_article_category where channel_id=7 and call_index='1' order by sort_id desc"); data_type.DataBind(); _users = new Tea.Web.UI.ShopPage().GetUserInfo(); cartModel = Tea.Web.UI.ShopCart.GetTotal(1); }
protected void Page_Load(object sender, EventArgs e) { _users = new Tea.Web.UI.ShopPage().GetUserInfo(); data_type.DataSource = Tea.DBUtility.DbHelperSQL.Query("select * from shop_article_category where channel_id=7 and call_index='1' order by sort_id desc"); data_type.DataBind(); key = TWRequest.GetQueryString("key"); this.page = TWRequest.GetQueryInt("page", 1); this.tid = TWRequest.GetQueryInt("tid", 0); this.hid = TWRequest.GetQueryInt("hid", 0); this.sort = TWRequest.GetQueryInt("sort", 0); if (sort == 1) { _orderby = "add_time desc,id desc"; } if (sort == 2) { _orderby = "click desc"; } if (sort == 3) { _orderby = "market_price,id"; } if (sort == 4) { _orderby = "market_price desc,id"; } if (tid != 0) { _sql = _sql + " and (category_id=" + tid + " or more_type like'%," + tid + ",%')"; tname = new Tea.BLL.article_category().GetTitle(tid); try { Tea.Model.article_category model = new Tea.BLL.article_category().GetModel(tid); title = model.seo_title; keyword = model.seo_keywords; describe = model.seo_description; } catch (Exception eee) { } } if (!string.IsNullOrEmpty(key)) { _sql = _sql + " and title like'%" + key + "%'"; tname = key; } Tea.Web.UI.ShopPage bll_view = new Tea.Web.UI.ShopPage(); data_list.DataSource = bll_view.GetViewList("view_article_product", "", this.pageSize, this.page, _sql, _orderby, out this.totalCount); data_list.DataBind(); string pageUrl = Utils.CombUrlTxt("index.aspx", "tid={0}&key={1}&sort={2}&page={3}", tid.ToString(), key.ToString(), sort.ToString(), "__id__"); PageContent.InnerHtml = Utils.OutPageListWeb(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
protected void Page_Load(object sender, EventArgs e) { id = TWRequest.GetQueryInt("id"); code = TWRequest.GetQueryString("code"); Tea.Model.users model = bll.GetModel(id); if (model.password != code) { Response.Write(ljd.function.LocalHint("郵箱驗證失敗,請重新驗證", "reg.aspx")); } else { model.status = 0; bll.Update(model); } }
protected void Page_Load(object sender, EventArgs e) { pwd = TWRequest.GetQueryString("pwd"); id = TWRequest.GetQueryInt("id"); act = TWRequest.GetFormString("act"); if (id > 0) { model = bll.GetModel(id); if (model.password != pwd) { Response.Write(ljd.function.LocalHint("該鏈接已經失效", "login.aspx")); Response.End(); } } if (act == "act_edit") { model = bll.GetModel(id); //檢查輸入的舊密碼 string oldpassword = TWRequest.GetFormString("txt_pwd"); string password = TWRequest.GetFormString("txt_pwd1"); if (string.IsNullOrEmpty(oldpassword)) { Response.Write(ljd.function.LocalHint("請輸入您的密碼!", "")); return; } //檢查輸入的新密碼 if (string.IsNullOrEmpty(password)) { Response.Write(ljd.function.LocalHint("請輸入確認密碼!", "")); return; } //舊密碼是否正確 if (password != oldpassword) { Response.Write(ljd.function.LocalHint("對不起,您輸入的密碼不正確!", "")); return; } model.password = DESEncrypt.Encrypt(password, model.salt); bll.Update(model); Response.Write(ljd.function.LocalHint("重置密碼成功,請用新密碼登入", "login.aspx")); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { _users = new Tea.Web.UI.ShopPage().GetUserInfo(); act = TWRequest.GetQueryString("act"); if (act == "send") { try { string mailTitle = "驗證郵箱通知信", mailContent = ""; string url = weburl + "mail/reg.aspx?id=" + _users.id, ss = ""; //Response.Write(url); //Response.End(); mailContent = ljd.function.GetPage(url, out ss); // 發送郵件 TWMail.sendMail(config.emailsmtp, config.emailssl, config.emailport, config.emailusername, config.emailpassword, config.emailnickname, config.emailfrom, _users.email, mailTitle, mailContent); } catch (Exception eee) { } Response.Write(ljd.function.LocalHint("已發送帳號啟用信至您的電子信箱,請至信箱確認並啟用。", "regno.aspx")); Response.End(); } }
//第三方登入後處理 protected void multi_login(string id, string name, string email, string source) { Tea.Model.users model = new Tea.Model.users(); Tea.BLL.users bll = new Tea.BLL.users(); //自動加入會員 DataSet ds = bll.GetList(1, "user_name='" + id + "'", "id"); //Response.Write(ds.Tables[0].Rows.Count); if (ds.Tables[0].Rows.Count == 0) { if (!string.IsNullOrEmpty(email) && email.Length > 5) { if (new Tea.BLL.users().ExistsEmail(email)) { Response.Write(ljd.function.LocalHint("此帳號信箱已存在於此網站,請以新mail註冊", "/users/login.aspx")); Response.End(); } } model.group_id = 1; model.status = 0; model.user_name = id; model.password = DESEncrypt.Encrypt(ljd.function.getUUIDString(12)); model.email = email; // txtEmail.Text; //model.birthday = DateTime.Parse("1980-1-1"); model.nick_name = name; //txtNickName.Text; model.mobile = ""; //txtTelphone.Text.Trim(); model.address = ""; //Request["txtcity"] + "|" + Request["txtcity1"] + "|" + txtZip.Text + "|" + txtAddress.Text.Trim(); model.reg_time = DateTime.Now; model.reg_ip = TWRequest.GetIP(); model.user_hei = 2; int uid = bll.Add(model); model = bll.GetModel(uid); //model.id = uid; } else { model = bll.GetModel(id); if (model == null) { Response.Write(ljd.function.LocalHint("您已更改本站密碼,請用本站密碼登入!", "/users/login.aspx")); Response.End(); } } //防止Session提前過期 try { Session[TWKeys.SESSION_USER_INFO] = model; Session.Timeout = 4500; //防止Session提前過期 Utils.WriteCookie(TWKeys.COOKIE_USER_NAME_REMEMBER, "Tea", model.user_name); Utils.WriteCookie(TWKeys.COOKIE_USER_PWD_REMEMBER, "Tea", model.password); Tea.Model.cart_total cartModel = Tea.Web.UI.ShopCart.GetTotal(1); if (cartModel.total_quantity == 0) { Response.Redirect("/Default.aspx"); } else { Response.Redirect("/shop/cart.aspx"); } //寫入登入日誌 // new Tea.BLL.user_login_log().Add(model.id, model.user_name, "會員登入", TWRequest.GetIP()); } catch { Response.Write("no"); } //寫入登入日誌 //new Tea.BLL.user_login_log().Add(model.id, model.user_name, id + "會員登入", TWRequest.GetIP()); //Response.Write(model.id+"--"+model.user_name+"--"+model.email); }
protected void Page_Load(object sender, EventArgs e) { _users = new Tea.Web.UI.ShopPage().GetUserInfo(); }
protected void Page_Load(object sender, EventArgs e) { _users = new Tea.Web.UI.ShopPage().GetUserInfo(); data_type.DataSource = Tea.DBUtility.DbHelperSQL.Query("select * from shop_article_category where channel_id=7 and call_index='1' order by sort_id desc"); data_type.DataBind(); gid = TWRequest.GetQueryInt("gid"); id = TWRequest.GetQueryInt("id"); if (id != 0) { model = bll.GetModel(id); if (model.status != 0) { Response.Redirect("/error.aspx?msg=您查看的商品已下架,若有任何問題可直接與客服聯繫"); } if (model.add_time > System.DateTime.Now) { Response.Redirect("/error.aspx?msg=您查看的商品已下架,若有任何問題可直接與客服聯繫"); } if (model.xia_date != null && model.xia_date.Value.AddDays(1) < System.DateTime.Now) { Response.Redirect("/error.aspx?msg=您查看的商品已下架,若有任何問題可直接與客服聯繫"); } try { if (model.brand_id == 5) { if (model.begin_time > System.DateTime.Now || model.end_time.AddDays(1) < System.DateTime.Now) { intshow = 0; } } } catch (Exception eee) { } tname = new Tea.BLL.article_category().GetTitle(model.category_id); title = model.seo_title; keyword = model.seo_keywords; describe = model.seo_description; bll.UpdateField(id, "click=click+1"); img_url = model.img_url; data_pic.DataSource = model.albums; data_pic.DataBind(); data_pic1.DataSource = model.albums; data_pic1.DataBind(); data_pic2.DataSource = model.albums; data_pic2.DataBind(); showpic = data_pic.Items.Count; } data_tui.DataSource = Tea.DBUtility.DbHelperSQL.Query("select * from view_article_product where (datediff(day,xia_date,getdate())<=0 or xia_date is null) and status=0 and datediff(minute,add_time,getdate())>=0 and id!=" + id + " and wheresql='tuan' and category_id=" + model.category_id + ""); data_tui.DataBind(); if (model.status == 0 && gid == 0) { DataSet ds = Tea.DBUtility.DbHelperSQL.Query("select * from shop_goods where parent_id=" + id + " order by sell_price"); data_goods.DataSource = ds; data_goods.DataBind(); goodlist = ""; foreach (DataRow dr in ds.Tables[0].Rows) { goodlist = goodlist + "\"" + dr["parent_id"].ToString() + "_" + dr["id"].ToString() + "\": { \"cartid\": \"" + dr["parent_id"].ToString() + "_" + dr["id"].ToString() + "\",\"price\": \"" + getyunum(Utils.StrToInt(dr["yu_lock"].ToString(), 0), Utils.StrToDecimal(dr["sell_price"].ToString(), 0), Utils.StrToDecimal(dr["yu_num"].ToString(), 0)).ToString().Replace(".00", "") + "\", \"mktprice\": \"" + dr["market_price"].ToString().Replace(".00", "") + "\" , \"stock_quantity\": \"" + dr["stock_quantity"].ToString() + "\", \"img_url\": \"" + dr["img_url"].ToString() + "\"},"; } if (ds.Tables[0].Rows.Count > 0) { //dr["sell_price"].ToString().Replace(".00", "") cartid = ds.Tables[0].Rows[0]["parent_id"].ToString() + "_" + ds.Tables[0].Rows[0]["id"].ToString(); stock_quantity = Utils.StrToInt(ds.Tables[0].Rows[0]["stock_quantity"].ToString(), 0); model.sell_price = getyunum(Utils.StrToInt(ds.Tables[0].Rows[0]["yu_lock"].ToString(), 0), Utils.StrToDecimal(ds.Tables[0].Rows[0]["sell_price"].ToString(), 0), Utils.StrToDecimal(ds.Tables[0].Rows[0]["yu_num"].ToString(), 0)); model.market_price = Utils.StrToDecimal(ds.Tables[0].Rows[0]["market_price"].ToString(), 0); model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString(); } } if (model.status == 0 && gid > 0) { DataSet ds = Tea.DBUtility.DbHelperSQL.Query("select * from view_user_group_price where parent_id=" + id + " and group_id=" + GetUserInfo().id + " and id=" + gid + ""); data_goods.DataSource = ds; data_goods.DataBind(); goodlist = ""; foreach (DataRow dr in ds.Tables[0].Rows) { goodlist = goodlist + "\"" + dr["parent_id"].ToString() + "_" + dr["id"].ToString() + "\": { \"cartid\": \"" + dr["parent_id"].ToString() + "_" + dr["id"].ToString() + "\",\"price\": \"" + dr["price"].ToString().Replace(".00", "") + "\", \"mktprice\": \"" + dr["market_price"].ToString().Replace(".00", "") + "\" , \"stock_quantity\": \"" + dr["stock_quantity"].ToString() + "\", \"img_url\": \"" + dr["img_url"].ToString() + "\"},"; } if (ds.Tables[0].Rows.Count > 0) { cartid = ds.Tables[0].Rows[0]["parent_id"].ToString() + "_" + ds.Tables[0].Rows[0]["id"].ToString(); stock_quantity = Utils.StrToInt(ds.Tables[0].Rows[0]["stock_quantity"].ToString(), 0); model.sell_price = Utils.StrToDecimal(ds.Tables[0].Rows[0]["price"].ToString(), 0); model.market_price = Utils.StrToDecimal(ds.Tables[0].Rows[0]["market_price"].ToString(), 0); model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString(); } } try { histroy = Request.Cookies["histroy"].Value.ToString(); } catch (Exception eee) { } if (string.IsNullOrEmpty(histroy)) { Response.Cookies["histroy"].Value = id.ToString(); Response.Cookies["histroy"].Expires = System.DateTime.Now.AddSeconds(30000000); histroy = Request.Cookies["histroy"].Value.ToString(); } else { IList _list = histroy.Split('|'); if (!_list.Contains(id)) { Response.Cookies["histroy"].Value = histroy + "|" + id; } } }
protected void Page_Load(object sender, EventArgs e) { id = Request["id"]; name = Request["name"]; if (!string.IsNullOrEmpty(id)) { Tea.Model.users model = new Tea.Model.users(); Tea.BLL.users bll = new Tea.BLL.users(); //自動加入會員 DataSet ds = bll.GetList(1, "user_name='" + id + "'", "id"); if (ds.Tables[0].Rows.Count == 0) { model.group_id = 1; model.status = 0; model.user_name = id; model.password = DESEncrypt.Encrypt(ljd.function.getUUIDString(12)); //model.birthday = DateTime.Parse("1980-1-1"); if (!string.IsNullOrEmpty(name)) { model.nick_name = name; } else { model.nick_name = "暱名"; } model.mobile = ""; model.address = ""; model.reg_time = DateTime.Now; model.reg_ip = TWRequest.GetIP(); model.user_hei = 1; model.point = 0; model.avatar = "https://graph.facebook.com/" + id + "/picture"; try { string tcode = Utils.GetCookie("tcode"); model.company = Utils.StrToInt(tcode, 0); } catch (Exception eee) { } int uid = bll.Add(model); model.id = uid; Session[TWKeys.SESSION_USER_INFO] = model; Session.Timeout = 4500; //防止Session提前過期 Utils.WriteCookie(TWKeys.COOKIE_USER_NAME_REMEMBER, "Tea", model.user_name); Utils.WriteCookie(TWKeys.COOKIE_USER_PWD_REMEMBER, "Tea", model.password); //寫入登入日誌 //new Tea.BLL.user_login_log().Add(); if (model.email.Length < 2) { Response.Write("2"); Response.End(); } Response.Write("1"); Response.End(); } else { model = bll.GetModel(id); model.avatar = "https://graph.facebook.com/" + id + "/picture"; bll.Update(model); if (model == null) { //Response.Write(Tea.Common.Utils.LocalHint("您已更改本站密碼,請用本站密碼登入!", "/login.aspx")); //Response.End(); } } //防止Session提前過期 try { Session[TWKeys.SESSION_USER_INFO] = model; Session.Timeout = 4500; //防止Session提前過期 Utils.WriteCookie(TWKeys.COOKIE_USER_NAME_REMEMBER, "Tea", model.user_name); Utils.WriteCookie(TWKeys.COOKIE_USER_PWD_REMEMBER, "Tea", model.password); //寫入登入日誌 //new Tea.BLL.user_login_log().Add(model.id, model.user_name, "會員登入", TWRequest.GetIP()); if (model.email.Length < 2) { Response.Write("2"); Response.End(); } Response.Write("1"); Response.End(); Tea.Model.cart_total cartModel = Tea.Web.UI.ShopCart.GetTotal(1); if (cartModel.total_quantity == 0) { Response.Write("3"); Response.End(); } else { Response.Write("4"); Response.End(); } } catch {// Response.Write("no"); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { Tea.BLL.users bll = new Tea.BLL.users(); act = Request["act"]; if (act == "act_find") { user = TWRequest.GetFormString("txt_email"); string remember = TWRequest.GetFormString("txt_code"); if (Session[TWKeys.SESSION_CODE] == null) { Response.Write(ljd.function.LocalHint("系統找不到驗證碼", "find.aspx")); return; } if (remember.ToLower() != Session[TWKeys.SESSION_CODE].ToString().ToLower()) { Response.Write(ljd.function.LocalHint("驗證碼輸入不正確", "find.aspx")); return; } Tea.Model.users model = bll.GetModel(user); if (model == null) { model = bll.GetEModel(user); } if (model == null) { Response.Write(ljd.function.LocalHint("對不起,您輸入的用戶名不存在!", "find.aspx")); return; } if (model.user_hei > 0) { Response.Write(ljd.function.LocalHint("您非一般註冊用戶,無法使用取回密碼功能!", "find.aspx")); return; } if (string.IsNullOrEmpty(model.email)) { Response.Write(ljd.function.LocalHint("您尚未設定郵箱地址,無法使用取回密碼功能!", "find.aspx")); return; } //生成隨機碼 string strcode = Utils.GetCheckCode(8); try { string mailTitle = "找回密碼通知信", mailContent = ""; string url = weburl + "mail/find.aspx?id=" + model.id, ss = ""; mailContent = ljd.function.GetPage(url, out ss); //發送郵件 TWMail.sendMail(config.emailsmtp, config.emailssl, config.emailport, config.emailusername, config.emailpassword, config.emailnickname, config.emailfrom, model.email, mailTitle, mailContent); //model.password = DESEncrypt.Encrypt(strcode, model.salt); //new Tea.BLL.users().Update(model); } catch (Exception eee) { Response.Write(ljd.function.LocalHint("發送失敗!", "find.aspx")); Response.End(); } Response.Write(ljd.function.LocalHint("已發送密碼至您的信箱!", "login.aspx")); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { uid = TWRequest.GetQueryInt("uid"); cart = TWRequest.GetQueryString("cart"); if (string.IsNullOrEmpty(cart)) { cart = "3"; } if (uid > 0) { userModel = new Tea.BLL.users().GetModel(uid); } cbquan = TWRequest.GetFormString("cbquan"); if (cart == "3") { cartModel = Tea.Web.UI.AdminCart.GetTotal(-3, uid); } if (cartModel.total_point > userModel.point) { Response.Write(ljd.function.LocalHint("紅利不足,請重新選擇商品!", "adminorder.aspx")); Response.End(); return; } try { guo = userModel.area.Split(',')[0].ToString(); area = userModel.area.Split(',')[1].ToString(); city = userModel.area.Split(',')[2].ToString(); zip = userModel.qq; } catch (Exception eee) { } DataSet ds_guo = Tea.DBUtility.DbHelperSQL.Query("select * from shop_basic where basic_where='city' order by basic_sort"); data_guo.DataSource = ds_guo; data_guo.DataBind(); dataguo.DataSource = ds_guo; dataguo.DataBind(); data_fp_guo.DataSource = ds_guo; data_fp_guo.DataBind(); data_invo_guo.DataSource = ds_guo; data_invo_guo.DataBind(); try { Tea.Model.express expModel = new Tea.BLL.express().GetModel(express_id); if (decimal.Parse(expModel.maxmoney.ToString()) > cartModel.real_amount) { yun = expModel.express_fee; } else { yun = 0; } } catch (Exception eee) { } if (cart == "3") { data_cart.DataSource = Tea.Web.UI.AdminCart.GetList(-3, uid); data_cart.DataBind(); } data_pay.DataSource = new Tea.BLL.payment().GetList(0, "is_lock=0", "sort_id desc,id desc"); data_pay.DataBind(); act = Request["act"]; if (act == "act_add") { if (TWRequest.GetFormString("txtguo") != "台灣") { string ycity = ""; DataSet yds = Tea.DBUtility.DbHelperSQL.Query("select basic_value,basic_type from shop_basic where basic_label='" + TWRequest.GetFormString("txtguo") + "' and basic_where='city'"); if (yds.Tables[0].Rows.Count > 0) { ycity = yds.Tables[0].Rows[0]["basic_type"].ToString(); DataSet yd_s = Tea.DBUtility.DbHelperSQL.Query("select top 1 basic_sort from shop_basic where basic_money>" + cartModel.total_num_zhe.ToString("0.") + " and basic_where='yunfei' and basic_type='" + ycity + "' order by basic_money"); if (yd_s.Tables[0].Rows.Count == 0) { Response.Write(ljd.function.LocalHint("材積重超出寄送限制,請調整訂單內容", "adminorder.aspx?uid=" + uid)); Response.End(); } } } //////檢查物流方式 if (data_cart.Items.Count == 0) { Response.Write(ljd.function.LocalHint("購物車為空,請選購商品!", "adminorder.aspx?uid=" + uid)); Response.End(); return; } yun = TWRequest.GetFormInt("yun"); //券 quan = TWRequest.GetFormString("txt_quan"); if (!string.IsNullOrEmpty(quan) && cbquan == "1") { Tea.Model.quan modelquan = new Tea.BLL.quan().GetModel(quan); if (modelquan != null) { if (modelquan.quan_show > 0 || int.Parse(modelquan.quan_end_date.Value.ToString("yyyyMMdd")) < int.Parse(System.DateTime.Now.ToString("yyyyMMdd"))) { Response.Write(ljd.function.LocalHint("優惠券無效", "adminorder.aspx?uid=" + uid)); Response.End(); } fee = modelquan.quan_num.Value; } else { Response.Write(ljd.function.LocalHint("優惠券無效", "adminorder.aspx?uid=" + uid)); Response.End(); } } //紅利 //hong = TWRequest.GetFormInt("cb_point"); //int txt_point = TWRequest.GetFormInt("txt_point"); //if (hong > 0 && txt_point > 0) //{ // int zuida = Utils.StrToInt((cartModel.real_amount * uconfig.pint_yong / 100).ToString(), 0); // if (cartModel.real_amount < uconfig.pint_mane && userModel.point > zuida) // { // Response.Write(ljd.function.LocalHint("紅利超出限制!", "adminorder.aspx?uid="+uid)); // return; // } // else // { // back = Utils.StrToInt((userModel.point / uconfig.pint_money).ToString(), 0); // } //} payment_id = TWRequest.GetFormInt("txt_pay"); //獲得傳參信息 string accept_name = Utils.ToHtml(TWRequest.GetFormString("txt_name")); string post_code = Utils.ToHtml(TWRequest.GetFormString("txt_zip")); string mobile = Utils.ToHtml(TWRequest.GetFormString("txt_mobile")); string address = Utils.ToHtml(TWRequest.GetFormString("txt_address")); string email = Utils.ToHtml(TWRequest.GetFormString("txt_email")); string guo = Utils.ToHtml(TWRequest.GetFormString("txt_guo").Trim()); string selcity = Utils.ToHtml(TWRequest.GetFormString("txt_state")); string selarea = Utils.ToHtml(TWRequest.GetFormString("txt_city")); string selcity1 = Utils.ToHtml(TWRequest.GetFormString("txt_state1")); string selarea1 = Utils.ToHtml(TWRequest.GetFormString("txt_city1")); string telphone = Utils.ToHtml(TWRequest.GetFormString("txt_tel")); //獲取訂單配置資料 Tea.Model.orderconfig orderConfig = new Tea.BLL.orderconfig().loadConfig(); //檢查付款方式 if (payment_id == 0) { Response.Write(ljd.function.LocalHint("對不起,請選擇付款方式!", "")); Response.End(); return; } Tea.Model.payment payModel = new Tea.BLL.payment().GetModel(payment_id); if (payModel == null) { Response.Write(ljd.function.LocalHint("對不起,付款方式不存在或已刪除!", "")); Response.End(); return; } //檢查收貨人 if (string.IsNullOrEmpty(accept_name)) { Response.Write(ljd.function.LocalHint("對不起,請輸入收貨人姓名!", "")); Response.End(); return; } //檢查手機和電話 if (string.IsNullOrEmpty(telphone) && string.IsNullOrEmpty(mobile)) { Response.Write(ljd.function.LocalHint("對不起,請輸入收貨人聯絡電話或手機!", "")); Response.End(); return; } if (string.IsNullOrEmpty(selarea) && string.IsNullOrEmpty(selarea1)) { Response.Write(ljd.function.LocalHint("對不起,請選擇收貨區域!", "")); Response.End(); return; } //檢查地址 if (string.IsNullOrEmpty(address) && string.IsNullOrEmpty(address)) { Response.Write(ljd.function.LocalHint("對不起,請輸入詳細的收貨地址!", "")); Response.End(); return; } ////檢查郵箱 if (string.IsNullOrEmpty(email)) { Response.Write(ljd.function.LocalHint("對不起,請輸入郵箱!", "")); Response.End(); return; } //如果開啟暱名購物則不檢查會員是否登入 int user_id = 0; int user_group_id = 0; string user_name = string.Empty; //檢查用戶是否登入 if (userModel != null) { user_id = userModel.id; user_group_id = userModel.group_id; user_name = userModel.user_name; } if (orderConfig.maned == 0 && userModel == null) { Response.Write(ljd.function.LocalHint("對不起,用戶尚未登入或已超時!", "")); Response.End(); return; } //檢查購物車商品 IList <Tea.Model.cart_items> iList = Tea.Web.UI.AdminCart.GetList(-3, uid); if (iList == null) { Response.Write(ljd.function.LocalHint("對不起,購物車為空,無法結帳!", "")); Response.End(); return; } //統計購物車 //儲存訂單======================================================================= Tea.Model.orders model = new Tea.Model.orders(); model.order_no = "M" + Utils.GetOrderNumber(); //訂單號B開頭為商品訂單 model.user_id = user_id; model.user_name = user_name; model.payment_id = 0; model.express_id = express_id; model.accept_name = accept_name; model.post_code = post_code; model.telphone = telphone; model.mobile = mobile; model.email = email; if (guo == "台灣") { model.area = guo + "," + selcity + "," + selarea; } else { model.area = guo + "," + selcity1 + "," + selarea1; } model.address = address; model.payable_amount = cartModel.payable_amount; model.real_amount = cartModel.real_amount; model.express_status = 1; model.express_fee = yun; //物流費用 model.payment_id = payment_id; model.message = TWRequest.GetFormString("txtcontent"); if (TWRequest.GetFormString("txtguo") == "台灣") { model.user_add = TWRequest.GetFormString("txtname") + "|" + TWRequest.GetFormString("txtsex") + "|" + TWRequest.GetFormString("txtmobile") + "|" + TWRequest.GetFormString("txttel") + "|" + TWRequest.GetFormString("txtemail") + "|" + TWRequest.GetFormString("txtguo") + "|" + TWRequest.GetFormString("txtstate") + "|" + TWRequest.GetFormString("txtcity") + "|" + TWRequest.GetFormString("txtaddress") + "|" + TWRequest.GetFormString("txtzip"); } else { model.user_add = TWRequest.GetFormString("txtname") + "|" + TWRequest.GetFormString("txtsex") + "|" + TWRequest.GetFormString("txtmobile") + "|" + TWRequest.GetFormString("txttel") + "|" + TWRequest.GetFormString("txtemail") + "|" + TWRequest.GetFormString("txtguo") + "|" + TWRequest.GetFormString("txtstate1") + "|" + TWRequest.GetFormString("txtcity1") + "|" + TWRequest.GetFormString("txtaddress") + "|" + TWRequest.GetFormString("txtzip"); } model.point = -cartModel.total_point; model.is_invoice = TWRequest.GetFormInt("txtinvoice"); if (model.is_invoice == 1) { model.invoice_title = TWRequest.GetFormString("txt_invoice1"); } if (model.is_invoice == 2) { model.invoice_title = TWRequest.GetFormString("txt_invoice2"); } if (model.is_invoice == 3) { if (TWRequest.GetFormString("txtfaaddress_guo") == "台灣") { model.invoice_title = TWRequest.GetFormString("txt_invoice3") + "," + TWRequest.GetFormString("txtfaaddress") + "," + TWRequest.GetFormString("txtfaaddress_guo") + "," + TWRequest.GetFormString("txtfaaddress_state") + "," + TWRequest.GetFormString("txtfaaddress_city") + "," + TWRequest.GetFormString("txtfaaddress_zip") + "," + TWRequest.GetFormString("txtfa_address"); } else { model.invoice_title = TWRequest.GetFormString("txt_invoice3") + "," + TWRequest.GetFormString("txtfaaddress") + "," + TWRequest.GetFormString("txtfaaddress_guo") + "," + TWRequest.GetFormString("txtfaaddress_state1") + "," + TWRequest.GetFormString("txtfaaddress_city1") + "," + TWRequest.GetFormString("txtfaaddress_zip") + "," + TWRequest.GetFormString("txtfa_address"); } } if (model.is_invoice == 4) { if (TWRequest.GetFormString("txt_invoiceaddress_guo") == "台灣") { model.invoice_title = TWRequest.GetFormString("txt_invoice_4") + "," + TWRequest.GetFormString("txt_invoiceaddress") + "," + TWRequest.GetFormString("txt_invoiceaddress_guo") + "," + TWRequest.GetFormString("txt_invoiceaddress_state") + "," + TWRequest.GetFormString("txt_invoiceaddress_city") + "," + TWRequest.GetFormString("txt_invoiceaddress_zip") + "," + TWRequest.GetFormString("txt_invoice_address"); } else { model.invoice_title = TWRequest.GetFormString("txt_invoice_4") + "," + TWRequest.GetFormString("txt_invoiceaddress") + "," + TWRequest.GetFormString("txt_invoiceaddress_guo") + "," + TWRequest.GetFormString("txt_invoiceaddress_state1") + "," + TWRequest.GetFormString("txt_invoiceaddress_city1") + "," + TWRequest.GetFormString("txt_invoiceaddress_zip") + "," + TWRequest.GetFormString("txt_invoice_address"); } } if (!string.IsNullOrEmpty(quan)) { Tea.Model.quan modelquan1 = new Tea.BLL.quan().GetModel(quan); if (modelquan1 != null) { model.zhe_code = modelquan1.quan_code; } } //model.zhe_else = cartModel.sales_str; // model.point = -cartModel.total_point;//紅利兌換 //model.express_fee = yun;//運費 //model.payment_fee = -fee;//優惠券 //model.tuid = -back;//紅利折扣 //model.zhe = -cartModel.total_moneyback; //折價金額 model.num = 0;// Utils.StrToInt((cartModel.real_amount / uconfig.money_pint).ToString("0."), 0); //獲得紅利 //訂單總金額=實付商品金額+運費+支付手續費-回饋金 if (model.order_amount < 0) { model.order_amount = 0; } model.add_time = DateTime.Now; //商品詳細列表 List <Tea.Model.order_goods> gls = new List <Tea.Model.order_goods>(); foreach (Tea.Model.cart_items item in iList) { gls.Add(new Tea.Model.order_goods { article_id = item.id, goods_title = item.title, goods_price = item.price, real_price = item.user_price, quantity = item.quantity, point = item.point, goods_where = item.by, goods_code = item.goods_code, goods_no = item.goods_code, goods_img = item.img_url, spec_text = item.goods_color, img_url = item.img_url, goodsid = item.goodsid }); } model.order_goods = gls; model.order_amount = model.real_amount + model.express_fee + model.payment_fee + model.tuid + model.zhe; model.order_pay_code = model.order_no + Utils.Number(4); int result = new Tea.BLL.orders().Add(model); if (result < 1) { Response.Write(ljd.function.LocalHint("訂單儲存過程中發生錯誤,請重新送出!", "")); Response.End(); return; } try { string mailTitle = "待付款訂單通知信", mailContent = ""; string url = weburl + "mail/payorder.aspx?id=" + result, ss = ""; mailContent = ljd.function.GetPage(url, out ss); //發送郵件 TWMail.sendMail(siteConfig.emailsmtp, siteConfig.emailssl, siteConfig.emailport, siteConfig.emailusername, siteConfig.emailpassword, siteConfig.emailnickname, siteConfig.emailfrom, model.email, mailTitle, mailContent); } catch (Exception eee) { } //if (email != TWRequest.GetFormString("txtemail")) //{ // try // { // string mailTitle = "待付款訂單通知信", mailContent = ""; // string url = weburl + "mail/payorder.aspx?id=" + result, ss = ""; // mailContent = ljd.function.GetPage(url, out ss); // //發送郵件 // TWMail.sendMail(siteConfig.emailsmtp, siteConfig.emailssl, siteConfig.emailport, siteConfig.emailusername, siteConfig.emailpassword, siteConfig.emailnickname, siteConfig.emailfrom,TWRequest.GetFormString("txtemail"), mailTitle, mailContent); // } // catch (Exception eee) { } //} //扣除紅利 if (model.point < 0) { new Tea.BLL.user_point_log().Add(model.user_id, model.user_name, model.point, "紅利兌換商品:" + model.order_no, false, 0, 0); } //if (!string.IsNullOrEmpty(quan)) //{ // Tea.Model.quan modelquan = new Tea.BLL.quan().GetModel(quan); // if (modelquan != null) // { // modelquan.quan_lock = 1; // modelquan.quan_date = System.DateTime.Now; // new Tea.BLL.quan().Update(modelquan); // } //} //userModel.point = userModel.point + model.point; //new Tea.BLL.users().Update(userModel); //清空購物車 Tea.Web.UI.AdminCart.ClearShop(cart, uid); // Tea.Web.UI.AdminCart.Clear("0"); //送出成功,返回URL if (model.payment_id != 1) { Response.Write(ljd.function.LocalHint("訂單已成功送出!", "/admin/index.aspx")); Response.End(); return; } else { Response.Write(ljd.function.LocalHint("訂單已成功送出!", "/admin/index.aspx")); Response.End(); return; } } }
protected void Page_Load(object sender, EventArgs e) { _users = new Tea.Web.UI.ShopPage().GetUserInfo(); key = TWRequest.GetQueryString("key"); this.page = TWRequest.GetQueryInt("page", 1); this.tid = TWRequest.GetQueryInt("tid", 0); this.hid = TWRequest.GetQueryInt("hid", 0); this.sort = TWRequest.GetQueryInt("sort", 0); if (sort == 1) { _orderby = "add_time desc,id desc"; } if (sort == 2) { _orderby = "click desc"; } if (sort == 3) { _orderby = "market_price,id"; } if (sort == 4) { _orderby = "market_price desc,id"; } if (tid != 0) { _sql = _sql + " and (category_id=" + tid + " or more_type like'%," + tid + ",%')"; tname = new Tea.BLL.article_category().GetTitle(tid); } if (!string.IsNullOrEmpty(key)) { _sql = _sql + " and (title like'%" + key + "%' or sub_title like'%" + key + "%')"; sqlkey = sqlkey + " and (title like'%" + key + "%' or sub_title like'%" + key + "%')"; tname = key; IList _list = new ArrayList(); DataSet ds = Tea.DBUtility.DbHelperSQL.Query("select category_id,more_type from view_article_product where " + sqlkey); foreach (DataRow dr in ds.Tables[0].Rows) { if (!_list.Contains(dr["category_id"].ToString())) { _list.Add(dr["category_id"].ToString()); } string more_type = dr["more_type"].ToString(); IList __list = more_type.Split(','); foreach (object ob in __list) { if (!_list.Contains(ob.ToString())) { _list.Add(ob.ToString()); } } } sql = "0"; foreach (object ob in _list) { if (!string.IsNullOrEmpty(ob.ToString())) { sql = sql + "," + ob.ToString(); } } } //Response.Write(sql); //Response.End(); if (!string.IsNullOrEmpty(sql)) { data_type.DataSource = Tea.DBUtility.DbHelperSQL.Query("select * from shop_article_category where channel_id=7 and id in(" + sql + ") and call_index='1' order by sort_id desc"); data_type.DataBind(); } Tea.Web.UI.ShopPage bll_view = new Tea.Web.UI.ShopPage(); data_list.DataSource = bll_view.GetViewList("view_article_product", "", this.pageSize, this.page, _sql, _orderby, out this.totalCount); data_list.DataBind(); string pageUrl = Utils.CombUrlTxt("search.aspx", "tid={0}&key={1}&sort={2}&page={3}", tid.ToString(), key.ToString(), sort.ToString(), "__id__"); PageContent.InnerHtml = Utils.OutPageListWeb(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
protected void Page_Load(object sender, EventArgs e) { Tea.Model.users _users = GetUserInfo(); if (_users != null && _users.status == 0) { Response.Redirect("edituser.aspx"); } url = TWRequest.GetQueryString("url"); try { num = Convert.ToInt32(Session["LoginSun"]); } catch (Exception eee) { } try { strurl = Request.UrlReferrer.AbsoluteUri.ToString(); if (strurl.Contains("tea.") && !strurl.Contains("login.aspx") && !strurl.Contains("out.aspx") && !strurl.Contains("reg")) { Utils.WriteCookie("url", strurl); } } catch (Exception eee) { } if (url == "cart") { Utils.WriteCookie("url", "/shop/cart.aspx"); } act = TWRequest.GetFormString("act"); Tea.BLL.users bll = new Tea.BLL.users(); if (act == "act_login") { string remember = TWRequest.GetFormString("txt_code"); if (Session[TWKeys.SESSION_CODE] == null) { Response.Write(ljd.function.LocalHint("系統找不到驗證碼", "login.aspx")); return; } if (remember.ToLower() != Session[TWKeys.SESSION_CODE].ToString().ToLower()) { Response.Write(ljd.function.LocalHint("驗證碼輸入不正確", "login.aspx")); return; } string username = TWRequest.GetFormString("email"); string password = TWRequest.GetFormString("password"); //檢查用戶名密碼 if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { Response.Write(ljd.function.LocalHint("檢查用戶名密碼", "login.aspx")); return; } Tea.Model.users model = bll.GetModel(username, password, 1, 1, true); if (model == null) { Response.Write(ljd.function.LocalHint("檢查用戶名密碼", "login.aspx")); return; } else if (model.status == 2) //待審核 { Response.Write(ljd.function.LocalHint("此帳號因未同意隱私條款或其他因素,已被系統限制登入,若有需要重新啟用,請連絡網站管理人員。", "login.aspx")); return; } Session[TWKeys.SESSION_USER_INFO] = model; Session.Timeout = 45; //防止Session提前過期 Utils.WriteCookie(TWKeys.COOKIE_USER_NAME_REMEMBER, "Tea", model.user_name); Utils.WriteCookie(TWKeys.COOKIE_USER_PWD_REMEMBER, "Tea", model.password); //寫入登入日誌 new Tea.BLL.user_login_log().Add(model.id, model.user_name, "會員登入"); //返回URL //檢查用戶是否通過驗證 if (model.status == 1) //待驗證 { Response.Write(ljd.function.LocalHint("已發送帳號啟用信至您的電子信箱,請至信箱確認並啟用", "regno.aspx")); return; } //strurl = Utils.GetCookie("url"); //if (strurl.Contains("tea.") || strurl.Contains("cart.")) //{ // Response.Redirect(strurl); //} //else //{ // Response.Redirect("/users/index.aspx"); //} Tea.Model.cart_total cartModel = Tea.Web.UI.ShopCart.GetTotal(1); if (cartModel.total_quantity == 0) { Response.Redirect("/Default.aspx"); } else { Response.Redirect("/shop/cart.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { act = Request["act"]; Tea.BLL.users bll = new Tea.BLL.users(); data_guo.DataSource = Tea.DBUtility.DbHelperSQL.Query("select * from shop_basic where basic_where='city' order by basic_sort"); data_guo.DataBind(); if (act == "act_reg") { string remember = TWRequest.GetFormString("txt_code"); if (Session[TWKeys.SESSION_CODE] == null) { Response.Write(ljd.function.LocalHint("系統找不到驗證碼", "reg.aspx")); return; } if (remember.ToLower() != Session[TWKeys.SESSION_CODE].ToString().ToLower()) { Response.Write(ljd.function.LocalHint("驗證碼輸入不正確", "reg.aspx")); return; } string username = Utils.ToHtml(TWRequest.GetFormString("email").Trim()); string password = TWRequest.GetFormString("loginPwd").Trim(); string email = Utils.ToHtml(TWRequest.GetFormString("email").Trim()); string mobile = Utils.ToHtml(TWRequest.GetFormString("cellPhone").Trim()); string address = Utils.ToHtml(TWRequest.GetFormString("address").Trim()); string area = Utils.ToHtml(TWRequest.GetFormString("txt_state").Trim()); string city = Utils.ToHtml(TWRequest.GetFormString("txt_city").Trim()); string area1 = Utils.ToHtml(TWRequest.GetFormString("txt_state1").Trim()); string city1 = Utils.ToHtml(TWRequest.GetFormString("txt_city1").Trim()); string guo = Utils.ToHtml(TWRequest.GetFormString("txt_guo").Trim()); string sex = TWRequest.GetFormString("rblSex").Trim(); string birthday = TWRequest.GetFormString("birthdayY").Trim() + "-" + TWRequest.GetFormString("birthdayM").Trim() + "-" + TWRequest.GetFormString("birthdayD").Trim(); string nickname = TWRequest.GetFormString("userName").Trim(); int rss = TWRequest.GetFormInt("rss", 0); string userip = TWRequest.GetIP(); //檢查用戶輸入資料是否為空 if (username == "" || password == "") { Response.Write(ljd.function.LocalHint("用戶名和密碼不能為空!", "")); return; } //檢查用戶名 Tea.Model.users model = new Tea.Model.users(); if (new Tea.BLL.users().ExistsEmail(email)) { Response.Write(ljd.function.LocalHint("此帳號信箱已存在於此網站,請以新mail註冊", "")); Response.End(); return; } if (bll.Exists(username)) { Response.Write(ljd.function.LocalHint("對不起,該用戶名已經存在!", "")); Response.End(); return; } //儲存註冊資料 model.group_id = 1; model.user_name = username; model.salt = Utils.GetCheckCode(6); model.status = 1; model.password = DESEncrypt.Encrypt(password, model.salt); model.email = email; model.mobile = mobile; if (guo == "台灣") { model.area = guo + "," + area + "," + city; } else { model.area = guo + "," + area1 + "," + city1; } model.qq = TWRequest.GetFormString("txt_zip"); model.sex = sex; model.address = address; try { model.birthday = System.DateTime.Parse(birthday); } catch (Exception eee) { Response.Write(ljd.function.LocalHint("請輸入正確的日期!", "")); return; } if (TWRequest.GetFormInt("birthdayY") < 1900 || TWRequest.GetFormInt("birthdayY") > System.DateTime.Now.Year) { Response.Write(ljd.function.LocalHint("請輸入正確的日期!", "")); Response.End(); return; } model.nick_name = nickname; model.reg_ip = userip; model.reg_time = DateTime.Now; model.exp = rss; model.user_hei = 0; int newId = bll.Add(model); if (newId < 1) { Response.Write(ljd.function.LocalHint("系統故障,請聯絡網站管理員!", "")); return; } model = bll.GetModel(newId); try { string mailTitle = "驗證郵箱通知信", mailContent = ""; string url = weburl + "mail/reg.aspx?id=" + newId, ss = ""; mailContent = ljd.function.GetPage(url, out ss); //發送郵件 TWMail.sendMail(config.emailsmtp, config.emailssl, config.emailport, config.emailusername, config.emailpassword, config.emailnickname, config.emailfrom, model.email, mailTitle, mailContent); } catch (Exception eee) { } if (model != null) { Session[TWKeys.SESSION_USER_INFO] = model; Session.Timeout = 45; //防止Session提前過期 Utils.WriteCookie(TWKeys.COOKIE_USER_NAME_REMEMBER, "Tea", model.user_name); Utils.WriteCookie(TWKeys.COOKIE_USER_PWD_REMEMBER, "Tea", model.password); //寫入登入日誌 new Tea.BLL.user_login_log().Add(model.id, model.user_name, "會員登入"); Response.Write(ljd.function.LocalHint("已發送帳號啟用信至您的電子信箱,請至信箱確認並啟用。", "regno.aspx")); Response.End(); } } }