/// <summary> /// 获得wid的用户分类信息 /// </summary> /// <returns></returns> public IList <Model.wx_shop_category> getCategory() { Tag tag = this.Document.CurrentRenderingTag; ///classlayer表示取类别深度,如果为-1,则取所有分类的深度,如果为1,则取第一层目录,如果为2,则去第2层目录 var classlayer = tag.Attributes["classlayer"]; var parentidObj = tag.Attributes["parentid"]; int parentid = -1; if (parentidObj != null && MyCommFun.isNumber(parentidObj.Value.GetValue())) { parentid = MyCommFun.Obj2Int(parentidObj.Value.GetValue()); } int class_layer = -1; if (classlayer != null && MyCommFun.isNumber(classlayer.Value.GetValue())) { class_layer = MyCommFun.Obj2Int(classlayer.Value.GetValue()); } DAL.wx_shop_category cateBll = new DAL.wx_shop_category(); IList <Model.wx_shop_category> categorylist = cateBll.GetCategoryListByWid(wid, -1, parentid, class_layer); if (categorylist != null && categorylist.Count > 0) { Model.wx_shop_category cat = new Model.wx_shop_category(); for (int i = 0; i < categorylist.Count; i++) { cat = categorylist[i]; if (cat.link_url == null || cat.link_url.Trim() == "") { //如果link_url为空,则直接调用本系统的信息 cat.link_url = MyCommFun.urlAddOpenid("/shop/list.aspx?wid=" + wid + "&cid=" + cat.id, openid); cat.category_url = MyCommFun.urlAddOpenid("/shop/category.aspx?wid=" + wid + "&cid=" + cat.id, openid); } else { cat.link_url = MyCommFun.urlAddOpenid(cat.link_url, openid); } } } return(categorylist); }
/// <summary> /// 获得热卖 /// </summary> /// <returns></returns> public DataTable getHotsalet() { Tag tag = this.Document.CurrentRenderingTag; var attribute = tag.Attributes["rows"]; int cid = MyCommFun.RequestInt("cid"); int rows = -1;//若为-1,则不做限制条件 if (attribute != null && MyCommFun.isNumber(attribute.Value.GetValue())) { rows = MyCommFun.Obj2Int(attribute.Value.GetValue()); } DAL.wx_shop_product artDal = new DAL.wx_shop_product(); if (cid != 0) { productlist = artDal.GetList(wid, rows, " hotsale=" + 1 + " and categoryId=" + cid); } else { productlist = artDal.GetList(wid, rows, " hotsale=" + 1); } DataTable dt = productlist.Tables[0]; if (productlist != null && productlist.Tables.Count > 0 && productlist.Tables[0].Rows.Count > 0) { DataRow dr; for (int i = 0; i < productlist.Tables[0].Rows.Count; i++) { dr = productlist.Tables[0].Rows[i]; if (dr["link_url"] != null && dr["link_url"].ToString().Trim().Length > 0) { dr["link_url"] = MyCommFun.urlAddOpenid(dr["link_url"].ToString().Trim(), openid); } else { dr["link_url"] = MyCommFun.urlAddOpenid("detail.aspx?wid=" + wid + "&pid=" + dr["id"].ToString(), openid); } productlist.AcceptChanges(); } } return(dt); }
/// <summary> /// 获取类别列表 /// </summary> /// <returns></returns> public DataTable getclasslist() { Tag tag = this.Document.CurrentRenderingTag; var parentidObj = tag.Attributes["parentid"]; int parentid = 0; if (parentidObj != null && MyCommFun.isNumber(parentidObj.Value.GetValue())) { parentid = MyCommFun.Obj2Int(parentidObj.Value.GetValue()); } var topNumObj = tag.Attributes["top"]; int topNum = 0; if (topNumObj != null && MyCommFun.isNumber(topNumObj.Value.GetValue())) { topNum = MyCommFun.Obj2Int(topNumObj.Value.GetValue()); } DAL.wx_shop_category classlist = new DAL.wx_shop_category(); return(classlist.GetWCodeList(wid, parentid, topNum)); }
/// <summary> /// 获得底部菜单 /// </summary> /// <returns></returns> public IList <Model.article_category> getBottomMenu() { string openid = MyCommFun.RequestOpenid(); Tag tag = this.Document.CurrentRenderingTag; var classlayer = tag.Attributes["classlayer"]; var parentidObj = tag.Attributes["parentid"]; int parentid = -1; if (parentidObj != null && MyCommFun.isNumber(parentidObj.Value.GetValue())) { parentid = MyCommFun.Obj2Int(parentidObj.Value.GetValue()); } int class_layer = -1; if (classlayer != null && MyCommFun.isNumber(classlayer.Value.GetValue())) { class_layer = MyCommFun.Obj2Int(classlayer.Value.GetValue()); } IList <Model.article_category> bmenulist = tDal.GetBottomMenuByWid(wid, -1, parentid, class_layer); if (bmenulist != null && bmenulist.Count > 0) { Model.article_category cat = new Model.article_category(); for (int i = 0; i < bmenulist.Count; i++) { cat = bmenulist[i]; if (cat.link_url == null || cat.link_url.Trim() == "" || isContainsNoOpenid_hz(cat.link_url)) { } else { cat.link_url = MyCommFun.urlAddOpenid(cat.link_url, openid); } } } return(bmenulist); }
/// <summary> /// 获得幻灯片列表二:优点:(1)使用function标签与foreach结合,可以从模版页面控制记录数量;(2)不需要实现注册到模版里 /// </summary> /// <returns></returns> public IList <Model.article> getHdp() { Tag tag = this.Document.CurrentRenderingTag; var attribute = tag.Attributes["rows"]; IList <Model.article> artlist = new List <Model.article>(); int rows = -1;//若为-1,则不做限制条件 if (attribute != null && MyCommFun.isNumber(attribute.Value.GetValue())) { rows = MyCommFun.Obj2Int(attribute.Value.GetValue()); } artlist = tDal.GetHDPByWid(wid, rows); if (artlist != null && artlist.Count > 0) { Model.article cat = new Model.article(); for (int i = 0; i < artlist.Count; i++) { cat = artlist[i]; if (cat.link_url == null || cat.link_url.Trim() == "") { //如果link_url为空,则直接调用本系统的信息 cat.link_url = "javascript:;"; } else { cat.link_url = MyCommFun.urlAddOpenid(cat.link_url, openid); } } } return(artlist); }
/// <summary> /// 添加奖品项目 /// </summary> private void EditAwardItem(int dzpId) { //1删除原来的,2新增 iBll.DeleteByActId(dzpId); Model.wx_dzpAwardItem item = new Model.wx_dzpAwardItem(); TextBox txtJXName; TextBox txtJPName; TextBox txtNum; TextBox txtRealNum; int sort_id = 0; int totJxNum = 0; //一共有多少奖项 for (int i = 1; i <= 6; i++) { txtJXName = this.FindControl("txt" + i + "JXName") as TextBox; txtJPName = this.FindControl("txt" + i + "JPName") as TextBox; txtNum = this.FindControl("txt" + i + "Num") as TextBox; txtRealNum = this.FindControl("txt" + i + "RealNum") as TextBox; if (txtJXName.Text.Trim() != "" && txtJPName.Text.Trim() != "" && txtNum.Text.Trim() != "" && txtRealNum.Text.Trim() != "" && MyCommFun.isNumber(txtNum.Text) && MyCommFun.isNumber(txtRealNum.Text)) { totJxNum++; } } //计算每个奖项的角度值 decimal avgDeg = (decimal)360.0 / (totJxNum + 1); for (int i = 1; i <= 6; i++) { txtJXName = this.FindControl("txt" + i + "JXName") as TextBox; txtJPName = this.FindControl("txt" + i + "JPName") as TextBox; txtNum = this.FindControl("txt" + i + "Num") as TextBox; txtRealNum = this.FindControl("txt" + i + "RealNum") as TextBox; if (txtJXName.Text.Trim() != "" && txtJPName.Text.Trim() != "" && txtNum.Text.Trim() != "" && txtRealNum.Text.Trim() != "" && MyCommFun.isNumber(txtNum.Text) && MyCommFun.isNumber(txtRealNum.Text)) { sort_id++; //那么添加奖品信息 item.jxName = txtJXName.Text.Trim(); item.sort_id = sort_id; item.jpName = txtJPName.Text.Trim(); item.jpNum = MyCommFun.Str2Int(txtNum.Text.Trim()); item.jpRealNum = MyCommFun.Str2Int(txtRealNum.Text.Trim()); item.actId = dzpId; item.createDate = DateTime.Now; item.jiaodu_min = avgDeg * sort_id; iBll.Add(item); } } }
/// <summary> /// 商品录入 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { int id = MyCommFun.Str2Int(hidid.Value); #region 商品基本信息 string strErr = ""; if (this.txtproductName.Text.Trim().Length == 0) { strErr += "商品名称不能为空!\\n"; } if (!MyCommFun.isDecimal(txtcostPrice.Text)) { strErr += "成本格式错误!\\n"; } if (!MyCommFun.isDecimal(txtmarketPrice.Text)) { strErr += "市场价格式错误!\\n"; } if (!MyCommFun.isDecimal(txtsalePrice.Text)) { strErr += "销售价格式错误!\\n"; } if (!MyCommFun.isNumber(txtstock.Text)) { strErr += "库存格式错误!\\n"; } if (!MyCommFun.isNumber(txtsort_id.Text)) { strErr += "排序号格式错误!\\n"; } if (strErr != "") { JscriptMsg(strErr, "back", "Error"); return; } Model.wx_userweixin weixin = GetWeiXinCode(); int wid = weixin.id; int categoryId = int.Parse(this.ddlCategoryId.SelectedItem.Value); int catalogId = int.Parse(this.ddlCatalog.SelectedItem.Value); int brandId = 0; string sku = this.txtsku.Text;//货号 if (sku.Trim() == "") { sku = Utils.Number(8, true); } string productName = this.txtproductName.Text; string shortDesc = this.txtshortDesc.Text; string unit = ""; decimal weight = 0; string description = this.txtdescription.Value; //string seo_title = this.txtseo_title.Text; //string seo_keywords = this.txtseo_keywords.Text; //string seo_description = this.txtseo_description.Text; //string focusImgUrl = this.txtfocusImgUrl.Text; //string thumbnailsUrll = this.txtthumbnailsUrll.Text; bool recommended = false; bool latest = false; bool hotsale = false; bool specialOffer = false; int count = cblActionType.Items.Count; for (int i = 0; i < count; i++) { if (cblActionType.Items[i].Selected) { if (cblActionType.Items[i].Value == "latest") { latest = true; } else if (cblActionType.Items[i].Value == "hotsale") { hotsale = true; } else if (cblActionType.Items[i].Value == "recommended") { recommended = true; } else if (cblActionType.Items[i].Value == "specialOffer") { specialOffer = true; } } } decimal costPrice = decimal.Parse(this.txtcostPrice.Text); decimal marketPrice = decimal.Parse(this.txtmarketPrice.Text); decimal salePrice = decimal.Parse(this.txtsalePrice.Text); bool upselling = true;//上架 if (radType.SelectedItem.Value == "2") { upselling = false; } int stock = int.Parse(this.txtstock.Text); DateTime addDate = DateTime.Now; int vistiCounts = 0; int sort_id = int.Parse(this.txtsort_id.Text); //DateTime productionDate = DateTime.Parse(this.txtproductionDate.Text); //DateTime ExpiryEndDate = DateTime.Parse(this.txtExpiryEndDate.Text); DateTime updateDate = DateTime.Now; WechatBuilder.Model.wx_shop_product model = spBll.GetModel(id); // model.wid = wid; model.categoryId = categoryId; model.brandId = brandId; model.sku = sku; model.productName = productName; model.shortDesc = shortDesc; model.unit = unit; model.weight = weight; model.description = description; //model.seo_title = seo_title; //model.seo_keywords = seo_keywords; //model.seo_description = seo_description; //model.focusImgUrl = focusImgUrl; //model.thumbnailsUrll = thumbnailsUrll; model.recommended = recommended; model.latest = latest; model.hotsale = hotsale; model.specialOffer = specialOffer; model.costPrice = costPrice; model.marketPrice = marketPrice; model.salePrice = salePrice; model.upselling = upselling; model.stock = stock; model.addDate = addDate; model.vistiCounts = vistiCounts; model.sort_id = sort_id; //model.productionDate = productionDate; //model.ExpiryEndDate = ExpiryEndDate; model.updateDate = updateDate; model.catalogId = catalogId; #endregion #region 保存相册==================== //检查是否有自定义图片 if (model.albums != null) { model.albums.Clear(); } string[] albumArr = Request.Form.GetValues("hid_photo_name"); string[] remarkArr = Request.Form.GetValues("hid_photo_remark"); if (albumArr != null) { List <Model.wx_shop_albums> ls = new List <Model.wx_shop_albums>(); for (int i = 0; i < albumArr.Length; i++) { string[] imgArr = albumArr[i].Split('|'); int img_id = Utils.StrToInt(imgArr[0], 0); if (imgArr.Length == 3) { if (!string.IsNullOrEmpty(remarkArr[i])) { ls.Add(new Model.wx_shop_albums { id = img_id, productId = id, original_path = imgArr[1], thumb_path = imgArr[2], remark = remarkArr[i] }); } else { ls.Add(new Model.wx_shop_albums { id = img_id, productId = id, original_path = imgArr[1], thumb_path = imgArr[2] }); } } } model.albums = ls; } #endregion //属性和sku配件列表 model.attrs = AddAttr(); model.skulist = AddSku(); WechatBuilder.BLL.wx_shop_product bll = new WechatBuilder.BLL.wx_shop_product(); bll.Update(model); AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "编辑商品信息,商品信息主键id:" + id); //记录日志 string frompage = MyCommFun.QueryString("frompage"); JscriptMsg("***商品编辑成功***!", frompage, "Success"); }
protected void Button1_Click(object sender, EventArgs e) { DateTime begin = DateTime.Parse(begindate.Text.Trim()); DateTime end = DateTime.Parse(enddate.Text.Trim()); if (begin >= end) { JscriptMsg("开始时间必须小于结束时间", "back", "Error"); return; } //base表 Model.wx_userweixin weixin = GetWeiXinCode(); int wid = weixin.id; BLL.wx_vote_base votebaseBll = new BLL.wx_vote_base(); Model.wx_vote_base votebase = new Model.wx_vote_base(); votebase.wid = wid; votebase.title = this.title.Text.ToString(); votebase.votepic = this.votepic.Text.ToString(); votebase.picdisplay = Convert.ToBoolean(this.picdisplay.SelectedValue); //是否显示在投票页面 votebase.votecontent = this.txtactContent.InnerText.ToString(); //投票说明 votebase.isRadio = Convert.ToBoolean(this.Radio.SelectedValue); if (this.begindate.Text.ToString() != "") { votebase.beginTime = Convert.ToDateTime(this.begindate.Text.ToString()); } if (this.enddate.Text.ToString() != "") { votebase.endTime = Convert.ToDateTime(this.enddate.Text.ToString()); } votebase.resultShowtype = Convert.ToInt32(this.resultShowtype.SelectedValue); votebase.actUrl = ""; votebase.voteType = 1;//文本投票 votebase.creatDate = DateTime.Now; votebase.actUrl = MyCommFun.getWebSite() + "/admin/vote/vote_list.aspx?wid=" + wid + "&aid="; int baseid = votebaseBll.Add(votebase); //item表 BLL.wx_vote_item voteitemBll = new BLL.wx_vote_item(); Model.wx_vote_item voteitem = new Model.wx_vote_item(); int sid = 0; TextBox xuanxtitle; TextBox Sortid; int totJxNum = 0; for (int i = 1; i <= 6; i++) { xuanxtitle = this.FindControl("xuanxtitle" + i) as TextBox; Sortid = this.FindControl("Sortid" + i) as TextBox; if (xuanxtitle.Text.Trim() != "" && Sortid.Text.Trim() != "" && MyCommFun.isNumber(Sortid.Text.Trim())) { totJxNum++; } } decimal avgDeg = (decimal)360.0 / (totJxNum + 1); for (int i = 1; i <= 6; i++) { xuanxtitle = this.FindControl("xuanxtitle" + i) as TextBox; Sortid = this.FindControl("Sortid" + i) as TextBox; if (xuanxtitle.Text.Trim() != "" && Sortid.Text.Trim() != "" && MyCommFun.isNumber(Sortid.Text.Trim())) { sid++; voteitem.sid = sid; voteitem.baseid = baseid; voteitem.title = xuanxtitle.Text.ToString(); voteitem.sort_id = MyCommFun.Str2Int(Sortid.Text.ToString()); voteitem.createDate = DateTime.Now; voteitemBll.Add(voteitem); } } // createDate AddAdminLog(MXEnums.ActionEnum.Delete.ToString(), "增加文字投票,id为" + baseid); //记录日志 JscriptMsg("添加成功", "vote_list.aspx", "Success"); }
/// <summary> /// 添加奖品项目 /// </summary> private void EditAwardItem(int ggkId) { //1删除原来的,2新增 iBll.DeleteByActId(ggkId); Model.wx_ggkAwardItem item = new Model.wx_ggkAwardItem(); TextBox txtJXName; TextBox txtJPName; TextBox txtNum; TextBox txtRealNum; int sort_id = 0; for (int i = 1; i <= 6; i++) { txtJXName = this.FindControl("txt" + i + "JXName") as TextBox; txtJPName = this.FindControl("txt" + i + "JPName") as TextBox; txtNum = this.FindControl("txt" + i + "Num") as TextBox; txtRealNum = this.FindControl("txt" + i + "RealNum") as TextBox; if (txtJXName.Text.Trim() != "" && txtJPName.Text.Trim() != "" && txtNum.Text.Trim() != "" && txtRealNum.Text.Trim() != "" && MyCommFun.isNumber(txtNum.Text) && MyCommFun.isNumber(txtRealNum.Text)) { sort_id++; //那么添加奖品信息 item.jxName = txtJXName.Text.Trim(); item.sort_id = sort_id; item.jpName = txtJPName.Text.Trim(); item.jpNum = MyCommFun.Str2Int(txtNum.Text.Trim()); item.jpRealNum = MyCommFun.Str2Int(txtRealNum.Text.Trim()); item.actId = ggkId; item.createDate = DateTime.Now; iBll.Add(item); } } }
private void EditAwardItem(int dzpId) { //1删除原来的,2新增 iBll.DeleteByActId(dzpId); Model.wx_zjdAwardItem item = new Model.wx_zjdAwardItem(); TextBox txtJXName; TextBox txtJPName; TextBox txtNum; TextBox txtRealNum; TextBox txtXSName; int sort_id = 0; int totJxNum = 0; //一共有多少奖项 for (int i = 1; i <= 6; i++) { txtJXName = this.FindControl("txt" + i + "JXName") as TextBox; txtXSName = this.FindControl("txt" + i + "XSName") as TextBox; txtRealNum = this.FindControl("txt" + i + "RealNum") as TextBox; txtJPName = this.FindControl("txt" + i + "JPName") as TextBox; txtNum = this.FindControl("txt" + i + "Num") as TextBox; if (txtJXName.Text.Trim() != "" && txtNum.Text.Trim() != "" && txtRealNum.Text.Trim() != "" && MyCommFun.isNumber(txtNum.Text) && MyCommFun.isNumber(txtRealNum.Text)) { totJxNum++; } } for (int i = 1; i <= 6; i++) { txtJXName = this.FindControl("txt" + i + "JXName") as TextBox; //奖品名称 txtXSName = this.FindControl("txt" + i + "XSName") as TextBox; //显示实际数量 txtRealNum = this.FindControl("txt" + i + "RealNum") as TextBox; //实际数量 txtJPName = this.FindControl("txt" + i + "JPName") as TextBox; //重命名 txtNum = this.FindControl("txt" + i + "Num") as TextBox; //图片 if (txtJXName.Text.Trim() != "" && txtNum.Text.Trim() != "" && txtRealNum.Text.Trim() != "" && MyCommFun.isNumber(txtRealNum.Text)) { sort_id++; //那么添加奖品信息 item.jxName = txtJXName.Text.Trim(); //奖品 item.sort_id = sort_id; item.jpNum = MyCommFun.Str2Int(txtXSName.Text.Trim()); //奖品数量 item.jpRealNum = MyCommFun.Str2Int(txtRealNum.Text.Trim()); //奖品数量 item.jpName = txtJPName.Text.Trim(); //奖品重命名 item.jiangpinpic = txtNum.Text.Trim(); //图片 item.actId = dzpId; item.createDate = DateTime.Now; //item.jiaodu_min = avgDeg * sort_id; iBll.Add(item); } } }
protected void Button1_Click(object sender, EventArgs e) { DateTime begin = DateTime.Parse(begindate.Text.Trim()); DateTime end = DateTime.Parse(enddate.Text.Trim()); if (begin >= end) { JscriptMsg("开始时间必须小于结束时间", "back", "Error"); return; } int id = Convert.ToInt32(Request.Params["id"]); BLL.wx_vote_base basebll = new BLL.wx_vote_base(); Model.wx_vote_base votebase = new Model.wx_vote_base(); votebase.id = id; votebase.title = this.title.Text.ToString(); votebase.votepic = this.votepic.Text.ToString(); votebase.picdisplay = Convert.ToBoolean(this.picdisplay.SelectedValue); votebase.votecontent = this.txtactContent.InnerText; votebase.isRadio = Convert.ToBoolean(this.Radio.SelectedValue); if (this.begindate.Text.ToString() != "") { votebase.beginTime = Convert.ToDateTime(this.begindate.Text.ToString()); } if (this.enddate.Text.ToString() != "") { votebase.endTime = Convert.ToDateTime(this.enddate.Text.ToString()); } votebase.resultShowtype = Convert.ToInt32(this.resultShowtype.SelectedValue); votebase.actUrl = this.actUrl.Text; votebase.voteType = 1; basebll.Update(votebase); BLL.wx_vote_item itembll = new BLL.wx_vote_item(); Model.wx_vote_item voteitem = new Model.wx_vote_item(); // voteitem.sid= itembll.Delete(id);//删除 //编辑 int sid = 0; TextBox xuanxtitle; TextBox Sortid; HiddenField toupiaoTimes; for (int i = 1; i <= 6; i++) { xuanxtitle = this.FindControl("xuanxtitle" + i) as TextBox; Sortid = this.FindControl("Sortid" + i) as TextBox; toupiaoTimes = this.FindControl("toupiaoTimes" + i) as HiddenField; if (xuanxtitle.Text.Trim() != "" && Sortid.Text.Trim() != "" && MyCommFun.isNumber(Sortid.Text.Trim())) { sid++; voteitem.sid = sid; voteitem.baseid = id; voteitem.title = xuanxtitle.Text.ToString(); voteitem.sort_id = MyCommFun.Str2Int(Sortid.Text.ToString()); voteitem.createDate = DateTime.Now; voteitem.tpTimes = MyCommFun.Str2Int(toupiaoTimes.Value); itembll.Add(voteitem); } } AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改文字投票,id为" + id); //记录日志 JscriptMsg("修改成功!", Utils.CombUrlTxt("vote_list.aspx", "keywords={0}", ""), "Success"); }