public void BindDdl() { string url = WebToolHelper.GetProfilesUrl(); var rollInfo = new DB.BLL.MY_Bll(DBEnum.Slave).GetModelList("SELECT R.*,CONCAT(@PathAdd,R.Picture) AS NPicture FROM M_Roll AS R WHERE R.IsEnable =1 ORDER BY R.OrderBy ASC", new { PathAdd = url }).Select(info => { return(new { info.NPicture, info.TargetSysID, info.TargetUrl }); }); repeaterNoticeList.DataSource = rollInfo; repeaterNoticeList.DataBind(); string cpyName = WebLoginHelper.GetSimpleName(); if (!string.IsNullOrEmpty(cpyName)) { cpyNameSpan.InnerHtml = cpyName + "商品专供"; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.HttpMethod.ToLower() == "get")//获取用户端的传输方式(全转化为小写)是否是get传值 { string openid = Convert.ToString(HttpContext.Current.Session[WebLoginHelper.SESSION_OPENID]); if (!string.IsNullOrEmpty(openid)) { DSMT_TAE_ServiceSoapClient pmtCilent = new DSMT_TAE_ServiceSoapClient(); GetQueryUserInfoEntity userInfoEntity = new GetQueryUserInfoEntity(); try { userInfoEntity.OpenID = new DESHelper().Decrypt(openid); new VerifyHelper().EncryptPmtEntity(userInfoEntity); BackQueryUserInfoEntity backUserInfo = pmtCilent.QueryUserInfo(userInfoEntity); new VerifyHelper().CheckPmtSign(ref backUserInfo); uOpenID.InnerHtml = openid;//将加密后的openID写入隐藏控件 if (backUserInfo != null) { if (!string.IsNullOrEmpty(backUserInfo.UserNo) && !string.IsNullOrEmpty(backUserInfo.UserPhone))//判断职员编号是否为空//并且手机号码不为空 { string telphoneNo = backUserInfo.UserPhone; string telphoneEnc = new DESHelper().Encrypt(telphoneNo); telephoneNo.Value = WebToolHelper.HiddenTelephoneNo(telphoneNo); //"18758305045";//替换*号符 telephoneUserName.InnerHtml = WebToolHelper.HiddenTelephoneUserName(backUserInfo.RealName); telephoneNo.Attributes.Add("disabled", "disabled"); telephoneNo.Attributes.Add("mydata", telphoneEnc); BindingInfo bindingInfo = new BindingInfo(); bindingInfo.CpySysID = backUserInfo.CpySysID; bindingInfo.CpyName = backUserInfo.CpyName; bindingInfo.SimpleName = backUserInfo.SimpleName; bindingInfo.RealName = backUserInfo.RealName; bindingInfo.UserGender = backUserInfo.UserGender; bindingInfo.UserNo = backUserInfo.UserNo; string jsonUserInfo = new JavaScriptSerializer().Serialize(bindingInfo); telephoneUserName.Attributes.Add("mydata", new DESHelper().Encrypt(jsonUserInfo)); } } } catch (Exception es) { FileHelper.logger.Error(Convert.ToString(es)); Response.Redirect("/web/mall_Index.aspx?", false); } } else { FileHelper.logger.Info("获取COOKIE的openID失败"); } } }
private void BindGrid() { try { string goodsSysID = Request.QueryString["goodsId"].Trim(); string url = WebToolHelper.GetProfilesUrl(); if (!string.IsNullOrEmpty(goodsSysID)) { StringBuilder strSql = new StringBuilder(); strSql.Append(" SELECT *,CONCAT(@PathAdd,GLY.ImgUrl) AS NImgUrl FROM M_GoodsGallery AS GLY WHERE GLY.GoodsID =@GoodsID "); object dt = new DB.BLL.MY_Bll(DBEnum.Slave).GetModelList(strSql.ToString(), new { PathAdd = url, GoodsID = goodsSysID }).Select(info => { return(new { info.NImgUrl }); }); repeaterGoodsPicetureShow.DataSource = dt; repeaterGoodsPicetureShow.DataBind(); strSql.Clear(); strSql.Append(" SELECT G.GoodsID,G.GoodsSn,G.GoodsName,G.BrandID,G.Weight,G.GoodsBrief,G.GoodsDesc,G.MarketPrice,G.ShopPrice,G.QuotaNumber,G.GoodsNumber,B.BrandName,S.SuppliersName,C.CateName,G.SaleNumber,FT.FareTime,"); strSql.Append(" CASE WHEN FT.FareType=10 THEN '按件数计费' WHEN FT.FareType= 20 THEN '按重量计费' WHEN FT.FareType= 30 THEN '按体积计费' ELSE '未指定运费模板' END NFareType , "); strSql.Append(" CONCAT('默认运费:',ROUND(FC.FirstCount),'(件/公斤)内:',FC.FirstMoney,'元,','续:',FC.ContinueMoney,'/(件/公斤)') AS NFareInfo "); strSql.Append(" FROM M_Goods AS G "); strSql.Append(" LEFT JOIN M_Brand AS B ON B.BrandID = G.BrandID "); strSql.Append(" LEFT JOIN M_Category AS C ON G.CateID = C.CateID "); strSql.Append(" LEFT JOIN M_Suppliers AS S ON S.SuppliersID = G.SuppliersID "); strSql.Append(" LEFT JOIN M_FareTemplate AS FT ON G.FareSysID= FT.FareSysID "); strSql.Append(" LEFT JOIN M_FareCarry AS FC ON G.FareSysID =FC.FareSysID "); strSql.Append(" WHERE G.GoodsID = @GoodsID AND G.IsDelete=0 ORDER BY FC.IsDefault DESC LIMIT 1 "); IEnumerable <dynamic> goodsInfo = new DB.BLL.MY_Bll(DBEnum.Slave).GetModelList(strSql.ToString(), new { GoodsID = goodsSysID }); string fileUrl = WebToolHelper.GetProfilesUrl(); foreach (var item in goodsInfo) { item.GoodsDesc = WebToolHelper.ReplaceImgUrl_1(item.GoodsDesc.ToString(), fileUrl); } repeaterGoodsInfo.DataSource = goodsInfo.Select(info => { return(new { info.GoodsID, info.GoodsSn, info.GoodsName, info.GoodsDesc, info.MarketPrice, info.ShopPrice, info.GoodsNumber, info.BrandName, info.SuppliersName, info.SaleNumber, info.CateName, info.GoodsBrief, Weight = info.Weight <= 0.1 ? "小于 1":info.Weight, info.NFareType, info.NFareInfo, info.FareTime, info.QuotaNumber, NQuotaNumber = (info.QuotaNumber <= 0) ? "不限购":"件" }); }); repeaterGoodsInfo.DataBind(); } } catch { Response.Redirect("/web/mall_Index.aspx", false); } }
public void BindDdl() { string parentCateIDStr = string.Empty; if (HttpRuntime.Cache["parentCateID"] == null) { string url = WebToolHelper.GetProfilesUrl(); string strSql = "SELECT *, CONCAT(@AddPath,ShowImage) AS NPicture FROM M_Category WHERE IsDelete = 0 AND IsEnable =1 AND ShowInNav =1 AND ParentID = 0"; IEnumerable <dynamic> info = new DB.BLL.MY_Bll(DBEnum.Slave).GetModelList(strSql, new { AddPath = url }); StringBuilder innerText = new StringBuilder(); foreach (var item in info) { innerText.Append("<li name=\"parentCateID\"><a href=\"javascript:void(0);\" mydata=\"" + item.CateID + "\" > " + item.CateName + " </a></li>"); } parentCateIDStr = innerText.ToString(); HttpRuntime.Cache.Insert("parentCateID", parentCateIDStr, null, DateTime.Now.AddMinutes(60), System.Web.Caching.Cache.NoSlidingExpiration); } else { parentCateIDStr = Convert.ToString(HttpRuntime.Cache["parentCateID"]); } gridTopCategoryList.InnerHtml = parentCateIDStr; }
protected void Page_Load(object sender, EventArgs e) { string feeAmount = new WebToolHelper().GetProfilesEncryptInfo(FieldName.FeeAmount, "159"); emCartFeeAmount.Attributes.Add("mydata", feeAmount); }