/// <summary>
/// Web列表获取
/// </summary>
/// <param name="Page">分页页码。从0开始</param>
/// <param name="PageSize">每页的数量。未指定时默认为15</param>
/// <returns></returns>
public IList <QuesQuestionsEntity> GetWebQuesQuestions(QuesQuestionsEntity entity, int Page, int PageSize)
{
if (PageSize <= 0)
{
PageSize = 15;
}
IList <QuesQuestionsEntity> list = new List <QuesQuestionsEntity>();
DataSet ds = new DataSet();
ds = _currentDAO.GetWebQuesQuestions(entity, Page, PageSize);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
list = DataTableToObject.ConvertToList <QuesQuestionsEntity>(ds.Tables[0]);
}
return(list);
}
/// <summary>
/// 问题查询
/// </summary>
public string GetQuestionListData()
{
var quesQuestionsBLL = new QuesQuestionsBLL(this.CurrentUserInfo);
string content = string.Empty;
string QuestionnaireId = FormatParamValue(Request("QuestionnaireId"));
int pageIndex = Utils.GetIntVal(FormatParamValue(Request("page"))) - 1;
var queryEntity = new QuesQuestionsEntity();
queryEntity.QuestionnaireID = QuestionnaireId;
var data = quesQuestionsBLL.GetWebQuesQuestions(queryEntity, pageIndex, PageSize);
int dataTotalCount = data.Count;
content = string.Format("{{\"totalCount\":{1},\"topics\":{0}}}",
data.ToJSON(),
dataTotalCount);
return(content);
}
public void Update(QuesQuestionsEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pIsUpdateNullField, pTran);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(QuesQuestionsEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, true, pTran);
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(QuesQuestionsEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Create(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(QuesQuestionsEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <QuesQuestionsEntity> PagedQueryByEntity(QuesQuestionsEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public QuesQuestionsEntity[] QueryByEntity(QuesQuestionsEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(QuesQuestionsEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
public void Update(QuesQuestionsEntity pEntity, bool pIsUpdateNullField)
{
_currentDAO.Update(pEntity, pIsUpdateNullField);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(QuesQuestionsEntity pEntity)
{
Update(pEntity, true);
}
/// <summary>
/// 列表数量获取
/// </summary>
public int GetWebQuesQuestionssCount(QuesQuestionsEntity entity)
{
return(_currentDAO.GetWebQuesQuestionsCount(entity));
}
public string GetSingleAnswer(string pQuestionId, string pAnswer)
{
string ret = "-1";
QuesQuestionsBLL quesBll = new QuesQuestionsBLL(_loggingSessionInfo);
QuesQuestionsEntity entity = quesBll.GetByID(pQuestionId);
if (entity != null)
{
QuesOptionBLL quesOpBll = new QuesOptionBLL(_loggingSessionInfo);
DataTable dTblOption = quesOpBll.GetQuesOptions(pQuestionId);
//1单选，2多选，3主观选择题，4填空题，5标准打分题
int questionType = (int)entity.QuestionType;
DataRow[] drs = null;
if (questionType == 1)//1单选
{
if (dTblOption != null && dTblOption.Rows.Count > 0)
{
drs = dTblOption.Select("IsAnswer=1");
if (drs != null && drs.Length > 0)
{
if (drs[0]["OptionIndex"].ToString().ToLower().Equals(pAnswer.ToLower()))
{
ret = "1";
}
else
{
ret = "0";
}
}
}
}
else
if (questionType == 2) //2多选
{
string[] answerArr = pAnswer.ToLower().Split(',');
if (dTblOption != null && dTblOption.Rows.Count > 0)
{
drs = dTblOption.Select("IsAnswer=1");
int index = 0;
foreach (DataRow row in drs)
{
for (int i = 0; i < answerArr.Length; i++)
{
if (row["OptionIndex"].ToString().ToLower().Equals(answerArr[i]))
{
index++;
}
}
}
if (index != answerArr.Length)
{
ret = "1";
}
else
{
ret = "0";
}
}
}
else
{
ret = "-1";
}
ret += "|" + entity.QuestionValue;
}
else
{
ret += "|题不存在";
}
return(ret);
}
