Esempio n. 1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(ApplyAssessment model)
        {
            var strSql = new StringBuilder();

            strSql.Append(@"REPOS:ApplyAssessment.ApplyAssessment.Update");
            var parameters = new List <QfParameter>();

            parameters.Add(new QfParameter("@ApplyAssessmentID", model.ApplyAssessmentID));
            parameters.Add(new QfParameter("@OperateTime", model.OperateTime));
            parameters.Add(new QfParameter("@CheckInDate", model.CheckInDate));
            parameters.Add(new QfParameter("@StudentID", model.StudentID));
            parameters.Add(new QfParameter("@SubjectID", model.SubjectID));
            parameters.Add(new QfParameter("@SubjectItemID", model.SubjectItemID));
            parameters.Add(new QfParameter("@CheckEmployeeID", model.CheckEmployeeID));
            parameters.Add(new QfParameter("@Statue", model.Statue));
            parameters.Add(new QfParameter("@Note", model.Note));
            parameters.Add(new QfParameter("@OperateID", model.OperateID));

            try
            {
                var rows = ExecuteSql(strSql.ToString(), parameters.ToArray());
                return(rows > 0);
            }
            catch (QfException ex)
            {
                throw ex;
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public ApplyAssessment GetModel(int ApplyAssessmentID)
        {
            var strSql = new StringBuilder();

            strSql.Append(@"REPOS:ApplyAssessment.ApplyAssessment.GetModel");
            var parameters = new List <QfParameter>();

            parameters.Add(new QfParameter("@ApplyAssessmentID", ApplyAssessmentID));

            var model = new ApplyAssessment();
            var ds    = Query(strSql.ToString(), parameters.ToArray());

            return(ModelConvert.ToModel <ApplyAssessment>(ds));
        }