public void Del(int id) { Tunnel.BLL.Tunnel_Vote tv = new Tunnel.BLL.Tunnel_Vote(); Tunnel.BLL.Tunnel_VoteRe tvr = new Tunnel.BLL.Tunnel_VoteRe(); List <Tunnel.Model.Tunnel_VoteRe> tvrList = tvr.GetModelList("vate_voteId=" + id + ""); foreach (Tunnel.Model.Tunnel_VoteRe item in tvrList) { tvr.Delete(item.vote_Id); } Tunnel.BLL.Tunnel_Votei tvi = new Tunnel.BLL.Tunnel_Votei(); List <Tunnel.Model.Tunnel_Votei> tviList = tvi.GetModelList("ivote_voteId=" + id + ""); foreach (Tunnel.Model.Tunnel_Votei item in tviList) { tvi.Delete(item.ivote_Id); } tv.Delete(id); Tunnel.BLL.Tunnel_Remind tr = new Tunnel.BLL.Tunnel_Remind(); Tunnel.Model.Tunnel_Remind trr = new Tunnel.Model.Tunnel_Remind(); List <Tunnel.Model.Tunnel_Remind> trList = new List <Tunnel.Model.Tunnel_Remind>(); trList = tr.GetModelList("m_type=4 and m_typeid=" + id + ""); foreach (Tunnel.Model.Tunnel_Remind item in trList) { tr.Delete(item.m_typeid); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { id = Convert.ToInt32(Request.QueryString["id"].ToString()); Tunnel.BLL.Tunnel_Vote t = new Tunnel.BLL.Tunnel_Vote(); Tunnel.Model.Tunnel_Vote tt = new Tunnel.Model.Tunnel_Vote(); Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); tt = t.GetModel(id); voteTitle = tt.vote_Title; voteUserName = tm.GetModel(Convert.ToInt32(tt.vote_userId)).m_name; voteDate = Convert.ToDateTime(tt.vote_startDate).ToShortDateString(); voteMark = tt.vote_mark; voteMax = tt.vote_max.ToString(); voteType = tt.vote_Type.ToString(); max.Value = voteMax; tvList = tv.GetModelList("ivote_voteId=" + id + ""); Repeater1.DataSource = tvList; Repeater1.DataBind(); if (voteType == "0") { foreach (RepeaterItem item in Repeater1.Items) { ((CheckBox)item.FindControl("CheckBox1")).Visible = false; } } else { foreach (RepeaterItem item in Repeater1.Items) { ((RadioButton)item.FindControl("RadioButton1")).Visible = false; } } Tunnel.BLL.UserLogin ul = new Tunnel.BLL.UserLogin(); bool b = false; foreach (Tunnel.Model.Tunnel_Votei item in tvList) { string[] temp = item.ivote_yesUserId.Split(','); foreach (string item1 in temp) { if (ul.LoginID.ToString() == item1) { b = true; } } } if (b) { //Button1.Text = "查看结果"; Response.Redirect("VoteShow.aspx?id=" + Request.QueryString["id"].ToString()); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { tempId = Convert.ToInt32(Request.QueryString["id"].ToString()); Tunnel.BLL.Tunnel_Vote tv = new Tunnel.BLL.Tunnel_Vote(); voteTitle = tv.GetModel(tempId).vote_Title; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { voteId = Convert.ToInt32(Request.QueryString["id"].ToString()); Tunnel.BLL.Tunnel_Vote t = new Tunnel.BLL.Tunnel_Vote(); Tunnel.Model.Tunnel_Vote tt = new Tunnel.Model.Tunnel_Vote(); Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); tt = t.GetModel(voteId); voteTitle = tt.vote_Title; voteMark = tt.vote_mark; PageBind(); } } }
protected void btnSave_Click(object sender, EventArgs e) { Tunnel.BLL.Tunnel_Vote tv = new Tunnel.BLL.Tunnel_Vote(); Tunnel.Model.Tunnel_Vote tvv = new Tunnel.Model.Tunnel_Vote(); Tunnel.BLL.UserLogin ul = new Tunnel.BLL.UserLogin(); tvv.vote_userId = Convert.ToInt32(ul.LoginID.ToString()); tvv.vote_bumGroup = TextbumId.Value; tvv.vote_startDate = TextBox1.Text.Trim().Length > 0 ? Convert.ToDateTime(TextBox1.Text) : DateTime.Now; tvv.vote_endDate = TextBox2.Text.Trim().Length > 0 ? Convert.ToDateTime(TextBox2.Text) : Convert.ToDateTime(tvv.vote_startDate).AddYears(1); tvv.vote_mark = txtText.Text; tvv.vote_state = 0; tvv.vote_Title = txtTitle.Text; tvv.vote_top = 0; tvv.vote_Type = Convert.ToInt32(DropDownList1.SelectedValue); tvv.vote_max = 1; if (tvv.vote_Type == 1) { if (TextBox3.Text.Length > 0) { tvv.vote_max = Convert.ToInt32(TextBox3.Text.Trim()); } else { tvv.vote_max = 1; } } int relf = tv.Add(tvv); if (relf > 0) { if (CheckBox1.Checked) { #region 发消息给大家////////////////////////////////////// //获得所需参数 string strToIds = tvv.vote_bumGroup; string strTitle = "投票:" + tvv.vote_Title; //写入数据库 if (strToIds != "" && strToIds != "|") { strToIds = strToIds.Split('|')[0].ToString(); if (strToIds.LastIndexOf(',') > 0) { strToIds = strToIds.Remove(strToIds.LastIndexOf(','), 1); } string[] arr = strToIds.Split(','); List <Tunnel.Model.Tunnel_menber> tmList = new List <Tunnel.Model.Tunnel_menber>(); foreach (string item in arr) { Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); tmList = new List <Tunnel.Model.Tunnel_menber>(); tmList = tm.GetModelList("m_bum=" + item + ""); for (int j = 0; j < tmList.Count; j++) { call(strTitle, relf.ToString(), DateTime.Now, tmList[j].m_id); } } } else { List <Tunnel.Model.Tunnel_menber> tmList = new List <Tunnel.Model.Tunnel_menber>(); Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); tmList = tm.GetModelList(""); foreach (Tunnel.Model.Tunnel_menber item in tmList) { call(strTitle, relf.ToString(), DateTime.Now, item.m_id); } } #endregion } Tunnel.Common.Message.Show("添加成功!", "VoteItemsAdd.aspx?id=" + relf + ""); } else { Tunnel.Common.Message.Show("添加失败!"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { id = Convert.ToInt32(Request.QueryString["id"].ToString()); Tunnel.BLL.Tunnel_Vote t = new Tunnel.BLL.Tunnel_Vote(); Tunnel.Model.Tunnel_Vote tt = new Tunnel.Model.Tunnel_Vote(); Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber(); tt = t.GetModel(id); voteTitle = tt.vote_Title; voteUserName = tm.GetModel(Convert.ToInt32(tt.vote_userId)).m_name; voteDate = Convert.ToDateTime(tt.vote_startDate).ToShortDateString(); if (!string.IsNullOrEmpty(tt.vote_mark)) { voteMark = "<img src=../image/info.png width=20px />" + tt.vote_mark; } voteMax = tt.vote_max.ToString(); voteType = tt.vote_Type.ToString(); max.Value = voteMax; tvList = tv.GetModelList("ivote_voteId=" + id + ""); Repeater1.DataSource = tvList; Repeater1.DataBind(); if (voteType == "0") { for (int i = 0; i < Repeater1.Items.Count; i++) { ((CheckBox)Repeater1.Items[i].FindControl("CheckBox1")).Visible = false; } } else { for (int i = 0; i < Repeater1.Items.Count; i++) { ((RadioButton)Repeater1.Items[i].FindControl("RadioButton1")).Visible = false; } } Tunnel.BLL.UserLogin ul = new Tunnel.BLL.UserLogin(); bool b = false; for (int i = 0; i < tvList.Count; i++) { string[] temp = tvList[i].ivote_yesUserId.Split(','); for (int j = 0; j < temp.Length; j++) { if (ul.LoginID.ToString() == temp[j]) { b = true; } } } if (b) { Button1.Text = "查看结果"; } } else { Tunnel.BLL.Tunnel_Vote tv = new Tunnel.BLL.Tunnel_Vote(); List <Tunnel.Model.Tunnel_Vote> tvList = new List <Tunnel.Model.Tunnel_Vote>(); tvList = tv.GetModelList("(getdate()>vote_startDate and getdate()<vote_endDate) and vote_state=0 and vote_top =1 order by vote_startDate desc"); if (tvList.Count > 0) { Response.Redirect("indexvote.aspx?id=" + tvList[0].vote_Id + ""); } } } }