/// <summary>
/// Creates new record.
/// </summary>
/// <param name="entity">
/// The entity.
/// </param>
public void Create(RecordEntity entity)
{
var recordId = this.dbService.Create(entity);
entity.Name += '`' + recordId.ToString();
this.CreateInCloudAsync(entity.ToCloudRecordModel(), recordId);
}
protected void Button1_Click(object sender, EventArgs e)
{
RecordEntity recordEntity = new RecordEntity();
RecordBll recordBll = new RecordBll();
recordEntity.PpID = Convert.ToInt32(Label1.Text);
recordEntity.PresentDate = DateTime.Now;
if (this.txtDes.Value != null && this.txtDes.Value != "")
{
recordEntity.Des = this.txtDes.Value;
}
else
{
recordEntity.Des = "";
}
if (recordBll.AddRewardProblem(recordEntity))
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('会议记录添加成功');</script>");
this.txtDes.Value = "";
base.Response.Redirect("ProjectInternetion.aspx");
return;
}
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('会议记录添加失败');</script>");
}
public static RecordModel ToModel(this RecordEntity entity) =>
new RecordModel
{
Id = entity.Id,
TaskId = entity.TaskId,
StartAt = entity.StartAt,
StopAt = entity.StopAt
};
public async Task <TData <string> > SaveForm(RecordEntity entity)
{
TData <string> obj = new TData <string>();
await recordService.SaveForm(entity);
obj.Result = entity.Id.ParseToString();
obj.Tag = 1;
return(obj);
}
/// <summary>
/// The mapper to dal record.
/// </summary>
/// <param name="recordEntity">
/// The record entity.
/// </param>
/// <returns>
/// The <see cref="DalRecord"/>.
/// </returns>
public static DalRecord ToDalRecord(this RecordEntity recordEntity)
{
return(new DalRecord()
{
Id = recordEntity.Id,
IsCompleted = recordEntity.IsCompleted,
Name = recordEntity.Name,
UserId = recordEntity.UserId
});
}
protected override Tuple <DomainEntity, RecordEntity> CreateRecordEntity(DbDataReader reader)
{
DomainEntity domain = new DomainEntity(reader.GetInt32("domain_id"), reader.GetString("domain_name"));
int?recordId = reader.GetInt32Nullable("id");
RecordEntity createRecord = recordId.HasValue ? CreateRecordEntity(reader, recordId, domain) : null;
return(Tuple.Create(domain, createRecord));
}
/// <summary>
/// Updates record entity.
/// </summary>
/// <param name="recordEntity">
/// The record entity.
/// </param>
public void Update(RecordEntity recordEntity)
{
int?cloudId = this.dbService.Update(recordEntity);
if (cloudId != null)
{
recordEntity.CloudId = cloudId.Value;
}
this.UpdateInCloudAsync(recordEntity.ToCloudRecordModel());
}
/// <summary>
/// The to client record model.
/// </summary>
/// <param name="recordEntity">
/// The record entity.
/// </param>
/// <returns>
/// The <see cref="CloudRecordModel"/>.
/// </returns>
public static CloudRecordModel ToClientRecordModel(this RecordEntity recordEntity)
{
return(new CloudRecordModel()
{
IsCompleted = recordEntity.IsCompleted,
Name = recordEntity.Name,
ToDoId = recordEntity.Id,
UserId = recordEntity.UserId
});
}
protected override void AddCommandParmeters(MySqlCommand command, RecordEntity record, int index)
{
DmarcRecordInfo recordInfo = record.RecordInfo as DmarcRecordInfo;
command.Parameters.AddWithValue($"a{index}", record.Id);
command.Parameters.AddWithValue($"b{index}", record.Domain.Id);
command.Parameters.AddWithValue($"c{index}", recordInfo?.Record);
command.Parameters.AddWithValue($"d{index}", record.EndDate);
command.Parameters.AddWithValue($"e{index}", record.FailureCount);
command.Parameters.AddWithValue($"f{index}", (ushort)record.ResponseCode);
}
public async Task SaveForm(RecordEntity entity)
{
if (entity.Id.IsNullOrZero())
{
entity.Create();
await this.BaseRepository().Insert(entity);
}
else
{
await this.BaseRepository().Update(entity);
}
}
private async Task <List <RecordEntity> > UpdateRecord(DomainEntity domain, List <RecordEntity> records)
{
DnsResponse response = await _dnsRecordClient.GetRecord(domain.Name);
if (IsSuccess(response.ResponseCode))
{
//find old records
List <RecordEntity> oldRecords = records.Where(existingRecord => response.Records.All(responseRecord => !responseRecord.Equals(existingRecord.RecordInfo)))
.Select(_ => new RecordEntity(_.Id, _.Domain, _.RecordInfo, response.ResponseCode, _.FailureCount, DateTime.UtcNow))
.ToList();
//find unchanged records
List <RecordEntity> unchangedRecords = records.Where(existingRecord => response.Records.Any(responseRecord => responseRecord.Equals(existingRecord.RecordInfo))).ToList();
//find new records
List <RecordEntity> newRecords = response.Records.Where(responseRecords => records.All(exisingRecord => !exisingRecord.RecordInfo.Equals(responseRecords)))
.Select(_ => new RecordEntity(null, domain, _, response.ResponseCode, 0))
.ToList();
List <RecordEntity> updatedSuccessfulRecords = oldRecords
.Concat(unchangedRecords)
.Concat(newRecords)
.ToList();
//create placeholder if no records
if (updatedSuccessfulRecords.All(_ => _.EndDate != null))
{
updatedSuccessfulRecords.Add(new RecordEntity(null, domain, null, response.ResponseCode, 0));
}
return(updatedSuccessfulRecords);
}
//Once placeholder in play keep returning placeholder on failure
RecordEntity recordEntity = records.SingleOrDefault(_ => _.FailureCount == -1);
if (recordEntity != null)
{
return(records);
}
//less that 3 failures increment failure count
if (records.Any() && records.Max(_ => _.FailureCount) < 3)
{
return(records.Select(_ => new RecordEntity(_.Id, domain, _.RecordInfo, response.ResponseCode, _.FailureCount + 1)).ToList());
}
//otherwise expire records and add placeholder
return(records.Select(_ => new RecordEntity(_.Id, domain, _.RecordInfo, response.ResponseCode, _.FailureCount, DateTime.UtcNow)).
Concat(new List <RecordEntity> {
new RecordEntity(null, domain, null, response.ResponseCode, -1)
}).ToList());
}
/// <summary>
/// 添加战绩
/// </summary>
/// <param name="groupId"></param>
/// <param name="record"></param>
public void AddRecord(int groupId, RecordEntity record)
{
if (record == null)
{
return;
}
ChatGroupEntity group = GetGroup(groupId);
if (group == null)
{
return;
}
if (!group.isRequested)
{
return;
}
for (int i = 0; i < group.recordList.Count; ++i)
{
if (group.recordList[i].battleId == record.battleId)
{
RemoveRecord(groupId, record.battleId);
break;
}
}
group.recordList.Add(record);
TransferData data = new TransferData();
data.SetValue("GroupId", group.id);
data.SetValue("BattleId", record.battleId);
data.SetValue <int>("RoomId", record.roomId);
data.SetValue <string>("DateTime", record.time);
data.SetValue <string>("GameName", record.gameName);
List <TransferData> lstPlayer = new List <TransferData>();
for (int i = 0; i < record.players.Count; ++i)
{
RecordPlayerEntity playerEntity = record.players[i];
TransferData playerData = new TransferData();
playerData.SetValue("PlayerId", playerEntity.id);
playerData.SetValue("Avatar", playerEntity.avatar);
playerData.SetValue("Gold", playerEntity.gold);
playerData.SetValue("Nickname", playerEntity.nickname);
lstPlayer.Add(playerData);
}
data.SetValue <List <TransferData> >("Player", lstPlayer);
SendNotification(ON_ADD_RECORD, data);
}
public DataTable GetById(RecordEntity en)
{
DataBase db = new DataBase();
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@RecordID", SqlDbType.Int, 4)
};
param[0].Value = en.RecordID;
string sql = "select Record.* from Record where RecordID=@RecordID ";
return(db.GetDataTable(sql, param));
}
public async Task <ActionResult> SaveFormJsonStatus(RecordEntity entity)
{
TData <RecordEntity> obj = await recordBLL.GetEntity(Convert.ToInt64(entity.Id));
if (obj.Tag == 1)
{
obj.Result.Status = entity.Status;
TData <string> objsave = await recordBLL.SaveForm(entity);
return(Json(objsave));
}
return(Json(obj));
}
public void bind(int RecordID)
{
RecordEntity recordEntity = new RecordEntity();
RecordBll recordBll = new RecordBll();
recordEntity.RecordID = RecordID;
DataTable byId = recordBll.GetById(recordEntity);
if (byId.Rows.Count >= 1)
{
this.TextBox1.Text = byId.Rows[0]["PresentDate"].ToString();
this.txtDes.Value = byId.Rows[0]["Des"].ToString();
}
}
public void Asp(GridView gv, AspNetPager pager, RecordEntity en)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@PPID", SqlDbType.Int)
};
p[0].Value = en.PpID;
string sql = "with AllRecord as( select RecordID,PPIDD,PresentDate,Des,ProjectPaper.Name,Row_Number() over(order by RecordID) as row_number from Record,ProjectPaper where PPIDD=@PPID and PPID=PPIDD ) select * from AllRecord where row_number>{0} and row_number<={1}";
string sql2 = "select count (*) from Record where PPIDD=@PPID";
sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(sql2, p));
gv.DataSource = this.db.GetDataTable(sql, p);
gv.DataBind();
}
public bool Update(RecordEntity en)
{
string sql = "update Record set Des=@Des,PresentDate=@PresentDate where RecordID=@RecordID";
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@RecordID", SqlDbType.Int);
para[0].Value = en.RecordID;
para[1] = new SqlParameter("@PresentDate", SqlDbType.DateTime);
para[1].Value = en.PresentDate;
para[2] = new SqlParameter("@Des", SqlDbType.VarChar, 1000);
para[2].Value = en.Des;
return(this.db.ExecuteSql(sql, para) == 1);
}
public bool UpdateRecord(RecordEntity recordEntity)
{
if (recordEntities != null)
{
RecordEntity existingRecordEntity = recordEntities.Find(p => p.ID.Equals(recordEntity.ID));
if (existingRecordEntity != null)
{
existingRecordEntity.LastName = recordEntity.LastName;
existingRecordEntity.FirstName = recordEntity.FirstName;
existingRecordEntity.Gender = recordEntity.Gender;
existingRecordEntity.FavoriteColor = recordEntity.FavoriteColor;
existingRecordEntity.DateOfBirth = recordEntity.DateOfBirth;
}
}
return(true);
}
protected void Button1_Click(object sender, EventArgs e)
{
RecordEntity recordEntity = new RecordEntity();
RecordBll recordBll = new RecordBll();
recordEntity.RecordID = Convert.ToInt32(base.Request.QueryString["RecordID"]);
recordEntity.PresentDate = DateTime.Parse(TextBox1.Text);
recordEntity.Des = this.txtDes.Value;
if (recordBll.Update(recordEntity))
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('修改成功')</script>");
}
else
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "alert", "<script>alert('修改失败')</script>");
}
base.Response.Redirect("UserRecordManage.aspx?");
}
private void BindView2()
{
RecordEntity userIntegralDetailEntity = new RecordEntity();
RecordBll userIntegralDetailBll = new RecordBll();
userIntegralDetailEntity.PpID = Convert.ToInt32(this.ViewState["id"]);
userIntegralDetailBll.Asp(this.GridView2, this.AspNetPager2, userIntegralDetailEntity);
ProjectPaperEntity userEntity = new ProjectPaperEntity();
ProjectPaperBll userBll = new ProjectPaperBll();
userEntity.PPID = Convert.ToInt32(this.ViewState["id"]);
DataTable byID = userBll.GetById(userEntity);
if (byID != null && byID.Rows.Count == 1)
{
this.Label1.Text = byID.Rows[0]["Name"].ToString();
}
}
public static RecordModel ToModel(RecordEntity recordEntity)
{
if (recordEntity == null)
{
return(null);
}
return(new RecordModel
{
Style = StyleMapper.ToModel(recordEntity.Style),
Name = recordEntity.Name,
Description = recordEntity.Description,
Id = recordEntity.Id,
Country = recordEntity.Country,
Format = recordEntity.Format,
Genre = GenreMapper.ToModel(recordEntity.Genre),
Label = recordEntity.Label,
RecordLength = recordEntity.RecordLength,
ReleaseDate = recordEntity.ReleaseDate
});
}
public bool InsertRecord(RecordEntity recordEntity)
{
RecordEntity existingRecordEntity = recordEntities.Find(p => p.ID.Equals(recordEntity.ID));
if (existingRecordEntity != null)
{
UpdateRecord(recordEntity);
}
else
{
recordEntities.Add(new RecordEntity()
{
ID = 1,
LastName = recordEntity.LastName,
FirstName = recordEntity.FirstName,
Gender = recordEntity.Gender,
FavoriteColor = recordEntity.FavoriteColor,
DateOfBirth = recordEntity.DateOfBirth
});
}
return(true);
}
public bool AddRecordProblem(RecordEntity en)
{
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@PPID", SqlDbType.Int);
p[0].Value = en.PpID;
p[1] = new SqlParameter("@PresentDate", SqlDbType.DateTime);
p[1].Value = en.PresentDate;
p[2] = new SqlParameter("@Des", SqlDbType.VarChar, 1000);
if (en.Des != null)
{
p[2].Value = en.Des;
}
else
{
p[2].Value = "";
}
string sql = "insert into Record (PPIDD,PresentDate,Des) values(@PPID,@PresentDate,@Des)";
return(this.db.ExecuteSql(sql, p) > 0);
}
public void Delete(RecordEntity record)
{
_context.Record.Remove(record);
}
public void Update(RecordEntity record)
{
_context.Entry(record).State = EntityState.Modified;
_context.Record.Update(record);
}
public void Create(RecordEntity record)
{
_context.Record.Add(record);
}
static void Main(string[] args)
{
try
{
System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
watch.Start();//开始计时
DataTable dtz = MySQLHelper.Query("SELECT * from zones where id=3118661").Tables[0];
DataTable dta = MySQLHelper.Query("SELECT * from authorities where zoneid=3118661").Tables[0];
DataTable dtd = MySQLHelper.Query("SELECT * from dnsrecords where zoneid=3118661").Tables[0];
List <Zones> zonesList = DtToList <Zones> .ConvertToModel(dtz);
Zones zone = zonesList[0];
ZonesEntity ze = new ZonesEntity();
ze.id = Utility.StringHelper.CalculateMD5Hash(zone.Zone + ".").ToLower();
ze.userid = Convert.ToInt32(zone.UserID);
ze.domain = zone.Zone;
ze.level = zone.DomainLevel > 0 ? 1 : 0;
ze.nsstate = zone.NSState;
ze.is_stop = zone.Active == "Y" ? "N" : "Y";
ze.force_stop = zone.ForceStop;
ze.rdomain = zone.RZone;
List <AuthEntity> alist = new List <AuthEntity>();
foreach (DataRow dr in dta.Rows)
{
AuthEntity ae = new AuthEntity();
ae.rid = Convert.ToInt32(dr["id"]);
ae.domain = ze.domain;
ae.name = dr["host"].ToString();
ae.type = dr["type"].ToString();
if (ae.type == "SOA")
{
//Mbox,Serial,Refresh,Retry,Expire,Minimum
ae.rdata = dr["data"].ToString() + " " + dr["mbox"].ToString() + " " + dr["serial"].ToString() + " " + dr["refresh"].ToString() + " " + dr["retry"].ToString() + " " + dr["expire"].ToString() + " " + dr["minimum"].ToString();
}
else
{
ae.rdata = dr["data"].ToString();
}
ae.ttl = Convert.ToInt32(dr["ttl"]);
ae.view = "Def";
ae.view = "Y";
alist.Add(ae);
}
List <RecordEntity> rlist = new List <RecordEntity>();
foreach (DataRow dr in dtd.Rows)
{
RecordEntity re = new RecordEntity();
re.rid = Convert.ToInt32(dr["id"]);
re.domain = ze.domain;
re.name = dr["host"].ToString();
re.type = dr["type"].ToString();
if (re.type == "MX")
{
//Mbox,Serial,Refresh,Retry,Expire,Minimum
re.rdata = dr["mx_priority"].ToString() + " " + dr["data"].ToString();
}
else if (re.type == "TXT")
{
re.rdata = dr["data"].ToString().Replace("\"", string.Empty);
}
else
{
re.rdata = dr["data"].ToString();
}
re.ttl = Convert.ToInt32(dr["ttl"]);
re.view = dr["view"].ToString();
re.view = dr["active"].ToString() == "Y" ? "N" : "Y";
rlist.Add(re);
}
ze.authorities = alist;
ze.records = rlist;
var client = DriverConfiguration.Client;
var db = client.GetDatabase(DriverConfiguration.DatabaseNamespace.DatabaseName);
IMongoCollection <ZonesEntity> categories = db.GetCollection <ZonesEntity>("ZonesEntiy");
categories.InsertOne(ze);
Console.WriteLine("MongoDB Inserted; Use time={0};", watch.ElapsedMilliseconds);
watch.Stop();//停止计时
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected abstract void AddCommandParmeters(MySqlCommand command, RecordEntity record, int index);
protected override void Seed(DataContext context)
{
// Records
var record1 = new RecordEntity()
{
Id = 1,
VariableId = 1,
Value = "566",
ArchiveTime = DateTime.Now
};
var record2 = new RecordEntity()
{
Id = 2,
VariableId = 2,
Value = "20",
ArchiveTime = DateTime.Now
};
var record3 = new RecordEntity()
{
Id = 3,
VariableId = 3,
Value = "1500",
ArchiveTime = DateTime.Now
};
var record4 = new RecordEntity()
{
Id = 4,
VariableId = 1,
Value = "576",
ArchiveTime = DateTime.Now + TimeSpan.FromSeconds(30)
};
var record5 = new RecordEntity()
{
Id = 5,
VariableId = 2,
Value = "26",
ArchiveTime = DateTime.Now + TimeSpan.FromSeconds(30)
};
var record6 = new RecordEntity()
{
Id = 6,
VariableId = 3,
Value = "1566",
ArchiveTime = DateTime.Now + TimeSpan.FromSeconds(30)
};
var record7 = new RecordEntity()
{
Id = 7,
VariableId = 1,
Value = "586",
ArchiveTime = DateTime.Now + TimeSpan.FromSeconds(60)
};
var record8 = new RecordEntity()
{
Id = 8,
VariableId = 2,
Value = "33",
ArchiveTime = DateTime.Now + TimeSpan.FromSeconds(60)
};
var record9 = new RecordEntity()
{
Id = 9,
VariableId = 3,
Value = "1570",
ArchiveTime = DateTime.Now + TimeSpan.FromSeconds(60)
};
context.Records.AddOrUpdate(x => x.Id, record1, record2, record3, record4, record5, record6, record7, record8, record9);
// Variables
var var1 = new VariableEntity()
{
Id = 1,
ProjectId = new Guid("db93cbda-e293-41db-ad54-bee5a4c254a3"),
Name = "ns=2;s=Demo.Dynamic.Scalar.Int16",
Archive = ArchiveInterval.ThirtySecond,
DataType = BuiltInType.Int16,
};
var var2 = new VariableEntity()
{
Id = 2,
ProjectId = new Guid("db93cbda-e293-41db-ad54-bee5a4c254a3"),
Name = "ns=2;s=Demo.Dynamic.Scalar.SByte",
Archive = ArchiveInterval.ThirtySecond,
DataType = BuiltInType.SByte,
};
var var3 = new VariableEntity()
{
Id = 3,
ProjectId = new Guid("db93cbda-e293-41db-ad54-bee5a4c254a3"),
Name = "ns=2;s=Demo.Dynamic.Scalar.UInt64",
Archive = ArchiveInterval.ThirtySecond,
DataType = BuiltInType.UInt64,
};
context.Variables.AddOrUpdate(x => x.Id, var1, var2, var3);
var endpoint = new EndpointEntity()
{
Id = 1,
Url = "opc.tcp://A05-226b:48010",
MessageSecurityMode = MessageSecurityMode.None,
SecurityPolicyUri = SecurityPolicies.None,
TransportProfileUri = Profiles.UaTcpTransport
};
context.Endpoints.AddOrUpdate(x => x.Id, endpoint);
var project = new ProjectEntity()
{
Id = new Guid("db93cbda-e293-41db-ad54-bee5a4c254a3"),
Name = "TestProject",
EndpointId = 1,
UserId = null,
SessionName = "TestProjectSession"
};
context.Projects.AddOrUpdate(x => x.Id, project);
context.SaveChanges();
}
public RecordViewModel(RecordEntity entity)
{
this.entity = entity;
}
public static iQueryBuilder Set(this iQueryBuilder pQuery, RecordEntity pEntity)
{
return pQuery.Set(pEntity._Record);
}
