/// <summary>
/// 获取投票列表项目
/// </summary>
public void VoteListPage()
{
int ovtebase_id = MyCommFun.RequestInt("aid");
//--=====begin: 将这个列表（文章类别）的基本信息展示出来 ====--
Model.wx_vote_base voteBase = tDal.GetVoteBaseByWid(wid, ovtebase_id);
this.Document.SetValue("voteBase", voteBase);
string whereStr = " baseid=" + ovtebase_id;
DataSet voteList = new DataSet();
if (ovtebase_id != 0)
{
DAL.wx_vote_item artDal = new DAL.wx_vote_item();
voteList = artDal.GetList(whereStr);
if (voteList != null && voteList.Tables.Count > 0 && voteList.Tables[0].Rows.Count > 0)
{
DataRow dr;
for (int i = 0; i < voteList.Tables[0].Rows.Count; i++)
{
dr = voteList.Tables[0].Rows[i];
voteList.AcceptChanges();
}
}
}
DAL.wx_vote_item tosum = new DAL.wx_vote_item();
int votesum = tosum.GetFieldSum("tpTimes", whereStr);
this.Document.SetValue("voteList", voteList);
this.Document.SetValue("votesum", votesum);
}
public void BindData(int wid, int aid, string openid)
{
//基本表信息
BLL.wx_vote_base baseBll = new BLL.wx_vote_base();
baseinfo = baseBll.GetModel(aid);
if (baseinfo == null)
{
return;
}
//投票选项字符串设置\
BLL.wx_vote_item itemBll = new BLL.wx_vote_item();
IList<Model.wx_vote_item> itemlist = itemBll.GetModelList("baseid=" + baseinfo.id );
if (itemlist == null || itemlist.Count <= 0)
{
return;
}
ItemListStr(itemlist,openid);
}
public void BindData(int wid, int aid, string openid)
{
//基本表信息
BLL.wx_vote_base baseBll = new BLL.wx_vote_base();
baseinfo = baseBll.GetModel(aid);
if (baseinfo == null)
{
return;
}
//投票选项字符串设置\
BLL.wx_vote_item itemBll = new BLL.wx_vote_item();
IList <Model.wx_vote_item> itemlist = itemBll.GetModelList("baseid=" + baseinfo.id);
if (itemlist == null || itemlist.Count <= 0)
{
return;
}
ItemListStr(itemlist, openid);
}
/// <summary>
///
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
switch (e.CommandName)
{
case "end":
{
int id = int.Parse(e.CommandArgument.ToString());
Model.wx_vote_base baseinfo = gbll.GetModel(id);
if (baseinfo.endTime <= DateTime.Now)
{
}
else
{
gbll.UpdateField(id, "endTime='" + DateTime.Now + "'");
}
}
break;
}
JscriptMsg("操作成功", Utils.CombUrlTxt("vote_list.aspx", "typeid={0}&keywords={1}", ddlProperty.SelectedValue, this.txtKeywords.Text), "Success");
}
public void BindData(int wid, int aid, string openid)
{
//基本表信息
BLL.wx_vote_base baseBll = new BLL.wx_vote_base();
List <Model.wx_vote_base> mlist = baseBll.GetModelList(string.Format(" id={0} and wid={1} ", aid, wid));
if (mlist.Count <= 0 || mlist == null)
{
return;
}
baseinfo = mlist[0];
//投票选项字符串设置
BLL.wx_vote_item itemBll = new BLL.wx_vote_item();
IList <Model.wx_vote_item> itemlist = itemBll.GetModelList("baseid=" + baseinfo.id);
if (itemlist == null || itemlist.Count <= 0)
{
return;
}
ItemListStr(itemlist, openid);
}
/// <summary>
/// 获得投票信息
/// </summary>
/// <param name="wid"></param>
/// <param name="id"></param>
/// <returns></returns>
public Model.wx_vote_base GetVoteBaseByWid(int wid, int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1");
strSql.Append(" * ");
strSql.Append(" from wx_vote_base where id=@id and wId=@wId");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@wId", SqlDbType.Int, 4)
};
parameters[0].Value = id;
parameters[1].Value = wid;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
Model.wx_vote_base category = new Model.wx_vote_base();
while (sr.Read())
{
category = new Model.wx_vote_base();
category.id = MyCommFun.Obj2Int(sr["id"]);
category.title = MyCommFun.ObjToStr(sr["title"]);
category.votepic = MyCommFun.ObjToStr(sr["votepic"]);
category.picdisplay = MyCommFun.ObjBool(sr["picdisplay"]);
category.votecontent = MyCommFun.ObjToStr(sr["votecontent"]);
category.isRadio = MyCommFun.ObjBool(sr["isRadio"]);
category.beginTime = MyCommFun.Obj2DateTime(sr["beginTime"]);
category.endTime = MyCommFun.Obj2DateTime(sr["endTime"]);
category.resultShowtype = MyCommFun.Obj2Int(sr["resultShowtype"]);
category.actUrl = MyCommFun.ObjToStr(sr["actUrl"]);
category.voteType = MyCommFun.Obj2Int(sr["voteType"]);
category.sort_id = MyCommFun.Obj2Int(sr["sort_id"]);
category.creatDate = MyCommFun.Obj2DateTime(sr["creatDate"]);
}
sr.Close();
return(category);
}
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");
}
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");
}
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");
}
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");
}
