public void getQuestionData(QuestionDataList questionDataList)
{
NaireWebDataContext db = new NaireWebDataContext();
List <QuestionDataItem> question_data_items = questionDataList.list;
for (int i = 0; i < question_data_items.Count; i++)
{
data_info data = new data_info();
data.question_id = question_data_items[i].id;
if (question_data_items[i].items.Count > 1)
{
data.data = JsonConvert.SerializeObject(question_data_items[i].items);
}
else if (question_data_items[i].items.Count == 1)
{
data.data = question_data_items[i].items[0];
}
// 提交存入数据库
db.data_info.InsertOnSubmit(data);
db.SubmitChanges();
}
// 获得问题id->获得问卷id->问卷收到数据数+1
int question_id = question_data_items[0].id;
question_info question_result = (from r in db.question_info
where r.id == question_id
select r).FirstOrDefault();
naire_info naire = (from r in db.naire_info
where r.id == question_result.naire_id
select r).FirstOrDefault();
naire.data += 1;
db.SubmitChanges();
}
/// <summary>
/// 创建项目
/// </summary>
private void createProject(NaireJsonObject naireJson)
{
user_id = Request.Cookies["user_id"].Value;
// 开始时间与最后修改时间
string start_time = Request.Cookies["start_time"].Value;
string edit_time = DateTime.Now.ToShortDateString().ToString();
NaireWebDataContext db = new NaireWebDataContext();
naire_info naire = new naire_info();
naire.user_id = int.Parse(user_id);
naire.title = naireJson.title;
naire.hint = naireJson.hint;
naire.state = "未发布";
naire.start_time = start_time;
naire.update_time = edit_time;
naire.questions = JsonConvert.SerializeObject(naireJson);
naire.recycle = 0;
// 提交问卷
db.naire_info.InsertOnSubmit(naire);
db.SubmitChanges();
// 获得naire_id的最大值
var naire_num = db.naire_info.Max(p => p.id);
naire_id = naire_num.ToString();
// 提交每一个问题
for (int i = 0; i < naireJson.list.Count; i++)
{
question_info question = new question_info();
question.naire_id = naire_num;
question.title = naireJson.list[i].title;
question.flag = naireJson.list[i].flag;
question.items = JsonConvert.SerializeObject(naireJson.list[i].items);
db.question_info.InsertOnSubmit(question);
db.SubmitChanges();
}
}
