/// <summary>
/// 获得幻灯片列表二：优点：（1）使用function标签与foreach结合，可以从模版页面控制记录数量；（2）不需要实现注册到模版里
/// </summary>
/// <returns></returns>
public IList <Model.wx_shop_indexbanner> getHdp()
{
Tag tag = this.Document.CurrentRenderingTag;
var attribute = tag.Attributes["rows"];
IList <Model.wx_shop_indexbanner> artlist = new List <Model.wx_shop_indexbanner>();
int rows = -1;//若为-1，则不做限制条件
if (attribute != null && MyCommFun.isNumber(attribute.Value.GetValue()))
{
rows = MyCommFun.Obj2Int(attribute.Value.GetValue());
}
MxWeiXinPF.DAL.wx_shop_indexbanner sibDal = new DAL.wx_shop_indexbanner();
artlist = sibDal.GetHDPByWid(wid, rows);
if (artlist != null && artlist.Count > 0)
{
Model.wx_shop_indexbanner cat = new Model.wx_shop_indexbanner();
for (int i = 0; i < artlist.Count; i++)
{
cat = artlist[i];
if (cat.bannerLinkUrl == null || cat.bannerLinkUrl.Trim() == "")
{ //如果link_url为空，则直接调用本系统的信息
cat.bannerLinkUrl = "javascript:;";
}
else
{
cat.bannerLinkUrl = MyCommFun.urlAddOpenid(cat.bannerLinkUrl, openid);
}
}
}
return(artlist);
}
/// <summary>
/// 取幻灯片信息
/// </summary>
/// <param name="wid"></param>
/// <param name="topNum">取前几条数据，若为-1，则取全部的数据</param>
public IList <Model.wx_shop_indexbanner> GetHDPByWid(int wid, int topNum)
{
IList <Model.wx_shop_indexbanner> hdpList = new List <Model.wx_shop_indexbanner>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (topNum >= 0)
{
strSql.Append(" top " + topNum + " ");
}
strSql.Append(" * from wx_shop_indexbanner ");
strSql.Append(" where wid=@wid order by sort_id asc,id asc");
SqlParameter[] parameters =
{
new SqlParameter("@wid", SqlDbType.Int, 4)
};
parameters[0].Value = wid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
Model.wx_shop_indexbanner hdp = new Model.wx_shop_indexbanner();
while (sr.Read())
{
hdp = new Model.wx_shop_indexbanner();
hdp.id = MyCommFun.Obj2Int(sr["id"]);
hdp.bannerName = MyCommFun.ObjToStr(sr["bannerName"]);
hdp.bannerPicUrl = MyCommFun.ObjToStr(sr["bannerPicUrl"]);
hdp.bannerLinkUrl = MyCommFun.ObjToStr(sr["bannerLinkUrl"]);
hdp.remark = MyCommFun.ObjToStr(sr["remark"]);
hdp.sort_id = MyCommFun.Obj2Int(sr["sort_id"]);
hdpList.Add(hdp);
}
sr.Close();
return(hdpList);
}
private void ShowInfo(int id)
{
hidid.Value = id.ToString();
Model.wx_shop_indexbanner photo = pBll.GetModel(id);
hidid.Value = photo.id.ToString();
txtpName.Text = photo.bannerName.ToString();
txtLinkUrl.Text = photo.bannerLinkUrl;
txtpContent.Value = photo.remark.ToString();
txtseq.Text = photo.sort_id.Value.ToString();
//封面图片
if (photo.bannerPicUrl != null && photo.bannerPicUrl.Trim() != "/images/noneimg.jpg")
{
txtImgUrl.Text = photo.bannerPicUrl;
imgfacePicPic.ImageUrl = photo.bannerPicUrl;
}
}
//保存
protected void btnSubmit_Click(object sender, EventArgs e)
{
int id = MyCommFun.Str2Int(hidid.Value);
#region //先判断
string strErr = "";
if (this.txtpName.Text.Trim().Length == 0)
{
strErr += "图片名称不能为空！";
}
if (this.txtImgUrl.Text.Trim().Length == 0)
{
strErr += "图片不能为空！";
}
if (strErr != "")
{
JscriptMsg(strErr, "back", "Error");
return;
}
#endregion
#region 赋值
Model.wx_shop_indexbanner photo = new Model.wx_shop_indexbanner();
if (id > 0)
{
photo = pBll.GetModel(id);
}
string facePicc = imgfacePicPic.ImageUrl;
if (txtImgUrl.Text.Trim() != "")
{
facePicc = txtImgUrl.Text.Trim();
}
Model.wx_userweixin weixin = GetWeiXinCode();
photo.wid = weixin.id;
photo.bannerName = txtpName.Text.Trim();
photo.remark = txtpContent.Value.Trim();
photo.bannerLinkUrl = txtLinkUrl.Text.Trim();
photo.bannerPicUrl = facePicc;
photo.sort_id = MyCommFun.Str2Int(txtseq.Text.Trim());
#endregion
if (id <= 0)
{ //新增
photo.createDate = DateTime.Now;
//1新增主表
id = pBll.Add(photo);
AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "添加相册--图片信息，主键为" + id); //记录日志
JscriptMsg("添加相册--图片信息成功！", "banner_list.aspx", "Success");
}
else
{ //修改
pBll.Update(photo);
AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改相册--图片信息，主键为" + id); //记录日志
JscriptMsg("修改相册--图片信息成功！", "banner_list.aspx", "Success");
}
}
