/// <summary>
/// 从数据库彻底删除指定数据
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="idColName">ID列名</param>
/// <param name="vales">ID列值</param>
/// <returns></returns>
public static int RealyDelete(string tableName, string idColName, int[] vales)
{
int length = vales.Length;
if (length == 0)
{
return(0);
}
string sql = string.Format("delete from {0} where {1} in ({2}", tableName, idColName,
vales[0]);
for (int i = 1; i < length; i++)
{
sql += string.Format(",{0}", vales[i]);
}
sql += ")";
return(SQLiteControl.ExecuteNonQuery(sql));
}
/// <summary>
/// 按指定的表名去恢复指定Id列里IsDelete的值
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="idColName">ID列名</param>
/// <param name="deleteColName">Delete列名</param>
/// <param name="vales">ID列值</param>
/// <returns></returns>
public static int Restore(string tableName, string idColName, string deleteColName, int[] vales)
{
int length = vales.Length;
if (length == 0)
{
return(0);
}
string sql = string.Format("update {0} set {1} = 0 where {2} in ({3}", tableName, deleteColName, idColName,
vales[0]);
for (int i = 1; i < length; i++)
{
sql += string.Format(",{0}", vales[i]);
}
sql += ")";
return(SQLiteControl.ExecuteNonQuery(sql));
}