/****************************************
***生成器版本：V2.0.0.32008
***生成时间：2013-10-27 08:26:06
***公司：山西ICat Studio有限公司
***友情提示：以下代码为生成器自动生成，可做参照修改之用；
*** 如需有其他业务要求，可在region外添加新方法；
*** 如发现任何编译和运行时错误，请联系QQ：330669393。
*****************************************/
#region public members methods
/// <summary>
/// 根据条件筛选所有ExamAnswerEstimate指定页码的数据（分页型）
/// </summary>
/// <param name="examanswerestimate">实体对象</param>
/// <param name="pageparams">分页对象</param>
/// <returns></returns>
public string GetJsonByPage(EntityExamAnswerEstimate examanswerestimate, PageParams pageparams)
{
#region
int totalCount = 0;
DataSet examanswerestimatedata = this.GetData(examanswerestimate, pageparams, out totalCount);
return(base.GetJson(examanswerestimatedata, totalCount));
#endregion
}
/// <summary>
/// 添加ExamAnswerEstimate表行数据（如主键为非自增型字段，则自行修改代码）
/// </summary>
/// <param name="examanswerestimatedata">数据集对象</param>
/// <param name="examanswerestimate">实体对象</param>
public void AddRow(ref ExamAnswerEstimateData examanswerestimatedata, EntityExamAnswerEstimate examanswerestimate)
{
#region
DataRow dr = examanswerestimatedata.Tables[0].NewRow();
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.answerId, examanswerestimate.answerId);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.questionId, examanswerestimate.questionId);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.answer, examanswerestimate.answer);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.writeUser, examanswerestimate.writeUser);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.writeIp, examanswerestimate.writeIp);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.writeTime, examanswerestimate.writeTime);
examanswerestimatedata.Tables[0].Rows.Add(dr);
#endregion
}
/// <summary>
/// 编辑examanswerestimatedata数据集中指定的行数据
/// </summary>
/// <param name="examanswerestimatedata">数据集对象</param>
/// <param name="examanswerestimate">实体对象</param>
public void EditRow(ref ExamAnswerEstimateData examanswerestimatedata, EntityExamAnswerEstimate examanswerestimate)
{
#region
if (examanswerestimatedata.Tables[0].Rows.Count <= 0)
{
examanswerestimatedata = this.GetData(examanswerestimate.answerId);
}
DataRow dr = examanswerestimatedata.Tables[0].Rows.Find(new object[1] {
examanswerestimate.answerId
});
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.answerId, examanswerestimate.answerId);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.questionId, examanswerestimate.questionId);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.answer, examanswerestimate.answer);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.writeUser, examanswerestimate.writeUser);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.writeIp, examanswerestimate.writeIp);
examanswerestimatedata.Assign(dr, ExamAnswerEstimateData.writeTime, examanswerestimate.writeTime);
#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>
/// 根据条件筛选所有ExamAnswerEstimate指定页码的数据（分页型）
/// </summary>
/// <param name="examanswerestimate">实体对象</param>
/// <param name="pageparams">分页对象</param>
/// <param name="totalCount">符合条件的记录总数量</param>
/// <returns></returns>
public ExamAnswerEstimateData GetData(EntityExamAnswerEstimate examanswerestimate, PageParams pageparams, out int totalCount)
{
#region
DBConditions querybusinessparams = new DBConditions(pageparams);
querybusinessparams.Add(ExamAnswerEstimateData.answerId, EnumSqlType.sqlint,
EnumCondition.Equal, examanswerestimate.answerId);
querybusinessparams.Add(ExamAnswerEstimateData.questionId, EnumSqlType.sqlint,
EnumCondition.Equal, examanswerestimate.questionId);
querybusinessparams.Add(ExamAnswerEstimateData.answer, EnumSqlType.bit,
EnumCondition.Equal, examanswerestimate.answer);
querybusinessparams.Add(ExamAnswerEstimateData.writeUser, EnumSqlType.sqlint,
EnumCondition.Equal, examanswerestimate.writeUser);
querybusinessparams.Add(ExamAnswerEstimateData.writeIp, EnumSqlType.nvarchar,
EnumCondition.Equal, examanswerestimate.writeIp);
querybusinessparams.Add(ExamAnswerEstimateData.writeTime, EnumSqlType.datetime,
EnumCondition.Equal, examanswerestimate.writeTime);
ExamAnswerEstimateData examanswerestimatedata = new ExamAnswerEstimateData();
totalCount = this._examanswerestimateclass.GetSingleT(examanswerestimatedata, querybusinessparams);
return(examanswerestimatedata);
#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
}
/// <summary>
///
/// </summary>
private void initEstimate()
{
#region
this.tbQuestionEstimate.Text = this.tbQuestion.Text;
int totalcount = 0;
ExamAnswerEstimateBusiness answerestimatebusiness =
new ExamAnswerEstimateBusiness();
_entityAnswerEstimate = new EntityExamAnswerEstimate();
_entityAnswerEstimate.questionId = QuestionRow[ExamQuestionData.questionId].ToString();
this._answerEstimateData = answerestimatebusiness.GetData(_entityAnswerEstimate, null, out totalcount);
if (totalcount == 1)
{
this.cbAnswerEstimate.IsChecked = Convert
.ToBoolean(this._answerEstimateData.Tables[0]
.Rows[0][ExamAnswerEstimateData.answer]);
}
else
{
ExtMessage.Show("数据错误，请将此项数据进行删除！");
}
#endregion
}
