本文整理汇总了C#中Community.CsharpSqlite.SQLiteClient.SqliteCommand.ToString方法的典型用法代码示例。如果您正苦于以下问题:C# SqliteCommand.ToString方法的具体用法?C# SqliteCommand.ToString怎么用?C# SqliteCommand.ToString使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Community.CsharpSqlite.SQLiteClient.SqliteCommand
的用法示例。
在下文中一共展示了SqliteCommand.ToString方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: updateRecord
public bool updateRecord()
{
Type ja = this.GetType();
string tmp = "UPDATE " + ja.Name + " SET ";
System.Reflection.FieldInfo[] fieldInfo = ja.GetFields();
bool was = false;
foreach (System.Reflection.FieldInfo info in fieldInfo)
{
if (info.IsDefined(typeof(PrimaryKey), true)) continue;
if (was) tmp += ",";
tmp += info.Name+"[email protected]"+info.Name;
was = true;
}
tmp+=" WHERE ";
string where = "";
foreach (System.Reflection.FieldInfo info in fieldInfo)
{
if (info.IsDefined(typeof(PrimaryKey), true))
{
if (where.Length != 0) where += " AND ";
where += "("+info.Name+" = @"+info.Name+")";
}
}
tmp += where;
SqliteCommand sql = new SqliteCommand(tmp, SqliteManager.connection);
foreach (System.Reflection.FieldInfo info in fieldInfo)
{
object temp = info.GetValue(this);
if (temp is long)
{
sql.Parameters.Add(new SqliteParameter("@"+info.Name, temp));
}
else
if (temp is string)
{
sql.Parameters.Add(new SqliteParameter("@" + info.Name, temp));
}
else
if (temp is double)
{
sql.Parameters.Add(new SqliteParameter("@" + info.Name, temp));
}
else
if (temp is bool)
{
if ((Boolean)temp)
sql.Parameters.Add(new SqliteParameter("@" + info.Name, "1"));
else
sql.Parameters.Add(new SqliteParameter("@" + info.Name, "0"));
}
else
{
sql.Parameters.Add(new SqliteParameter("@" + info.Name, temp.ToString()));
}
}
try
{
return sql.ExecuteNonQuery() != 0;
}
catch (Exception e)
{
MessageBox.Show("Error durring row update.\n" + sql.ToString() + "\n"+tmp+"\n" + e.ToString());
return false;
}
}
示例2: insertRecord
public bool insertRecord()
{
Type ja = this.GetType();
string tmp = "INSERT INTO " + ja.Name + "(";
System.Reflection.FieldInfo[] fieldInfo = ja.GetFields();
bool was = false;
foreach (System.Reflection.FieldInfo info in fieldInfo)
{
if (was) tmp += ",";
tmp += info.Name;
was = true;
}
tmp += ") VALUES (";
was = false;
foreach (System.Reflection.FieldInfo info in fieldInfo)
{
if (was) tmp += ",";
tmp += "@" + info.Name;
was = true;
}
tmp += ");";
SqliteCommand sql = new SqliteCommand(tmp, SqliteManager.connection);
foreach (System.Reflection.FieldInfo info in fieldInfo)
{
object temp = info.GetValue(this);
if (temp is long)
{
sql.Parameters.Add(new SqliteParameter("@"+info.Name, temp));
}
else
if (temp is string)
{
sql.Parameters.Add(new SqliteParameter("@" + info.Name, temp));
}
else
if (temp is double)
{
sql.Parameters.Add(new SqliteParameter("@" + info.Name, temp));
}
else
if (temp is bool)
{
if ((Boolean)temp)
sql.Parameters.Add(new SqliteParameter("@" + info.Name, "1"));
else
sql.Parameters.Add(new SqliteParameter("@" + info.Name, "0"));
}
else
{
sql.Parameters.Add(new SqliteParameter("@" + info.Name, temp.ToString()));
}
}
try
{
return sql.ExecuteNonQuery() != 0;
}
catch (Exception e)
{
MessageBox.Show("Error durring row insert.\n" + sql.ToString() + "\n" + e.ToString());
return false;
}
}