public List <string> GetCaseWhenNameList()
{
string Sql = @"SELECT id
FROM vou_caseWhenMain
ORDER BY id";
return(mySqlite3.ExecuteReadList(Sql));
}
public List <Class_Dictionary> GetAllDictionary(string SignName)
{
string Sql = "Select id, signName, contentName, defaultSelect, sortNo, stopSign, remark From inf_dictionary";
if (SignName != null)
{
Sql = string.Format(@"{1} Where signName='{0}'
And stopSign = '0'
Order by sortNo"
, SignName, Sql);
}
List <string> vs = new List <string>();
vs = mySqlite3.ExecuteReadList(Sql);
if (vs != null)
{
List <Class_Dictionary> class_Dictionaries = new List <Class_Dictionary>();
foreach (string row in vs)
{
string[] rowList = row.Split(';');
Class_Dictionary class_Dictionary = new Class_Dictionary();
class_Dictionary.id = rowList[0];
class_Dictionary.signName = rowList[1];
class_Dictionary.contentName = rowList[2];
class_Dictionary.defaultSelect = rowList[3] == "1" ? true : false;
class_Dictionary.sortNo = Convert.ToInt32(rowList[4]);
class_Dictionary.stopSign = rowList[5] == "1" ? true : false;
class_Dictionary.remark = rowList[6];
class_Dictionaries.Add(class_Dictionary);
}
return(class_Dictionaries);
}
else
{
return(null);
}
}