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