public int GetCount(FlagUpdHandle flagUpdHandle)
{
DBHelper dbHelper = new DBHelper(ConnectionString, DbProviderType.SqlServer);
string strSql = string.Format("select count(*) from {0} where {1}={2}", flagUpdHandle.TableName, flagUpdHandle.Key, flagUpdHandle.Value);
return((int)dbHelper.ExecuteScalar(strSql, null));
}
public bool Update(FlagUpdHandle flagUpdHandle)
{
DBHelper dbHelper = new DBHelper(ConnectionString, DbProviderType.SqlServer);
string strSql = string.Format("update {0} set {1}={2} where Id=@Id", flagUpdHandle.TableName, flagUpdHandle.Key, flagUpdHandle.Value);
List <DbParameter> parametersList = new List <DbParameter>();
parametersList.Add(new SqlParameter("@Id", flagUpdHandle.Id));
return(dbHelper.ExecuteNonQuery(strSql, parametersList) > 0);
}
