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