/// <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); }