public void TestMethod1()
{
wp_article mode = new wp_article();
//mode.Id = 2;
mode.content = "测试1";
mode.name = "测试1";
mode.title = "测试1";
mode.image = "测试1";
mode.end_time = DateTime.Now;
mode.is_delete = 0;
//var tmp = new Bll.WeChat.wp_articlebll().InsertItem(mode);
string replyMode = "";
//var tmp = new Bll.WeChat.wp_shop_vote_logbll().GetVoteCountTodayByOptionId(1, 1);
string str = "a:2:{i:0;s:1:\"0\";i:1;s:1:\"1\";}";
str = "s:12:\"我文案无\";";
//var tmp = new Bll.WeChat.wp_surveybll().GetAnswer(str);
var tmp = new Bll.WeChat.wp_survey_answerbll().GetAnswerExport(11);
//var cvs = Bll.MySqlHelper.DataTableToCsv(tmp);
var i = GetStar("da");
i = GetStar(12);
int ii = 123_456_789;
var s = tmp;
}
public BaseOutput GetSurveyAnswer(int surver_id, int pageIndex, int pageSize)
{
var ret = new BaseOutput();
int count = 0;
var list = new Bll.WeChat.wp_survey_answerbll().GetListBySurveyId(surver_id, out count, pageIndex, pageSize);
ret.TotalCount = count;
ret.Data = list;
return(ret);
}
protected void Page_Load(object sender, EventArgs e)
{
int uid = RequestHelper.GetQueryInt("uid", 0);
int surevyid = RequestHelper.GetQueryInt("surevyid", 0);
var dt = new Bll.WeChat.wp_survey_answerbll().GetAnswerBySurveyId(uid, surevyid);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SyrevyAnswer model = new SyrevyAnswer();
model.Querstion = dr["title"].ToString();
var answers = dr["extra"].ToString().Split(' ').ToList();
var answervalue = new List <string>();
answers.ForEach(s =>
{
if (!string.IsNullOrEmpty(s.Trim()))
{
answervalue.Add(s);
}
});
//获取答案的索引
var answerIndex = new Bll.WeChat.wp_survey_answerbll().GetAnswer(dr["answer"].ToString());
var type = dr["type"].ToString();
if (answerIndex != null && answerIndex.Count > 0)
{
switch (type)
{
case "radio":
model.AnswerValue = answervalue[ConvertHelper.GetInteger(answerIndex[0])];
break;
case "checkbox":
foreach (var item in answerIndex)
{
model.AnswerValue += answervalue[ConvertHelper.GetInteger(item)] + " ";
}
break;
default:
model.AnswerValue = answerIndex[0];
break;
}
}
else
{
model.AnswerValue = "";
}
list.Add(model);
}
}
}
private MemoryStream GetSurvey(int id)
{
DataTable dtAnswer = new Bll.WeChat.wp_survey_answerbll().GetAnswerExport(id);
IList <int> listQuestionId = new Bll.WeChat.wp_survey_answerbll().GetQuestionIds(id);
if (dtAnswer != null && listQuestionId != null && listQuestionId.Count > 0)
{
List <string> ColumnName = new List <string>();
List <string> questionList = new List <string>();
for (int i = 0; i < listQuestionId.Count; i++)
{
ColumnName.Add($"第{i + 1}题");
ColumnName.Add($"第{i + 1}题答案");
}
foreach (var item in ColumnName)
{
dtAnswer.Columns.Add(item, typeof(string));
}
dtAnswer.Columns.Add("答题时间", typeof(string));
//for (int i = 0; i < dtAnswer.Columns.Count; i++)
//{
// dt.Columns.Remove
//}
foreach (DataRow dr in dtAnswer.Rows)
{
var questionIds = dr["question_ids"].ToString().Split('^').ToList();
var answers = dr["answers"].ToString().Split('^').ToList();
var titles = dr["titles"].ToString().Split('^').ToList();
var types = dr["types"].ToString().Split('^').ToList();
var extras = dr["extras"].ToString().Split('^').ToList();
dr["答题时间"] = Common.BaseClass.ConvertToDateTime(ConvertHelper.GetLong(dr["cTime"])).ToString("yyyy-MM-dd HH:mm:ss");
for (int i = 0; i < listQuestionId.Count; i++)
{
var index = questionIds.IndexOf(listQuestionId[i].ToString());
var answer = "";
var quesrtion = "";
try
{
#region 获取问题和答案
var answertmp = new Bll.WeChat.wp_survey_answerbll().GetAnswer(answers[index]);
if (answertmp != null && answertmp.Count > 0)
{
var type = types[index];
var answervaluetmp = extras[i].ToString().Split(' ').ToList();
var answervalue = new List <string>();
answervaluetmp.ForEach(s =>
{
if (!string.IsNullOrEmpty(s.Trim()))
{
answervalue.Add(s);
}
});
switch (type)
{
case "radio":
answer = answervalue[ConvertHelper.GetInteger(answertmp[0])];
break;
case "checkbox":
List <string> list = new List <string>();
answertmp.ForEach(s =>
{
var tmp = ConvertHelper.GetInteger(s);
list.Add(answervalue[tmp]);
});
answer = string.Join(",", list.ToArray());
break;
default:
answer = string.Join(",", answertmp.ToArray());
break;
}
}
quesrtion = titles[index];
#endregion
}
catch (Exception ex)
{
answer = "";
quesrtion = "";
}
//问题
dr[ColumnName[i * 2]] = quesrtion;
//答案
dr[ColumnName[i * 2 + 1]] = answer;
}
}
dtAnswer.Columns.Remove("answers");
dtAnswer.Columns.Remove("question_ids");
dtAnswer.Columns.Remove("titles");
dtAnswer.Columns.Remove("types");
dtAnswer.Columns.Remove("cTime");
dtAnswer.Columns.Remove("extras");
dtAnswer.Columns.Remove("uid");
MemoryStream ms = Bll.ExportExcelNew.ExportDataTableToExcelWithTitle(dtAnswer, "问卷调查");
return(ms);
}
else
{
return(null);
}
}
