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();
}
