/// <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");
}
