protected void btnCollection_Click(object sender, EventArgs e) { if (Session["name"] != null) { BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { Session["Uid"] = userdDT.Rows[0][1].ToString(); BuyerDSTableAdapters.CollectionTableAdapter collectDA = new BuyerDSTableAdapters.CollectionTableAdapter(); DataTable collectDT = collectDA.GetDateByUIDandShopId(System.Guid.Parse(Session["Uid"].ToString()), long.Parse(Session["ShopId"].ToString())); if (collectDT.Rows.Count != 0) { Response.Write("<Script>alert('您已收藏过该店铺!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('您已收藏过该店铺!');", true); } else { int insertDT = collectDA.InsertCollectedShop(System.Guid.Parse(Session["Uid"].ToString()), long.Parse(Session["ShopId"].ToString()), DateTime.Now, "shop"); if (insertDT != 0) { Response.Write("<Script>alert('成功加入收藏!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('成功加入收藏!');", true); } } } } else { Session["lasturl"] = Server.UrlDecode(Request.Url.AbsoluteUri.ToString()); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>openDiv('newDiv');</script>"); //Response.Write("<Script>alert('登录后才能加入购物车!')</Script>"); } }
protected void btnCollection_Click(object sender, EventArgs e) { if (Session["name"] != null) { BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { Session["Uid"] = userdDT.Rows[0][1].ToString(); BuyerDSTableAdapters.CollectionTableAdapter collectDA = new BuyerDSTableAdapters.CollectionTableAdapter(); DataTable collectDT = collectDA.GetDateByUIDandShopId(System.Guid.Parse(Session["Uid"].ToString()), long.Parse(Session["ShopId"].ToString())); if (collectDT.Rows.Count != 0) { Response.Write("<Script>alert('您已收藏过该店铺!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('您已收藏过该店铺!');", true); } else { int insertDT = collectDA.InsertCollectedShop(System.Guid.Parse(Session["Uid"].ToString()), long.Parse(Session["ShopId"].ToString()),DateTime.Now,"shop"); if (insertDT != 0) { Response.Write("<Script>alert('成功加入收藏!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('成功加入收藏!');", true); } } } } else { Session["lasturl"] = Server.UrlDecode(Request.Url.AbsoluteUri.ToString()); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>openDiv('newDiv');</script>"); //Response.Write("<Script>alert('登录后才能加入购物车!')</Script>"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtShopName.Text != "") { BuyerDSTableAdapters.aspnet_UsersTableAdapter uidDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable uidDT = uidDA.GetDataByUName(Session["name"].ToString()); if (uidDT.Rows.Count != 0) { BuyerDSTableAdapters.UsersExtendTableAdapter upDA = new BuyerDSTableAdapters.UsersExtendTableAdapter(); int upDT = upDA.UpdateSellerInfo(imgIdPhoto.ImageUrl, System.Guid.Parse(uidDT.Rows[0][1].ToString())); BuyerDSTableAdapters.UsersExtendTableAdapter infoDA = new BuyerDSTableAdapters.UsersExtendTableAdapter(); DataTable infoDT = infoDA.GetDataByUid(System.Guid.Parse(uidDT.Rows[0][1].ToString())); if (infoDT.Rows.Count != 0 && upDT != 0) { BuyerDSTableAdapters.ShopInfoTableAdapter shopDA = new BuyerDSTableAdapters.ShopInfoTableAdapter(); int shopDT = shopDA.InsertShop(txtShopName.Text, System.Guid.Parse(uidDT.Rows[0][1].ToString()), "", infoDT.Rows[0][2].ToString(), infoDT.Rows[0][3].ToString(), DateTime.Now, "1", imgLogo.ImageUrl); if (shopDT != 0) { //Response.Write("<Script>alert('已提交,等待审核!')</Script>"); ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('已提交,等待审核!');", true); } } } } else { // Response.Write("<Script>alert('!')</Script>"); ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('请先填写店铺名称!');", true); } }
protected void lbtnInChart1_Click(object sender, EventArgs e) { string phoneid = ((LinkButton)sender).CommandArgument.ToString(); if (Session["name"] != null) { BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); ShopCartTableAdapter shopcartDA = new ShopCartTableAdapter(); if (userdDT.Rows.Count > 0) { DataTable shopcartDT = shopcartDA.GetDataBySCidPid(System.Guid.Parse(userdDT.Rows[0][1].ToString()), long.Parse(phoneid)); if (shopcartDT.Rows.Count > 0) { Response.Redirect("~/Buyer/ShoppingCart.aspx"); } else { string ConnSql = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); string SelectSql = "SELECT * FROM V_PhoneDetailInfo WHERE phone_id =" + long.Parse(phoneid) + ""; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); string seller = ""; if (ds.Tables[0].Rows.Count > 0) { seller = ds.Tables[0].Rows[0]["sellerId"].ToString().Trim(); int DT = shopcartDA.AddShoppingCart(System.Guid.Parse(userdDT.Rows[0][1].ToString()), System.Guid.Parse(seller), long.Parse(phoneid), 1, int.Parse(ds.Tables[0].Rows[0]["price"].ToString().Trim()), DateTime.Now, "否"); if (DT > 0) { Response.Redirect("~/Buyer/ShoppingCart.aspx"); } else { Response.Write("<Script>alert('未能成功加入购物车!')</Script>"); } } } } else { Response.Write("<Script>alert('未能成功加入购物车!')</Script>"); } } else { Session["lasturl"] = Server.UrlDecode(Request.Url.AbsoluteUri.ToString()); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>openDiv('newDiv');</script>"); //Response.Write("<Script>alert('登录后才能加入购物车!')</Script>"); } }
protected void lbtnInChart2_Click(object sender, EventArgs e) { string phoneid = ((LinkButton)sender).CommandArgument.ToString(); if (Session["name"] != null) { BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); ShopCartTableAdapter shopcartDA = new ShopCartTableAdapter(); if (userdDT.Rows.Count > 0) { DataTable shopcartDT = shopcartDA.GetDataBySCidPid(System.Guid.Parse(userdDT.Rows[0][1].ToString()), long.Parse(phoneid)); if (shopcartDT.Rows.Count > 0) { Response.Redirect("~/Buyer/ShoppingCart.aspx"); } else { string ConnSql = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); string SelectSql = "SELECT * FROM V_PhoneDetailInfo WHERE phone_id =" + long.Parse(phoneid) + ""; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); string seller = ""; if (ds.Tables[0].Rows.Count > 0) { seller = ds.Tables[0].Rows[0]["sellerId"].ToString().Trim(); int DT = shopcartDA.AddShoppingCart(System.Guid.Parse(userdDT.Rows[0][1].ToString()), System.Guid.Parse(seller), long.Parse(phoneid), 1, int.Parse(ds.Tables[0].Rows[0]["price"].ToString().Trim()), DateTime.Now, "否"); if (DT > 0) { Response.Redirect("~/Buyer/ShoppingCart.aspx"); } else { Response.Write("<Script>alert('未能成功加入购物车!')</Script>"); } } } } else { Response.Write("<Script>alert('未能成功加入购物车!')</Script>"); } } else { Session["lasturl"] = Server.UrlDecode(Request.Url.AbsoluteUri.ToString()); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>openDiv('newDiv');</script>"); //Response.Write("<Script>alert('登录后才能加入购物车!')</Script>"); } }
protected void ibtnCollect_Click(object sender, ImageClickEventArgs e) { if (Session["name"] != null) { string phoneid = Request.QueryString["PhoneId"].ToString(); BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); CollectionTableAdapter collect = new CollectionTableAdapter(); string buyer = ""; if (userdDT.Rows.Count > 0) { buyer = userdDT.Rows[0][1].ToString(); DataTable collectDT = collect.GetDataByUidPid(System.Guid.Parse(buyer), long.Parse(phoneid)); if (collectDT.Rows.Count > 0) { Response.Write("<Script>alert('您已收藏过此商品!')</Script>"); } else { string ConnSql = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); string SelectSql = "SELECT * FROM V_PhoneDetailInfo WHERE phone_id =" + long.Parse(phoneid) + ""; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); string shopid = ""; if (ds.Tables[0].Rows.Count > 0) { shopid = ds.Tables[0].Rows[0]["shopId"].ToString().Trim(); } int DT = collect.AddCollect(System.Guid.Parse(buyer), long.Parse(phoneid), long.Parse(shopid), DateTime.Now, "phone"); if (DT > 0) { Response.Write("<Script>alert('收藏成功!')</Script>"); } } } } else { Response.Write("<Script>alert('登陆后才能收藏!')</Script>"); } }
protected void Page_Load(object sender, EventArgs e) { lblCode.Visible = false; lblRevName.Visible = false; lblTelPhone.Visible = false; lblStreet.Visible = false; txtStreet.Visible = false; txtRevName.Visible = false; txtCode.Visible = false; txtTelPhone.Visible = false; btnAddress.Visible = false; btnCancel.Visible = false; Session["State"] = "是"; if (Session["name"] != null) { BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { Session["BuyerId"] = System.Guid.Parse(userdDT.Rows[0][1].ToString()); BuyerDSTableAdapters.UsersExtendTableAdapter addrDA = new BuyerDSTableAdapters.UsersExtendTableAdapter(); DataTable addrDT = addrDA.GetDataByUid(System.Guid.Parse(userdDT.Rows[0][1].ToString())); if (addrDT.Rows.Count != 0) { lblAddr.Text = addrDT.Rows[0][3].ToString() + "" + "(" + addrDT.Rows[0][1].ToString() + " 收) " + addrDT.Rows[0][2].ToString(); lblRevAddr.Text = addrDT.Rows[0][3].ToString() + " "; lblRevInfo.Text = addrDT.Rows[0][1].ToString() + " " + addrDT.Rows[0][2].ToString() + " "; Session["Addr"] = addrDT.Rows[0][3].ToString(); Session["RevName"] = addrDT.Rows[0][1].ToString(); Session["TelPhone"] = addrDT.Rows[0][2].ToString(); } Show(); } } else { Response.Write("<Script>alert('提示:登录后才能提交订单!')</Script>"); Response.Redirect("~/Public/Index.aspx"); } btnAddress.Attributes.Add("onclick", "return confirm('确定要修改吗?');"); }
private void BindDatalist(int currentpage) { pds.AllowPaging = true; pds.PageSize = 3; pds.CurrentPageIndex = currentpage; BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { Session["Uid"] = userdDT.Rows[0][1].ToString(); BuyerDSTableAdapters.View_Collection_ShopTableAdapter csDA = new BuyerDSTableAdapters.View_Collection_ShopTableAdapter(); DataTable csDT = csDA.GetDataByUid(System.Guid.Parse(userdDT.Rows[0][1].ToString()), "shop"); if (csDT.Rows.Count > 0) { cbAll.Visible = true; cbAll.Enabled = true; imgbtnDelete.Visible = true; imgbtnDelete.Enabled = true; Panel1.Visible = false; pds.DataSource = csDT.DefaultView; dlShop.DataSource = pds; dlShop.DataBind(); } else { cbAll.Visible = false; cbAll.Enabled = false; imgbtnDelete.Visible = false; imgbtnDelete.Enabled = false; Panel1.Visible = true; //Response.Write("<Script>alert('您未收藏任何店铺!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('您未收藏任何店铺!');", true); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["name"] != null) { imgTubiao.Visible = false; lblShowMassage.Visible = false; BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { Session["buyerID"] = userdDT.Rows[0][1].ToString(); } SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); string SelectSql = "select * from View1 where goodsbuyer = '" +System.Guid.Parse( Session["buyerID"].ToString()) + "' order by orderId desc"; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); gvOrderInfo.DataSource = ds.Tables[0]; gvOrderInfo.DataBind(); int waitpay = 0, waitConfirm = 0; if (gvOrderInfo.Rows.Count > 0) { int i ; for (i = 0;i< gvOrderInfo.Rows.Count ; i++) { CheckBox chbSelect = (CheckBox)gvOrderInfo.Rows[i].FindControl("chbSelect"); Label lblPrice = (Label)gvOrderInfo.Rows[i].FindControl("lblPrice"); Label lblQuantity = (Label)gvOrderInfo.Rows[i].FindControl("lblQuantity"); Label lblTotalPrice = (Label)gvOrderInfo.Rows[i].FindControl("lblTotalPrice"); int price = int.Parse(lblPrice.Text); int quantity = int.Parse(lblQuantity.Text); lblTotalPrice.Text = (price * quantity).ToString(); Label lblOrderID = (Label)gvOrderInfo.Rows[i].FindControl("lblOrderID"); Label lblOrderState = (Label)gvOrderInfo.Rows[i].FindControl("lblOrderState"); LinkButton lbtnPay = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnPay"); LinkButton lbtnCancel = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnCancel"); LinkButton lbtnConfirm = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnConfirm"); LinkButton lbtnAddEvaluation = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnAddEvaluation"); Label lblEvaluated = (Label)gvOrderInfo.Rows[i].FindControl("lblEvaluated"); LinkButton lbtnGoToEvaluate = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnGoToEvaluate"); //lbtnAddEvaluation if (lblOrderState.Text == "待付款") { waitpay++; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "买家已付款") { waitConfirm++; lbtnPay.Enabled = false; lbtnPay.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; } else { if (lblOrderState.Text == "卖家已发货") { waitConfirm++; lbtnPay.Enabled = false; lbtnPay.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; } else { if (lblOrderState.Text == "交易成功") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; EstimateInfoTableAdapter estimateDA = new EstimateInfoTableAdapter(); DataTable estimateDT = estimateDA.GetEvaluationByOrderId(long.Parse(lblOrderID.Text)); if (estimateDT.Rows.Count > 0) { lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; } } else { if (lblOrderState.Text == "退款中的订单") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "交易关闭") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } } } } } } //Session["orderID"] = lblOrderID.Text; } } else { imgTubiao.Visible = true; lblShowMassage.Visible = true; lblShowMassage.Text = "没有找到相关订单"; } lbtnWaitPay.Text = "待付款(" + waitpay.ToString() + ")"; lbtnWaitConfirm.Text = "待确认收货(" + waitConfirm.ToString() + ")"; Conn.Close(); } else { Response.Redirect("~/Public/Index.aspx"); } if (!IsPostBack) { BindDatalist(0); } }
public void gridviewBind() { string id = ""; BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { id = userdDT.Rows[0][1].ToString(); } SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); Guid guid = new Guid(id); string SelectSql = "select * from View1 where goodsbuyer = '" + guid + "' order by orderId desc"; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); gvOrderInfo.DataSource = ds.Tables[0]; gvOrderInfo.DataBind(); //int waitpay = 0, waitConfirm = 0; if (gvOrderInfo.Rows.Count > 0) { int i; for (i = 0; i < gvOrderInfo.Rows.Count; i++) { CheckBox chbSelect = (CheckBox)gvOrderInfo.Rows[i].FindControl("chbSelect"); Label lblPrice = (Label)gvOrderInfo.Rows[i].FindControl("lblPrice"); Label lblQuantity = (Label)gvOrderInfo.Rows[i].FindControl("lblQuantity"); Label lblTotalPrice = (Label)gvOrderInfo.Rows[i].FindControl("lblTotalPrice"); int price = int.Parse(lblPrice.Text); int quantity = int.Parse(lblQuantity.Text); lblTotalPrice.Text = (price * quantity).ToString(); Label lblOrderID = (Label)gvOrderInfo.Rows[i].FindControl("lblOrderID"); Label lblOrderState = (Label)gvOrderInfo.Rows[i].FindControl("lblOrderState"); LinkButton lbtnPay = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnPay"); LinkButton lbtnCancel = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnCancel"); LinkButton lbtnConfirm = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnConfirm"); LinkButton lbtnAddEvaluation = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnAddEvaluation"); Label lblEvaluated = (Label)gvOrderInfo.Rows[i].FindControl("lblEvaluated"); LinkButton lbtnGoToEvaluate = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnGoToEvaluate"); if (lblOrderState.Text == "待付款") { lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "买家已付款") { lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; lbtnPay.Enabled = false; lbtnPay.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "卖家已发货") { lbtnPay.Enabled = false; lbtnPay.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; } else { if (lblOrderState.Text == "交易成功") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; EstimateInfoTableAdapter estimateDA = new EstimateInfoTableAdapter(); DataTable estimateDT = estimateDA.GetEvaluationByOrderId(long.Parse(lblOrderID.Text)); if (estimateDT.Rows.Count > 0) { lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; } } else { if (lblOrderState.Text == "退款中的订单") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "交易关闭") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } } } } } } } } else { imgTubiao.Visible = true; lblShowMassage.Visible = true; lblShowMassage.Text = "没有找到相关订单"; } Conn.Close(); }
protected void Page_Load(object sender, EventArgs e) { lblCode.Visible = false; lblRevName.Visible = false; lblTelPhone.Visible = false; lblStreet.Visible = false; txtStreet.Visible = false; txtRevName.Visible = false; txtCode.Visible = false; txtTelPhone.Visible = false; btnAddress.Visible = false; btnCancel.Visible = false; Session["State"] = "是"; if (Session["name"] != null) { BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { Session["BuyerId"] = System.Guid.Parse(userdDT.Rows[0][1].ToString()); BuyerDSTableAdapters.UsersExtendTableAdapter addrDA = new BuyerDSTableAdapters.UsersExtendTableAdapter(); DataTable addrDT = addrDA.GetDataByUid(System.Guid.Parse(userdDT.Rows[0][1].ToString())); if (addrDT.Rows.Count != 0) { lblAddr.Text = addrDT.Rows[0][3].ToString() + "" + "(" + addrDT.Rows[0][1].ToString() + " 收) " + addrDT.Rows[0][2].ToString(); lblRevAddr.Text = addrDT.Rows[0][3].ToString() + " "; lblRevInfo.Text = addrDT.Rows[0][1].ToString() + " " + addrDT.Rows[0][2].ToString() + " "; Session["Addr"] = addrDT.Rows[0][3].ToString(); Session["RevName"] = addrDT.Rows[0][1].ToString(); Session["TelPhone"] = addrDT.Rows[0][2].ToString(); } Show(); } } else { Response.Write("<Script>alert('提示:登录后才能提交订单!')</Script>"); Response.Redirect("~/Public/Index.aspx"); } btnAddress.Attributes.Add("onclick", "return confirm('确定要修改吗?');"); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (txtShopName.Text != "") { BuyerDSTableAdapters.aspnet_UsersTableAdapter uidDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable uidDT = uidDA.GetDataByUName(Session["name"].ToString()); if (uidDT.Rows.Count != 0) { BuyerDSTableAdapters.UsersExtendTableAdapter upDA = new BuyerDSTableAdapters.UsersExtendTableAdapter(); int upDT = upDA.UpdateSellerInfo(imgIdPhoto.ImageUrl, System.Guid.Parse(uidDT.Rows[0][1].ToString())); BuyerDSTableAdapters.UsersExtendTableAdapter infoDA = new BuyerDSTableAdapters.UsersExtendTableAdapter(); DataTable infoDT = infoDA.GetDataByUid(System.Guid.Parse(uidDT.Rows[0][1].ToString())); if (infoDT.Rows.Count != 0 && upDT != 0) { BuyerDSTableAdapters.ShopInfoTableAdapter shopDA = new BuyerDSTableAdapters.ShopInfoTableAdapter(); int shopDT = shopDA.InsertShop(txtShopName.Text, System.Guid.Parse(uidDT.Rows[0][1].ToString()), "", infoDT.Rows[0][2].ToString(), infoDT.Rows[0][3].ToString(), DateTime.Now, "1", imgLogo.ImageUrl); if (shopDT != 0) { //Response.Write("<Script>alert('已提交,等待审核!')</Script>"); ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('已提交,等待审核!');", true); } } } } else { // Response.Write("<Script>alert('!')</Script>"); ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('请先填写店铺名称!');", true); } }
protected void Page_Load(object sender, EventArgs e) { lblSelected.Text = "0"; if (Session["name"] != null) { string id = ""; BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { id = userdDT.Rows[0][1].ToString(); Session["buyerID"] = System.Guid.Parse(id); V_ShopCartTableAdapter shop = new V_ShopCartTableAdapter(); ShopCartTableAdapter shopcart = new ShopCartTableAdapter(); DataTable shopDT = shop.GetShopCartInfoByBuyer(System.Guid.Parse(Session["buyerID"].ToString())); if (shopDT.Rows.Count > 0) { for (int i = 0; i < shopDT.Rows.Count; i++) { if (int.Parse(shopDT.Rows[i]["store_quantity"].ToString()) == 0) { shopcart.DeleteShoppingCart(long.Parse(shopDT.Rows[0][0].ToString())); } else { if (int.Parse(shopDT.Rows[i]["buy_quantity"].ToString()) > int.Parse(shopDT.Rows[i]["store_quantity"].ToString())) { shopcart.UpdateCartPhoneQuantity(int.Parse(shopDT.Rows[i]["store_quantity"].ToString()), int.Parse(shopDT.Rows[i]["price"].ToString()) * int.Parse(shopDT.Rows[i]["store_quantity"].ToString()), long.Parse(shopDT.Rows[0][0].ToString())); } } } } } int number = 0; if (dlCartShop.Items.Count > 0) { for (int i = 0; i < dlCartShop.Items.Count; i++) { DataList dlCartPhone = dlCartShop.Items[i].FindControl("dlCartPhone") as DataList; for (int j = 0; j < dlCartPhone.Items.Count; j++) { TextBox txtQuantity = dlCartPhone.Items[j].FindControl("txtQuantity") as TextBox; number += int.Parse(txtQuantity.Text); } } lblMsg.Visible = false; lblMsg.Enabled = false; lbtnGo.Enabled = false; lbtnGo.Visible = false; Panel2.Visible = true; Panel1.Visible = true; Panel3.Visible = true; lblTotalNumber.Text = number.ToString(); lbtnSettlement.Enabled = false; } else { lblTotalNumber.Text = "0"; lblMsg.Visible = true; lbtnGo.Enabled = true; lbtnGo.Visible = true; Panel1.Visible = false; lbtnSettlement.Enabled = false; Panel2.Visible = false; Panel3.Visible = false; } } else { Response.Redirect("~/Public/Index.aspx"); } }
private void BindDatalist(int currentpage) { pds.AllowPaging = true; pds.PageSize = 3; pds.CurrentPageIndex = currentpage; BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { Session["Uid"] = userdDT.Rows[0][1].ToString(); BuyerDSTableAdapters.View_Collection_ShopTableAdapter csDA = new BuyerDSTableAdapters.View_Collection_ShopTableAdapter(); DataTable csDT = csDA.GetDataByUid(System.Guid.Parse(userdDT.Rows[0][1].ToString()),"shop"); if (csDT.Rows.Count > 0) { cbAll.Visible = true; cbAll.Enabled = true; imgbtnDelete.Visible = true; imgbtnDelete.Enabled = true; Panel1.Visible = false; pds.DataSource = csDT.DefaultView; dlShop.DataSource = pds; dlShop.DataBind(); } else { cbAll.Visible = false; cbAll.Enabled = false; imgbtnDelete.Visible = false; imgbtnDelete.Enabled = false; Panel1.Visible = true; //Response.Write("<Script>alert('您未收藏任何店铺!')</Script>"); //ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('您未收藏任何店铺!');", true); } } }
protected void Page_Load(object sender, EventArgs e) { lblSelected.Text = "0"; if (Session["name"] != null) { string id = ""; BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { id = userdDT.Rows[0][1].ToString(); Session["buyerID"] = System.Guid.Parse(id); V_ShopCartTableAdapter shop = new V_ShopCartTableAdapter(); ShopCartTableAdapter shopcart = new ShopCartTableAdapter(); DataTable shopDT = shop.GetShopCartInfoByBuyer(System.Guid.Parse(Session["buyerID"].ToString())); if (shopDT.Rows.Count > 0) { for (int i = 0; i < shopDT.Rows.Count; i++) { if (int.Parse(shopDT.Rows[i]["store_quantity"].ToString()) == 0) { shopcart.DeleteShoppingCart(long.Parse(shopDT.Rows[0][0].ToString())); } else { if (int.Parse(shopDT.Rows[i]["buy_quantity"].ToString()) > int.Parse(shopDT.Rows[i]["store_quantity"].ToString())) { shopcart.UpdateCartPhoneQuantity(int.Parse(shopDT.Rows[i]["store_quantity"].ToString()), int.Parse(shopDT.Rows[i]["price"].ToString()) * int.Parse(shopDT.Rows[i]["store_quantity"].ToString()), long.Parse(shopDT.Rows[0][0].ToString())); } } } } } int number = 0; if (dlCartShop.Items.Count > 0) { for (int i = 0; i < dlCartShop.Items.Count; i++) { DataList dlCartPhone = dlCartShop.Items[i].FindControl("dlCartPhone") as DataList; for (int j = 0; j < dlCartPhone.Items.Count; j++) { TextBox txtQuantity = dlCartPhone.Items[j].FindControl("txtQuantity") as TextBox; number += int.Parse(txtQuantity.Text); } } lblMsg.Visible = false; lblMsg.Enabled = false; lbtnGo.Enabled = false; lbtnGo.Visible = false; Panel2.Visible = true; Panel1.Visible = true; Panel3.Visible = true; lblTotalNumber.Text = number.ToString(); lbtnSettlement.Enabled = false; } else { lblTotalNumber.Text = "0"; lblMsg.Visible = true; lbtnGo.Enabled = true; lbtnGo.Visible = true; Panel1.Visible = false; lbtnSettlement.Enabled = false; Panel2.Visible = false; Panel3.Visible = false; } } else { Response.Redirect("~/Public/Index.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["name"] != null) { imgTubiao.Visible = false; lblShowMassage.Visible = false; BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { Session["buyerID"] = userdDT.Rows[0][1].ToString(); } SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); string SelectSql = "select * from View1 where goodsbuyer = '" + System.Guid.Parse(Session["buyerID"].ToString()) + "' order by orderId desc"; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); gvOrderInfo.DataSource = ds.Tables[0]; gvOrderInfo.DataBind(); int waitpay = 0, waitConfirm = 0; if (gvOrderInfo.Rows.Count > 0) { int i; for (i = 0; i < gvOrderInfo.Rows.Count; i++) { CheckBox chbSelect = (CheckBox)gvOrderInfo.Rows[i].FindControl("chbSelect"); Label lblPrice = (Label)gvOrderInfo.Rows[i].FindControl("lblPrice"); Label lblQuantity = (Label)gvOrderInfo.Rows[i].FindControl("lblQuantity"); Label lblTotalPrice = (Label)gvOrderInfo.Rows[i].FindControl("lblTotalPrice"); int price = int.Parse(lblPrice.Text); int quantity = int.Parse(lblQuantity.Text); lblTotalPrice.Text = (price * quantity).ToString(); Label lblOrderID = (Label)gvOrderInfo.Rows[i].FindControl("lblOrderID"); Label lblOrderState = (Label)gvOrderInfo.Rows[i].FindControl("lblOrderState"); LinkButton lbtnPay = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnPay"); LinkButton lbtnCancel = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnCancel"); LinkButton lbtnConfirm = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnConfirm"); LinkButton lbtnAddEvaluation = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnAddEvaluation"); Label lblEvaluated = (Label)gvOrderInfo.Rows[i].FindControl("lblEvaluated"); LinkButton lbtnGoToEvaluate = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnGoToEvaluate"); //lbtnAddEvaluation if (lblOrderState.Text == "待付款") { waitpay++; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "买家已付款") { waitConfirm++; lbtnPay.Enabled = false; lbtnPay.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; } else { if (lblOrderState.Text == "卖家已发货") { waitConfirm++; lbtnPay.Enabled = false; lbtnPay.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; } else { if (lblOrderState.Text == "交易成功") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; EstimateInfoTableAdapter estimateDA = new EstimateInfoTableAdapter(); DataTable estimateDT = estimateDA.GetEvaluationByOrderId(long.Parse(lblOrderID.Text)); if (estimateDT.Rows.Count > 0) { lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; } } else { if (lblOrderState.Text == "退款中的订单") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "交易关闭") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } } } } } } //Session["orderID"] = lblOrderID.Text; } } else { imgTubiao.Visible = true; lblShowMassage.Visible = true; lblShowMassage.Text = "没有找到相关订单"; } lbtnWaitPay.Text = "待付款(" + waitpay.ToString() + ")"; lbtnWaitConfirm.Text = "待确认收货(" + waitConfirm.ToString() + ")"; Conn.Close(); } else { Response.Redirect("~/Public/Index.aspx"); } if (!IsPostBack) { BindDatalist(0); } }
protected void ibtnBuyNow_Click(object sender, ImageClickEventArgs e) { if (Session["name"] != null) { string phoneid = Request.QueryString["PhoneId"].ToString(); BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); string buyer = ""; ShopCartTableAdapter shopcartDA = new ShopCartTableAdapter(); if (userdDT.Rows.Count > 0) { buyer = userdDT.Rows[0][1].ToString(); DataTable shopcartDT = shopcartDA.GetDataBySCidPid(System.Guid.Parse(buyer), long.Parse(phoneid)); if (shopcartDT.Rows.Count > 0) { int Dt = shopcartDA.UpdateCartQuantity(int.Parse(txtNum.Text), int.Parse(lblAllPrice.Text), DateTime.Now, "是", long.Parse(shopcartDT.Rows[0][0].ToString())); if (Dt == 1) { Response.Redirect("~/Buyer/SubmitOrder.aspx"); } else { Response.Write("<Script>alert('未能成功结算!')</Script>"); } } else { string ConnSql = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); string SelectSql = "SELECT * FROM V_PhoneDetailInfo WHERE phone_id =" + long.Parse(phoneid) + ""; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); string seller = ""; if (ds.Tables[0].Rows.Count > 0) { seller = ds.Tables[0].Rows[0]["sellerId"].ToString().Trim(); int DT = shopcartDA.AddShoppingCart(System.Guid.Parse(buyer), System.Guid.Parse(seller), long.Parse(phoneid), int.Parse(txtNum.Text.Trim()), int.Parse(lblAllPrice.Text.Trim()), DateTime.Now, "是"); if (DT > 0) { Response.Redirect("~/Buyer/SubmitOrder.aspx"); } else { Response.Write("<Script>alert('未能成功结算!')</Script>"); } } } } else { Response.Write("<Script>alert('未能成功结算!')</Script>"); } } else { Session["lasturl"] = Server.UrlDecode(Request.Url.AbsoluteUri.ToString()); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>openDiv('newDiv');</script>"); //Response.Write("<Script>alert('登录后才能购买!')</Script>"); } }
protected void ibtnBuyNow_Click(object sender, ImageClickEventArgs e) { if (Session["name"] != null) { string phoneid = Request.QueryString["PhoneId"].ToString(); BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); string buyer = ""; ShopCartTableAdapter shopcartDA = new ShopCartTableAdapter(); if (userdDT.Rows.Count > 0) { buyer = userdDT.Rows[0][1].ToString(); DataTable shopcartDT = shopcartDA.GetDataBySCidPid(System.Guid.Parse(buyer), long.Parse(phoneid)); if (shopcartDT.Rows.Count > 0) { int Dt = shopcartDA.UpdateCartQuantity(int.Parse(txtNum.Text), int.Parse(lblAllPrice.Text), DateTime.Now, "是", long.Parse(shopcartDT.Rows[0][0].ToString())); if (Dt == 1) { Response.Redirect("~/Buyer/SubmitOrder.aspx"); } else { Response.Write("<Script>alert('未能成功结算!')</Script>"); } } else { string ConnSql = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); string SelectSql = "SELECT * FROM V_PhoneDetailInfo WHERE phone_id =" + long.Parse(phoneid) + ""; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); string seller = ""; if (ds.Tables[0].Rows.Count > 0) { seller = ds.Tables[0].Rows[0]["sellerId"].ToString().Trim(); int DT = shopcartDA.AddShoppingCart(System.Guid.Parse(buyer), System.Guid.Parse(seller), long.Parse(phoneid), int.Parse(txtNum.Text.Trim()), int.Parse(lblAllPrice.Text.Trim()), DateTime.Now, "是"); if (DT > 0) { Response.Redirect("~/Buyer/SubmitOrder.aspx"); } else { Response.Write("<Script>alert('未能成功结算!')</Script>"); } } } } else { Response.Write("<Script>alert('未能成功结算!')</Script>"); } } else { Session["lasturl"] = Server.UrlDecode(Request.Url.AbsoluteUri.ToString()); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>openDiv('newDiv');</script>"); //Response.Write("<Script>alert('登录后才能购买!')</Script>"); } }
protected void ibtnCollect_Click(object sender, ImageClickEventArgs e) { if (Session["name"] != null) { string phoneid = Request.QueryString["PhoneId"].ToString(); BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); CollectionTableAdapter collect = new CollectionTableAdapter(); string buyer = ""; if (userdDT.Rows.Count > 0) { buyer = userdDT.Rows[0][1].ToString(); DataTable collectDT = collect.GetDataByUidPid(System.Guid.Parse(buyer), long.Parse(phoneid)); if (collectDT.Rows.Count > 0) { Response.Write("<Script>alert('您已收藏过此商品!')</Script>"); } else { string ConnSql = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString(); SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); string SelectSql = "SELECT * FROM V_PhoneDetailInfo WHERE phone_id =" + long.Parse(phoneid) + ""; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); string shopid = ""; if (ds.Tables[0].Rows.Count > 0) { shopid = ds.Tables[0].Rows[0]["shopId"].ToString().Trim(); } int DT = collect.AddCollect(System.Guid.Parse(buyer), long.Parse(phoneid), long.Parse(shopid), DateTime.Now, "phone"); if (DT > 0) { Response.Write("<Script>alert('收藏成功!')</Script>"); } } } } else { Response.Write("<Script>alert('登陆后才能收藏!')</Script>"); } }
public void gridviewBind() { string id = ""; BuyerDSTableAdapters.aspnet_UsersTableAdapter userDA = new BuyerDSTableAdapters.aspnet_UsersTableAdapter(); DataTable userdDT = userDA.GetDataByUName(Session["name"].ToString()); if (userdDT.Rows.Count != 0) { id = userdDT.Rows[0][1].ToString(); } SqlConnection Conn = new SqlConnection(ConnSql); Conn.Open(); Guid guid = new Guid(id); string SelectSql = "select * from View1 where goodsbuyer = '" + guid + "' order by orderId desc"; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(SelectSql, Conn); DataSet ds = new DataSet(); da.Fill(ds); gvOrderInfo.DataSource = ds.Tables[0]; gvOrderInfo.DataBind(); //int waitpay = 0, waitConfirm = 0; if (gvOrderInfo.Rows.Count > 0) { int i; for (i = 0; i < gvOrderInfo.Rows.Count; i++) { CheckBox chbSelect = (CheckBox)gvOrderInfo.Rows[i].FindControl("chbSelect"); Label lblPrice = (Label)gvOrderInfo.Rows[i].FindControl("lblPrice"); Label lblQuantity = (Label)gvOrderInfo.Rows[i].FindControl("lblQuantity"); Label lblTotalPrice = (Label)gvOrderInfo.Rows[i].FindControl("lblTotalPrice"); int price = int.Parse(lblPrice.Text); int quantity = int.Parse(lblQuantity.Text); lblTotalPrice.Text = (price * quantity).ToString(); Label lblOrderID = (Label)gvOrderInfo.Rows[i].FindControl("lblOrderID"); Label lblOrderState = (Label)gvOrderInfo.Rows[i].FindControl("lblOrderState"); LinkButton lbtnPay = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnPay"); LinkButton lbtnCancel = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnCancel"); LinkButton lbtnConfirm = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnConfirm"); LinkButton lbtnAddEvaluation = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnAddEvaluation"); Label lblEvaluated = (Label)gvOrderInfo.Rows[i].FindControl("lblEvaluated"); LinkButton lbtnGoToEvaluate = (LinkButton)gvOrderInfo.Rows[i].FindControl("lbtnGoToEvaluate"); if (lblOrderState.Text == "待付款") { lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "买家已付款") { lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; lbtnPay.Enabled = false; lbtnPay.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "卖家已发货") { lbtnPay.Enabled = false; lbtnPay.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; } else { if (lblOrderState.Text == "交易成功") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; EstimateInfoTableAdapter estimateDA = new EstimateInfoTableAdapter(); DataTable estimateDT = estimateDA.GetEvaluationByOrderId(long.Parse(lblOrderID.Text)); if (estimateDT.Rows.Count > 0) { lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; } } else { if (lblOrderState.Text == "退款中的订单") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } else { if (lblOrderState.Text == "交易关闭") { lbtnPay.Enabled = false; lbtnPay.Visible = false; lbtnCancel.Enabled = false; lbtnCancel.Visible = false; lbtnConfirm.Enabled = false; lbtnConfirm.Visible = false; chbSelect.Enabled = false; lbtnAddEvaluation.Enabled = false; lbtnAddEvaluation.Visible = false; lblEvaluated.Enabled = false; lblEvaluated.Visible = false; lbtnGoToEvaluate.Enabled = false; lbtnGoToEvaluate.Visible = false; } } } } } } } } else { imgTubiao.Visible = true; lblShowMassage.Visible = true; lblShowMassage.Text = "没有找到相关订单"; } Conn.Close(); }