/// <summary> /// 保存examhistorydata数据集数据 /// </summary> /// <param name="examhistorydata">数据集对象</param> /// <returns>返回保存后的响应信息</returns> public String SaveExamHistory(ExamHistoryData examhistorydata) { #region return(base.Save(examhistorydata, this._examhistoryclass)); #endregion }
/// <summary> /// 根据条件筛选所有ExamHistory指定页码的数据(分页型) /// </summary> /// <param name="examhistory">实体对象</param> /// <param name="pageparams">分页对象</param> /// <param name="totalCount">符合条件的记录总数量</param> /// <returns></returns> public ExamHistoryData GetData(EntityExamHistory examhistory, PageParams pageparams, out int totalCount) { #region DBConditions querybusinessparams = new DBConditions(pageparams); querybusinessparams.Add(ExamHistoryData.examHistoryId, EnumSqlType.sqlint, EnumCondition.Equal, examhistory.examHistoryId); querybusinessparams.Add(ExamHistoryData.examPaperId, EnumSqlType.sqlint, EnumCondition.Equal, examhistory.examPaperId); querybusinessparams.Add(ExamHistoryData.giveScoreRemark, EnumSqlType.nvarchar, EnumCondition.Equal, examhistory.giveScoreRemark); querybusinessparams.Add(ExamHistoryData.giveScoreUser, EnumSqlType.sqlint, EnumCondition.Equal, examhistory.giveScoreUser); querybusinessparams.Add(ExamHistoryData.giveScoreTime, EnumSqlType.datetime, EnumCondition.Equal, examhistory.giveScoreTime); querybusinessparams.Add(ExamHistoryData.writeUser, EnumSqlType.sqlint, EnumCondition.Equal, examhistory.writeUser); querybusinessparams.Add(ExamHistoryData.examSubmitTime, EnumSqlType.datetime, EnumCondition.Equal, examhistory.examSubmitTime); querybusinessparams.Add(ExamHistoryData.writeIp, EnumSqlType.nvarchar, EnumCondition.Equal, examhistory.writeIp); querybusinessparams.Add(ExamHistoryData.writeTime, EnumSqlType.datetime, EnumCondition.Equal, examhistory.writeTime); ExamHistoryData examhistorydata = new ExamHistoryData(); totalCount = this._examhistoryclass.GetSingleT(examhistorydata, querybusinessparams); return(examhistorydata); #endregion }
/// <summary> /// 获取ExamHistory数据表的全部数据 /// </summary> /// <returns>Json字符串</returns> public string GetJsonByAll() { #region int totalCount = 0; ExamHistoryData examhistorydata = this.getData(null); totalCount = examhistorydata.Tables[0].Rows.Count; return(base.GetJson(examhistorydata, totalCount)); #endregion }
/// <summary> /// 根据主键值检索符合该条件的记录,用于编辑和删除记录时。 /// </summary> /// <param name="examHistoryId">主键-考试成绩单编号</param> /// <returns></returns> private ExamHistoryData getData(string examHistoryId) { #region ExamHistoryData examhistorydata = new ExamHistoryData(); DBConditions querybusinessparams = new DBConditions(); querybusinessparams.Add(ExamHistoryData.examHistoryId, EnumSqlType.sqlint, EnumCondition.Equal, examHistoryId); this._examhistoryclass.GetSingleTAllWithoutCount(examhistorydata, querybusinessparams); return(examhistorydata); #endregion }
/// <summary> /// 添加ExamHistory表行数据(如主键为非自增型字段,则自行修改代码) /// </summary> /// <param name="examhistorydata">数据集对象</param> /// <param name="examhistory">实体对象</param> public void AddRow(ref ExamHistoryData examhistorydata, EntityExamHistory examhistory) { #region DataRow dr = examhistorydata.Tables[0].NewRow(); examhistorydata.Assign(dr, ExamHistoryData.examHistoryId, examhistory.examHistoryId); examhistorydata.Assign(dr, ExamHistoryData.examPaperId, examhistory.examPaperId); examhistorydata.Assign(dr, ExamHistoryData.giveScoreRemark, examhistory.giveScoreRemark); examhistorydata.Assign(dr, ExamHistoryData.giveScoreUser, examhistory.giveScoreUser); examhistorydata.Assign(dr, ExamHistoryData.giveScoreTime, examhistory.giveScoreTime); examhistorydata.Assign(dr, ExamHistoryData.writeUser, examhistory.writeUser); examhistorydata.Assign(dr, ExamHistoryData.examSubmitTime, examhistory.examSubmitTime); examhistorydata.Assign(dr, ExamHistoryData.writeIp, examhistory.writeIp); examhistorydata.Assign(dr, ExamHistoryData.writeTime, examhistory.writeTime); examhistorydata.Tables[0].Rows.Add(dr); #endregion }
/// <summary> /// 删除examhistorydata数据集中指定的行数据 /// </summary> /// <param name="examhistorydata">数据集对象</param> /// <param name="examHistoryId">主键-考试成绩单编号</param> public void DeleteRow(ref ExamHistoryData examhistorydata, string examHistoryId) { #region if (examhistorydata.Tables[0].Rows.Count <= 0) { examhistorydata = this.getData(examHistoryId); } DataRow dr = examhistorydata.Tables[0].Rows.Find(new object[1] { examHistoryId }); if (dr != null) { dr.Delete(); } #endregion }
/// <summary> /// 编辑examhistorydata数据集中指定的行数据 /// </summary> /// <param name="examhistorydata">数据集对象</param> /// <param name="examhistory">实体对象</param> public void EditRow(ref ExamHistoryData examhistorydata, EntityExamHistory examhistory) { #region if (examhistorydata.Tables[0].Rows.Count <= 0) { examhistorydata = this.getData(examhistory.examHistoryId); } DataRow dr = examhistorydata.Tables[0].Rows.Find(new object[1] { examhistory.examHistoryId }); examhistorydata.Assign(dr, ExamHistoryData.examHistoryId, examhistory.examHistoryId); examhistorydata.Assign(dr, ExamHistoryData.examPaperId, examhistory.examPaperId); examhistorydata.Assign(dr, ExamHistoryData.giveScoreRemark, examhistory.giveScoreRemark); examhistorydata.Assign(dr, ExamHistoryData.giveScoreUser, examhistory.giveScoreUser); examhistorydata.Assign(dr, ExamHistoryData.giveScoreTime, examhistory.giveScoreTime); examhistorydata.Assign(dr, ExamHistoryData.writeUser, examhistory.writeUser); examhistorydata.Assign(dr, ExamHistoryData.examSubmitTime, examhistory.examSubmitTime); examhistorydata.Assign(dr, ExamHistoryData.writeIp, examhistory.writeIp); examhistorydata.Assign(dr, ExamHistoryData.writeTime, examhistory.writeTime); #endregion }