public int InsertDictionary(Class_Dictionary class_Dictionary)
{
string Sql = string.Format(@"Insert into inf_dictionary (id, signName
, contentName, defaultSelect
, sortNo, stopSign, remark )
values('{0}','{1}','{2}',{3}
,{4},{5},'{6}')"
, class_Dictionary.id
, class_Dictionary.signName
, class_Dictionary.contentName
, class_Dictionary.defaultSelect ? "1" : "0"
, class_Dictionary.sortNo
, class_Dictionary.stopSign ? "1" : "0"
, class_Dictionary.remark
);
return(mySqlite3.ExecuteSql(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);
}
}
