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