/// <summary>
/// 添加调查问卷
/// </summary>
/// <param name="exampaper"></param>
public void AddExampaper(Survey_Exampaper exampaper)
{
//修改的时候，先全部删除，再添加
if (exampaper.ExampaperID > 0)
{
Sdb.DeleteByExampaperId(exampaper.ExampaperID);
Sdb.DeleteAnswerById(exampaper.ExampaperID);
Sdb.EditServeyExamPaper(exampaper);
}
else
{
Sdb.AddServeyExamPaper(exampaper);
}
foreach (var question in exampaper.Questions)
{
question.ExampaperID = exampaper.ExampaperID;
sqDB.Add(question);
foreach (var answer in question.Answers)
{
answer.QuestionID = question.QuestionID;
sqaDB.Add(answer);
}
}
//exampaper = exampaperRepository.GetModel(exampaper.ExampaperID);
}
/// <summary>
/// 修改问卷
/// </summary>
/// <param name="model">问卷</param>
public bool EditServeyExamPaper(Survey_Exampaper model)
{
using (var conn = OpenConnection())
{
const string sqlwhere =
@"update Survey_Exampaper set ExamTitle=@ExamTitle,ExamType=@ExamType,UserID=@UserID,SortID=@SortID,LastUpdateTime=getdate(),ExamDescription=@ExamDescription,ExampaperUsage=@ExampaperUsage,IsDelete=@IsDelete where ExampaperID=@ExampaperID ";
var param = new
{
ExamTitle = model.ExamTitle,
ExamType = model.ExamType,
UserID = model.UserID,
SortID = model.SortID,
ExamDescription = model.ExamDescription,
ExampaperUsage = model.ExampaperUsage,
IsDelete = model.IsDelete,
ExampaperID = model.ExampaperID
};
var result = conn.Execute(sqlwhere, param);
return(result > 0);
}
}
/// <summary>
/// 增加问卷
/// </summary>
/// <param name="model">问卷实体</param>
public bool AddServeyExamPaper(Survey_Exampaper model)
{
using (var conn = OpenConnection())
{
const string sqlwhere =
@"insert into Survey_Exampaper (ExamTitle,ExamType,UserID,SortID,LastUpdateTime,ExamDescription,ExampaperUsage,IsDelete) values (@ExamTitle,@ExamType,@UserID,@SortID,@LastUpdateTime,@ExamDescription,@ExampaperUsage,@IsDelete) SELECT @@Identity as Id";
var param = new
{
model.ExamTitle,
model.ExamType,
model.UserID,
model.SortID,
model.LastUpdateTime,
model.ExamDescription,
model.ExampaperUsage,
model.IsDelete
};
var id = conn.Query <decimal>(sqlwhere, param).FirstOrDefault();
model.ExampaperID = decimal.ToInt32(id);
return(model.ExampaperID > 0);
}
}
public JsonResult SaveExampaper()
{
try
{
string data = Request.Form["exampaper"];
dynamic examdata = Newtonsoft.Json.JsonConvert.DeserializeObject(data);
Survey_Exampaper exampaper;
int examId = examdata.examId;
if (examId > 0)
{
exampaper = SeBl.GetSurveyExampaper(examId);
}
exampaper = new Survey_Exampaper
{
ExamDescription = examdata.examDesc,
ExamTitle = examdata.examTitle,
ExamType = examdata.examType,
ExampaperID = examdata.examId,
SortID = examdata.sortID,
LastUpdateTime = DateTime.Now,
Questions = new List <Survey_Question>()
};
if (exampaper.ExampaperID == 0)
{
exampaper.UserID = CurrentUser.UserId;
}
for (int i = 0; i < examdata.questions.Count; i++)
{
var question = new Survey_Question
{
QuestionContent = examdata.questions[i].title,
QuestionOrder = examdata.questions[i].order,
QuestionType = examdata.questions[i].type,
Status = 0,
UpdateTime = DateTime.Now,
UserID = CurrentUser.UserId,
LinkSortPayGrade = examdata.questions[i].sortpayGrade,
Answers = new List <Survey_QuestionAnswer>()
};
question.QuestionContent = question.QuestionContent.HtmlDecode();
foreach (var answer in examdata.questions[i].answers)
{
var a = new Survey_QuestionAnswer
{
AnswerContent = answer.content,
ShowOrder = answer.order
};
question.Answers.Add(a);
}
exampaper.Questions.Add(question);
}
SeBl.AddExampaper(exampaper);
return(Json(new
{
result = 1
}, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new
{
result = 0
}, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 修改问卷
/// </summary>
/// <param name="model">问卷</param>
public bool EditServeyExamPaper(Survey_Exampaper model)
{
return(Sdb.EditServeyExamPaper(model));
}
/// <summary>
/// 增加问卷
/// </summary>
/// <param name="model">问卷实体</param>
public bool AddServeyExamPaper(Survey_Exampaper model)
{
return(Sdb.AddServeyExamPaper(model));
}
