namespace Yw.DAL.PostgreSql
|
{
|
/// <summary>
|
/// 运行实时记录
|
/// </summary>
|
public class RunRealRecord : IRunRealRecord
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public ConnectionConfig ConnectionConfig
|
{
|
get { return ConfigHelper.PostgreSqlRecordConnectionConfig; }
|
}
|
|
#region 常规获取
|
|
/// <summary>
|
/// 获取最近几条列表
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLastList(DateTime? StartTime, DateTime? EndTime, int Number = 1, bool? Run = null)
|
{
|
if (StartTime.HasValue && EndTime.HasValue)
|
{
|
if (StartTime.Value > EndTime.Value)
|
{
|
return default;
|
}
|
}
|
if (Number < 1)
|
{
|
Number = 1;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.AndIF(StartTime.HasValue, x => x.DataTime >= StartTime.Value);
|
exp.AndIF(EndTime.HasValue, x => x.DataTime <= EndTime.Value);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Desc)
|
.Take(Number).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 获取某日的最近几条数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLastListByDay(DateTime Day, int Number = 1, bool? Run = null)
|
{
|
if (Number < 1)
|
{
|
Number = 1;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= Day.Date && x.DataTime < Day.AddDays(1).Date);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Desc)
|
.Take(Number).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 获取日期区间的最近几条数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLastListByDayRange(DateTime StartDay, DateTime EndDay, int Number = 1, bool? Run = null)
|
{
|
if (StartDay.Date > EndDay.Date)
|
{
|
return default;
|
}
|
if (Number < 1)
|
{
|
Number = 1;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= StartDay.Date && x.DataTime < EndDay.AddDays(1).Date);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Desc)
|
.Take(Number).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 获取时间区间的最近几条数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLastListByTimeRange(DateTime StartTime, DateTime EndTime, int Number = 1, bool? Run = null)
|
{
|
if (StartTime > EndTime)
|
{
|
return default;
|
}
|
if (Number < 1)
|
{
|
Number = 1;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= StartTime && x.DataTime <= EndTime);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Desc)
|
.Take(Number).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 获取
|
/// </summary>
|
public List<Entity.RunRealRecord> Get(DateTime? StartTime, DateTime? EndTime, bool? Run = null)
|
{
|
if (StartTime.HasValue && EndTime.HasValue)
|
{
|
if (StartTime.Value > EndTime.Value)
|
{
|
return default;
|
}
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.AndIF(StartTime.HasValue, x => x.DataTime >= StartTime.Value);
|
exp.AndIF(EndTime.HasValue, x => x.DataTime <= EndTime.Value);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 获取某日的数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetByDay(DateTime Day, bool? Run = null)
|
{
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= Day.Date && x.DataTime < Day.AddDays(1).Date);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 获取日期区间内的数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetByDayRange(DateTime StartDay, DateTime EndDay, bool? Run = null)
|
{
|
if (StartDay.Date > EndDay.Date)
|
{
|
return default;
|
}
|
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= StartDay.Date && x.DataTime < EndDay.AddDays(1).Date);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 获取时间区间的数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetByTimeRange(DateTime StartTime, DateTime EndTime, bool? Run = null)
|
{
|
if (StartTime > EndTime)
|
{
|
return default;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= StartTime && x.DataTime <= EndTime);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 获取分页列表
|
/// </summary>
|
public List<Entity.RunRealRecord> GetPageList(DateTime? StartTime, DateTime? EndTime, bool? Run, int PageIndex, int PageSize, ref int Total)
|
{
|
if (StartTime.HasValue && EndTime.HasValue)
|
{
|
if (StartTime.Value > EndTime.Value)
|
{
|
return default;
|
}
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.AndIF(StartTime.HasValue, x => x.DataTime >= StartTime.Value);
|
exp.AndIF(EndTime.HasValue, x => x.DataTime <= EndTime.Value);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Desc)
|
.ToPageList(PageIndex, PageSize, ref Total);
|
}
|
}
|
|
#endregion
|
|
#region 通过 ObjectType 和 ObjectID 获取
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取最近几条记录
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLastListByObjectTypeAndObjectID(string ObjectType, long ObjectID, int Number = 1, bool? Run = null)
|
{
|
if (Number < 1)
|
{
|
Number = 1;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Desc)
|
.Take(Number).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取
|
/// </summary>
|
public List<Entity.RunRealRecord> GetByObjectTypeAndObjectID(string ObjectType, long ObjectID, DateTime? StartTime, DateTime? EndTime, bool? Run = null)
|
{
|
if (StartTime.HasValue && EndTime.HasValue)
|
{
|
if (StartTime.Value > EndTime.Value)
|
{
|
return default;
|
}
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.AndIF(StartTime.HasValue, x => x.DataTime >= StartTime.Value);
|
exp.AndIF(EndTime.HasValue, x => x.DataTime <= EndTime.Value);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取 (限制数量)
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLimitByObjectTypeAndObjectID(string ObjectType, long ObjectID, DateTime? StartTime, DateTime? EndTime, int Limit, bool? Run = null)
|
{
|
if (StartTime.HasValue && EndTime.HasValue)
|
{
|
if (StartTime.Value > EndTime.Value)
|
{
|
return default;
|
}
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.AndIF(StartTime.HasValue, x => x.DataTime >= StartTime.Value);
|
exp.AndIF(EndTime.HasValue, x => x.DataTime <= EndTime.Value);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
var list = db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
return list?.ToLimitList(Limit);
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取某日的数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetByObjectTypeAndObjectIDOfDay(string ObjectType, long ObjectID, DateTime Day, bool? Run = null)
|
{
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= Day.Date && x.DataTime < Day.AddDays(1).Date);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取某日的数据 (限制数量)
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLimitByObjectTypeAndObjectIDOfDay(string ObjectType, long ObjectID, DateTime Day, int Limit, bool? Run = null)
|
{
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= Day.Date && x.DataTime < Day.AddDays(1).Date);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
var list = db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
return list?.ToLimitList(Limit);
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取日期区间内的数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetByObjectTypeAndObjectIDOfDayRange(string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay, bool? Run = null)
|
{
|
if (StartDay.Date > EndDay.Date)
|
{
|
return default;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= StartDay.Date && x.DataTime < EndDay.AddDays(1).Date);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取日期区间内的数据 (限制数量)
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLimitByObjectTypeAndObjectIDOfDayRange(string ObjectType, long ObjectID, DateTime StartDay, DateTime EndDay, int Limit, bool? Run = null)
|
{
|
if (StartDay.Date > EndDay.Date)
|
{
|
return default;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= StartDay.Date && x.DataTime < EndDay.AddDays(1).Date);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
var list = db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
return list?.ToLimitList(Limit);
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取时间区间内的数据
|
/// </summary>
|
public List<Entity.RunRealRecord> GetByObjectTypeAndObjectIDOfTimeRange(string ObjectType, long ObjectID, DateTime StartTime, DateTime EndTime, bool? Run = null)
|
{
|
if (StartTime > EndTime)
|
{
|
return default;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= StartTime && x.DataTime <= EndTime);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取时间区间内的数据 (限制数量)
|
/// </summary>
|
public List<Entity.RunRealRecord> GetLimitByObjectTypeAndObjectIDOfTimeRange(string ObjectType, long ObjectID, DateTime StartTime, DateTime EndTime, int Limit, bool? Run = null)
|
{
|
if (StartTime > EndTime)
|
{
|
return default;
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.And(x => x.DataTime >= StartTime && x.DataTime <= EndTime);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
var list = db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Asc)
|
.ToList();
|
return list?.ToLimitList(Limit);
|
}
|
}
|
|
/// <summary>
|
/// 通过 ObjectType 和 ObjectID 获取分页列表
|
/// </summary>
|
public List<Entity.RunRealRecord> GetPageListByObjectTypeAndObjectID(string ObjectType, long ObjectID, DateTime? StartTime, DateTime? EndTime, bool? Run, int PageIndex, int PageSize, ref int Total)
|
{
|
if (StartTime.HasValue && EndTime.HasValue)
|
{
|
if (StartTime.Value > EndTime.Value)
|
{
|
return default;
|
}
|
}
|
var exp = Expressionable.Create<Entity.RunRealRecord>();
|
exp.AndIF(StartTime.HasValue, x => x.DataTime >= StartTime.Value);
|
exp.AndIF(EndTime.HasValue, x => x.DataTime <= EndTime.Value);
|
exp.And(x => x.ObjectType == ObjectType);
|
exp.And(x => x.ObjectID == ObjectID);
|
exp.AndIF(Run.HasValue && Run.Value, x => x.RSa == RunStatus.Run);
|
exp.AndIF(Run.HasValue && !Run.Value, x => x.RSa == RunStatus.Shut);
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RunRealRecord>()
|
.Where(exp.ToExpression())
|
.OrderBy(x => x.DataTime, OrderByType.Desc)
|
.ToPageList(PageIndex, PageSize, ref Total);
|
}
|
}
|
|
|
#endregion
|
|
#region InsertOrUpdate
|
|
/// <summary>
|
/// 插入
|
/// </summary>
|
public bool InsertOrUpdate(Entity.RunRealRecord entity)
|
{
|
if (entity == null)
|
return false;
|
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
var sql = CreateSql();
|
var paras = CreateParameters(entity);
|
return db.Ado.ExecuteCommand(sql, paras) > 0;
|
}
|
}
|
|
/// <summary>
|
/// 批量插入
|
/// </summary>
|
public bool InsertOrUpdate(List<Entity.RunRealRecord> list)
|
{
|
if (list == null || list.Count < 1)
|
return false;
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
try
|
{
|
db.Ado.BeginTran();
|
var sql = CreateSql();
|
foreach (var item in list)
|
{
|
var paras = CreateParameters(item);
|
var bol = db.Ado.ExecuteCommand(sql, paras) > 0;
|
if (!bol)
|
{
|
db.Ado.RollbackTran();
|
return false;
|
}
|
}
|
db.Ado.CommitTran();
|
return true;
|
}
|
catch
|
{
|
db.Ado.RollbackTran();
|
throw;
|
}
|
}
|
}
|
|
//创建sql
|
private string CreateSql()
|
{
|
var sb = new StringBuilder();
|
sb.AppendLine("INSERT INTO run_real_record");
|
sb.AppendLine($" VALUES(@objecttype,@objectid,@datatime,@rsa,@continuetime,@totalshuttime,@totalruntime,@boottimes,@analystatus,@analyinfo)");
|
sb.AppendLine("ON CONFLICT(objecttype, objectid, datatime) DO UPDATE");
|
sb.AppendLine("SET rsa = excluded.rsa,");
|
sb.AppendLine("continuetime = excluded.continuetime,");
|
sb.AppendLine("totalshuttime = excluded.totalshuttime,");
|
sb.AppendLine("totalruntime = excluded.totalruntime,");
|
sb.AppendLine("boottimes = excluded.boottimes,");
|
sb.AppendLine("analystatus = excluded.analystatus,");
|
sb.AppendLine("analyinfo = excluded.analyinfo;");
|
return sb.ToString();
|
}
|
|
//创建参数
|
private List<SugarParameter> CreateParameters(Entity.RunRealRecord entity)
|
{
|
var list = new List<SugarParameter>
|
{
|
new SugarParameter("@objecttype", entity.ObjectType),
|
new SugarParameter("@objectid", entity.ObjectID),
|
new SugarParameter("@datatime", entity.DataTime),
|
new SugarParameter("@rsa", entity.RSa),
|
new SugarParameter("@continuetime", entity.ContinueTime),
|
new SugarParameter("@totalshuttime", entity.TotalShutTime),
|
new SugarParameter("@totalruntime", entity.TotalRunTime),
|
new SugarParameter("@boottimes", entity.BootTimes),
|
new SugarParameter("@analystatus", entity.AnalyStatus),
|
new SugarParameter("@analyinfo", entity.AnalyInfo)
|
};
|
return list;
|
}
|
|
#endregion
|
|
|
|
|
}
|
}
|
