Пример #1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(TicketEq model)
        {
            var strSql = new StringBuilder();

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

            parameters.Add(new QfParameter("@SN", model.SN));
            parameters.Add(new QfParameter("@TicketID", model.TicketID));
            parameters.Add(new QfParameter("@ChangeType", model.ChangeType));
            parameters.Add(new QfParameter("@RefCode", model.RefCode));
            parameters.Add(new QfParameter("@RefCodeType", model.RefCodeType));
            parameters.Add(new QfParameter("@OperateID", model.OperateID));
            parameters.Add(new QfParameter("@OperateTime", model.OperateTime));
            parameters.Add(new QfParameter("@Note", model.Note));

            try
            {
                var rows = ExecuteSql(strSql.ToString(), parameters.ToArray());
                return(rows > 0);
            }
            catch (QfException ex)
            {
                throw ex;
            }
        }
Пример #2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public TicketEq GetModel(string SN)
        {
            var strSql = new StringBuilder();

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

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

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

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