///<summary> ///向数据库中添加一条记录 ///</summary> ///<param name="model">要添加的实体</param> public bool Insert(OverageHistory model) { const string sql = @"INSERT INTO [dbo].[OverageHistory] (objectId,createdAt,updatedAt,userId,originUserId,type,before,after,change) VALUES (@objectId,@createdAt,@updatedAt,@userId,@originUserId,@type,@before,@after,@change)"; int res = SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@objectId", model.objectId.ToDBValue()), new SqlParameter("@createdAt", model.createdAt.ToDBValue()), new SqlParameter("@updatedAt", model.updatedAt.ToDBValue()), new SqlParameter("@userId", model.userId.ToDBValue()), new SqlParameter("@originUserId", model.originUserId.ToDBValue()), new SqlParameter("@type", model.type.ToDBValue()), new SqlParameter("@before", model.before.ToDBValue()), new SqlParameter("@after", model.after.ToDBValue()), new SqlParameter("@change", model.change.ToDBValue())); return(res > 0); }
/// <summary> /// 查询单个模型实体 /// </summary> /// <param name="id">objectId</param>); /// <returns>实体</returns>); public OverageHistory QuerySingleById(string objectId) { const string sql = "SELECT TOP 1 objectId,createdAt,updatedAt,userId,originUserId,type,before,after,change from OverageHistory WHERE [objectId] = @objectId"; using (var reader = SqlHelper.ExecuteReader(sql, new SqlParameter("@objectId", objectId))) { if (reader.HasRows) { reader.Read(); OverageHistory model = SqlHelper.MapEntity <OverageHistory>(reader); return(model); } else { return(null); } } }
///<summary> ///分页查询一个集合 ///</summary> ///<param name="index">页码</param> ///<param name="size">页大小</param> ///<param name="wheres">条件匿名类</param> ///<param name="orderField">排序字段</param> ///<param name="isDesc">是否降序排序</param> ///<returns>实体集合</returns> public IEnumerable <OverageHistory> QueryList(int index, int size, object wheres = null, string orderField = "objectId", bool isDesc = true) { List <SqlParameter> list = null; string where = wheres.parseWheres(out list); orderField = string.IsNullOrEmpty(orderField) ? "objectId" : orderField; var sql = SqlHelper.GenerateQuerySql("OverageHistory", new string[] { "objectId", "createdAt", "updatedAt", "userId", "originUserId", "type", "before", "after", "change" }, index, size, where, orderField, isDesc); using (var reader = SqlHelper.ExecuteReader(sql, list.ToArray())) { if (reader.HasRows) { while (reader.Read()) { OverageHistory model = SqlHelper.MapEntity <OverageHistory>(reader); yield return(model); } } } }
/// <summary> /// 根据主键更新一条记录 /// </summary> /// <param name="model">更新后的实体</param> /// <returns>执行结果受影响行数</returns> public bool Update(OverageHistory model) { return(_dao.Update(model)); }
/// <summary> /// 向数据库中添加一条记录 /// </summary> /// <param name="model">要添加的实体</param> /// <returns>是否成功</returns> public bool Insert(OverageHistory model) { return(_dao.Insert(model)); }
/// <summary> /// 根据主键更新一条记录 /// </summary> /// <param name="model">更新后的实体</param> /// <returns>是否成功</returns> public bool Update(OverageHistory model) { const string sql = @"UPDATE [dbo].[OverageHistory] SET createdAt=@createdAt,updatedAt=@updatedAt,userId=@userId,originUserId=@originUserId,type=@type,before=@before,after=@after,change=@change WHERE [objectId] = @objectId"; return(SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@objectId", model.objectId.ToDBValue()), new SqlParameter("@createdAt", model.createdAt.ToDBValue()), new SqlParameter("@updatedAt", model.updatedAt.ToDBValue()), new SqlParameter("@userId", model.userId.ToDBValue()), new SqlParameter("@originUserId", model.originUserId.ToDBValue()), new SqlParameter("@type", model.type.ToDBValue()), new SqlParameter("@before", model.before.ToDBValue()), new SqlParameter("@after", model.after.ToDBValue()), new SqlParameter("@change", model.change.ToDBValue())) > 0); }