/**************************************** ***生成器版本: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 }