internal override long Insert() { var sql = new SqlBuilder(); sql.AppendSql($"INSERT INTO {TableName}") .AppendSql("(") .AppendSql($" {Cols.Name}") .AppendSql($",{Cols.Priority}") .AppendSql($",{Cols.Visible}") .AppendSql($",{Cols.CreateAt}") .AppendSql($",{Cols.UpdateAt}") .AppendSql(")") .AppendSql("VALUES") .AppendSql("(") .AppendSql($" @{Cols.Name}") .AppendSql($",@{Cols.Priority}") .AppendSql($",@{Cols.Visible}") .AppendSql(",datetime('now', 'localtime')") .AppendSql(",datetime('now', 'localtime')") .AppendSql(")"); var paramList = new ParameterList(); paramList.Add($"@{Cols.Name}", this.Name); paramList.Add($"@{Cols.Priority}", this.Priority); paramList.Add($"@{Cols.Visible}", MyLogDatabase.Bool2Int(this.Visible)); return(base.Database.Insert(sql, paramList)); }
internal TemplateDetailEntity(MyLogDatabase database) : base(database) { }
internal TempLogEntity(MyLogDatabase database) : base(database) { }
internal LogDetailEntity(MyLogDatabase database) : base(database) { }
internal BaseEntity(MyLogDatabase database) { this.Database = database; }
/// <summary> /// パラメータを追加する /// </summary> /// <param name="key">キー(カラム名)</param> /// <param name="val">値</param> internal void AddParams(string key, bool val) { this.Params.Add($"@{key}", MyLogDatabase.Bool2Int(val)); }
internal CategoryEntity(MyLogDatabase database) : base(database) { }