public void BindStoreCart(int DisID, int Compid)
{
DataTable ListCart = new Hi.BLL.DIS_ShopCart().GetList("GoodsName,bg.id,GoodsinfoID,GoodsNum ", "DIS_ShopCart cart join BD_Goods bg on cart.GoodsID=bg.ID join BD_GoodsInfo bginfo on cart.GoodsinfoID=bginfo.ID", " cart.dr=0 and cart.DisID=" + DisID + " ", " cart.createdate desc");
decimal goodsNum = 0;
DataTable dtsum = new Hi.BLL.DIS_ShopCart().SumCartNum(Compid.ToString(), DisID.ToString());
if (dtsum != null && dtsum.Rows.Count > 0)
{
goodsNum = dtsum.Rows[0]["cart"].ToString().ToDecimal(0);
}
this.TopE_CartNum.InnerText = goodsNum.ToString();
if (ListCart.Rows.Count == 0)
{
TopE_StoreCart.InnerHtml = "<a href=\"javascript:void(0);\"><i class=\"name\" tip=\"title\">购物车中还没有商品，赶紧选购吧！</i></a>";
}
else
{
string CartHTML = "";
int index = 0;
foreach (DataRow row in ListCart.Rows)
{
index++;
if (index > 4)
{
CartHTML += "<div class=\"border\"><span> 购物车还有<span class='red' id=\"num\">" + (ListCart.Rows.Count - 4) + "</span></span>个商品<a class\"cklink\" style='float:right' href=\"../Distributor/Shop.aspx\">去购物车</a></div>";
break;
}
CartHTML += "<a target='_blank' Infoid='" + row["GoodsinfoID"] + "' href=\"/e" + row["GoodsinfoID"] + "_" + Compid + "_.html\"><i class=\"GoGoodsInfo name\" title='" + row["GoodsName"] + "'>" + (row["GoodsName"].ToString().Length > 15 ? row["GoodsName"].ToString().Substring(0, 15) + "..." : row["GoodsName"].ToString()) + "</i><span class=\"goodsnum num\">x" + row["GoodsNum"].ToString().ToDecimal(0).ToString("#") + "</span></a>";
}
TopE_StoreCart.InnerHtml = CartHTML;
}
}
/// <summary>
/// 商品总价
/// </summary>
/// <returns></returns>
public void ToTalPrice2()
{
decimal price = 0;
List <int> list = new List <int>();
Dictionary <int, decimal> num = new Dictionary <int, decimal>();
List <Hi.Model.DIS_ShopCart> l = new Hi.BLL.DIS_ShopCart().GetList("", "isnull(dr,0)=0 and compid=" + this.ddrComp.Value + " and disid=" + this.DisID, "");
if (l.Count > 0)
{
for (int i = 0; i < l.Count; i++)
{
list.Add(l[i].GoodsinfoID);
num.Add(l[i].GoodsinfoID, l[i].GoodsNum);
}
List <BLL.gDprice> lsit = BLL.Common.GetPrice(this.CompID, this.DisID, list);
if (lsit.Count > 0)
{
foreach (BLL.gDprice item in lsit)
{
price += item.FinalPrice * num[item.goodsInfoId];
}
}
}
this.sumPrice.InnerHtml = price.ToString().ToDecimal(0).ToString("N");
}
/// <summary>
/// 购物车商品
/// </summary>
public void ShopCart()
{
DataTable dt = new Hi.BLL.DIS_ShopCart().GetGoodsCart(" sc.[CompID]=" + this.CompID + " and sc.[DisID]=" + this.DisID + "and sc.dr=0", "sc.[CreateDate] desc ");
if (dt != null && dt.Rows.Count > 0)
{
decimal TotalAmount = 0;
string html = string.Empty;
string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", this.CompID); //小数位数
string str6 = IsInve == 0 ? "" : "display:none";
for (int i = 0; i < dt.Rows.Count; i++)
{
int goodsinfoid = Convert.ToInt32(dt.Rows[i]["GoodsinfoID"].ToString());
Hi.Model.BD_GoodsInfo model3 = new Hi.BLL.BD_GoodsInfo().GetModel(goodsinfoid);
Hi.Model.BD_Goods model4 = new Hi.BLL.BD_Goods().GetModel(model3.GoodsID);
string pic = dt.Rows[i]["pic"].ToString(); // new Hi.BLL.BD_Goods().GetModel(Convert.ToInt32(model2.GoodsID)).Pic;
string inventory = string.Empty;
BLL.Common.GetInevntory(this.CompID, goodsinfoid, 0, Convert.ToDecimal(dt.Rows[i]["GoodsNum"]), out inventory); // dt.Rows[i]["Inventory"].ToString();
string str7 = string.Empty; //是否促销
if (dt.Rows[i]["ProID"].ToString() != "0")
{
str7 = SelectGoodsInfo.protitle(dt.Rows[i]["ProID"].ToString(), dt.Rows[i]["Unit"].ToString());
}
string strremark = string.Empty;
decimal zxprice = BLL.Common.GetGoodsPrice(this.CompID, this.DisID, goodsinfoid);//最新价格
decimal num = decimal.Parse(string.Format("{0:N4}", Convert.ToDecimal(dt.Rows[i]["GoodsNum"]).ToString("#,####" + Digits)));
TotalAmount += zxprice * num;
html += "<tr tip=\"" + goodsinfoid + "\" trindex=\"" + i + "\" trindex2=\"" + i + "\" id=\"\"><td class=\"t8\"><div class=\"addg\"><a href=\"javascript:;\" class=\"minus2\"></a><a href=\"javascript:;\" class=\"add2\"></a></div></td><td><div class=\"sPic\"><a class=\"opt-i2\"></a><span><a href=\"javascript:;\"><img src=\"" + Common.GetPicURL(pic, "resize200") + "\" width=\"60\" height=\"60\"></a></span><a href=\"javascript:;\" class=\"code\">商品编码：" + dt.Rows[i]["barCode"].ToString() + str7 + "</a><a href=\"javascript:;\" class=\"name\">" + GetGoodsName(model4.GoodsName, model3.ValueInfo, "1") + "<i>" + GetGoodsName(model4.GoodsName, model3.ValueInfo, "2") + "</i></a></div></td><td><div class=\"tc\">" + model4.Unit + "</div></td><td><div class=\"tc divprice" + i + "\" tip=\"" + decimal.Parse(string.Format("{0:N2}", zxprice)).ToString("0.00") + "\">￥" + decimal.Parse(string.Format("{0:N2}", zxprice)).ToString("0.00") + "</div><input type=\"hidden\" class=\"hidPrice\" value=\"" + zxprice + "\" /></td><td style=\"" + str6 + "\"><div class=\"tc\"><input type=\"hidden\" id=\"hidInventory_" + i + "\" value=\"" + decimal.Parse(string.Format("{0:N2}", inventory)).ToString(Digits) + "\" />" + decimal.Parse(string.Format("{0:N2}", inventory)).ToString(Digits) + "</div></td><td><div class=\"sl divnum\" tip=\"" + dt.Rows[i]["GoodsinfoID"].ToString() + "\" tip2=\"" + i + "\"><a href=\"javascript:void(0);\" class=\"minus\">-</a><input type=\"text\" class=\"box txtGoodsNum txtGoodsNum" + i + "\" onfocus=\"InputFocus(this)\" onkeyup='KeyInt2(this)' maxlength=\"9\" value=\"" + num + "\"><a href=\"javascript:void(0);\" class=\"add\">+</a></div></td><td><div class=\"tc lblTotal_" + i + "\">￥" + decimal.Parse(string.Format("{0:N2}", zxprice * num)).ToString("0.00") + "</div></td><td><div class=\"tc alink\"><a href=\"javascript:;\" class=\"aremark" + i + "\">添加</a>" + strremark + "</div></td></tr>";
}
//查询购物车商品数量、总价
// DataTable dtp = new Hi.BLL.DIS_ShopCart().SumCartNum(this.CompID.ToString(), this.DisID.ToString());
// if (dtp != null && dtp.Rows.Count > 0)
//{
//TotalAmount = (dtp.Rows[0]["SumAmount"].ToString().ToDecimal(0));
//订单总价
this.lblTotalAmount.InnerText = decimal.Parse(string.Format("{0:N2}", TotalAmount.ToString())).ToString("0.00");//商品总额
//订单促销
decimal ProAmount = Common.GetProPrice(TotalAmount, out ProID, out ProIDD, out ProType, this.CompID);
this.lblCux.InnerText = decimal.Parse(string.Format("{0:N2}", ProAmount.ToString())).ToString("0.00");
//合计
string str8 = (TotalAmount - ProAmount).ToString("N");
ClientScript.RegisterStartupScript(this.GetType(), "adder", "<script>$(function(){disId=" + this.DisID + "; $(\".tabLine table tbody tr:last\").before(\"" + html.Replace("\"", "'") + "\");$(\"#lblYFPrice\").text(\"" + str8 + "\")})</script>");
// }
}
else
{
Response.Redirect("/Distributor/Shop.aspx");
}
}
protected void databind()
{
DataTable dt = new Hi.BLL.DIS_ShopCart().GetGoodsCart(" sc.[CompID]=" + this.ddrComp.Value + " and sc.[DisID]=" + this.DisID + "and sc.dr=0", "sc.[CreateDate] desc ");
if (dt != null && dt.Rows.Count > 0)
{
this.rprCart.DataSource = dt;
this.rprCart.DataBind();
}
else
{
Clear();
this.rprCart.DataSource = null;
this.rprCart.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session != null)
{
logUser = Session["UserModel"] as LoginModel;
dis = new Hi.BLL.BD_Distributor().GetModel(logUser.DisID);
//com = new Hi.BLL.BD_Company().GetModel(logUser.CompID);
//if (com != null)
//{
// string lg = com.CompLogo;
// logo = lg == "" ? "../Config/image/logo8.jpg" : System.Configuration.ConfigurationManager.AppSettings["ImgViewPath"] + "CompImage/" + lg;
//}
if (logUser.Url != null)
{
//罗汉
if (logUser.Url.IndexOf("lhhome") != -1)
{
bol = true;
}
//酒隆仓
if (logUser.Url.IndexOf("jlc") != -1)
{
bol = true;
}
}
Hi.Model.SYS_Users sysuser = new Hi.BLL.SYS_Users().GetModel(logUser.UserID);
if (sysuser.TrueName != null && sysuser.TrueName.ToString() != "")
{
ShowName = sysuser.TrueName.ToString();
}
else
{
ShowName = sysuser.UserName.ToString();
}
if (ShowName.Length > 6)
{
ShowName = ShowName.Substring(0, 6) + "...";
}
}
DataTable dt = new Hi.BLL.DIS_ShopCart().GetGoodsCart(" sc.[CompID]=" + logUser.CompID + " and sc.[DisID]=" + logUser.DisID + "and sc.dr=0", "sc.[CreateDate] desc ");
string cart = "";
int i = 0;
if (dt != null && dt.Rows.Count > 0)
{
//查询购物车商品数量、总价
DataTable dtsum = new Hi.BLL.DIS_ShopCart().SumCartNum(logUser.CompID.ToString(), logUser.DisID.ToString());
if (dtsum != null && dtsum.Rows.Count > 0)
{
this.Top_CartNum.InnerText = dtsum.Rows[0]["cart"].ToString().ToDecimal(0).ToString("0");
}
foreach (DataRow item in dt.Rows)
{
i++;
if (i > 4)
{
cart += "<div class=\"border\"><span>购物车还有<span id=\"num\">" + (dtsum.Rows[0]["cart"].ToString().ToDecimal(0) - 4) + "</span>个商品</span><a class=\"cklink\" href=\"" + ResolveUrl("../Distributor/Shop.aspx") + "\">去购物车</a></div>";
break;
}
cart += "<i class=\"GoGoodsInfo\" goods_tip=\"" + item["GoodsID"] + "\" tip=\"" + item["GoodsinfoID"] + "\">" + Common.MySubstring(item["GoodsName"].ToString(), 15, "...") + "<span class=\"goodsnum\"> " + item["GoodsNum"].ToString().ToDecimal(0).ToString("0") + "</span><span>x</span></i>";
}
}
cart = !string.IsNullOrEmpty(cart) ? cart : "<i tip=\"title\">购物车中还没有商品，赶紧选购吧！</i>";
this.tgnCar.InnerHtml = cart;
}
