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