private static ResWord GetSearchWord(IList<object> r) { var resfile = new ResFile {FileID = (int)r[1], FileName = (string)r[3], ModuleName = (string)r[4], ProjectName = (string)r[5]}; return new ResWord {Title = (string)r[0], ResFile = resfile, ValueFrom = (string)r[2]}; }
public static List<ResWord> GetListResWords(ResFile resFile, string to, string search) { using (var dbManager = new DbManager("tmresource")) { var sql = new SqlQuery("res_data") .Select("title", "fileid", "textValue", "description", "flag", "link") .InnerJoin("res_files", Exp.EqColumns("res_files.ID", "res_data.fileID")) .Where("moduleName", resFile.ModuleName) .Where("projectName", resFile.ProjectName) .Where("cultureTitle", to) .Where("flag != 4") .Where("resourceType", "text") .OrderBy("res_data.id", true); if (!String.IsNullOrEmpty(resFile.FileName)) sql.Where("resName", resFile.FileName); if (!String.IsNullOrEmpty(search)) sql.Where(Exp.Like("textvalue", search)); return dbManager.ExecuteList(sql).ConvertAll(r => GetWord(r)); } }