public WordDomain FindById(Guid id)
{
var query = $"select * from {this.TableName} where Flag = '{id.ToString()}' ";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
return(this.ConvertDataSetToWordList(dataSet).FirstOrDefault());
}
public List <WordDomain> FindByFlag(int flag)
{
var query = $"select * from {this.TableName} where Flag = {flag} ";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
return(this.ConvertDataSetToWordList(dataSet));
}
public WordDomain GetReadedOne()
{
var query = $"select * from {this.TableName} where Flag = 1 ORDER BY CreateTime DESC LIMIT 1";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
return(this.ConvertDataSetToWordList(dataSet).FirstOrDefault());
}
public WordDomain GetOne()
{
var query = $"select * from {this.TableName} where Flag = 0 limit 1";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
return(this.ConvertDataSetToWordList(dataSet).FirstOrDefault());
}
public List <WordDomain> GetWordListByCount(int count)
{
var query = $"select * from {this.TableName} where Flag = 0 limit {count}";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
return(this.ConvertDataSetToWordList(dataSet));
}
public WordDomain GetReverseOneExcludeId(Guid Id)
{
try
{
var newId = Id.ToString();
var query = $"select * from {this.TableName} where Flag = 0 and Id != '{newId}' ORDER BY CreateTime desc limit 1";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
return(this.ConvertDataSetToWordList(dataSet).FirstOrDefault());
}
catch (Exception)
{
return(null);
}
}
public bool InsertOneWithVoice(WordDomain word)
{
try
{
var query = "insert into ";
query += query + this.TableName;
query += query + " (Id, Word, Trascation, Phonetic, Flag, CreateTime, Voice) ";
query += query + "values (@Id, @Word,@Trascation,@Phonetic,@Flag,@CreateTime,@Voice)";
var paramArray = this.ConvertParamsToArrayWithVoice(word);
var dataSet = SqliteRepository.ExecuteDataSet(query, paramArray);
}
catch (Exception)
{
return(false);
}
return(true);
}
public void UpdateVoiceById(Guid id, string voiceStr, string ph)
{
if (!string.IsNullOrEmpty(ph))
{
ph.Replace("'", "''");
}
try
{
var query = $"update {this.TableName} set Voice = '{voiceStr}', Phonetic = '{ph}' where Id = '{id.ToString()}' ";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
}
catch (Exception)
{
var query = $"update {this.TableName} set Voice = '{voiceStr}' where Id = '{id.ToString()}' ";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
}
}
public void ResetFlag()
{
var query = $"update {this.TableName} set Flag = 0 where Flag = 2 ";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
}
public void UpdateFlagById(Guid id, int flag)
{
var query = $"update {this.TableName} set Flag = {flag}, CreateTime = {DateTime.Now.Ticks} where Id = '{id.ToString()}' ";
var dataSet = SqliteRepository.ExecuteDataSet(query, null);
}
