/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/6/7 12:10:43</remarks> public bool Update(StatisticDetailEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_StatisticDetail_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int64, entity.Idx); database.AddInParameter(commandWrapper, "@ZoneId", DbType.Int32, entity.ZoneId); database.AddInParameter(commandWrapper, "@AnalyseType", DbType.Int32, entity.AnalyseType); database.AddInParameter(commandWrapper, "@RecordDate", DbType.DateTime, entity.RecordDate); database.AddInParameter(commandWrapper, "@TotalValue", DbType.Int32, entity.TotalValue); database.AddInParameter(commandWrapper, "@MinValue", DbType.Int32, entity.MinValue); database.AddInParameter(commandWrapper, "@MinTime", DbType.DateTime, entity.MinTime); database.AddInParameter(commandWrapper, "@MaxValue", DbType.Int32, entity.MaxValue); database.AddInParameter(commandWrapper, "@MaxTime", DbType.DateTime, entity.MaxTime); database.AddInParameter(commandWrapper, "@Hour0", DbType.Int32, entity.Hour0); database.AddInParameter(commandWrapper, "@Hour1", DbType.Int32, entity.Hour1); database.AddInParameter(commandWrapper, "@Hour2", DbType.Int32, entity.Hour2); database.AddInParameter(commandWrapper, "@Hour3", DbType.Int32, entity.Hour3); database.AddInParameter(commandWrapper, "@Hour4", DbType.Int32, entity.Hour4); database.AddInParameter(commandWrapper, "@Hour5", DbType.Int32, entity.Hour5); database.AddInParameter(commandWrapper, "@Hour6", DbType.Int32, entity.Hour6); database.AddInParameter(commandWrapper, "@Hour7", DbType.Int32, entity.Hour7); database.AddInParameter(commandWrapper, "@Hour8", DbType.Int32, entity.Hour8); database.AddInParameter(commandWrapper, "@Hour9", DbType.Int32, entity.Hour9); database.AddInParameter(commandWrapper, "@Hour10", DbType.Int32, entity.Hour10); database.AddInParameter(commandWrapper, "@Hour11", DbType.Int32, entity.Hour11); database.AddInParameter(commandWrapper, "@Hour12", DbType.Int32, entity.Hour12); database.AddInParameter(commandWrapper, "@Hour13", DbType.Int32, entity.Hour13); database.AddInParameter(commandWrapper, "@Hour14", DbType.Int32, entity.Hour14); database.AddInParameter(commandWrapper, "@Hour15", DbType.Int32, entity.Hour15); database.AddInParameter(commandWrapper, "@Hour16", DbType.Int32, entity.Hour16); database.AddInParameter(commandWrapper, "@Hour17", DbType.Int32, entity.Hour17); database.AddInParameter(commandWrapper, "@Hour18", DbType.Int32, entity.Hour18); database.AddInParameter(commandWrapper, "@Hour19", DbType.Int32, entity.Hour19); database.AddInParameter(commandWrapper, "@Hour20", DbType.Int32, entity.Hour20); database.AddInParameter(commandWrapper, "@Hour21", DbType.Int32, entity.Hour21); database.AddInParameter(commandWrapper, "@Hour22", DbType.Int32, entity.Hour22); database.AddInParameter(commandWrapper, "@Hour23", DbType.Int32, entity.Hour23); database.AddInParameter(commandWrapper, "@UpdateTime", DbType.DateTime, entity.UpdateTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Idx = (System.Int64)database.GetParameterValue(commandWrapper, "@Idx"); return(Convert.ToBoolean(results)); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>StatisticDetailEntity</returns> /// <remarks>2016/6/7 12:10:42</remarks> public StatisticDetailEntity GetById(System.Int64 idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_StatisticDetail_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int64, idx); StatisticDetailEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// 将IDataReader的当前记录读取到StatisticDetailEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public StatisticDetailEntity LoadSingleRow(IDataReader reader) { var obj = new StatisticDetailEntity(); obj.Idx = (System.Int64)reader["Idx"]; obj.ZoneId = (System.Int32)reader["ZoneId"]; obj.AnalyseType = (System.Int32)reader["AnalyseType"]; obj.RecordDate = (System.DateTime)reader["RecordDate"]; obj.TotalValue = (System.Int32)reader["TotalValue"]; obj.MinValue = (System.Int32)reader["MinValue"]; obj.MinTime = (System.DateTime)reader["MinTime"]; obj.MaxValue = (System.Int32)reader["MaxValue"]; obj.MaxTime = (System.DateTime)reader["MaxTime"]; obj.Hour0 = (System.Int32)reader["Hour0"]; obj.Hour1 = (System.Int32)reader["Hour1"]; obj.Hour2 = (System.Int32)reader["Hour2"]; obj.Hour3 = (System.Int32)reader["Hour3"]; obj.Hour4 = (System.Int32)reader["Hour4"]; obj.Hour5 = (System.Int32)reader["Hour5"]; obj.Hour6 = (System.Int32)reader["Hour6"]; obj.Hour7 = (System.Int32)reader["Hour7"]; obj.Hour8 = (System.Int32)reader["Hour8"]; obj.Hour9 = (System.Int32)reader["Hour9"]; obj.Hour10 = (System.Int32)reader["Hour10"]; obj.Hour11 = (System.Int32)reader["Hour11"]; obj.Hour12 = (System.Int32)reader["Hour12"]; obj.Hour13 = (System.Int32)reader["Hour13"]; obj.Hour14 = (System.Int32)reader["Hour14"]; obj.Hour15 = (System.Int32)reader["Hour15"]; obj.Hour16 = (System.Int32)reader["Hour16"]; obj.Hour17 = (System.Int32)reader["Hour17"]; obj.Hour18 = (System.Int32)reader["Hour18"]; obj.Hour19 = (System.Int32)reader["Hour19"]; obj.Hour20 = (System.Int32)reader["Hour20"]; obj.Hour21 = (System.Int32)reader["Hour21"]; obj.Hour22 = (System.Int32)reader["Hour22"]; obj.Hour23 = (System.Int32)reader["Hour23"]; obj.UpdateTime = (System.DateTime)reader["UpdateTime"]; return(obj); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2016/6/7 12:10:43</remarks> public bool Update(StatisticDetailEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/6/7 12:10:43</remarks> public bool Insert(StatisticDetailEntity entity) { return(Insert(entity, null)); }
public static bool Update(StatisticDetailEntity statisticDetailEntity, DbTransaction trans = null) { var provider = new StatisticDetailProvider(); return(provider.Update(statisticDetailEntity, trans)); }