/// <summary>
/// 根据条件筛选所有ExamQuestion指定页码的数据（分页型）
/// </summary>
/// <param name="examquestion">实体对象</param>
/// <param name="pageparams">分页对象</param>
/// <param name="totalCount">符合条件的记录总数量</param>
/// <returns></returns>
public ExamQuestionData GetData(EntityExamQuestion examquestion, PageParams pageparams, out int totalCount)
{
#region
DBConditions querybusinessparams = new DBConditions(pageparams);
querybusinessparams.Add(ExamQuestionData.questionId, EnumSqlType.sqlint,
EnumCondition.Equal, examquestion.questionId);
querybusinessparams.Add(ExamQuestionData.questionTypeId, EnumSqlType.tinyint,
EnumCondition.Equal, examquestion.questionTypeId);
querybusinessparams.Add(ExamQuestionData.questionScopeId, EnumSqlType.sqlint,
EnumCondition.Equal, examquestion.questionScopeId);
querybusinessparams.Add(ExamQuestionData.questionName, EnumSqlType.nvarchar,
EnumCondition.LikeBoth, examquestion.questionName);
querybusinessparams.Add(ExamQuestionData.usable, EnumSqlType.bit,
EnumCondition.Equal, examquestion.usable);
querybusinessparams.Add(ExamQuestionData.sort, EnumSqlType.tinyint,
EnumCondition.Equal, examquestion.sort);
querybusinessparams.Add(ExamQuestionData.writeUser, EnumSqlType.sqlint,
EnumCondition.Equal, examquestion.writeUser);
querybusinessparams.Add(ExamQuestionData.writeIp, EnumSqlType.nvarchar,
EnumCondition.Equal, examquestion.writeIp);
querybusinessparams.Add(ExamQuestionData.writeTime, EnumSqlType.datetime,
EnumCondition.Equal, examquestion.writeTime);
ExamQuestionData examquestiondata = new ExamQuestionData();
totalCount = this._examquestionclass.GetSingleT(examquestiondata, querybusinessparams);
return(examquestiondata);
#endregion
}
/****************************************
***生成器版本：V2.0.0.32008
***生成时间：2013-10-27 08:26:06
***公司：山西ICat Studio有限公司
***友情提示：以下代码为生成器自动生成，可做参照修改之用；
*** 如需有其他业务要求，可在region外添加新方法；
*** 如发现任何编译和运行时错误，请联系QQ：330669393。
*****************************************/
#region public members methods
/// <summary>
/// 根据条件筛选所有ExamQuestion指定页码的数据（分页型）
/// </summary>
/// <param name="examquestion">实体对象</param>
/// <param name="pageparams">分页对象</param>
/// <returns></returns>
public string GetJsonByPage(EntityExamQuestion examquestion, PageParams pageparams)
{
#region
int totalCount = 0;
DataSet examquestiondata = this.GetData(examquestion, pageparams, out totalCount);
return(base.GetJson(examquestiondata, totalCount));
#endregion
}
/// <summary>
/// 添加ExamQuestion表行数据（如主键为非自增型字段，则自行修改代码）
/// </summary>
/// <param name="examquestiondata">数据集对象</param>
/// <param name="examquestion">实体对象</param>
public void AddRow(ref ExamQuestionData examquestiondata, EntityExamQuestion examquestion)
{
#region
DataRow dr = examquestiondata.Tables[0].NewRow();
examquestiondata.Assign(dr, ExamQuestionData.questionId, examquestion.questionId);
examquestiondata.Assign(dr, ExamQuestionData.questionTypeId, examquestion.questionTypeId);
examquestiondata.Assign(dr, ExamQuestionData.questionScopeId, examquestion.questionScopeId);
examquestiondata.Assign(dr, ExamQuestionData.questionName, examquestion.questionName);
examquestiondata.Assign(dr, ExamQuestionData.usable, examquestion.usable);
examquestiondata.Assign(dr, ExamQuestionData.sort, examquestion.sort);
examquestiondata.Assign(dr, ExamQuestionData.writeUser, examquestion.writeUser);
examquestiondata.Assign(dr, ExamQuestionData.writeIp, examquestion.writeIp);
examquestiondata.Assign(dr, ExamQuestionData.writeTime, examquestion.writeTime);
examquestiondata.Tables[0].Rows.Add(dr);
#endregion
}
/// <summary>
///
/// </summary>
/// <param name="examquestiondata"></param>
/// <param name="entityQuestion"></param>
/// <param name="examAnswerestimateData"></param>
/// <param name="entityAnswer"></param>
public void AddEstimateQuestion(ref ExamQuestionData examquestiondata
, EntityExamQuestion entityQuestion, ref ExamAnswerEstimateData examAnswerestimateData
, EntityExamAnswerEstimate entityAnswer)
{
#region
entityQuestion.questionId = this._examquestionclass.GetMaxAddOne(examquestiondata).ToString();
ExamAnswerEstimateClass answerestimateclass = new ExamAnswerEstimateClass();
ExamAnswerEstimateBusiness answerestimatebusiness = new ExamAnswerEstimateBusiness();
entityAnswer.answerId = answerestimateclass.GetMaxAddOne(examAnswerestimateData).ToString();
entityAnswer.questionId = entityQuestion.questionId;
this.AddRow(ref examquestiondata, entityQuestion);
answerestimatebusiness.AddRow(ref examAnswerestimateData, entityAnswer);
this.SaveExamQuestion(examquestiondata);
answerestimateclass.SaveSingleT(examAnswerestimateData);
#endregion
}
/// <summary>
/// 编辑examquestiondata数据集中指定的行数据
/// </summary>
/// <param name="examquestiondata">数据集对象</param>
/// <param name="examquestion">实体对象</param>
public void EditRow(ref ExamQuestionData examquestiondata, EntityExamQuestion examquestion)
{
#region
if (examquestiondata.Tables[0].Rows.Count <= 0)
{
examquestiondata = this.getData(examquestion.questionId);
}
DataRow dr = examquestiondata.Tables[0].Rows.Find(new object[1] {
examquestion.questionId
});
examquestiondata.Assign(dr, ExamQuestionData.questionId, examquestion.questionId);
examquestiondata.Assign(dr, ExamQuestionData.questionTypeId, examquestion.questionTypeId);
examquestiondata.Assign(dr, ExamQuestionData.questionScopeId, examquestion.questionScopeId);
examquestiondata.Assign(dr, ExamQuestionData.questionName, examquestion.questionName);
examquestiondata.Assign(dr, ExamQuestionData.usable, examquestion.usable);
examquestiondata.Assign(dr, ExamQuestionData.sort, examquestion.sort);
examquestiondata.Assign(dr, ExamQuestionData.writeUser, examquestion.writeUser);
examquestiondata.Assign(dr, ExamQuestionData.writeIp, examquestion.writeIp);
examquestiondata.Assign(dr, ExamQuestionData.writeTime, examquestion.writeTime);
#endregion
}
/// <summary>
/// 新增保存
/// </summary>
private void addEstimateQuestion()
{
#region
EntityExamQuestion entityquestion = new EntityExamQuestion();
entityquestion.questionName = this.tbQuestion.Text;
entityquestion.questionScopeId = this.cbQuestionScope.SelectedValue.ToString();
entityquestion.questionTypeId = this.cbQuestiontype.SelectedValue.ToString();
entityquestion.usable = "true";
entityquestion.writeTime = TimeManager.CurrentDBServerTime.ToString();
this._entityAnswerEstimate = new EntityExamAnswerEstimate();
this._entityAnswerEstimate.answer = this.cbAnswerEstimate.IsChecked.ToString();
this._entityAnswerEstimate.writeTime = TimeManager.CurrentDBServerTime.ToString();
ExamAnswerEstimateData answerestimatedata = new ExamAnswerEstimateData();
ExamQuestionBusiness questionbusiness = new ExamQuestionBusiness();
questionbusiness.AddEstimateQuestion(
ref QuestionController.QuestionData, entityquestion,
ref answerestimatedata, this._entityAnswerEstimate);
#endregion
}
