public void ShowActivityInfo(string strID) { SubjectDAL dal = new SubjectDAL(); DataSet ds = dal.GetVoteDetail(strID, Session["strSiteCode"].ToString()); VOTE_Subject model = DataConvert.DataRowToModel <VOTE_Subject>(ds.Tables[0].Rows[0]); this.txtName.Text = model.Subject; this.hd_content.Value = model.Content; starttime.Text = model.BeginTime.ToString("yyyy-MM-dd"); endtime.Text = model.EndTime.ToString("yyyy-MM-dd"); optionlist = ""; DataSet optionds = dal.GetOptionsData(strID); optionlist += "<table id=\"MyOption\">"; if (optionds != null && optionds.Tables.Count > 0 && optionds.Tables[0].Rows.Count > 0) { optionlist += "<script type=\"text/javascript\">"; for (int i = 0; i < optionds.Tables[0].Rows.Count; i++) { string opname = optionds.Tables[0].Rows[i]["Title"].ToString(); string opid = optionds.Tables[0].Rows[i]["ID"].ToString(); string order = optionds.Tables[0].Rows[i]["Order"].ToString(); if (optionds.Tables[0].Rows.Count > 2 && Common.Common.NoHtml(Request["action"]) != "show") { optionlist += "AddRow(\"" + opname + "\",\"" + opid + "\",\"" + order + "\",\"del\");"; } else { optionlist += "AddRow(\"" + opname + "\",\"" + opid + "\",\"" + order + "\",\"\");"; } } optionlist += "</script>"; } optionlist += "</table>"; if (strAction == "show") { this.btnReset.Visible = false; this.btnSave.Visible = false; starttime.ReadOnly = true; endtime.ReadOnly = true; txtName.ReadOnly = true; } else { starttime.Attributes.Add("onclick", "WdatePicker()"); endtime.Attributes.Add("onclick", "WdatePicker()"); } }
/// <summary> /// 添加投票 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddVoteinfo(VOTE_Subject model) { string sql = @"INSERT INTO [VOTE_Subject] ([ID] ,[Subject] ,[Content] ,[Type] ,[SiteCode] ,[BeginTime] ,[EndTime] ,[CreateTime] ,[IsValid]) VALUES (@ID ,@Subject ,@Content ,@Type ,@SiteCode ,@BeginTime ,@EndTime ,@CreateTime ,@IsValid)"; System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@ID", model.ID), new System.Data.SqlClient.SqlParameter("@Subject", model.Subject), new System.Data.SqlClient.SqlParameter("@Content", model.Content), new System.Data.SqlClient.SqlParameter("@Type", model.Type), new System.Data.SqlClient.SqlParameter("@SiteCode", model.SiteCode), new System.Data.SqlClient.SqlParameter("@BeginTime", model.BeginTime), new System.Data.SqlClient.SqlParameter("@EndTime", model.EndTime), new System.Data.SqlClient.SqlParameter("@CreateTime", DateTime.Now), new System.Data.SqlClient.SqlParameter("@IsValid", model.IsValid) }; int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras); if (rowsAffected > 0) { return(true); } else { return(false); } }
public void saveupdate() { string strID = Guid.NewGuid().ToString("N").ToUpper(); VOTE_Subject model = new VOTE_Subject(); model.ID = strID; model.Subject = Common.Common.NoHtml(Request["txtName"]); model.SiteCode = GlobalSession.strSiteCode; model.Content = Common.Common.NoHtml(Request["Content"]); model.BeginTime = Convert.ToDateTime(Request["BeginTime"]); model.EndTime = Convert.ToDateTime(Request["endtime"]); model.IsValid = Convert.ToInt32(Common.Common.NoHtml(Request["IsValid"])); SubjectDAL dal = new SubjectDAL(); if (dal.AddVoteinfo(model)) { if (Common.Common.NoHtml(Request["Option0"]) != null && Common.Common.NoHtml(Request["Option0"]) != "") { OptionDAL optdal = new OptionDAL(); VOTE_Option optmoedl = new VOTE_Option(); for (int i = 0; i < 6; i++) { optmoedl.Title = Common.Common.NoHtml(Request["Option" + i]); if (Common.Common.NoHtml(Request["Order" + i]) != null && Common.Common.NoHtml(Request["Order" + i]) != "") { optmoedl.Order = Convert.ToInt32(Common.Common.NoHtml(Request["Order" + i])); } optmoedl.ID = Guid.NewGuid().ToString("N").ToUpper(); optmoedl.SubjectID = strID; if (Common.Common.NoHtml(Request["Option" + i]) != null && Common.Common.NoHtml(Request["Option" + i]) != "") { optdal.AddVoteOption(optmoedl); } } } Response.Write("{\"success\":\"true\"}"); } else { Response.Write("{\"success\":\"操作失败\"}"); } Response.End(); }
/// <summary> /// 更新投票信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateVoteInfo(VOTE_Subject model) { string safesql = ""; safesql = "update VOTE_Subject set "; if (model.Subject != null) { safesql += "Subject='" + model.Subject + "',"; } if (model.SiteCode != null) { safesql += "SiteCode='" + model.SiteCode + "',"; } if (model.Content != null) { safesql += "Content='" + model.Content + "',"; } if (model.BeginTime != null) { safesql += "BeginTime='" + model.BeginTime.ToString("yyyy-MM-dd") + "',"; } if (model.EndTime != null) { safesql += "EndTime='" + model.EndTime.ToString("yyyy-MM-dd") + "',"; } safesql += "CreateTime='" + DateTime.Now + "' where id='" + model.ID + "'"; int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
void getvoteDetail() { // DAL.Vote.IndexDAL dalIndex = new IndexDAL(); strSubjectID = dalIndex.GetSubjectData(strID); if (string.IsNullOrEmpty(strSubjectID)) { return; } //取投票主题与选项 DAL.Vote.SubjectDAL dalSubject = new DAL.Vote.SubjectDAL(); DataSet dsSubject = dalSubject.GetVoteDetail(strSubjectID,strSiteCode); if (null != dsSubject && dsSubject.Tables.Count > 0 && dsSubject.Tables[0].Rows.Count > 0) { strSubjectID = dsSubject.Tables[0].Rows[0]["ID"].ToString(); strSubjectTitle = dsSubject.Tables[0].Rows[0]["Subject"].ToString(); strSubjectContent = dsSubject.Tables[0].Rows[0]["Content"].ToString(); strEndTime = dsSubject.Tables[0].Rows[0]["EndTime"].ToString(); if (Convert.ToDateTime(strEndTime) > DateTime.Now) { strEndTime = "show"; } } else { return; } List<Model.Vote.VOTE_Option> liOption = new List<Model.Vote.VOTE_Option>(); DataSet dsOptions = dalSubject.GetOptionsData(strSubjectID); if (null != dsOptions && dsOptions.Tables.Count > 0 && dsOptions.Tables[0].Rows.Count > 0) { foreach (DataRow row in dsOptions.Tables[0].Rows) { Model.Vote.VOTE_Option model = DataConvert.DataRowToModel<Model.Vote.VOTE_Option>(row); liOption.Add(model); } } List<VOTE_Subject> lisubjectlist = new List<VOTE_Subject>(); DataSet dssublist = dalSubject.GetSubjectDataList(strSiteCode); int sublistcount = dssublist.Tables[0].Rows.Count; if (null != dssublist && dssublist.Tables.Count > 0 && dssublist.Tables[0].Rows.Count > 0) { foreach (DataRow row in dssublist.Tables[0].Rows) { VOTE_Subject model = DataConvert.DataRowToModel<VOTE_Subject>(row); lisubjectlist.Add(model); } } //读取模板内容 string text = string.Empty; if (!File.Exists(Server.MapPath("Themes/" + strTheme + "/Vote.html"))) { text = System.IO.File.ReadAllText(Server.MapPath("Themes/Vote/Vote.html")); } else { text = System.IO.File.ReadAllText(Server.MapPath("Themes/" + strTheme + "/Vote.html")); } JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["title"] = strTitle; context.TempData["siteid"] = Session["siteid"]; context.TempData["footer"] = "奥琦微商易"; context.TempData["sitecode"] =strSiteCode; context.TempData["openid"] = strOpenID; context.TempData["subjectID"] = strSubjectID; context.TempData["SubjectTitle"] = strSubjectTitle; context.TempData["SubjectContent"] = strSubjectContent; context.TempData["SubjectEndTime"] = strEndTime; context.TempData["option_list"] = liOption; context.TempData["subjectlist"] = lisubjectlist; context.TempData["sublistcount"] = sublistcount; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }
public void saveupdate() { VOTE_Subject model = new VOTE_Subject(); model.ID = strID; model.Subject = Common.Common.NoHtml(Request["txtName"]); model.SiteCode = GlobalSession.strSiteCode; model.Content = Common.Common.NoHtml(Request["Content"]); model.BeginTime = Convert.ToDateTime(Request["BeginTime"]); model.EndTime = Convert.ToDateTime(Request["endtime"]); SubjectDAL dal = new SubjectDAL(); if (dal.UpdateVoteInfo(model)) { if (Common.Common.NoHtml(Request["Option0"]) != null && Common.Common.NoHtml(Request["Option0"]) != "") { OptionDAL optdal = new OptionDAL(); VOTE_Option optmoedl = new VOTE_Option(); int listlength = 0; optmoedl.IsDel = 1; if (Request["listlength"] != null && Request["listlength"] != "") { listlength = Convert.ToInt32(Common.Common.NoHtml(Request["listlength"])); } for (int i = 0; i < listlength; i++) { string optiontitle = string.Empty; string optionID = string.Empty; string optionOrder = string.Empty; try { optiontitle = Common.Common.NoHtml(Request["Option" + i]); } catch (Exception) { } try { optionID = Common.Common.NoHtml(Request["Option" + i + "ID"]); } catch (Exception) { } try { optionOrder = Common.Common.NoHtml(Request["Order" + i]); } catch (Exception) {} if (optiontitle != null && optiontitle != "") { optmoedl.Title = optiontitle; if (optionOrder != null && optionOrder != "") { optmoedl.Order = Convert.ToInt32(optionOrder); } if (optdal.IsexistOption(optionID)) { optmoedl.ID = optionID; optdal.UpdateOption(optmoedl); } else if (optdal.ExistOptionTile(optiontitle)) { Response.Write("{\"success\":\"该选项已经存在\"}"); } else { optmoedl.ID = Guid.NewGuid().ToString("N").ToUpper(); optmoedl.SubjectID = strID; if (optiontitle != null && optiontitle != "") { optdal.AddVoteOption(optmoedl); } } } } } Response.Write("{\"success\":\"true\"}"); } else { Response.Write("{\"success\":\"修改失败\"}"); } Response.End(); }