ss001/g.hnyhua.cn
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
g.hnyhua.cn/Mtxfw.shop/Sell/UserQRGM.aspx.cs
ss001 c2cda58c65 代码修改后的版本，全部提交
2026-02-07 15:48:27 +08:00

333 lines
20 KiB
C#
Raw Permalink Blame History

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text;
namespace Mtxfw.shop
{
/// <summary>
/// myShoppingCart µÄժҪ˵Ã÷¡£
/// </summary>
public partial class UserQRGM : Mtxfw.Utility.MemberBase
{
protected string UserID = "", ShowConent = "", OrdersID="";
protected String pid = "", cid = "", qid = "", strName = "", strPhone = "", strMailingAddress = "", strPostalCode = "", addresslist = "", yunfei = "0.00", YHJlist = "", strZE = "", XFBYE = "0", JFYE = "0", hidTotal="0";
public Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
public Mtxfw.DAL.P_Product daoProduct = new Mtxfw.DAL.P_Product();
protected int IFaddress = 0;
protected Double umoney19 = 0;
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (!Page.IsPostBack)
{
DataSet ds = new DAL.user_address().GetList("", "UserID=" + Card);
if (ds.Tables[0].Rows.Count > 0)
{
int i = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
addresslist += "<li><input type=\"radio\" id=\"selectaddress" + dr["Id"].ToString() + "\" name=\"addressid\" value=\"" + dr["Id"].ToString() + "\" class=\"selectaddress\" onclick=\"$('.address_table').hide();$('#selectaddress').removeAttr('checked');\"";
if (dr["IFIndex"].ToString() == "1")
{
addresslist += " checked=\"true\"";
}
addresslist += "/>&nbsp;" + dr["Contactname"].ToString() + "&nbsp;" + new DAL.province().GetProvince(dr["Province"].ToString()) + new DAL.city().GetCity(dr["City"].ToString()) + new DAL.county().GetCounty(dr["County"].ToString()) + dr["Address"].ToString() + "&nbsp;" + dr["Contacttel"].ToString() + "&nbsp;<span onclick=\"editaddress(" + dr["Id"].ToString() + ",'" + dr["Contactname"].ToString() + "','" + dr["Contacttel"].ToString() + "','" + dr["Province"].ToString() + "','" + dr["City"].ToString() + "','" + dr["County"].ToString() + "','" + dr["Address"].ToString() + "','" + dr["Zipcode"].ToString() + "')\">±à¼­</span>&nbsp;<span onclick=\"deladdress(" + dr["Id"].ToString() + ")\">ɾ³ý</span>";
if (dr["IFIndex"].ToString() == "1")
{
addresslist += "&nbsp;ĬÈϵØÖ·";
//yunfei = new DAL.province().GetYFmoney(dr["Province"].ToString()).ToString("f2");
}
else
{
addresslist += "&nbsp;<span class=\"setindex\" onclick=\"setaddress(" + dr["Id"].ToString() + ")\">ÉèΪĬÈϵØÖ·</span>";
}
addresslist += "</li>";
i += 1;
}
addresslist += "<li><input type=\"radio\" id=\"selectaddress\" onclick=\"addnewaddress()\" name=\"selectaddress\" value=\"\" />&nbsp;ʹÓÃеØÖ·</li>";
}
else
{
addresslist += "<li><input type=\"radio\" id=\"selectaddress\" checked=\"true\" onclick=\"addnewaddress()\" name=\"selectaddress\" value=\"\" />&nbsp;ʹÓÃеØÖ·</li>";
IFaddress = 1;
}
ds.Clear();
if (Request.QueryString["CartID"] != null)
{
OrdersID = Mtxfw.Utility.Tools.SafeSQL(Request.QueryString["CartID"].ToString());
/*ds = new DAL.order_info().GetList("(Select P_NAME from P_Product b where b.P_ID=a.pid) as prodName,(Select P_images from P_Product b where b.P_ID=a.pid) as prodimg,(select P_JiangLi from P_Product c where c.P_ID=a.pid) as P_JiangLi,", "utype='2' And UserID=" + Card + " And IFDelete=0 And O_received=0");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
YHJlist += "<li><input type=\"checkbox\" id=\"YHJ" + dr["id"].ToString() + "\" onclick=\"addjg(" + Convert.ToDouble(dr["P_JiangLi"]).ToString("f2") + ",this)\" name=\"yhj\" value=\"" + dr["id"].ToString() + "\" />&nbsp;" + dr["prodName"].ToString() + "&nbsp;£¤<span class=\"red\">" + Convert.ToDouble(dr["P_JiangLi"]).ToString("f2") + "</span>Ôª</li>";
}
}
else
{
YHJlist += "<li>Äú»¹Ã»ÓÐÓÅ»Ý¾í£¬½øÈë <a href=\"/shop_jifen.aspx\">»ý·ÖרÇø</a> ¶Ò»»ÓŻݾí</li>";
}
ds.Clear();*/
myDataBind(0);
}
else
{
if (!String.IsNullOrEmpty(Request.QueryString["id"]))
{
OrdersID = Request.QueryString["id"].ToString();
myDataBind(Convert.ToInt32(OrdersID));
}
}
}
}
private void myDataBind(int id)
{
Mtxfw.Model.user_info model = daoUser.GetModel(Card);
if (model != null)
{
IFStores = model.IFStores;
umoney19 = model.umoney19;
if (model.RealName == "")
{
if (model.NCName == "")
{
strName = model.UserName;
}
else
{
strName = model.NCName;
}
}
else
{
strName = model.RealName;
}
strPhone = model.Phone;
strMailingAddress = model.MailingAddress;
strPostalCode = model.PostalCode;
pid = model.Province;
cid = model.City;
qid = model.County;
JFYE = (model.umoney30 - model.umoney31).ToString("f0");
string strprovince = "", strcity = "", strcounty="";
if (Request.Cookies["province"] != null)
{
HttpCookie myCookie = Request.Cookies["province"];
strprovince = HttpUtility.UrlDecode(myCookie.Value);
}
if (Request.Cookies["city"] != null)
{
HttpCookie myCookie = Request.Cookies["city"];
strcity = HttpUtility.UrlDecode(myCookie.Value);
}
if (Request.Cookies["county"] != null)
{
HttpCookie myCookie = Request.Cookies["county"];
strcounty = HttpUtility.UrlDecode(myCookie.Value);
}
if (strprovince != "" && strcity != "" && strcounty != "")
{
if (strprovince.IndexOf(pid) == -1 && strcity.IndexOf(cid) == -1 && strcounty.IndexOf(qid) == -1)
{
pid = strprovince.Split('|')[0];
cid = strcity.Split('|')[0];
qid = strcounty.Split('|')[0];
strMailingAddress = "";
}
}
if (yunfei == "0.00" && pid != "-1")
{
//yunfei = new DAL.province().GetYFmoney(pid).ToString("f2");
}
}
if (id > 0)
{
//ShowConent += "<tr bgColor=\"#efc5ce\"><td colspan=\"4\">É̼ÒÃû³Æ£º";
//ShowConent += "Üñ±¦";
Double YFmoney = 0.00;
Mtxfw.Model.P_Product pmodel = daoProduct.GetModel(id);
if (pmodel != null)
{
YFmoney = pmodel.P_YH_P;
Double ZSubTotal = pmodel.P_VIP_P + YFmoney;
string selcolor = "";
//ShowConent += "&nbsp;&nbsp;ÔË·Ñ£º£¤<span class=\"red\">" + YFmoney.ToString("f2") + "</span></td></tr>";
ShowConent += "<tr id='tr" + pmodel.P_ID + "' " + "><td align='center' class=\"cartprodName\">";
ShowConent += "<a href='/view-" + pmodel.P_ID + ".html' target='_blank'><img src='" + Mtxfw.Utility.Common.GetCoverPic(pmodel.P_images.Split('|')[0].Split(',')[0], "100x100", "cut") + "' width='100'><br>" + pmodel.P_NAME + (selcolor.Split('#')[0] != "" ? "[" + selcolor.Split('#')[0] + "]" : "") + "</a>";
ShowConent += "</td>";
ShowConent += "<td align='center' class=\"hide300\" id='Price" + pmodel.P_ID + "'>£¤" + YFmoney.ToString("f2") + "</td>";
ShowConent += "<td align='center'>1</td><td align='center' id='SubTotal" + pmodel.P_ID + "'>£¤" + (pmodel.P_VIP_P + YFmoney).ToString("f2") + "</td>";
ShowConent += "</tr>";
ShowConent += "<tr><td colspan='4'><div class='cart_left'></div><div class='cart_right'>ÉÌÆ·×ܼÛ(°üº¬ÔË·Ñ)£º£¤<span class='cart_Total' id='cart_Total'>" + ZSubTotal.ToString("f2").Replace(",", "") + "</span>Ôª";
hidTotal = ZSubTotal.ToString("f2").Replace(",", "");
ShowConent += "&nbsp;<input type='button' class='cart_botton' value='È·ÈÏÌá½»' onclick=\"UserQRGM()\"/></div></td></tr>";
}
}
else
{
DataView dv = Mtxfw.DAL.ShoppingCart.Getprod(IFStores);
if (dv.Count > 0)
{
string CFOIDs = ",";
for (int j = 0; j <= dv.Count - 1; j++)
{
string prodid = dv.Table.Rows[j]["prodid"].ToString();
if (OrdersID.IndexOf("," + prodid + ",") != -1)
{
string SUserID = dv.Table.Rows[j]["SUserID"].ToString();
if (CFOIDs == "")
{
CFOIDs = "," + SUserID + ",";
}
else
{
if (CFOIDs.IndexOf("," + SUserID + ",") == -1)
{
CFOIDs += SUserID + ",";
}
}
}
}
string[] ACFOIDs = CFOIDs.Split(',');
Double ZSubTotal = 0.00;
Double ZYFmoney = 0.00;
foreach (string stra in ACFOIDs)
{
if (stra != "")
{
ShowConent += "<tr bgColor=\"#efc5ce\"><td colspan=\"4\">É̼ÒÃû³Æ£º";
if (stra != "0")
{
string strUserName = daoUser.Getzd("UserName", "ID=" + stra).ToString();
ShowConent += strUserName;
}
else
{
ShowConent += "Üñ±¦";
}
Double YFmoney = 0.00;
for (int j = 0; j <= dv.Count - 1; j++)
{
string prodid = dv.Table.Rows[j]["prodid"].ToString();
string SUserID = dv.Table.Rows[j]["SUserID"].ToString();
if (Request.QueryString["CartID"].ToString().IndexOf("," + prodid + ",") != -1 && stra == SUserID)
{
Double SPYH = Convert.ToDouble(dv.Table.Rows[j]["SPYH1"].ToString());
if (Convert.ToDouble(YFmoney.ToString("f2")) == 0.00 && Convert.ToDouble(SPYH.ToString("f2")) > 0.00)
{
YFmoney = SPYH;
}
}
}
ShowConent += "&nbsp;&nbsp;ÔË·Ñ£º£¤<span class=\"red\">" + YFmoney.ToString("f2") + "</span></td></tr>";
ZYFmoney += YFmoney;
for (int j = 0; j <= dv.Count - 1; j++)
{
string prodid = dv.Table.Rows[j]["prodid"].ToString();
string SUserID = dv.Table.Rows[j]["SUserID"].ToString();
if (Request.QueryString["CartID"].ToString().IndexOf("," + prodid + ",") != -1 && stra == SUserID)
{
string utype = dv.Table.Rows[j]["utype"].ToString();
string strid = dv.Table.Rows[j]["id"].ToString();
string prodName = dv.Table.Rows[j]["prodName"].ToString();
string P_CATEGORYs = dv.Table.Rows[j]["P_CATEGORYs"].ToString();
string selcolor = HttpUtility.UrlDecode(dv.Table.Rows[j]["selcolor"].ToString());
string prodimg = dv.Table.Rows[j]["prodimg"].ToString().Split('|')[0].Split(',')[0];
if (prodimg == "")
{
prodimg = "/Images/no_photo_s.png";
}
string prodPrice = Convert.ToDouble(dv.Table.Rows[j]["prodPrice"].ToString()).ToString("f2").Replace(",", "");
string prodNum = dv.Table.Rows[j]["prodNum"].ToString();
string TotalNum = dv.Table.Rows[j]["TotalNum"].ToString();
string SubTotal = Convert.ToDouble(dv.Table.Rows[j]["SubTotal"].ToString()).ToString("f2").Replace(",", "");
string IFMJCDYH = dv.Table.Rows[j]["IFMJCDYH"].ToString();
Double XSubTotal = Convert.ToDouble(dv.Table.Rows[j]["SubTotal"].ToString());
ZSubTotal = ZSubTotal + XSubTotal;
ShowConent += "<tr id='tr" + strid + "' " + (utype == "3" ? " bgColor=\"#EEEEEE\"" : "") + "><td align='center' class=\"cartprodName\">";
if (utype == "3")
{
ShowConent += "" + prodName + (selcolor.Split('#')[0] != "" ? "[" + selcolor.Split('#')[0] + "]" : "") + "";
}
else
{
ShowConent += "<a href='/view-" + prodid + ".html' target='_blank'><img src='" + Mtxfw.Utility.Common.GetCoverPic(prodimg, "100x100", "cut") + "' width='100'><br>" + prodName + (selcolor.Split('#')[0] != "" ? "[" + selcolor.Split('#')[0] + "]" : "") + "</a>";
}
ShowConent += "</td>";
ShowConent += "<td align='center' class=\"hide300\" id='Price" + strid + "'>£¤" + prodPrice + "</td>";
ShowConent += "<td align='center'>" + prodNum + "</td><td align='center' id='SubTotal" + strid + "'>£¤" + SubTotal + "</td>";
/*if (IFMJCDYH == "1")
{
ShowConent += "<td align='center'><select name='SPYH' class=''><option value='1'>ƽÓÊ " + SPYH1.ToString("c") + "</option>";
ShowConent += "<option value='2' selected>¿ìµÝ " + SPYH2.ToString("c") + "</option>";
ShowConent += "<option value='3'>EMS " + SPYH3.ToString("c") + "</option>";
ShowConent += "</select></td>";
}
else
{
ShowConent += "<td align='center'><select name='SPYH' class=''><option value='0'>Âô¼Ò³Ðµ£·ÑÓÃ</option>";
ShowConent += "</select></td>";
}*/
ShowConent += "</tr>";
if (utype == "3")
{
ShowConent += "<tr bgColor=\"#EEEEEE\"><td colspan=\"4\"><div class=\"taocaoproduct\"><ul>";
System.Data.DataSet Ds_Product2 = daoProduct.GetList("", "utype='0' And charindex(',' + Convert(varchar(50),P_ID) + ',','" + P_CATEGORYs + "')>0 And P_State=N'ÒÑ´¦Àí' Order By P_Orders Desc,P_ADDATE asc");
if (Ds_Product2.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < Ds_Product2.Tables[0].Rows.Count; k++)
{
string prodimg2 = Ds_Product2.Tables[0].Rows[k]["P_images"].ToString().Split('|')[0].Split(',')[0];
string prodid2 = Ds_Product2.Tables[0].Rows[k]["P_ID"].ToString();
string prodName2 = Ds_Product2.Tables[0].Rows[k]["P_NAME"].ToString();
ShowConent += "<li><a href='/view-" + prodid2 + ".html' target='_blank'><img src='" + Mtxfw.Utility.Common.GetCoverPic(prodimg2, "100x100", "cut") + "' width='100'><br>" + prodName2 + "</a></li>";
}
}
ShowConent += "</ul></div></td></tr>";
}
}
}
}
}
ZSubTotal += ZYFmoney;
strZE = ZSubTotal.ToString("f0");
ShowConent += "<tr><td colspan='4'><div class='cart_left'></div><div class='cart_right'>ÉÌÆ·×ܼÛ(°üº¬ÔË·Ñ)£º£¤<span class='cart_Total' id='cart_Total'>" + ZSubTotal.ToString("f2").Replace(",", "") + "</span>Ôª";
hidTotal = ZSubTotal.ToString("f2").Replace(",", "");
ShowConent += "&nbsp;<input type='button' class='cart_botton' value='È·ÈÏÌá½»' onclick=\"UserQRGM()\"/></div></td></tr>";
}
dv.Table.Clear();
}
}
protected String GetProvince()
{
StringBuilder sb = new StringBuilder();
Mtxfw.DAL.province daoPro = new Mtxfw.DAL.province();
System.Data.DataSet Ds = daoPro.GetCacheList("", "1=1 Order by Id Asc", "Province");
System.Data.DataTable Dt = (Ds != null && Ds.Tables[0] != null) ? Ds.Tables[0] : null;
foreach (System.Data.DataRow Dr in Dt.Rows)
{
sb.Append("<option value=\"" + Dr["ProvinceID"] + "\">" + Dr["ProvinceName"] + "</option>\r\n");
}
return sb.ToString();
}
}
}
Reference in New Issue View Git Blame Copy Permalink