/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnQuery_Click(object sender, EventArgs e)
{
viewpage1.CurrentPageIndex = 1;
this.TxtSurveyName = txtSurveyName.Text.Trim();
if (!string.IsNullOrEmpty(getBackNum.Text.Trim()))
{
this.GetBackNum = NDConvert.ToInt32(getBackNum.Text.Trim());
}
else
{
this.GetBackNum = -1;
}
if (!string.IsNullOrEmpty(ddlSurveyClass.Text.Trim()))
{
this.DdlSurveyClass = NDConvert.ToInt32(ddlSurveyClass.Text.Trim());
}
else
{
this.DdlSurveyClass = -1;
}
this.WdcBeginDate = NDConvert.ToDateTime(wdcBeginDate.Value);
if (NDConvert.ToDateTime(wdcEndDate.Value) == NDConvert.ToDateTime("1900-1-1"))
{
this.WdcEndDate = NDConvert.ToDateTime("2999-12-31");
}
else
{
this.WdcEndDate = NDConvert.ToDateTime(wdcEndDate.Value);
}
BindGridView();
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnQuery_Click(object sender, EventArgs e)
{
if (!CheckData())
{
PageHelper.ShowExceptionMessage(hidInfo.Value);
return;
}
viewpage1.CurrentPageIndex = 1;
this.SurveyName = txtSurveyName.Text.Trim();
this.State = NDConvert.ToInt32(ddlState.SelectedValue);
this.Active = NDConvert.ToInt32(ddlActive.SelectedValue);
this.ClassID = NDConvert.ToInt32(ddlSurveyClass.SelectedValue);
this.BeginDate = NDConvert.ToDateTime(wdcBeginDate.Value);
if (NDConvert.ToDateTime(wdcEndDate.Value) == NDConvert.ToDateTime("1900-1-1"))
{
this.EndDate = NDConvert.ToDateTime("2999-12-31");
}
else
{
this.EndDate = NDConvert.ToDateTime(wdcEndDate.Value);
}
BindGridView();
}
private void CreateChart()
{
this.StatisticsClass = statisticsClass.SelectedValue; //分析类型
this.BeginDate = NDConvert.ToDateTime(wdcBeginDate.Value);
if (NDConvert.ToDateTime(wdcEndDate.Value) == NDConvert.ToDateTime("1900-1-1"))
{
this.EndDate = NDConvert.ToDateTime("2999-12-31");
}
else
{
this.EndDate = NDConvert.ToDateTime(wdcEndDate.Value);
}
Chart chart3DPie = new CreateWebChart().HLACreateChart(true, SeriesChartType.Pie, statisticsClass.SelectedItem.Text, BeginDate, EndDate, StatisticsClass);
chart3DPie.Attributes.Add("id", "chart3DPie");
chart3DPie.ImageUrl = "TempFiles/ChartPic_9";
chartContent.Controls.Add(chart3DPie);
if (IsPostBack)
{
string chart3DPieHtml = "\"" + RenderHTML(chart3DPie).Replace("\"", "'").Replace("\n", "").Replace("\r", "").Replace(" ", "") + "\"";
Anthem.Manager.AddScriptForClientSideEval(string.Format("innerDivAllHtml({0});", chart3DPieHtml));
}
}
/// <summary>
/// 首页数据绑定
/// 作者：姚东
/// 时间：20100924
/// </summary>
private void BindDate()
{
BLL.Query.IndexQuery query = new BLL.Query.IndexQuery();
//绑定问卷调查部分的数据
DataTable surveyDT = null;
surveyDT = query.GetSurveyList();
DataColumn dc = new DataColumn();
dc.ColumnName = "HasAnswered";
surveyDT.Columns.Add(dc);
if (Session["UserGUID"] != null)
{
foreach (DataRow dr in surveyDT.Rows)
{
if (new BLL.Query.IndexQuery().CheckHasAnswered(dr["SID"].ToString(), Session["UserIDClient"].ToString()))
{
dr["HasAnswered"] = "已参加";
}
else
{
dr["HasAnswered"] = "未参加";
}
}
}
rptSurveyMain.DataSource = surveyDT;
rptSurveyMain.DataBind();
//绑定热门问卷部分数据
DataTable hotSurveyDT = query.GetHotSurveyList();
rptHotSurvey.DataSource = hotSurveyDT;
rptHotSurvey.DataBind();
//绑定推荐问卷部分数据
DataTable recommendSurveyDT = query.GetRecommendSurveyList();
if (recommendSurveyDT.Rows.Count > 0)
{
lblRecommendSurveyTitle.Text = string.Format("<a href='#' onclick='window.open(\"Survey/userdata/u1/s{0}.aspx\")'>{1}</a>", recommendSurveyDT.Rows[0]["sid"].ToString(), recommendSurveyDT.Rows[0]["SurveyName"].ToString());
lblRecommendSurveyContent.Text = recommendSurveyDT.Rows[0]["PageContent"].ToString();
lblRecommendSurveyPoint.Text = "赠送积分：" + recommendSurveyDT.Rows[0]["Point"].ToString() + "分";
}
//所有礼品
DataTable giftDT = new BLL.Query.GiftsQuery().GetAllGifts();
rGiftsShow.DataSource = giftDT;
rGiftsShow.DataBind();
//热门礼品
DataTable hotGiftDT = new BLL.Query.GiftsQuery().GetHotGifts();
rHotGift.DataSource = hotGiftDT;
rHotGift.DataBind();
//兑换记录
DataTable hotExchangeHistoryDT = new BLL.Query.ExchangeQuery().GetNewExchangeList();
rExchangeHistory.DataSource = hotExchangeHistoryDT;
rExchangeHistory.DataBind();
//合作伙伴
DataTable partnerDT = new BLL.Query.PartnerQuery().GetOnLinePartner();
rPartner.DataSource = partnerDT;
rPartner.DataBind();
//网站访问频率统计图
Dundas.Charting.WebControl.Chart chart3DPie = new _12355WebChart().CreateChart("F", "", true, SeriesChartType.Pie, "网站访问频率统计分析图");//创建3d饼图
chart3DPie.Width = 450;
chart3DPie.Height = 366;
chart3DPie.Attributes.Add("id", "chart3DPie");
chart3DPie.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPic_1";
chartContent1.Controls.Add(chart3DPie);
//热线咨询统计图
Dundas.Charting.WebControl.Chart chart3DPie2 =
new CreateWebChart().HLACreateChart(true, SeriesChartType.Pie, "热线咨询统计图", NDConvert.ToDateTime("1900-1-1"), NDConvert.ToDateTime("2999-12-31"), "ConsultType");
chart3DPie2.Width = 450;
chart3DPie2.Height = 366;
chart3DPie2.Attributes.Add("id", "chart3DPie");
chart3DPie2.ImageUrl = "Survey/TempFiles/ChartPic_9";
chartContent2.Controls.Add(chart3DPie2);
//1、2010年青年最关注的十大社会现象
Dundas.Charting.WebControl.Chart chart3DPieTop1 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "2010年青年最关注的十大社会现象", "Top1");//创建3d饼图
chart3DPieTop1.Width = 450;
chart3DPieTop1.Height = 366;
chart3DPieTop1.Attributes.Add("id", "chart3DPie");
chart3DPieTop1.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_1";
chartContent3.Controls.Add(chart3DPieTop1);
//2、2010年青年人中十大网络流行语
Dundas.Charting.WebControl.Chart chart3DPieTop2 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "2010年青年人中十大网络流行语", "Top2");//创建3d饼图
chart3DPieTop2.Width = 750;
chart3DPieTop2.Height = 366;
chart3DPieTop2.Attributes.Add("id", "chart3DPie");
chart3DPieTop2.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_2";
chartContent4.Controls.Add(chart3DPieTop2);
//3、当前青年人最关心的十大社会热点问题
Dundas.Charting.WebControl.Chart chart3DPieTop3 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "当前青年人最关心的十大社会热点问题", "Top3");//创建3d饼图
chart3DPieTop3.Width = 450;
chart3DPieTop3.Height = 366;
chart3DPieTop3.Attributes.Add("id", "chart3DPie");
chart3DPieTop3.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_3";
chartContent5.Controls.Add(chart3DPieTop3);
//4、青年人最渴望获得的十大知识和技能
Dundas.Charting.WebControl.Chart chart3DPieTop4 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "青年人最渴望获得的十大知识和技能", "Top4");//创建3d饼图
chart3DPieTop4.Width = 450;
chart3DPieTop4.Height = 366;
chart3DPieTop4.Attributes.Add("id", "chart3DPie");
chart3DPieTop4.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_4";
chartContent6.Controls.Add(chart3DPieTop4);
//5、青年人十大择业标准
Dundas.Charting.WebControl.Chart chart3DPieTop5 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "青年人十大择业标准", "Top5");//创建3d饼图
chart3DPieTop5.Width = 600;
chart3DPieTop5.Height = 366;
chart3DPieTop5.Attributes.Add("id", "chart3DPie");
chart3DPieTop5.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_5";
chartContent7.Controls.Add(chart3DPieTop5);
//6、青年人十大择偶标准
Dundas.Charting.WebControl.Chart chart3DPieTop6 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "青年人十大择偶标准", "Top6");//创建3d饼图
chart3DPieTop6.Width = 450;
chart3DPieTop6.Height = 366;
chart3DPieTop6.Attributes.Add("id", "chart3DPie");
chart3DPieTop6.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_6";
chartContent8.Controls.Add(chart3DPieTop6);
//7、青年人十大消费支出项目
Dundas.Charting.WebControl.Chart chart3DPieTop7 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "青年人十大消费支出项目", "Top7");//创建3d饼图
chart3DPieTop7.Width = 450;
chart3DPieTop7.Height = 366;
chart3DPieTop7.Attributes.Add("id", "chart3DPie");
chart3DPieTop7.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_7";
chartContent9.Controls.Add(chart3DPieTop7);
//8、青年人十大交流工具
Dundas.Charting.WebControl.Chart chart3DPieTop8 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "青年人十大交流工具", "Top8");//创建3d饼图
chart3DPieTop8.Width = 450;
chart3DPieTop8.Height = 366;
chart3DPieTop8.Attributes.Add("id", "chart3DPie");
chart3DPieTop8.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_8";
chartContent10.Controls.Add(chart3DPieTop8);
//9、青年人十大休闲娱乐项目
Dundas.Charting.WebControl.Chart chart3DPieTop9 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "青年人十大休闲娱乐项目", "Top9");//创建3d饼图
chart3DPieTop9.Width = 450;
chart3DPieTop9.Height = 366;
chart3DPieTop9.Attributes.Add("id", "chart3DPie");
chart3DPieTop9.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_9";
chartContent11.Controls.Add(chart3DPieTop9);
//10、青年人十大幸福指数
Dundas.Charting.WebControl.Chart chart3DPieTop10 = new _12355WebChart().CreateTop10Survey(true, SeriesChartType.Pie, "青年人十大幸福指数", "Top10");//创建3d饼图
chart3DPieTop10.Width = 450;
chart3DPieTop10.Height = 366;
chart3DPieTop10.Attributes.Add("id", "chart3DPie");
chart3DPieTop10.ImageUrl = "Web/12355WebVistor/TempFiles/ChartPicTop_10";
chartContent12.Controls.Add(chart3DPieTop10);
}
/// <summary>
/// 绑定答卷类型数据源
/// 作者：韩亮
/// 时间：20100928
/// </summary>
//private void BindData()
//{
// DataTable dt = new SurveyTableQuery().GetClassID();
// ddlSurveyClass.DataSource = dt;
// ddlSurveyClass.DataValueField = "CID";
// ddlSurveyClass.DataTextField = "SurveyClassName";
// ddlSurveyClass.DataBind();
//}
#endregion
#region 查询
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnQuery_Click(object sender, EventArgs e)
{
if (!CheckData())
{
PageHelper.ShowExceptionMessage(hidInfo.Value);
return;
}
viewpage1.CurrentPageIndex = 1;
this.AnswerName = answerName.Text.Trim();
if (!string.IsNullOrEmpty(minRecord.Text.Trim()))
{
this.MinAnswerRecord = NDConvert.ToInt32(minRecord.Text.Trim());
}
else
{
this.MinAnswerRecord = -1;
}
if (!string.IsNullOrEmpty(maxRecord.Text.Trim()))
{
this.MaxAnswerRecord = NDConvert.ToInt32(maxRecord.Text.Trim());
}
else
{
this.MaxAnswerRecord = -1;
}
if (!string.IsNullOrEmpty(minTime.Text.Trim()))
{
this.MinUseTime = NDConvert.ToInt32(minTime.Text.Trim());
}
else
{
this.MinUseTime = -1;
}
if (!string.IsNullOrEmpty(maxTime.Text.Trim()))
{
this.MaxUseTime = NDConvert.ToInt32(maxTime.Text.Trim());
}
else
{
this.MaxUseTime = -1;
}
if (!string.IsNullOrEmpty(approvalStaus.SelectedValue))
{
this.ApprovalStaus = NDConvert.ToInt32(approvalStaus.SelectedValue);
}
else
{
this.ApprovalStaus = -1;
}
this.BeginDate = NDConvert.ToDateTime(startDate.Value);
if (NDConvert.ToDateTime(endDate.Value) == NDConvert.ToDateTime("1900-1-1"))
{
this.EndDate = NDConvert.ToDateTime("2999-12-31");
}
else
{
this.EndDate = NDConvert.ToDateTime(endDate.Value);
}
BindGridView();
}
